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
⤷ 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 |