What is P_RU_MaterialRcptDateMM4 in SAP S/4HANA?

P_RU_MaterialRcptDateMM4 is a consumption CDS view in SAP S/4HANA. FI RU get Material Receipt Date: MM-4 It contains 21 fields.

Which tables does P_RU_MaterialRcptDateMM4 read from?

P_RU_MaterialRcptDateMM4 reads data from: P_RU_AcctgDocReferenceID, I_OperationalAcctgDocItem, P_RU_PurchaseOrderHistoryGRIR.

What VDM layer is P_RU_MaterialRcptDateMM4?

P_RU_MaterialRcptDateMM4 is classified as a Consumption view optimized for specific business scenarios and reporting.

P_RU_MaterialRcptDateMM4

DDL: P_RU_MATERIALRCPTDATEMM4 SQL: PRUMATRCDTMM4 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU_SPL

21 Fields 3 Data Sources

FI RU get Material Receipt Date: MM-4

P_RU_MaterialRcptDateMM4 is a Consumption CDS View that provides data about "FI RU get Material Receipt Date: MM-4" in SAP S/4HANA. It reads from 3 data sources (P_RU_AcctgDocReferenceID, I_OperationalAcctgDocItem, P_RU_PurchaseOrderHistoryGRIR) and exposes 21 fields. Part of development package GLO_FIN_IS_VAT_RU_SPL.

Data Sources (3)

Source	Alias	Join Type
P_RU_AcctgDocReferenceID	InvoiceAccDocHead	from
I_OperationalAcctgDocItem	InvoiceAccDocItem	inner
P_RU_PurchaseOrderHistoryGRIR	PurchDocItemHistGRIR	inner

Annotations (6)

Name	Value	Level
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	PRUMATRCDTMM4	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (21)

Field	Source Table	Source Field	Description
CompanyCode	P_RU_AcctgDocReferenceID	CompanyCode	Receiver Company Code
AccountingDocument	P_RU_AcctgDocReferenceID	AccountingDocument	Journal Entry
FiscalYear	P_RU_AcctgDocReferenceID	FiscalYear	G/L Fiscal Year
DocumentDate	P_RU_AcctgDocReferenceID	DocumentDate	Journal Entry Date
PostingDate	P_RU_AcctgDocReferenceID	PostingDate	Posting Date for GR
IsReversal	P_RU_AcctgDocReferenceID	IsReversal	Reversal doc.
IsReversed	P_RU_AcctgDocReferenceID	IsReversed	Reversed?
PurchasingDocument	I_OperationalAcctgDocItem	PurchasingDocument	Purchasing Document
PurchasingDocumentItem	I_OperationalAcctgDocItem	PurchasingDocumentItem	Purchasing Doc. Item
Plant	P_RU_PurchaseOrderHistoryGRIR	Plant	Valuation Area
GoodsReceiptIsExpected	P_RU_PurchaseOrderHistoryGRIR	GoodsReceiptIsExpected	Goods Receipt
IR_MaterialDocument	P_RU_PurchaseOrderHistoryGRIR	IR_MaterialDocument	Material Doc.
IR_MaterialDocumentYear	P_RU_PurchaseOrderHistoryGRIR	IR_MaterialDocumentYear	Material Document Year
IR_MaterialDocumentItem	P_RU_PurchaseOrderHistoryGRIR	IR_MaterialDocumentItem	Material Document Item
GR_MaterialDocument	P_RU_PurchaseOrderHistoryGRIR	GR_MaterialDocument	Material Doc.
GR_MaterialDocumentYear	P_RU_PurchaseOrderHistoryGRIR	GR_MaterialDocumentYear	Material Document Year
GR_MaterialDocumentItem	P_RU_PurchaseOrderHistoryGRIR	GR_MaterialDocumentItem	Material Document Item
GR_PostingDate	P_RU_PurchaseOrderHistoryGRIR	GR_PostingDate	Posting Date for GR
GRIR_ReferenceDocument	P_RU_PurchaseOrderHistoryGRIR	GRIR_ReferenceDocument	Reference Document
GRIR_ReferenceDocumentFisYear	P_RU_PurchaseOrderHistoryGRIR	GRIR_ReferenceDocumentFisYear	Year Cur.Period
GRIR_ReferenceDocumentItem	P_RU_PurchaseOrderHistoryGRIR	GRIR_ReferenceDocumentItem	Reference item

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RU_MaterialRcptDateMM4.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRUMATRCDTMM4

CREATE VIEW P_RU_MaterialRcptDateMM4 AS
SELECT
  InvoiceAccDocHead.CompanyCode AS CompanyCode,
  InvoiceAccDocHead.AccountingDocument AS AccountingDocument,
  InvoiceAccDocHead.FiscalYear AS FiscalYear,
  InvoiceAccDocHead.DocumentDate AS DocumentDate,
  InvoiceAccDocHead.PostingDate AS PostingDate,
  InvoiceAccDocHead.IsReversal AS IsReversal,
  InvoiceAccDocHead.IsReversed AS IsReversed,
  InvoiceAccDocItem.PurchasingDocument AS PurchasingDocument,
  InvoiceAccDocItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurchDocItemHistGRIR.Plant AS Plant,
  PurchDocItemHistGRIR.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  PurchDocItemHistGRIR.IR_MaterialDocument AS IR_MaterialDocument,
  PurchDocItemHistGRIR.IR_MaterialDocumentYear AS IR_MaterialDocumentYear,
  PurchDocItemHistGRIR.IR_MaterialDocumentItem AS IR_MaterialDocumentItem,
  PurchDocItemHistGRIR.GR_MaterialDocument AS GR_MaterialDocument,
  PurchDocItemHistGRIR.GR_MaterialDocumentYear AS GR_MaterialDocumentYear,
  PurchDocItemHistGRIR.GR_MaterialDocumentItem AS GR_MaterialDocumentItem,
  PurchDocItemHistGRIR.GR_PostingDate AS GR_PostingDate,
  PurchDocItemHistGRIR.GRIR_ReferenceDocument AS GRIR_ReferenceDocument,
  PurchDocItemHistGRIR.GRIR_ReferenceDocumentFisYear AS GRIR_ReferenceDocumentFisYear,
  PurchDocItemHistGRIR.GRIR_ReferenceDocumentItem AS GRIR_ReferenceDocumentItem
FROM P_RU_AcctgDocReferenceID AS InvoiceAccDocHead
INNER JOIN I_OperationalAcctgDocItem AS InvoiceAccDocItem ON /* join condition not captured in parsed metadata */
INNER JOIN P_RU_PurchaseOrderHistoryGRIR AS PurchDocItemHistGRIR ON /* join condition not captured in parsed metadata */
;

Depth:

P_RU_MaterialRcptDateMM4 view