Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table E2CLIKP

SIS - delivery header data

E2CLIKP (SIS - delivery header data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link E2CLIKP to other SAP tables.

E2CLIKP table fields

Field Data element Checktable Datatype Length Decimals Possible values
SUPKZ
Statistics update indicator (post in/post out)
 SUPKZ
CHAR
 1 0
VBELN
Delivery
 VBELN_VL
CHAR
 10 0
ERNAM
Name of Person who Created the Object
 ERNAM
CHAR
 12 0
ERZET
Entry time
 ERZET
TIMS
 6 0
ERDAT
Date on Which Record Was Created
 ERDAT
DATS
 8 0
BZIRK
Sales district
 BZIRK
CHAR
 6 0
VSTEL
Shipping Point/Receiving Point
 VSTEL
CHAR
 4 0
VKORG
Sales Organization
 VKORG
CHAR
 4 0
LFART
Delivery Type
 LFART
CHAR
 4 0
AUTLF
Complete delivery defined for each sales order?
 AUTLF
CHAR
 1 0
KZAZU
Order Combination Indicator
 KZAZU_D
CHAR
 1 0
WADAT
Planned goods movement date
 WADAK
DATS
 8 0
LDDAT
Loading Date
 LDDAT
DATS
 8 0
TDDAT
Transportation Planning Date
 TDDAT_D
DATS
 8 0
LFDAT
Delivery Date
 LFDAT_V
DATS
 8 0
KODAT
Picking Date
 KODAT
DATS
 8 0
ABLAD
Unloading Point
 ABLAD
CHAR
 25 0
INCO1
Incoterms (Part 1)
 INCO1
CHAR
 3 0
INCO2
Incoterms (Part 2)
 INCO2
CHAR
 28 0
EXPKZ
Export indicator
 EXPKZ
CHAR
 1 0
ROUTE
Route
 ROUTE
CHAR
 6 0
FAKSK
Billing block in SD document
 FAKSK
CHAR
 2 0
LIFSK
Delivery block (document header)
 LIFSK
CHAR
 2 0
VBTYP
SD document category
 VBTYP
CHAR
 1 0
KNFAK
Customer factory calendar
 KNFAK
CHAR
 2 0
TPQUA
not currently in use
 TPQUA
CHAR
 1 0
TPGRP
not currently in use
 TPGRP
CHAR
 2 0
LPRIO
Delivery Priority
 LPRIO
NUMC
 2 0
VSBED
Shipping Conditions
 VSBED
CHAR
 2 0
KUNNR
Ship-to party
 KUNWE
CHAR
 10 0
KUNAG
Sold-to party
 KUNAG
CHAR
 10 0
KDGRP
Customer group
 KDGRP
CHAR
 2 0
STZKL
R/2 table
 CHAR5
CHAR
 5 0
STZZU
R/2 table
 CHAR5
CHAR
 5 0
BTGEW
Field length 18
 CHAR18
CHAR
 18 0
NTGEW
Field length 18
 CHAR18
CHAR
 18 0
GEWEI
3-Byte field
 CHAR3
CHAR
 3 0
VOLUM
Field length 18
 CHAR18
CHAR
 18 0
VOLEH
3-Byte field
 CHAR3
CHAR
 3 0
ANZPK
Total number of packages in delivery
 ANZPK
NUMC
 5 0
BEROT
Picked items location
 BEROT
CHAR
 20 0
LFUHR
Time of delivery
 LFUHR
TIMS
 6 0
GRULG
Weight group for delivery (To group)
 GRULG
CHAR
 4 0
LSTEL
Loading Point
 LSTEL
CHAR
 2 0
TRAGR
Transportation Group
 TRAGR
CHAR
 4 0
FKARV
Proposed billing type for a delivery-related billing doc.
 FKARV
CHAR
 4 0
FKDAT
Billing date for billing index and printout
 FKDAT
DATS
 8 0
PERFK
Invoice dates (calendar identification)
 PERFK
CHAR
 2 0
ROUTA
Route
 ROUTE
CHAR
 6 0
STAFO
Update group for statistics update
 STAFO
CHAR
 6 0
KALSM
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
 KALSM_D
CHAR
 6 0
KNUMV
Number of the document condition
 KNUMV
CHAR
 10 0
WAERK
SD Document Currency
 WAERK
CUKY
 5 0
VKBUR
Sales Office
 VKBUR
CHAR
 4 0
VBEAK
Character field, 8 characters long
 CHAR8
CHAR
 8 0
ZUKRL
Combination criteria for delivery
 DZUKRL
CHAR
 40 0
VERUR
Distribution delivery
 VERUR_VL
CHAR
 35 0
COMMN
Communication number for Q-API interface
 COMMN
CHAR
 5 0
STWAE
Statistics currency
 STWAE
CUKY
 5 0
STCUR
Character Length 11
 CHAR11
CHAR
 11 0
EXNUM
Number of foreign trade data in MM and SD documents
 EXNUM
CHAR
 10 0
AEDAT
Changed On
 AEDAT
DATS
 8 0
LGNUM
Warehouse Number / Warehouse Complex
 LGNUM
CHAR
 3 0
VKOIV
Sales organization for intercompany billing
 VKOIV
CHAR
 4 0
VTWIV
Distribution channel for intercompany billing
 VTWIV
CHAR
 2 0
SPAIV
Division for intercompany billing
 SPAIV
CHAR
 2 0
FKAIV
Billing type for intercompany billing
 FKAIV
CHAR
 4 0
PIOIV
Date for intercompany billing
 PIOIV
CHAR
 2 0
FKDIV
Billing date for intercompany billing
 FKDIV
DATS
 8 0
KUNIV
Customer number for intercompany billing
 KUNIV
CHAR
 10 0
KKBER
Credit control area
 KKBER
CHAR
 4 0
KNKLI
Customer's account number with credit limit reference
 KNKLI
CHAR
 10 0
GRUPP
Customer Credit Group
 GRUPP_CM
CHAR
 4 0
SBGRP
Credit representative group for credit management
 SBGRP_CM
CHAR
 3 0
CTLPC
Credit management: Risk category
 CTLPC_CM
CHAR
 3 0
CMWAE
Currency key of credit control area
 WAERS_CM
CUKY
 5 0
AMTBL
17-Char. Field
 CHAR17
CHAR
 17 0
BOLNR
Bill of lading
 BOLNR
CHAR
 35 0
LIFNR
Vendor Account Number
 ELIFN
CHAR
 10 0
TRATY
Means-of-Transport Type
 TRATY
CHAR
 4 0
TRAID
Means of Transport ID
 TRAID
CHAR
 20 0
CMFRE
Release date of the document determined by credit management
 CMFRE
DATS
 8 0
CMNGV
Next date
 CMNGV
DATS
 8 0
XABLN
Goods Receipt/Issue Slip Number
 XABLN
CHAR
 10 0
WADAT_IST
Actual Goods Movement Date
 WADAT_IST
DATS
 8 0
TRSPG
Shipment Blocking Reason
 TRSPG
CHAR
 2 0
TPSID
ID for external transport system
 TPSID
CHAR
 5 0
LIFEX
External Identification of Delivery Note
 LIFEX
CHAR
 35 0
TERNR
Order Number
 AUFNR
CHAR
 12 0
KALSM_CH
Search procedure for batch determination
 KALSMA_CH
CHAR
 6 0
KLIEF
Correction delivery
 KLIEF
CHAR
 1 0
HWAER
Local Currency
 HWAER
CUKY
 5 0
BUKRS
Character field of length 6
 CHAR6
CHAR
 6 0
LLAND
Country of Destination
 LLAND
CHAR
 3 0
PERIV_CM
Fiscal Year Variant of Credit Control Area
 PERIV_CM
CHAR
 2 0
PKUNAG
Sold-to party
 KUNAG
CHAR
 10 0
PKUNWE
Ship-to party
 KUNWE
CHAR
 10 0
PKUNRE
Bill-to party
 KUNRE
CHAR
 10 0
PKUNRG
Payer
 KUNRG
CHAR
 10 0
PSPDNR
Forwarding agent
 SPDNR
CHAR
 10 0
PVRTNR
Sales employee
 VRTNR
NUMC
 8 0
PLAAG
Country of the sold-to party
 PLAAG
CHAR
 3 0
PLAWE
Country of ship-to party
 PLAWE
CHAR
 3 0
PLARE
Country of the bill-to party
 PLARE
CHAR
 3 0
PLARG
Country of the payer
 PLARG
CHAR
 3 0
PLASP
Country of the carrier
 PLASP
CHAR
 3 0
PLAVE
Country of the representative
 PLAVE
CHAR
 3 0
PABLA
Unloading point of the ship-to party
 PABLA
CHAR
 25 0
PZONE
Transportation zone of the ship-to party
 PZONE
CHAR
 10 0