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".

Fields for table T005

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
LAND1Country/Region KeyXLAND1CHAR6
LANDKVehicle Country/Region KeyLANDKCHAR6
LNPLZPostal code lengthLNPLZ_005NUMC4
PRPLZRule for the postal code field checkPRUEF_005CHAR2
ADDRSFormatting routine key for printing addressesADDRS_005CHAR6T005A
XPLZSFlag: Street address postal code required entry?XPLZS_005CHAR2
XPLPFFlag: PO Box postal code required?XPLPF_005CHAR2
SPRASLanguage KeySPRASLANG2T002
XLANDIndicator: Country/Region Version AvailabilityXLAND_005CHAR2
XADDRIndicator: Print Country/Region for Addresses of Other C/RXADDR_005CHAR2
NMFMTStandard name formatNMFMT_005CHAR4T005N
XREGSFlag: City file address checkXREGS_005CHAR2
XPLSTFlag: Street-specific postal code? (City file)XPLST_005CHAR2
INTCAISO Code of the Country/RegionINTCACHAR4
INTCA3ISO Country/Region Code 3 CharactersINTCA3CHAR6
INTCN3ISO Country/Region Code Numeric 3-CharactersINTCN3NUMC6
XEGLDIndicator: European Union Member?XEGLDCHAR2
XSKFNIndicator: Discount base amount is the net valueXSKFNCHAR2
XMWSNIndicator: Base amount for tax is net of discount ?XMWSNCHAR2
.INCLUDESI_T005ABA0
LNBKNBank account number lengthLNBKN_005NUMC4
PRBKNRule for checking bank account number fieldPRBKN_005CHAR2
LNBLZBank number lengthLNBLZ_005NUMC4
PRBLZRule for checking bank number fieldPRBLZ_005CHAR2
LNPSKPost office bank current account number lengthLNPSK_005NUMC4
PRPSKRule for checking postal check account number fieldPRPSK_005CHAR2
XPRBKIndicator: Use check module for bank fields ?XPRBK_005CHAR2
BNKEYName of the bank keyBNKEYCHAR2
LNBKSLength of Bank KeyLNBKS_005NUMC4
PRBKSRule for checking bank key fieldPRBKS_005CHAR2
XPRSOIndicator: Use check module for tax fields etc. ?XPRSO_005CHAR2
PRUINRule for checking VAT registration number fieldPRUIN_005CHAR2
UINLNVAT registration number lengthUINLNNUMC4
LNST1Permitted Input Length for Tax Numbre 1LNST1_005NUMC4
PRST1Rule for checking tax code 1 fieldPRST1_005CHAR2
LNST2Permitted Input Length for Tax Number 2LNST2_005NUMC4
PRST2Rule for checking tax code 2 fieldPRST2_005CHAR2
LNST3Permitted Input Length for Tax Number 3LNST3_005NUMC4
PRST3Rule for checking tax code 3 fieldPRST3_005CHAR2
LNST4Permitted Input Length for Tax Number 4LNST4_005NUMC4
PRST4Rule for checking tax code 4 fieldPRST4_005CHAR2
LNST5Permitted Input Length for Tax Number 5LNST5_005NUMC4
PRST5Rule for checking tax code 5 fieldPRST5_005CHAR2
.INCLUDESI_T005AP0
.INCLUDESI_T005HR0
LANDDDUEVO: NationalityDUSTACHAR6T5D4E
.INCLUDESI_T005SPAY0
KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...)KALSM_DCHAR12T683
.INCLUDESI_T0050
LANDAAlternative Country/Region KeyLANDACHAR6
WECHFBill of Exchange Payment PeriodWECHFNUMC6
LKVRZShort Name for Foreign Trade StatisticsLKVRZCHAR14
INTCNIntrastat CodeINTCNNUMC6
XDEZPDecimal Point FormatXDEZPCHAR2
DATFMDate FormatDATFMCHAR2
CURINCurrency Key of the Index-Based CurrencyCURINCUKY10TCURC
CURHACurrency Key of the Hard CurrencyCURHACUKY10TCURC
WAERSReporting CurrencyWAERS_005CUKY10TCURC
KURSTExchange Rate Type for Translation into Reporting CurrencyKURST_005CHAR8TCURV
AFAPLChart of Depreciaton for Asset ValuationAFAPLCHAR8T096
GWGWRTMaximum Low-Value Asset AmountGWGWRTCURR12
UMRWRTNet Book Value for Changeover of Depreciation MethodUMRWRTCURR12
KZRBWBIndicator Post Net Book Value for RetirementKZRBWBCHAR2
XANZUMIndicator transfer down payments from previous yearsXANZUMCHAR2
CTNCONCEPTWithholding Tax Certificate Numbering: ConceptsCTNCONCEPTCHAR8WITH_CTNCOKEY
KZSRVTaxes at individual service levelKZSRVCHAR2
XXINVEIndicator: Display Capital Goods Indicator?XXINVECHAR2
NET_GROSS_POSTING_TYPECalculate and Post Impairment Based on Net or Gross AmountFINS_NET_GROSS_POSTING_TYPECHAR2
.INCLU--APT005GCCVAT0
XGCCVIndicator: GCC Member?XGCCVCHAR2
.INCLU--APT005APP0
SUREGSuper Region for Each Country/RegionPRQ_SUREGCHAR16TBKS
Privacy Policy