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

SAP Table LIPS

SD document: Delivery: Item data

LIPS (SD document: Delivery: Item 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 LIPS to other SAP tables.

LIPS table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
 MANDT T000
CLNT
 3 0
VBELN
Delivery
 VBELN_VL VBUK
CHAR
 10 0
POSNR
Delivery Item
 POSNR_VL VBUP
NUMC
 6 0
PSTYV
Delivery item category
 PSTYV_VL TVPT
CHAR
 4 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
MATNR
Material Number
 MATNR MARA
CHAR
 18 0
MATWA
Material entered
 MATWA MARA
CHAR
 18 0
MATKL
Material Group
 MATKL T023
CHAR
 9 0
WERKS
Plant
 WERKS_D T001W
CHAR
 4 0
LGORT
Storage Location
 LGORT_D T001L
CHAR
 4 0
CHARG
Batch Number
 CHARG_D MCHA
CHAR
 10 0
LICHN
Vendor Batch Number
 LICHN
CHAR
 15 0
KDMAT
Material belonging to the customer
 KDMAT
CHAR
 35 0
PRODH
Product hierarchy
 PRODH_D T179
CHAR
 18 0
LFIMG
Actual quantity delivered (in sales units)
 LFIMG
QUAN
 13 3
MEINS
Base Unit of Measure
 MEINS T006
UNIT
 3 0
VRKME
Sales unit
 VRKME T006
UNIT
 3 0
UMVKZ
Numerator (factor) for conversion of sales quantity into SKU
 UMVKZ
DEC
 5 0
UMVKN
Denominator (Divisor) for Conversion of Sales Qty into SKU
 UMVKN
DEC
 5 0
NTGEW
Net weight
 NTGEW_15
QUAN
 15 3
BRGEW
Gross weight
 BRGEW_15
QUAN
 15 3
GEWEI
Weight Unit
 GEWEI T006
UNIT
 3 0
VOLUM
Volume
 VOLUM_15
QUAN
 15 3
VOLEH
Volume unit
 VOLEH T006
UNIT
 3 0
KZTLF
Partial delivery at item level
 KZTLF
CHAR
 1 0
UEBTK
Indicator: Unlimited Overdelivery Allowed
 UEBTK
CHAR
 1 0
UEBTO
Overdelivery Tolerance Limit
 UEBTO
DEC
 3 1
UNTTO
Underdelivery Tolerance Limit
 UNTTO
DEC
 3 1
CHSPL
Batch split allowed
 CHSPL
CHAR
 1 0
FAKSP
Block
 FAKSP TVFS
CHAR
 2 0
MBDAT
Material Staging/Availability Date
 MBDAT
DATS
 8 0
LGMNG
Actual quantity delivered in stockkeeping units
 LGMNG
QUAN
 13 3
ARKTX
Short text for sales order item
 ARKTX
CHAR
 40 0
LGPBE
Storage Bin
 LGPBE
CHAR
 10 0
VBELV
Originating document
 VBELV VBUK
CHAR
 10 0
POSNV
Originating item
 POSNV VBUP
NUMC
 6 0
VBTYV
SD document category
 VBTYP
CHAR
 1 0
VGSYS
Logical System in the Preceding Document
 VGLOGSYS TBDLS
CHAR
 10 0
VGBEL
Document number of the reference document
 VGBEL VBUK
CHAR
 10 0
VGPOS
Item number of the reference item
 VGPOS VBUP
NUMC
 6 0
UPFLU
Update indicator for delivery document flow
 UPFLL
CHAR
 1 0
UEPOS
Higher-level item in bill of material structures
 UEPOS VBUP
NUMC
 6 0
FKREL
Relevant for Billing
 FKREL
CHAR
 1 0
LADGR
Loading Group
 LADGR TLGR
CHAR
 4 0
TRAGR
Transportation Group
 TRAGR TTGR
CHAR
 4 0
KOMKZ
Indicator for picking control
 KOMKZ
CHAR
 1 0
LGNUM
Warehouse Number / Warehouse Complex
 LGNUM T300
CHAR
 3 0
LISPL
Split to warehouse number required
 LNSPL_LIPS
CHAR
 1 0
LGTYP
Storage Type
 LGTYP T301
CHAR
 3 0
LGPLA
Storage Bin
 LGPLA LAGP
CHAR
 10 0
BWTEX
Indicator: Separate valuation
 BWTEX
CHAR
 1 0
BWART
Movement Type (Inventory Management)
 BWART T156
CHAR
 3 0
BWLVS
Movement Type for Warehouse Management
 BWLVS T333
NUMC
 3 0
KZDLG
Indicator: dynamic storage bin in warehouse management
 LVS_KZDLG
CHAR
 1 0
BDART
Requirement type
 BDART
CHAR
 2 0
PLART
Planning type
 PLART
CHAR
 1 0
MTART
Material Type
 MTART T134
CHAR
 4 0
XCHPF
Batch management requirement indicator
 XCHPF
CHAR
 1 0
XCHAR
Batch management indicator (internal)
 XCHAR
CHAR
 1 0
VGREF
Preceding document has resulted from reference
 VGREF
CHAR
 1 0
POSAR
Item type
 POSAR
CHAR
 1 0
BWTAR
Valuation Type
 BWTAR_D T149D
CHAR
 10 0
SUMBD
Summing up of requirements
 SUMBD
CHAR
 1 0
MTVFP
Checking Group for Availability Check
 MTVFP TMVF
CHAR
 2 0
EANNR
European Article Number (EAN) - obsolete!!!!!
 EANNR
CHAR
 13 0
GSBER
Business Area
 GSBER TGSB
CHAR
 4 0
VKBUR
Sales Office
 VKBUR TVBUR
CHAR
 4 0
VKGRP
Sales Group
 VKGRP TVKGR
CHAR
 3 0
VTWEG
Distribution Channel
 VTWEG TVTW
CHAR
 2 0
SPART
Division
 SPART TSPA
CHAR
 2 0
GRKOR
Delivery group (items are delivered together)
 GRKOR
NUMC
 3 0
FMENG
Quantity is Fixed
 FMENG
CHAR
 1 0
ANTLF
Maximum Number of Partial Deliveries Allowed Per Item
 ANTLF
DEC
 1 0
VBEAF
Fixed shipping processing time in days (= setup time)
 VBEAF
DEC
 5 2
VBEAV
Variable shipping processing time in days
 VBEAV
DEC
 5 2
STAFO
Update group for statistics update
 STAFO
CHAR
 6 0
WAVWR
Cost in document currency
 WAVWR
CURR
 13 2
KZWI1
Subtotal 1 from pricing procedure for condition
 KZWI1
CURR
 13 2
KZWI2
Subtotal 2 from pricing procedure for condition
 KZWI2
CURR
 13 2
KZWI3
Subtotal 3 from pricing procedure for condition
 KZWI3
CURR
 13 2
KZWI4
Subtotal 4 from pricing procedure for condition
 KZWI4
CURR
 13 2
KZWI5
Subtotal 5 from pricing procedure for condition
 KZWI5
CURR
 13 2
KZWI6
Subtotal 6 from pricing procedure for condition
 KZWI6
CURR
 13 2
SOBKZ
Special Stock Indicator
 SOBKZ T148
CHAR
 1 0
AEDAT
Changed On
 AEDAT
DATS
 8 0
EAN11
International Article Number (EAN/UPC)
 EAN11
CHAR
 18 0
KVGR1
Customer group 1
 KVGR1 TVV1
CHAR
 3 0
KVGR2
Customer group 2
 KVGR2 TVV2
CHAR
 3 0
KVGR3
Customer group 3
 KVGR3 TVV3
CHAR
 3 0
KVGR4
Customer group 4
 KVGR4 TVV4
CHAR
 3 0
KVGR5
Customer group 5
 KVGR5 TVV5
CHAR
 3 0
MVGR1
Material group 1
 MVGR1 TVM1
CHAR
 3 0
MVGR2
Material group 2
 MVGR2 TVM2
CHAR
 3 0
MVGR3
Material group 3
 MVGR3 TVM3
CHAR
 3 0
MVGR4
Material group 4
 MVGR4 TVM4
CHAR
 3 0
MVGR5
Material group 5
 MVGR5 TVM5
CHAR
 3 0
VPZUO
Allocation Indicator
 VPZUO
CHAR
 1 0
VGTYP
SD document category
 VBTYP
CHAR
 1 0
RFVGTYP
Type of preceding document in central system
 RFVGTYP
CHAR
 1 0
KOSTL
Cost Center
 KOSTL CSKS
CHAR
 10 0
KOKRS
Controlling Area
 KOKRS TKA01
CHAR
 4 0
PAOBJNR
Profitability Segment Number (CO-PA)
 RKEOBJNR
NUMC
 10 0
PRCTR
Profit Center
 PRCTR
CHAR
 10 0
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
 PS_PSP_PNR
NUMC
 8 0
AUFNR
Order Number
 AUFNR AUFK
CHAR
 12 0
POSNR_PP
Order Item Number
 CO_POSNR
NUMC
 4 0
KDAUF
Sales Order Number
 KDAUF
CHAR
 10 0
KDPOS
Item Number in Sales Order
 KDPOS
NUMC
 6 0
VPMAT
Planning material
 VPMAT MARA
CHAR
 18 0
VPWRK
Planning plant
 VPWRK T001W
CHAR
 4 0
PRBME
Base unit of measure for product group
 PRBME T006
UNIT
 3 0
UMREF
Conversion factor: quantities
 UMREFF
FLTP
 16 16
KNTTP
Account Assignment Category
 KNTTP T163K
CHAR
 1 0
KZVBR
Consumption Posting
 KZVBR
CHAR
 1 0
FIPOS
Commitment Item
 FIPOS
CHAR
 14 0
FISTL
Funds Center
 FISTL
CHAR
 16 0
GEBER
Fund
 BP_GEBER
CHAR
 10 0
PCKPF
Packing control
 PCKPF
CHAR
 1 0
BEDAR_LF
Requirements class
 BEDAR T459K
CHAR
 3 0
CMPNT
ID: Item with active credit function / relevant for credit
 CMPNT
CHAR
 1 0
KCMENG
Cumulative batch quantity of all split items (in StckUnit)
 KCMENG
QUAN
 15 3
KCBRGEW
Cumulative gross weight of all batch split items
 KCBRGEW
QUAN
 15 3
KCNTGEW
Cumulative net weight of all batch split items
 KCNTGEW
QUAN
 15 3
KCVOLUM
Cumulative volume of all batch split items
 KCVOLUM
QUAN
 15 3
UECHA
Higher-Level Item of Batch Split Item
 UECHA LIPS
NUMC
 6 0
CUOBJ
Configuration
 CUOBJ_VA
NUMC
 18 0
CUOBJ_CH
Internal object number of the batch classification
 CUOBJ_CH
NUMC
 18 0
ANZSN
Number of serial numbers
 ANZSN
INT4
 10 0
SERAIL
Serial Number Profile
 SERAIL T377P
CHAR
 4 0
KCGEWEI
Weight Unit
 GEWEI T006
UNIT
 3 0
KCVOLEH
Volume unit
 VOLEH T006
UNIT
 3 0
SERNR
BOM explosion number
 SERNR SNUM
CHAR
 8 0
ABRLI
Internal delivery schedule number
 ABRLI VBLB
NUMC
 4 0
ABART
Release type
 ABART
CHAR
 1 0
ABRVW
Usage Indicator
 ABRVW TVLV
CHAR
 3 0
QPLOS
Inspection Lot Number
 QPLOS QALS
NUMC
 12 0
QTLOS
Partial lot number
 QTLOS
NUMC
 6 0
NACHL
Customer has not posted goods receipt
 NACHL
CHAR
 1 0
MAGRV
Material Group: Packaging Materials
 MAGRV TVEGR
CHAR
 4 0
OBJKO
Object number at header level
 OBJKO
CHAR
 22 0
OBJPO
Object number at item level
 OBJPO
CHAR
 22 0
AESKD
Customer Engineering Change Status
 AESKD
CHAR
 17 0
SHKZG
Returns Item
 SHKZG_VA
CHAR
 1 0
PROSA
ID for material determination
 PROSA
CHAR
 1 0
UEPVW
ID for higher-level item usage
 UEPVW
CHAR
 1 0
EMPST
Receiving point
 EMPST
CHAR
 25 0
ABTNR
Department number
 ABTNR TSAB
CHAR
 4 0
KOQUI
Picking is subject to confirmation
 KOQUI
CHAR
 1 0
STADAT
Statistics date
 STADAT
DATS
 8 0
AKTNR
Promotion
 WAKTION WAKH
CHAR
 10 0
KNUMH_CH
Number of condition record from batch determination
 KNUMH_CH
CHAR
 10 0
PREFE
Preference indicator in export/import
 PREFE
CHAR
 1 0
EXART
Business Transaction Type for Foreign Trade
 EXART
CHAR
 2 0
CLINT
Internal Class Number
 CLINT KLAH
NUMC
 10 0
CHMVS
Batches: Exit to quantity proposal
 CHMVS
NUMC
 3 0
ABELN
Allocation Table Number
 ABELN AUKO
CHAR
 10 0
ABELP
Item number of allocation table
 ABELP AUPO
NUMC
 5 0
LFIMG_FLO
Internal field/ Do not use / LFIMG in float / MUM
 LFIMG_FLO
FLTP
 16 16
LGMNG_FLO
Internal field/ Do not use / LGMNG in float / MUM
 LGMNG_FLO
FLTP
 16 16
KCMENG_FLO
Internal field/ Do not use / KCMENG in float / MUM
 KCMENG_FLO
FLTP
 16 16
KZUMW
Environmentally Relevant
 KZUMW
CHAR
 1 0
KMPMG
Component quantity
 KMPMG
QUAN
 13 3
AUREL
Relevant to Allocation Table
 AUREL
CHAR
 1 0
KPEIN
Condition pricing unit
 KPEIN
DEC
 5 0
KMEIN
Condition unit
 KMEIN T006
UNIT
 3 0
NETPR
Net price
 NETPR
CURR
 11 2
NETWR
Net Value in Document Currency
 NETWR
CURR
 15 2
KOWRR
Statistical values
 KOWRR
CHAR
 1 0
KZBEW
Movement Indicator
 KZBEW
CHAR
 1 0
MFRGR
Material freight group
 MFRGR TMFG
CHAR
 8 0
CHHPV
Pack accumulated batches / movement type item
 CHHPV
CHAR
 1 0
ABFOR
Form of payment guarantee
 ABSFORM_CM T691K
CHAR
 2 0
ABGES
Guaranteed (factor between 0 and 1)
 ABGES_CM
FLTP
 16 16
MBUHR
Material Staging Time (Local, Relating to a Plant)
 MBUHR
TIMS
 6 0
WKTNR
Value contract no.
 WKTNR VBUK
CHAR
 10 0
WKTPS
Value contract item
 WKTPS VBUP
NUMC
 6 0
J_1BCFOP
CFOP Code and Extension
 J_1BCFOP J_1BAG
CHAR
 10 0
J_1BTAXLW1
Tax law: ICMS
 J_1BTAXLW1 J_1BATL1
CHAR
 3 0
J_1BTAXLW2
Tax law: IPI
 J_1BTAXLW2 J_1BATL2
CHAR
 3 0
J_1BTXSDC
SD tax code
 J_1BTXSDC_ J_1BTXSDC
CHAR
 2 0
SITUA
Indicator for situation
 SITUA
CHAR
 2 0
RSNUM
Number of Reservation/Dependent Requirement
 RSNUM
NUMC
 10 0
RSPOS
Item Number of Reservation/Dependent Requirement
 RSPOS
NUMC
 4 0
RSART
Record type
 RSART
CHAR
 1 0
KANNR
KANBAN/sequence number
 KANNR
CHAR
 35 0
KZFME
ID: Leading unit of measure for completing a transaction
 KZFME
CHAR
 1 0
PROFL
Dangerous Goods Indicator Profile
 ADGE_PROFL TDG41
CHAR
 3 0
KCMENGVME
Cumulative batch quantity of all split items in sales units
 KCMENG_VME
QUAN
 15 3
KCMENGVMEF
Cumulated batch split quantity in VRKME and float
 KCMENGVMEF
FLTP
 16 16
KZBWS
Valuation of Special Stock
 KZBWS
CHAR
 1 0
PSPNR
Project definition (internal)
 PS_INTNR
NUMC
 8 0
EPRIO
Withdrawal sequence group for stocks
 EPRIO
CHAR
 4 0
RULES
Stock determination rule
 BF_RULES T434R
CHAR
 4 0
KZBEF
Indicator Inventory Management active
 LVS_KZBEF
CHAR
 1 0
MPROF
Manufacturer Part Profile
 MPROF
CHAR
 4 0
EMATN
Material Number Corresponding to Manufacturer Part Number
 EMATN MARA
CHAR
 18 0
LGBZO
Staging Area for Warehouse Complex
 LGBZO T30C
CHAR
 10 0
HANDLE
Worldwide unique key for LIPS-VBELN & LIPS_POSNR
 TSEGGUID_LIPS
CHAR
 22 0
VERURPOS
Distribution delivery: Original item
 VERURPOS
NUMC
 6 0
LIFEXPOS
External item number
 LIFEXPOS
NUMC
 6 0
NOATP
Indicator: deactivate availability check
 NO_ATP_CHECK
CHAR
 1 0
NOPCK
Indicator: not relevant for picking
 NO_PICKING
CHAR
 1 0
RBLVS
Reference movement type for WM from material movements
 RBLVS
NUMC
 3 0
BERID
MRP Area
 BERID MDLV
CHAR
 10 0
BESTQ
Stock Category in the Warehouse Management System
 BESTQ
CHAR
 1 0
UMBSQ
Stock Category in the Warehouse Management System
 BESTQ
CHAR
 1 0
UMMAT
Receiving/Issuing Material
 UMMAT
CHAR
 18 0
UMWRK
Receiving/Issuing Plant
 UMWRK
CHAR
 4 0
UMLGO
Receiving/Issuing Storage Location
 UMLGO
CHAR
 4 0
UMCHA
Receiving/Issuing Batch
 UMCHA
CHAR
 10 0
UMBAR
Valuation Type of Transfer Batch
 UMBAR
CHAR
 10 0
UMSOK
Special Stock Indicator for Physical Stock Transfer
 UMSOK
CHAR
 1 0
SONUM
Special Stock Number
 LVS_SONUM
CHAR
 16 0
USONU
Special Stock Number
 LVS_SONUM
CHAR
 16 0
AKKUR
Exchange rate for letter-of-credit procg in foreign trade
 AKKUR
DEC
 9 5
AKMNG
Current Qty Field for Arithmetic Operations in Doc.Process.
 AKMNG
CHAR
 1 0
VKGRU
Repair Processing: Classification of Items
 VKGRU
CHAR
 3 0
SHKZG_UM
Indicator: UNMAT in main posting
 SHKZG_UM
CHAR
 1 0
INSMK
Stock Type
 MB_INSMK
CHAR
 1 0
KZECH
Determination of batch entry in the production/process order
 KZECH
CHAR
 1 0
FLGWM
Indicator: Copy dest. storage data from preceding document
 FLGWM
CHAR
 1 0
BERKZ
Material Staging Indicator for Production Supply
 BERKZ
CHAR
 1 0
HUPOS
Indicator: Delivery item is a HU item
 HUPOS
CHAR
 1 0
NOWAB
Indicator: Item Not Relevant for Goods Movements
 NOWAB
CHAR
 1 0
KONTO
G/L Account Number
 SAKNR
CHAR
 10 0
KZEAR
Final Issue for This Reservation
 KZEAR
CHAR
 1 0
HSDAT
Date of Manufacture
 HSDAT
DATS
 8 0
VFDAT
Shelf Life Expiration or Best-Before Date
 VFDAT
DATS
 8 0
LFGJA
Fiscal Year of Current Period
 LFGJA
NUMC
 4 0
LFBNR
Document No. of a Reference Document
 LFBNR
CHAR
 10 0
LFPOS
Item of a Reference Document
 LFPOS
NUMC
 4 0
GRUND
Reason for goods movment
 MB_GRUND
NUMC
 4 0
FOBWA
Subsequent movement type
 FOBWA
CHAR
 3 0
DLVTP
Delivery Category
 DLVTP
CHAR
 2 0
EXBWR
Externally Entered Posting Amount in Local Currency
 EXBWR
CURR
 13 2
BPMNG
Quantity in Purchase Order Price Unit
 BPMNG
QUAN
 13 3
EXVKW
Externally Entered Sales Value in Local Currency
 EXVKW
CURR
 13 2
CMPRE_FLT
Item credit price
 CMPRE_FLT
FLTP
 16 16
KZPOD
POD indicator (relevance, verification, confirmation)
 KZPOD
CHAR
 1 0
LFDEZ
Not relevant for distribution for WMS
 LFDEZ
CHAR
 1 0
UMREV
Conversion Factor of Delivery Quantity VRKME for MEINS
 LE_UMREV
FLTP
 16 16
PODREL
POD Control (Proof of Delivery)
 PODREL
CHAR
 1 0
KZUML
Stock transfer/transfer posting
 KZUML
CHAR
 1 0
FKBER
Functional Area
 FKBER
CHAR
 16 0
GRANT_NBR
Grant
 GM_GRANT_NBR
CHAR
 20 0
KZWSO
Units of measure usage
 KZWSO
CHAR
 1 0
GMCONTROL
Goods Movement Control
 GMCONTROL
CHAR
 1 0
POSTING_CHANGE
Goods Movement Control: HU
 POSTING_CHANGE
CHAR
 1 0
UM_PS_PSP_PNR
Receiving/Issuing (WBS Element)
 UM_PS_PSP_PNR
NUMC
 8 0
PRE_VL_ETENS
Sequential Number of Vendor Confirmation
 ETENS
NUMC
 4 0
SPE_GEN_ELIKZ
"Delivery Completed" Indicator
 ELIKZ
CHAR
 1 0
SPE_SCRAP_IND
Scrap Indicator for EWM Processing
 /SPE/DELIVERY_SCRAP_IND
CHAR
 1 0
SPE_AUTH_NUMBER
Return Material Authorization Number
 /SPE/RET_RMA
CHAR
 20 0
SPE_INSPOUT_GUID
Inspections: Inspection outcome GUID set by EWM
 /SPE/INSP_OUT_GUID_16
RAW
 16 0
SPE_FOLLOW_UP
Default Follow-Up Activity Code
 /SPE/RET_FOLLOW_UP
CHAR
 4 0
SPE_EXP_DATE_EXT
End date of validity period of returns delivery
 /SPE/RET_EXPIRY_DATE_EXT
DEC
 15 0
SPE_EXP_DATE_INT
End date of internal validity period of returns delivery
 /SPE/RET_EXPIRY_DATE_INT
DEC
 15 0
SPE_AUTH_COMPLET
RMA completion indicator
 /SPE/RET_RMA_COMPLETED
CHAR
 1 0
ORMNG
Original Quantity of Delivery Item
 ORMNG_VL
QUAN
 13 3
SPE_ATP_TMSTMP
ATP Time Stamp
 /SPE/DE_ATP_TIMESTAMP
DEC
 15 0
SPE_ORIG_SYS
Original System Type
 /SPE/INB_ORIGIN_SYS
CHAR
 1 0
SPE_LIEFFZ
Cumulative Qty for SchedAgr - Vendor's Point of View
 /SPE/LIEFFZ
QUAN
 15 3
SPE_IMWRK
Inbound Delivery item has Status 'In Plant'
 /SPE/IMWRK_ITEM
CHAR
 1 0
SPE_LIFEXPOS2
External item identifier
 /SPE/DE_EXT_IDENT
CHAR
 35 0
SPE_EXCEPT_CODE
Exception Code Warehouse for Quantity Difference
 /SPE/INB_EXCEPT_CODE_WM
CHAR
 4 0
SPE_KEEP_QTY
Retention Quantity for Scrap. Process in EWM
 /SPE/KEEP_QUANTITY
QUAN
 13 3
SPE_ALTERNATE
Alternate Product Number
 /SPE/DE_ALTERNATE_PART_NR
CHAR
 40 0
SPE_MAT_SUBST
Reason for material substitution
 /SPE/MAT_SUBST
CHAR
 1 0
SPE_STRUC
Structure of Items That Are Delivered Together
 /SPE/STRUC
NUMC
 3 0
SPE_APO_QNTYFAC
Numerator of Quotient for Unit of Measure Conversion
 APOQUANFACTOR
DEC
 5 0
SPE_APO_QNTYDIV
Denominator of Quotient for Unit of Measure Conversion
 APOQUANDIVISOR
DEC
 5 0
SPE_HERKL
Country of origin of the material
 HERKL
CHAR
 3 0
SPE_BXP_DATE_EXT
Begin date of validity period of returns delivery
 /SPE/RET_EXPIRY_DATE_EXT_B
DEC
 15 0
SPE_VERSION
Delivery Version at Confirmation
 /SPE/DE_DLV_VERSION
NUMC
 4 0
SPE_COMPL_MVT
Completion of Goods Movements after Difference Postings
 /SPE/COMPL_MVT
CHAR
 1 0
J_1BTAXLW4
COFINS Tax Law
 J_1BTAXLW4 J_1BATL4A
CHAR
 3 0
J_1BTAXLW5
PIS Tax Law
 J_1BTAXLW5 J_1BATL5
CHAR
 3 0
J_1BTAXLW3
ISS Tax Law
 J_1BTAXLW3 J_1BATL3
CHAR
 3 0
BUDGET_PD
FM: Budget Period
 FM_BUDGET_PERIOD
CHAR
 10 0
KBNKZ
Kanban Indicator
 KBNKZ
CHAR
 1 0
SITKZ
Specification for Issuing Valuated Stock in Transit
 SITKZ
CHAR
 1 0
/CWM/LFIMG
Actual Delivered Quantity in Parallel Unit of Measure
 /CWM/LFIMG
QUAN
 13 3
/CWM/LFIME
CWM Delivery Unit of Measure
 /CWM/LFIME
UNIT
 3 0
/CWM/PIKMG
Quantity Picked/Placed in Storage in Parallel UoM
 /CWM/PIKMG
QUAN
 13 3
/CWM/PIKME
Picked/Stored Parallel Unit of Measure
 /CWM/PIKME
UNIT
 3 0
/CWM/XENTER
Indicator Stating Whether Quantity Clearly Entered in PUoM
 /CWM/XENTER
CHAR
 1 0
/CWM/XTAENTER
Indicator Stating Whether Qty to Be Entered in PUoM in TO
 /CWM/XTAENTER
CHAR
 1 0
/CWM/KCMENG
Cumulatd CWM Batch Quantity of all Split Items (in StckUnit)
 /CWM/KCMENG
QUAN
 15 3
/CWM/EBUMG
Quantity to Be Posted in PUoM
 /CWM/EBUMG
QUAN
 15 3
OID_EXTBOL
External bill of lading
 OID_EXTBOL
CHAR
 16 0
OID_MISCDL
Miscellaneous delivery number
 OID_MISCDL
CHAR
 16 0
OIPIPEVAL
Validation indicator for pipeline fields (X=ON, blank=OFF)
 OID_PIPEV
CHAR
 1 0
OIC_LIFNR
Account Number of Vendor or Creditor
 LIFNR LFA1
CHAR
 10 0
OIC_DCITYC
Destination city code
 OIC_DCITYC T005G
CHAR
 4 0
OIC_DCOUNC
Destination county code
 OIC_DCOUNC T005E
CHAR
 3 0
OIC_DREGIO
Destination region
 OIC_DREGIO T005S
CHAR
 3 0
OIC_DLAND1
Destination country
 OIC_DLAND1 T005
CHAR
 3 0
OIC_OCITYC
Origin city code
 OIC_OCITYC T005G
CHAR
 4 0
OIC_OCOUNC
Origin county code
 OIC_OCOUNC T005E
CHAR
 3 0
OIC_OREGIO
Origin region
 OIC_OREGIO T005S
CHAR
 3 0
OIC_OLAND1
Origin country
 OIC_OLAND1 T005
CHAR
 3 0
OIC_PORGIN
Tax origin
 OIC_PORGIN
CHAR
 15 0
OIC_PDESTN
Tax destination
 OIC_PDESTN
CHAR
 15 0
OIC_PTRIP
Pipeline trip number (external)
 OIC_PTRIP
CHAR
 16 0
OIC_PBATCH
 OIC_PBATCH
CHAR
 16 0
OIC_MOT
IS-OIL MAP external details mode of transport
 OIC_MOT TVTR
CHAR
 2 0
OIC_AORGIN
Alternate origin
 OIC_AORGIN
CHAR
 15 0
OIC_ADESTN
Alternate destination
 OIC_ADESTN
CHAR
 15 0
OIC_TRUCKN
Truck number
 OIC_TRUCKN
CHAR
 10 0
OIA_BASELO
Base location
 OIA_BASELO
CHAR
 15 0
CMETH
Quantity Conversion Method
 OIB_CMETH
CHAR
 1 0
OITAXFROM
Excise duty tax key for 'from' location
 OIH_TAXFRO OIH4
CHAR
 2 0
OIHANTYP
Excise Duty Handling Type
 OIH_HANTYP OIH5
CHAR
 2 0
OITAXGRP
Excise Duty Group
 OIH_TAXGRP OIH2
CHAR
 2 0
OITAXTO
Excise duty tax key for 'to' location
 OIH_TAXTO OIH4
CHAR
 2 0
OICERTF1
Excise tax external license number
 OIH_CERTF1
CHAR
 15 0
OIOILCON
Oil content in a material as a percentage
 OIH_OILCON
DEC
 5 2
OIDATFM1
Excise Duty License Valid from Date
 OIH_DATFM1
DATS
 8 0
OIDATTO1
Valid to date for excise duty tax certificate
 OIH_DATTO1
DATS
 8 0
OIEDBAL
Excise duty balancing is required (indicator)
 OIH_EDBAL
CHAR
 1 0
OIPRICIE
ED pricing: external (indicator)
 OIH_PRICIE
CHAR
 1 0
OIINEX
Code for internal or external excise duty rate determination
 OIH_INEX OIH16
CHAR
 2 0
OIEDBALM
Excise duty balancing method indicator
 OIH_EDBALM
CHAR
 1 0
OITAXLOD
Excise duty tax value for goods loading
 OIH_TAXLOD
CURR
 13 2
OITAXISS
Excise duty value for goods issue
 OIH_TAXISS
CURR
 13 2
OITAXINV
Excise duty tax value for an invoice
 OIH_TAXINV
CURR
 13 2
OICONTNR
Outline agreement: contract
 OIC_CONTNR
CHAR
 10 0
OIC_KMPOS
Reference contract line item number
 OIC_KMPOS
NUMC
 6 0
OIC_TIME
Time for time pricing
 OIC_LFTIM
TIMS
 6 0
OIC_DATE
Date for time pricing
 OIC_LFDAT
DATS
 8 0
OIEXGNUM
Exchange agreement number
 OIA_EXGNUM
CHAR
 10 0
OIEXGTYP
Exchange type
 OIA_EXGTYP TOIA2
CHAR
 4 0
OIFEETOT
Fee total
 OIA_FEETOT
CURR
 13 2
OIFEEDT
Fee pricing condition date
 OIA_FEEDT
DATS
 8 0
OINETCYC
Netting cycle (FI blocking indicator)
 OIA_NETCYC T008
CHAR
 1 0
OIMATREF
Material group reference for exchange balance reporting
 OIA_MATREF
CHAR
 20 0
OIFINAL
Final Delivery Indicator
 OID_FINAL
CHAR
 1 0
OIC_WATIM
Actual goods issue time (for time pricing)
 OIC_WATIM
TIMS
 6 0
OIC_WADAT
Goods issue date (for time pricing)
 OIC_WADAT
DATS
 8 0
OIH_LICTP
License type
 OIH_LICTP
CHAR
 4 0
OIH_LICIN
Excise tax internal license number
 OIH_LICIN
CHAR
 10 0
OIH_LCFOL
Follow-on license for quantity license
 OIH_LCFOL
CHAR
 10 0
OIH_FOLQTY
Excise Tax Follow-On License Quantity
 OIH_FOLQTY
QUAN
 13 3
OITRKNR
Tracking number
 OIH_TRKNR
CHAR
 10 0
OITRKJR
Tracking number year
 OIH_TRKJR
NUMC
 4 0
OIEXTNR
External tracking number
 OIH_EXTNR
CHAR
 18 0
OIITMNR
Tracking number item line
 OIH_ITMNR
NUMC
 5 0
OIFTIND
Final transfer indicator
 OIH_FTIND
CHAR
 1 0
OIPRIOP
Price options for gain calculation
 OIH_PRIOP
CHAR
 1 0
OITRIND
Transfer sign for plant-to-plant transfers
 OIH_TRIND
CHAR
 1 0
OIGHNDL
Gain handling
 OIH_GHNDL
CHAR
 1 0
OIUMBAR
Valuation type of issuing location for two-step transfer
 OIH_UMBAR T149D
CHAR
 10 0
OISBREL
Sub product/ base product relevence indicator
 OIA_SBREL
NUMC
 3 0
OIBASPROD
Base product number
 OIA_SBMAT
CHAR
 18 0
OIGNRULE
Gross/net pricing rule
 OIC_GNRULE
NUMC
 3 0
OITITLE
Location of title transfer for Incoterms purposes
 OIC_TITLE
CHAR
 1 0
OIA_IPMVAT
VAT on internally-posted material
 OIA_IPMVAT
CHAR
 1 0
OIA_FFTYP
Fulfillment indicator for exchange assignments
 OIA_FFTYP
CHAR
 1 0
OII_CONWK
OIL-BDRP: Consignment stock receiving plant in delivery
 OII_CONWK
CHAR
 4 0
OII_CONLG
OIL-BDRP: Consignment stock receiving s/loc in delivery
 OII_CONLG
CHAR
 4 0
OIEDBAL_GI
Excise Duty Balancing is Required for Mat. (STO)
 OIH_EDBAL_GI
CHAR
 1 0
OIEDBALM_GI
Excise Duty Balancing Method Indicator for Mat. (STO)
 OIH_EDBALM_GI
CHAR
 1 0
OICERTF1_GI
Excise Tax External License Number Used During GI (STO)
 OIH_CERTF1_GI
CHAR
 15 0
OIDATFM1_GI
Excise Duty License Valid from Date for Mat. (STO)
 OIH_DATFM1_GI
DATS
 8 0
OIDATTO1_GI
Valid To Date for Excise Duty Tax Certificate for Mat. (STO)
 OIH_DATTO1_GI
DATS
 8 0
OIH_LICTP_GI
License Type to Material (STO)
 OIH_LICTP_GI OIH20
CHAR
 4 0
OIH_LICIN_GI
Excise Tax Internal License Number to Mat. (STO)
 OIH_LICIN_GI OIHL
CHAR
 10 0
OIH_LCFOL_GI
Follow-On License for Quantity License to Mat. (STO)
 OIH_LCFOL_GI OIHL
CHAR
 10 0
OIH_FOLQTY_GI
Excise Tax Follow-On License Quantity to Mat. (STO)
 OIH_FOLQTY_GI
QUAN
 13 3
OIHANTYP_GI
Excise Duty Handling Type - Denotes Use of Material
 OIH_HANTYP_GI
CHAR
 2 0
OITAXGRP_GI
Excise Duty Group
 OIH_TAXGRP
CHAR
 2 0
OITAXISS_CC
Excise duty value for goods issue
 OIH_TAXISS
CURR
 13 2
OITAXINV_CC
Excise duty tax value for an invoice
 OIH_TAXINV
CURR
 13 2
OIO_SPROC
Supply Process
 OIO_SPROC
CHAR
 4 0
CONS_ORDER
Purchase Order for Consignment
 WRF_CONS_ORDER
CHAR
 1 0

LIPS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LIPS ABELN LIPS MANDT AUKO
Allocation Table Document Header
 MANDT
LIPS ABELN LIPS ABELN AUKO
Allocation Table Document Header
 ABELN
LIPS ABELP LIPS ABELP AUPO
Allocation Table Document Item
 ABELP
LIPS ABELP LIPS MANDT AUPO
Allocation Table Document Item
 MANDT
LIPS ABELP LIPS ABELN AUPO
Allocation Table Document Item
 ABELN
LIPS ABFOR LIPS MANDT T691K
Forms of payment guarantee
 MANDT
LIPS ABFOR LIPS ABFOR T691K
Forms of payment guarantee
 ABSFO
LIPS ABRLI LIPS ABRLI VBLB
Sales document: Release order data
 ABRLI
LIPS ABRLI LIPS ABART VBLB
Sales document: Release order data
 ABART
LIPS ABRLI LIPS MANDT VBLB
Sales document: Release order data
 MANDT
LIPS ABRLI LIPS VGBEL VBLB
Sales document: Release order data
 VBELN
LIPS ABRLI LIPS VGPOS VBLB
Sales document: Release order data
 POSNR
LIPS ABRVW LIPS MANDT TVLV
Check table for release orders: Usage ID
 MANDT
LIPS ABRVW LIPS ABRVW TVLV
Check table for release orders: Usage ID
 ABRVW
LIPS ABTNR LIPS MANDT TSAB
Contact persons: standard departments
 MANDT
LIPS ABTNR LIPS ABTNR TSAB
Contact persons: standard departments
 ABTNR
LIPS AKTNR LIPS MANDT WAKH
Promotion Header Data, IS-R
 MANDT
LIPS AKTNR LIPS AKTNR WAKH
Promotion Header Data, IS-R
 AKTNR
LIPS AUFNR LIPS MANDT AUFK
Order master data
 MANDT
LIPS AUFNR LIPS AUFNR AUFK
Order master data
 AUFNR
LIPS BEDAR_LF LIPS MANDT T459K
Control table for customer requirements
 MANDT
LIPS BEDAR_LF LIPS BEDAR_LF T459K
Control table for customer requirements
 BEDAR
LIPS BERID LIPS MANDT MDLV
Customizing MRP Area
 MANDT
LIPS BERID LIPS BERID MDLV
Customizing MRP Area
 BERID
LIPS BWART LIPS MANDT T156
Movement Type
 MANDT
LIPS BWART LIPS BWART T156
Movement Type
 BWART
LIPS BWLVS LIPS BWLVS T333
WM Movement Types
 BWLVS
LIPS BWLVS LIPS MANDT T333
WM Movement Types
 MANDT
LIPS BWLVS LIPS LGNUM T333
WM Movement Types
 LGNUM
LIPS BWTAR LIPS MANDT T149D
Global Valuation Types
 MANDT
LIPS BWTAR LIPS BWTAR T149D
Global Valuation Types
 BWTAR
LIPS CHARG LIPS MANDT MCHA
Batches
 MANDT
LIPS CHARG LIPS MATNR MCHA
Batches
 MATNR
LIPS CHARG LIPS WERKS MCHA
Batches
 WERKS
LIPS CHARG LIPS CHARG MCHA
Batches
 CHARG
LIPS CLINT LIPS MANDT KLAH
Class Header Data
 MANDT
LIPS CLINT LIPS CLINT KLAH
Class Header Data
 CLINT
LIPS EMATN LIPS MANDT MARA
General Material Data
 MANDT
LIPS EMATN LIPS EMATN MARA
General Material Data
 MATNR
LIPS FAKSP LIPS MANDT TVFS
Billing: Reasons for Blocking
 MANDT
LIPS FAKSP LIPS FAKSP TVFS
Billing: Reasons for Blocking
 FAKSP
LIPS GEWEI LIPS GEWEI T006
Units of Measurement
 MSEHI
LIPS GEWEI LIPS MANDT T006
Units of Measurement
 MANDT
LIPS GSBER LIPS MANDT TGSB
Business Areas
 MANDT
LIPS GSBER LIPS GSBER TGSB
Business Areas
 GSBER
LIPS J_1BCFOP LIPS MANDT J_1BAG
CFOP
 MANDT
LIPS J_1BCFOP LIPS J_1BCFOP J_1BAG
CFOP
 CFOP
LIPS J_1BTAXLW1 LIPS MANDT J_1BATL1
Tax Law ICMS
 MANDT
LIPS J_1BTAXLW1 LIPS J_1BTAXLW1 J_1BATL1
Tax Law ICMS
 TAXLAW
LIPS J_1BTAXLW2 LIPS J_1BTAXLW2 J_1BATL2
Tax Law IPI
 TAXLAW
LIPS J_1BTAXLW2 LIPS MANDT J_1BATL2
Tax Law IPI
 MANDT
LIPS J_1BTAXLW3 LIPS MANDT J_1BATL3
Tax Laws ISS
 MANDT
LIPS J_1BTAXLW3 LIPS J_1BTAXLW3 J_1BATL3
Tax Laws ISS
 TAXLAW
LIPS J_1BTAXLW4 LIPS MANDT J_1BATL4A
Tax Laws COFINS
 MANDT
LIPS J_1BTAXLW4 LIPS J_1BTAXLW4 J_1BATL4A
Tax Laws COFINS
 TAXLAW
LIPS J_1BTAXLW5 LIPS J_1BTAXLW5 J_1BATL5
Tax Laws PIS
 TAXLAW
LIPS J_1BTAXLW5 LIPS MANDT J_1BATL5
Tax Laws PIS
 MANDT
LIPS J_1BTXSDC LIPS MANDT J_1BTXSDC
SD tax codes
 MANDT
LIPS J_1BTXSDC LIPS J_1BTXSDC J_1BTXSDC
SD tax codes
 TAXCODE
LIPS KCGEWEI LIPS MANDT T006
Units of Measurement
 MANDT
LIPS KCGEWEI LIPS KCGEWEI T006
Units of Measurement
 MSEHI
LIPS KCVOLEH LIPS MANDT T006
Units of Measurement
 MANDT
LIPS KCVOLEH LIPS KCVOLEH T006
Units of Measurement
 MSEHI
LIPS KMEIN LIPS MANDT T006
Units of Measurement
 MANDT
LIPS KMEIN LIPS KMEIN T006
Units of Measurement
 MSEHI
LIPS KNTTP LIPS MANDT T163K
Account Assignment Categories in Purchasing Document
 MANDT
LIPS KNTTP LIPS KNTTP T163K
Account Assignment Categories in Purchasing Document
 KNTTP
LIPS KOKRS LIPS MANDT TKA01
Controlling Areas
 MANDT
LIPS KOKRS LIPS KOKRS TKA01
Controlling Areas
 KOKRS
LIPS KOSTL LIPS MANDT CSKS
Cost Center Master Data
 MANDT
LIPS KOSTL LIPS KOKRS CSKS
Cost Center Master Data
 KOKRS
LIPS KOSTL LIPS KOSTL CSKS
Cost Center Master Data
 KOSTL
LIPS KOSTL LIPS AEDAT CSKS
Cost Center Master Data
 DATBI
LIPS KVGR1 LIPS MANDT TVV1
Customer Group 1
 MANDT
LIPS KVGR1 LIPS KVGR1 TVV1
Customer Group 1
 KVGR1
LIPS KVGR2 LIPS MANDT TVV2
Customer Group 2
 MANDT
LIPS KVGR2 LIPS KVGR2 TVV2
Customer Group 2
 KVGR2
LIPS KVGR3 LIPS MANDT TVV3
Customer Group 3
 MANDT
LIPS KVGR3 LIPS KVGR3 TVV3
Customer Group 3
 KVGR3
LIPS KVGR4 LIPS MANDT TVV4
Customer Group 4
 MANDT
LIPS KVGR4 LIPS KVGR4 TVV4
Customer Group 4
 KVGR4
LIPS KVGR5 LIPS MANDT TVV5
Customer Group 5
 MANDT
LIPS KVGR5 LIPS KVGR5 TVV5
Customer Group 5
 KVGR5
LIPS LADGR LIPS MANDT TLGR
Routes: Loading Groups
 MANDT
LIPS LADGR LIPS LADGR TLGR
Routes: Loading Groups
 LADGR
LIPS LGBZO LIPS MANDT T30C
WM Materials Staging Zones
 MANDT
LIPS LGBZO LIPS LGNUM T30C
WM Materials Staging Zones
 LGNUM
LIPS LGBZO LIPS LGBZO T30C
WM Materials Staging Zones
 LGBZO
LIPS LGNUM LIPS MANDT T300
WM Warehouse Numbers
 MANDT
LIPS LGNUM LIPS LGNUM T300
WM Warehouse Numbers
 LGNUM
LIPS LGORT LIPS LGORT T001L
Storage Locations
 LGORT
LIPS LGORT LIPS MANDT T001L
Storage Locations
 MANDT
LIPS LGORT LIPS WERKS T001L
Storage Locations
 WERKS
LIPS LGPLA LIPS MANDT LAGP
Storage bins
 MANDT
LIPS LGPLA LIPS LGNUM LAGP
Storage bins
 LGNUM
LIPS LGPLA LIPS LGTYP LAGP
Storage bins
 LGTYP
LIPS LGPLA LIPS LGPLA LAGP
Storage bins
 LGPLA
LIPS LGTYP LIPS LGTYP T301
WM Storage Types
 LGTYP
LIPS LGTYP LIPS MANDT T301
WM Storage Types
 MANDT
LIPS LGTYP LIPS LGNUM T301
WM Storage Types
 LGNUM
LIPS MAGRV LIPS MANDT TVEGR
Material Group: Packaging Materials
 MANDT
LIPS MAGRV LIPS MAGRV TVEGR
Material Group: Packaging Materials
 MAGRV
LIPS MANDT LIPS MANDT T000
Clients
 MANDT
LIPS MATKL LIPS MANDT T023
Material Groups
 MANDT
LIPS MATKL LIPS MATKL T023
Material Groups
 MATKL
LIPS MATNR LIPS MANDT MARA
General Material Data
 MANDT
LIPS MATNR LIPS MATNR MARA
General Material Data
 MATNR
LIPS MATWA LIPS MANDT MARA
General Material Data
 MANDT
LIPS MATWA LIPS MATWA MARA
General Material Data
 MATNR
LIPS MEINS LIPS MANDT T006
Units of Measurement
 MANDT
LIPS MEINS LIPS MEINS T006
Units of Measurement
 MSEHI
LIPS MFRGR LIPS MANDT TMFG
Material freight groups
 MANDT
LIPS MFRGR LIPS MFRGR TMFG
Material freight groups
 MFRGR
LIPS MTART LIPS MANDT T134
Material Types
 MANDT
LIPS MTART LIPS MTART T134
Material Types
 MTART
LIPS MTVFP LIPS MTVFP TMVF
Availability Check Control
 MTVFP
LIPS MTVFP LIPS MANDT TMVF
Availability Check Control
 MANDT
LIPS MVGR1 LIPS MANDT TVM1
Material Pricing Group 1
 MANDT
LIPS MVGR1 LIPS MVGR1 TVM1
Material Pricing Group 1
 MVGR1
LIPS MVGR2 LIPS MANDT TVM2
Material Pricing Group 2
 MANDT
LIPS MVGR2 LIPS MVGR2 TVM2
Material Pricing Group 2
 MVGR2
LIPS MVGR3 LIPS MANDT TVM3
Material Pricing Group 3
 MANDT
LIPS MVGR3 LIPS MVGR3 TVM3
Material Pricing Group 3
 MVGR3
LIPS MVGR4 LIPS MANDT TVM4
Material Pricing Group 4
 MANDT
LIPS MVGR4 LIPS MVGR4 TVM4
Material Pricing Group 4
 MVGR4
LIPS MVGR5 LIPS MANDT TVM5
Material Pricing Group 5
 MANDT
LIPS MVGR5 LIPS MVGR5 TVM5
Material Pricing Group 5
 MVGR5
LIPS OIC_DCITYC SYST MANDT T005G
City
 MANDT
LIPS OIC_DCITYC LIPS OIC_DLAND1 T005G
City
 LAND1
LIPS OIC_DCITYC LIPS OIC_DREGIO T005G
City
 REGIO
LIPS OIC_DCITYC LIPS OIC_DCITYC T005G
City
 CITYC
LIPS OIC_DCOUNC LIPS OIC_DREGIO T005E
County
 REGIO
LIPS OIC_DCOUNC LIPS OIC_DCOUNC T005E
County
 COUNC
LIPS OIC_DCOUNC SYST MANDT T005E
County
 MANDT
LIPS OIC_DCOUNC LIPS OIC_DLAND1 T005E
County
 LAND1
LIPS OIC_DLAND1 SYST MANDT T005
Countries
 MANDT
LIPS OIC_DLAND1 LIPS OIC_DLAND1 T005
Countries
 LAND1
LIPS OIC_DREGIO LIPS OIC_DREGIO T005S
Taxes: Region (Province) Key
 BLAND
LIPS OIC_DREGIO SYST MANDT T005S
Taxes: Region (Province) Key
 MANDT
LIPS OIC_DREGIO LIPS OIC_DLAND1 T005S
Taxes: Region (Province) Key
 LAND1
LIPS OIC_LIFNR LIPS OIC_LIFNR LFA1
Vendor Master (General Section)
 LIFNR
LIPS OIC_LIFNR SYST MANDT LFA1
Vendor Master (General Section)
 MANDT
LIPS OIC_MOT LIPS OIC_MOT TVTR
Routes: Modes of Transport
 VKTRA
LIPS OIC_MOT SYST MANDT TVTR
Routes: Modes of Transport
 MANDT
LIPS OIC_OCITYC SYST MANDT T005G
City
 MANDT
LIPS OIC_OCITYC LIPS OIC_OLAND1 T005G
City
 LAND1
LIPS OIC_OCITYC LIPS OIC_OREGIO T005G
City
 REGIO
LIPS OIC_OCITYC LIPS OIC_OCITYC T005G
City
 CITYC
LIPS OIC_OCOUNC LIPS OIC_OCOUNC T005E
County
 COUNC
LIPS OIC_OCOUNC SYST MANDT T005E
County
 MANDT
LIPS OIC_OCOUNC LIPS OIC_OLAND1 T005E
County
 LAND1
LIPS OIC_OCOUNC LIPS OIC_OREGIO T005E
County
 REGIO
LIPS OIC_OLAND1 SYST MANDT T005
Countries
 MANDT
LIPS OIC_OLAND1 LIPS OIC_OLAND1 T005
Countries
 LAND1
LIPS OIC_OREGIO SYST MANDT T005S
Taxes: Region (Province) Key
 MANDT
LIPS OIC_OREGIO LIPS OIC_OLAND1 T005S
Taxes: Region (Province) Key
 LAND1
LIPS OIC_OREGIO LIPS OIC_OREGIO T005S
Taxes: Region (Province) Key
 BLAND
LIPS OIEXGTYP SYST MANDT TOIA2
Exchange types
 MANDT
LIPS OIEXGTYP LIPS OIEXGTYP TOIA2
Exchange types
 EXGTYP
LIPS OIHANTYP T000 MANDT OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
 MANDT
LIPS OIHANTYP LIPS OIHANTYP OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
 HANTYP
LIPS OIH_LCFOL_GI LIPS OIH_LICTP_GI OIHL
License Master Data
 LICTP
LIPS OIH_LCFOL_GI SYST MANDT OIHL
License Master Data
 MANDT
LIPS OIH_LCFOL_GI LIPS OIH_LCFOL_GI OIHL
License Master Data
 LICIN
LIPS OIH_LICIN_GI SYST MANDT OIHL
License Master Data
 MANDT
LIPS OIH_LICIN_GI LIPS OIH_LICIN_GI OIHL
License Master Data
 LICIN
LIPS OIH_LICIN_GI * OIHL
License Master Data
 LICTP
LIPS OIH_LICTP_GI SYST MANDT OIH20
License types
 MANDT
LIPS OIH_LICTP_GI LIPS OIH_LICTP_GI OIH20
License types
 LICTP
LIPS OIINEX T000 MANDT OIH16
Internal/external price conditions
 MANDT
LIPS OIINEX LIPS OIINEX OIH16
Internal/external price conditions
 INEX
LIPS OINETCYC LIPS OINETCYC T008
Blocking Reasons for Automatic Payment Transcations
 ZAHLS
LIPS OINETCYC SYST MANDT T008
Blocking Reasons for Automatic Payment Transcations
 MANDT
LIPS OITAXFROM T000 MANDT OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
 MANDT
LIPS OITAXFROM LIPS OITAXFROM OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
 TAXKEY
LIPS OITAXGRP T000 MANDT OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
 MANDT
LIPS OITAXGRP LIPS OITAXGRP OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
 TAXGRP
LIPS OITAXTO LIPS OITAXTO OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
 TAXKEY
LIPS OITAXTO T000 MANDT OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
 MANDT
LIPS OIUMBAR SY MANDT T149D
Global Valuation Types
 MANDT
LIPS OIUMBAR LIPS OIUMBAR T149D
Global Valuation Types
 BWTAR
LIPS POSNR LIPS VBELN VBUP
Sales Document: Item Status
 VBELN
LIPS POSNR LIPS POSNR VBUP
Sales Document: Item Status
 POSNR
LIPS POSNR LIPS MANDT VBUP
Sales Document: Item Status
 MANDT
LIPS POSNV LIPS MANDT VBUP
Sales Document: Item Status
 MANDT
LIPS POSNV LIPS VBELV VBUP
Sales Document: Item Status
 VBELN
LIPS POSNV LIPS POSNV VBUP
Sales Document: Item Status
 POSNR
LIPS PRBME LIPS MANDT T006
Units of Measurement
 MANDT
LIPS PRBME LIPS PRBME T006
Units of Measurement
 MSEHI
LIPS PRODH LIPS PRODH T179
Materials: Product Hierarchies
 PRODH
LIPS PRODH LIPS MANDT T179
Materials: Product Hierarchies
 MANDT
LIPS PROFL LIPS MANDT TDG41
DG: DG Indicator Profiles for Material Master
 MANDT
LIPS PROFL LIPS PROFL TDG41
DG: DG Indicator Profiles for Material Master
 PROFL
LIPS PSTYV LIPS MANDT TVPT
Sales documents: Item categories
 MANDT
LIPS PSTYV LIPS PSTYV TVPT
Sales documents: Item categories
 PSTYV
LIPS QPLOS LIPS MANDT QALS
Inspection lot record
 MANDANT
LIPS QPLOS LIPS QPLOS QALS
Inspection lot record
 PRUEFLOS
LIPS RULES LIPS MANDT T434R
Stock determination rule
 MANDT
LIPS RULES LIPS RULES T434R
Stock determination rule
 RULES
LIPS SERAIL LIPS MANDT T377P
Serial Number Management Profiles
 MANDT
LIPS SERAIL LIPS SERAIL T377P
Serial Number Management Profiles
 SERAIL
LIPS SERNR LIPS MANDT SNUM
BOM explosion number
 MANDT
LIPS SERNR LIPS SERNR SNUM
BOM explosion number
 SERNR
LIPS SOBKZ LIPS MANDT T148
Special Stock Indicator
 MANDT
LIPS SOBKZ LIPS SOBKZ T148
Special Stock Indicator
 SOBKZ
LIPS SPART LIPS MANDT TSPA
Organizational Unit: Sales Divisions
 MANDT
LIPS SPART LIPS SPART TSPA
Organizational Unit: Sales Divisions
 SPART
LIPS TRAGR LIPS MANDT TTGR
Delivery Scheduling: Transportation Groups
 MANDT
LIPS TRAGR LIPS TRAGR TTGR
Delivery Scheduling: Transportation Groups
 TRAGR
LIPS UECHA LIPS MANDT LIPS
SD document: Delivery: Item data
 MANDT
LIPS UECHA LIPS VBELN LIPS
SD document: Delivery: Item data
 VBELN
LIPS UECHA LIPS UECHA LIPS
SD document: Delivery: Item data
 POSNR
LIPS UEPOS LIPS MANDT VBUP
Sales Document: Item Status
 MANDT
LIPS UEPOS LIPS VBELN VBUP
Sales Document: Item Status
 VBELN
LIPS UEPOS LIPS UEPOS VBUP
Sales Document: Item Status
 POSNR
LIPS VBELN LIPS MANDT VBUK
Sales Document: Header Status and Administrative Data
 MANDT
LIPS VBELN LIPS VBELN VBUK
Sales Document: Header Status and Administrative Data
 VBELN
LIPS VBELV LIPS VBELV VBUK
Sales Document: Header Status and Administrative Data
 VBELN
LIPS VBELV LIPS MANDT VBUK
Sales Document: Header Status and Administrative Data
 MANDT
LIPS VGBEL LIPS MANDT VBUK
Sales Document: Header Status and Administrative Data
 MANDT
LIPS VGBEL LIPS VGBEL VBUK
Sales Document: Header Status and Administrative Data
 VBELN
LIPS VGPOS LIPS VGPOS VBUP
Sales Document: Item Status
 POSNR
LIPS VGPOS LIPS MANDT VBUP
Sales Document: Item Status
 MANDT
LIPS VGPOS LIPS VGBEL VBUP
Sales Document: Item Status
 VBELN
LIPS VGSYS LIPS VGSYS TBDLS
Logical system
 LOGSYS
LIPS VKBUR LIPS MANDT TVBUR
Organizational Unit: Sales Offices
 MANDT
LIPS VKBUR LIPS VKBUR TVBUR
Organizational Unit: Sales Offices
 VKBUR
LIPS VKGRP LIPS VKGRP TVKGR
Organizational Unit: Sales Groups
 VKGRP
LIPS VKGRP LIPS MANDT TVKGR
Organizational Unit: Sales Groups
 MANDT
LIPS VOLEH LIPS MANDT T006
Units of Measurement
 MANDT
LIPS VOLEH LIPS VOLEH T006
Units of Measurement
 MSEHI
LIPS VPMAT LIPS VPMAT MARA
General Material Data
 MATNR
LIPS VPMAT LIPS MANDT MARA
General Material Data
 MANDT
LIPS VPWRK LIPS MANDT T001W
Plants/Branches
 MANDT
LIPS VPWRK LIPS VPWRK T001W
Plants/Branches
 WERKS
LIPS VRKME LIPS MANDT T006
Units of Measurement
 MANDT
LIPS VRKME LIPS VRKME T006
Units of Measurement
 MSEHI
LIPS VTWEG LIPS MANDT TVTW
Organizational Unit: Distribution Channels
 MANDT
LIPS VTWEG LIPS VTWEG TVTW
Organizational Unit: Distribution Channels
 VTWEG
LIPS WERKS LIPS MANDT T001W
Plants/Branches
 MANDT
LIPS WERKS LIPS WERKS T001W
Plants/Branches
 WERKS
LIPS WKTNR LIPS MANDT VBUK
Sales Document: Header Status and Administrative Data
 MANDT
LIPS WKTNR LIPS WKTNR VBUK
Sales Document: Header Status and Administrative Data
 VBELN
LIPS WKTPS LIPS MANDT VBUP
Sales Document: Item Status
 MANDT
LIPS WKTPS LIPS WKTNR VBUP
Sales Document: Item Status
 VBELN
LIPS WKTPS LIPS WKTPS VBUP
Sales Document: Item Status
 POSNR