dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table LIPS

SD document: Delivery: Item data

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table LIPS (SD document: Delivery: Item data) is a standard table in SAP ERP. It belongs to the package VL.

Technical Information

Table LIPS
Short Text SD document: Delivery: Item data
Package VL
Table Type Transparent Table

Fields for Table LIPS

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 T000
VBELN ✔ Delivery VBELN_VL CHAR 10 VBUK
POSNR ✔ Delivery Item POSNR_VL NUMC 6 VBUP
PSTYV Delivery item category PSTYV_VL CHAR 4 TVPT
ERNAM Name of Person who Created the Object ERNAM CHAR 12
ERZET Entry time ERZET TIMS 6
ERDAT Date on Which Record Was Created ERDAT DATS 8
MATNR Material Number MATNR CHAR 18 MARA
MATWA Material entered MATWA CHAR 18 MARA
MATKL Material Group MATKL CHAR 9 T023
WERKS Plant WERKS_D CHAR 4 T001W
LGORT Storage Location LGORT_D CHAR 4 T001L
CHARG Batch Number CHARG_D CHAR 10 MCHA
LICHN Vendor Batch Number LICHN CHAR 15
KDMAT Material belonging to the customer KDMAT CHAR 35
PRODH Product hierarchy PRODH_D CHAR 18 T179
LFIMG Actual quantity delivered (in sales units) LFIMG QUAN 13
MEINS Base Unit of Measure MEINS UNIT 3 T006
VRKME Sales unit VRKME UNIT 3 T006
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5
NTGEW Net weight NTGEW_15 QUAN 15
BRGEW Gross weight BRGEW_15 QUAN 15
GEWEI Weight Unit GEWEI UNIT 3 T006
VOLUM Volume VOLUM_15 QUAN 15
VOLEH Volume unit VOLEH UNIT 3 T006
KZTLF Partial delivery at item level KZTLF CHAR 1
UEBTK Indicator: Unlimited Overdelivery Allowed UEBTK CHAR 1
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3
CHSPL Batch split allowed CHSPL CHAR 1
FAKSP Block FAKSP CHAR 2 TVFS
MBDAT Material Staging/Availability Date MBDAT DATS 8
LGMNG Actual quantity delivered in stockkeeping units LGMNG QUAN 13
ARKTX Short text for sales order item ARKTX CHAR 40
LGPBE Storage Bin LGPBE CHAR 10
VBELV Originating document VBELV CHAR 10 VBUK
POSNV Originating item POSNV NUMC 6 VBUP
VBTYV SD document category VBTYP CHAR 1
VGSYS Logical System in the Preceding Document VGLOGSYS CHAR 10 TBDLS
VGBEL Document number of the reference document VGBEL CHAR 10 VBUK
VGPOS Item number of the reference item VGPOS NUMC 6 VBUP
UPFLU Update indicator for delivery document flow UPFLL CHAR 1
UEPOS Higher-level item in bill of material structures UEPOS NUMC 6 VBUP
FKREL Relevant for Billing FKREL CHAR 1
LADGR Loading Group LADGR CHAR 4 TLGR
TRAGR Transportation Group TRAGR CHAR 4 TTGR
KOMKZ Indicator for picking control KOMKZ CHAR 1
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 T300
LISPL Split to warehouse number required LNSPL_LIPS CHAR 1
LGTYP Storage Type LGTYP CHAR 3 T301
LGPLA Storage Bin LGPLA CHAR 10 LAGP
BWTEX Indicator: Separate valuation BWTEX CHAR 1
BWART Movement Type (Inventory Management) BWART CHAR 3 T156
BWLVS Movement Type for Warehouse Management BWLVS NUMC 3 T333
KZDLG Indicator: dynamic storage bin in warehouse management LVS_KZDLG CHAR 1
BDART Requirement type BDART CHAR 2
PLART Planning type PLART CHAR 1 *
MTART Material Type MTART CHAR 4 T134
XCHPF Batch management requirement indicator XCHPF CHAR 1
XCHAR Batch management indicator (internal) XCHAR CHAR 1
VGREF Preceding document has resulted from reference VGREF CHAR 1
POSAR Item type POSAR CHAR 1
BWTAR Valuation Type BWTAR_D CHAR 10 T149D
SUMBD Summing up of requirements SUMBD CHAR 1
MTVFP Checking Group for Availability Check MTVFP CHAR 2 TMVF
EANNR European Article Number (EAN) - obsolete!!!!! EANNR CHAR 13
GSBER Business Area GSBER CHAR 4 TGSB
VKBUR Sales Office VKBUR CHAR 4 TVBUR
VKGRP Sales Group VKGRP CHAR 3 TVKGR
VTWEG Distribution Channel VTWEG CHAR 2 TVTW
SPART Division SPART CHAR 2 TSPA
GRKOR Delivery group (items are delivered together) GRKOR NUMC 3
FMENG Quantity is Fixed FMENG CHAR 1
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1
VBEAF Fixed shipping processing time in days (= setup time) VBEAF DEC 5
VBEAV Variable shipping processing time in days VBEAV DEC 5
STAFO Update group for statistics update STAFO CHAR 6 *
WAVWR Cost in document currency WAVWR CURR 13
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13
SOBKZ Special Stock Indicator SOBKZ CHAR 1 T148
AEDAT Changed On AEDAT DATS 8
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18
KVGR1 Customer group 1 KVGR1 CHAR 3 TVV1
KVGR2 Customer group 2 KVGR2 CHAR 3 TVV2
KVGR3 Customer group 3 KVGR3 CHAR 3 TVV3
KVGR4 Customer group 4 KVGR4 CHAR 3 TVV4
KVGR5 Customer group 5 KVGR5 CHAR 3 TVV5
MVGR1 Material group 1 MVGR1 CHAR 3 TVM1
MVGR2 Material group 2 MVGR2 CHAR 3 TVM2
MVGR3 Material group 3 MVGR3 CHAR 3 TVM3
MVGR4 Material group 4 MVGR4 CHAR 3 TVM4
MVGR5 Material group 5 MVGR5 CHAR 3 TVM5
VPZUO Allocation Indicator VPZUO CHAR 1
VGTYP SD document category VBTYP CHAR 1
RFVGTYP Type of preceding document in central system RFVGTYP CHAR 1
KOSTL Cost Center KOSTL CHAR 10 CSKS
KOKRS Controlling Area KOKRS CHAR 4 TKA01
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10
PRCTR Profit Center PRCTR CHAR 10 *
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 *
AUFNR Order Number AUFNR CHAR 12 AUFK
POSNR_PP Order Item Number CO_POSNR NUMC 4
KDAUF Sales Order Number KDAUF CHAR 10 *
KDPOS Item Number in Sales Order KDPOS NUMC 6
VPMAT Planning material VPMAT CHAR 18 MARA
VPWRK Planning plant VPWRK CHAR 4 T001W
PRBME Base unit of measure for product group PRBME UNIT 3 T006
UMREF Conversion factor: quantities UMREFF FLTP 16
KNTTP Account Assignment Category KNTTP CHAR 1 T163K
KZVBR Consumption Posting KZVBR CHAR 1
FIPOS Commitment Item FIPOS CHAR 14 *
FISTL Funds Center FISTL CHAR 16 *
GEBER Fund BP_GEBER CHAR 10 *
PCKPF Packing control PCKPF CHAR 1
BEDAR_LF Requirements class BEDAR CHAR 3 T459K
CMPNT ID: Item with active credit function / relevant for credit CMPNT CHAR 1
KCMENG Cumulative batch quantity of all split items (in StckUnit) KCMENG QUAN 15
KCBRGEW Cumulative gross weight of all batch split items KCBRGEW QUAN 15
KCNTGEW Cumulative net weight of all batch split items KCNTGEW QUAN 15
KCVOLUM Cumulative volume of all batch split items KCVOLUM QUAN 15
UECHA Higher-Level Item of Batch Split Item UECHA NUMC 6 LIPS
CUOBJ Configuration CUOBJ_VA NUMC 18
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18
ANZSN Number of serial numbers ANZSN INT4 10
SERAIL Serial Number Profile SERAIL CHAR 4 T377P
KCGEWEI Weight Unit GEWEI UNIT 3 T006
KCVOLEH Volume unit VOLEH UNIT 3 T006
SERNR BOM explosion number SERNR CHAR 8 SNUM
ABRLI Internal delivery schedule number ABRLI NUMC 4 VBLB
ABART Release type ABART CHAR 1
ABRVW Usage Indicator ABRVW CHAR 3 TVLV
QPLOS Inspection Lot Number QPLOS NUMC 12 QALS
QTLOS Partial lot number QTLOS NUMC 6 *
NACHL Customer has not posted goods receipt NACHL CHAR 1
MAGRV Material Group: Packaging Materials MAGRV CHAR 4 TVEGR
OBJKO Object number at header level OBJKO CHAR 22 *
OBJPO Object number at item level OBJPO CHAR 22 *
AESKD Customer Engineering Change Status AESKD CHAR 17
SHKZG Returns Item SHKZG_VA CHAR 1
PROSA ID for material determination PROSA CHAR 1
UEPVW ID for higher-level item usage UEPVW CHAR 1
EMPST Receiving point EMPST CHAR 25
ABTNR Department number ABTNR CHAR 4 TSAB
KOQUI Picking is subject to confirmation KOQUI CHAR 1
STADAT Statistics date STADAT DATS 8
KNUMH_CH Number of condition record from batch determination KNUMH_CH CHAR 10
PREFE Preference indicator in export/import PREFE CHAR 1
EXART Business Transaction Type for Foreign Trade EXART CHAR 2 *
CLINT Internal Class Number CLINT NUMC 10 KLAH
CHMVS Batches: Exit to quantity proposal CHMVS NUMC 3
ABELN Allocation Table Number ABELN CHAR 10 AUKO
ABELP Item number of allocation table ABELP NUMC 5 AUPO
LFIMG_FLO Internal field/ Do not use / LFIMG in float / MUM LFIMG_FLO FLTP 16
LGMNG_FLO Internal field/ Do not use / LGMNG in float / MUM LGMNG_FLO FLTP 16
KCMENG_FLO Internal field/ Do not use / KCMENG in float / MUM KCMENG_FLO FLTP 16
KZUMW Environmentally Relevant KZUMW CHAR 1
KMPMG Component quantity KMPMG QUAN 13
AUREL Relevant to Allocation Table AUREL CHAR 1
KPEIN Condition pricing unit KPEIN DEC 5
KMEIN Condition unit KMEIN UNIT 3 T006
NETPR Net price NETPR CURR 11
NETWR Net Value in Document Currency NETWR CURR 15
KOWRR Statistical values KOWRR CHAR 1
KZBEW Movement Indicator KZBEW CHAR 1
MFRGR Material freight group MFRGR CHAR 8 TMFG
CHHPV Pack accumulated batches / movement type item CHHPV CHAR 1
ABFOR Form of payment guarantee ABSFORM_CM CHAR 2 T691K
ABGES Guaranteed (factor between 0 and 1) ABGES_CM FLTP 16
MBUHR Material Staging Time (Local, Relating to a Plant) MBUHR TIMS 6
WKTNR Value contract no. WKTNR CHAR 10 VBUK
WKTPS Value contract item WKTPS NUMC 6 VBUP
J_1BCFOP CFOP Code and Extension J_1BCFOP CHAR 10 J_1BAG
J_1BTAXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 J_1BATL1
J_1BTAXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 J_1BATL2
J_1BTXSDC SD tax code J_1BTXSDC_ CHAR 2 J_1BTXSDC
SITUA Indicator for situation SITUA CHAR 2 *
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 *
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4
RSART Record type RSART CHAR 1
KANNR KANBAN/sequence number KANNR CHAR 35
KZFME ID: Leading unit of measure for completing a transaction KZFME CHAR 1
PROFL Dangerous Goods Indicator Profile ADGE_PROFL CHAR 3 TDG41
KCMENGVME Cumulative batch quantity of all split items in sales units KCMENG_VME QUAN 15
KCMENGVMEF Cumulated batch split quantity in VRKME and float KCMENGVMEF FLTP 16
KZBWS Valuation of Special Stock KZBWS CHAR 1
PSPNR Project definition (internal) PS_INTNR NUMC 8 *
EPRIO Withdrawal sequence group for stocks EPRIO CHAR 4 *
RULES Stock determination rule BF_RULES CHAR 4 T434R
KZBEF Indicator Inventory Management active LVS_KZBEF CHAR 1
MPROF Manufacturer Part Profile MPROF CHAR 4 *
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 MARA
LGBZO Staging Area for Warehouse Complex LGBZO CHAR 10 T30C
HANDLE Worldwide unique key for LIPS-VBELN & LIPS_POSNR TSEGGUID_LIPS CHAR 22
VERURPOS Distribution delivery: Original item VERURPOS NUMC 6 *
LIFEXPOS External item number LIFEXPOS NUMC 6 *
NOATP Indicator: deactivate availability check NO_ATP_CHECK CHAR 1
NOPCK Indicator: not relevant for picking NO_PICKING CHAR 1
RBLVS Reference movement type for WM from material movements RBLVS NUMC 3
BERID MRP Area BERID CHAR 10 MDLV
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1
UMBSQ Stock Category in the Warehouse Management System BESTQ CHAR 1
UMMAT Receiving/Issuing Material UMMAT CHAR 18 *
UMWRK Receiving/Issuing Plant UMWRK CHAR 4 *
UMLGO Receiving/Issuing Storage Location UMLGO CHAR 4 *
UMCHA Receiving/Issuing Batch UMCHA CHAR 10 *
UMBAR Valuation Type of Transfer Batch UMBAR CHAR 10 *
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 *
SONUM Special Stock Number LVS_SONUM CHAR 16
USONU Special Stock Number LVS_SONUM CHAR 16
AKKUR Exchange rate for letter-of-credit procg in foreign trade AKKUR DEC 9
AKMNG Current Qty Field for Arithmetic Operations in Doc.Process. AKMNG CHAR 1
VKGRU Repair Processing: Classification of Items VKGRU CHAR 3 *
SHKZG_UM Indicator: UNMAT in main posting SHKZG_UM CHAR 1
INSMK Stock Type MB_INSMK CHAR 1
KZECH Determination of batch entry in the production/process order KZECH CHAR 1
FLGWM Indicator: Copy dest. storage data from preceding document FLGWM CHAR 1
BERKZ Material Staging Indicator for Production Supply BERKZ CHAR 1
HUPOS Indicator: Delivery item is a HU item HUPOS CHAR 1
NOWAB Indicator: Item Not Relevant for Goods Movements NOWAB CHAR 1
KONTO G/L Account Number SAKNR CHAR 10 *
KZEAR Final Issue for This Reservation KZEAR CHAR 1
HSDAT Date of Manufacture HSDAT DATS 8
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8
LFGJA Fiscal Year of Current Period LFGJA NUMC 4
LFBNR Document No. of a Reference Document LFBNR CHAR 10
LFPOS Item of a Reference Document LFPOS NUMC 4
GRUND Reason for goods movment MB_GRUND NUMC 4
FOBWA Subsequent movement type FOBWA CHAR 3 *
DLVTP Delivery Category DLVTP CHAR 2
EXBWR Externally Entered Posting Amount in Local Currency EXBWR CURR 13
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13
EXVKW Externally Entered Sales Value in Local Currency EXVKW CURR 13
CMPRE_FLT Item credit price CMPRE_FLT FLTP 16
KZPOD POD indicator (relevance, verification, confirmation) KZPOD CHAR 1
LFDEZ Not relevant for distribution for WMS LFDEZ CHAR 1
UMREV Conversion Factor of Delivery Quantity VRKME for MEINS LE_UMREV FLTP 16
PODREL POD Control (Proof of Delivery) PODREL CHAR 1
KZUML Stock transfer/transfer posting KZUML CHAR 1
FKBER Functional Area FKBER CHAR 16 *
GRANT_NBR Grant GM_GRANT_NBR CHAR 20
KZWSO Units of measure usage KZWSO CHAR 1
GMCONTROL Goods Movement Control GMCONTROL CHAR 1
POSTING_CHANGE Goods Movement Control: HU POSTING_CHANGE CHAR 1
UM_PS_PSP_PNR Receiving/Issuing (WBS Element) UM_PS_PSP_PNR NUMC 8 *
PRE_VL_ETENS Sequential Number of Vendor Confirmation ETENS NUMC 4
SPE_GEN_ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1
SPE_SCRAP_IND Scrap Indicator for EWM Processing /SPE/DELIVERY_SCRAP_IND CHAR 1
SPE_AUTH_NUMBER Return Material Authorization Number /SPE/RET_RMA CHAR 20
SPE_INSPOUT_GUID Inspections: Inspection outcome GUID set by EWM /SPE/INSP_OUT_GUID_16 RAW 16
SPE_FOLLOW_UP Default Follow-Up Activity Code /SPE/RET_FOLLOW_UP CHAR 4
SPE_EXP_DATE_EXT End date of validity period of returns delivery /SPE/RET_EXPIRY_DATE_EXT DEC 15
SPE_EXP_DATE_INT End date of internal validity period of returns delivery /SPE/RET_EXPIRY_DATE_INT DEC 15
SPE_AUTH_COMPLET RMA completion indicator /SPE/RET_RMA_COMPLETED CHAR 1
ORMNG Original Quantity of Delivery Item ORMNG_VL QUAN 13
SPE_ATP_TMSTMP ATP Time Stamp /SPE/DE_ATP_TIMESTAMP DEC 15
SPE_ORIG_SYS Original System Type /SPE/INB_ORIGIN_SYS CHAR 1
SPE_LIEFFZ Cumulative Qty for SchedAgr - Vendor's Point of View /SPE/LIEFFZ QUAN 15
SPE_IMWRK Inbound Delivery item has Status 'In Plant' /SPE/IMWRK_ITEM CHAR 1
SPE_LIFEXPOS2 External item identifier /SPE/DE_EXT_IDENT CHAR 35
SPE_EXCEPT_CODE Exception Code Warehouse for Quantity Difference /SPE/INB_EXCEPT_CODE_WM CHAR 4
SPE_KEEP_QTY Retention Quantity for Scrap. Process in EWM /SPE/KEEP_QUANTITY QUAN 13
SPE_ALTERNATE Alternate Product Number /SPE/DE_ALTERNATE_PART_NR CHAR 40
SPE_MAT_SUBST Reason for material substitution /SPE/MAT_SUBST CHAR 1
SPE_STRUC Structure of Items That Are Delivered Together /SPE/STRUC NUMC 3
SPE_APO_QNTYFAC Numerator of Quotient for Unit of Measure Conversion APOQUANFACTOR DEC 5
SPE_APO_QNTYDIV Denominator of Quotient for Unit of Measure Conversion APOQUANDIVISOR DEC 5
SPE_HERKL Country of origin of the material HERKL CHAR 3 *
SPE_BXP_DATE_EXT Begin date of validity period of returns delivery /SPE/RET_EXPIRY_DATE_EXT_B DEC 15
SPE_VERSION Delivery Version at Confirmation /SPE/DE_DLV_VERSION NUMC 4
SPE_COMPL_MVT Completion of Goods Movements after Difference Postings /SPE/COMPL_MVT CHAR 1
J_1BTAXLW4 COFINS Tax Law J_1BTAXLW4 CHAR 3 J_1BATL4A
J_1BTAXLW5 PIS Tax Law J_1BTAXLW5 CHAR 3 J_1BATL5
J_1BTAXLW3 ISS Tax Law J_1BTAXLW3 CHAR 3 J_1BATL3
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 *
KBNKZ Kanban Indicator KBNKZ CHAR 1
SITKZ Specification for Issuing Valuated Stock in Transit SITKZ CHAR 1
/SAPMP/LBA_NO DTUC Complete /SAPMP/LBADONE CHAR 1
/SAPMP/ALT_CONV Mill: Indicator Provisional Conversion Factors /SAPMP/ALT_CONV CHAR 1
LGTOR Door for Warehouse Number LGTOR CHAR 3 *
MILL_UCDET Batch Determination for Original Batches MILL_UCDET CHAR 1
CONS_ORDER Purchase Order for Consignment WRF_CONS_ORDER CHAR 1