SAP Table T005SEPA

SEPA Country Settings

T005SEPA (SEPA Country Settings) 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 T005SEPA to other SAP tables.

T005SEPA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LAND1 Country Key LAND1 T005 CHAR 3 0
INTCA Country ISO code INTCA CHAR 2 0
XSEPA_LAND Indicator: SEPA Country XSEPA_LAND CHAR 1 0
X Yes
NULL No
XIBAN_ONLY Indicator: IBAN without BIC XIBAN_ONLY CHAR 1 0
X Yes
NULL No
IBAN_LENGTH Length of IBAN IBAN_LENGTH NUMC 2 0
UCI_LENGTH Length of Creditor ID UCI_LENGTH NUMC 2 0
UCI_RULE Checking Rule for the Creditor ID UCI_RULE 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

T005SEPA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T005SEPA LAND1 * T005 Countries MANDT
T005SEPA LAND1 T005SEPA LAND1 T005 Countries LAND1