SAP Table

LIPS SD document: Delivery: Item data

SAP table LIPS has 3 primary key fields being MANDT,VBELN,POSNR.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

LIPS columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyVBELN Delivery CHAR 10 0 LIKP VBELN_VL
KeyPOSNR Delivery Item NUMC 6 0 POSNR_VL
PSTYV Delivery item category CHAR 4 0 TVPT PSTYV_VL
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERZET Entry time TIMS 6 0 ERZET
ERDAT Date on which the record was created DATS 8 0 ERDAT
MATNR Material Number CHAR 40 0 MARA MATNR
MATWA Material Entered CHAR 40 0 MARA MATWA
MATKL Material Group CHAR 9 0 T023 MATKL
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
LICHN Supplier Batch Number CHAR 15 0 LICHN
KDMAT Customer Material CHAR 35 0 KDMAT
PRODH Product hierarchy CHAR 18 0 T179 PRODH_D
LFIMG Actual quantity delivered (in sales units) QUAN 13 3 LFIMG
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
VRKME Sales unit UNIT 3 0 T006 VRKME
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
NTGEW Net weight QUAN 15 3 NTGEW_15
BRGEW Gross weight QUAN 15 3 BRGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 T006 VOLEH
KZTLF Partial delivery at item level CHAR 1 0 KZTLF
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
CHSPL Batch split allowed CHAR 1 0 CHSPL
FAKSP Billing Block CHAR 2 0 TVFS FAKSP
MBDAT Material Staging/Availability Date DATS 8 0 MBDAT
LGMNG Actual quantity delivered in stockkeeping units QUAN 13 3 LGMNG
ARKTX Short text for sales order item CHAR 40 0 ARKTX
LGPBE Storage Bin CHAR 10 0 LGPBE
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
VBTYV SD Document Category CHAR 4 0 VBTYPL
VGSYS Logical System in the Preceding Document CHAR 10 0 TBDLS VGLOGSYS
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
UPFLU Update indicator for delivery document flow CHAR 1 0 UPFLL
UEPOS Higher-Level Item in Bill of Material Structures NUMC 6 0 LIPS UEPOS
FKREL Relevant for Billing CHAR 1 0 FKREL
LADGR Loading Group CHAR 4 0 TLGR LADGR
TRAGR Transportation Group CHAR 4 0 TTGR TRAGR
KOMKZ Indicator for picking control CHAR 1 0 KOMKZ
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LISPL Split to warehouse number required CHAR 1 0 LNSPL_LIPS
LGTYP Storage Type CHAR 3 0 T301 LGTYP
LGPLA Storage Bin CHAR 10 0 LAGP LGPLA
BWTEX Indicator: Separate valuation CHAR 1 0 BWTEX
ETTYP Schedule line category CHAR 2 0 TVEP ETTYP
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
BWLVS Movement Type for Warehouse Management NUMC 3 0 T333 BWLVS
KZDLG Indicator: dynamic storage bin in warehouse management CHAR 1 0 LVS_KZDLG
BDART Requirement type CHAR 2 0 BDART
PLART Planning type CHAR 1 0 PLART
MTART Material type CHAR 4 0 T134 MTART
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
XCHAR Batch management indicator (internal) CHAR 1 0 XCHAR
VGREF Preceding document has resulted from reference CHAR 1 0 VGREF
POSAR Item Type CHAR 1 0 POSAR
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
SUMBD Summing up of requirements CHAR 1 0 SUMBD
MTVFP Checking Group for Availability Check CHAR 2 0 TMVF MTVFP
EANNR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
GSBER Business Area CHAR 4 0 TGSB GSBER
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
GRKOR Delivery Group (Items are delivered together) NUMC 3 0 GRKOR
FMENG Quantity is fixed CHAR 1 0 FMENG
ANTLF Maximum Number of Partial Deliveries Allowed Per Item DEC 1 0 ANTLF
VBEAF Fixed shipping processing time in days (= setup time) DEC 5 2 VBEAF
VBEAV Variable shipping processing time in days DEC 5 2 VBEAV
STAFO Update Group for statistics update CHAR 6 0 STAFO
WAVWR Cost in Document Currency CURR 13 2 WAVWR
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
AEDAT Last Changed On DATS 8 0 AEDAT
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
KVGR1 Customer Group 1 CHAR 3 0 TVV1 KVGR1
KVGR2 Customer Group 2 CHAR 3 0 TVV2 KVGR2
KVGR3 Customer Group 3 CHAR 3 0 TVV3 KVGR3
KVGR4 Customer Group 4 CHAR 3 0 TVV4 KVGR4
KVGR5 Customer Group 5 CHAR 3 0 TVV5 KVGR5
MVGR1 Material Group 1 CHAR 3 0 TVM1 MVGR1
MVGR2 Material Group 2 CHAR 3 0 TVM2 MVGR2
MVGR3 Material Group 3 CHAR 3 0 TVM3 MVGR3
MVGR4 Material Group 4 CHAR 3 0 TVM4 MVGR4
MVGR5 Material Group 5 CHAR 3 0 TVM5 MVGR5
VPZUO Allocation Indicator CHAR 1 0 VPZUO
VGTYP Document Category of Preceding SD Document CHAR 4 0 VBTYPL_V
RFVGTYP Type of preceding document in central system (long) CHAR 4 0 RFVGTYPL
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRCTR Profit Center CHAR 10 0 PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
AUFNR Order Number CHAR 12 0 AUFK AUFNR
POSNR_PP Order item number NUMC 4 0 CO_POSNR
VORNR Operation/Activity Number CHAR 4 0 VORNR
RECIPIENT_LOCATION_CODE Recipient location code CHAR 15 0 RECIPIENT_LOCATION_CODE
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
VPMAT Planning material CHAR 40 0 MARA VPMAT
VPWRK Planning plant CHAR 4 0 T001W VPWRK
PRBME Base unit of measure for product group UNIT 3 0 T006 PRBME
UMREF Conversion factor: quantities FLTP 16 16 UMREFF
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
KZVBR Consumption posting CHAR 1 0 KZVBR
FIPOS Commitment Item CHAR 14 0 FIPOS
FISTL Funds Center CHAR 16 0 FISTL
GEBER Fund CHAR 10 0 BP_GEBER
PCKPF Packing Control CHAR 1 0 PCKPF
BEDAR_LF Requirements class CHAR 3 0 T459K BEDAR
CMPNT ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
KCMENG Cumulative batch quantity of all split items (in StckUnit) QUAN 15 3 KCMENG
KCBRGEW Cumulative gross weight of all batch split items QUAN 15 3 KCBRGEW
KCNTGEW Cumulative net weight of all batch split items QUAN 15 3 KCNTGEW
KCVOLUM Cumulative volume of all batch split items QUAN 15 3 KCVOLUM
UECHA Higher-Level Item of Batch Split Item NUMC 6 0 LIPS UECHA
CUOBJ Configuration NUMC 18 0 CUOBJ_VA
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
ANZSN Number of serial numbers INT4 10 0 ANZSN
SERAIL Serial Number Profile CHAR 4 0 T377P SERAIL
KCGEWEI Weight Unit UNIT 3 0 T006 GEWEI
KCVOLEH Volume unit UNIT 3 0 T006 VOLEH
SERNR BOM explosion number CHAR 8 0 SNUM SERNR
ABRLI Internal delivery schedule number NUMC 4 0 VBLB ABRLI
ABART Release type CHAR 1 0 ABART
ABRVW Usage Indicator CHAR 3 0 TVLV ABRVW
QPLOS Inspection Lot Number NUMC 12 0 QALS QPLOS
QTLOS Partial Lot Number NUMC 6 0 QTLOS
NACHL Customer has not posted goods receipt CHAR 1 0 NACHL
MAGRV Material Group: Packaging Materials CHAR 4 0 TVEGR MAGRV
OBJKO Object Number at Header Level CHAR 22 0 OBJKO
OBJPO Object Number at Item Level CHAR 22 0 OBJPO
AESKD Customer Engineering Change Status CHAR 17 0 AESKD
SHKZG Returns Item CHAR 1 0 SHKZG_DLV
PROSA ID for material determination CHAR 1 0 PROSA
UEPVW ID for higher-level item usage CHAR 1 0 UEPVW
EMPST Receiving Point CHAR 25 0 EMPST
ABTNR Department number CHAR 4 0 TSAB ABTNR
KOQUI Picking is subject to confirmation CHAR 1 0 KOQUI
STADAT Statistics date DATS 8 0 STADAT
AKTNR Promotion CHAR 10 0 WAKH WAKTION
KNUMH_CH Number of condition record from batch determination CHAR 10 0 KNUMH_CH
PREFE Customs Preference CHAR 1 0 PREFE
EXART Business Transaction Type CHAR 2 0 EXART
CLINT Internal Class Number NUMC 10 0 KLAH CLINT
CHMVS Batches: Exit to quantity proposal NUMC 3 0 CHMVS
ABELN Allocation Table CHAR 10 0 AUKO ABELN
ABELP Allocation Table Item NUMC 5 0 AUPO ABELP
LFIMG_FLO Internal field/ Do not use / LFIMG in float / MUM FLTP 16 16 LFIMG_FLO
LGMNG_FLO Internal field/ Do not use / LGMNG in float / MUM FLTP 16 16 LGMNG_FLO
KCMENG_FLO Internal field/ Do not use / KCMENG in float / MUM FLTP 16 16 KCMENG_FLO
KZUMW Environmentally Relevant CHAR 1 0 KZUMW
KMPMG Component Quantity QUAN 13 3 KMPMG
AUREL Relevant to Allocation Table CHAR 1 0 AUREL
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 T006 KMEIN
NETPR Net Price CURR 11 2 NETPR
NETWR Net Value in Document Currency CURR 15 2 NETWR
KOWRR Statistical Values CHAR 1 0 KOWRR
KZBEW Movement Indicator CHAR 1 0 KZBEW
MFRGR Material freight group CHAR 8 0 TMFG MFRGR
CHHPV Pack accumulated batches / movement type item CHAR 1 0 CHHPV
ABFOR Form of payment guarantee CHAR 2 0 T691K ABSFORM_CM
ABGES Guaranteed (factor between 0 and 1) FLTP 16 16 ABGES_CM
MBUHR Material Staging Time (Local, Relating to a Plant) TIMS 6 0 MBUHR
WKTNR Value Contract No. CHAR 10 0 VBAK WKTNR
WKTPS Value Contract Item NUMC 6 0 VBAP WKTPS
J_1BCFOP CFOP Code and Extension CHAR 10 0 J_1BAG J_1BCFOP
J_1BTAXLW1 Tax law: ICMS CHAR 3 0 J_1BATL1 J_1BTAXLW1
J_1BTAXLW2 Tax law: IPI CHAR 3 0 J_1BATL2 J_1BTAXLW2
J_1BTXSDC SD tax code CHAR 2 0 J_1BTXSDC J_1BTXSDC_
SITUA Indicator for situation CHAR 2 0 SITUA
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
RSART Record type CHAR 1 0 RSART
KANNR KANBAN/Sequence Number CHAR 35 0 KANNR
KZFME ID: Leading unit of measure for completing a transaction CHAR 1 0 KZFME
PROFL Dangerous Goods Indicator Profile CHAR 3 0 TDG41 ADGE_PROFL
KCMENGVME Cumulative batch quantity of all split items in sales units QUAN 15 3 KCMENG_VME
KCMENGVMEF Cumulated batch split quantity in VRKME and float FLTP 16 16 KCMENGVMEF
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
PSPNR Project (internal) NUMC 8 0 PS_INTNR
EPRIO Withdrawal Sequence Group for Stocks CHAR 4 0 EPRIO
RULES Stock Determination Rule CHAR 4 0 T434R BF_RULES
KZBEF Indicator Inventory Management active CHAR 1 0 LVS_KZBEF
MPROF Mfr part profile CHAR 4 0 MPROF
EMATN Material number corresponding to manufacturer part number CHAR 40 0 MARA EMATN
LGBZO Staging Area for Warehouse Complex CHAR 10 0 T30C LGBZO
HANDLE Worldwide unique key for LIPS-VBELN & LIPS_POSNR CHAR 22 0 TSEGGUID_LIPS
VERURPOS Distribution delivery: Original item NUMC 6 0 VERURPOS
LIFEXPOS External item number NUMC 6 0 LIFEXPOS
NOATP Indicator: deactivate availability check CHAR 1 0 NO_ATP_CHECK
NOPCK Indicator: not relevant for picking CHAR 1 0 NO_PICKING
RBLVS Reference movement type for WM from material movements NUMC 3 0 RBLVS
BERID MRP Area CHAR 10 0 MDLV BERID
BESTQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
UMBSQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
UMMAT Receiving/Issuing Material CHAR 40 0 UMMAT
UMWRK Receiving plant/issuing plant CHAR 4 0 UMWRK
UMLGO Receiving/issuing storage location CHAR 4 0 UMLGO
UMCHA Receiving/Issuing Batch CHAR 10 0 UMCHA
UMBAR Valuation Type of Transfer Batch CHAR 10 0 UMBAR
UMSOK Special stock indicator for physical stock transfer CHAR 1 0 UMSOK
SONUM Special Stock Number CHAR 16 0 LVS_SONUM
USONU Special Stock Number CHAR 16 0 LVS_SONUM
AKKUR Exchange rate for letter-of-credit procg in foreign trade DEC 9 5 AKKUR
AKMNG Current Qty Field for Arithmetic Operations in Doc.Process. CHAR 1 0 AKMNG
VKGRU Repair Processing: Classification of Items CHAR 3 0 VKGRU
SHKZG_UM Indicator: UNMAT in main posting CHAR 1 0 SHKZG_UM
INSMK Stock Type CHAR 1 0 MB_INSMK
KZECH Determination of batch entry in the production/process order CHAR 1 0 KZECH
FLGWM Indicator: Copy dest. storage data from preceding document CHAR 1 0 FLGWM
BERKZ Material Staging Indicator for Production Supply CHAR 1 0 BERKZ
HUPOS Indicator: Delivery item is a HU item CHAR 1 0 HUPOS
NOWAB Indicator: Item Not Relevant for Goods Movements CHAR 1 0 NOWAB
KONTO G/L Account Number CHAR 10 0 SAKNR
KZEAR Final Issue for Reservation CHAR 1 0 KZEAR
HSDAT Date of Manufacture DATS 8 0 HSDAT
VFDAT Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFBNR Document No. of a Reference Document CHAR 10 0 LFBNR
LFPOS Item of a Reference Document NUMC 4 0 LFPOS
GRUND Reason for goods movment NUMC 4 0 MB_GRUND
FOBWA Subsequent movement type CHAR 3 0 FOBWA
DLVTP Delivery Category CHAR 2 0 DLVTP
EXBWR Externally Entered Posting Amount in Local Currency CURR 13 2 EXBWR
BPMNG Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
EXVKW Externally Entered Sales Value in Local Currency CURR 13 2 EXVKW
CMPRE_FLT Item Credit Price FLTP 16 16 CMPRE_FLT
KZPOD POD indicator (relevance, verification, confirmation) CHAR 1 0 KZPOD
LFDEZ Not relevant for distribution for WMS CHAR 1 0 LFDEZ
UMREV Conversion Factor of Delivery Quantity VRKME for MEINS FLTP 16 16 LE_UMREV
PODREL POD Control (Proof of Delivery) CHAR 1 0 PODREL
KZUML Stock transfer/transfer posting CHAR 1 0 KZUML
FKBER Functional Area CHAR 16 0 FKBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
KZWSO Units of measure usage CHAR 1 0 KZWSO
GMCONTROL Goods Movement Control CHAR 1 0 GMCONTROL
POSTING_CHANGE Goods Movement Control: HU CHAR 1 0 POSTING_CHANGE
UM_PS_PSP_PNR Receiving/Issuing (WBS Element) NUMC 8 0 UM_PS_PSP_PNR
PRE_VL_ETENS Sequential Number of Supplier Confirmation NUMC 4 0 ETENS
SPE_GEN_ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
SPE_SCRAP_IND Scrap Indicator for EWM Processing CHAR 1 0 /SPE/DELIVERY_SCRAP_IND
SPE_AUTH_NUMBER Return Material Authorization Number CHAR 20 0 /SPE/RET_RMA
SPE_INSPOUT_GUID Inspections: Inspection outcome GUID set by EWM RAW 16 0 /SPE/INSP_OUT_GUID_16
SPE_FOLLOW_UP Default Follow-Up Activity Code CHAR 4 0 /SPE/RET_FOLLOW_UP
SPE_EXP_DATE_EXT End date of validity period of returns delivery DEC 15 0 /SPE/RET_EXPIRY_DATE_EXT
SPE_EXP_DATE_INT End date of internal validity period of returns delivery DEC 15 0 /SPE/RET_EXPIRY_DATE_INT
SPE_AUTH_COMPLET RMA completion indicator CHAR 1 0 /SPE/RET_RMA_COMPLETED
ORMNG Original Quantity of Delivery Item QUAN 13 3 ORMNG_VL
SPE_ATP_TMSTMP ATP Time Stamp DEC 15 0 /SPE/DE_ATP_TIMESTAMP
SPE_ORIG_SYS Original System Type CHAR 1 0 /SPE/INB_ORIGIN_SYS
SPE_LIEFFZ Cumulative Qty for SchedAgr - Vendor's Point of View QUAN 15 3 /SPE/LIEFFZ
SPE_IMWRK Inbound Delivery item has Status 'In Plant' CHAR 1 0 /SPE/IMWRK_ITEM
SPE_LIFEXPOS2 External item identifier CHAR 35 0 /SPE/DE_EXT_IDENT
SPE_EXCEPT_CODE Exception Code Warehouse for Quantity Difference CHAR 4 0 /SPE/INB_EXCEPT_CODE_WM
SPE_KEEP_QTY Retention Quantity for Scrap. Process in EWM QUAN 13 3 /SPE/KEEP_QUANTITY
SPE_ALTERNATE Alternate Product Number CHAR 40 0 /SPE/DE_ALTERNATE_PART_NR
SPE_MAT_SUBST Reason for material substitution CHAR 1 0 /SPE/MAT_SUBST
SPE_STRUC Structure of Items That Are Delivered Together NUMC 3 0 /SPE/STRUC
SPE_APO_QNTYFAC Numerator of Quotient for Unit of Measure Conversion DEC 5 0 APOQUANFACTOR
SPE_APO_QNTYDIV Denominator of Quotient for Unit of Measure Conversion DEC 5 0 APOQUANDIVISOR
SPE_HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 HERKL
SPE_BXP_DATE_EXT Begin date of validity period of returns delivery DEC 15 0 /SPE/RET_EXPIRY_DATE_EXT_B
SPE_VERSION Delivery Version at Confirmation NUMC 4 0 /SPE/DE_DLV_VERSION
SPE_COMPL_MVT Completion of Goods Movements after Difference Postings CHAR 1 0 /SPE/COMPL_MVT
J_1BTAXLW4 COFINS Tax Law CHAR 3 0 J_1BATL4A J_1BTAXLW4
J_1BTAXLW5 PIS Tax Law CHAR 3 0 J_1BATL5 J_1BTAXLW5
J_1BTAXLW3 ISS Tax Law CHAR 3 0 J_1BATL3 J_1BTAXLW3
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
KBNKZ Kanban Indicator CHAR 1 0 KBNKZ
FARR_RELTYPE Revenue Accounting Type CHAR 10 0 FARR_RELTYPE
SITKZ Specification for Issuing Valuated Stock in Transit CHAR 1 0 SITKZ
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
RESOURCE_ID Resource Name (Stock Identifier) CHAR 40 0 LE_RESOURCENAME_SID
UMRESOURCE_ID Resource Name (Stock Identifier Complement) CHAR 40 0 LE_RESOURCENAME_CID
FLPKZ Field Logistics Indicator CHAR 1 0 FLPKZ
LOADING_POINT Loading/Unloading Point CHAR 20 0 /SCMTMS/LOADING_POINT_ID
SOLUTION_ORDER_ID Solution Order CHAR 10 0 CRMS4_SOLO_OBJECT_ID
SOLUTION_ORDER_ITM_ID Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
SPE_HERKR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 HERKR
ITM_COMCO Commodity Code CHAR 30 0 /SAPSLL/COMCO
WEMPF Goods Recipient CHAR 12 0 WEMPF
BESTA Delivery Confirmation Status (Item) CHAR 1 0 BESTA
CMPPI Status of Credit Check Against Financial Document CHAR 1 0 CMPSI
CMPPJ Status of Credit Check Against Export Credit Insurance CHAR 1 0 CMPSJ
FKIVP Intercompany Billing Status (Item) CHAR 1 0 FKIVP
FKSTA Delivery-Related Billing Status (Item) CHAR 1 0 FKSTA
GBSTA Overall Processing Status (Item) CHAR 1 0 GBSTA
HDALL Inbound Delivery Item Not Yet Complete (on Hold) CHAR 1 0 /SPE/INB_HDALL_ITM
KOQUA Confirmation Status of Picking/Putaway CHAR 1 0 KOQUA
KOSTA Picking Status/Putaway Status (Item) CHAR 1 0 KOSTA
LVSTA Status of Warehouse Management Activities (Item) CHAR 1 0 LVSTA
PDSTA POD status on item level CHAR 1 0 PDSTA
PKSTA Packing Status (Item) CHAR 1 0 PKSTA
UVALL Incompletion Status (Item) CHAR 1 0 UVALL_UP
UVFAK Billing Incompletion Status (Item) CHAR 1 0 UVFAK_UP
UVPAK Packing Incompletion Status (Item) CHAR 1 0 UVPAP_UP
UVPIK Picking/Putaway Incompletion Status (Item) CHAR 1 0 UVPIP_UP
UVVLK Delivery Incompletion Status (Item) CHAR 1 0 UVVLK_UP
UVWAK Goods Movement Incompletion Status (Item) CHAR 1 0 UVWAP_UP
VLSTP Decentralized whse processing CHAR 1 0 VLSTP
WBSTA Goods Movement Status (Item) CHAR 1 0 WBSTA
UVP01 Customer reserves 1: Item status CHAR 1 0 UVP01
UVP02 Customer reserves 2: Item status CHAR 1 0 UVP02
UVP03 Item reserves 3: Item status CHAR 1 0 UVP03
UVP04 Item reserves 4: Item status CHAR 1 0 UVP04
UVP05 Customer reserves 5: Item status CHAR 1 0 UVP05
EMCST Embargo Status (Item) CHAR 1 0 /SAPSLL/EMCST
SLCST Screening Status (Item) CHAR 1 0 /SAPSLL/SLCST
LCCST Legal Control Check Status CHAR 1 0 /SAPSLL/LCCST
PCSTA Product Marketability Check Status CHAR 1 0 TDD_PCSTA_LE
DGSTA Dangerous Goods Check Status CHAR 1 0 TDD_DGSTA_LE
SDSSTA Safety Data Sheet Check Status CHAR 1 0 TDD_SDSSTA_LE
ICO_FKIVP Intercompany Billing Status (Item) CHAR 1 0 ICO_FKIVP
/SAPMP/LBASP DTUC Status CHAR 1 0 /SAPMP/LBASTAT
ARC_STATUS Excise Tax ARC Status CHAR 1 0 ET_ARC_STATUS
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
/CWM/LFIMG Actual Delivered Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/LFIMG
/CWM/LFIME CWM Delivery Unit of Measure UNIT 3 0 * /CWM/LFIME
/CWM/PIKMG Quantity Picked/Placed in Storage in Parallel UoM QUAN 13 3 /CWM/PIKMG
/CWM/PIKME Picked/Stored Parallel Unit of Measure UNIT 3 0 * /CWM/PIKME
/CWM/XENTER Indicator Stating Whether Quantity Clearly Entered in PUoM CHAR 1 0 /CWM/XENTER
/CWM/XTAENTER Indicator Stating Whether Qty to Be Entered in PUoM in TO CHAR 1 0 /CWM/XTAENTER
/CWM/KCMENG Cumulatd CWM Batch Quantity of all Split Items (in StckUnit) QUAN 15 3 /CWM/KCMENG
/CWM/EBUMG Quantity to Be Posted in PUoM QUAN 15 3 /CWM/EBUMG
DUMMY_DELITM_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
ICO_VGTYP Intercompany Reference Document Category CHAR 4 0 ICO_VGTYP
ICO_VGBEL Intercompany Reference Document ID CHAR 10 0 ICO_VGBEL
ICO_VGPOS Intercompany Reference Document Item ID NUMC 6 0 ICO_VGPOS
ICO_FKAIV Intercompany Billing Type CHAR 4 0 * ICO_FKAIV
ICO_VKOIV Sales Organization for Intercompany Billing CHAR 4 0 * ICO_VKOIV
ICO_PIOIV Factory Calendar Identification for Intercompany Billing CHAR 2 0 * ICO_PIOIV
ICO_FKDIV Billing Date for Intercompany Billing DATS 8 0 ICO_FKDIV
VCM_CHAIN_UUID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
VCM_CHAIN_CATEGORY Value Chain Category CHAR 4 0 * VCM_CHAIN_CATEGORY
/KJEDM/INVERTED Inverted Flag CHAR 1 0 /KJEDM/INVERTED_FLAG
/SAPMP/LBA_NO DTUC Complete CHAR 1 0 /SAPMP/LBADONE
/SAPMP/ALT_CONV Mill: Indicator Provisional Conversion Factors CHAR 1 0 /SAPMP/ALT_CONV
LGTOR Door for Warehouse Number CHAR 3 0 * LGTOR
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FSH_KVGR6 Customer Group 6 CHAR 3 0 * FSH_KVGR6
FSH_KVGR7 Customer Group 7 CHAR 3 0 * FSH_KVGR7
FSH_KVGR8 Customer Group 8 CHAR 3 0 * FSH_KVGR8
FSH_KVGR9 Customer Group 9 CHAR 3 0 * FSH_KVGR9
FSH_KVGR10 Customer Group 10 CHAR 3 0 * FSH_KVGR10
FSH_VAS_REL VAS Relevant CHAR 1 0 FSH_VAS_REL
FSH_VAS_PRNT_ID Delivery Item NUMC 6 0 POSNR_VL
FSH_TRANSACTION Transaction Number CHAR 10 0 FSH_TRANSACTION
FSH_ITEM_GROUP Item Group NUMC 5 0 FSH_ITEM_GROUP
FSH_ITEM Item Number NUMC 5 0 FSH_ITEM
FSH_RSNUM Number of reservation/dependent requirements NUMC 10 0 * RSNUM
FSH_RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
MILL_UCDET Batch Determination for Original Batches CHAR 1 0 MILL_UCDET
CONS_ORDER Purchase Order for Consignment CHAR 1 0 WRF_CONS_ORDER
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3
/ Relationships

