SAP Table T001N
Company Code - EC Tax Numbers / Notifications
T001N (Company Code - EC Tax Numbers / Notifications) 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 T001N to other SAP tables.
T001N table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | 0 | |||
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | 0 | |||
ADRNR | Address | ADRNR | CHAR | 10 | 0 | |||
VMZL1 | Registration Entry 1 for EC Sales List | VMZL1 | CHAR | 48 | 0 | |||
VMZL2 | Registration Entry 2 for EC Sales List | VMZL2 | CHAR | 48 | 0 | |||
VMZL3 | Registration Entry 3 for EC Sales List | VMZL3 | CHAR | 48 | 0 | |||
INKNR | ID no. INTRASTAT for declarations to the authorities for FT | INKNR | CHAR | 20 | 0 | |||
INZNR | Foreign Trade: Additional no. for decl. to authorities | INZNR | NUMC | 3 | 0 | |||
EXFNR | Company no. EXTRASTAT for declar. to auth. for Foreign Trade | EXFNR | CHAR | 7 | 0 | |||
EXMNR | EXTRASTAT material no. for decl. to auth. for Foreign Trade | EXMNR | CHAR | 6 | 0 | |||
EXTKN | EXTRASTAT ID no. for decl. to authorities for Foreign Trade | EXTKN | CHAR | 20 | 0 | |||
STCD1 | Tax Number for Plants Abroad | STCD1_001N | CHAR | 16 | 0 |
T001N foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
T001N | BUKRS | T001N | MANDT | T001 | Company Codes | MANDT |
T001N | BUKRS | T001N | BUKRS | T001 | Company Codes | BUKRS |
T001N | LAND1 | T001N | MANDT | T005 | Countries | MANDT |
T001N | LAND1 | T001N | LAND1 | T005 | Countries | LAND1 |
T001N | MANDT | T001N | MANDT | T000 | Clients | MANDT |