C_PurOrdRefDocIR

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_PurOrdRefDocIR.
-- 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: CPURORDREFDOCIR

CREATE VIEW C_PurOrdRefDocIR AS
SELECT
  eine.PurchasingInfoRecord AS PurchasingInfoRecord,
  eine.PurchasingOrganization AS PurchasingOrganization,
  eine.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  eine.Plant AS Plant,
  cast('' as abap.char(10)) AS PurchaseRequisition,
  cast('' as abap.numc(5)) AS PurchaseRequisitionItem,
  '' AS PurchaseOrder,
  cast('' as abap.numc(5)) AS PurchaseOrderItem,
  '' AS AccountAssignmentNumber,
  cast('' as abap.char(10)) AS FixedSupplier,
  cast('' as abap.char(10)) AS FixedSupplierName,
  _Plant.PlantName AS PlantName,
  eine.PurchasingInfoRecord AS PurchasingDocument,
  'I' AS PurchasingDocumentCategory,
  '' AS IsAdvancedPurchaseOrder,
  '' AS PurchasingDocumentDeletionCode,
  '' AS StorageLocation,
  eina.Material AS ManufacturerMaterial,
  eina.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  material._MaterialType.MaterialType AS MaterialType,
  cast('' as abap.char(40)) AS PurchaseRequisitionItemText,
  case eina.MaterialGroup when '' then eina._Material.MaterialGroup else eina.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  case eina.MaterialGroup when '' then eina._Material._MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName else eina._MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName end as MaterialGroupName AS MaterialGroupNameendasMaterialGroupName,
  eina.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  cast('' as abap.char(4)) AS PurchasingDocumentType,
  cast('' as abap.char(4)) AS PurchasingDocumentSubtype,
  eina.PurchasingInfoRecordDesc AS PurchasingDocumentItemText,
  eine.StandardPurchaseOrderQuantity AS PurchaseOrderQty,
  eina.PurgDocOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  eine.NetPriceAmount AS PurchaseOrderNetPriceAmount,
  eine.Currency AS Currency,
  eine.MaterialPriceUnitQty AS PurchaseOrderNetPriceQuantity,
  eine.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  _UnitOfMeasureText.UnitOfMeasureLongName AS PurchaseOrderPriceUnitName,
  eine.PurchasingGroup AS PurchasingGroup,
  _PurgGrp.PurchasingGroupName AS PurchasingGroupName,
  cast('' as abap.char(4)) AS CompanyCode,
  cast('' as abap.char(25)) AS CompanyCodeName,
  cast('' as abap.char(10)) AS PurchasingDocumentCondition,
  '' AS PricingProcedure,
  cast('00000000' as vdm_validitystart) AS ValidityStartDate,
  eine.PriceValidityEndDate AS ValidityEndDate,
  0 AS ContractConsumptionInPct,
  cast('' as abap.char(1)) AS GoodsReceiptIsExpected,
  cast('' as abap.char(1)) AS GoodsReceiptIsNonValuated,
  cast('' as abap.char(1)) AS InvoiceIsExpected,
  eine.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  eine.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  eine.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  eine.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  eina.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  eina.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  '' AS PurchaseOrderItemCategory,
  eine.IsMarkedForDeletion AS IsDeleted,
  '' AS ServicePerformer,
  '' AS ServicePerformerName,
  '' AS ProductType,
  cast('' as abap.char(10)) AS RefPurchaseOutlineAgreement,
  cast('00000' as abap.numc(5)) AS RefPurchOutlineAgrmtItem,
  eina.SupplierMaterialNumber AS SupplierMaterialNumber,
  cast('00000000' as abap.dats) AS DeliveryDate,
  cast('00000000' as abap.dats) AS PerformancePeriodStartDate,
  cast('00000000' as abap.dats) AS PerformancePeriodEndDate,
  eine.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  eine.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  '' AS CustomerProjectName,
  cast('' as abap.char(10)) AS ProfitCenter,
  cast('' as abap.numc(8)) AS WBSElementInternalID,
  cast('' as abap.numc(10)) AS WBSElement,
  cast('' as abap.char(16)) AS FunctionalArea,
  cast('' as abap.char(10)) AS GLAccount,
  '' AS GLAccountName,
  cast('' as abap.char(10)) AS CostCenter,
  '' AS CostCenterName,
  cast('' as abap.char(4)) AS ControllingArea,
  cast('' as abap.char(10)) AS SalesOrder,
  cast('' as abap.numc(6)) AS SalesOrderItem,
  cast('' as abap.char(4)) AS PurReqnDescription
FROM I_PurgInfoRecdOrgPlantData AS eine
LEFT OUTER JOIN I_PurchasingInfoRecord AS eina ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS material ON /* join condition not captured in parsed metadata */
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_MM_ControllingAreaVH AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- 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]
;