C_GB_StRpAuditMMFileC

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_GB_StRpAuditMMFileC.
-- 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 C_GB_StRpAuditMMFileC AS
SELECT
  I_PurchasingDocument.CompanyCode AS CompanyCode,
  I_PurchasingDocument.PurchasingDocument AS PurchasingDocument,
  I_PurchasingDocumentItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_PurgDocAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  I_PurchasingDocument.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  I_PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  I_PurchasingDocumentItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_PurchasingDocumentItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  I_PurchasingDocumentItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  I_PurchasingDocumentItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_PurchasingDocumentItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  I_PurchasingDocumentItem.InvoiceIsExpected AS InvoiceIsExpected,
  I_PurchasingDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_PurgDocAccountAssignment.IsDeleted AS IsDeleted,
  I_PurgDocAccountAssignment.Quantity AS Quantity,
  I_PurgDocAccountAssignment.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  I_PurgDocAccountAssignment.PurgDocNetAmount AS PurgDocNetAmount,
  I_PurgDocAccountAssignment.GLAccount AS GLAccount,
  I_PurgDocAccountAssignment.CostCenter AS CostCenter,
  I_PurgDocAccountAssignment.MasterFixedAsset AS MasterFixedAsset,
  I_PurgDocAccountAssignment.ControllingArea AS ControllingArea,
  I_PurgDocAccountAssignment.CostObject AS CostObject,
  I_PurgDocAccountAssignment.ProfitCenter AS ProfitCenter,
  cast(I_PurgDocAccountAssignment.WBSElementInternalID as ps_psp_pnr_core) AS WBSElementInternalID,
  I_PurgDocAccountAssignment.TaxCode AS TaxCode,
  I_PurgDocAccountAssignment.TaxJurisdiction AS TaxJurisdiction,
  I_PurchasingDocumentItem.PurchasingDocumentItemText AS PurchasingDocumentItemText
FROM I_PurchasingDocument
INNER JOIN I_PurchasingDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurgDocAccountAssignment ON /* join condition not captured in parsed metadata */
;