Model / SD / LIPS

SD — Sales & Distribution

LIPS

73 fields · 3 key · 41 foreign keys · sourced from leanx.eu

Outbound delivery item data — quantities, batches, and warehouse detail per delivery line.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
TRD keytraditioDeliveryVBELN_VLCHAR 10VBUK
TRD_POS keytraditio positioDelivery ItemPOSNR_VLNUMC 6VBUP
TRD_POS_CTGtraditio positio categoriaDelivery item categoryPSTYV_VLCHAR 4TVPT
NOM_PSN_CREnomen persona creatusName of Person who Created the ObjectERNAM12 0CHAR
TMPtempusEntry timeERZET6 0TIMS
DIE_TBL_CREdies tabula creatusDate on Which Record Was CreatedERDAT8 0DATS
MAT_NUMmateria numerusMaterial NumberMATNRCHAR 18MARA
MATmateriaMaterial enteredMATWACHAR 18MARA
MAT_CTSmateria coetusMaterial GroupMATKLCHAR 9T023
OFCofficinaPlantWERKS_DCHAR 4T001W
LOClocus repositionisStorage LocationLGORT_DCHAR 4T001L
GRX_NUMgrex numerusBatch NumberCHARG_DCHAR 10MCHA
MAT_EMPmateria emptorMaterial belonging to the customerKDMAT35 0CHAR
HIRhierarchiaProduct hierarchyPRODH_DCHAR 18T179
ACL_QNT_VDTactualis quantitas venditioActual quantity delivered (in sales units)LFIMG13 3QUAN
MENmensuraBase Unit of MeasureMEINSUNIT 3T006
VDT_UNIvenditio unitasSales unitVRKMEUNIT 3T006
NET_PNDnetus pondusNet weightNTGEW_1515 3QUAN
GRS_PNDcrassus pondusGross weightBRGEW_1515 3QUAN
PND_UNIpondus unitasWeight UnitGEWEIUNIT 3T006
VLMvolumenVolumeVOLUM_1515 3QUAN
VLM_UNIvolumen unitasVolume unitVOLEHUNIT 3T006
OBXobexBlockFAKSPCHAR 2TVFS
MAT_DIEmateria diesMaterial Staging/Availability DateMBDAT8 0DATS
ACL_QNTactualis quantitasActual quantity delivered in stockkeeping unitsLGMNG13 3QUAN
TXT_VDT_MNDtextus venditio mandatumShort text for sales order itemARKTX40 0CHAR
LGPBEStorage BinLGPBE10 0CHAR
DOCdocumentumOriginating documentVBELVCHAR 10VBUK
POSpositioOriginating itemPOSNVNUMC 6VBUP
NDO_RFR_DOCnumerus documenti referentia documentumDocument number of the reference documentVGBELCHAR 10VBUK
POS_NUM_RFRpositio numerus referentiaItem number of the reference itemVGPOSNUMC 6VBUP
FACfacturaRelevant for BillingFKREL1 0CHAR
CTScoetusLoading GroupLADGRCHAR 4TLGR
CTS2coetusTransportation GroupTRAGRCHAR 4TTGR
NHR_HORnumerus horrei horreumWarehouse Number / Warehouse ComplexLGNUMCHAR 3T300
GRPgenus repositionisStorage TypeLGTYPCHAR 3T301
LGPLAStorage BinLGPLACHAR 10LAGP
MTM_GENmotus genusMovement Type (Inventory Management)BWARTCHAR 3T156
MAT_GENmateria genusMaterial TypeMTARTCHAR 4T134
AES_GENaestimatio genusValuation TypeBWTAR_DCHAR 10T149D
CTS3coetusChecking Group for Availability CheckMTVFPCHAR 2TMVF
ANGarea negotiiBusiness AreaGSBERCHAR 4TGSB
VDTvenditioSales OfficeVKBURCHAR 4TVBUR
VDT_CTSvenditio coetusSales GroupVKGRPCHAR 3TVKGR
CDScanalis distributionisDistribution ChannelVTWEGCHAR 2TVTW
DVSdivisioDivisionSPARTCHAR 2TSPA
SMP_DOC_MONsumptus documentum monetaCost in document currencyWAVWR13 2CURR
CPA_IDXcopia indexSpecial Stock IndicatorSOBKZCHAR 1T148
MUTmutatusChanged OnAEDAT8 0DATS
CSMcentrum sumptusCost CenterKOSTLCHAR 10CSKS
AMDarea moderationisControlling AreaKOKRSCHAR 4TKA01
SEG_NUMsegmentum numerusProfitability Segment Number (CO-PA)RKEOBJNR10 0NUMC
CLUcentrum lucriProfit CenterPRCTR10 0CHAR
OPS_ELM_EOPopus elementum elementum operisWork Breakdown Structure Element (WBS Element)PS_PSP_PNR8 0NUMC
MND_NUMmandatum numerusOrder NumberAUFNRCHAR 12AUFK
VDT_MND_NUMvenditio mandatum numerusSales Order NumberKDAUF10 0CHAR
POS_NUM_VDTpositio numerus venditioItem Number in Sales OrderKDPOS6 0NUMC
RAT_ASG_CTGratio assignatio categoriaAccount Assignment CategoryKNTTPCHAR 1T163K
NET_PREnetus pretiumNet priceNETPR11 2CURR
NET_VAL_DOCnetus valor documentumNet Value in Document CurrencyNETWR15 2CURR
CND_TAX_UNIcondicio taxatio unitasCondition pricing unitKPEIN5 0DEC
CND_UNIcondicio unitasCondition unitKMEINUNIT 3T006
VAL_PCTvalor pactumValue contract no.WKTNRCHAR 10VBUK
VAL_PCT_POSvalor pactum positioValue contract itemWKTPSNUMC 6VBUP
NUM_RQSnumerus requisitumNumber of Reservation/Dependent RequirementRSNUM10 0NUMC
POS_NUM_RQSpositio numerus requisitumItem Number of Reservation/Dependent RequirementRSPOS4 0NUMC
DOC_CTGdocumentum categoriaSD document categoryVBTYP1 0CHAR
RAT_NUMratio numerusG/L Account NumberSAKNR10 0CHAR
DIEdiesShelf Life Expiration or Best-Before DateVFDAT8 0DATS
DIE2diesDate of ManufactureHSDAT8 0DATS
DOC_RFRdocumentum referentiaDocument No. of a Reference DocumentLFBNR10 0CHAR
POS_RFR_DOCpositio referentia documentumItem of a Reference DocumentLFPOS4 0NUMC