LIPS foreign keys.

Table Field Check Table Description Check Field
LIPS ABELN AUKO Allocation Table Document Header ABELN
LIPS ABELP AUPO Allocation Table Document Item ABELN
LIPS ABELP AUPO Allocation Table Document Item ABELP
LIPS ABFOR T691K Forms of payment guarantee ABSFO
LIPS ABRLI VBLB Sales document: Release order data MANDT
LIPS ABRLI VBLB Sales document: Release order data VBELN
LIPS ABRLI VBLB Sales document: Release order data POSNR
LIPS ABRVW TVLV Check table for release orders: Usage ID ABRVW
LIPS ABTNR TSAB Contact persons: standard departments MANDT
LIPS ABTNR TSAB Contact persons: standard departments ABTNR
LIPS AKTNR WAKH Promotion Header Data, IS-R MANDT
LIPS AKTNR WAKH Promotion Header Data, IS-R AKTNR
LIPS AUFNR AUFK Order master data AUFNR
LIPS BEDAR_LF T459K Control table for customer requirements MANDT
LIPS BERID MDLV Customizing MRP Area MANDT
LIPS BERID MDLV Customizing MRP Area BERID
LIPS BWART T156 Movement Type MANDT
LIPS BWART T156 Movement Type BWART
LIPS BWLVS T333 WM Movement Types MANDT
LIPS BWLVS T333 WM Movement Types LGNUM
LIPS BWTAR T149D Global Valuation Types MANDT
LIPS BWTAR T149D Global Valuation Types BWTAR
LIPS CHARG MCHA Batches MANDT
LIPS CHARG MCHA Batches WERKS
LIPS CHARG MCHA Batches CHARG
LIPS CLINT KLAH Class Header Data MANDT
LIPS CLINT KLAH Class Header Data CLINT
LIPS EMATN MARA General Material Data MANDT
LIPS EMATN MARA General Material Data MATNR
LIPS ETTYP TVEP Sales Document: Schedule Line Categories ETTYP
LIPS FAKSP TVFS Billing: Reasons for Blocking FAKSP
LIPS GEWEI T006 Units of Measurement MANDT
LIPS GEWEI T006 Units of Measurement MSEHI
LIPS GSBER TGSB Business Areas MANDT
LIPS GSBER TGSB Business Areas GSBER
LIPS J_1BCFOP J_1BAG CFOP MANDT
LIPS J_1BTAXLW4 J_1BATL4A Tax Laws COFINS MANDT
LIPS J_1BTAXLW5 J_1BATL5 PIS Tax Law MANDT
LIPS J_1BTXSDC J_1BTXSDC SD tax codes MANDT
LIPS KCGEWEI T006 Units of Measurement MANDT
LIPS KCGEWEI T006 Units of Measurement MSEHI
LIPS KCVOLEH T006 Units of Measurement MANDT
LIPS KCVOLEH T006 Units of Measurement MSEHI
LIPS KMEIN T006 Units of Measurement MANDT
LIPS KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
LIPS KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
LIPS KOKRS TKA01 Controlling Areas MANDT
LIPS KOSTL CSKS Cost Center Master Record MANDT
LIPS KOSTL CSKS Cost Center Master Record KOKRS
LIPS KOSTL CSKS Cost Center Master Record KOSTL
LIPS KOSTL CSKS Cost Center Master Record DATBI
LIPS KVGR1 TVV1 Customer Group 1 MANDT
LIPS KVGR1 TVV1 Customer Group 1 KVGR1
LIPS KVGR2 TVV2 Customer Group 2 MANDT
LIPS KVGR2 TVV2 Customer Group 2 KVGR2
LIPS KVGR3 TVV3 Customer Group 3 KVGR3
LIPS KVGR4 TVV4 Customer Group 4 MANDT
LIPS KVGR4 TVV4 Customer Group 4 KVGR4
LIPS KVGR5 TVV5 Customer Group 5 MANDT
LIPS KVGR5 TVV5 Customer Group 5 KVGR5
LIPS LADGR TLGR Routes: Loading Groups LADGR
LIPS LGBZO T30C WM Materials Staging Zones MANDT
LIPS LGBZO T30C WM Materials Staging Zones LGNUM
LIPS LGBZO T30C WM Materials Staging Zones LGBZO
LIPS LGNUM T300 WM Warehouse Numbers MANDT
LIPS LGNUM T300 WM Warehouse Numbers LGNUM
LIPS LGORT T001L Storage Locations MANDT
LIPS LGORT T001L Storage Locations WERKS
LIPS LGPLA LAGP Storage bins MANDT
LIPS LGPLA LAGP Storage bins LGNUM
LIPS LGPLA LAGP Storage bins LGPLA
LIPS LGTYP T301 WM Storage Types MANDT
LIPS LGTYP T301 WM Storage Types LGNUM
LIPS LGTYP T301 WM Storage Types LGTYP
LIPS MAGRV TVEGR Material Group: Packaging Materials MANDT
LIPS MAGRV TVEGR Material Group: Packaging Materials MAGRV
LIPS MANDT T000 Clients MANDT
LIPS MATKL T023 Material Groups MATKL
LIPS MATNR MARA General Material Data MANDT
LIPS MATNR MARA General Material Data MATNR
LIPS MATWA MARA General Material Data MANDT
LIPS MATWA MARA General Material Data MATNR
LIPS MEINS T006 Units of Measurement MANDT
LIPS MEINS T006 Units of Measurement MSEHI
LIPS MFRGR TMFG Material freight groups MANDT
LIPS MFRGR TMFG Material freight groups MFRGR
LIPS MTART T134 Material Types MANDT
LIPS MTART T134 Material Types MTART
LIPS MTVFP TMVF Availability Check Control MTVFP
LIPS MVGR1 TVM1 Material Pricing Group 1 MVGR1
LIPS MVGR2 TVM2 Material Pricing Group 2 MVGR2
LIPS MVGR3 TVM3 Material Pricing Group 3 MVGR3
LIPS MVGR4 TVM4 Material Pricing Group 4 MANDT
LIPS MVGR4 TVM4 Material Pricing Group 4 MVGR4
LIPS MVGR5 TVM5 Material Pricing Group 5 MANDT
LIPS MVGR5 TVM5 Material Pricing Group 5 MVGR5
LIPS PRBME T006 Units of Measurement MANDT
LIPS PRODH T179 Materials: Product Hierarchies PRODH
LIPS PROFL TDG41 DG: DG Indicator Profiles for Material Master MANDT
LIPS PROFL TDG41 DG: DG Indicator Profiles for Material Master PROFL
LIPS PSTYV TVPT Sales Documents: Item categories MANDT
LIPS PSTYV TVPT Sales Documents: Item categories PSTYV
LIPS QPLOS QALS Inspection lot record MANDANT
LIPS RULES T434R Stock determination rule MANDT
LIPS SERAIL T377P Serial Number Management Profiles MANDT
LIPS SERNR SNUM BOM explosion number MANDT
LIPS SOBKZ T148 Special Stock Indicator MANDT
LIPS SOBKZ T148 Special Stock Indicator SOBKZ
LIPS SPART TSPA Organizational Unit: Sales Divisions MANDT
LIPS SPART TSPA Organizational Unit: Sales Divisions SPART
LIPS TRAGR TTGR Delivery Scheduling: Transportation Groups TRAGR
LIPS UECHA LIPS SD document: Delivery: Item data MANDT
LIPS UECHA LIPS SD document: Delivery: Item data VBELN
LIPS UECHA LIPS SD document: Delivery: Item data POSNR
LIPS UEPOS LIPS SD document: Delivery: Item data MANDT
LIPS UEPOS LIPS SD document: Delivery: Item data VBELN
LIPS UEPOS LIPS SD document: Delivery: Item data POSNR
LIPS VBELN LIKP SD Document: Delivery Header Data MANDT
LIPS VBELN LIKP SD Document: Delivery Header Data VBELN
LIPS VGSYS TBDLS Logical system LOGSYS
LIPS VKBUR TVBUR Organizational Unit: Sales Offices MANDT
LIPS VKGRP TVKGR Organizational Unit: Sales Groups MANDT
LIPS VOLEH T006 Units of Measurement MANDT
LIPS VOLEH T006 Units of Measurement MSEHI
LIPS VPMAT MARA General Material Data MANDT
LIPS VPMAT MARA General Material Data MATNR
LIPS VPWRK T001W Plants/Branches MANDT
LIPS VPWRK T001W Plants/Branches WERKS
LIPS VRKME T006 Units of Measurement MANDT
LIPS VRKME T006 Units of Measurement MSEHI
LIPS VTWEG TVTW Organizational Unit: Distribution Channels MANDT
LIPS VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
LIPS WERKS T001W Plants/Branches MANDT
LIPS WERKS T001W Plants/Branches WERKS
LIPS WKTNR VBAK Sales Document: Header Data MANDT
LIPS WKTNR VBAK Sales Document: Header Data VBELN
LIPS WKTPS VBAP Sales Document: Item Data VBELN
LIPS WKTPS VBAP Sales Document: Item Data POSNR
Back to SAP tables