SAP Table LIPSD

Dynamic Part of the Delivery Item

LIPSD (Dynamic Part of the Delivery Item) 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 LIPSD to other SAP tables.

LIPSD table fields

Field Data element Checktable Datatype Length Decimals
UPDKZ Update indicator UPDKZ_D CHAR 1 0
CHMULT Indicator: more than one batch CHMUL CHAR 4 0
OFMNG Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP OMENG QUAN 15 3
PIKMG Pick/stock quantity in sales units PIKMG QUAN 13 3
VRKMP Sales unit VRKME T006 UNIT 3 0
LBEFU_IND Row Index of Internal Tables SYTABIX INT4 10 0
LIPS_UP Update indicator UPDKZ_D CHAR 1 0
VERAB Availability date VERAB DATS 8 0
G_LFIMG Actual quantity delivered (in sales units) LFIMG QUAN 13 3
KCMENG_VME Cumulative batch quantity of all split items in sales units KCMENG_VME QUAN 15 3
VGVGBEL Document number of the reference document VGBEL CHAR 10 0
VGVGPOS Item number of the reference item VGPOS NUMC 6 0
VGVGTYP Document category of preceding SD document VBTYP_V 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
UMREZ Numerator for Conversion of Order Unit to Base Unit UMBSZ DEC 5 0
UMREN Denominator for Conversion of Order Unit to Base Unit UMBSN DEC 5 0
VUPOS Originating item VUPOS NUMC 6 0
LSTANR Free goods delivery control LSTANR CHAR 1 0
NULL Delivery takes place regardless of main item
A Delivery only if main item is partially delivered
B Delivery only if main item is fully delivered
C Delivery if main item is part. delivered, only with main itm
E Delivery proportional to quantity in main item
NATGR Delivery group (items are delivered together) GRKOR NUMC 3 0
VGUEPOS Higher-level item in bill of material structures UEPOS NUMC 6 0
RFBEL Reference document RFBEL_VL CHAR 10 0
RFPOS Reference Item RFPOS_VL NUMC 6 0
POSGUID ATP: Encryption of DELNR and DELPS POSGUID CHAR 22 0
QUAN_NO_CHECK Deactivate Availability Check and/or Allocating Requirement QUAN_NO_CHECK CHAR 1 0
NULL Availability check and ATP according to Customizing
W No availability check; no requirements
X Requirements but no availability check
2 Availability check but no requirements
ID Unique Number for a Delivery-Processing Request LESHP_INTERFACE_ID INT4 10 0
CREATE_UCLIEF Indicator: Creation of an Unchecked Delivery Item Active V50AGL_CREATE_UCLIEF CHAR 1 0
X Yes
NULL No
UCDEL_TO_DEL Indicator: Conversion of Unchecked Delivery Active V50AGL_UCDEL_TO_DEL CHAR 1 0
X Yes
NULL No
ETENS Sequential Number of Vendor Confirmation ETENS NUMC 4 0
EBUMG Quantity to Book In in SUn (Sales Unit) EBUMNG QUAN 13 3
EBUMG_BME Quantity to Book In in BUn (Base Unit of Measure) EBUMNG_BME QUAN 13 3
EBUMG_FLO Quantity to Book In in Sales Unit EBUMNG_FLO FLTP 16 16
EBUMG_FLT Quantity to Book In in Base Unit of Measure EBUMNG_FLT FLTP 16 16
VBUMG GR-Posted Quantity in SUn VBUMNG QUAN 13 3
VBUMG_BME Quantity (GR Posted) in Base Unit of Measure VBUMG_BME QUAN 13 3
BTYPB Procurement document category BTYPB CHAR 1 0
1 Purchase Order
2 Sales Order
3 Delivery
4 Putaway in distribution center
9 Entry for incomplete distribution
BLNRB Document number, procurement BLNRB CHAR 10 0
BPOSB Document item, procurement BPOSB NUMC 6 0
DOCUBATCH_CHARG Documentary Batch - Batch Number DOCUBATCH_CHARG CHAR 10 0
DOCUBATCH_CONTROL Define Documentary Batches per Material Type DOCUBATCH_CONTROL CHAR 1 0
NULL No Documentary Batches
1 Only Usage Data, no Batch Master
2 Usage Data and Batch Master
DOCUBATCH_MULT_ENTRIES Checkbox XFELD CHAR 1 0
X Yes
NULL No
IS_QUITL Indicator for Confirming Service Item IS_QUITL CHAR 1 0
X Yes
NULL No
MDIFF_BWART Difference Movement Type (Quantity Differences) MDIFF_BWART CHAR 3 0
MDIFF_GRUND Reason for Movement MB_GRBEW NUMC 4 0
MDIFF_LGORT Storage Location LGORT_D CHAR 4 0
MDIFF_COMPL Completed indicator COMPL_MARK CHAR 1 0
X Yes
NULL No
MDIFF_FZGLS Do Not Adjust Cumulative Received Quantity FZGLS CHAR 1 0
X Yes
NULL No
MDIFF_ETANP Adjust Open Quantity in Scheduling Agreement Item ETANP CHAR 1 0
X Yes
NULL No
MDIFF_POPUP Display Dialog Box POPUP CHAR 1 0
X Selection character
NULL Blank
SPE_DLV_QTY_FROM Actual quantity delivered in stockkeeping units LGMNG QUAN 13 3
SPE_PROCESS_DATE UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0
SPE_MDIFF_INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
SPE_DEL_INSMK General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
SPE_KZEBU Item Marked for Partial Goods Receipt KZEBU_P CHAR 1 0
X Yes
NULL No
SPE_PICK_DENIAL Pick Denial Flag /SPE/DE_PICK_DENIAL CHAR 1 0
NULL Blank
. Radio button
X Selection
SN_FROM_TAB Ignore Serial Numbers of Preceding Document SN_FROM_TAB CHAR 1 0
X Yes
NULL No
SPE_XNOCON Quantity conversion not necessary XNOCON CHAR 1 0
X Yes
NULL No
SPE_ITEM_PROCESS Item Process Identification /SPE/DE_ITEM_PROCESS CHAR 3 0
A1 Not Relevant for Scrapping
A2 Scrap Entire Inventory
A3 Scrap Inventory with Retention Quantity Constraint
A4 Scrap Predetermined Quantity
B1 Returns: Putaway
B2 Returns: Scrap
B3 Inspection with Follow-up Decision by Customer Service
B4 Inspection with Own Follow-up Decision
B5 Inspection at Non-final Location
C1 Normal GI for Outbound Delivery, GR for Inbound Delivery
C2 Posting Change/Stock Transfer 2-Step, GR from StockinTransit
C3 Posting Change/Stock Transfer 2-Step, GI into StockinTransit
C4 Posting Change/Stock Transfer 1-Step
C5 Posting Change/Stock Transfer 2-Step CC GR
C6 Posting Change/Stock Transfer 2-Step CC GI
C7 Posting Change/Stock Transfer 1-Step CC
D1 IBGI not allowed
D2 IBGI not Allowed Except for Export Processes
D3 IBGI Route Dependent
D4 IBGI Mandatory
D5 IBGI Allowed But not Mandatory
V1 2-step STO, GI with returns follow-up putaway
V2 2-step STO, CC GI with returns follow-up putaway
V3 2-step STO, GI with returns follow-up scrap
V4 2-step STO, CC GI with returns follow-up scrap
V5 2-step STO, GI with returns follow-up by customer service
V6 2-step STO, CC GI with return follow-up by customer service
V7 2-step STO, GI with returns inspection with own follow-up
V8 2-step STO, CC GI with returns inspection with own follow-up
V9 2-step STO, GI with returns inspection at non-final location
V10 2-step STO, CC GI w/ ret. insp at non-final location
V11 2-step STO, GR with returns follow-up putaway
V12 2-step STO, CC GR with returns follow-up putaway
V13 2-step STO, GR with returns follow-up scrap
V14 2-step STO, CC GR with returns follow-up scrap
V15 2-step STO, GR with returns follow-up by customer service
V16 2-step STO, CC GR with returns follow-up by customer service
V17 2-step STO, GR with returns inspection with own follow-up
V18 2-step STO, CC GR with returns inspection with own follow-up
V19 2-step STO, GR w/ returns inspection at non-final location
V20 2-step STO, CC GR w/ returns insp. at non-final location
NULL
K1 GI from Kanban for Cost Center
K2 Kanban Transfer 2-Step, GR from StockinTransit
K3 Kanban Transfer 2-Step, GI into StockinTransit
K4 Kanban Transfer 1-Step
MSR_VALUATION Checkbox XFELD CHAR 1 0
X Yes
NULL No
/CWM/G_LFIMG Actual Delivered Quantity in Parallel Unit of Measure /CWM/LFIMG QUAN 13 3
PROCESSED Single-Character Indicator CHAR1 CHAR 1 0

LIPSD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LIPSD VRKMP SYST MANDT T006 Units of Measurement MANDT
LIPSD VRKMP LIPSD VRKMP T006 Units of Measurement MSEHI