SAP Table SIA_T005

Table T005 Application Fields

SIA_T005 (Table T005 Application Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SIA_T005 to other SAP tables.

SIA_T005 table fields

Field Data element Checktable Datatype Length Decimals
LANDA Alternative Country Key LANDA CHAR 3 0
LANDD DUEVO Country Key LANDD CHAR 3 0
XEGLD Indicator: European Union Member? XEGLD CHAR 1 0
X Yes
NULL No
LNBKN Bank account number length LNBKN_005 NUMC 2 0
PRBKN Rule for checking bank account number field PRBKN_005 CHAR 1 0
1 Maximum value length, without gaps
2 Maximum value length, numerical, without gaps
3 Length to be kept to exactly, without gaps
4 Length to be kept to exactly, numerical, without gaps
5 Maximum value length
6 Maximum value length, numerical
7 Length to be kept to exactly
8 Length to be kept to exactly, numerical
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNBLZ Bank number length LNBLZ_005 NUMC 2 0
PRBLZ Rule for checking bank number field PRBLZ_005 CHAR 1 0
1 Maximum value length, without gaps
2 Maximum value length, numerical, without gaps
3 Length to be kept to exactly, without gaps
4 Length to be kept to exactly, numerical, without gaps
5 Maximum value length
6 Maximum value length, numerical
7 Length to be kept to exactly
8 Length to be kept to exactly, numerical
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNPSK Post office bank current account number length LNPSK_005 NUMC 2 0
PRPSK Rule for checking postal check account number field PRPSK_005 CHAR 1 0
1 Maximum value length, without gaps
2 Maximum value length, numerical, without gaps
3 Length to be kept to exactly, without gaps
4 Length to be kept to exactly, numerical, without gaps
5 Maximum value length
6 Maximum value length, numerical
7 Length to be kept to exactly
8 Length to be kept to exactly, numerical
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNST1 Permitted Input Length for Tax Numbre 1 LNST1_005 NUMC 2 0
PRST1 Rule for checking tax code 1 field PRST1_005 CHAR 1 0
1 Maximum value length, without gaps
2 Maximum value length, numerical, without gaps
3 Length to be kept to exactly, without gaps
4 Length to be kept to exactly, numerical, without gaps
5 Maximum value length
6 Maximum value length, numerical
7 Length to be kept to exactly
8 Length to be kept to exactly, numerical
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNST2 Permitted Input Length for Tax Number 2 LNST2_005 NUMC 2 0
PRST2 Rule for checking tax code 2 field PRST2_005 CHAR 1 0
1 Maximum value length, without gaps
2 Maximum value length, numerical, without gaps
3 Length to be kept to exactly, without gaps
4 Length to be kept to exactly, numerical, without gaps
5 Maximum value length
6 Maximum value length, numerical
7 Length to be kept to exactly
8 Length to be kept to exactly, numerical
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
XPRBK Indicator: Use check module for bank fields ? XPRBK_005 CHAR 1 0
X Yes
NULL No
XPRSO Indicator: Use check module for tax fields etc. ? XPRSO_005 CHAR 1 0
X Yes
NULL No
WECHF Payment period for bill of exchange WECHF NUMC 3 0
SPRAS Language Key SPRAS LANG 1 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
LKVRZ Short Name for Foreign Trade Statistics LKVRZ CHAR 7 0
UINLN VAT registration number length UINLN NUMC 2 0
INTCA Country ISO code INTCA CHAR 2 0
INTCN Intrastat Code INTCN NUMC 3 0
PRUIN Rule for checking VAT registration number field PRUIN_005 CHAR 1 0
1 Maximum value length, without gaps
2 Maximum value length, numerical, without gaps
3 Length to be kept to exactly, without gaps
4 Length to be kept to exactly, numerical, without gaps
5 Maximum value length
6 Maximum value length, numerical
7 Length to be kept to exactly
8 Length to be kept to exactly, numerical
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
XDEZP Decimal point format XDEZP CHAR 1 0
X Yes
NULL No
DATFM Date Format DATFM CHAR 1 0
1 DD.MM.YYYY
2 MM/DD/YYYY
3 MM-DD-YYYY
4 YYYY.MM.DD
BNKEY Name of the bank key BNKEY CHAR 1 0
1 Bank number
2 Obsolete
3 Assign internally
4 Assign externally
LNBKS Length of Bank Key LNBKS_005 NUMC 2 0
PRBKS Rule for checking bank key field PRBKS_005 CHAR 1 0
1 Maximum value length, without gaps
2 Maximum value length, numerical, without gaps
3 Length to be kept to exactly, without gaps
4 Length to be kept to exactly, numerical, without gaps
5 Maximum value length
6 Maximum value length, numerical
7 Length to be kept to exactly
8 Length to be kept to exactly, numerical
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
CURIN Currency Key of the Index-Based Currency CURIN CUKY 5 0
CURHA Currency Key of the Hard Currency CURHA CUKY 5 0
XLAND Country version flag XLAND_005 CHAR 1 0
NULL Not relevant for IMG or country program
I Only relevant for IMG
X Relevant for both IMG and country program