C_PurOrdRefDocPO

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_PurOrdRefDocPO.
-- 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: CPURORDREFDOCPO

CREATE VIEW C_PurOrdRefDocPO AS
SELECT
  po_item.PurchaseOrder AS PurchaseOrder,
  po_item.PurchaseOrderItem AS PurchaseOrderItem,
  AccAssLine.AccountAssignmentNumber AS AccountAssignmentNumber,
  cast('' as abap.char(10)) AS PurchasingInfoRecord,
  cast('' as abap.char(10)) AS PurchaseRequisition,
  cast('' as abap.char(40)) AS PurchaseRequisitionItemText,
  cast('' as abap.numc(5)) AS PurchaseRequisitionItem,
  po_header.PurchasingOrganization AS PurchasingOrganization,
  cast('' as abap.char(1)) AS PurchasingInfoRecordCategory,
  po_item.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  po_item.PurchaseOrder AS PurchasingDocument,
  'F' AS PurchasingDocumentCategory,
  '' AS IsAdvancedPurchaseOrder,
  po_item.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  cast('' as abap.char(10)) AS FixedSupplier,
  po_header.Supplier AS FixedSupplierName,
  po_item.ManufacturerMaterial AS ManufacturerMaterial,
  po_item.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  po_item.MaterialType AS MaterialType,
  po_item.MaterialGroup AS MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  po_header.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  po_header.PurchaseOrderType AS PurchasingDocumentType,
  po_header.PurchaseOrderSubtype AS PurchasingDocumentSubtype,
  po_item.PurchaseOrderItemText AS PurchasingDocumentItemText,
  po_item.OrderQuantity AS PurchaseOrderQty,
  po_item.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  po_item.NetPriceAmount AS PurchaseOrderNetPriceAmount,
  po_header.DocumentCurrency AS Currency,
  po_item.NetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  po_item.OrderPriceUnit AS PurchaseOrderPriceUnit,
  _UnitOfMeasureText.UnitOfMeasureLongName AS PurchaseOrderPriceUnitName,
  po_header.PurchasingGroup AS PurchasingGroup,
  _PurgGrp.PurchasingGroupName AS PurchasingGroupName,
  po_header.CompanyCode AS CompanyCode,
  cast('' as abap.char(25)) AS CompanyCodeName,
  po_header.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  po_item.ServicePerformer AS ServicePerformer,
  _BusinessPartner.BusinessPartnerName AS ServicePerformerName,
  _Project.CustomerProjectName AS CustomerProjectName,
  AccAssLine.WBSElementInternalID AS WBSElementInternalID,
  _Project.WBSElement AS WBSElement,
  AccAssLine.FunctionalArea AS FunctionalArea,
  AccAssLine.GLAccount AS GLAccount,
  _GlAccountTextInCompanycode.GLAccountName AS GLAccountName,
  AccAssLine.CostCenter AS CostCenter,
  _CostCenterText.CostCenterName AS CostCenterName,
  po_header.ValidityStartDate AS ValidityStartDate,
  po_header.ValidityEndDate AS ValidityEndDate,
  0 AS ContractConsumptionInPct,
  AccAssLine.ControllingArea AS ControllingArea,
  AccAssLine.SalesOrder AS SalesOrder,
  AccAssLine.SalesOrderItem AS SalesOrderItem,
  cast('' as abap.char(4)) AS PurReqnDescription
FROM I_PurchaseOrderItem AS po_item
LEFT OUTER JOIN I_PurchaseOrder AS po_header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurOrdAcctAssignmentTP AS AccAssLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Purordmaintaincustproj AS _Project ON WBSElementInternalID = _Project.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurgGrp ON PurchasingGroup = _PurgGrp.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND ValidityEndDate = _CostCenterText.ValidityEndDate AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON ManufacturerMaterial = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON PurchaseOrderPriceUnit = _UnitOfMeasureText.UnitOfMeasure AND _UnitOfMeasureText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON ServicePerformer = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GlAccountTextInCompanycode ON GLAccount = _GlAccountTextInCompanycode.GLAccount AND CompanyCode = _GlAccountTextInCompanycode.CompanyCode AND _GlAccountTextInCompanycode.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupVH ON _PurchasingGroupVH.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = ManufacturerMaterial  -- association [0..*]
LEFT OUTER JOIN C_MM_ServicePerformerValueHelp AS _ServicePerformerValueHelp ON _ServicePerformerValueHelp.ServicePerformer = ServicePerformer  -- association [0..*]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupVH ON _MaterialGroupVH.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant  -- association [0..*]
LEFT OUTER JOIN I_MM_SalesOrderValueHelp AS _SalesOrder ON _SalesOrder.SalesOrder = SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_MM_CostCenterValueHelp AS _CostCenter ON _CostCenter.CostCenter = CostCenter AND _CostCenter.ControllingArea = ControllingArea AND _CostCenter.ValidityEndDate = ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_MM_WBSElementValueHelp AS _WBSElementVH ON _WBSElementVH.WBSElementInternalID = WBSElementInternalID AND _WBSElementVH.WBSElementExternalID = WBSElement  -- association [0..1]
LEFT OUTER JOIN I_MM_ControllingAreaVH AS _ControllingAreaValueHelp ON ControllingArea = _ControllingAreaValueHelp.ControllingArea  -- association [0..1]
LEFT OUTER JOIN R_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
;