P_ClrdInvcPurgDocWthoutGds

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_ClrdInvcPurgDocWthoutGds.
-- 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.

CREATE VIEW P_ClrdInvcPurgDocWthoutGds AS
SELECT
  CompanyCode,
  PurchasingDocument,
  PurchasingDocumentItem,
  _SupplierInvoiceItem.SupplierInvoice AS SupplierInvoice,
  _SupplierInvoiceItem.SupplierInvoiceItem AS SupplierInvoiceItem,
  _PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _SupplierInvoiceItem._SupplierInvoice.CreationDate AS CreationDate,
  _SupplierInvoiceItem._SupplierInvoice.CreatedByUser AS InvoiceCreatedByUser,
  _PurchasingDocumentItem.GrossAmount AS GrossAmount,
  _PurchasingDocument.CreatedByUser AS CreatedByUser,
  _PurchasingDocument.CreationDate AS PurchasingDocumentCreationDate,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _PurchasingDocument.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  _PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  NumberOfGoodsReceipts,
  NumberOfInvoiceReceipts,
  Material,
  Plant,
  Supplier,
  SupplierName,
  InvoiceRcptAmtInCoCodeCrcy,
  CompanyCodeCurrency,
  LastChangedByUser,
  GRIRClearingProcessStatus,
  $session.system_date AS ProcedureRunDate,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _SupplierInvoiceItem._SupplierInvoice.SupplierInvoiceStatus AS SupplierInvoiceStatus
FROM I_GRIRAccountReconciliation
LEFT OUTER JOIN I_SupplierInvoiceItemPurOrdRef AS _SupplierInvoiceItem ON PurchasingDocument = _SupplierInvoiceItem.PurchaseOrder AND PurchasingDocumentItem = _SupplierInvoiceItem.PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON purchasingdocumentcategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON purchasingdocumentcategory = _PurchasingDocumentType.PurchasingDocumentCategory AND purchasingdocumenttype = _PurchasingDocumentType.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON purchasingorganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON documentcurrency = _DocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON purchasinggroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentOrigin AS _PurchasingDocumentOrigin ON purchasingdocumentorigin = _PurchasingDocumentOrigin.PurchasingDocumentOrigin  -- association [1..1]
;