SAP ABAP Table E3CLIKP (SIS - delivery header data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ IDOCLOGISTICS (Package) IDoc Interface (logistics segment definitions)
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ IDOCLOGISTICS (Package) IDoc Interface (logistics segment definitions)
Basic Data
Table Category | INTTAB | Structure |
Structure | E3CLIKP | Table Relationship Diagram |
Short Description | SIS - delivery header 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 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
2 | VBELN | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
3 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
4 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
5 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
6 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
7 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | * | |
8 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
9 | LFART | LFART | LFART | CHAR | 4 | 0 | Delivery Type | * | |
10 | AUTLF | AUTLF | XFELD | CHAR | 1 | 0 | Complete delivery defined for each sales order? | ||
11 | KZAZU | KZAZU_D | XFELD | CHAR | 1 | 0 | Order combination indicator | ||
12 | WADAT | WADAK | DATUM | DATS | 8 | 0 | Planned goods movement date | ||
13 | LDDAT | LDDAT | DATUM | DATS | 8 | 0 | Loading Date | ||
14 | TDDAT | TDDAT_D | DATUM | DATS | 8 | 0 | Transportation Planning Date | ||
15 | LFDAT | LFDAT_V | DATUM | DATS | 8 | 0 | Delivery Date | ||
16 | KODAT | KODAT | DATUM | DATS | 8 | 0 | Picking Date | ||
17 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
18 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
19 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
20 | EXPKZ | EXPKZ | EXPKZ | CHAR | 1 | 0 | Export indicator | ||
21 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | * | |
22 | FAKSK | FAKSK | FAKSP | CHAR | 2 | 0 | Billing block in SD document | * | |
23 | LIFSK | LIFSK | LIFSP | CHAR | 2 | 0 | Delivery block (document header) | * | |
24 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
25 | KNFAK | KNFAK | WFCID | CHAR | 2 | 0 | Customer factory calendar | * | |
26 | TPQUA | TPQUA | TPQUA | CHAR | 1 | 0 | not currently in use | ||
27 | TPGRP | TPGRP | TPGRP | CHAR | 2 | 0 | not currently in use | ||
28 | LPRIO | LPRIO | LPRIO | NUMC | 2 | 0 | Delivery priority | * | |
29 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | * | |
30 | KUNNR | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
31 | KUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
32 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
33 | STZKL | STZKL | STZKL | DEC | 3 | 2 | Not Currently in Use | ||
34 | STZZU | STZZU | STZZU | DEC | 3 | 0 | not currently in use | ||
35 | BTGEW | GSGEW | MENG15 | QUAN | 15 | 3 | Total Weight | ||
36 | NTGEW | NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
37 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
38 | VOLUM | VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
39 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
40 | ANZPK | ANZPK | ANZPK | NUMC | 5 | 0 | Total number of packages in delivery | ||
41 | BEROT | BEROT | BEROT | CHAR | 20 | 0 | Picked items location | ||
42 | LFUHR | LFUHR | LFUHR | TIMS | 6 | 0 | Time of delivery | ||
43 | GRULG | GRULG | GRULG | CHAR | 4 | 0 | Weight group for delivery (To group) | * | |
44 | LSTEL | LSTEL | LSTEL | CHAR | 2 | 0 | Loading Point | * | |
45 | TRAGR | TRAGR | TRAGR | CHAR | 4 | 0 | Transportation Group | * | |
46 | FKARV | FKARV | FKART | CHAR | 4 | 0 | Proposed billing type for a delivery-related billing doc. | * | |
47 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
48 | PERFK | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | * | |
49 | ROUTA | ROUTE | ROUTE | CHAR | 6 | 0 | Route | * | |
50 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
51 | KALSM | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | * | |
52 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
53 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
54 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
55 | VBEAK | VBEAK | DEC4_2 | DEC | 6 | 2 | Shipping processing time for the entire document | ||
56 | ZUKRL | DZUKRL | CHAR40 | CHAR | 40 | 0 | Combination criteria for delivery | ||
57 | VERUR | VERUR_VL | CHAR35 | CHAR | 35 | 0 | Distribution delivery | ||
58 | COMMN | COMMN | COMMN | CHAR | 5 | 0 | Communication number for Q-API interface | * | |
59 | STWAE | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
60 | STCUR | STCUR | KURRF | DEC | 9 | 5 | Exchange rate for statistics | ||
61 | EXNUM | EXNUM | EXNUM | CHAR | 10 | 0 | Number of foreign trade data in MM and SD documents | * | |
62 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
63 | LGNUM | LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | * | |
64 | VKOIV | VKOIV | VKORG | CHAR | 4 | 0 | Sales organization for intercompany billing | * | |
65 | VTWIV | VTWIV | VTWEG | CHAR | 2 | 0 | Distribution channel for intercompany billing | * | |
66 | SPAIV | SPAIV | SPART | CHAR | 2 | 0 | Division for intercompany billing | * | |
67 | FKAIV | FKAIV | FKART | CHAR | 4 | 0 | Billing type for intercompany billing | * | |
68 | PIOIV | PIOIV | WFCID | CHAR | 2 | 0 | Date for intercompany billing | * | |
69 | FKDIV | FKDIV | DATUM | DATS | 8 | 0 | Billing date for intercompany billing | ||
70 | KUNIV | KUNIV | KUNNR | CHAR | 10 | 0 | Customer number for intercompany billing | * | |
71 | KKBER | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | * | |
72 | KNKLI | KNKLI | KUNNR | CHAR | 10 | 0 | Customer's account number with credit limit reference | * | |
73 | GRUPP | GRUPP_CM | GRUPP_CM | CHAR | 4 | 0 | Customer credit group | * | |
74 | SBGRP | SBGRP_CM | SBGRP_CM | CHAR | 3 | 0 | Credit Representative Group for Credit Management | * | |
75 | CTLPC | CTLPC_CM | CTLPC_CM | CHAR | 3 | 0 | Credit management: Risk category | * | |
76 | CMWAE | WAERS_CM | WAERS | CUKY | 5 | 0 | Currency key of credit control area | * | |
77 | AMTBL | AMTBL_CM | WERTV8 | CURR | 15 | 2 | Released credit value of the document | ||
78 | BOLNR | BOLNR | CHAR35 | CHAR | 35 | 0 | Bill of lading | ||
79 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
80 | TRATY | TRATY | TRATY | CHAR | 4 | 0 | Means-of-Transport Type | * | |
81 | TRAID | TRAID | TRAID | CHAR | 20 | 0 | Means-of-transport ID | ||
82 | CMFRE | CMFRE | DATUM | DATS | 8 | 0 | Release date of the document determined by credit management | ||
83 | CMNGV | CMNGV | DATUM | DATS | 8 | 0 | Next date | ||
84 | XABLN | XABLN | BELNR | CHAR | 10 | 0 | Goods receipt/issue slip number | ||
85 | WADAT_IST | WADAT_IST | DATUM | DATS | 8 | 0 | Actual Goods Movement Date | ||
86 | TRSPG | TRSPG | TRSPG | CHAR | 2 | 0 | Shipment Blocking Reason | * | |
87 | TPSID | TPSID | COMMN | CHAR | 5 | 0 | ID for external transport system | * | |
88 | LIFEX | LIFEX | TEXT35 | CHAR | 35 | 0 | External Identification of Delivery Note | ||
89 | TERNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
90 | KALSM_CH | KALSMA_CH | KALSM | CHAR | 6 | 0 | Search procedure for batch determination | * | |
91 | KLIEF | KLIEF | XFELD | CHAR | 1 | 0 | Correction delivery | ||
92 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
93 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
94 | LLAND | LLAND | LAND1 | CHAR | 3 | 0 | Destination Country | * | |
95 | PERIV_CM | PERIV_CM | PERIV | CHAR | 2 | 0 | Fiscal year variant of credit control area | * | |
96 | PKUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
97 | PKUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
98 | PKUNRE | KUNRE | KUNNR | CHAR | 10 | 0 | Bill-to party | * | |
99 | PKUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
100 | PSPDNR | SPDNR | LIFNR | CHAR | 10 | 0 | Carrier | * | |
101 | PVRTNR | VRTNR | PERNR | NUMC | 8 | 0 | Sales employee | ||
102 | PLAAG | PLAAG | LAND1 | CHAR | 3 | 0 | Country of the sold-to party | * | |
103 | PLAWE | PLAWE | LAND1 | CHAR | 3 | 0 | Country of ship-to party | * | |
104 | PLARE | PLARE | LAND1 | CHAR | 3 | 0 | Country of the bill-to party | * | |
105 | PLARG | PLARG | LAND1 | CHAR | 3 | 0 | Country of the payer | * | |
106 | PLASP | PLASP | LAND1 | CHAR | 3 | 0 | Country of the carrier | * | |
107 | PLAVE | PLAVE | LAND1 | CHAR | 3 | 0 | Country of the representative | * | |
108 | PABLA | PABLA | TEXT25 | CHAR | 25 | 0 | Unloading point of the ship-to party | ||
109 | PZONE | PZONE | ZONE | CHAR | 10 | 0 | Transportation zone of the ship-to party | * |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |