A_CntrlPurchaseContractItem

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 A_CntrlPurchaseContractItem.
-- 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: ACNTRLPCTRI

CREATE VIEW A_CntrlPurchaseContractItem AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  PurchasingDocumentItemCategory,
  FormattedPurchaseContractItem,
  MaterialGroup,
  PurchasingCentralMaterial,
  ProcmtHubRefcdConnectedSystem,
  PurchaseContractItemText AS CntrlPurContractItemText,
  ProductType,
  ActivePurchasingDocument,
  NetPriceQuantity,
  OrderPriceUnit,
  TargetQuantity,
  CntrlPurContrItmTargetAmount,
  ContractNetPriceAmount,
  OrderQuantityUnit,
  PurgDocReleaseOrderQuantity,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  DocumentCurrency,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  PurgDocOrderAcknNumber,
  RequirementTracking,
  SupplierMaterialNumber,
  IsOrderAcknRqd,
  PurgDocEstimatedPrice,
  PriceIsToBePrinted,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  StockType,
  TaxCode,
  ShippingInstruction,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  EvaldRcptSettlmtIsAllowed,
  PurgDocItmBlkRsnCode,
  PurgDocItemRenegotiationStatus,
  PurchasingParentItem,
  IsStatisticalItem AS IsOutline,
  PurgConfigurableItemNumber
FROM I_CntrlPurchaseContractItem
LEFT OUTER JOIN A_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_CntrlPurContrItmDistribution AS _CntrlPurConItmDistribution ON CentralPurchaseContract = _CntrlPurConItmDistribution.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurConItmDistribution.CentralPurchaseContractItem  -- association [1..*]
LEFT OUTER JOIN A_CntrlPurContractItemNotes AS _CntrlPurContrItmNotes ON FormattedPurchaseContractItem = _CntrlPurContrItmNotes.PurchasingDocumentNoteObjectID  -- association [1..*]
LEFT OUTER JOIN A_CntrlPurContrItmCndnValdty AS _CntrlPurContrItmCndnValdty ON CentralPurchaseContractItem = _CntrlPurContrItmCndnValdty.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCndnValdty.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN A_CntrlPurContrItmCmmdtyQty AS _CntrlPurContrItmCmmdtyQty ON CentralPurchaseContractItem = _CntrlPurContrItmCmmdtyQty.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCmmdtyQty.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _CntrlPurContrItemExtension ON CentralPurchaseContract = _CntrlPurContrItemExtension.PurchasingDocument AND CentralPurchaseContractItem = _CntrlPurContrItemExtension.PurchasingDocumentItem  -- association [1..1]
;