C_PurOrdMaintainRefDocValHelp

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_PurOrdMaintainRefDocValHelp.
-- 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: CPOMAINTREFDOCVH

CREATE VIEW C_PurOrdMaintainRefDocValHelp AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingInfoRecordCategory,
  Plant,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  StorageLocation,
  Material,
  MaterialType,
  COALESCE( MaterialGroup , '' ) AS MaterialGroup,
  COALESCE( Supplier , '' ) AS Supplier,
  _PurOrdMaintainSupplierAddr.SupplierAddressCountry AS AddressCountry,
  _PurOrdMaintainSupplierAddr.SupplierAddressCity AS AddressCityName,
  PurchasingDocumentItemText,
  PurchaseOrderQty,
  PurchaseOrderQuantityUnit,
  PurchaseOrderNetPriceAmount,
  TaxCode,
  TaxJurisdiction,
  Currency,
  PurchaseOrderNetPriceQuantity,
  PurchaseOrderPriceUnit,
  _Plant.PlantName AS PlantName,
  _PurgOrg.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurgGrp.PurchasingGroupName AS PurchasingGroupName,
  CompanyCode,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  PurchasingDocumentCondition,
  PricingProcedure,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  PurchaseOrderItemCategory,
  AcctAssignmentCategory,
  IsDeleted,
  ServicePerformer,
  ProductType,
  RefPurchaseOutlineAgreement,
  RefPurchOutlineAgrmtItem,
  SupplierMaterialNumber,
  IncotermsVersion,
  HeaderIncotermsClassification,
  HeaderIncotermsTransferLoc,
  HeaderIncotermsLocation1,
  HeaderIncotermsLocation2,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  DeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  ProfitCenter,
  _CustProject.CustomerProjectName AS CustomerProjectName,
  FunctionalArea,
  GLAccount,
  COALESCE( CostCenter , '' ) AS CostCenter,
  ControllingArea,
  COALESCE( SalesOrder , '' ) AS SalesOrder,
  COALESCE( SalesOrderItem , '' ) AS SalesOrderItem,
  COALESCE( SalesOrderCreatedByUser , '' ) AS CreatedByUser,
  COALESCE( SalesOrderSoldToParty , '' ) AS SoldToParty,
  COALESCE( SalesOrderSalesOrganization , '' ) AS SalesOrganization,
  COALESCE( SalesOrderDistributionChannel , '' ) AS DistributionChannel,
  COALESCE( SalesOrderOrganizationDivision , '' ) AS OrganizationDivision
FROM P_PurOrdMaintainRefDocumentAll
LEFT OUTER JOIN P_Purordmaintaincustproj AS _CustProject ON WBSElementInternalIDNoCoalesce = _CustProject.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryName ON AddressCountry = _CountryName.Country  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON SupplierNoCoalesce = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurgOrg ON PurchasingOrganization = _PurgOrg.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurgGrp ON PurchasingGroup = _PurgGrp.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCodeName  -- association [0..1]
LEFT OUTER JOIN P_PurOrdMaintainSupplierAddr AS _PurOrdMaintainSupplierAddr ON SupplierNoCoalesce = _PurOrdMaintainSupplierAddr.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON PurchaseOrderPriceUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON ServicePerformer = _BusinessPartner.BusinessPartner  -- association [0..1]
;