SAP ABAP Table CRMT_DLV_HEAD_R3 (Header delivery data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BE-DL (Application Component) Billing Due List
⤷ CRM_DLV (Package) Connection of Logistics Execution to CRM
⤷ CRM-BE-DL (Application Component) Billing Due List
⤷ CRM_DLV (Package) Connection of Logistics Execution to CRM
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_DLV_HEAD_R3 | Table Relationship Diagram |
Short Description | Header delivery data |
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 | .INCLUDE | 0 | 0 | Sales Document: Header Data for Delivery | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | DELIV_NUMB | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | ||
4 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
5 | REC_TIME | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
6 | REC_DATE | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
7 | SALES_DIST | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
8 | SHIP_POINT | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | ||
9 | SALESORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
10 | DLV_TYPE | LFART | LFART | CHAR | 4 | 0 | Delivery Type | * | |
11 | COMPL_DLV | AUTLF | XFELD | CHAR | 1 | 0 | Complete delivery defined for each sales order? | ||
12 | ORDER_COMP | KZAZU_D | XFELD | CHAR | 1 | 0 | Order combination indicator | ||
13 | GI_DATE_PLAN | WADAK | DATUM | DATS | 8 | 0 | Planned goods movement date | ||
14 | LOAD_DATE | LDDAT | DATUM | DATS | 8 | 0 | Loading Date | ||
15 | TP_DATE | TDDAT_D | DATUM | DATS | 8 | 0 | Transportation Planning Date | ||
16 | DLV_DATE | LFDAT_V | DATUM | DATS | 8 | 0 | Delivery Date | ||
17 | PICK_DATE | KODAT | DATUM | DATS | 8 | 0 | Picking Date | ||
18 | UNLOAD_PT | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
19 | INCOTERMS1 | INCO1 | CRM_INCOTERMS1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
20 | INCOTERMS2 | INCO2 | CRM_INCOTERMS2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
21 | EXPORT_IND | EXPKZ | EXPKZ | CHAR | 1 | 0 | Export indicator | ||
22 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | ||
23 | BILL_BLOCK | FAKSK | FAKSP | CHAR | 2 | 0 | Billing block in SD document | * | |
24 | DLV_BLOCK | LIFSK | LIFSP | CHAR | 2 | 0 | Delivery block (document header) | * | |
25 | SD_DOC_CAT | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
26 | FAC_CALEND | KNFAK | WFCID | CHAR | 2 | 0 | Customer factory calendar | * | |
27 | DLV_PRIO | LPRIO | LPRIO | NUMC | 2 | 0 | Delivery priority | ||
28 | SHIP_COND | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | * | |
29 | SHIP_TO | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
30 | SOLD_TO | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
31 | CUST_GROUP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | ||
32 | TOTAL_WGHT | GSGEW | MENG15 | QUAN | 15 | 3 | Total Weight | ||
33 | NET_WEIGHT | NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
34 | UNIT_OF_WT | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
35 | UNIT_OF_WT_ISO | GEWEI_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of weight in ISO code | * | |
36 | VOLUME | VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
37 | VOLUMEUNIT | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
38 | VOLUMEUNIT_ISO | VOLEH_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Volume unit in ISO code | * | |
39 | NOSHPUNITS | ANZPK | ANZPK | NUMC | 5 | 0 | Total number of packages in delivery | ||
40 | PICK_ITEMS_LOC | BEROT | BEROT | CHAR | 20 | 0 | Picked items location | ||
41 | DLV_TIME | LFUHR | LFUHR | TIMS | 6 | 0 | Time of delivery | ||
42 | WEIGHT_GRP_DLV | GRULG | GRULG | CHAR | 4 | 0 | Weight group for delivery (To group) | * | |
43 | LOADING_PT | LSTEL | LSTEL | CHAR | 2 | 0 | Loading Point | * | |
44 | TRANS_GRP | TRAGR | TRAGR | CHAR | 4 | 0 | Transportation Group | * | |
45 | BILL_TYPE_PROP | FKARV | FKART | CHAR | 4 | 0 | Proposed billing type for a delivery-related billing doc. | * | |
46 | BILL_DATE | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
47 | BILL_SCHED | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | * | |
48 | ROUTE_ORD | ROUTE | ROUTE | CHAR | 6 | 0 | Route | ||
49 | UPDATE_GRP | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
50 | PROCEDURE | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | * | |
51 | CONDITION | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
52 | CURRENCY | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
53 | CURRENCY_ISO | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
54 | SALES_OFF | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
55 | SHIP_PROC_TIME | VBEAK | DEC4_2 | DEC | 6 | 2 | Shipping processing time for the entire document | ||
56 | COMP_CRIT_DLV | DZUKRL | CHAR40 | CHAR | 40 | 0 | Combination criteria for delivery | ||
57 | TRANS_CENTR | VERUR_VL | CHAR35 | CHAR | 35 | 0 | Distribution delivery | ||
58 | COMM_NO | CRMT_COMMN | CRM_COMMN | CHAR | 5 | 0 | Communication number for Q-API interface | ||
59 | CURRENCY_STAT | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
60 | CURRENCY_STAT_ISO | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
61 | EXCHRATEST | STCUR | KURRF | DEC | 9 | 5 | Exchange rate for statistics | ||
62 | EXPORT_NO | EXNUM | EXNUM | CHAR | 10 | 0 | Number of foreign trade data in MM and SD documents | * | |
63 | CH_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
64 | WHSE_NO | LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | * | |
65 | ONE_WAREH_DLV | LNSPL_LIKP | LNSPL_LIKP | CHAR | 1 | 0 | Delivery within one warehouse | ||
66 | SALESORG_IB | VKOIV | VKORG | CHAR | 4 | 0 | Sales organization for intercompany billing | * | |
67 | DISTR_CHAN_IB | VTWIV | VTWEG | CHAR | 2 | 0 | Distribution channel for intercompany billing | * | |
68 | DIVISION_IB | SPAIV | SPART | CHAR | 2 | 0 | Division for intercompany billing | ||
69 | BILL_TYPE_IB | FKAIV | FKART | CHAR | 4 | 0 | Billing type for intercompany billing | * | |
70 | DATE_IB | CRMT_PIOIV | WFCID | CHAR | 2 | 0 | Date for intercompany billing | * | |
71 | BILL_DATE_IB | CRMT_FKDIV | DATUM | DATS | 8 | 0 | Billing date for intercompany billing | ||
72 | CUSTOMER_IB | KUNIV | KUNNR | CHAR | 10 | 0 | Customer number for intercompany billing | * | |
73 | C_CTR_AREA | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | * | |
74 | CRED_ACCNT | KNKLI | KUNNR | CHAR | 10 | 0 | Customer's account number with credit limit reference | * | |
75 | CRED_GROUP | GRUPP_CM | GRUPP_CM | CHAR | 4 | 0 | Customer credit group | * | |
76 | REPR_GROUP | SBGRP_CM | SBGRP_CM | CHAR | 3 | 0 | Credit Representative Group for Credit Management | * | |
77 | RISK_CATEG | CTLPC_CM | CTLPC_CM | CHAR | 3 | 0 | Credit management: Risk category | * | |
78 | CURRENCY_CM | WAERS_CM | WAERS | CUKY | 5 | 0 | Currency key of credit control area | * | |
79 | CURRENCY_CM_ISO | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
80 | REL_CRED_VALUE | AMTBL_CM | WERTV8 | CURR | 15 | 2 | Released credit value of the document | ||
81 | REL_CRED_VALUE_ISO | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
82 | BILLOFLADING | BOLNR | CHAR35 | CHAR | 35 | 0 | Bill of lading | ||
83 | VENDOR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
84 | TRANS_CAT | CRMT_TRATY | CHAR4 | CHAR | 4 | 0 | Means-of-Transport Type | ||
85 | TRANSP_ID | TRAID | TRAID | CHAR | 20 | 0 | Means-of-transport ID | ||
86 | REL_DATE_CM | CMFRE | DATUM | DATS | 8 | 0 | Release date of the document determined by credit management | ||
87 | NEXT_SHP_DATE | CMNGV | DATUM | DATS | 8 | 0 | Next date | ||
88 | GR_GI_SLIP_NO | XABLN | BELNR | CHAR | 10 | 0 | Goods receipt/issue slip number | ||
89 | GI_DATE_ACT | WADAT_IST | DATUM | DATS | 8 | 0 | Actual Goods Movement Date | ||
90 | SHIP_BLOCK_REA | CRMT_TRSPG | CRM_TRSPG | CHAR | 2 | 0 | Shipment blocking reason | ||
91 | EXT_DLV_SYS_ID | CRMT_TPSID | CRM_COMMN | CHAR | 5 | 0 | ID for external transport system | ||
92 | EXTDELV_NO | CRMT_LIFEX | TEXT35 | CHAR | 35 | 0 | External identification of delivery note | ||
93 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
94 | SEARCH_PR_BATCH | KALSMA_CH | KALSM | CHAR | 6 | 0 | Search procedure for batch determination | * | |
95 | CORR_DLV | CRMT_KLIEF | XFELD | CHAR | 1 | 0 | Correction delivery | ||
96 | PROCEDURE_SHP | CRMT_KALSP | KALSM | CHAR | 6 | 0 | Shipping: Pricing procedure | * | |
97 | CONDITION_DLV | CRMT_KNUMP | KNUMV | CHAR | 10 | 0 | Number of document condition - pricing | ||
98 | ROUTESCHED | AULWE | AULWE | CHAR | 10 | 0 | Route Schedule | * | |
99 | RECEIV_PLANT | CRMT_EMPFW | WERKS | CHAR | 4 | 0 | Receiving plant for deliveries | * | |
100 | FIN_DOC_IN | LCNUM | LCNUM | CHAR | 10 | 0 | Financial doc. processing: Internal financial doc. number | * | |
101 | PAY_GUAR_PROC | ABSSCHE_CM | ABSSCHE_CM | CHAR | 6 | 0 | Payment Guarantee Procedure | ||
102 | PICK_TIME | CRMT_KOUHR | TIME_PLANT | TIMS | 6 | 0 | Picking time (local time, with reference to a plant) | ||
103 | TP_TIME | TDUHR | TIME_SHIPP | TIMS | 6 | 0 | Transp. Planning Time (Local, Relating to a Shipping Point) | ||
104 | LOAD_TIME | LDUHR | TIME_SHIPP | TIMS | 6 | 0 | Loading Time (Local Time Relating to a Shipping Point) | ||
105 | GI_TIME | WAUHR | TIME_PLANT | TIMS | 6 | 0 | Time of Goods Issue (Local, Relating to a Plant) | ||
106 | DOOR | CRMT_LGTOR | CRM_LGTOR | CHAR | 3 | 0 | Door for warehouse number | ||
107 | MAT_STAG_AREA | CRMT_LGBZO | CRM_LGBZO | CHAR | 10 | 0 | Material staging area for warehouse number | ||
108 | CURRENCY_LOC | AKWAE | WAERS | CUKY | 5 | 0 | Currency key for letter-of-credit procg in foreign trade | * | |
109 | CURRENCY_LOC_ISO | WAERS_ISO | ISOCD | CHAR | 3 | 0 | ISO code currency | ||
110 | EXCH_RATE_LOC | AKKUR | KURRF | DEC | 9 | 5 | Exchange rate for letter-of-credit procg in foreign trade | ||
111 | DEPR_PRC_LOC | AKPRZ | PRZ32 | DEC | 5 | 2 | Depreciation percentage for financial document processing | ||
112 | DANG_GOODS_PROF | CRMT_ADGE_PROLI | CRM_ADGD_PROLI | CHAR | 3 | 0 | Profile for dangerous goods indicator in SD documents | ||
113 | REF_DOC_NO | CRMT_XBLNR_LIKP | CRM_XBLNR_LIKP | CHAR | 25 | 0 | Reference Document Number | ||
114 | UPDATE_IND | UPDKZ_D | UPDKZ | CHAR | 1 | 0 | Update indicator | ||
115 | NET_VAL_HD | NETWR_AK | WERTV8 | CURR | 15 | 2 | Net Value of the Sales Order in Document Currency | ||
116 | NET_VAL_HD_ISO | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
117 | UID_DLV | CRMT_TSEGGUID_LIKP | SYSUUID_22 | CHAR | 22 | 0 | Worldwide unique key for LIKP-VBELN | ||
118 | TIMESEG_EXISTS | CRMT_TSEGEXISTS | FLAG | CHAR | 1 | 0 | Time segment exists | ||
119 | TIMESEG_TEMPL | CRMT_TSEGTPLLIK | TSEGTEMPLA | CHAR | 10 | 0 | Event group time segment delivery header | * | |
120 | TIMEZONE_DLV | CRMT_TSEGZONISS | TZNZONE | CHAR | 6 | 0 | Time zone of delivering location | * | |
121 | TIMEZONE_REC | CRMT_TSEGZONREC | TZNZONE | CHAR | 6 | 0 | Time Zone of Receiving Location | * | |
122 | DANG_GOODS_IND | ADGE_NCDG | X | CHAR | 1 | 0 | Indicator: Document contains dangerous goods | ||
123 | ORIG_SYS_DLV | CRMT_VERURSYS | LOGSYS | CHAR | 10 | 0 | Distribution delivery: Original system | * | |
124 | GOOD_MOVE_IND | CRMT_KZWAB | CRM_KZWAB | CHAR | 1 | 0 | Indicator for controlling goods movement | ||
125 | DISTRIB_STATUS | VLSTK | VLSTK | CHAR | 1 | 0 | Distribution Status (Decentralized Warehouse Processing) | ||
126 | COMPANY_ID | VBUND | RCOMP | CHAR | 6 | 0 | Company ID | * | |
127 | CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
128 | DOC_DATE | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
129 | TRANS_CODE | TCODE | TCODE | CHAR | 20 | 0 | Transaction Code | * | |
130 | SHP_TYPE | VSARTTR | VERSART | CHAR | 2 | 0 | Shipping type | * | |
131 | MEANS_OF_TRANS | TRMTYP | MATNR | CHAR | 18 | 0 | Means of Transportation | ||
132 | SPEC_PROC_IND | SDABW | SDABW | CHAR | 4 | 0 | Special Processing Indicator | * | |
133 | VAL_CALC_OPEN | XWOFF | XFELD | CHAR | 1 | 0 | Calculation of val. open | ||
134 | AUT_TO_CREAT | CRMT_LVS_DIRTA | XFELD | CHAR | 1 | 0 | Automatic TO creation immediately after TR generation | ||
135 | SUPPLYAREA | PRVBE | PRVBE | CHAR | 10 | 0 | Production Supply Area | * | |
136 | DLV_TYPE_SUCC | LFART | LFART | CHAR | 4 | 0 | Delivery Type | * | |
137 | POD_DATE | CRMT_PODAT | DATUM | DATS | 8 | 0 | Date (proof of delivery) | ||
138 | POD_TIME | CRMT_POTIM | CRM_TIME_PLANT | TIMS | 6 | 0 | Local time | ||
139 | GEOROUTE | CRMT_ROUTE_ID | CHAR10 | CHAR | 10 | 0 | Description of Geographical Route | ||
140 | GEOROUTE_SRC | CRMT_ROUTE_IND | CHAR1 | CHAR | 1 | 0 | Indicator for Change to Route | ||
141 | CARRIER_IND | CRMT_CARRIER_IND | CHAR1 | CHAR | 1 | 0 | Indicator for Changing the Carrier | ||
142 | GTS_RELEVANCE | CRMT_LEG_GTS_CODE | CRM_LEG_GTS_CODE | CHAR | 2 | 0 | Relevant for Global Trade | ||
143 | GTS_ROUTE_CD | CRMT_ROUTE_GTS_CODE | CHAR10 | CHAR | 10 | 0 | Route Code for Global Trade | ||
144 | DIRECT_BILLING | CRMT_DIRECT_BILLING | CHAR1 | CHAR | 1 | 0 | Indicator Direct Billing | ||
145 | IBGI_STATUS | CRMT_IBGI_STATUS | CHAR1 | CHAR | 1 | 0 | Indicator for Billing Document Creation Before Goods Issue | ||
146 | PRINTER_PROF | CRMT_DRUCK_PROFIL_ID | CRM_DPROFIL_ID | CHAR | 10 | 0 | Description of Print Profile | ||
147 | TRNSP_MODE | CRM_FT_MOTAB | CRM_FT_MOTAB | CHAR | 1 | 0 | Mode of Transport at the Border (Intrastat Code) |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 300 |