P_CePuCoItemHierSource

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 P_CePuCoItemHierSource.
-- 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: PCCTRITHIERSRC

CREATE VIEW P_CePuCoItemHierSource AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  PurchasingParentItem,
  PurchaseContractItemText,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber,
  Material,
  MaterialGroup,
  NetPriceQuantity,
  OrderQuantityUnit,
  ContractNetPriceAmount,
  OrderPriceUnit,
  VolumeUnit,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  cast ( ' ' as ad_addrnum ) AS ManualDeliveryAddressID,
  StorageLocation,
  GoodsReceiptIsExpected,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  TargetQuantity,
  TargetAmount,
  DocumentCurrency,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  PurchasingDocumentItemCategory,
  SupplierMaterialNumber,
  EvaldRcptSettlmtIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurgDocPriceDate,
  IsInfoRecordUpdated,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  StockType,
  TaxCode,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  ProductType,
  MaterialType,
  FormattedPurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingContractDeletionCode,
  IsStatisticalItem,
  PurgDocAggrgdSubitemCategory,
  SupplierConfirmationControlKey,
  PurgDocEstimatedPrice,
  PurgDocItmBlkRsnCode,
  PurgDocItemRenegotiationStatus,
  PurchasingCentralMaterial,
  CntrlPurContrItmTargetAmount,
  ProcmtHubRefcdConnectedSystem,
  IsEndOfPurposeBlocked,
  PurchasingDocumentItemUniqueID
FROM I_CntrlPurchaseContractItem
LEFT OUTER JOIN I_CentralPurchaseContract AS _CntrlPurchaseContract ON CentralPurchaseContract = _CntrlPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN P_CePuCoItemHierSource AS _Parent ON PurchasingParentItem = _Parent.CentralPurchaseContractItem AND CentralPurchaseContract = _Parent.CentralPurchaseContract  -- association [0..1]
;