SAP ABAP Table T617 (Foreign Trade: Proposal for Foreign Trade Header Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VEI (Package) Application development R/3 foreign trade

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T617	Table Relationship Diagram
Short Description	Foreign Trade: Proposal for Foreign Trade Header Data

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VEREI	☑	VEREI	VEREI	NUMC	1	0	Indicator: Goods direction for declarations to authorities
3	ALAND	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
4	ALREG	☑	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
5	LLAND	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	LLREG	☑	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
7	EXPVZ	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	T618
8	IEVER	☐	IEVER	EXPVZ	CHAR	1	0	Domestic Mode of Transport for Foreign Trade	T618
9	ZOLLA	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	T615
10	AZOLL	☐	AZOLL	ZOLLS	CHAR	6	0	Customs office: Export customs office for foreign trade	T615
11	ZOLLB	☐	DZOLLB	ZOLLS	CHAR	6	0	Customs office: Office of destination for foreign trade	T615
12	LAZL1	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
13	ZOLL1	☐	DZOLL1	ZOLLS	CHAR	6	0	Customs office: Customs office 1 for foreign trade	T615
14	LAZL2	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
15	ZOLL2	☐	DZOLL2	ZOLLS	CHAR	6	0	Customs office: Customs office 2 for foreign trade	T615
16	LAZL3	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
17	ZOLL3	☐	DZOLL3	ZOLLS	CHAR	6	0	Customs office: Customs office 3 for foreign trade	T615
18	LAZL4	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
19	ZOLL4	☐	DZOLL4	ZOLLS	CHAR	6	0	Customs office: Customs office 4 for foreign trade	T615
20	LAZL5	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
21	ZOLL5	☐	DZOLL5	ZOLLS	CHAR	6	0	Customs office: Customs office 5 for foreign trade	T615
22	LAZL6	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
23	ZOLL6	☐	DZOLL6	ZOLLS	CHAR	6	0	Customs office: Customs office 6 for foreign trade	T615
24	KZGBE	☐	KZGBE	KZGBEF	CHAR	30	0	Indicator for means of transport crossing the border
25	KZABE	☐	KZABE	KZABE	CHAR	30	0	Indicator for the means of transport at departure
26	STGBE	☐	STGBE	LAND1	CHAR	3	0	Origin of Means of Transport when Crossing the Border	T005
27	STABE	☐	STABE	LAND1	CHAR	3	0	Country of Origin of the Means of Transport at Departure	T005
28	CONTA	☐	CONTA	CONTA	CHAR	1	0	ID: Goods cross border in a container

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T617	ALAND	T005	LAND1	KEY	1	CN
2	T617	ALREG	T005S	BLAND	KEY	1	CN
3	T617	AZOLL	T615	ZOLLA	REF	1	CN
4	T617	EXPVZ	T618	EXPVZ	REF	1	CN
5	T617	IEVER	T618	EXPVZ	REF	1	CN
6	T617	LAZL1	T005	LAND1	REF	1	CN
7	T617	LAZL2	T005	LAND1	REF	1	CN
8	T617	LAZL3	T005	LAND1	REF	1	CN
9	T617	LAZL4	T005	LAND1	REF	1	CN
10	T617	LAZL5	T005	LAND1	REF	1	CN
11	T617	LAZL6	T005	LAND1	REF	1	CN
12	T617	LLAND	T005	LAND1	KEY	1	CN
13	T617	LLREG	T005S	BLAND	KEY	1	CN
14	T617	MANDT	T000	MANDT	KEY	1	CN
15	T617	STABE	T005	LAND1	REF	1	CN
16	T617	STGBE	T005	LAND1	REF	1	CN
17	T617	ZOLL1	T615	ZOLLA	REF	1	CN
18	T617	ZOLL2	T615	ZOLLA	REF	1	CN
19	T617	ZOLL3	T615	ZOLLA	REF	1	CN
20	T617	ZOLL4	T615	ZOLLA	REF	1	CN
21	T617	ZOLL5	T615	ZOLLA	REF	1	CN
22	T617	ZOLL6	T615	ZOLLA	REF	1	CN
23	T617	ZOLLA	T615	ZOLLA	REF	1	CN
24	T617	ZOLLB	T615	ZOLLA	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in