CDS Views for VDM Stock and Goods Movements (MM-IM-VDM-SGM)

CDS View NameDescriptionSQL View Name
A_MATERIALDOCUMENTHEADERDocument HeaderAMATDOCHEAD
A_MATERIALDOCUMENTITEMDocument ItemsAMATDOCITEM
A_SERIALNUMBERMATERIALDOCUMENTSerial NumbersASERNOITEM
C_GDSMVTTHROUGHPUTQUERYGoods Movement Throughput QueryCGDSMVTTPQUERY
C_GOODSMOVEMENTQUERYGoods Movement AnalysisCGDSMVTQUERY
C_INVTRYTURNOVERANALYSISInventory Turnover AnalysisCINVTRYTOANA
C_INVTRYTURNOVERANLYSDETSInventory Turnover Analysis DetailsCINVTOANLYSDETS
C_INVTRYTURNOVERPRFRDSUPPLIERInventory Turnover Preferred SupplierCINVTOPRFSUPLR
C_INVTRYTURNOVERSUPPLIERAll Supplier for material, plantCINVTOSUPLR
C_INVTRYTURNOVERTIMESERSInventory Turnover Time SeriesCINVTOTIMESER
C_MATERIALSTOCKACTUALTotal actual stock quantityCMATSTOCKACT
C_MATERIALSTOCKBYKEYDATEMaterial Stock at posting dateCMATSTOCKBYKDATE
C_MATERIALSTOCKRANGEOFCOVERAGEMaterials with Range of Coverage LT required thresholdCMATSTOCKROC
C_MATERIALSTOCKROCKPINumber of Materials with Range of Coverage LT thresholdCMATSTOCKROCKPI
C_MATERIALSTOCKTIMESERIESMaterial stock for periods by typeCMATSTOCKTIMESER
C_MATLSTKATKEYDATEINALTUOMStock at Key Date in Alternative UoMCMATSTKDATEAUOM
C_STOCKQTYCURRENTVALUE_2Current stock quantity and valueCSTKQUANVALCUR2
C_STOCKQUANTITYCURRENTVALUECurrent Stock Quantity and ValueCSTOCKQUANVALCUR
C_STOCKQUANTITYVALUEBYTYPEStock Quantity and Value by TypeCSTOCKVALBYTYPE
C_STOCKQUANTITYVALUETIMESERIESStock Quantity and Value time seriesCSTOCKQUANVALTS
I_AUGMENTEDGOODSMOVEMENTAugmented view of Goods MovementIAUGMGOODSMVMT
I_CONSUMPTIONPOSTINGINDICATORCode list view for data element KZVBR - Consumption PostingICNSMPNPOSTGIND
I_CURRENTMATLPRICEBYCOSTESTCurrent material price by cost estimateICURRMATPRICE
I_GOODSMOVEMENTCUBEAnalytical Cube for Goods MovementsIGOODSMVMTCUBE
I_GOODSMOVEMENTDOCUMENTGoods MovementsIGOODSMVMTDOC
I_GOODSMOVEMENTREFDOCTYPECode list view for data element KZBEW ΓÇô Movement IndicatorIGDSMVTREFDOC
I_GOODSMOVEMENTTYPEGoods Movement TypeIGDSMVTTYPE
I_GOODSMOVEMENTTYPETGoods Movement Type TextIGDSMVTTYPET
I_GOODSMVTTYPEBYSPCLSTKINDTGoods Movement Type by Special Stock Indicator TextIGDSMVTBYSPSTINT
I_GOODSRECEIPTTYPECode list view for data element KZZUG ΓÇô Receipt IndicatorIGDSRPCTTYPE
I_INVENTORYSPECIALSTOCKTYPEInventory Special Stock TypeIINVSPECSTOCKTY
I_INVENTORYSPECIALSTOCKTYPETInventory Special Stock Type TextIINVSPECSTOCKTYT
I_INVENTORYSTOCKTYPEInventory Stock TypeIINVSTOCKTYPE
I_INVENTORYSTOCKTYPETInventory Stock Type TextIINVSTOCKTYPET
I_INVTRYTURNOVERVALUECATTEXTInventory Turnover Value Category TextIINVTRYTOVCT
I_MATERIALDOCUMENTHEADERMaterial Document HeaderIMATDOCHEADER
I_MATERIALDOCUMENTHEADERSTDVHMaterial Document HeaderIRHMATDOCVH
I_MATERIALDOCUMENTHEADER_2Material Document HeaderIMATDOCHEADER2
I_MATERIALDOCUMENTITEMMaterial Document ItemIMATDOCITEM
I_MATERIALDOCUMENTITEM_2Material Document ItemIMATDOCITEM2
I_MATERIALSTOCKMaterial Stock CalculationIMATERIALSTOCK
I_MATERIALSTOCKPERIODSSINGLEMaterial stock periodsIMATSTOCKPSINGLE
I_MATERIALSTOCKRANGEOFCOVERAGERange of Coverage CalculationIMATSTOCKROC
I_MATERIALSTOCKTIMESERIESMaterial Stock For PeriodsIMATSTOCKTIMESER
I_MATERIALSTOCK_AGGRAggreg. of material stock on low levelIMATSTOCKAGGR
I_MATLDOCUMENTREVERSALSReversed Material DocumentIMATREVERSALS
I_MATLDOCWEIGHTEDSTOCKWeighted stock for average calcIMATWEIGHTSTK
I_MATLDOCYEAROFSTINTRANSITValues for Material Document YearIMATLDOCYEARSIT
I_MATLOVRDPREDICTEDDELIVDTEMaterial Overdue Predicted Delivery DateIMATOVRDPRDELDTE
I_MATLOVRDSTINTRPREDICTEDDTEInter View for Predicted Date in Material Overdue SITIMATOVRDSITPD
I_MATLSTKATKEYDATEINALTUOMStock At Key Date In Alternative UoMIMATSTKDATEAUOM
I_READDOMAINFIXEDVALUESRead Domain Fixed ValuesIREADDOMFIXVALUE
I_STOCKCHANGECATEGORYStock Change CategoryISTOCKCHGCAT
I_STOCKCHANGECATEGORYTStock Change Category TextISTOCKCHGCATT
I_STOCKQUANTITYCURRENTVALUECurrent Stock Quantity and ValueISTOCKQUANVALCUR
I_STOCKQUANTITYVALUEBYTYPEStock Quantity and Value by TypeISTOCKVALBYTYPE
I_STOCKQUANTITYVALUETIMESERIESStock Quantity and Value time seriesISTOCKQUANVALTS
P_CURRENTMATLPRICEBYCOSTESTCurrent material price by cost estimatePCURRMATPRICE
P_GETLASTPOSTINGDATEGet last Posting Date of Material DocumentsPGETLASTPOSTDATE
P_GOODSMOVEMENTCODEGoods Movement CodePGDSMOVEMENTCODE
P_INVTRYTURNOVERANLYSVALUESCalculate Turnover ValuePINVTRYTOANAVAL
P_INVTRYTURNOVERAVGSTKVALSInventory Turnover Average Stock ValuesPINVTRYAVGSTV
P_INVTRYTURNOVERAVGSTOCKAverage Stock per DayPINVTRYTOAVRGST
P_INVTRYTURNOVERMATLSTKBYDATECalculate the stock level for date paramPINVTOSTKBYDATE
P_INVTRYTURNOVERPRFRDSUPPLIERPreferred Supplier dataPINVTOPRFSUPLR
P_INVTRYTURNOVERPRICINGInventory Turnover PricingPINVTRNOVRPRICE
P_INVTRYTURNOVERSTOCKInventory Turnover Stock CalculationPINVTOSTOCK
P_INVTRYTURNOVERSTOCKPERDAYInventory Turnover Stock CalculationPINVTOSTOCKPD
P_INVTRYTURNOVERSUPLRQTYVARCApp specific aggr of C_QuantityVariancePINVTOSUPLQTYVAR
P_INVTRYTURNOVERSUPLRTIMEVARCApp specific aggr of C_TimeVariancePINVTOSUPLTIMVAR
P_INVTRYTURNOVERSUPPLIERQTYDelivered qty per supplr, matl, plant, and periodPINVTRYTODELQTY
P_INVTRYTURNOVERTIMESERSINTMDTunover Time Series IntermediatePINVTOTIMSERINTM
P_INVTRYTURNOVERTMESERSAGGRGNInventory Turnover Time Series AggrPINVTOTIMSERAGGR
P_INVTRYTURNOVERTMESERSVALNInventory Turnover Time Series ValuationPINVTOTIMSERVALN
P_INVTRYTURNOVERVALUATIONInventory Turnover ValuationPINVTOVAL
P_MATERIALOVERDUESITPREDBASICBasic View of Prediction ModelPMATOVERDUESITPB
P_MATERIALOVERDUESITPREDCALCPrediction calculationPMATOVERDUESITCA
P_MATERIALOVERDUESITPREDCONVConversionPMATOVERDUESITPC
P_MATERIALOVERDUESITPREDICTDATPrediction Model of Overdue SIT to be consumed by FrameworkPMATOVERDUESITDT
P_MATERIALOVERDUESITPREDICTIONPrediction Model of Overdue SIT to be consumed by FrameworkPMATOVERDUESITPD
P_MATERIALOVERDUESITPREDREResult of Table FunctionPMATOVERDUESITPR
P_MATERIALSTOCKBYKEYDATE1Calculate the stock level before date (paramenter)PMATSTKBKDATE1
P_MATERIALSTOCKFYVARIANTDetermine all used fiscal year variantsPMATSTOCKFYVAR
P_MATERIALSTOCKPERIODSPeriods for all possible period typesPMATSTOCKPERIODS
P_MATERIALSTOCKROC1Range of Coverage - Derive Date from posting datePMATSTOCKROC1
P_MATERIALSTOCKROC2Range of Coverage - Determine consumption for required daysPMATSTOCKROC2
P_MATERIALSTOCKTIMESERIESDetermine material stock for the periods of period typePMATSTOCKTIMESER
P_MATERIALSTOCKTIMESERIES1Combine stock from start date with following periodsPMATSTCKTIMESER1
P_MATLDOCBYINVTRYTIMESERIESKEYMATDOC keys for inventory time seriesPMATBINVTMSERK
P_MATLSTKATKEYDATEINALTUOMStock at Key Date in Alternative UoMPMATSTKDATEAUOM
P_MATLSTKATKEYDATEINALTUOM1Stock at Key Date in Alternative UoMPMATSTKDATEAUOM1
P_MATSTKQTYVALCUR1Current Stock Quantity and ValuePMATSTKQTYVALCU1
P_MATSTKQTYVALCUR2Current Stock Quantity and ValuePMATSTKQTYVALCU2
P_MATSTKQTYVALCUR3Current Stock Quantity and ValuePMATSTKQTYVALCU3
P_MATSTKQTYVALOVP1Material Stock Quantiy and Value OVP1PMATSTKQTYVALOP1
P_MATSTKQTYVALOVP2Stock Quantity and Value by Type OVP2PMATSTKQTYVALOP2
P_MATSTKQTYVALOVP3Stock Quantity and Value by TypePMATSTKQTYVALOP3
P_PERIODTYPEVHPeriod Type Value HelpPPERIODTYPEVH
P_STKVALUEBYTYPE1'Stock value by type level 1PSTCKVALTYP1
P_STKVALUEBYTYPE2Stock value by type level 2PSTCKVALTYP2
P_STKVALUEBYTYPE3Stock value by type level 3PSTCKVALTYP3
P_STKVALUEBYTYPE4Stock value by type level 4PSTCKVALTYP4
P_STOCKQUANTITYVALUETS1Stock Quantity and Value time seriesPSTOCKQUANVALTS1
P_STOCKQUANTITYVALUETS2Stock Quantity and Value time seriesPSTOCKQUANVALTS2
P_SUPPLIERBYMATERIALPLANTGet all Supplier of material + plantPSUPPMATPLANT