P_ACCRUALPURCHASEORDER

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_ACCRUALPURCHASEORDER.
-- 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: PFACRA_ACRPOOBJ

CREATE VIEW P_ACCRUALPURCHASEORDER AS
SELECT
  _header.SenderLogicalSystem AS SenderLogicalSystem,
  _header.CFinPurchasingDocument AS CFinPurchasingDocument,
  _item.CFinPurchasingDocumentItem AS CFinPurchasingDocumentItem,
  _acctassign.CFinPurgDocAccountAssignment AS CFinPurgDocAccountAssignment,
  _header.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _header.PurchasingDocumentType AS PurchasingDocumentType,
  _header.DocumentCurrency AS DocumentCurrency,
  _header.Supplier AS Supplier,
  _header.PurchasingGroup AS PurchasingGroup,
  _header.CreatedByUser AS CreatedByUser,
  _header.CreationDate AS CreationDate,
  _header.PurchasingOrganization AS PurchasingOrganization,
  _item.NetPriceQuantity AS NetPriceQuantity,
  _item.NetAmount AS NetAmount,
  _item.Material AS Material,
  _item.MaterialGroup AS MaterialGroup,
  _item.RequisitionerName AS RequisitionerName,
  _item.IsCompletelyDelivered AS IsCompletelyDelivered,
  _item.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  _item.InvoiceIsExpected AS InvoiceIsExpected,
  _item.IsFinallyInvoiced AS IsFinallyInvoiced,
  _item.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _item.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _item.ProductType AS ProductType,
  _item.OrderQuantityUnit AS OrderQuantityUnit,
  _item.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _item.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _acctassign.GLAccount AS GLAccount,
  cast ( '' as ktoks ) AS GLAccountGroup,
  _acctassign.CostCenter AS CostCenter,
  cast ( '' as hkost ) AS CostCenterGroup,
  cast ( '' as prctr ) AS ProfitCenter,
  cast ( '' as hprct ) AS ProfitCenterGroup,
  _acctassign.OrderID AS OrderID,
  cast ( '' as aufgr ) AS InternalOrderGroup,
  _acctassign.WBSElementInternalID AS WBSElementInternalID,
  _acctassign.GoodsRecepientName AS GoodsRecepientName,
  _acctassign.BusinessArea AS BusinessArea,
  _acctassign.Quantity AS Quantity,
  _acctassign.MasterFixedAsset AS MasterFixedAsset,
  _acctassign.FixedAsset AS FixedAsset,
  cast ( '' as ablad ) AS UnloadingWarehouseStagingArea,
  LPad(_item.CFinPurchasingDocument, 10, '0') AS ref_key,
  _acctassign.ControllingArea AS ControllingArea,
  cast(_acctassign.CentralFinanceSalesDocument as vbeln_va preserving type ) AS CentralFinanceSalesDocument,
  cast(_acctassign.CFinSalesDocumentItem as posnr_va preserving type ) AS CFinSalesDocumentItem,
  _acctassign.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent
FROM I_CFinPurchasingDocument AS _header
LEFT OUTER JOIN I_CFinPurchasingDocumentItem AS _item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CFinPurgDocAccountAssignment AS _acctassign ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;