SAP ABAP Table FTJOUR_PO (Foreign Trade: Transfer Structure (ALV) - Journals - Item)

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

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	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
4	.INCLUDE	☐				0	0	Foreign Trade: Communication Structure - Item Data
5	FT_BNR	☐	FT_BNR	FT_BNR	CHAR	10	0	Foreign trade: Document number
6	FT_JAHR	☐	FT_JAHR	GJAHR	NUMC	4	0	Foreign trade: Document year
7	FT_POS	☐	FT_POS	FT_POS	NUMC	6	0	Foreign trade: Document item
8	FT_MATNR	☐	FT_MATNR	MATNR	CHAR	18	0	Foreign trade: Material number of document item	*
9	FT_WERK	☐	FT_WERK	WERKS	CHAR	4	0	Foreign trade: Plant in document	*
10	FT_KZTEXT	☐	FT_KZTEXT	TEXT40	CHAR	40	0	Foreign trade: Material description of document item
11	FT_MENGE	☐	FT_MENGE	FT_MENGE	QUAN	13	3	Foreign trade: Material quantity in document
12	FT_MGEIH	☐	FT_MGEIH	MEINS	UNIT	3	0	Foreign trade: Unit of measure for quantity in document	*
13	FT_PREIS	☐	FT_PREIS	FT_PREIS	CURR	15	2	Foreign trade: Price for document item
14	FT_PEINH	☐	FT_PEINH	DEC5	DEC	5	0	Foreign trade: Price unit
15	FT_BPRME	☐	FT_BPRME	MEINS	UNIT	3	0	Foreign trade: Order price unit	*
16	FT_EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
17	FT_VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
18	FT_STATUS	☐	UVALL_UP	STATV	CHAR	1	0	General Incompletion Status of the Item
19	FT_SELFLAG	☐	FT_SELFLAG	CHAR1	CHAR	1	0	Foreign trade: Table control indicator
20	FT_AMPEL	☐	FT_AMPEL	CHAR40	CHAR	40	0	Foreign trade: Status
21	FT_SUBSCR	☐	FT_SUBSCR	CHAR30	CHAR	30	0	Foreign Trade: Input field for subscreen control
22	FT_PRDAT	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
23	FT_VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
24	FT_POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
25	FT_AMPEL_LE	☐	LE_AMPEL	CHAR30	CHAR	30	0	Vendor declaration traffic light
26	FT_BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
27	FT_MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
28	FT_TASTE_NINC	☐	BEZEI30	TEXT30	CHAR	30	0	Description
29	.INCLUDE	☐				0	0	Foreign Trade: Reference Structure for EIPO and Dynamic Part
30	.INCLUDE	☐				0	0	Foreign Trade: Export/Import: Item Data
31	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
32	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
33	EXPOS	☐	EXPOS	EXPOS	NUMC	6	0	Internal item number for foreign trade data in MM and SD
34	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
35	EXPRF	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	T616
36	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
37	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
38	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
39	GRWRT	☐	GRWRT	GRWRT	CURR	13	2	Statistical value for foreign trade
40	PREFPACOD	☐	PREFPACOD	PREFPACOD	CHAR	3	0	Preference code for foreign trade (decl.to author., import)	T604C
41	SEGAL	☐	SEGAL	SEGAL	CHAR	2	0	Exclusion/Inclusion indicator for declara. to authorities	T609A
42	MOWNR	☐	MOWNR	MOWNR	CHAR	12	0	CAP: Number of CAP products list	T618M
43	MOGRU	☐	MOGRU	MOGRU	CHAR	6	0	Common Agricultural Policy: CAP products group-Foreign Trade	T618G
44	GPNUM	☐	GPNUM	GPNUM	CHAR	9	0	Production statistics: PRODCOM number for foreign trade	T609G
45	CASNR	☐	CASNR	CASNR	CHAR	15	0	CAS number for pharmaceutical products in foreign trade	T610C
46	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	T604F
47	WZOLL	☐	WZOLL	GRWRT	CURR	13	2	Customs val. in doc.currency in imp.procg for foreign trade
48	VERLD	☐	VERLD	LAND1	CHAR	3	0	Country of dispatch for Foreign Trade	T005
49	HANLD	☐	HANLD	LAND1	CHAR	3	0	Trading country for foreign trade	T005
50	TEXT1	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
51	TEXT2	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
52	TEXT3	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
53	COKON	☐	COKON	COKON	CHAR	6	0	Customs quota code for import processing in foreign trade	T610K
54	COPHA	☐	COPHA	COPHA	CHAR	6	0	Pharmaceutical products code (Foreign Trade)	T610D
55	COADI	☐	COADI	COADI	CHAR	6	0	Anti-dumping code for import processing in foreign trade	T610A
56	PRONU	☐	PRONU	PRONU	CHAR	25	0	Invoice: Number of invoice document for import processing
57	PRODA	☐	PRODA	DATUM	DATS	8	0	Invoice: Date of invoice document for import processing
58	VORPA	☐	VORPA	VORPA	CHAR	10	0	Preliminary document: Document type for foreign trade procg	T610VA
59	VORNU	☐	VORNU	CHAR25	CHAR	25	0	Preliminary document: No. of preliminary doc.f.import procg
60	VORDA	☐	VORDA	DATUM	DATS	8	0	Preliminary document: Date of preliminary doc.f.import procg
61	BEHOE	☐	VOHOE	BEHOE	CHAR	10	0	Preliminary doc.: Issuing authority of relevant prelim.doc.	T610O
62	KENNU	☐	KENNU	CHAR06	CHAR	6	0	Preliminary document: Customs office/ID number for import
63	VOISO	☐	VOISO	INTCA	CHAR	2	0	Prelim. doc.: ISO code of ctry issuing the preliminary doc.
64	PREFA	☐	PREFA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
65	PREFN	☐	PREFN	CHAR25	CHAR	25	0	Preference: Official number of preference document - Import
66	PREDU	☐	PREDU	DATUM	DATS	8	0	Preference: Date of preference document for import procg
67	PRISO	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
68	PRHOE	☐	PRHOE	BEHOE	CHAR	10	0	Preference: Issuing authoritiy for relevant preference doc.	T610O
69	PRUEL	☐	PRUEL	DATUM	DATS	8	0	Preference: Validity date of preference document for import
70	NACAR	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
71	NACNU	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
72	NACDA	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
73	NAISO	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
74	NAHOE	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
75	NAUEL	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
76	NACA2	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
77	NACN2	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
78	NACD2	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
79	NAIS2	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
80	NAHO2	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
81	NAUE2	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
82	NACA3	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
83	NACN3	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
84	NACD3	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
85	NAIS3	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
86	NAHO3	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
87	NAUE3	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
88	NACA4	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
89	NACN4	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
90	NACD4	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
91	NAIS4	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
92	NAHO4	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
93	NAUE4	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
94	NACA5	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
95	NACN5	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
96	NACD5	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
97	NAIS5	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
98	NAHO5	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
99	NAUE5	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
100	EXDAR	☐	EXDAR	VORPA	CHAR	10	0	Export document: Export document type for foreign trade	T610VA
101	EXDAA	☐	EXDAA	CHAR25	CHAR	25	0	Export document: Official number of export document
102	EXDAB	☐	EXDAB	CHAR25	CHAR	25	0	Export document: Valid-to number of export document
103	EXDTA	☐	EXDTA	VORPA	CHAR	10	0	T document: Type of T document for foreign trade	T610VA
104	EXDT2	☐	EXDT2	CHAR25	CHAR	25	0	T document: Official number of T document for foreign trade
105	EXDTB	☐	EXDTB	CHAR25	CHAR	25	0	T doc.: Official no. for next page of T doc. f.foreign trade
106	EXDPA	☐	EXDPA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
107	EXPRE	☐	EXPRE	CHAR25	CHAR	25	0	Preference: Official number of preference document - Export
108	EXDT5	☐	EXDT5	CHAR25	CHAR	25	0	CAP: Official number of T5 document for foreign trade
109	AUSOK	☐	AUSOK	XFELD	CHAR	1	0	Status: Document data in foreign trade complete (system)
110	COIMP	☐	COIMP	STAWN	CHAR	17	0	Code number for import processing in foreign trade	T604
111	HERSE	☐	HERSE	LIFNR	CHAR	10	0	Manufacturer number for import processing in foreign trade	LFA1
112	COBLD	☐	COBLD	STAWN	CHAR	17	0	Import code no. in destination country for foreign trade	T604
113	EIOKW	☐	EIOKW	EIOKW	CHAR	1	0	Status: Complete document data in foreign trade (user)
114	EIOKA	☐	EIOKA	EIOKW	CHAR	1	0	EDI: Export/Import customs tariff number for foreign trade
115	GBNUM	☐	GB_NR	CHAR20	CHAR	20	0	Foreign Trade:Customs declaration list no. for Foreign Trade
116	RGNNR	☐	RG_NR	CHAR20	CHAR	20	0	Registration number for import processing in foreign trade
117	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
118	PRENO	☐	PRENN	PRENN	CHAR	8	0	Exemption certificate number for legal control
119	PREND	☐	PREND	PREND	DATS	8	0	Exemption certificate: Issue date of exemption certificate
120	KTNUM	☐	KTPLN	KTPLN	CHAR	10	0	Quota or Ceiling Number for Import Processing	T610KP
121	PLNUM	☐	KTPLN	KTPLN	CHAR	10	0	Quota or Ceiling Number for Import Processing	T610KP
122	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
123	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
124	.INCLUDE	☐				0	0	Table for Update Indicators
125	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
126	COLOR	☐	SL_COLOR	SL_COLOR	CHAR	3	0	Foreign Trade: SLS - Field determining line color

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTJOUR_PO	BEHOE	T610O	BEHOE	REF	1	CN
2	FTJOUR_PO	CASNR	T610C	CASNR	REF	1	CN
3	FTJOUR_PO	COADI	T610A	COADI	REF	1	CN
4	FTJOUR_PO	COBLD	T604	STAWN	REF	1	CN
5	FTJOUR_PO	COIMP	T604	STAWN	REF	1	CN
6	FTJOUR_PO	COKON	T610K	COKON	REF	1	CN
7	FTJOUR_PO	COPHA	T610D	COPHA	REF	1	CN
8	FTJOUR_PO	EXART	T605	EXART
9	FTJOUR_PO	EXDAR	T610VA	VORPA	REF	1	CN
10	FTJOUR_PO	EXDPA	T610PA	PREFA	REF	1	CN
11	FTJOUR_PO	EXDTA	T610VA	VORPA	REF	1	CN
12	FTJOUR_PO	EXNUM	EIKP	EXNUM
13	FTJOUR_PO	EXPRF	T616	EXPRF
14	FTJOUR_PO	GPNUM	T609G	GPNUM	REF	1	CN
15	FTJOUR_PO	HANLD	T005	LAND1	REF	1	CN
16	FTJOUR_PO	HERKL	T005	LAND1
17	FTJOUR_PO	HERKR	T005S	BLAND
18	FTJOUR_PO	HERSE	LFA1	LIFNR	REF	C	CN
19	FTJOUR_PO	KTNUM	T610KP	KTPLN		1	CN
20	FTJOUR_PO	MANDT	T000	MANDT
21	FTJOUR_PO	MOGRU	T618G	MOGRU	REF	1	CN
22	FTJOUR_PO	MOWNR	T618M	MOWNR	REF	1	CN
23	FTJOUR_PO	NACA2	T610NA	NACAR	REF	1	CN
24	FTJOUR_PO	NACA3	T610NA	NACAR	REF	1	CN
25	FTJOUR_PO	NACA4	T610NA	NACAR	REF	1	CN
26	FTJOUR_PO	NACA5	T610NA	NACAR	REF	1	CN
27	FTJOUR_PO	NACAR	T610NA	NACAR	REF	1	CN
28	FTJOUR_PO	NAHO2	T610O	BEHOE	REF	1	CN
29	FTJOUR_PO	NAHO3	T610O	BEHOE	REF	1	CN
30	FTJOUR_PO	NAHO4	T610O	BEHOE	REF	1	CN
31	FTJOUR_PO	NAHO5	T610O	BEHOE	REF	1	CN
32	FTJOUR_PO	NAHOE	T610O	BEHOE	REF	1	CN
33	FTJOUR_PO	PLNUM	T610KP	KTPLN		1	CN
34	FTJOUR_PO	PREFA	T610PA	PREFA	REF	1	CN
35	FTJOUR_PO	PREFPACOD	T604C	PREFPACOD	REF	C	CN
36	FTJOUR_PO	PRHOE	T610O	BEHOE	REF	1	CN
37	FTJOUR_PO	SEGAL	T609A	SEGAL	REF	1	CN
38	FTJOUR_PO	STAWN	T604	STAWN
39	FTJOUR_PO	STEUC	T604F	STEUC	REF	1	CN
40	FTJOUR_PO	VERLD	T005	LAND1	REF	1	CN
41	FTJOUR_PO	VORPA	T610VA	VORPA	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in