E3CLIKP SAP (SIS - delivery header data) Structure details
Description: SIS - delivery header data
Structure field list including key, data, relationships and ABAP select examples
E3CLIKP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SIS - delivery header data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_E3CLIKP TYPE E3CLIKP.
The E3CLIKP table consists of various fields, each holding specific information or linking keys about SIS - delivery header data data available in SAP. These include VBELN (Delivery), ERNAM (Name of Person who Created the Object), ERZET (Entry time), ERDAT (Date on Which Record Was Created).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP E3CLIKP structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
SUPKZ | Statistics update indicator (post in/post out) | SUPKZ | CHAR | 1 | SUPKZ | ||||
VBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
BZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | Assigned to domain | VSTEL | VST | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
LFART | Delivery Type | LFART | CHAR | 4 | Assigned to domain | LFART | ALT | ||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | XFELD | ||||
WADAT | Planned goods movement date | WADAK | DATS | 8 | DATUM | ||||
LDDAT | Loading Date | LDDAT | DATS | 8 | DATUM | ||||
TDDAT | Transportation Planning Date | TDDAT_D | DATS | 8 | DATUM | ||||
LFDAT | Delivery Date | LFDAT_V | DATS | 8 | DATUM | ||||
KODAT | Picking Date | KODAT | DATS | 8 | DATUM | ||||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | Assigned to domain | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | Assigned to domain | FAKSP | |||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | Assigned to domain | LIFSP | |||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
KNFAK | Customer factory calendar | KNFAK | CHAR | 2 | Assigned to domain | WFCID | |||
TPQUA | not currently in use | TPQUA | CHAR | 1 | TPQUA | ||||
TPGRP | not currently in use | TPGRP | CHAR | 2 | TPGRP | ||||
LPRIO | Delivery Priority | LPRIO | NUMC | 2 | Assigned to domain | LPRIO | |||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
KUNNR | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
STZKL | Not Currently in Use | STZKL | DEC | 3(2) | STZKL | ||||
STZZU | not currently in use | STZZU | DEC | 3 | STZZU | ||||
BTGEW | Total Weight | GSGEW | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ANZPK | Total number of packages in delivery | ANZPK | NUMC | 5 | ANZPK | ||||
BEROT | Picked items location | BEROT | CHAR | 20 | BEROT | ||||
LFUHR | Time of delivery | LFUHR | TIMS | 6 | LFUHR | ||||
GRULG | Weight group for delivery (To group) | GRULG | CHAR | 4 | Assigned to domain | GRULG | |||
LSTEL | Loading Point | LSTEL | CHAR | 2 | Assigned to domain | LSTEL | |||
TRAGR | Transportation Group | TRAGR | CHAR | 4 | Assigned to domain | TRAGR | |||
FKARV | Proposed billing type for a delivery-related billing doc. | FKARV | CHAR | 4 | Assigned to domain | FKART | |||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | Assigned to domain | WFCID | |||
ROUTA | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | Assigned to domain | KALSM | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
VBEAK | Shipping processing time for the entire document | VBEAK | DEC | 6(2) | DEC4_2 | ||||
ZUKRL | Combination criteria for delivery | DZUKRL | CHAR | 40 | CHAR40 | ||||
VERUR | Distribution delivery | VERUR_VL | CHAR | 35 | CHAR35 | ||||
COMMN | Communication number for Q-API interface | COMMN | CHAR | 5 | Assigned to domain | COMMN | |||
STWAE | Statistics currency | STWAE | CUKY | 5 | Assigned to domain | WAERS | |||
STCUR | Exchange rate for statistics | STCUR | DEC | 9(5) | EXCRT | KURRF | |||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | Assigned to domain | EXNUM | |||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | Assigned to domain | LGNUM | LGN | ||
VKOIV | Sales organization for intercompany billing | VKOIV | CHAR | 4 | Assigned to domain | VKORG | VKO | ||
VTWIV | Distribution channel for intercompany billing | VTWIV | CHAR | 2 | Assigned to domain | VTWEG | VTW | ||
SPAIV | Division for intercompany billing | SPAIV | CHAR | 2 | Assigned to domain | SPART | SPA | ||
FKAIV | Billing type for intercompany billing | FKAIV | CHAR | 4 | Assigned to domain | FKART | |||
PIOIV | Date for intercompany billing | PIOIV | CHAR | 2 | Assigned to domain | WFCID | |||
FKDIV | Billing date for intercompany billing | FKDIV | DATS | 8 | DATUM | ||||
KUNIV | Customer number for intercompany billing | KUNIV | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KKBER | Credit control area | KKBER | CHAR | 4 | Assigned to domain | KKBER | KKB | ||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
GRUPP | Customer Credit Group | GRUPP_CM | CHAR | 4 | Assigned to domain | GRUPP_CM | |||
SBGRP | Credit representative group for credit management | SBGRP_CM | CHAR | 3 | Assigned to domain | SBGRP_CM | KBG | ||
CTLPC | Credit management: Risk category | CTLPC_CM | CHAR | 3 | Assigned to domain | CTLPC_CM | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | Assigned to domain | WAERS | |||
AMTBL | Released credit value of the document | AMTBL_CM | CURR | 15(2) | WERTV8 | ||||
BOLNR | Bill of lading | BOLNR | CHAR | 35 | CHAR35 | ||||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | Assigned to domain | TRATY | |||
TRAID | Means of Transport ID | TRAID | CHAR | 20 | TRAID | ||||
CMFRE | Release date of the document determined by credit management | CMFRE | DATS | 8 | DATUM | ||||
CMNGV | Next date | CMNGV | DATS | 8 | DATUM | ||||
XABLN | Goods Receipt/Issue Slip Number | XABLN | CHAR | 10 | ALPHA | BELNR | |||
WADAT_IST | Actual Goods Movement Date | WADAT_IST | DATS | 8 | DATUM | WDTI | |||
TRSPG | Shipment Blocking Reason | TRSPG | CHAR | 2 | Assigned to domain | TRSPG | |||
TPSID | ID for external transport system | TPSID | CHAR | 5 | Assigned to domain | COMMN | |||
LIFEX | External Identification of Delivery Note | LIFEX | CHAR | 35 | TEXT35 | ||||
TERNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
KALSM_CH | Search procedure for batch determination | KALSMA_CH | CHAR | 6 | Assigned to domain | KALSM | |||
KLIEF | Correction delivery | KLIEF | CHAR | 1 | XFELD | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
LLAND | Country of Destination | LLAND | CHAR | 3 | Assigned to domain | LAND1 | VLL | ||
PERIV_CM | Fiscal Year Variant of Credit Control Area | PERIV_CM | CHAR | 2 | Assigned to domain | PERIV | |||
PKUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
PKUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
PKUNRE | Bill-to party | KUNRE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
PKUNRG | Payer | KUNRG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
PSPDNR | Forwarding agent | SPDNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PVRTNR | Sales employee | VRTNR | NUMC | 8 | PERNR | PREMV | |||
PLAAG | Country of the sold-to party | PLAAG | CHAR | 3 | Assigned to domain | LAND1 | |||
PLAWE | Country of ship-to party | PLAWE | CHAR | 3 | Assigned to domain | LAND1 | |||
PLARE | Country of the bill-to party | PLARE | CHAR | 3 | Assigned to domain | LAND1 | |||
PLARG | Country of the payer | PLARG | CHAR | 3 | Assigned to domain | LAND1 | |||
PLASP | Country of the carrier | PLASP | CHAR | 3 | Assigned to domain | LAND1 | |||
PLAVE | Country of the representative | PLAVE | CHAR | 3 | Assigned to domain | LAND1 | |||
PABLA | Unloading point of the ship-to party | PABLA | CHAR | 25 | TEXT25 | ||||
PZONE | Transportation zone of the ship-to party | PZONE | CHAR | 10 | Assigned to domain | ZONE |
Key field | Non-key field |
How do I retrieve data from SAP structure E3CLIKP using ABAP code?
As E3CLIKP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on E3CLIKP as there is no data to select.How to access SAP table E3CLIKP
Within an ECC or HANA version of SAP you can also view further information about E3CLIKP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects