CDS Views for Predictive MRP Engine (PP-PMR-ENG)

CDS View NameDescriptionSQL View Name
DDL_PMRP_PROD_RELProduct Relations via SoSPMRPPRODREL
DDL_PMRP_SOS_FLATSoS with output and all inputs and low level codePMRPSOSFLAT
I_PMRPBUCKETA bucket in pMRPIPMRPBUCKET
I_PMRPBUCKETASSIGNMENTAssignment of a day to a time bucketIPMRPBUCKETASGN
I_PMRPBUCKETCATEGORYBucket CategoryIPMRPBUCKCAT
I_PMRPBUCKETCATEGORYTEXTText of a Bucket CategoryIPMRPBUCKCATT
I_PMRPFACTORYCALENDARA factory calendar in pMRPIPMRPFCAL
I_PMRPISSUEBYCAUSEIssue by Cause in pMRPIPMRPISSUEBYCSE
I_PMRPISSUEBYCAUSEAFFCDBUCKETSAffcd buckets of issue by cause in pMRPIPMRPISSUEBYCSEB
I_PMRPISSUECATEGORYIssue CategoryIPMRPISSUECAT
I_PMRPISSUECATEGORYTEXTText of an Issue CategoryIPMRPISSUECATT
I_PMRPPRODUCTA product used in pMRPIPMRPPROD
I_PMRPRECEIPTReceipt used in pMRPIPMRPRECEIPT
I_PMRPRECEIPTBASICReceipt used in pMRPIPMRPRECEIPTB
I_PMRPRECEIPTISSUEReceipt Issue in pMRPIPMRPRCPTISSUE
I_PMRPRECEIPTITEMReceipt Item used in pMRPIPMRPRECEIPTITEM
I_PMRPRECEIPTITEMTPReceipt Item used in pMRPIPMRPRCPTITEMTP
I_PMRPRECEIPTKPIKPIs of a Receipt used in pMRPIPMRPRECEIPTKPI
I_PMRPRECEIPTTPReceipt used in pMRPIPMRPRECEIPTTP
I_PMRPREFERENCEPLANA Reference Plan in predictive MRPIPMRPREFPLAN
I_PMRPREFERENCEPLANTEXTDescription of a Reference PlanIPMRPREFPLANT
I_PMRPREQUIREMENTRequirement used in pMRPIPMRPRQMT
I_PMRPREQUIREMENTBASICRequirement used in pMRPIPMRPRQMTB
I_PMRPREQUIREMENTKPIKPIs of a Requirement used in pMRPIPMRPRQMTKPI
I_PMRPRESOURCEA Resource used in pMRPIPMRPRES
I_PMRPRESOURCECAPACITYResource Capacity used in pMRPIPMRPRESCAP
I_PMRPRSCEDISREGARDISSUERSNDisregard Resource Issue ReasonIPMRPRESRSN
I_PMRPRSCEDISREGARDISSUERSNTXTText of Disregard Resource Issue ReasonIPMRPRESRSNT
I_PMRPSIMLNCAPACITYBUCKETISSUENumber of overload issues in a bucketIPMRPSIMRCAPBISS
I_PMRPSIMLNCAPACITYRQMTpMRP capacity requirementIPMRPSIMCAPRQMT
I_PMRPSIMLNCAPACITYRQMTBASICpMRP capacity requirementIPMRPSIMCAPRQMTB
I_PMRPSIMLNCAPACITYUTILIZATIONpMRP Capacity UtilizationIPMRPSIMCAPUT
I_PMRPSIMLNCAPUTILIZATIONTPpMRP Capacity Utilization TP viewIPMRPSIMCAPUTTP
I_PMRPSIMLNCHANGEHISTORYpMRP Change HistoryIPMRPSIMCHGH
I_PMRPSIMLNFLXBLCONSTRAINTKPIKPIs of a Flexible ConstraintIPMRPSFLXTKPI
I_PMRPSIMLNOUTPQTYBYPRODUCTOutput of a product per bucketIPMRPOUTPPROD
I_PMRPSIMLNOUTPQTYBYSUPPLYOutput of a product per bucket by SupplyIPMRPOUTPSUPP
I_PMRPSIMLNOUTPQTYBYTOPLVLDMNDOutput of a product per top level demandIPMRPOUTPTLD
I_PMRPSIMLNRECEIPTBUCKETBASICReceipt used in pMRP distributedIPMRPRECEIPTBCK
I_PMRPSIMLNRESOURCEBUCKETISSUEOverload of a pMRP Resource per bucketIPMRPRESISSUE
I_PMRPSIMLNRSCEBUCKETCAPRQMTCapacity Demand of Receipt on a ResourceIPMRPSIMRCAPBRQ
I_PMRPSIMLNRSCECAPBUCKETpMRP Resource bucket capacityIPMRPSIMRCAPBUCK
I_PMRPSIMLNRSCECAPRQMTISSUECapacity Rqmts contributing to IssueIPMRPCAPISSUE
I_PMRPSIMLNRSCEDELTACAPRECEIPTpMRP Resource capacity delta ReceiptIPMRPRESCAPRPT
I_PMRPSIMLNTOPLEVELDEMANDTop Level Demand in pMRPIPMRPSIMTLD
I_PMRPSIMLNTOPLEVELDEMANDBASICTop Level Demand in pMRPIPMRPSIMTLDBASIC
I_PMRPSIMLNTOPLEVELDEMANDKPIKPIs of Top Level Demand in pMRPIPMRPSIMTLDKPI
I_PMRPSIMLNTOPLEVELDEMANDTPTop Level Demand in pMRP TP viewIPMRPSIMTLDTP
I_PMRPSIMULATIONA Simulation in predictive MRPIPMRPSIM
I_PMRPSIMULATIONRESOURCEResource in pMRP SimulationIPMRPSIMRES
I_PMRPSIMULATIONRESOURCETPResource in pMRP Simulation TP viewIPMRPSIMRESTP
I_PMRPSIMULATIONSTATUSStatus of a pMRP SimulationIPMRPSIMSTAT
I_PMRPSIMULATIONSTATUSTEXTText of a Status of a pMRP SimulationIPMRPSIMSTATT
I_PMRPSIMULATIONTEXTDescription of a Simulation PlanIPMRPSIMT
I_PMRPSIMULATIONTEXTTPTP View for Simulation DescriptionIPMRPSIMTTP
I_PMRPSIMULATIONTPSimulation in predictive MRP TP ViewIPMRPSIMTP
I_PMRPSOURCEOFSUPCATEGORYTEXTText of a Source of Supply CategoryIPMRPSOSCATTXT
I_PMRPSOURCEOFSUPPLYA Source Of Supply in Predictive MRPIPMRPSOS
I_PMRPSOURCEOFSUPPLYBASICA Source Of Supply in Predictive MRPIPMRPSOSBASIC
I_PMRPSOURCEOFSUPPLYCATEGORYSource Of Supply CategoryIPMRPSOSCAT
I_PMRPSOURCEOFSUPPLYDETAILSource Of Supply: Time-dependent PartIPMRPSOSDETL
I_PMRPSOURCEOFSUPPLYINPUTA Source Of Supply Input in pMRPIPMRPSOSI
I_PMRPTOPLEVELDEMANDISSUETop Level Demand Issue in pMRPIPMRPTLDISSUE
I_PMRPTOPLEVELDEMANDSLACKCalculate Slack for TLDIPMRPTLDSLACK
I_PMRPTOPLEVELDMNDRSCEBUCKETToplevel Demand contributing to ResourceIPMRPTLDRSCEB
I_PMRPTOPLEVELDMNDRSCECAPRQMTShare of Cap Demand of Top Level DemandIPMRPTLDRQMT
I_PMRPTOPLVLDMNDSLACKBYRSCECalculate Slack for TLD by Resource BucketIPMRPTLDSLKRSCE
I_PMRPTOPLVLPRODSLACKBYISSUESlack by Top Level Product in pMRPIPMRPTLPSLKISS
P_PMRPALTVSOSData needed to propose alternative SOSPPMRPALTVSOS
P_PMRPCAPREQFORTLDAggregate CAPREQs for TLDPPMRPCAPREQTLD
P_PMRPCAPREQSCALEScale Capreqs to TLDPPMRPCAPREQSCALE
P_PMRPISSUEBYCAUSEpMRP Issue ListPPMRPISSUEBYCSE
P_PMRPISSUEBYCAUSEAFFCDBUCKETSpMRP Issue ListPPMRPISSUEBYCSEB
P_PMRPISSUEBYCONSTRAINTpMRP Underdelivery Issue ImpactPISSUEBYCNSTRT
P_PMRPISSUEBYCONSTRAINT0pMRP Underdelivery Issue ImpactPISSUEBYCNSTRT0
P_PMRPISSUEBYCONSTRAINT1pMRP Underdelivery Issue ImpactPISSUEBYCNSTRT1
P_PMRPISSUEBYCONSTRAINT2pMRP Underdelivery Issue ImpactPISSUEBYCNSTRT2
P_PMRPISSUEBYCONSTRAINT3pMRP Underdelivery Issue ImpactPISSUEBYCNSTRT3
P_PMRPISSUEBYCONSTRAINT4pMRP Underdelivery Issue ImpactPISSUEBYCNSTRT4
P_PMRPISSUEBYCONSTRAINT5pMRP Underdelivery Issue ImpactPISSUEBYCNSTRT5
P_PMRPISSUEBYNOSOSpMRP No Source Of Supply Issue ImpactPNOSOSISSCAUSE
P_PMRPISSUEBYNOSOS1pMRP No Source Of Supply Issue ImpactPNOSOSISSCAUSE1
P_PMRPISSUEBYNOSOSBUCKETSpMRP No Source Of Supply Issue ImpactPNOSOSISSCAUSEB
P_PMRPISSUEBYPRODUCTUNDERDLVpMRP Underdelivery Issue ImpactPUNDDLVISSCAUSE
P_PMRPISSUEBYRESOURCEpMRP Resource Overload Issue ImpactPRESISSCAUSE
P_PMRPISSUEBYRESOURCE1pMRP Resource Overload Issue ImpactPRESISSCAUSE1
P_PMRPISSUEBYRESOURCE2pMRP Resource Overload Issue ImpactPRESISSCAUSE2
P_PMRPISSUEBYRESOURCE3pMRP Resource Overload Issue ImpactPRESISSCAUSE3
P_PMRPISSUEBYRESOURCE4pMRP Resource Overload Issue ImpactPRESISSCAUSE4
P_PMRPISSUEBYUNDERDELIVERYpMRP Underdelivery Issue ImpactPUNDDLVISSCS
P_PMRPOUTPQTYBYBUCKETCONSTRQuantities by Bucket for ConstraintsPMRPBUCKETC
P_PMRPOUTPQTYBYBUCKETPRDCTKPIQuantities by Bucket and Product with ConstraintsPMRPBUCKETPRDKPI
P_PMRPOUTPQTYBYBUCKETPRDSUPKPIQuantities by Bucket, Product and SGroup for ConstraintPMRPBUCKSUPPRDK
P_PMRPOUTPQTYBYBUCKETPRDSUPPLYQuantities by Bucket, Product and Supply GroupPMRPBUCKETPRDSUP
P_PMRPOUTPQTYBYBUCKETPRODUCTQuantities by Bucket and ProductPMRPBUCKETPRD
P_PMRPOUTPQTYBYBUCKETSOSQuantities by Bucket and SoSPMRPBUCKETSOS
P_PMRPOUTPQTYBYBUCKETSUPPLYQuantities by Bucket, Product and Supply GroupPMRPBUCKETSUP
P_PMRPOUTPQTYBYBUCKETSUPPLYKPIQuantities by Bucket, Product and SGroup for ConstraintPMRPBUCKETSUPKPI
P_PMRPPRODNOSOSMISSINGQTY1pMRP Top Level Product missing quantity due to no SOSPPRODNOSOSMQ1
P_PMRPPRODNOSOSMISSINGQUANTITYpMRP Top Level Product missing quantity due to no SOSPPRODNOSOSMQ
P_PMRPPRODUCTUNDERDELIVERYpMRP Underdelivery Issue ImpactPPRODUNDERDLV
P_PMRPPRODUCTUNDERDELIVERY1pMRP Underdelivery Issue ImpactPPRODUNDERDLV1
P_PMRPRECEIPTISSUEpMRP Issue related to some receiptPPMRPRCPTISSUE
P_PMRPRECEIPTISSUECAPACITYCapacity/NSOS/NORD KPI of a Receipt used in pMRPPPMRPRCPTKPICA
P_PMRPRECEIPTISSUEFLXBLCSTR1pMRP Receipt Flexible Constraint IssuePPMRPRCPTISSFC1
P_PMRPRECEIPTISSUEFLXBLCSTR2pMRP Receipt Flexible Constraint IssuePPMRPRCPTISSFC2
P_PMRPRECEIPTISSUEFLXBLCSTRTpMRP Receipt Flexible Constraint IssuePPMRPRCPTISSFCS
P_PMRPRECEIPTSOSNumber of Sos per ReceiptPPMRPRECEIPTSOS
P_PMRPRECEIPTWITHISSUEReceipt with issue no SOSPPMRPRECEIPTWI
P_PMRPREQUIREMENTRequirements including TLD used in pMRPPPMRPRQMT
P_PMRPSIMLNOUTPQTYBYPRODUCT1Receipts aggregated by bucketPPMRSMOSUPP1
P_PMRPSIMLNOUTPQTYBYSUPPLY1Output of a product per bucket by SupplyPPMRPOUTPSUPP1
P_PMRPSIMLNOUTPQTYBYTOPLVLDMN1Output of a product per top level demandPPMRPOUTPTLD1
P_PMRPSIMLNRECEIPTCONSTRAINT1Receipts enriched per Bucket with ConstraintPPMRSMORCPTC1
P_PMRPSIMLNRESAVAILCAPABUCKETpMRP Resource bucket capacityPPMRPESAVAICAP
P_PMRPSIMLNRESAVAILCAPABUCKET1pMRP Resource bucket capacityPPMRPESAVAICAP1
P_PMRPSIMLNRESCAPABUCKETRQMTA Resource used in pMRPPPMRPSIMRESCAPRQ
P_PMRPSIMLNRESCAPABUCKETRQMT1pMRP Resource capacity requirementPPMRPSIMRESCAPR1
P_PMRPSIMLNRESCAPBCKTRQMTRCPT1pMRP Resource capacity requirement ReceiptPPMRPRESCAPRCPT1
P_PMRPSIMLNRESCAPBCKTRQMTTLDpMRP Resource capacity requirement TLDPPMRPRESCAPTLD
P_PMRPSIMLNRSCECAPBCKTOVRLDDRGpMRP Resource bucket capacityPPMRPSIMRCAPBTOD
P_PMRPSIMLNRSCECAPBUCKETpMRP Resource bucket capacityPPMRPSIMRCAPBUCK
P_PMRPSIMLNRSCEGROUPpMRP resource group bucketsPMRPSIMRSCGRP
P_PMRPSIMLNRSCEGROUP1pMRP resource group bucketsPMRPSIMRSCGRPBC1
P_PMRPSIMLNRSCEGROUPBUCKETpMRP resource group bucketsPMRPSIMRSCGRPBCK
P_PMRPSIMLNRSCEGROUPBUCKETRELpMRP resource group buckets relationPMRPSIMRSCEGRPBR
P_PMRPSIMLNRSCEGRPBUCKETAGGRELpMRP aggregated resource group hierarchy relationsPMRPSIMRSCGRPABR
P_PMRPSIMLNTOPLVLDMNDCONSTTop Level Demand enriched per Bucket with ConstraintPPMRSMTLDC
P_PMRPSIMLNTOPLVLDMNDCONST1Top Level Demand enriched per Bucket with ConstraintPPMRSMTLDC1
P_PMRPTOPLEVELDEMANDCAPISSUEpMRP Capacity Issue for TLDPPMRPTLDCAPISS
P_PMRPTOPLEVELDEMANDCONSTRISSpMRP Flexible Constraint Issue for TLDPPMRPTLDCSTISS
P_PMRPTOPLEVELDEMANDDELTApMRP Quantities for TLDPPMRPTLDCAPDELTA
P_PMRPTOPLEVELDEMANDISSUEpMRP Issues related to a top level demandPPMRPTLDISSUE
P_PMRPTOPLEVELDEMANDNOCONSTRTLD with Receipts that have no constraintsPPMRPTLDNOCON
P_PMRPTOPLEVELDEMANDSLACKCalculate Slack for TLDPPMRPTLDSLACK
P_PMRPTOPLEVELDEMANDSOSISSUEpMRP Sos Issue for TLDPPMRPTLDSOSISS
P_PMRPTOPLEVELDEMANDSOSISSUE1pMRP Sos Issue for TLD PreparePPMRPTLDSOSISS1
P_PMRPTOPLVLDMNDSLACKBYCONSTRCalculate Slack for TLD by Flexible ConstraintPPMRPTLDSLKFLX
P_PMRPTOPLVLDMNDSLACKBYCONSTR1Calculate Slack for TLD by Flexible ConstraintPPMRPTLDSLKFLX1
P_PMRPTOPLVLDMNDSLACKBYRSCECalculate Slack for TLD by Resource BucketPPMRPTLDSLKRSCE
P_PMRPTOPLVLPRODSLACKBYCONSTRCalculate Slack for Top Level Product by Flexible ConstraintPPMRPTLPSLKCNSTR
P_PMRPTOPLVLPRODSLACKBYCONSTR0Calculate Slack for Top Level Product by Flexible ConstraintPPMRPTLPSLKCNST0
P_PMRPTOPLVLPRODSLACKBYCONSTR1Calculate Slack for Top Level Product by Flexible ConstraintPPMRPTLPSLKCNST1
P_PMRPTOPLVLPRODSLACKBYCONSTR2Calculate Slack for Top Level Product by Flexible ConstraintPPMRPTLPSLKCNST2
P_PMRPTOPLVLPRODSLACKBYISSUECalculate Slack for Top Level Product by IssuePPMRPTLPSLKISS
P_PMRPTOPLVLPRODSLACKBYNOSOSCalculate Slack for Top Level Product by NoSOSPPMRPTLPSLKNOSOS
P_PMRPTOPLVLPRODSLACKBYRSCECalculate Slack for Top Level Product by ResourcePPMRPTLPSLKRSCE
P_PMRPTOPLVLPRODSLACKBYRSCE0Calculate Slack for Top Level Product by ResourcePPMRPTLPSLKRSCE0
P_PMRPTOPLVLPRODSLACKBYRSCE1Calculate Slack for Top Level Product by ResourcePPMRPTLPSLKRSCE1
P_PMRPTOPLVLPRODSLACKBYRSCE2Calculate Slack for Top Level Product by ResourcePPMRPTLPSLKRSCE2
P_PMRPTOPLVLPRODSLACKBYUNDRDLVCalculate Slack for Top Level Product by UnderDeliveryPPMRPTLPSLKUNDD