SAP ABAP Table FTJOUR_KO (Foreign Trade: Transfer Structure (ALV) - Journals - Header)

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	INTTAB	Structure
Structure	FTJOUR_KO	Table Relationship Diagram
Short Description	Foreign Trade: Transfer Structure (ALV) - Journals - Header

Delivery and Maintenance

Pool/cluster
Delivery Class
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	ICOSYS	☐	FTJ_AMPEL	LIGHTS	CHAR	30	0	Traffic light for Foreign Trade status of a document/item
2	ICOMAN	☐	FTJ_HAKEN	LIGHTS	CHAR	30	0	Indicator for confirming completeness
3	ICONLAND	☐	FTJ_LAND	LIGHTS	CHAR	30	0	Foreign Trade: Icon for identification of the economic area
4	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
5	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	*
6	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
7	KU_WE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
8	KU_AG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
9	KU_RG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
10	.INCLUDE	☐				0	0	Foreign Trade: Reference Structure for EIKP and Dynamic Part
11	.INCLUDE	☐				0	0	Foreign Trade: Export/Import Header Data
12	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
13	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
14	ALAND	☐	HLAND	LAND1	CHAR	3	0	Delivering country	T005
15	EXPVZ	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	T618
16	ZOLLA	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	T615
17	ZOLLB	☐	DZOLLB	ZOLLS	CHAR	6	0	Customs office: Office of destination for foreign trade	T615
18	ZOLL1	☐	DZOLL1	ZOLLS	CHAR	6	0	Customs office: Customs office 1 for foreign trade	T615
19	ZOLL2	☐	DZOLL2	ZOLLS	CHAR	6	0	Customs office: Customs office 2 for foreign trade	T615
20	ZOLL3	☐	DZOLL3	ZOLLS	CHAR	6	0	Customs office: Customs office 3 for foreign trade	T615
21	ZOLL4	☐	DZOLL4	ZOLLS	CHAR	6	0	Customs office: Customs office 4 for foreign trade	T615
22	ZOLL5	☐	DZOLL5	ZOLLS	CHAR	6	0	Customs office: Customs office 5 for foreign trade	T615
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
29	GRWCU	☐	GRWCU	WAERS	CUKY	5	0	Currency of statistical values for foreign trade	TCURC
30	IEVER	☐	IEVER	EXPVZ	CHAR	1	0	Domestic Mode of Transport for Foreign Trade	T618
31	SEGAL	☐	SEGAL	SEGAL	CHAR	2	0	Exclusion/Inclusion indicator for declara. to authorities	T609A
32	WZOCU	☐	WZOCU	WAERS	CUKY	5	0	Currency of customs values for import procg in foreign trade	TCURC
33	PRONU	☐	PRONU	PRONU	CHAR	25	0	Invoice: Number of invoice document for import processing
34	PRODA	☐	PRODA	DATUM	DATS	8	0	Invoice: Date of invoice document for import processing
35	VORPA	☐	VORPA	VORPA	CHAR	10	0	Preliminary document: Document type for foreign trade procg	T610VA
36	VORDA	☐	VORDA	DATUM	DATS	8	0	Preliminary document: Date of preliminary doc.f.import procg
37	VORNU	☐	VORNU	CHAR25	CHAR	25	0	Preliminary document: No. of preliminary doc.f.import procg
38	BEHOE	☐	VOHOE	BEHOE	CHAR	10	0	Preliminary doc.: Issuing authority of relevant prelim.doc.	T610O
39	KENNU	☐	KENNU	CHAR06	CHAR	6	0	Preliminary document: Customs office/ID number for import
40	VOISO	☐	VOISO	INTCA	CHAR	2	0	Prelim. doc.: ISO code of ctry issuing the preliminary doc.
41	PREFPACOD	☐	PREFPACOD	PREFPACOD	CHAR	3	0	Preference code for foreign trade (decl.to author., import)	T604C
42	PREFA	☐	PREFA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
43	PREFN	☐	PREFN	CHAR25	CHAR	25	0	Preference: Official number of preference document - Import
44	PREDU	☐	PREDU	DATUM	DATS	8	0	Preference: Date of preference document for import procg
45	PRISO	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
46	PRHOE	☐	PRHOE	BEHOE	CHAR	10	0	Preference: Issuing authoritiy for relevant preference doc.	T610O
47	PRUEL	☐	PRUEL	DATUM	DATS	8	0	Preference: Validity date of preference document for import
48	NACAR	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
49	NACNU	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
50	NACDA	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
51	NAISO	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
52	NAHOE	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
53	NAUEL	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
54	TEXT1	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
55	TEXT2	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
56	TEXT3	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
57	EXDAR	☐	EXDAR	VORPA	CHAR	10	0	Export document: Export document type for foreign trade	T610VA
58	EXDAA	☐	EXDAA	CHAR25	CHAR	25	0	Export document: Official number of export document
59	EXDAB	☐	EXDAB	CHAR25	CHAR	25	0	Export document: Valid-to number of export document
60	EXDTA	☐	EXDTA	VORPA	CHAR	10	0	T document: Type of T document for foreign trade	T610VA
61	EXDT2	☐	EXDT2	CHAR25	CHAR	25	0	T document: Official number of T document for foreign trade
62	EXDTB	☐	EXDTB	CHAR25	CHAR	25	0	T doc.: Official no. for next page of T doc. f.foreign trade
63	EXDPA	☐	EXDPA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
64	EXPRE	☐	EXPRE	CHAR25	CHAR	25	0	Preference: Official number of preference document - Export
65	EXDT5	☐	EXDT5	CHAR25	CHAR	25	0	CAP: Official number of T5 document for foreign trade
66	LADEL	☐	LADEL	LADEL	CHAR	40	0	Place of loading/unloading for foreign trade
67	AUSFU	☐	AUSFU	LIFNR	CHAR	10	0	Exporter for import processing in foreign trade	LFA1
68	EIOKW	☐	EIOKW	EIOKW	CHAR	1	0	Status: Complete document data in foreign trade (user)
69	AUSOK	☐	AUSOK	XFELD	CHAR	1	0	Status: Document data in foreign trade complete (system)
70	LAZL1	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
71	LAZL2	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
72	LAZL3	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
73	LAZL4	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
74	LAZL5	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
75	LAZL6	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
76	AZOLL	☐	AZOLL	ZOLLS	CHAR	6	0	Customs office: Export customs office for foreign trade	T615
77	AHBAS	☐	AHBAS	AHBAS	CHAR	3	0	Basis document category for foreign trade processing
78	REFNR	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
79	MABSD	☐	MABSD	DATUM	DATS	8	0	Selection date for periodic declarations
80	BFMAR	☐	BFMAR	BFMAR	CHAR	6	0	Foreign Trade: Type of means of transport	T612B
81	CUDCL	☐	CUDCL	CUDCL	CHAR	3	0	Customs declaration type for customs processing in FT
82	.INCLUDE	☐				0	0	Table for Update Indicators
83	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
84	.INCLUDE	☐				0	0	Foreign Trade: Communication Structure - Header Data
85	FT_BNR	☐	FT_BNR	FT_BNR	CHAR	10	0	Foreign trade: Document number
86	FT_JAHR	☐	FT_JAHR	GJAHR	NUMC	4	0	Foreign trade: Document year
87	FT_ART	☐	FT_ART	FT_ART	CHAR	4	0	Foreign trade: Document type
88	FT_PAR	☐	FT_PAR	FT_PAR	CHAR	10	0	Foreign trade: Partners
89	FT_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
90	FT_DAT	☐	FT_DAT	FT_DAT	DATS	8	0	Foreign Trade: Document Date
91	FT_WAERS	☐	FT_WAERS	FT_WAERS	CUKY	5	0	Foreign trade: Document currency	*
92	FT_HLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
93	FT_PLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
94	FT_EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
95	FT_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
96	FT_EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
97	FT_EXP_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
98	FT_STATUS	☐	UVALL_UP	STATV	CHAR	1	0	General Incompletion Status of the Item
99	FT_AMPEL	☐	FT_AMPEL	CHAR40	CHAR	40	0	Foreign trade: Status
100	FT_TEXT1	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
101	FT_TEXT2	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
102	FT_TEXT3	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
103	FT_TEXT4	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
104	FT_TEXT5	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
105	FT_TEXT6	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
106	FT_TEXT7	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
107	FT_TEXT8	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
108	FT_TEXT9	☐	FT_TEXT	CHAR40	CHAR	40	0	Foreign trade: Text field
109	FT_SUBSCR	☐	FT_SUBSCR	CHAR30	CHAR	30	0	Foreign Trade: Input field for subscreen control
110	FT_EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
111	FT_RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
112	FT_SUMME	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
113	FT_GESSTA	☐	FT_GESSTA	CHAR30	CHAR	30	0	Foreign Trade/Customs: Overall status of a document
114	FT_GESMAN	☐	FT_GESMAN	CHAR30	CHAR	30	0	Foreign Trade/Customs: Overall Status Doc.: Manual Status
115	FT_USER	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
116	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
117	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
118	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
119	CBOX	☐	FLAG	FLAG	CHAR	1	0	General Flag
120	STATUS	☐	SL_COLOR	SL_COLOR	CHAR	3	0	Foreign Trade: SLS - Field determining line color
121	COLOR	☐	SL_COLOR	SL_COLOR	CHAR	3	0	Foreign Trade: SLS - Field determining line color
122	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
123	FT_SUM_GRWRT	☐	FT_SUM_GRWRT	WERTV8	CURR	15	2	Total statistical value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTJOUR_KO	ALAND	T005	LAND1
2	FTJOUR_KO	AUSFU	LFA1	LIFNR	REF	C	CN
3	FTJOUR_KO	AZOLL	T615	ZOLLA	REF	1	CN
4	FTJOUR_KO	BEHOE	T610O	BEHOE	REF	1	CN
5	FTJOUR_KO	BFMAR	T612B	BFMAR		1	CN
6	FTJOUR_KO	EXDAR	T610VA	VORPA	REF	1	CN
7	FTJOUR_KO	EXDPA	T610PA	PREFA	REF	1	CN
8	FTJOUR_KO	EXDTA	T610VA	VORPA	REF	1	CN
9	FTJOUR_KO	EXPVZ	T618	EXPVZ
10	FTJOUR_KO	GRWCU	TCURC	WAERS
11	FTJOUR_KO	IEVER	T618	EXPVZ	REF	1	CN
12	FTJOUR_KO	LAZL1	T005	LAND1	REF	1	CN
13	FTJOUR_KO	LAZL2	T005	LAND1	REF	1	CN
14	FTJOUR_KO	LAZL3	T005	LAND1	REF	1	CN
15	FTJOUR_KO	LAZL4	T005	LAND1	REF	1	CN
16	FTJOUR_KO	LAZL5	T005	LAND1	REF	1	CN
17	FTJOUR_KO	LAZL6	T005	LAND1	REF	1	CN
18	FTJOUR_KO	MANDT	T000	MANDT
19	FTJOUR_KO	NACAR	T610NA	NACAR	REF	1	CN
20	FTJOUR_KO	NAHOE	T610O	BEHOE	REF	1	CN
21	FTJOUR_KO	PREFA	T610PA	PREFA	REF	1	CN
22	FTJOUR_KO	PREFPACOD	T604C	PREFPACOD	REF	1	CN
23	FTJOUR_KO	PRHOE	T610O	BEHOE	REF	1	CN
24	FTJOUR_KO	SEGAL	T609A	SEGAL	REF	1	CN
25	FTJOUR_KO	STABE	T005	LAND1
26	FTJOUR_KO	STGBE	T005	LAND1
27	FTJOUR_KO	VORPA	T610VA	VORPA	REF	1	CN
28	FTJOUR_KO	WZOCU	TCURC	WAERS	REF	1	CN
29	FTJOUR_KO	ZOLL1	T615	ZOLLA	REF	1	CN
30	FTJOUR_KO	ZOLL2	T615	ZOLLA	REF	1	CN
31	FTJOUR_KO	ZOLL3	T615	ZOLLA	REF	1	CN
32	FTJOUR_KO	ZOLL4	T615	ZOLLA	REF	1	CN
33	FTJOUR_KO	ZOLL5	T615	ZOLLA	REF	1	CN
34	FTJOUR_KO	ZOLL6	T615	ZOLLA	REF	1	CN
35	FTJOUR_KO	ZOLLA	T615	ZOLLA
36	FTJOUR_KO	ZOLLB	T615	ZOLLA	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in