1. Home
  2. Resources
  3. SAP Tables
  4. LIPSUP - Generated Table for View

SAP Table LIPSUP

Generated Table for View

LIPSUP (Generated Table for View) 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 LIPSUP to other SAP tables.

LIPSUP table fields

Field Data element Checktable Datatype Length Decimals
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
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
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
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
NULL Partial delivery allowed
A Create a delivery with qty 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 Limit UEBTO DEC 3 1
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
CHSPL Batch split allowed CHSPL CHAR 1 0
X Yes
NULL No
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
VBELV Originating document VBELV VBUK CHAR 10 0
POSNV Originating item POSNV VBUP NUMC 6 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
KOMKZ Indicator for picking control KOMKZ CHAR 1 0
NULL Picking is not carried out
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
1 Single-step procedure for multiple picking
2 Two-step procedure for multiple picking
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 CHAR 3 0
LISPL Split to warehouse number required LNSPL_LIPS CHAR 1 0
X Yes
NULL No
BWTEX Indicator: Separate valuation BWTEX CHAR 1 0
X Yes
NULL No
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
MTVFP Checking Group for Availability Check MTVFP TMVF CHAR 2 0
GRKOR Delivery group (items are delivered together) GRKOR NUMC 3 0
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
AEDAT Changed On AEDAT DATS 8 0
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
VGTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
BEDAR_LF Requirements class BEDAR T459K CHAR 3 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
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
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
ABART Release type ABART CHAR 1 0
NULL Order
1 Forecast dlv. sched.
2 JIT delivery schedule
3 Issue for external agent (only in delivery)
4 Returns for scheduling agreemnt w/ release (only in dlvy)
5 Planning delivery schedule
6 Delivery order (only in the delivery)
7 Returns for delivery order (only in delivery)
PROSA ID for material determination PROSA CHAR 1 0
NULL No product selection
A Replaced item
B Replacement item
UEPVW ID for higher-level item usage UEPVW CHAR 1 0
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 KOQUI CHAR 1 0
X Yes
NULL No
PSPNR Project definition (internal) PS_INTNR NUMC 8 0
WBSTA Goods movement status WBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
GBSTA Overall processing status of the SD document item GBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOSTA Picking status/Putaway status KOSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LVSTA Status of warehouse management activities LVSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALL General Incompletion Status of Item UVALL_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLK Incompletion status of the item with regard to delivery UVVLK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK Item Incompletion Status with Respect to Billing UVFAK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKIVP Intercompany Billing Status FKIVP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PKSTA Packing status of item PKSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOQUA Confirmation status of picking/putaway KOQUA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPIK Incomplete status of item for picking/putaway UVPIP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPAK Incomplete status of item for packaging UVPAP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVWAK Incomplete status of item regarding goods issue UVWAP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed

LIPSUP foreign key relationships

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