SAP ABAP Table CDBD_DELIVERY_H (Table for storing the delivery header details)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_DELIVERY_H	Table Relationship Diagram
Short Description	Table for storing the delivery header details

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	*
2	DELIVERY_H_GUID	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery
4	DLV_TYPE	☐	LFART	LFART	CHAR	4	0	Delivery Type	*
5	CREATED_BY	☐	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
6	CR_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	CHANGED_BY	☐	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
8	CH_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
9	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
10	NET_WEIGHT	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
11	CONT_DG	☐	ADGE_NCDG	X	CHAR	1	0	Indicator: Document contains dangerous goods
12	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
13	LOAD_DATE	☐	LDDAT	DATUM	DATS	8	0	Loading Date
14	SHIP_POINT	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
15	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
16	SHIP_TO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
17	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
18	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
19	NAME_2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
20	CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
21	POSTL_CODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
22	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
23	TOTAL_WGHT	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
24	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
25	VOLUME	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
26	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
27	REQ_PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
28	REQ_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
29	REQ_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
30	SUPPL_PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
31	SUPPL_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
32	SUPPL_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
33	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
34	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route
35	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
36	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
37	ROUTBEZ	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
38	TRAZTD	☐	TRAZTD	TSTRDURAG	DEC	11	0	Transit duration in calendar days
39	FAHZTD	☐	FAHZTD	TSTRDURAN	DEC	11	0	Travel duration as actual time (hours/minutes)
40	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
41	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
42	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
43	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
44	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
45	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
46	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

History

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