SAP ABAP Table CRMS_FT_WLEN_EXT_S (Worklist GTS Intrastat (Copy of /ECRS/WLEN_EXT_S))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BE (Application Component) Billing
     ⤷ BEA_SLL (Package) BE Application - Service - Foreign Trade Connection

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_FT_WLEN_EXT_S	Table Relationship Diagram
Short Description	Worklist GTS Intrastat (Copy of /ECRS/WLEN_EXT_S)

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	GDSRC	☐	CRM_FT_GDSRC	LOGSYS	CHAR	10	0	Goods Movement Document: Source System	*
2	GDOBT	☐	CRM_FT_GDOBT	BEA_OBJTYPE	CHAR	10	0	Goods Movement Document: Object Type
3	GDOBK	☐	CRM_FT_GDOBK	CRM_FT_OBKEY	CHAR	40	0	Goods Movement Document: Object Key
4	GDOBI	☐	CRM_FT_GDOBI	NUMC10	NUMC	10	0	Goods Movement Document: Item Number
5	IDSRC	☐	CRM_FT_IDSRC	LOGSYS	CHAR	10	0	Invoice Document: Source System	*
6	IDOBT	☐	CRM_FT_IDOBT	BEA_OBJTYPE	CHAR	10	0	Invoice Document: Object Type
7	IDOBK	☐	CRM_FT_IDOBK	CRM_FT_OBKEY	CHAR	40	0	Invoice Document: Object Key
8	IDOBI	☐	CRM_FT_IDOBI	NUMC10	NUMC	10	0	Invoice Document: Item Number
9	CDSRC	☐	CRM_FT_CDSRC	LOGSYS	CHAR	10	0	Change Document:: Source System	*
10	CDOBT	☐	CRM_FT_CDOBT	BEA_OBJTYPE	CHAR	10	0	Change Document:: Object Type
11	CDOBK	☐	CRM_FT_CDOBK	CRM_FT_OBKEY	CHAR	40	0	Change Document: Object Key
12	CDOBI	☐	CRM_FT_CDOBI	NUMC10	NUMC	10	0	Change Document: Item Number
13	CNSRC	☐	CRM_FT_CNSRC	LOGSYS	CHAR	10	0	Cancellation Document: Source System	*
14	CNOBT	☐	CRM_FT_CNOBT	BEA_OBJTYPE	CHAR	10	0	Cancellation Document: Object Type
15	CNOBK	☐	CRM_FT_CNOBK	CRM_FT_OBKEY	CHAR	40	0	Cancellation Document: Object Key
16	CNOBI	☐	CRM_FT_CNOBI	NUMC10	NUMC	10	0	Cancellation Document: Item Number
17	GFLOW	☐	CRM_FT_GFLOW	CRM_FT_GFLOW	CHAR	1	0	Flow of Goods
18	ENTYP	☐	CRM_FT_ENTYP	CRM_FT_ENTYP	CHAR	1	0	Type of Entry in Worklist
19	GDDAT	☐	CRM_FT_GDDAT	DATS	DATS	8	0	Date of Goods Movement Document
20	IDDAT	☐	CRM_FT_IDDAT	DATS	DATS	8	0	Date of Invoice Document
21	CDDAT	☐	CRM_FT_CDDAT	DATS	DATS	8	0	Date of Change/Cancellation Document
22	ODSRC	☐	CRM_FT_ODSRC	LOGSYS	CHAR	10	0	Order/Purchase Order Document: Source System	*
23	ODOBT	☐	CRM_FT_ODOBT	BEA_OBJTYPE	CHAR	10	0	Order/Purchase Order Document: Object Type
24	ODOBK	☐	CRM_FT_ODOBK	CRM_FT_OBKEY	CHAR	40	0	Order/Purchase Order Document: Object Key
25	ODOBI	☐	CRM_FT_ODOBI	NUMC10	NUMC	10	0	Order/Purchase Order Document: Item Number
26	RPYEA	☐	CRM_FT_RPYEA	CRM_FT_RPYEA	NUMC	4	0	Declaration Year
27	RPMON	☐	CRM_FT_RPMON	CRM_FT_RPMON	CHAR	2	0	Declaration Month
28	POIVA	☐	CRM_FT_POIVA	CRM_FT_VATID	CHAR	20	0	VAT Registration Number of Provider of Information
29	POIAD	☐	CRM_FT_POIAD	CRM_FT_ADDNR	CHAR	5	0	Additional Number of Provider of Information
30	GFPIC	☐	CRM_FT_GFPIC	LAND1	CHAR	3	0	Country of Provider of Information (Flow of Goods) (Int.SAP)	T005
31	GFPIR	☐	CRM_FT_GFPIR	REGIO	CHAR	3	0	Region of Provider of Information (Flow of Goods) (Int. SAP)	T005S
32	VFPTT	☐	CRM_FT_VFPTT	CRM_FT_VFPTT	CHAR	1	0	Partner Type (Value Flow)
33	VFPTV	☐	CRM_FT_VFPTV	CRM_FT_VATID	CHAR	20	0	Partner VAT Registration Number (Value Flow)
34	VFPTC	☐	CRM_FT_VFPTC	LAND1	CHAR	3	0	Partner Country (Value Flow) (Internal SAP Code)	T005
35	VFPTN	☐	CRM_FT_VFPTN	BU_PARTNER	CHAR	10	0	Partner Number (Value Flow)	BUT000
36	GFPTC	☐	CRM_FT_GFPTC	LAND1	CHAR	3	0	Partner Country (Flow of Goods) (Internal SAP Code)	T005
37	GFPTR	☐	CRM_FT_GFPTR	REGIO	CHAR	3	0	Region in Partner Country (Flow of Goods) (Int. SAP Code)	T005S
38	GFPTN	☐	CRM_FT_GFPTN	BU_PARTNER	CHAR	10	0	Partner Number (Flow of Goods)	BUT000
39	RETFL	☐	CRM_FT_RETFL	XFELD	CHAR	1	0	Indicator: Returns
40	TGLFL	☐	CRM_FT_TGLFL	XFELD	CHAR	1	0	Indicator: Triangular Transaction
41	COMCD	☐	CRM_FT_COMCD	CRM_FT_COMCD	CHAR	30	0	Commodity Code
42	PRNUM	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
43	PRDES	☐	CRM_FT_PRDES	TEXT60	CHAR	60	0	Product Description
44	CTYOO	☐	CRM_FT_CTYOO	LAND1	CHAR	3	0	Country of Origin (Internal SAP Code)	T005
45	REGOO	☐	CRM_FT_REGOO	REGIO	CHAR	3	0	Region of Origin (Internal SAP Code)	T005S
46	BTTYP	☐	CRM_FT_BTTYP	CRM_FT_BTTYP	CHAR	2	0	Business Transaction Type (Intrastat Code)
47	PRCDR	☐	CRM_FT_PRCDR	CRM_FT_PRCDR	CHAR	5	0	Statistical Procedure (Intrastat Code)
48	MOTAB	☐	CRM_FT_MOTAB	CRM_FT_MOTAB	CHAR	1	0	Mode of Transport at the Border (Intrastat Code)
49	PORTI	☐	CRM_FT_PORTI	CRM_FT_PORTI	CHAR	4	0	Port/Airport (Intrastat Code)
50	INCTM	☐	CRM_FT_INCTM	CHAR03	CHAR	3	0	Incoterms
51	SPMCO	☐	CRM_FT_SPMCO	CRM_FT_SPMCO	CHAR	2	0	Special Movement Code (Intrastat Code)
52	INVAL	☐	CRM_FT_INVAL	WERT15	CURR	15	2	Invoice Value
53	INCUR	☐	CRM_FT_INCUR	WAERS	CUKY	5	0	Currency Key for Invoice Value	TCURC
54	STVAL	☐	CRM_FT_STVAL	WERT15	CURR	15	2	Statistical Value
55	STCUR	☐	CRM_FT_STCUR	WAERS	CUKY	5	0	Currency Key for Statistical Value	TCURC
56	NTWEI	☐	CRM_FT_NTWEI	MENG13	QUAN	13	3	Net Weight
57	NWUOM	☐	CRM_FT_NWUOM	MEINS	UNIT	3	0	Unit of Measure for Net Weight	T006
58	SPQUA	☐	CRM_FT_SPQUA	MENG13	QUAN	13	3	Quantity in Supplementary Unit
59	SPUOM	☐	CRM_FT_SPUOM	MEINS	UNIT	3	0	Supplementary Unit	T006
60	DOQUA	☐	CRM_FT_DOQUA	MENG13	QUAN	13	3	Quantity in Document Unit of Measure
61	DOUOM	☐	CRM_FT_DOUOM	MEINS	UNIT	3	0	Document Unit of Measure	T006
62	BMQUA	☐	CRM_FT_BMQUA	MENG13	QUAN	13	3	Quantity in Base Unit of Measure
63	BMUOM	☐	CRM_FT_BMUOM	MEINS	UNIT	3	0	Base Unit of Measure	*
64	ORPYE	☐	CRM_FT_ORPYE	CRM_FT_RPYEA	NUMC	4	0	Declaration Year
65	ORPMO	☐	CRM_FT_ORPMO	CRM_FT_RPMON	CHAR	2	0	Declaration Month
66	ADDF1	☐	CRM_FT_ADDF1	CRM_FT_ADDF1	CHAR	5	0	Additional Field 1
67	ADDF2	☐	CRM_FT_ADDF2	CRM_FT_ADDF2	CHAR	10	0	Additional Field 2
68	ADDF3	☐	CRM_FT_ADDF3	CRM_FT_ADDF3	CHAR	15	0	Additional Field 3

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_FT_WLEN_EXT_S	CTYOO	T005	LAND1	KEY	1	CN
2	CRMS_FT_WLEN_EXT_S	DOUOM	T006	MSEHI	KEY	1	CN
3	CRMS_FT_WLEN_EXT_S	GFPIC	T005	LAND1	KEY	1	CN
4	CRMS_FT_WLEN_EXT_S	GFPIR	T005S	BLAND	KEY	1	CN
5	CRMS_FT_WLEN_EXT_S	GFPTC	T005	LAND1	KEY	1	CN
6	CRMS_FT_WLEN_EXT_S	GFPTN	BUT000	PARTNER	KEY	1	CN
7	CRMS_FT_WLEN_EXT_S	GFPTR	T005S	BLAND	KEY	1	CN
8	CRMS_FT_WLEN_EXT_S	INCUR	TCURC	WAERS	KEY	1	CN
9	CRMS_FT_WLEN_EXT_S	NWUOM	T006	MSEHI	KEY	1	CN
10	CRMS_FT_WLEN_EXT_S	REGOO	T005S	BLAND	KEY	1	CN
11	CRMS_FT_WLEN_EXT_S	SPUOM	T006	MSEHI	KEY	1	CN
12	CRMS_FT_WLEN_EXT_S	STCUR	TCURC	WAERS	KEY	1	CN
13	CRMS_FT_WLEN_EXT_S	VFPTC	T005	LAND1	KEY	1	CN
14	CRMS_FT_WLEN_EXT_S	VFPTN	BUT000	PARTNER	KEY	1	CN

History

Last changed by/on	SAP	20110909
SAP Release Created in	520