T005 - Countries
Countries information is stored in SAP table T005.
It is part of development package SZAD in software component BC-SRV-ADR. This development package consists of objects that can be grouped under "SAP Technology - Business Services: Address Management".
It is part of development package SZAD in software component BC-SRV-ADR. This development package consists of objects that can be grouped under "SAP Technology - Business Services: Address Management".
Fields for table T005
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
LAND1 | Country/Region Key | X | LAND1 | CHAR | 6 | |
LANDK | Vehicle Country/Region Key | LANDK | CHAR | 6 | ||
LNPLZ | Postal code length | LNPLZ_005 | NUMC | 4 | ||
PRPLZ | Rule for the postal code field check | PRUEF_005 | CHAR | 2 | ||
ADDRS | Formatting routine key for printing addresses | ADDRS_005 | CHAR | 6 | T005A | |
XPLZS | Flag: Street address postal code required entry? | XPLZS_005 | CHAR | 2 | ||
XPLPF | Flag: PO Box postal code required? | XPLPF_005 | CHAR | 2 | ||
SPRAS | Language Key | SPRAS | LANG | 2 | T002 | |
XLAND | Indicator: Country/Region Version Availability | XLAND_005 | CHAR | 2 | ||
XADDR | Indicator: Print Country/Region for Addresses of Other C/R | XADDR_005 | CHAR | 2 | ||
NMFMT | Standard name format | NMFMT_005 | CHAR | 4 | T005N | |
XREGS | Flag: City file address check | XREGS_005 | CHAR | 2 | ||
XPLST | Flag: Street-specific postal code? (City file) | XPLST_005 | CHAR | 2 | ||
INTCA | ISO Code of the Country/Region | INTCA | CHAR | 4 | ||
INTCA3 | ISO Country/Region Code 3 Characters | INTCA3 | CHAR | 6 | ||
INTCN3 | ISO Country/Region Code Numeric 3-Characters | INTCN3 | NUMC | 6 | ||
XEGLD | Indicator: European Union Member? | XEGLD | CHAR | 2 | ||
XSKFN | Indicator: Discount base amount is the net value | XSKFN | CHAR | 2 | ||
XMWSN | Indicator: Base amount for tax is net of discount ? | XMWSN | CHAR | 2 | ||
.INCLUDE | SI_T005ABA | 0 | ||||
LNBKN | Bank account number length | LNBKN_005 | NUMC | 4 | ||
PRBKN | Rule for checking bank account number field | PRBKN_005 | CHAR | 2 | ||
LNBLZ | Bank number length | LNBLZ_005 | NUMC | 4 | ||
PRBLZ | Rule for checking bank number field | PRBLZ_005 | CHAR | 2 | ||
LNPSK | Post office bank current account number length | LNPSK_005 | NUMC | 4 | ||
PRPSK | Rule for checking postal check account number field | PRPSK_005 | CHAR | 2 | ||
XPRBK | Indicator: Use check module for bank fields ? | XPRBK_005 | CHAR | 2 | ||
BNKEY | Name of the bank key | BNKEY | CHAR | 2 | ||
LNBKS | Length of Bank Key | LNBKS_005 | NUMC | 4 | ||
PRBKS | Rule for checking bank key field | PRBKS_005 | CHAR | 2 | ||
XPRSO | Indicator: Use check module for tax fields etc. ? | XPRSO_005 | CHAR | 2 | ||
PRUIN | Rule for checking VAT registration number field | PRUIN_005 | CHAR | 2 | ||
UINLN | VAT registration number length | UINLN | NUMC | 4 | ||
LNST1 | Permitted Input Length for Tax Numbre 1 | LNST1_005 | NUMC | 4 | ||
PRST1 | Rule for checking tax code 1 field | PRST1_005 | CHAR | 2 | ||
LNST2 | Permitted Input Length for Tax Number 2 | LNST2_005 | NUMC | 4 | ||
PRST2 | Rule for checking tax code 2 field | PRST2_005 | CHAR | 2 | ||
LNST3 | Permitted Input Length for Tax Number 3 | LNST3_005 | NUMC | 4 | ||
PRST3 | Rule for checking tax code 3 field | PRST3_005 | CHAR | 2 | ||
LNST4 | Permitted Input Length for Tax Number 4 | LNST4_005 | NUMC | 4 | ||
PRST4 | Rule for checking tax code 4 field | PRST4_005 | CHAR | 2 | ||
LNST5 | Permitted Input Length for Tax Number 5 | LNST5_005 | NUMC | 4 | ||
PRST5 | Rule for checking tax code 5 field | PRST5_005 | CHAR | 2 | ||
.INCLUDE | SI_T005AP | 0 | ||||
.INCLUDE | SI_T005HR | 0 | ||||
LANDD | DUEVO: Nationality | DUSTA | CHAR | 6 | T5D4E | |
.INCLUDE | SI_T005SPAY | 0 | ||||
KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 12 | T683 | |
.INCLUDE | SI_T005 | 0 | ||||
LANDA | Alternative Country/Region Key | LANDA | CHAR | 6 | ||
WECHF | Bill of Exchange Payment Period | WECHF | NUMC | 6 | ||
LKVRZ | Short Name for Foreign Trade Statistics | LKVRZ | CHAR | 14 | ||
INTCN | Intrastat Code | INTCN | NUMC | 6 | ||
XDEZP | Decimal Point Format | XDEZP | CHAR | 2 | ||
DATFM | Date Format | DATFM | CHAR | 2 | ||
CURIN | Currency Key of the Index-Based Currency | CURIN | CUKY | 10 | TCURC | |
CURHA | Currency Key of the Hard Currency | CURHA | CUKY | 10 | TCURC | |
WAERS | Reporting Currency | WAERS_005 | CUKY | 10 | TCURC | |
KURST | Exchange Rate Type for Translation into Reporting Currency | KURST_005 | CHAR | 8 | TCURV | |
AFAPL | Chart of Depreciaton for Asset Valuation | AFAPL | CHAR | 8 | T096 | |
GWGWRT | Maximum Low-Value Asset Amount | GWGWRT | CURR | 12 | ||
UMRWRT | Net Book Value for Changeover of Depreciation Method | UMRWRT | CURR | 12 | ||
KZRBWB | Indicator Post Net Book Value for Retirement | KZRBWB | CHAR | 2 | ||
XANZUM | Indicator transfer down payments from previous years | XANZUM | CHAR | 2 | ||
CTNCONCEPT | Withholding Tax Certificate Numbering: Concepts | CTNCONCEPT | CHAR | 8 | WITH_CTNCOKEY | |
KZSRV | Taxes at individual service level | KZSRV | CHAR | 2 | ||
XXINVE | Indicator: Display Capital Goods Indicator? | XXINVE | CHAR | 2 | ||
NET_GROSS_POSTING_TYPE | Calculate and Post Impairment Based on Net or Gross Amount | FINS_NET_GROSS_POSTING_TYPE | CHAR | 2 | ||
.INCLU--AP | T005GCCVAT | 0 | ||||
XGCCV | Indicator: GCC Member? | XGCCV | CHAR | 2 | ||
.INCLU--AP | T005APP | 0 | ||||
SUREG | Super Region for Each Country/Region | PRQ_SUREG | CHAR | 16 | TBKS |