P_RU_MaterialRcptDateMM4

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 */
;