C_InvcdPurgDocNoGdsRcpt

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 C_InvcdPurgDocNoGdsRcpt.
-- 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: CGRCINVPDWTTGDRC

CREATE VIEW C_InvcdPurgDocNoGdsRcpt AS
SELECT
  _PurchasingDocument.CompanyCode AS CompanyCode,
  PurchaseOrder,
  PurchaseOrderItem,
  _SupplierInvoice.SupplierInvoice AS SupplierInvoice,
  _SupplierInvoice.FiscalYear AS FiscalYear,
  _PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _SupplierInvoice.CreationDate AS CreationDate,
  _SupplierInvoice.CreatedByUser AS InvoiceCreatedByUser,
  _PurchasingDocumentItem.GrossAmount AS GrossAmount,
  _PurchasingDocument.CreationDate AS PurchasingDocumentCreationDate,
  _PurchasingDocument.CreatedByUser AS CreatedByUser,
  _PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _PurchasingDocument.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  _PurchasingDocument.LastChangeDateTime AS LastChangeDateTime,
  _PurchasingDocument.Supplier AS Supplier,
  _PurchasingDocument._Supplier.SupplierFullName AS SupplierFullName,
  _SupplierInvoice.InvoiceGrossAmount AS InvoiceGrossAmount,
  _SupplierInvoice.DocumentDate AS DocumentDate,
  _SupplierInvoice.PostingDate AS PostingDate,
  _PurchasingDocument._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  case when PurchasingHistoryDocumentType = '2' then 'X' else '' end AS InvoiceIsExisting,
  case when _PurchaseOrderHistoryAPI0.PurchasingHistoryDocumentType is null then '' end AS GoodsReceiptIsExisting,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem
LEFT OUTER JOIN I_PurchaseOrderHistoryAPI01 AS _PurchaseOrderHistoryAPI0 ON PurchaseOrder = _PurchaseOrderHistoryAPI0.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderHistoryAPI0.PurchaseOrderItem AND _PurchaseOrderHistoryAPI0.PurchasingHistoryDocumentType = '1'  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchaseOrder = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchaseOrder = _PurchasingDocumentItem.PurchasingDocument AND PurchaseOrderItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON PurchasingHistoryDocument = _SupplierInvoice.SupplierInvoice AND PurchasingHistoryDocumentYear = _SupplierInvoice.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderHistoryBasic AS _PurchaseOrderHistoryBasic ON PurchaseOrder = _PurchaseOrderHistoryBasic.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderHistoryBasic.PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [0..1]
;