SAP table LIPSUP (Generated Table for View)

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

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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Delivery CHAR 10 0 LIKP VBELN_VL
POSNR 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
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
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
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
Partial delivery allowed
A Create a delivery with quantity greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
CHSPL Batch split allowed CHAR 1 0 CHSPL
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
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
KOMKZ Indicator for picking control CHAR 1 0 KOMKZ
Picking is not carried out
1 Single-step procedure for multiple picking
2 Two-step procedure for multiple picking
A Picking is not carried out with WMS
B WMS fixed bin picking
C Picking carried out via WMS transfer orders
D LEAN WM in use
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LISPL Split to warehouse number required CHAR 1 0 LNSPL_LIPS
No
X Yes
BWTEX Indicator: Separate valuation CHAR 1 0 BWTEX
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
MTVFP Checking Group for Availability Check CHAR 2 0 TMVF MTVFP
GRKOR Delivery Group (Items are delivered together) NUMC 3 0 GRKOR
ANTLF Maximum Number of Partial Deliveries Allowed Per Item DEC 1 0 ANTLF
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
AEDAT Last Changed On DATS 8 0 AEDAT
VPZUO Allocation Indicator CHAR 1 0 VPZUO
VGTYP Document Category of Preceding SD Document CHAR 4 0 VBTYPL_V
BEDAR_LF Requirements class CHAR 3 0 T459K BEDAR
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
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
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
ABART Release type CHAR 1 0 ABART
Order
1 Forecast Delivery Schedule
2 JIT Delivery Schedule
3 Issue for External Agent (only in delivery)
4 Return for Scheduling Agreemnt with Release (only in dlvy)
5 Planning Delivery Schedule
6 Delivery Order (only in the delivery)
7 Return for Delivery Order (only in delivery)
PROSA ID for material determination CHAR 1 0 PROSA
No product selection
A Replaced item
B Replacement item
UEPVW ID for higher-level item usage CHAR 1 0 UEPVW
A Product selection
B Free goods (inclusive bonus)
C Free goods (on-top bonus)
D Repairs
E ** unused **
F Cross selling
G Complete goods (purchase order)
H Automotive (subitem)
I CRM Repairs
K Kit Component
R Replacement Kit Component
KOQUI Picking is subject to confirmation CHAR 1 0 KOQUI
PSPNR Project (internal) NUMC 8 0 PS_INTNR
WBSTA Goods Movement Status (Item) CHAR 1 0 WBSTA
GBSTA Overall Processing Status (Item) CHAR 1 0 GBSTA
KOSTA Picking Status/Putaway Status (Item) CHAR 1 0 KOSTA
LVSTA Status of Warehouse Management Activities (Item) CHAR 1 0 LVSTA
UVALL Incompletion Status (Item) CHAR 1 0 UVALL_UP
UVVLK Delivery Incompletion Status (Item) CHAR 1 0 UVVLK_UP
UVFAK Billing Incompletion Status (Item) CHAR 1 0 UVFAK_UP
FKIVP Intercompany Billing Status (Item) CHAR 1 0 FKIVP
PKSTA Packing Status (Item) CHAR 1 0 PKSTA
KOQUA Confirmation Status of Picking/Putaway CHAR 1 0 KOQUA
UVPIK Picking/Putaway Incompletion Status (Item) CHAR 1 0 UVPIP_UP
UVPAK Packing Incompletion Status (Item) CHAR 1 0 UVPAP_UP
UVWAK Goods Movement Incompletion Status (Item) CHAR 1 0 UVWAP_UP
/SAPMP/LBASP DTUC Status CHAR 1 0 /SAPMP/LBASTAT

LIPSUP foreign key relationships

Table Field Check Table Check Field
0 LIPSUP BEDAR_LF T459K Control table for customer requirements MANDT
1 LIPSUP BWART T156 Movement Type MANDT
1 LIPSUP BWART T156 Movement Type BWART
0 LIPSUP BWTAR T149D Global Valuation Types MANDT
0 LIPSUP BWTAR T149D Global Valuation Types BWTAR
1 LIPSUP CHARG MCHA Batches MANDT
1 LIPSUP CHARG MCHA Batches WERKS
1 LIPSUP CHARG MCHA Batches CHARG
0 LIPSUP GEWEI T006 Units of Measurement MANDT
0 LIPSUP GEWEI T006 Units of Measurement MSEHI
1 LIPSUP KCGEWEI T006 Units of Measurement MANDT
1 LIPSUP KCGEWEI T006 Units of Measurement MSEHI
0 LIPSUP KCVOLEH T006 Units of Measurement MANDT
0 LIPSUP KCVOLEH T006 Units of Measurement MSEHI
1 LIPSUP LGNUM T300 WM Warehouse Numbers MANDT
1 LIPSUP LGNUM T300 WM Warehouse Numbers LGNUM
0 LIPSUP LGORT T001L Storage Locations MANDT
0 LIPSUP LGORT T001L Storage Locations WERKS
1 LIPSUP MANDT T000 Clients MANDT
0 LIPSUP MATNR MARA General Material Data MANDT
0 LIPSUP MATNR MARA General Material Data MATNR
1 LIPSUP MEINS T006 Units of Measurement MANDT
1 LIPSUP MEINS T006 Units of Measurement MSEHI
0 LIPSUP MTVFP TMVF Availability Check Control MTVFP
1 LIPSUP PSTYV TVPT Sales Documents: Item categories MANDT
1 LIPSUP PSTYV TVPT Sales Documents: Item categories PSTYV
0 LIPSUP SERAIL T377P Serial Number Management Profiles MANDT
1 LIPSUP SERNR SNUM BOM explosion number MANDT
0 LIPSUP SOBKZ T148 Special Stock Indicator MANDT
0 LIPSUP SOBKZ T148 Special Stock Indicator SOBKZ
1 LIPSUP UECHA LIPS SD document: Delivery: Item data MANDT
1 LIPSUP UECHA LIPS SD document: Delivery: Item data VBELN
1 LIPSUP UECHA LIPS SD document: Delivery: Item data POSNR
0 LIPSUP VBELN LIKP SD Document: Delivery Header Data MANDT
0 LIPSUP VBELN LIKP SD Document: Delivery Header Data VBELN
1 LIPSUP VOLEH T006 Units of Measurement MANDT
1 LIPSUP VOLEH T006 Units of Measurement MSEHI
0 LIPSUP VRKME T006 Units of Measurement MANDT
0 LIPSUP VRKME T006 Units of Measurement MSEHI
1 LIPSUP WERKS T001W Plants/Branches MANDT
1 LIPSUP WERKS T001W Plants/Branches WERKS