SAP ABAP Table CRMT_COMPL_DELIVERY (Delivery Data)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-BTX-COM (Application Component) Complaints / Returns / In-House Repair
⤷

CRM_COMPLAINT (Package) Complaints

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_COMPL_DELIVERY	Table Relationship Diagram
Short Description	Delivery Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Delivery from R/3:Corresponds Exactly to R/3 LIPOV Structure
2	VBELN	VBELN_VL	VBELN	CHAR	10	0	Delivery
3	POSNR	POSNR_VL	POSNR	NUMC	6	0	Delivery Item
4	SELKZ	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
5	MARK	CHAR_132		CHAR	132	0	Text of length 132
6	ARKTX	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
7	MATNR	MATNR	MATNR	CHAR	18	0	Material Number
8	S_MTART	MTART	MTART	CHAR	4	0	Material type	*
9	LADGR	LADGR	LADGR	CHAR	4	0	Loading Group	*
10	LFART	LFART	LFART	CHAR	4	0	Delivery Type	*
11	LPRIO	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	*
12	VSTEL	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
13	LSTEL	LSTEL	LSTEL	CHAR	2	0	Loading Point	*
14	BEROT	BEROT	BEROT	CHAR	20	0	Picked items location
15	LFDAT	LFDAT	DATUM	DATS	8	0	Delivery date
16	LFUHR	LFUHR	LFUHR	TIMS	6	0	Time of delivery
17	LDDAT	LDDAT	DATUM	DATS	8	0	Loading Date
18	S_LDUHR	LDUHR	TIME_SHIPP	TIMS	6	0	Loading Time (Local Time Relating to a Shipping Point)
19	WADAT	WADAT	DATUM	DATS	8	0	Goods Issue Date
20	S_WAUHR	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
21	TDDAT	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
22	S_TDUHR	TDUHR	TIME_SHIPP	TIMS	6	0	Transp. Planning Time (Local, Relating to a Shipping Point)
23	KODAT	KODAT	DATUM	DATS	8	0	Picking Date
24	S_KOUHR	CRMT_KOUHR	TIME_PLANT	TIMS	6	0	Picking time (local time, with reference to a plant)
25	MBDAT	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
26	ROUTE	ROUTE	ROUTE	CHAR	6	0	Route
27	LFIMG	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
28	VRKME	VRKME	MEINS	UNIT	3	0	Sales unit	*
29	S_LGMNG	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
30	S_MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
31	BRGEW	GSGEW	MENG15	QUAN	15	3	Total Weight
32	NTGEW	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
33	GEWEI	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
34	VOLUM	VOLUM_15	MENG15	QUAN	15	3	Volume
35	VOLEH	VOLEH	MEINS	UNIT	3	0	Volume unit	*
36	ANZPK	NUMC5	NUM5	NUMC	5	0	5 Character Numeric NUMC
37	VBEAK	SWFP6_0DEC		DEC	6	0	Decimal Number, Length 6 Without Decimal Places
38	VBEAF	CRMT_DEC5	DEC5	DEC	5	0	dec5
39	VBEAV	CRMT_DEC5	DEC5	DEC	5	0	dec5
40	PIKMG	MENGV13	MENGV13	QUAN	13	3	Quantity field, length 13, with +/- sign
41	UMVKZ	CRMT_DEC5	DEC5	DEC	5	0	dec5
42	UMVKN	CRMT_DEC5	DEC5	DEC	5	0	dec5
43	FAKSP	FAKSP	FAKSP	CHAR	2	0	Lock	*
44	KUNNR	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
45	NAME_WE	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
46	ORT01_WE	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
47	KUNAG	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
48	NAME_AG	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
49	ORT01_AG	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
50	SPDNR	SPDNR	LIFNR	CHAR	10	0	Carrier	*
51	NAME_SP	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
52	ORT01_SP	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
53	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
54	NAME_LI	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
55	ORT01_LI	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
56	PARVW	PARVW	PARVW	CHAR	2	0	Partner Role	*
57	PARTN	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
58	NAME_PA	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
59	ORT01_PA	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
60	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
61	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
62	SPART	SPART	SPART	CHAR	2	0	Division
63	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
64	EBELN	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
65	LIFEX	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
66	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
67	EXIDV	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
68	TRATY	CRMT_TRATY	CHAR4	CHAR	4	0	Means-of-Transport Type
69	TRAID	TRAID	TRAID	CHAR	20	0	Means-of-transport ID
70	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
71	KOSTA	KOSTA	STATV	CHAR	1	0	Picking Status/Putaway Status
72	LVSTA	LVSTA	STATV	CHAR	1	0	Status of warehouse management activities
73	WBSTA	WBSTA	STATV	CHAR	1	0	Goods movement status
74	KOSTK	KOSTK	STATV	CHAR	1	0	Overall picking / putaway status
75	LVSTK	LVSTK	STATV	CHAR	1	0	Overall status of warehouse management activities
76	KOQUK	KOQUK	STATV	CHAR	1	0	Status of pick confirmation
77	WBSTK	WBSTK	STATV	CHAR	1	0	Total goods movement status
78	BESTK	BESTK	STATV	CHAR	1	0	Confirmation status
79	S_IMWRK	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
80	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
81	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location
82	LGNUM	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
83	LGTYP	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
84	LGPLA	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
85	KZDLG	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
86	LGPBE	LGPBE	CHAR10	CHAR	10	0	Storage Bin
87	S_LGTOR	CHAR3	CHAR3	CHAR	3	0	3-Byte field
88	S_LGBZO	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
89	ACTIV	CHAR2	CHAR2	CHAR	2	0	Version Number Component
90	KOMAU	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
91	KOMAUART	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
92	KZFME	KZFME	KZFME	CHAR	1	0	ID: Leading unit of measure for completing a transaction
93	COLOR	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
94	PROC_STATUS	BEA_PROCESS_STATUS	BEA_PROCESS_STATUS	CHAR	1	0	Processing Status
95	HUPOS	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
96	SELMETH	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
97	ANZPOS	INT4	INT4	INT4	10	0	Natural number
98	S_PSTYV	PSTYV_VL	PSTYV	CHAR	4	0	Delivery item category
99	S_VGTYP	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
100	S_VGBEL	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
101	S_VGPOS	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
102	S_CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number
103	S_SOBKZ	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
104	S_BESTQ	BESTQ	BESTQ	CHAR	1	0	Stock Category in the Warehouse Management System
105	S_SONUM	LVS_SONUM	LVS_SONUM	CHAR	16	0	Special Stock Number
106	S_BWLVS	BWLVS	BWLVS	NUMC	3	0	Movement Type for Warehouse Management	*
107	S_BWART	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
108	S_AKTNR	WAKTION	WAKTION	CHAR	10	0	Promotion
109	COUNTER	CRMT_APO_COUNTER	CRM_APO_COUNTER	INT4	10	0	Internal Counter
110	DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
111	VGBEL	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
112	VGPOS	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
113	.INCLUDE				0	0	Data Delivery: Mapped CRM Data to R/3 Data (Partn., Prod.)
114	SOLD_TO_GUID	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
115	SHIP_TO_GUID	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
116	PRODUCT_ID	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
117	PRODUCT_GUID	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product