MCLIPS SAP (Delivery: Item Data) Structure details

Dictionary Type: Structure
Description: Delivery: Item Data




ABAP Code to SELECT data from MCLIPS
Related tables to MCLIPS
Access table MCLIPS




Structure field list including key, data, relationships and ABAP select examples

MCLIPS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Delivery: Item Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MCLIPS TYPE MCLIPS.

The MCLIPS table consists of various fields, each holding specific information or linking keys about Delivery: Item Data data available in SAP. These include MANDT (Client), VBELN (Delivery), POSNR (Delivery Item), PSTYV (Delivery item category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MCLIPS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VBELNDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
POSNRDelivery Item POSNR_VLNUMC6VBUPPOSNR
PSTYVDelivery item category PSTYV_VLCHAR4TVPTPSTYV
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
ERDATDate on Which Record Was Created ERDATDATS8DATUM
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MATWAMaterial entered MATWACHAR18MARAMATN1MATNRMAT
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
CHARGBatch Number CHARG_DCHAR10MCHACHARGCHA
LICHNVendor Batch Number LICHNCHAR15LICHN
KDMATMaterial belonging to the customer KDMATCHAR35IDNEX
PRODHProduct hierarchy PRODH_DCHAR18T179PRODHVPR
LFIMGActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
NTGEWNet weight NTGEW_15QUAN15(3) MENG15
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
VOLUMVolume VOLUM_15QUAN15(3) MENG15
VOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
KZTLFPartial delivery at item level KZTLFCHAR1KZTLF
UEBTKIndicator: Unlimited Overdelivery Allowed UEBTKCHAR1XFELD
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
CHSPLBatch split allowed CHSPLCHAR1XFELD
FAKSPBlock FAKSPCHAR2TVFSFAKSP
MBDATMaterial Staging/Availability Date MBDATDATS8DATUM
LGMNGActual quantity delivered in stockkeeping units LGMNGQUAN13(3) MENG13
ARKTXShort text for sales order item ARKTXCHAR40TEXT40
LGPBEStorage Bin LGPBECHAR10CHAR10
VBELVOriginating document VBELVCHAR10VBUKALPHAVBELN
POSNVOriginating item POSNVNUMC6VBUPPOSNR
VBTYVSD document category VBTYPCHAR1VBTYP
VGSYSLogical System in the Preceding Document VGLOGSYSCHAR10TBDLSALPHALOGSYS
VGBELDocument number of the reference document VGBELCHAR10VBUKALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6VBUPPOSNR
UPFLUUpdate indicator for delivery document flow UPFLLCHAR1UPFLL
UEPOSHigher-level item in bill of material structures UEPOSNUMC6VBUPPOSNR
FKRELRelevant for Billing FKRELCHAR1FKREL
LADGRLoading Group LADGRCHAR4TLGRLADGR
TRAGRTransportation Group TRAGRCHAR4TTGRTRAGR
KOMKZIndicator for picking control KOMKZCHAR1KOMKZ
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
LISPLSplit to warehouse number required LNSPL_LIPSCHAR1LNSPL_LIPS
LGTYPStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10LAGPLGPLALGPLAG1
BWTEXIndicator: Separate valuation BWTEXCHAR1XFELD
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
BWLVSMovement Type for Warehouse Management BWLVSNUMC3T333BWLVSBWL
KZDLGIndicator: dynamic storage bin in warehouse management LVS_KZDLGCHAR1XFELD
BDARTRequirement type BDARTCHAR2BDARTBDA
PLARTPlanning type PLARTCHAR1Assigned to domainPLART
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
VGREFPreceding document has resulted from reference VGREFCHAR1XFELD
POSARItem type POSARCHAR1POSAR
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
SUMBDSumming up of requirements SUMBDCHAR1SUMBD
MTVFPChecking Group for Availability Check MTVFPCHAR2TMVFMTVFP
EANNREuropean Article Number (EAN) - obsolete!!!!! EANNRCHAR13CHAR13EAN
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
VKBURSales Office VKBURCHAR4TVBURVKBURVKB
VKGRPSales Group VKGRPCHAR3TVKGRVKGRPVKG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
GRKORDelivery group (items are delivered together) GRKORNUMC3GRKOR
FMENGQuantity is Fixed FMENGCHAR1XFELD
ANTLFMaximum Number of Partial Deliveries Allowed Per Item ANTLFDEC1ANTLF
VBEAFFixed shipping processing time in days (= setup time) VBEAFDEC5(2) DEC3_2
VBEAVVariable shipping processing time in days VBEAVDEC5(2) DEC3_2
STAFOUpdate group for statistics update STAFOCHAR6Assigned to domainALPHASTAFOMCF
WAVWRCost in document currency WAVWRCURR13(2) WERTV7
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
AEDATChanged On AEDATDATS8DATUM
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
KVGR1Customer group 1 KVGR1CHAR3TVV1KVGR1
KVGR2Customer group 2 KVGR2CHAR3TVV2KVGR2
KVGR3Customer group 3 KVGR3CHAR3TVV3KVGR3
KVGR4Customer group 4 KVGR4CHAR3TVV4KVGR4
KVGR5Customer group 5 KVGR5CHAR3TVV5KVGR5
MVGR1Material group 1 MVGR1CHAR3TVM1MVGR1
MVGR2Material group 2 MVGR2CHAR3TVM2MVGR2
MVGR3Material group 3 MVGR3CHAR3TVM3MVGR3
MVGR4Material group 4 MVGR4CHAR3TVM4MVGR4
MVGR5Material group 5 MVGR5CHAR3TVM5MVGR5
VPZUOAllocation Indicator VPZUOCHAR1ZUVKZ
VGTYPSD document category VBTYPCHAR1VBTYP
RFVGTYPType of preceding document in central system RFVGTYPCHAR1VBTYP
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
POSNR_PPOrder Item Number CO_POSNRNUMC4CO_POSNR
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
VPMATPlanning material VPMATCHAR18MARAMATN1MATNR
VPWRKPlanning plant VPWRKCHAR4T001WWERKS
PRBMEBase unit of measure for product group PRBMEUNIT3T006CUNITMEINS
UMREFConversion factor: quantities UMREFFFLTP16(16) FLTP
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
KZVBRConsumption Posting KZVBRCHAR1KZVBR
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
PCKPFPacking control PCKPFCHAR1PCKPF
BEDAR_LFRequirements class BEDARCHAR3T459KBEDAR
CMPNTID: Item with active credit function / relevant for credit CMPNTCHAR1XFELD
KCMENGCumulative batch quantity of all split items (in StckUnit) KCMENGQUAN15(3) MENG15
KCBRGEWCumulative gross weight of all batch split items KCBRGEWQUAN15(3) MENG15
KCNTGEWCumulative net weight of all batch split items KCNTGEWQUAN15(3) MENG15
KCVOLUMCumulative volume of all batch split items KCVOLUMQUAN15(3) MENG15
UECHAHigher-Level Item of Batch Split Item UECHANUMC6LIPSPOSNR
CUOBJConfiguration CUOBJ_VANUMC18CUOBJ
CUOBJ_CHInternal object number of the batch classification CUOBJ_CHNUMC18CUOBJ
ANZSNNumber of serial numbers ANZSNINT410INT4
SERAILSerial Number Profile SERAILCHAR4T377PSERAIL
KCGEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
KCVOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
SERNRBOM explosion number SERNRCHAR8SNUMSERNR
ABRLIInternal delivery schedule number ABRLINUMC4VBLBABRLI
ABARTRelease type ABARTCHAR1ABART
ABRVWUsage Indicator ABRVWCHAR3TVLVABRVW
QPLOSInspection Lot Number QPLOSNUMC12QALSQPLOSQLSQALS
QTLOSPartial lot number QTLOSNUMC6Assigned to domainQTLOSQTL
NACHLCustomer has not posted goods receipt NACHLCHAR1XFELD
MAGRVMaterial Group: Packaging Materials MAGRVCHAR4TVEGRMAGRV
OBJKOObject number at header level OBJKOCHAR22Assigned to domainJ_OBJNR
OBJPOObject number at item level OBJPOCHAR22Assigned to domainJ_OBJNR
AESKDCustomer Engineering Change Status AESKDCHAR17AESKD
SHKZGReturns Item SHKZG_VACHAR1XFELD
PROSAID for material determination PROSACHAR1PROSA
UEPVWID for higher-level item usage UEPVWCHAR1UEPVW
EMPSTReceiving point EMPSTCHAR25TEXT25
ABTNRDepartment number ABTNRCHAR4TSABABTNR
KOQUIPicking is subject to confirmation KOQUICHAR1XFELD
STADATStatistics date STADATDATS8DATUM
AKTNRCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
KNUMH_CHNumber of condition record from batch determination KNUMH_CHCHAR10KNUMB
PREFEPreference indicator in export/import PREFECHAR1PREFE
EXARTBusiness Transaction Type for Foreign Trade EXARTCHAR2Assigned to domainEXARTEXA
CLINTInternal Class Number CLINTNUMC10KLAHCLINT
CHMVSBatches: Exit to quantity proposal CHMVSNUMC3NUM3
ABELNAllocation Table Number ABELNCHAR10AUKOALPHAABELNABE
ABELPItem number of allocation table ABELPNUMC5AUPOABELP
LFIMG_FLOInternal field/ Do not use / LFIMG in float / MUM LFIMG_FLOFLTP16(16) FLTP
LGMNG_FLOInternal field/ Do not use / LGMNG in float / MUM LGMNG_FLOFLTP16(16) FLTP
KCMENG_FLOInternal field/ Do not use / KCMENG in float / MUM KCMENG_FLOFLTP16(16) FLTP
KZUMWEnvironmentally Relevant KZUMWCHAR1XFELD
KMPMGComponent quantity KMPMGQUAN13(3) MENGV13
AURELRelevant to Allocation Table AURELCHAR1AUREL
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit KMEINUNIT3T006CUNITMEINS
NETPRNet price NETPRCURR11(2) WERTV6
NETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
KOWRRStatistical values KOWRRCHAR1KOWRR
KZBEWMovement Indicator KZBEWCHAR1KZBEW
MFRGRMaterial freight group MFRGRCHAR8TMFGMFRGR
CHHPVPack accumulated batches / movement type item CHHPVCHAR1XFELD
ABFORForm of payment guarantee ABSFORM_CMCHAR2T691KABSFORM_CM
ABGESGuaranteed (factor between 0 and 1) ABGES_CMFLTP16(16) FLTP
MBUHRMaterial Staging Time (Local, Relating to a Plant) MBUHRTIMS6TIME_PLANT
WKTNRValue contract no. WKTNRCHAR10VBUKALPHAVBELN
WKTPSValue contract item WKTPSNUMC6VBUPPOSNR
J_1BCFOPCFOP Code and Extension J_1BCFOPCHAR10J_1BAGCFOBRJ_1BCFOP
J_1BTAXLW1Tax law: ICMS J_1BTAXLW1CHAR3J_1BATL1ALPHAJ_1BTAXLW1
J_1BTAXLW2Tax law: IPI J_1BTAXLW2CHAR3J_1BATL2ALPHAJ_1BTAXLW2
J_1BTXSDCSD tax code J_1BTXSDC_CHAR2J_1BTXSDCJ_1BTXSDC
SITUAIndicator for situation SITUACHAR2Assigned to domainSITUA
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
RSARTRecord type RSARTCHAR1RSART
KANNRKANBAN/sequence number KANNRCHAR35CHAR35
KZFMEID: Leading unit of measure for completing a transaction KZFMECHAR1KZFME
PROFLDangerous Goods Indicator Profile ADGE_PROFLCHAR3TDG41ADGD_PROFL
KCMENGVMECumulative batch quantity of all split items in sales units KCMENG_VMEQUAN15(3) MENGV15_3
KCMENGVMEFCumulated batch split quantity in VRKME and float KCMENGVMEFFLTP16(16) FLTP
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
PSPNRProject definition (internal) PS_INTNRNUMC8Assigned to domainKONPDPS_PSPNR
EPRIOWithdrawal sequence group for stocks EPRIOCHAR4Assigned to domainEPRIO
RULESStock determination rule BF_RULESCHAR4T434RBF_RULES
KZBEFIndicator Inventory Management active LVS_KZBEFCHAR1XFELD
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18MARAMATN1MATNRHTN
LGBZOStaging Area for Warehouse Complex LGBZOCHAR10T30CLGBZO
HANDLEWorldwide unique key for LIPS-VBELN & LIPS_POSNR TSEGGUID_LIPSCHAR22SYSUUID_22
VERURPOSDistribution delivery: Original item VERURPOSNUMC6Assigned to domainPOSNR
LIFEXPOSExternal item number LIFEXPOSNUMC6Assigned to domainPOSNR
NOATPIndicator: deactivate availability check NO_ATP_CHECKCHAR1NO_ATP_CHECK
NOPCKIndicator: not relevant for picking NO_PICKINGCHAR1XFELD
RBLVSReference movement type for WM from material movements RBLVSNUMC3LVS_BWREF
BERIDMRP Area BERIDCHAR10MDLVBERIDBERID
BESTQStock Category in the Warehouse Management System BESTQCHAR1BESTQ
UMBSQStock Category in the Warehouse Management System BESTQCHAR1BESTQ
UMMATReceiving/Issuing Material UMMATCHAR18Assigned to domainMATN1MATNR
UMWRKReceiving/Issuing Plant UMWRKCHAR4Assigned to domainWERKS
UMLGOReceiving/Issuing Storage Location UMLGOCHAR4Assigned to domainLGORT
UMCHAReceiving/Issuing Batch UMCHACHAR10Assigned to domainCHARG
UMBARValuation Type of Transfer Batch UMBARCHAR10Assigned to domainBWTAR
UMSOKSpecial Stock Indicator for Physical Stock Transfer UMSOKCHAR1Assigned to domainSOBKZ
SONUMSpecial Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
USONUSpecial Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
AKKURExchange rate for letter-of-credit procg in foreign trade AKKURDEC9(5) KURRF
AKMNGCurrent Qty Field for Arithmetic Operations in Doc.Process. AKMNGCHAR1AKMNG
VKGRURepair Processing: Classification of Items VKGRUCHAR3Assigned to domainRMA_VORGARMA_VORGA
SHKZG_UMIndicator: UNMAT in main posting SHKZG_UMCHAR1SHKZG_UM
INSMKStock Type MB_INSMKCHAR1MB_INSMK
KZECHDetermination of batch entry in the production/process order KZECHCHAR1KZECH
FLGWMIndicator: Copy dest. storage data from preceding document FLGWMCHAR1FLGWM
BERKZMaterial Staging Indicator for Production Supply BERKZCHAR1LVS_BERKZ
HUPOSIndicator: Delivery item is a HU item HUPOSCHAR1HUPOS
NOWABIndicator: Item Not Relevant for Goods Movements NOWABCHAR1NOWAB
KONTOG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
HSDATDate of Manufacture HSDATDATS8DATUM
VFDATShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
LFGJAFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
LFBNRDocument No. of a Reference Document LFBNRCHAR10ALPHABELNR
LFPOSItem of a Reference Document LFPOSNUMC4MBLPO
GRUNDReason for goods movment MB_GRUNDNUMC4NUMC4
FOBWASubsequent movement type FOBWACHAR3Assigned to domainBWART
DLVTPDelivery Category DLVTPCHAR2DLVTP
EXBWRExternally Entered Posting Amount in Local Currency EXBWRCURR13(2) WERT7
BPMNGQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
EXVKWExternally Entered Sales Value in Local Currency EXVKWCURR13(2) WERT7
CMPRE_FLTItem credit price CMPRE_FLTFLTP16(16) FLTP
KZPODPOD indicator (relevance, verification, confirmation) KZPODCHAR1KZPOD
LFDEZNot relevant for distribution for WMS LFDEZCHAR1LFDEZ
UMREVConversion Factor of Delivery Quantity VRKME for MEINS LE_UMREVFLTP16(16) FLTP
PODRELPOD Control (Proof of Delivery) PODRELCHAR1PODREL
KZUMLStock transfer/transfer posting KZUMLCHAR1XFELD
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
KZWSOUnits of measure usage KZWSOCHAR1KZWSO
GMCONTROLGoods Movement Control GMCONTROLCHAR1GMCONTROL
POSTING_CHANGEGoods Movement Control: HU POSTING_CHANGECHAR1POSTING_CHANGE
UM_PS_PSP_PNRReceiving/Issuing (WBS Element) UM_PS_PSP_PNRNUMC8Assigned to domainABPSPPS_POSNR
PRE_VL_ETENSSequential Number of Vendor Confirmation ETENSNUMC4NUM04
SPE_GEN_ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
SPE_SCRAP_INDScrap Indicator for EWM Processing /SPE/DELIVERY_SCRAP_INDCHAR1/SPE/DELIVERY_SCRAP_IND
SPE_AUTH_NUMBERReturn Material Authorization Number /SPE/RET_RMACHAR20ALPHA/SPE/RET_RMA
SPE_INSPOUT_GUIDInspections: Inspection outcome GUID set by EWM /SPE/INSP_OUT_GUID_16RAW16/SPE/RET_GUID16
SPE_FOLLOW_UPDefault Follow-Up Activity Code /SPE/RET_FOLLOW_UPCHAR4/SPE/RET_FOLLOW_UP
SPE_EXP_DATE_EXTEnd date of validity period of returns delivery /SPE/RET_EXPIRY_DATE_EXTDEC15TZNTSTMPS
SPE_EXP_DATE_INTEnd date of internal validity period of returns delivery /SPE/RET_EXPIRY_DATE_INTDEC15TZNTSTMPS
SPE_AUTH_COMPLETRMA completion indicator /SPE/RET_RMA_COMPLETEDCHAR1/SPE/RET_RMA_COMPLETED
ORMNGOriginal Quantity of Delivery Item ORMNG_VLQUAN13(3) MENG13
SPE_ATP_TMSTMPATP Time Stamp /SPE/DE_ATP_TIMESTAMPDEC15TZNTSTMPS
SPE_ORIG_SYSOriginal System Type /SPE/INB_ORIGIN_SYSCHAR1/SPE/SYSTYPE_SHORT
SPE_LIEFFZCumulative Qty for SchedAgr - Vendor's Point of View /SPE/LIEFFZQUAN15(3) MENG15
SPE_IMWRKInbound Delivery item has Status 'In Plant' /SPE/IMWRK_ITEMCHAR1XFELD
SPE_LIFEXPOS2External item identifier /SPE/DE_EXT_IDENTCHAR35CHAR35
SPE_EXCEPT_CODEException Code Warehouse for Quantity Difference /SPE/INB_EXCEPT_CODE_WMCHAR4/SPE/EXCEPT_CODE_WM
SPE_KEEP_QTYRetention Quantity for Scrap. Process in EWM /SPE/KEEP_QUANTITYQUAN13(3) MENG13
SPE_ALTERNATEAlternate Product Number /SPE/DE_ALTERNATE_PART_NRCHAR40/SPE/DE_ALTERNATE_PART_NR
SPE_MAT_SUBSTReason for material substitution /SPE/MAT_SUBSTCHAR1/SPE/MAT_SUBST
SPE_STRUCStructure of Items That Are Delivered Together /SPE/STRUCNUMC3
SPE_APO_QNTYFACNumerator of Quotient for Unit of Measure Conversion APOQUANFACTORDEC5APOQUANFACTOR
SPE_APO_QNTYDIVDenominator of Quotient for Unit of Measure Conversion APOQUANDIVISORDEC5APOQUANDIVISOR
SPE_HERKLCountry of origin of the material HERKLCHAR3Assigned to domainLAND1LND
SPE_BXP_DATE_EXTBegin date of validity period of returns delivery /SPE/RET_EXPIRY_DATE_EXT_BDEC15TZNTSTMPS
SPE_VERSIONDelivery Version at Confirmation /SPE/DE_DLV_VERSIONNUMC4NUMC04
SPE_COMPL_MVTCompletion of Goods Movements after Difference Postings /SPE/COMPL_MVTCHAR1XFELD
J_1BTAXLW4COFINS Tax Law J_1BTAXLW4CHAR3J_1BATL4AALPHAJ_1BTAXLW4
J_1BTAXLW5PIS Tax Law J_1BTAXLW5CHAR3J_1BATL5ALPHAJ_1BTAXLW5
J_1BTAXLW3ISS Tax Law J_1BTAXLW3CHAR3J_1BATL3ALPHAJ_1BTAXLW3
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
KBNKZKanban Indicator KBNKZCHAR1KBNKZ
SITKZSpecification for Issuing Valuated Stock in Transit SITKZCHAR1SITKZ
.INCLU--AP 0
/SAPMP/LBA_NODTUC Complete /SAPMP/LBADONECHAR1XFELD
.INCLU--AP 0
/SAPMP/ALT_CONVMill: Indicator Provisional Conversion Factors /SAPMP/ALT_CONVCHAR1XFELD
.INCLU--AP 0
LGTORDoor for Warehouse Number LGTORCHAR3Assigned to domainLGTOR
.INCLU--AP 0
MILL_UCDETBatch Determination for Original Batches MILL_UCDETCHAR1MILL_UCDET
.INCLU--AP 0
CONS_ORDERPurchase Order for Consignment WRF_CONS_ORDERCHAR1WRF_CONS_ORDER
VDATUDate of update for statistics updating MC_VDATUMDATS8DATUM
LLANDCountry of Destination LLANDCHAR3Assigned to domainLAND1VLL
APOAUMEOpen orders quantity in base unit of measure MC_OAUMEQUAN15(3) MENGV15_3
APOAUWEOpen net value of orders MC_OAUWECURR19(2) WERTV10
APERDATDate on Which Record Was Created ERDATDATS8DATUM
APSTCURExchange rate for statistics STCURDEC9(5) EXCRTKURRF
APWAERKSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
APNETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
APPRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
APKURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
APKURSK_DATTranslation Date WWERT_DDATS8DATUM
APKURSTExchange Rate Type KURSTCHAR4Assigned to domainKURSTKUT
APKLMENGCumulative confirmed quantity in base unit KLMENGQUAN15(3) MENG15
APLSMENGCumulative required delivery qty (all dlv-relev.sched.lines) LSMENGQUAN15(3) MENG15
APKBMENGCumulative confirmed quantity in sales unit KBMENGQUAN15(3) MENG15
APKWMENGCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
APLFGSAOverall delivery status of the item LFGSACHAR1STATV
APLFSTADelivery status LFSTACHAR1STATV
APABSTARejection status for SD item ABSTA_VBCHAR1STATV
AKVBTYPSD document category VBTYPCHAR1VBTYP
APVRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
APUMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
APUMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
APCMPREItem credit price CMPRE_FLTFLTP16(16) FLTP
APCMKUACredit data exchange rate for requested delivery date CMKUADEC9(5) KURRF
OLIMEOpen delivery quantity MC_OLIMEQUAN15(3) MENGV15_3
OLIKWOpen delivery credit value MC_OLIKW_FFLTP16(16) FLTP
OLIKWGESTotal open delivery credit value (without guarantee) MC_OLIKWGFFLTP16(16) FLTP
OLIKWAAGuaranteed open delivery value MC_OLIKWFAFLTP16(16) FLTP
SUMFKIMGInvoiced quantity in basic unit of measure ERLMENGE_FQUAN13(3) MENG13
APVGBELDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
APVGPOSItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
PERIV_LFFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
APSPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
WEBUKCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
APOAUMEVKMOpen orders quantity in base unit of measure MC_OAUMEQUAN15(3) MENGV15_3
APLCNUMFinancial doc. processing: Internal financial doc. number LCNUMCHAR10Assigned to domainALPHALCNUMAKN
ABSTPPayment guarantee category ABSTYP_CMCHAR1ABSTYP_CM
APWKWAEValue contract currency WKWAECUKY5Assigned to domainWAERS
APWKKURExchange rate in value contract currency WKKURDEC9(5) KURRF
APABGRUReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
APABGESGuaranteed (factor between 0 and 1) ABGES_CMFLTP16(16) FLTP
APERDATADate on which the release order was added ERDATADATS8DATUM
APAEDATADate on which the release order was last changed AEDATADATS8DATUM
APKOWRRStatistical values KOWRRCHAR1KOWRR
APMEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
PODMGActual quantity accepted in sales unit per delivery item PODMGQUAN13(3) MENG13
DLFIMGDeviation from LFIMG in SUn according to POD DLFIMGQUAN13(3) MENG13
PKUNAGSold-to party KUNAGCHAR10Assigned to domainALPHAKUNNRVAG
PKUNWEShip-to party KUNWECHAR10Assigned to domainALPHAKUNNR
PKUNREBill-to party KUNRECHAR10Assigned to domainALPHAKUNNRKUN
PKUNRGPayer KUNRGCHAR10Assigned to domainALPHAKUNNR
PSPDNRForwarding agent SPDNRCHAR10Assigned to domainALPHALIFNR
PVRTNRSales employee VRTNRNUMC8PERNRPREMV
PLAAGCountry of the sold-to party PLAAGCHAR3Assigned to domainLAND1
PLAWECountry of ship-to party PLAWECHAR3Assigned to domainLAND1
PLARECountry of the bill-to party PLARECHAR3Assigned to domainLAND1
PLARGCountry of the payer PLARGCHAR3Assigned to domainLAND1
PLASPCountry of the carrier PLASPCHAR3Assigned to domainLAND1
PLAVECountry of the representative PLAVECHAR3Assigned to domainLAND1
PABLAUnloading point of the ship-to party PABLACHAR25TEXT25
PZONETransportation zone of the ship-to party PZONECHAR10Assigned to domainZONE
PDUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
PZPERSPerson responsible DZPERSNUMC8PERNR
PLAZMCountry of Employee Responsible PLAZMCHAR3Assigned to domainLAND1
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
EKSGBPurchasing area EKSGBCHAR4T026EKSGB
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
DISPOMRP Controller (Materials Planner) DISPOCHAR3T024DDISPODGRHS_T024D
LIFNRAccount number of regular vendor MCW_RLIFNCHAR10LFA1ALPHALIFNRLIF
LTSNRVendor Subrange LTSNRCHAR6WYT1LTSNR
BTRKZPlant category VLFKZCHAR1VLFKZ
WGRU2Material group hierarchy 2 MCW_WGRU2CHAR18KLASSEWGRU2
WGRU1Material group hierarchy 1 MCW_WGRU1CHAR18KLASSEWGRU1
SATNRCross-Plant Configurable Material SATNRCHAR18MARAMATN1MATNR
MERK1Characteristic 1 MCW_MERK1CHAR30ATWRT
MERK2Characteristic 2 MCW_MERK2CHAR30ATWRT
MERK3Characteristic 3 MCW_MERK3CHAR30ATWRT
AKTYPPromotion Category W_AKTYPCHAR4TWTYAKTTY
AKTHEPromotion theme W_AKTHECHAR4TWATTHEMA
PLGTPPrice Band Category PLGTPCHAR2TWPTPLGTP
SAISOSeason Category SAISOCHAR4T6WSPSAISOSAISO
SAISJSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
BWVORProcurement rule BWVORCHAR1T6WP1BWVOR
BWSCLSource of Supply BWSCLCHAR1TMBW1BQSCL
SERVGIS-R service level W_SERVGRDCHAR1TWSGW_SERVGRD
PRDHAProduct hierarchy PRODH_DCHAR18T179PRODHVPR
LAND1Country of regular vendor MCW_LANDRLCHAR3T005LAND1
WRKGR2Plant group hierarchy 2 MCW_WRKGR2CHAR18KLASSE
WRKGR1Plant group hierarchy 1 MCW_WRKGR1CHAR18KLASSE
ASCARAssortment ASORTCHAR10Assigned to domainALPHAASORTWSTWSOR
SVKORGMaster data: sales organization (Retail) MCW_SVKORGCHAR4TVKOVKORGVKO
SVTWEGMaster data: distribution channel (Retail) MCW_SVTWEGCHAR2Assigned to domainVTWEGVTW
SBZIRKMaster data: customer district (Retail) MCW_SBZIRKCHAR6T171BZIRK
SMATKLMaster data: material group (Retail) MCW_SMATKLCHAR9T023MATKLMKL
SABTNRRetail master data department MCW_SABTNRCHAR4TSABABTNR
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
KOLIFPrior Vendor KOLIFCHAR10LFA1ALPHALIFNR
WMAKGMaterial type ID WMAKCHAR1WMAK
ATINM1Internal characteristic number, characteristic 1 MCW_ATINM1NUMC10Assigned to domainATINNATINN
ATINM2Internal characteristic number, characteristic 2 MCW_ATINM2NUMC10Assigned to domainATINNATINN
ATINM3Internal characteristic number, characteristic 3 MCW_ATINM3NUMC10Assigned to domainATINNATINN
STRNRStructured material STRNRCHAR18MARAMATN1MATNR
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
SEAN11European article number (master data) SEAN11CHAR18EAN11EAN11EAN
LIFMNGDeliveries to customers, quantity MCW_LIFMNGQUAN15(3) MENGV15_3
LIFGEWDeliveries to customers, weight MCW_LIFGEWQUAN15(3) MENGV15_3
LIFVOLDeliveries to customers, volume MCW_LIFVOLQUAN15(3) MENGV15_3
WKUNNRCustomer number of plant KUNNR_WKCHAR10KNA1ALPHAKUNNR
RPLRELID: relevant for Replenishment? WRPL_RELEVCHAR1BOOLE
BIWMVERIS/Reporting Server - Transfer quantity sold MCW_BIWMVEQUAN15(3) MENGV15_3
BIWMNGRIS/Reporting Server - Transfer base quantity MCW_BIWMNGQUAN15(3) MENGV15_3
BWVORGSAP BW transaction key MCW_BWVORGNUMC3NUM3
HSUPKZAuxiliary statistics update indicator MCW_SUPKZCHAR1SUPKZ
HERZETEntry time ERZETTIMS6UZEIT
METYPUnit-of-measure load category according to workload criteria METYPCHAR1Assigned to domainMEITYVLY
WARTYPGoods category (promotional goods or normal goods) MCL_WARTYPCHAR1MCL_WARTYPVLW
BELTYPDocument category: rough workload estimate MCL_BELTYPCHAR3MCL_BELTYPVLT
VZTTGWarehouse process MCL_VZTTGCHAR1MCL_VZTTGVLP
VHARTLPackaging Material Type Rough Workload Estimate MCL_VHARTLCHAR4TVTYTRATY
TIMELTime slot: Rough workload forecast MCL_TIMELCHAR4TC37AKAPTPROG
PLGTYPPlanned picking storage type MCL_PLGTYPCHAR3T301LGTYPLGT
PKOBERPlanned picking area MCL_PKOBERCHAR3Assigned to domainKOBER
VGLZTComparison time for forming waves MCL_VGLZTTIMS6UZEIT
LGNUVPreceding warehouse number: rough workload estimate MCL_LGNUVCHAR3T300LGNUM
WARTYVPreceding goods category: rough workload estimate MCL_WARTYVCHAR1MCL_WARTYP
BELTYVPreceding document category: rough workload estimate MCL_BELTYVCHAR3MCL_BELTYP
PLGTYVPreceding planned picking storage type MCL_PLGTYVCHAR3T301LGTYP
PKOBEVPreceding planning picking area: rough workload estimate MCL_PKOBEVCHAR3T30AKOBER
LPRIVPreceding delivery priority MCL_LPRIVNUMC2TPRIOLPRIO
METYVPreceding unit-of-measure load category: rough workload est. MCL_METYVCHAR1TMETMEITY
VHARTVPreceding Packaging Material Type Rough Workload Estimate MCL_VHARTVCHAR4TVTYTRATY
TIMEVPreceding time slot: rough workload estimate MCL_TIMEVCHAR4TC37AKAPTPROG
VGLDTComparison date for forming waves MCL_VGLDTDATS8DATUM
GEWEHLWeight unit: Rough Workload Estimate and picking waves MCL_GEWEHUNIT3T006CUNITMEINS
VOLEHLVolume unit: Rough Workload Estimate and picking waves MCL_VOLEHUNIT3T006CUNITMEINS
BZEIT_EProcessing time+ for quantity in hours MCL_BZEITEDEC17(5) DEC17_5
VHART_EPackaging Materials for Packaging Material Type + MCL_VHARTEDEC15(3) DEC15_3
BZEIT_VPreceding processing time+ for quantity in hours MCL_BZEITVDEC17(5) DEC17_5
VHART_VPreceding Packaging Material for Packaging Material Type + MCL_VHARTKDEC15(3) DEC15_3
DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
BWMVEBW: Quantity in Sales Unit MCBW_MVEQUAN15(3) MENGV15_3
BWAPPLNMApplication Component RSAPPLNMCHAR30RSAPPLNM
BWSUPKZAuxiliary statistics update indicator MCBW_SUPKZCHAR1SUPKZ
BWERZETEntry time ERZETTIMS6UZEIT
BWDUMMYDummy Function for Extraction SAPBW MCBW_DUMMYCHAR1DUMMY

Key field Non-key field



How do I retrieve data from SAP structure MCLIPS using ABAP code?

As MCLIPS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCLIPS as there is no data to select.

How to access SAP table MCLIPS

Within an ECC or HANA version of SAP you can also view further information about MCLIPS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!