CDS Views for Material Requirements Planning (IS-AD-MPN-MRP)

CDS View NameDescriptionSQL View Name
DIMPVAP_MA61V_DDLExtension view for Append DIMPVAP_MA61VDIMPVAP_MA61V_V
A_MRPMATERIALMaster DataIMRPMATERIAL
A_PLANNEDORDERPlanned OrderAPLNDORD
A_PLANNEDORDERCAPACITYPlanned Order CapacityAPLNDORDCAP
A_PLANNEDORDERCOMPONENTPlanned Order ComponentsAPLNDORDCOMP
A_PLNDINDEPRQMTPlanned Independent RequirementAPIR_H
A_PLNDINDEPRQMTITEMPlanned Independent Requirement ItemAPIR_IT
C_MRPISACCEPTEDINDICATORVHIs Accepted Value HelpCMRPIAIVH
C_MRPMASTERDATAISSUETPConsumption View for MRP IssuesCMRPMDISSUETP
FCDM_KEYFIGURES_READ_CUSTRQRead Customer Requirements for Forecast Demand KeyfiguresV_FCDM_RD_CR
FCDM_KEYFIGURES_READ_GIRead Goods IssuesV_FCDM_GI
FCDM_READ_ATTRIBUTESAll public Attributes of Forecast DemandV_FCDM_ATTR
I_DEPENDENTRQMTSTYPETEXTDependent Requirements Type TextIDPDTRQMTTYTXT
I_MATLCOMPDSCONTNTYPETEXTMaterial Comp Discontinuation Type TextIMATDISCTTYPETXT
I_MRPMASTERDATAISSUEMaster data related issue that occurred during an MRP runIMRPMDISSUE
I_MRPMASTERDATAISSUEBASICMaster data related issue that occurred during an MRP runIMRPMDISSUEBAS
I_MRPMASTERDATAISSUECATCategory of an MRP Master Data IssueIMRPMDISSCAT
I_MRPMASTERDATAISSUECATASSGMTAssignment of a Message to an IssueIMRPMDISSCATA
I_MRPMASTERDATAISSUECATTEXTText for a Category of an MRP Master Data IssueIMRPMDISSCATT
I_MRPMASTERDATAISSUESOURCESource of an MRP Master Data IssueIMRPMDI
I_MRPMASTERDATAISSUESOURCETEXTSource of an MRP Master Data Issue TextIMRPMDIT
I_MRPMASTERDATAISSUETPTransactional Processing for a MRP Master Data IssueIMRPMDISSUETP
I_MRPMATERIALMRP MaterialIMRPMATRL
I_PLNDINDEPRQMTPlanned Independent Requirement Basic ViewIPIR_H
I_PLNDINDEPRQMTITEMPlanned Independent Requirement ItemIPIR_IT
I_PLNDINDEPRQMTITEMBASICPlanned Independent Requirement Item Basic with internal keyIPIR_IT_BAS
I_PLNDINDEPRQMTITEMTPPlanned Independent Requirement Item Transactional ViewIPIRTP_IT
I_PLNDINDEPRQMTTPPlanned Independent Requirement Transactional ViewIPIRTP_H
PIR_ALL_ATTRIBUTESAll Attributes from PBED and PBED_DRAFTPIR_V_ALL_ATT
PIR_INACTIVE_EXISTSAll PIR HeadersPIR_V_INACT_EX
PIR_ITEM_CALC_ATTCalculated PIR Item attributesPIR_V_ITEM_ATT
PIR_ITEM_CALC_ATT1Calculated PIR Item Attributes 1PIR_V_ITEM_ATT1
PIR_ITEM_CALC_ATT_PERKZDetermine changed PERKZPIR_V_ITEM_ATT_P
PIR_ITEM_CALC_ATT_PERKZ1PeriodPIR_V_ITEM_ATT_Q
PIR_KEYFIGURES_READ_FOR_SUMdPIR_V_RD_SUM
PIR_READ_AOR_HEADSRead Header data in your area of responsibilityPIR_V_AOR_HEAD
PIR_UNION_HEADAll PIR HeadersPIR_V_UNION_HD
PIR_UNION_HEAD_ALLAll PIR HeadersPIR_V_UNIONA_HD
PPHMRP_ERROR_MATSMaterials with Errors from last MRPPPHMRP_ERR_MATS
PPHMRP_PERFLOG_HEADER_CONSConsumption View Performance Log HeaderPPHMRPPERFLOGH_C
PPHMRP_PERFLOG_ITEM_CONSConsumption View Performance Log ItemPPHMRPPERFLOGH_I
PPHMRP_PERFLOG_LLC_CONSConsumption View Performance Log LLCPPHMRPPERFLOGH_L
PPHMRP_PERFLOG_RUNSMRP Runs per MRP commentPPHMRPPERFLOGH_R
PPHMRP_PERF_LOG_HELP1Help View for PPHMRP_PERF_LOG_KEY_Figures: Max StarttimePPHMRP_PERF_LOG1
PPHMRP_PERF_LOG_HELP2Help View for PPHMRP_PERF_LOG_KEY_FIGURESPPHMRP_PERF_LOG2
PPHMRP_PERF_LOG_ITEM_KEY_FIGMRP Performance Log Key Figures per ItemPPHMRP_PERFLOG_I
PPHMRP_PERF_LOG_KEY_FIGURESMRP Performance Log Key FiguresPPHMRP_PERF_LOG
PPHMRP_PERF_LOG_LLC_KEY_FIGMRP Performance Log Key Figures per Low Level CodePPHMRP_PERFLOG_D
PPH_DDL_AFPOread AFPOV_PPH_AFPO
PPH_DDL_AFPO_1read AFPOV_PPH_AFPO_1
PPH_DDL_AFPO_PWread AFPO PWV_PPH_AFPO_PW
PPH_DDL_AFPO_PW_BAFPO_PW calculate BERIDV_PPH_AFPO_PW_B
PPH_DDL_AFPO_PW_PAFO_PW calculate PLAAB/PLANR/VRFKZV_PPH_AFPO_PW_P
PPH_DDL_AFPO_RGread AFPO RGV_PPH_AFPO_RG
PPH_DDL_AFPO_RG_BAFPO_RG calculate BERIDV_PPH_AFPO_RG_B
PPH_DDL_AFPO_RG_PAFPO_RG calculate PLAAB/PLANR/VRFKZV_PPH_AFPO_RG_P
PPH_DDL_DDMRP_NFP_AORDDMRP: Net Flow Position with AORV_PPH_NFP_AOR
PPH_DDL_DDMRP_PROJCTD_NFP_AORDDMRP: Projected Net Flow Position with AORV_PPH_P_NFP_AOR
PPH_DDL_DDMRP_PROJCTD_NFP_SELDDMRP: Projected Net Flow Position with MATNR/WERKS/BERIDV_PPH_P_NFP_SEL
PPH_DDL_DDMRP_PROJCTD_STCK_AORDDMRP: Projected stock with AORV_PPH_P_STK_AOR
PPH_DDL_DDMRP_PROJCTD_STCK_SELDDMRP: Projected stock with MATNR/WERKS/BERIDV_PPH_P_STK_SEL
PPH_DDL_EBANread EBANV_PPH_EBAN
PPH_DDL_EBAN_BEBAN calculate BERIDV_PPH_EBAN_B
PPH_DDL_EBAN_PEBAN calculate PLAAB/PLANR/VRFKZV_PPH_EBAN_P
PPH_DDL_EBAN_P1EBAN calculate PLAAB/PLANR/VRFKZV_PPH_EBAN_P1
PPH_DDL_EBKNread EBKNV_PPH_EBKN
PPH_DDL_EKKNread EKKNV_PPH_EKKN
PPH_DDL_MAT_CTRLRead Material Data for MRPV_PPH_MAT_CTRL
PPH_DDL_MAT_CTRL_0View for reading master dataV_PPH_MAT_CTRL_0
PPH_DDL_MAT_CTRL_1Read Material Data for MRPV_PPH_MAT_CTRL_1
PPH_DDL_MAT_CTRL_DDMaterial Data for DDMRPV_PPH_MAT_CTRLDD
PPH_DDL_MDBSread MDBSV_PPH_MDBS
PPH_DDL_MDBS_1read MDBSV_PPH_MDBS_1
PPH_DDL_MDBS_2read MDBSV_PPH_MDBS_2
PPH_DDL_MDBS_3read MDBSV_PPH_MDBS_3
PPH_DDL_MDBS_4read MDBSV_PPH_MDBS_4
PPH_DDL_MDBS_BMDBS calculate BERIDV_PPH_MDBS_B
PPH_DDL_MDBS_PMDBS calculate PLAAB/PLANR/VRFKZV_PPH_MDBS_P
PPH_DDL_MDBS_P1MDBS calculate PLAAB/PLANR/VRFKZV_PPH_MDBS_P1
PPH_DDL_MDBS_SLread MDBS zero schedule linesV_PPH_MDBS_SL
PPH_DDL_MDLAread MDLAV_PPH_MDLA
PPH_DDL_MDLA_1read MDLAV_PPH_MDLA_1
PPH_DDL_MDLA_BMDLA calculate BERIDV_PPH_MDLA_B
PPH_DDL_MDLA_PMDLA calculate PLAAB/PLANR/VRFKZV_PPH_MDLA_P
PPH_DDL_MDLA_P1MDLA calculate PLAAB/PLANR/VRFKZV_PPH_MDLA_P1
PPH_DDL_MDPBRead MDPBV_PPH_MDPB
PPH_DDL_MDPB_BMDPB calculate BERIDV_PPH_MDPB_B
PPH_DDL_MDPB_PMDPB calculate PLAAB/PLANR/VRFKZV_PPH_MDPB_P
PPH_DDL_MDQMread MDQMV_PPH_MDQM
PPH_DDL_MDQM_BMDQM calculate BERIDV_PPH_MDQM_B
PPH_DDL_MDQM_EWMread MDQMV_PPH_MDQM_EWM
PPH_DDL_MDQM_EWM_1read MDQMV_PPH_MDQM_EWM_1
PPH_DDL_MDQM_PMDQM calculate BERIDV_PPH_MDQM_P
PPH_DDL_MDRELAread MDRELAV_PPH_MDRELA
PPH_DDL_MDRELA_1read MDRELAV_PPH_MDRELA_1
PPH_DDL_MDRELA_BMDRELA calculate BERIDV_PPH_MDRELA_B
PPH_DDL_MDRELA_PMDRELA calculate PLAAB/PLANR/VRFKZV_PPH_MDRELA_P
PPH_DDL_MDUAread MDUAV_PPH_MDUA
PPH_DDL_MDUA_BMDUA calculate BERIDV_PPH_MDUA_B
PPH_DDL_MDUA_PMDUA calculate PLAAB/PLANR/VRFKZV_PPH_MDUA_P
PPH_DDL_MDUBread MDUBV_PPH_MDUB
PPH_DDL_MDUB_1read MDUBV_PPH_MDUB_1
PPH_DDL_MDUB_2read MDUBV_PPH_MDUB_2
PPH_DDL_MDUB_BMDUB calculate BERIDV_PPH_MDUB_B
PPH_DDL_MDUB_PMDUB calculate PLAAB/PLANR/VRFKZV_PPH_MDUB_P
PPH_DDL_MDURread MDURV_PPH_MDUR
PPH_DDL_MDUR_BMDUR calculate BERIDV_PPH_MDUR_B
PPH_DDL_MDUR_PMDUR calculate PLAAB/PLANR/VRFKZV_PPH_MDUR_P
PPH_DDL_MKALProduction Version as Source of SupplyV_PPH_MKAL
PPH_DDL_MRBEDread MRBEDV_PPH_MRBED
PPH_DDL_MRBED_1read MRBEDV_PPH_MRBED_1
PPH_DDL_MRBED_Pread MRBEDV_PPH_MRBED_P
PPH_DDL_PERFLOG_DISSTAggregated MRP Performance data per low level codeV_PPH_PF_DISST
PPH_DDL_PERFLOG_HEADERAggregated MRP Performance data per LogV_PPH_PF_HD_KF1
PPH_DDL_PERFLOG_ITEM_KFMRP Performance Key Figures per ItemV_PPH_PF_ITEM_KF
PPH_DDL_PERFLOG_ITEM_SUMAggregated MRP Performance Item dataV_PPH_PF_SUM_IT
PPH_DDL_PERFLOG_ITEM_SUM_1Aggregated MRP Performance Item dataV_PPH_PF_SUM_IT1
PPH_DDL_PERFLOG_ITEM_UNIONUnion of MRP and Postprocessing Performance Log ItemsV_PPH_PF_ITEM_UN
PPH_DDL_PERFLOG_KINDMRP Performance Key Figures per MRP kindV_PPH_PF_KIND_1
PPH_DDL_PERFLOG_PP_SUMPostprocessing Log Item InfoV_PPH_PF_PP_IT1
PPH_DDL_PERFLOG_PP_SUM_1Postprocessing Log Item InfoV_PPH_PF_PP_IT2
PPH_DDL_PLAF_PWread PLAF PWV_PPH_PLAF_PW
PPH_DDL_PLAF_RGread PLAF RGV_PPH_PLAF_RG
PPH_DDL_PLAF_RG_BPLAF_RG calculate BERIDV_PPH_PLAF_RG_B
PPH_DDL_PLAF_RG_PPLAF_RG calculate PLAAB/PLANR/VRFKZV_PPH_PLAF_RG_P
PPH_DDL_PLAF_ULread PLAF ULV_PPH_PLAF_UL
PPH_DDL_PLAF_UL_BPLAF_UL calculate BERIDV_PPH_PLAF_UL_B
PPH_DDL_PLAF_UL_PPLAF_UL calculate PLAAB/PLANR/VRFKZV_PPH_PLAF_UL_P
PPH_DDL_PO_TCX00Main scheduling parameters for planned order schedulingV_PPH_PO_TCX00
PPH_DDL_PROWread PROWV_PPH_PROW
PPH_DDL_PRUEFBESTQuality Inspection FlagV_PPH_PRUEFBST
PPH_DDL_QM_IL_EWMread QALS for external inspection lots of origin 17V_PPH_QM_IL_EWM
PPH_DDL_QM_IL_EWM_1read QALS for external inspection lots of origin 17V_PPH_QM_IL_EWM1
PPH_DDL_RESB_AGGread RESB AGGV_PPH_RESB_AGG
PPH_DDL_RESB_AGG_1read RESB AGGV_PPH_RESB_AGG_1
PPH_DDL_RESB_AGG_2read RESB AGGV_PPH_RESB_AGG_2
PPH_DDL_RESB_AGG_BRESB_AGG calculate BERIDV_PPH_RESB_AGG_B
PPH_DDL_RESB_AGG_PRESB_AGG calculate PLAAB/PLANR/VRFKZV_PPH_RESB_AGG_P
PPH_DDL_RESB_AGG_P1RESB_AGG calculate PLAAB/PLANR/VRFKZV_PPH_RESBAGG_P1
PPH_DDL_RESB_FLEXread RESB FLEXV_PPH_RESB_FLEX
PPH_DDL_RESB_FLEX_BRESB_FLEX calculate BERIDV_PPH_RESBFLEX_B
PPH_DDL_RESB_FLEX_PRESB_FLEX calculate PLAAB/PLANR/VRFKZV_PPH_RESBFLEX_P
PPH_DDL_RESB_FLEX_P1RESB_FLEX calculate PLAAB/PLANR/VRFKZV_PPH_RESBFLX_P1
PPH_DDL_STOCKread STOCK for MRPV_PPH_STOCK
PPH_DDL_STOCK_1read STOCK 1, DB access to MATDOC_EXTRACTV_PPH_STOCK_1
PPH_DDL_STOCK_2read STOCK 2V_PPH_STOCK_2
PPH_DDL_STOCK_3read STOCK 3V_PPH_STOCK_3
PPH_DDL_STOCK_4read STOCK 4V_PPH_STOCK_4
PPH_DDL_STOCK_KFread stock, round MNG01V_PPH_STOCK_KF
PPH_DDL_STOCK_KF_0read from stock account key figure viewV_PPH_STOCK_KF_0
PPH_DDL_STOCK_KF_1read from stock account key figure viewV_PPH_STOCK_KF_1
PPH_DDL_STOCK_KF_2read from stock_kf_1, determine MRP AreaV_PPH_STOCK_KF_2
PPH_DDL_STOCK_KF_3read from stock_kf_2, set MNG01V_PPH_STOCK_KF_3
PPH_DDL_STOCK_KF_4read stock, sum MNG01V_PPH_STOCK_KF_4
PPH_DDL_STOCK_KF_Zread stock, round MNG01, incl. zero stockV_PPH_STOCK_KF_Z
PPH_DDL_T460A_MAXGet SOBSL of kind stock transferV_PPH_T460A_MAX
PPH_DDL_T460A_MAX_BANFGet SOBSL of kind stock transferV_PPH_T460A_MAXB
PPH_DDL_VBBEread VBBEV_PPH_VBBE
PPH_DDL_VBBE_AGGread VBBE AGGV_PPH_VBBE_AGG
PPH_DDL_VBBE_AGG_1read VBBE AGGV_VBBE_AGG_1
PPH_DDL_VBBE_AGG_BVBBE_AGG calculate BERIDV_PPH_VBBE_AGG_B
PPH_DDL_VBBE_AGG_PVBBE_AGG calculate PLAAB/PLANR/VRFKZV_PPH_VBBE_AGG_P
PPH_DDL_VBBE_BVBBE calculate BERIDV_PPH_VBBE_B
PPH_DDL_VBBE_PVBBE calculate PLAAB/PLANR/VRFKZV_PPH_VBBE_P
PPH_DOMTEXTDomain textPPHDD07V
PPH_MRP_ACCPTD_SHORTAGE_EXISTSCDS view for existance of an accepted shortageV_MRP_ACCSHORTEX
PPH_MRP_AFPOFiori MRP App AFPO read and enhanceV_MRP_AFPO
PPH_MRP_AREASCDS View for MRP AreasV_PPH_MRP_AREAS
PPH_MRP_CHECK_BUFFERFiori MRP App Check Buffer CDS ViewV_MRP_CHECK_BUF
PPH_MRP_CTRLRMRP ControllerPPH_MRPCTRLR
PPH_MRP_CURRENCYFiori MRP App Currency CDS ViewV_MRP_CURRENCY
PPH_MRP_MATERIALSFiori MRP App Materials CDS ViewV_MRP_MATERIALS
PPH_MRP_MAT_VALMaterial ValuationV_PPH_MAT_VAL
PPH_MRP_MC_TOTALSTruck Load Optimizer Supply and Demand Item ViewV_MRP_MC_TOTALS
PPH_MRP_MFG_COMPManufacturing Orders Components CDS ViewV_MRP_MFG_COMPS
PPH_MRP_PLAN_PLANTFiori MRP App Planning Plant CDS ViewV_MRP_PLAN_PLANT
PPH_MRP_PLAN_SEGMENTSFiori MRP App Planning Segments CDS ViewV_MRP_PLAN_SEG
PPH_MRP_PROD_DEMANDSFiori MRP App Production Demands CDS ViewV_MRP_PROD_DEM
PPH_MRP_PROD_DEMANDS_AGGRFiori MRP App aggreg. Production Demands CDS ViewV_MRP_PRODDEM_A
PPH_MRP_PROD_PLANTFiori MRP App Production Plant CDS ViewV_MRP_PROD_PLANT
PPH_MRP_PRUEFBESTQuality Inspection FlagV_PPH_PRUEFBEST
PPH_MRP_PURCHASE_DOCSFiori MRP App Purchase Documents CDS ViewV_MRP_PURCH_DOC
PPH_MRP_PURCH_DOC_BASICBasic View f├╝r Purchasing DocumentsV_MRP_PURDOC_B
PPH_MRP_RESERVATIONSFiori MRP App Reservations CDS ViewV_MRP_RESERV
PPH_MRP_SCHED_AGRMT_EXITSTSPPH MRP Schedule Agreement ExistsV_MRP_SCHEDAGRMT
PPH_MRP_STOCKTRANSFER_DEMANDSFiori MRP App Stock Transfer Demands CDS ViewV_MRP_TRANSF_DEM
PPH_MRP_STOCK_LINESCDS View for aggregating stock linesV_PPH_STOCK_LINE
PPH_MRP_STOCK_LINES_11st level MRP stock linesV_PPH_STOCK_LIN1
PPH_MRP_STOCK_LINES_22nd level MRP stock linesV_PPH_STOCK_LIN2
PPH_MRP_STOCK_LINES_3stockV_PPH_STOCK_LIN3
PPH_MRP_STTR_PRE_DEMANDSPre-Select CDS view for Stocktransfer DemandsV_MRP_PRE_TRANSF
PPH_MRP_SUPPLIERFiori MRP App Supplier CDS ViewV_MRP_SUPPLIER
PPH_MRP_SUPPLIERSFiori MRP App Suppliers CDS ViewV_MRP_SUPPLIERS
P_MRPMATERIALMRP MaterialPMRPMATRL
P_PLANNEDORDERPROFILEGETPlanned Order ProfilePPLNDORDPRFL
P_PLNDINDEPRQMTPlanned Independent Requirement: Union of PBIM and PBIDPPIR_H
P_PPH_MRP_ISSUESprivate View Material IssuesPPHMRP_ISS_PV
P_PPH_MRP_MATMaterial List for MRP LiveP_PPH_MRP_MAT_V
P_PRODUCTPLANTMRPMRP area data of a ProductPPRDPLNTMRP
P_T460AMAXGet SOBSL of kind stock transferPT460AMAX
P_T460AMAXBANFGet SOBSL of kind stock transferPT460AMAXBANF

Other CDS Views