C_PurOrdRefDocPurReqn

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_PurOrdRefDocPurReqn.
-- 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: CPURORDREFDOCPR

CREATE VIEW C_PurOrdRefDocPurReqn AS
SELECT
  purchaseRequisitionItm.PurchaseRequisition AS PurchaseRequisition,
  purchaseRequisitionItm.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseReqnItem._PurchaseReqnAcctAssgmt.PurReqnAcctAssgmtNmbr AS AccountAssignmentNumber,
  purchaseRequisitionItm.PurchaseRequisition AS PurchasingDocument,
  cast( case purchaseRequisitionItm.Supplier when '' then purchaseRequisitionItm.FixedSupplier else purchaseRequisitionItm.Supplier end as lifnr ) as Supplier AS SupplierendaslifnrasSupplier,
  purchaseRequisitionItm.FixedSupplier AS FixedSupplier,
  purchaseRequisitionItm.Supplier AS FixedSupplierName,
  cast('' as abap.char(10)) AS PurchaseOrder,
  cast('' as abap.numc(5)) AS PurchaseOrderItem,
  purchaseRequisitionItm.PurchaseRequisitionItemText AS PurchasingDocumentItemText,
  purchaseRequisitionItm.CompanyCode AS CompanyCode,
  '' AS IsAdvancedPurchaseOrder,
  cast('' as abap.char(10)) AS PurchasingInfoRecord,
  purchaseRequisitionItm.PurchasingOrganization AS PurchasingOrganization,
  cast('' as esokz) AS PurchasingInfoRecordCategory,
  purchaseRequisitionItm.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  purchaseRequisitionItm.Material AS ManufacturerMaterial,
  purchaseRequisitionItm.MaterialGroup AS MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  purchaseRequisitionItm.RequestedQuantity - purchaseRequisitionItm.OrderedQuantity AS PurchaseOrderQty,
  _PurchaseReqnItem.ServicePerformer AS ServicePerformer,
  _PurchaseReqnItem.CostCenter AS CostCenter,
  _PurchaseReqnItem.ItemUoM AS ItemUoM,
  purchaseRequisitionItm.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  '' AS CostCenterName,
  '' AS PurchaseOrderPriceUnitName,
  '' AS PurchasingDocumentDeletionCode,
  _PurchaseReqnItem.StorageLocation AS StorageLocation,
  _PurchaseReqnItem.GLAccount AS GLAccount,
  purchaseRequisitionItm.Material AS Material,
  cast('' as abap.char(4)) AS MaterialType,
  _MaterialText.MaterialName AS MaterialName,
  cast('' as abap.unit( 3 )) AS PurchaseOrderQuantityUnit,
  '' AS CustomerProjectName,
  '' AS PurchasingDocumentSubtype,
  purchaseRequisitionItm.PurReqnItemCurrency AS Currency,
  purchaseRequisitionItm.PurReqnPriceQuantity AS PurchaseOrderNetPriceQuantity,
  _PurchaseReqnItem.BaseUnit AS PurchaseOrderPriceUnit,
  purchaseRequisitionItm.BaseUnit AS BaseUnit,
  '' AS GLAccountName,
  '' AS PurchasingGroupName,
  cast('' as abap.char(25)) AS CompanyCodeName,
  cast('' as abap.char(6)) AS PricingProcedure,
  purchaseRequisitionItm.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  purchaseRequisitionItm.PerformancePeriodEndDate AS ValidityEndDate,
  '' 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 ServicePerformerName,
  cast('00000' as abap.char(04)) AS ProductType,
  cast('00000' as abap.char(10)) AS RefPurchaseOutlineAgreement,
  cast('00000' as abap.numc(5)) AS RefPurchOutlineAgrmtItem,
  cast('00000' as abap.char(35)) AS SupplierMaterialNumber,
  cast('00000000' as abap.dats) AS DeliveryDate,
  cast(0 as abap.dec( 5, 0 )) AS OrderPriceUnitToOrderUnitNmrtr,
  cast(0 as abap.dec( 5, 0 )) AS OrdPriceUnitToOrderUnitDnmntr,
  cast('' as abap.char(10)) AS SalesOrder,
  cast('' as abap.numc(6)) AS SalesOrderItem,
  cast('' as abap.char(4)) AS ControllingArea,
  cast('' as abap.char(4)) AS PurchasingDocumentType,
  cast('00000000' as abap.dats) AS ValidityStartDate,
  0 AS ContractConsumptionInPct,
  _PurchaseReqnItem._PurchaseReqn.PurReqnDescription AS PurReqnDescription,
  _PurchaseReqnItem._PurchaseReqnAcctAssgmt.WBSElementInternalID AS WBSElementInternalID,
  _PurchaseReqnItem._PurchaseReqnAcctAssgmt.WBSElement AS WBSElement,
  cast('' as abap.char(16)) AS FunctionalArea,
  _PurchaseReqnItem.PurchasingGroup AS PurchasingGroup,
  _PurchaseReqnItem._PurchasingGroupValueHelp AS _PurchasingGroupValueHelp
FROM C_PurchaseRequisitionItmDtls AS purchaseRequisitionItm
LEFT OUTER JOIN C_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _FixedSupplier ON purchaseRequisitionItm.FixedSupplier = _FixedSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON purchaseRequisitionItm.Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = purchaseRequisitionItm.Supplier AND _SupplierValueHelp.CompanyCode = purchaseRequisitionItm.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = Material AND _MaterialValueHelp.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupVH ON _MaterialGroupVH.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
;