CDS Views for Basis (PP-DD-BLM-BAS)

CDS View NameDescriptionSQL View Name
C_DEMANDDRIVENMASSPRODVHDemand Driven Product Value HelpCDDPRDVALHELP
C_DEMANDDRIVENPRODGROUPVHDemand Driven Product Group Value HelpCDDPRODGRPVH
C_DEMANDDRIVENPRODUCTTPMass Maintenance of Products (DD)CDDMASSPRODTP
C_MATBOMUSAGEMODEVALHELPBOM Usage Mode Value HelpCBOMUSGMODEVH
C_MATCONSUMPTIONMODEVALHELPConsumption Mode Value HelpCCONMODEVH
C_MATLEADTIMEMODEVALHELPLead Time Mode Value HelpCLEADTIMEMODEVH
C_MATVARIABILITYMODEVALHELPVariability Mode Value HelpCVARMODEVH
I_AVERAGEDAILYUSAGEMODEDemand-Driven Replenishment Average Daily Usage ModeIPRPSLADUMODE
I_AVERAGEDAILYUSAGEMODETEXTDemand-Driven Replenishment Average Daily Usage Mode TextIPRPSLADUMODET
I_BOMUSAGEDemand Driven View for BOM UsageIDDBOMUSAGE
I_BOMUSAGEMODEDemand Driven View for BOM Usage ModeIDDBOMUSAGEMODE
I_BOMUSAGEMODETEXTDemand Driven BOM Usage Mode DescriptionIDDBOMUSAGEMODT
I_BOMUSAGETEXTDemand Driven BOM Usage DescriptionIDDBOMUSAGETEXT
I_BUFFERPROFILEDemand-Driven Replnmt Buffer PrflIDDBUFPRFL
I_BUFFERPROFILEDETSDemand-Driven Replnmt Buffer Prfl DetsIDDBUFPRFLDETS
I_BUFFERPROFILEDETSTEXTDemand-Driven Replnmt Buffer Prfl Dets TextIDDPRFLDETSTEXT
I_BUFFERPROFILETEXTDemand-Driven Replnmt Buffer Prfl DescIDDBUFPRFLTXT
I_CHANGEMODEDemand Driven View for Change ModeIDDCHANGEMODE
I_CHANGEMODETEXTDemand Driven Change Mode DescriptionIDDCHANGEMODETXT
I_CONSUMPTIONCODEDemand Driven View for Consumption CodeICONSUMPTIONCODE
I_CONSUMPTIONMODEDemand Driven View for Consumption ModeICONSUMPTIONMODE
I_CONSUMPTIONMODETEXTDemand Driven Consumption Mode DescriptionICONSUMPTIONMODT
I_CONSUMPTIONTEXTDemand Driven Consumption DescriptionICONSUMPTIONTEXT
I_DDPLNDINDEPRQMTITEMHISTORYHistory of planned independent itemsIDDPIRHIST
I_DEMANDDRIVENEXTDPRODUCTDemand Driven Extended Product DetailsIDDEXTPRODUCT
I_DEMANDDRIVENMATERIALDATAData related to materialsIDDMATDATA
I_DEMANDDRIVENPROCUREMENTTYPEDemand Driven View for Procurement TypeIDDPROCMTTYPE
I_DEMANDDRIVENPRODUCTDemand Driven Extended Product DetailsIDDPRODUCT
I_DEMANDDRIVENPRODUCTTPTP View for Demand Driven Extended Prod DetailsIDDPRODUCTTP
I_DEMANDDRIVENPURDOCHEADERDemand Driven Purchasing Document HeaderIPURDOCHED
I_DEMANDDRIVENPURDOCITEMDemand Driven Purchasing Document ItemIPURDOCITEM
I_DEMANDDRIVENSOSTYPEDemand Driven SOS TypeIDDSOSTYPE
I_LEADTIMECALCULATIONMETHODDemand-Driven Replenishment Lead Time Calc. MethodIDDLTCALC
I_LEADTIMECALCULATIONMETHODTXTDemand-Driven Replenishment Lead Time Calc. Method Desc.IDDLTCALCTXT
I_MATERIALAVERAGEDAILYUSAGEMaterial Average Daily UsageIMATADU
I_MATLAVGDAILYUSGE1Material Average Daily UsageIMATADU1
I_MATLAVGDAILYUSGE2Material Average Daily UsageIMATADU2
I_MATLAVGDAILYUSGE3Material Average Daily UsageIMATADU3
I_MINORDQTYCONSIDEREDSTATUSDemand Driven View for MinOrdQty StatusIDDMOQCONSTATUS
I_MINORDQTYCONSIDEREDTEXTDemand Driven MOQ DescriptionIDDMOQCONTXT
I_ONHANDSTOCKSTATUSCODEDemand Driven On-Hand Stock Status CodeIONHANDSTKSTS
I_ONHANDSTOCKSTATUSTEXTDemand Driven On-Hand Stock Status DescriptionIONHANDSTKSTSTXT
I_PROCUREMENTTYPETEXTDemand Driven Procurement Type DescIDDPROCMTTYPETXT
I_PRODAVGDAILYUSGETIMESERIESTime Series Avg Daily UsageITIMESERIESADU
I_PRODBUFLVLPRPSLProduct Buffer Level ProposalsIPRODBUFLVLPRPSL
I_PRODBUFLVLPRPSLDATAProduct Buffer Level Proposal DataIPRODBUFPRPSLHDR
I_PRODBUFLVLPRPSLDEMANDProduct Buffer Level Proposal DemandIPRODBUFPRPSLDMD
I_PRODBUFLVLPRPSLDEMANDFCTRBuffer Proposal Demand Adjustment FactorsIPRODBUFPRPSDADJ
I_PRODBUFLVLPRPSLDMNDFCTRBASICBuffer Proposal Demand Adjustment Factors BasicIPRODBUFDADJB
I_PRODBUFLVLPRPSLDMNDTPTransactional View for Product Buffer Proposal DemandIPRODBUFPSLDMDTP
I_PRODBUFLVLPRPSLTPProduct Buffer Level Proposal TPIPRODBUFPRPSLTP
I_PRODBUFLVLPRPSLZNADJMTFCTRProduct Buffer Level Proposal Zone Adjustment FactorsIPRODBUFPRPSLADJ
I_PRODBUFLVLPRPSLZNADJMTFCTRTPTransactional View for Product Buffer Proposal Adj FactorsIPRDBUFPRPSLADJF
I_PRODBUFLVLPRPSLZONESProduct Buffer Level Proposal ZonesIBUFLVLPRPSLZN
I_PRODDAILYDEMANDCHARTProduct Daily Demand ChartIDDPRODADUCHART
I_PRODDAILYDEMANDCHARTTPTransactional View for Demand ChartIDEMANDCHARTTP
I_PRODPLNGACTIONSTATUSCODEDemand Driven Product Planning Action Status CodeIPLNGACTNSTSCODE
I_PRODPLNGACTIONSTATUSTEXTDemand Driven Product Planning Action Status DescriptionIPLNGACTNSTSTXT
I_PRODPLNGPRIOSTATUSCODEDemand Driven Product Planning Priority Status CodeIPLNGPRIOSTSCODE
I_PRODPLNGPRIOSTATUSTEXTDemand Driven Product Planning Priority Status DescriptionIPLNGPRIOSTSTXT
I_PRODUCTBUFFERLEVELCHARTProduct Buffer Level ChartIDDPRODBUFCHART
I_PRODUCTSTOCKREQUIREMENTLISTProduct Stock Requirement DetailIPRODSTKREQ
I_PROFILEASSGMTTOPLANTDemand-Driven Buf Prfl Assgmt to PlntIPRFLASSGMTPLNT
I_PROPOSALMODEDemand Driven View for Proposal ModeIPROPOSALMODE
I_PROPOSALMODETEXTDemand Driven View for Proposal Mode DescIPROPOSALMODT
I_PROPOSALSTATUSDemand Driven View for Proposal StatusIDDPRPSLSTATUS
I_PROPOSALSTATUSTEXTDemand Driven Proposal Status DescIDDPRPSLSTSTXT
I_REPLENISHMENTLEADTIMECODEDemand Driven Replnmt Time CodeIDDLEADTIMECODE
I_REPLENISHMENTLEADTIMEMODEDemand Driven Replnmt Time ModeIDDLEADTIMEMODE
I_REPLENISHMENTLEADTIMEMODTEXTDemand Driven Replnmt Time Mode DescIDDLEADTIMEMODT
I_REPLENISHMENTLEADTIMETEXTDemand Driven Replnmt Time DescriptionIDDLEADTIMETXT
I_SOSTYPETEXTDemand Driven SOS Type DescriptionIDDSOSTYPETEXT
I_STOCKLEVELPROPOSALDemand Driven Proposed Stock LevelsIDDSTKLVLPRPSL
I_STOCKLEVELPROPOSALTPTransactional View for DD Proposed Stock LevelsIDDSTKLVLPRPSLTP
I_STOCKLEVELPROPOSALZONESDemand Driven Stock Level Proposal ZonesIDDSTKLVLPRPSLZN
I_STOCKLEVELPRPSLBOMDemand Driven BOM Component Lead TimeIDDSTKLVLPRPLBOM
I_STOCKLEVELPRPSLDETSDemand Driven Stock Proposal DetailsIDDSTKPRPSLDETS
I_TIMEDEPENDENTSTOCKBUFFERDemand Driven Adopted Stock LevelsIDDTMDEPDNTSTBUF
I_TIMEDEPENDENTSTOCKBUFFERTPTransactional View for Demand Driven Adopted Stock LevelsIDDSTBUFTP
I_VARIABILITYCODEDemand Driven View for Variability CodeIVARIABILITYCODE
I_VARIABILITYMODEDemand Driven View for Variability ModeIVARIABILITYMODE
I_VARIABILITYMODETEXTDemand Driven Variability Mode DescriptionIVARIABILITYMODT
I_VARIABILITYTEXTDemand Driven Variability DescriptionIVARIABILITYTEXT
P_AVGDAILYUSGEHRZNFORCALDTEP viewPHORIZFOREACHDTE
P_BUFFEREDPRODCHARTDSPHRZNP view to fetch horizon detailsPBUFRPRODDSPHRZ
P_BUFPRODCHARTDSPHORIZONCALCCalculationPBUFCHTDSPHRZN
P_CALENDARDAYCalendar DayPDDCALDAY
P_CHARTHORIZONDemand Driven Chart HorizonPDDCALHRZ
P_COMBINEDLEADTIMEDemand Driven Product Combined Lead TimePCOMBINEDLT
P_DAILYPLNDINDEPREQMTHISTDAILY PIR HistPPIRDAILYHIST
P_DAILYPLNDINDEPRQMTPrivate view for everyday PIR maintanancePDAILYPIR
P_DAILYWEEKLYMNTHLYPIRP_DailyWeeklyMnthlyPIRPDAYWKMNTHPIR
P_DAILYWEEKLYMNTHLYPIRBYDATEP_DailyWeeklyMnthlyPIRByDatePDWMPIRBYDATE
P_DAILYWEEKLYMNTHLYPIRHISTP_DailyWeeklyMnthlyPIRHistPDYMNTHWKPIRHIST
P_DAILYWEEKLYMNTHLYPIRHISTDATEP_DailyWeeklyMnthlyPIRHistDatePDWMPIRHISTDTE
P_DDPRODUCTCALCFIELDSDD Product Calculated FieldsPDDPRDCF
P_DDPRODUCTHORIZCALCFIELDSDDProduct Horiz CalcPDDPRDHZCF
P_DEFAULTLEADTIMEPREDDefault Lead Time PredictionPLTPRED
P_DEMANDDRIVENORDERSDemand Driven Relevant OrdersPDDORDERS
P_DEMANDDRIVENPRODSLHORIZONDemand Driven Products HorizonPDDPRODSHORIZON
P_EXTRACTPOCURRENTMONTHPrivate View to extract STPO for current monthPSTPOCURRMONTH
P_EXTRACTPOCURRENTWEEKExtract STPO for current weekPSTPOCURRWEEK
P_EXTRACTPOCURRMONTHRECPLANTSTPO for current month at receiving plantPCURRMONTHRPM
P_EXTRACTPOCURRWEEKRECPLANTSTPO for current week at receiving plantPCURRWEEKRPM
P_EXTRACTPOPREVMONTHExtract STPO for previous monthPSTPOPREVMONTH
P_EXTRACTPOPREVMONTHRECPLANTSTPO for previous month at receiving plantPPREVMONTHRPM
P_EXTRACTPOPREVWEEKExtract STPO for previous weekPSTPOPREVWEEK
P_EXTRACTPOPREVWEEKRECPLANTSTPO for previous week at receiving plantPPREVWEEKRPM
P_FALLBACKTARGETSTOCKDemand-Driven Fall Back Target StkPFALLBACKTGTSTK
P_FORECASTDEMANDITEMHISTORYPrivate View for I_ForecastDemandItemHistoryPFCSTDMNDIHIST
P_GOODSISSUEDATAView for Goods Issue DataPGOODSISSDATA
P_GOODSRECEIPTDATAPrivate View for Goods Receipt DataPGOODSRECDATA
P_INDIV_LEADTIME_STO2_V01P_2A504CB20A77C2
P_INFORECORDLEADTIMEDemand Driven Product Lead Time InfoRecord SpecificPINFORECORDLT
P_LASTFALLBACKLEADTIMEDemand Driven Product Lead Time From Material MasterPDDLASTLT
P_MATERIALDEMANDFORECASTPrivate view for material demand forecastPMATLDMNDFCST
P_MATLAVGDAILYUSGECALHRZNDATESP view to get the ADU start and end datesPPDDADUHRZNDATES
P_MNTHLYPLNDINDEPRQMTHISTP_MnthlyPlndIndepRqmtHistPMNTHLYPIRHIST
P_MNTHLYPLNDINDEPRQMTHISTBYDTEP_MnthlyPlndIndepRqmtHistByDtePMNTHLYHISTBYDTE
P_MONTHLYPLNDINDEPRQMTFor monthly PIR maintainedPMONPIR
P_MONTHLYPLNDINDEPRQMTBYDATEMonthy Planned Independent Requirement By DatePMONTHLYBYDATE
P_MRPAREASTORLOCSUBCONTRACTORStorage Locations and Sub Contractors of MRP AreaPMRPSLSUBCON
P_PERDAYUSAGEDemand Driven Product Per Day UsagePPERDAYCNSMPN
P_PIRHISTBYLASTCHANGEDATETIMEPIR history by last change date timePPIRHISTBYDT
P_PLANTCURRENCYDemand Driven Plant Currency - ABC AnalysisPPLANTCRCY
P_PLNDINDEPRQMTITEMHISTPIR HistoryPPIRHIST
P_PLNDINDEPRQMTITEMHISTBYDATEP_PlndIndepRqmtItemHistByDatePPIRHISTBYDATE
P_PLNDINDEPRQMTITEMHISTORYPIR History P viewPPIRHIST0
P_PREDEXTRACTCALENDARPrivate View to extract calendar valuesPREDCAL
P_PRODBUFLVLPRPSLDEMANDFCTRDemand Factor Records for SDM MigrationPSDMDMDFCTR
P_PRODUCTBUFFERLEVELCHARTFUTRBufferl Level Chart for FuturePDDPRODBUFCHART
P_PRODUCTCOSTDemand Driven Product Cost - ABC AnalysisPPRODCOST
P_PRODUCTINDIVLEADTIMEDemand Driven Product Indiv Lead TimePDDINDIVLEADTIME
P_PRODUCTOVERDUESITMaterial Overdue SITPMATOVERDUE
P_PRODUCTOVERDUESITBASIC1Material Overdue SIT BasicPOVERDUESITBAS
P_PRODUCTOVERDUESITBASIC2Material Overdue SIT Basic 2POVERDUESITBAS2
P_PRODUCTOVERDUESITPREDICTMaterial Overdue SIT PredictionPOVERDUEPRED
P_PRODUCTOVERDUESITPREDICTCALCMaterial Overdue SIT Prediction CalcPOVERDUECALC
P_PRODUCTOVERDUESITPREDICTCONVMaterial Overdue SIT Prediction ConvPMATOVERDUEPC
P_PURCHASINGDOCUMENTITEMPurchasing Document ItemPPURDOCITEM
P_SCHEDAGRMTLEADTIMEDemand Driven Product Scheduling Agreement Lead TimePSCHEDAGRMTLT
P_SCHEDGAGRMTLEADTIMEMAINDemand Driven Product SchedgAgrmt Lead Time MainPDDAGRMTLTMAIN
P_SCHEDGAGRMTORDSDemand Driven Products Relevant SA DatasPSCHEDGAGRMTORDS
P_SCHEDGAGRMTORDSEXTDDemand Driven Product SchedgAgrmt Lead Time ExtdPSCHEDGORDSEXTD
P_SDM_DEMANDFCTRKey for SDM MigrationPSDMDMDKEY
P_SDM_DEMANDFCTRBASICKey for SDM MigrationPSDMDMDKEYB
P_STANDARDPURCHASEORDERSDemand Driven Product Purchase OrdersPSTDPURORDS
P_STOCKTRANSPORTORDERSDemand Driven Product's Stock Transport OrdersPSTKTRANORD
P_TIMEDEPENDENTSTOCKDemand-Driven Time Dependent StockPDDTMEDEPDNTSTK
P_TMESERSAVGDAILYUSGEHRZNCALCP view to get max ADU HorizonPADUDSPHRZN
P_TOTALAVGDAILYUSGEBYDATEP viewPTOTALADUFORHORZ
P_TOTALCONSUMPTIONDemand Driven Material Consumption Over the Horizon - ABCPTOTCONSUMP
P_UNITOFMEASUREUnit Of MeasurePUOM
P_WEEKLYPLNDINDEPRQMTWeekly RequirementPWEEKLYPIR
P_WEEKLYPLNDINDEPRQMTBYDATEWeekly Planned Independent Requirement By DatePWEEKLYPIRBYDATE
P_WEEKLYPLNDINDEPRQMTHISTWeekly PIR historyPWPIRHIST
P_WEEKLYPLNDINDEPRQMTHISTBYDTEWeekly PIR history by datePWPIRHISTBYDTE
R_PRODUCTTIMEDEPDNTSTOCKLVLTPTP view for Product time dependent stockRPTIMDEPSTKTP