Foreign keys

FieldCheck tableCheck field
AUFNRAUFKAUFNR
BWARTT156BWART
BWTART149DBWTAR
CHARGMCHACHARG
GEWEIT006MSEHI
GSBERTGSBGSBER
KMEINT006MSEHI
KNTTPT163KKNTTP
KOKRSTKA01KOKRS
KOSTLCSKSKOSTL
LADGRTLGRLADGR
LGNUMT300LGNUM
LGORTT001LLGORT
LGPLALAGPLGPLA
LGTYPT301LGTYP
MANDTT000MANDT
MATKLT023MATKL
MATNRMARAMATNR
MATWAMARAMATNR
MEINST006MSEHI
MTARTT134MTART
MTVFPTMVFMTVFP
POSNRVBUPPOSNR
POSNVVBUPPOSNR
PRODHT179PRODH
PSTYVTVPTPSTYV
SOBKZT148SOBKZ
SPARTTSPASPART
TRAGRTTGRTRAGR
VBELNVBUKVBELN
VBELVVBUKVBELN
VGBELVBUKVBELN
VGPOSVBUPPOSNR
VKBURTVBURVKBUR
VKGRPTVKGRVKGRP
VOLEHT006MSEHI
VRKMET006MSEHI
VTWEGTVTWVTWEG
WERKST001WWERKS
WKTNRVBUKVBELN
WKTPSVBUPPOSNR

View LIPS.yaml in the repository