C_PurOrdRefDocPC

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_PurOrdRefDocPC.
-- 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: CPURORDREFDOCPC

CREATE VIEW C_PurOrdRefDocPC AS
SELECT
  ctr_item.PurchaseContract AS PurchaseOrder,
  ctr_item.PurchaseContractItem AS PurchaseOrderItem,
  AccAssLine.AccountAssignmentNumber AS AccountAssignmentNumber,
  '' AS PurchasingInfoRecord,
  ctr_header.PurchasingOrganization AS PurchasingOrganization,
  cast('' as esokz) AS PurchasingInfoRecordCategory,
  ctr_item.Plant AS Plant,
  cast('' as abap.char(10)) AS FixedSupplier,
  cast('' as abap.char(10)) AS FixedSupplierName,
  cast('' as abap.char(10)) AS PurchaseRequisition,
  cast('' as abap.numc(5)) AS PurchaseRequisitionItem,
  _Plant.PlantName AS PlantName,
  ctr_item.PurchaseContract AS PurchasingDocument,
  'K' AS PurchasingDocumentCategory,
  '' AS IsAdvancedPurchaseOrder,
  ctr_header.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  ctr_item.StorageLocation AS StorageLocation,
  ctr_item.ManufacturerMaterial AS ManufacturerMaterial,
  ctr_item.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  '' AS MaterialType,
  ctr_item.MaterialGroup AS MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  ctr_header.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  ctr_header.PurchaseContractType AS PurchasingDocumentType,
  '' AS PurchasingDocumentSubtype,
  ctr_item.PurchaseContractItemText AS PurchasingDocumentItemText,
  cast(0 as abap.dec( 13, 3 )) AS PurchaseOrderQty,
  ctr_item.OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  ctr_item.ContractNetPriceAmount AS PurchaseOrderNetPriceAmount,
  ctr_header.DocumentCurrency AS Currency,
  ctr_item.NetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  ctr_item.OrderPriceUnit AS PurchaseOrderPriceUnit,
  _UnitOfMeasureText.UnitOfMeasureLongName AS PurchaseOrderPriceUnitName,
  ctr_header.PurchasingGroup AS PurchasingGroup,
  _PurgGrp.PurchasingGroupName AS PurchasingGroupName,
  ctr_header.CompanyCode AS CompanyCode,
  cast('' as abap.char(25)) AS CompanyCodeName,
  cast('' as abap.char(40)) AS PurchaseRequisitionItemText,
  '' AS PurchasingDocumentCondition,
  '' AS PricingProcedure,
  ctr_header.ValidityStartDate AS ValidityStartDate,
  ctr_header.ValidityEndDate AS ValidityEndDate,
  ctr_consumption.ContractConsumptionInPct AS ContractConsumptionInPct,
  '' AS GoodsReceiptIsExpected,
  '' AS GoodsReceiptIsNonValuated,
  '' AS InvoiceIsExpected,
  '' AS InvoiceIsGoodsReceiptBased,
  cast(0 as abap.dec( 5, 1 )) AS OverdelivTolrtdLmtRatioInPct,
  '' AS UnlimitedOverdeliveryIsAllowed,
  cast(0 as abap.dec( 5, 1 )) AS UnderdelivTolrtdLmtRatioInPct,
  cast(0 as abap.dec( 5, 0 )) AS OrderItemQtyToBaseQtyNmrtr,
  cast(0 as abap.dec( 5, 0 )) AS OrderItemQtyToBaseQtyDnmntr,
  '' AS PurchaseOrderItemCategory,
  '' AS IsDeleted,
  '' AS ServicePerformer,
  '' AS ServicePerformerName,
  '' AS ProductType,
  '' AS RefPurchaseOutlineAgreement,
  cast('00000' as abap.numc(5)) AS RefPurchOutlineAgrmtItem,
  '' AS SupplierMaterialNumber,
  cast('00000000' as abap.dats) AS DeliveryDate,
  cast('00000000' as abap.dats) AS PerformancePeriodStartDate,
  cast('00000000' as abap.dats) AS PerformancePeriodEndDate,
  cast(0 as abap.dec( 5, 0 )) AS OrderPriceUnitToOrderUnitNmrtr,
  cast(0 as abap.dec( 5, 0 )) AS OrdPriceUnitToOrderUnitDnmntr,
  _Project.CustomerProjectName AS CustomerProjectName,
  AccAssLine.ProfitCenter AS ProfitCenter,
  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,
  AccAssLine.ControllingArea AS ControllingArea,
  AccAssLine.SalesOrder AS SalesOrder,
  AccAssLine.SalesOrderItem AS SalesOrderItem,
  cast('' as abap.char(4)) AS PurReqnDescription
FROM I_PurchaseContractItem AS ctr_item
LEFT OUTER JOIN I_PurchaseContract AS ctr_header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseContractRelevance AS ctr_consumption 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 I_SalesOrderItem AS so_item 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  -- association [0..*]
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]
;