SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

LIPS Table in SAP | SD document: Delivery: Item data Table & Fields List

LIPS is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of LIPS in SAP.

  • Table description : SD document: Delivery: Item data
  • Module : CRM
  • Parent Module : CRM
  • Package : VL
  • Software Component : BBPCRM
LIPS table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP LIPS Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
VBELNDeliveryVBELN_VLVBELN
POSNRDelivery ItemPOSNR_VLPOSNR
PSTYVDelivery item categoryPSTYV_VLPSTYV
ERNAMName of Person who Created the ObjectERNAMUSNAM
ERZETEntry timeERZETUZEIT
ERDATDate on which the record was createdERDATDATUM
MATNRMaterial NumberMATNRMATNR
MATWAMaterial enteredMATWAMATNR
MATKLMaterial GroupMATKLMATKL
WERKSPlantWERKS_DWERKS
LGORTStorage locationLGORT_DLGORT
CHARGBatch NumberCHARG_DCHARG
LICHNVendor Batch NumberLICHNLICHN
KDMATMaterial belonging to the customerKDMATIDNEX
PRODHProduct HierarchyPRODH_DPRODH
LFIMGActual quantity delivered (in sales units)LFIMGMENG13
MEINSBase Unit of MeasureMEINSMEINS
VRKMESales unitVRKMEMEINS
UMVKZNumerator (factor) for conversion of sales quantity into SKUUMVKZUMBSZ
UMVKNDenominator (divisor) for conversion of sales qty. into SKUUMVKNUMBSN
NTGEWNet weightNTGEW_15MENG15
BRGEWGross weightBRGEW_15MENG15
GEWEIWeight UnitGEWEIMEINS
VOLUMVolumeVOLUM_15MENG15
VOLEHVolume unitVOLEHMEINS
KZTLFPartial delivery at item levelKZTLFKZTLF
UEBTKIndicator: Unlimited Overdelivery AllowedUEBTKXFELD
UEBTOOverdelivery Tolerance LimitUEBTOPRZ21
UNTTOUnderdelivery Tolerance LimitUNTTOPRZ21
CHSPLBatch split allowedCHSPLXFELD
FAKSPLockFAKSPFAKSP
MBDATMaterial Staging/Availability DateMBDATDATUM
LGMNGActual quantity delivered in stockkeeping unitsLGMNGMENG13
ARKTXShort text for sales order itemARKTXTEXT40
LGPBEStorage BinLGPBECHAR10
VBELVOriginating documentVBELVVBELN
POSNVOriginating itemPOSNVPOSNR
VBTYVSD document categoryVBTYPVBTYP
VGSYSLogical System in the Preceding DocumentVGLOGSYSLOGSYS
VGBELDocument number of the reference documentVGBELVBELN
VGPOSItem number of the reference itemVGPOSPOSNR
UPFLUUpdate indicator for delivery document flowUPFLLUPFLL
UEPOSHigher-level item in bill of material structuresUEPOSPOSNR
FKRELRelevant for BillingFKRELFKREL
LADGRLoading GroupLADGRLADGR
TRAGRTransportation GroupTRAGRTRAGR
KOMKZIndicator for picking controlKOMKZKOMKZ
LGNUMWarehouse Number / Warehouse ComplexLGNUMLGNUM
LISPLSplit to warehouse number requiredLNSPL_LIPSLNSPL_LIPS
LGTYPStorage TypeLGTYPLGTYP
LGPLAStorage BinLGPLALGPLA
BWTEXIndicator: Separate valuationBWTEXXFELD
BWARTMovement type (inventory management)BWARTBWART
BWLVSMovement Type for Warehouse ManagementBWLVSBWLVS
KZDLGIndicator: dynamic storage bin in warehouse managementLVS_KZDLGXFELD
BDARTRequirement typeBDARTBDART
PLARTPlanning typePLARTPLART
MTARTMaterial typeMTARTMTART
XCHPFBatch management requirement indicatorXCHPFXFELD
XCHARBatch management indicator (internal)XCHARXFELD
VGREFPreceding document has resulted from referenceVGREFXFELD
POSARItem typePOSARPOSAR
BWTARValuation typeBWTAR_DBWTAR
SUMBDSumming up of requirementsSUMBDSUMBD
MTVFPChecking Group for Availability CheckMTVFPMTVFP
EANNREuropean Article Number (EAN) - obsolete!!!!!EANNRCHAR13
GSBERBusiness AreaGSBERGSBER
VKBURSales officeVKBURVKBUR
VKGRPSales groupVKGRPVKGRP
VTWEGDistribution ChannelVTWEGVTWEG
SPARTDivisionSPARTSPART
GRKORDelivery group (items are delivered together)GRKORGRKOR
FMENGQuantity is fixedFMENGXFELD
ANTLFMaximum number of partial deliveries allowed per itemANTLFANTLF
VBEAFFixed shipping processing time in days (= setup time)VBEAFDEC3_2
VBEAVVariable shipping processing time in daysVBEAVDEC3_2
STAFOUpdate group for statistics updateSTAFOSTAFO
WAVWRCost in document currencyWAVWRWERTV7
KZWI1Subtotal 1 from pricing procedure for conditionKZWI1WERTV7
KZWI2Subtotal 2 from pricing procedure for conditionKZWI2WERTV7
KZWI3Subtotal 3 from pricing procedure for conditionKZWI3WERTV7
KZWI4Subtotal 4 from pricing procedure for conditionKZWI4WERTV7
KZWI5Subtotal 5 from pricing procedure for conditionKZWI5WERTV7
KZWI6Subtotal 6 from pricing procedure for conditionKZWI6WERTV7
SOBKZSpecial Stock IndicatorSOBKZSOBKZ
AEDATLast Changed OnAEDATDATUM
EAN11International Article Number (EAN/UPC)EAN11EAN11
KVGR1Customer group 1KVGR1KVGR1
KVGR2Customer group 2KVGR2KVGR2
KVGR3Customer group 3KVGR3KVGR3
KVGR4Customer group 4KVGR4KVGR4
KVGR5Customer group 5KVGR5KVGR5
MVGR1Material group 1MVGR1MVGR1
MVGR2Material group 2MVGR2MVGR2
MVGR3Material group 3MVGR3MVGR3
MVGR4Material group 4MVGR4MVGR4
MVGR5Material group 5MVGR5MVGR5
VPZUOAllocation IndicatorVPZUOZUVKZ
VGTYPSD document categoryVBTYPVBTYP
RFVGTYPType of preceding document in central systemRFVGTYPVBTYP
KOSTLCost CenterKOSTLKOSTL
KOKRSControlling AreaKOKRSCACCD
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRRKEOBJNR
PRCTRProfit CenterPRCTRPRCTR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPS_POSNR
AUFNROrder NumberAUFNRAUFNR
POSNR_PPOrder item numberCO_POSNRCO_POSNR
KDAUFSales Order NumberKDAUFVBELN
KDPOSItem number in Sales OrderKDPOSNUM06
VPMATPlanning materialVPMATMATNR
VPWRKPlanning plantVPWRKWERKS
PRBMEBase unit of measure for product groupPRBMEMEINS
UMREFConversion factor: quantitiesUMREFFFLTP
KNTTPAccount assignment categoryKNTTPKNTTP
KZVBRConsumption postingKZVBRKZVBR
FIPOSCommitment ItemFIPOSFIPOS
FISTLFunds CenterFISTLFISTL
GEBERFundBP_GEBERBP_GEBER
PCKPFPacking controlPCKPFPCKPF
BEDAR_LFRequirements classBEDARBEDAR
CMPNTID: Item with active credit function / relevant for creditCMPNTXFELD
KCMENGCumulative batch quantity of all split items (in StckUnit)KCMENGMENG15
KCBRGEWCumulative gross weight of all batch split itemsKCBRGEWMENG15
KCNTGEWCumulative net weight of all batch split itemsKCNTGEWMENG15
KCVOLUMCumulative volume of all batch split itemsKCVOLUMMENG15
UECHAHigher-Level Item of Batch Split ItemUECHAPOSNR
CUOBJConfigurationCUOBJ_VACUOBJ
CUOBJ_CHInternal object number of the batch classificationCUOBJ_CHCUOBJ
ANZSNNumber of serial numbersANZSNINT4
SERAILSerial Number ProfileSERAILSERAIL
KCGEWEIWeight UnitGEWEIMEINS
KCVOLEHVolume unitVOLEHMEINS
SERNRBOM explosion numberSERNRSERNR
ABRLIInternal delivery schedule numberABRLIABRLI
ABARTRelease typeABARTABART
ABRVWUsage IndicatorABRVWABRVW
QPLOSInspection Lot NumberQPLOSQPLOS
QTLOSPartial lot numberQTLOSQTLOS
NACHLCustomer has not posted goods receiptNACHLXFELD
MAGRVMaterial Group: Packaging MaterialsMAGRVMAGRV
OBJKOObject number at header levelOBJKOJ_OBJNR
OBJPOObject number at item levelOBJPOJ_OBJNR
AESKDCustomer Engineering Change StatusAESKDAESKD
SHKZGReturns ItemSHKZG_VAXFELD
PROSAID for material selection - activePROSAPROSA
UEPVWID for higher-level item usageUEPVWUEPVW
EMPSTReceiving pointEMPSTTEXT25
ABTNRDepartment numberABTNRABTNR
KOQUIPicking is subject to confirmationKOQUIXFELD
STADATStatistics dateSTADATDATUM
AKTNRPromotionWAKTIONWAKTION
KNUMH_CHNumber of condition record from batch determinationKNUMH_CHKNUMB
PREFEPreference indicator in export/importPREFEPREFE
EXARTBusiness Transaction Type for Foreign TradeEXARTEXART
CLINTInternal Class NumberCLINTCLINT
CHMVSBatches: Exit to quantity proposalCHMVSNUM3
ABELNAllocation Table NumberABELNABELN
ABELPItem number of allocation tableABELPABELP
LFIMG_FLOInternal field/ Do not use / LFIMG in float / MUMLFIMG_FLOFLTP
LGMNG_FLOInternal field/ Do not use / LGMNG in float / MUMLGMNG_FLOFLTP
KCMENG_FLOInternal field/ Do not use / KCMENG in float / MUMKCMENG_FLOFLTP
KZUMWIndicator: Environmentally relevantKZUMWXFELD
KMPMGComponent QuantityKMPMGMENGV13
AURELRelevant to Allocation TableAURELAUREL
KPEINCondition pricing unitKPEINKPEIN
KMEINCondition UnitKMEINMEINS
NETPRNet priceNETPRWERTV6
NETWRNet Value in Document CurrencyNETWRWERTV8
KOWRRStatistical valuesKOWRRKOWRR
KZBEWMovement IndicatorKZBEWKZBEW
MFRGRMaterial freight groupMFRGRMFRGR
CHHPVPack accumulated batches / movement type itemCHHPVXFELD
ABFORForm of payment guaranteeABSFORM_CMABSFORM_CM
ABGESGuaranteed (factor between 0 and 1)ABGES_CMFLTP
MBUHRMaterial Staging Time (Local, Relating to a Plant)MBUHRTIME_PLANT
WKTNRValue contract no.WKTNRVBELN
WKTPSValue contract itemWKTPSPOSNR
J_1BCFOPCFOP code and extensionJ_1BCFOPJ_1BCFOP
J_1BTAXLW1Tax law: ICMSJ_1BTAXLW1J_1BTAXLW1
J_1BTAXLW2Tax law: IPIJ_1BTAXLW2J_1BTAXLW2
J_1BTXSDCSD tax codeJ_1BTXSDC_J_1BTXSDC
SITUAIndicator for situationSITUASITUA
RSNUMNumber of reservation/dependent requirementsRSNUMRSNUM
RSPOSItem Number of Reservation / Dependent RequirementsRSPOSRSPOS
RSARTRecord typeRSARTRSART
KANNRKANBAN/sequence numberKANNRCHAR35
KZFMEID: Leading unit of measure for completing a transactionKZFMEKZFME
PROFLDangerous goods indicator profileADGE_PROFLADGD_PROFL
KCMENGVMECumulative batch quantity of all split items in sales unitsKCMENG_VMEMENGV15_3
KCMENGVMEFCumulated batch split quantity in VRKME and floatKCMENGVMEFFLTP
KZBWSValuation of Special StockKZBWSKZBWS
PSPNRCurrent number for project or project itemPS_INTNRPS_PSPNR
EPRIOWithdrawal sequence group for stocksEPRIOEPRIO
RULESStock determination ruleBF_RULESBF_RULES
KZBEFIndicator Inventory Management activeLVS_KZBEFXFELD
MPROFMfr part profileMPROFMPROF
EMATNMaterial number corresponding to manufacturer part numberEMATNMATNR
LGBZOStaging Area for Warehouse ComplexLGBZOLGBZO
HANDLEWorldwide unique key for LIPS-VBELN & LIPS_POSNRTSEGGUID_LIPSSYSUUID_22
VERURPOSDistribution delivery: Original itemVERURPOSPOSNR
LIFEXPOSExternal item numberLIFEXPOSPOSNR
NOATPIndicator: deactivate availability checkNO_ATP_CHECKNO_ATP_CHECK
NOPCKIndicator: not relevant for pickingNO_PICKINGXFELD
RBLVSReference movement type for WM from material movementsRBLVSLVS_BWREF
BERIDMRP AreaBERIDBERID
BESTQStock Category in the Warehouse Management SystemBESTQBESTQ
UMBSQStock Category in the Warehouse Management SystemBESTQBESTQ
UMMATReceiving/issuing materialUMMATMATNR
UMWRKReceiving plant/issuing plantUMWRKWERKS
UMLGOReceiving/issuing storage locationUMLGOLGORT
UMCHAReceiving/issuing batchUMCHACHARG
UMBARValuation type of transfer batchUMBARBWTAR
UMSOKSpecial stock indicator for physical stock transferUMSOKSOBKZ
SONUMSpecial Stock NumberLVS_SONUMLVS_SONUM
USONUSpecial Stock NumberLVS_SONUMLVS_SONUM
AKKURExchange rate for letter-of-credit procg in foreign tradeAKKURKURRF
AKMNGCurrent Qty Field for Arithmetic Operations in Doc.Process.AKMNGAKMNG
VKGRURepair processing: Classify itemsVKGRURMA_VORGA
SHKZG_UMIndicator: UNMAT in main postingSHKZG_UMSHKZG_UM
INSMKStock TypeMB_INSMKMB_INSMK
KZECHDetermination of batch entry in the production/process orderKZECHKZECH
FLGWMIndicator: Copy dest. storage data from preceding documentFLGWMFLGWM
BERKZMaterial Staging Indicator for Production SupplyBERKZLVS_BERKZ
HUPOSIndicator: Delivery item is a HU itemHUPOSHUPOS
NOWABIndicator: Item Not Relevant for Goods MovementsNOWABNOWAB
KONTOG/L Account NumberSAKNRSAKNR
KZEARFinal issue for this reservationKZEARXFELD
HSDATDate of ManufactureHSDATDATUM
VFDATShelf Life Expiration or Best-Before DateVFDATDATUM
LFGJAFiscal Year of Current PeriodLFGJAGJAHR
LFBNRDocument number of a reference documentLFBNRBELNR
LFPOSItem of a reference documentLFPOSMBLPO
GRUNDReason for goods movmentMB_GRUNDNUMC4
FOBWASubsequent movement typeFOBWABWART
DLVTPDelivery CategoryDLVTPDLVTP
EXBWRExternally Entered Posting Amount in Local CurrencyEXBWRWERT7
BPMNGQuantity in order price quantity unitBPMNGMENG13
EXVKWExternally Entered Sales Value in Local CurrencyEXVKWWERT7
CMPRE_FLTItem credit priceCMPRE_FLTFLTP
KZPODPOD indicator (relevance, verification, confirmation)KZPODKZPOD
LFDEZNot relevant for distribution for WMSLFDEZLFDEZ
UMREVConversion Factor of Delivery Quantity VRKME for MEINSLE_UMREVFLTP
PODRELPOD Control (Proof of Delivery)PODRELPODREL
KZUMLStock Transfer/Transfer PostingKZUMLXFELD
FKBERFunctional AreaFKBERFKBER
GRANT_NBRGrantGM_GRANT_NBRGM_GRANT_NBR
KZWSOUnits of measure usageKZWSOKZWSO
GMCONTROLGoods Movement ControlGMCONTROLGMCONTROL
POSTING_CHANGEGoods Movement Control: HUPOSTING_CHANGEPOSTING_CHANGE
UM_PS_PSP_PNRReceiving/Issuing (WBS Element)UM_PS_PSP_PNRPS_POSNR
PRE_VL_ETENSSequential Number of Vendor ConfirmationETENSNUM04
SPE_GEN_ELIKZ"Delivery Completed" IndicatorELIKZXFELD
SPE_SCRAP_INDScrap Indicator for EWM Processing/SPE/DELIVERY_SCRAP_IND/SPE/DELIVERY_SCRAP_IND
SPE_AUTH_NUMBERReturn Material Authorization Number/SPE/RET_RMA/SPE/RET_RMA
SPE_INSPOUT_GUIDInspections: Inspection outcome GUID set by EWM/SPE/INSP_OUT_GUID_16/SPE/RET_GUID16
SPE_FOLLOW_UPDefault Follow-Up Activity Code/SPE/RET_FOLLOW_UP/SPE/RET_FOLLOW_UP
SPE_EXP_DATE_EXTEnd date of validity period of returns delivery/SPE/RET_EXPIRY_DATE_EXTTZNTSTMPS
SPE_EXP_DATE_INTEnd date of internal validity period of returns delivery/SPE/RET_EXPIRY_DATE_INTTZNTSTMPS
SPE_AUTH_COMPLETRMA completion indicator/SPE/RET_RMA_COMPLETED/SPE/RET_RMA_COMPLETED
ORMNGOriginal Quantity of Delivery ItemORMNG_VLMENG13
SPE_ATP_TMSTMPATP Time Stamp/SPE/DE_ATP_TIMESTAMPTZNTSTMPS
SPE_ORIG_SYSOriginal System Type/SPE/INB_ORIGIN_SYS/SPE/SYSTYPE_SHORT
SPE_LIEFFZCumulative Qty for SchedAgr - Vendor's Point of View/SPE/LIEFFZMENG15
SPE_IMWRKInbound Delivery item has Status 'In Plant'/SPE/IMWRK_ITEMXFELD
SPE_LIFEXPOS2External item identifier/SPE/DE_EXT_IDENTCHAR35
SPE_EXCEPT_CODEException Code Warehouse for Quantity Difference/SPE/INB_EXCEPT_CODE_WM/SPE/EXCEPT_CODE_WM
SPE_KEEP_QTYRetention Quantity for Scrap. Process in EWM/SPE/KEEP_QUANTITYMENG13
SPE_ALTERNATEAlternate Product Number/SPE/DE_ALTERNATE_PART_NR/SPE/DE_ALTERNATE_PART_NR
SPE_MAT_SUBSTReason for material substitution/SPE/MAT_SUBST/SPE/MAT_SUBST
SPE_STRUCStructure of Items That Are Delivered Together/SPE/STRUC  
SPE_APO_QNTYFACNumerator of Quotient for Unit of Measure ConversionAPOQUANFACTORAPOQUANFACTOR
SPE_APO_QNTYDIVDenominator of Quotient for Unit of Measure ConversionAPOQUANDIVISORAPOQUANDIVISOR
SPE_HERKLCountry of origin of the materialHERKLLAND1
SPE_BXP_DATE_EXTBegin date of validity period of returns delivery/SPE/RET_EXPIRY_DATE_EXT_BTZNTSTMPS
SPE_VERSIONDelivery Version at Confirmation/SPE/DE_DLV_VERSIONNUMC04
SPE_COMPL_MVTCompletion of Goods Movements after Difference Postings/SPE/COMPL_MVTXFELD
J_1BTAXLW4COFINS Tax LawJ_1BTAXLW4J_1BTAXLW4
J_1BTAXLW5PIS Tax LawJ_1BTAXLW5J_1BTAXLW5
J_1BTAXLW3Tax law: ISSJ_1BTAXLW3J_1BTAXLW3
BUDGET_PDFM: Budget PeriodFM_BUDGET_PERIODFM_BUDGET_PERIOD
KBNKZKanban IndicatorKBNKZKBNKZ
SITKZSpecification for Issuing Valuated Stock in TransitSITKZSITKZ
.INCLU--APSeasonal Procurement: Append for LIPS    
CONS_ORDERPurchase Order for ConsignmentWRF_CONS_ORDERWRF_CONS_ORDER

LIPS related tables

TableNote
LIPSSD document: Delivery: Item data
SMOLIPSSD document: Delivery: Item data
/BOFU/DEM_D_ITEMDelivery Document Item
JVTLFNGIS-M/SD: Delivery/Home Delivery
JVTLIEFBARIS-M/SD: Delivery/Home Delivery/Pickup Viability Sets
OIFDD1Delivery point info for bulk delivery preplannning
TVLKAIPDetermine Delivery Type for Delivery Creation Using BAPI
VXSISPExpress Delivery Company: Delivery Priority -> Service Code
/DSD/ME_DELV_LFTDSD CN: Assignm. of Delivery Types to DSD Delivery Scenarios
J_1IEXCREFDelivery document to excise invoice refrence document link
TMDRD_DOCTPDelivery Relationshp: Document Types per Document Category
TWDRD_DOCTPDelivery Relationshp: Document Types per Document Category
DVK02R/2-R/3 Link: Delivery Item Data R2 -> R3
FKK_JLRPHD_SHORTItem Data for IS-M/SD Home Delivery Settlement - Extracts
PKSDControl Cycle Item/Additional Data for Kanban With Delivery
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com