I_CntrlPurchaseContractItemTP

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 I_CntrlPurchaseContractItemTP.
-- 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: ICNTRLPCONITMTP

CREATE VIEW I_CntrlPurchaseContractItemTP AS
SELECT
  Document.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  Document.CentralPurchaseContract AS CentralPurchaseContract,
  Document.Material AS Material,
  Document.PurchaseContractItemText AS PurchaseContractItemText,
  Document.ContractNetPriceAmount AS ContractNetPriceAmount,
  Document.OrderPriceUnit AS OrderPriceUnit,
  Document.VolumeUnit AS VolumeUnit,
  Document.OrderQuantityUnit AS OrderQuantityUnit,
  Document.MaterialGroup AS MaterialGroup,
  Document.Customer AS Customer,
  Document.Subcontractor AS Subcontractor,
  Document.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  Document.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  Document.Plant AS Plant,
  Document.StorageLocation AS StorageLocation,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  Document.NetPriceQuantity AS NetPriceQuantity,
  Document.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  Document.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  Document.TargetQuantity AS TargetQuantity,
  Document.TargetAmount AS TargetAmount,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Document.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Document.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  Document.SupplierMaterialNumber AS SupplierMaterialNumber,
  Document.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  Document.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Document.PriceIsToBePrinted AS PriceIsToBePrinted,
  Document.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  Document.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Document.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  Document.InvoiceIsExpected AS InvoiceIsExpected,
  Document.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  Document.PurgDocPriceDate AS PurgDocPriceDate,
  Document.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  Document.PurgDocReleaseOrderQuantity AS PurgDocReleaseOrderQuantity,
  Document.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  Document.PurgDocEstimatedPrice AS PurgDocEstimatedPrice,
  Document.IsInfoAtRegistration AS IsInfoAtRegistration,
  Document.NoDaysReminder1 AS NoDaysReminder1,
  Document.NoDaysReminder2 AS NoDaysReminder2,
  Document.NoDaysReminder3 AS NoDaysReminder3,
  Document.StockType AS StockType,
  Document.TaxCode AS TaxCode,
  Document.RequirementTracking AS RequirementTracking,
  Document.IsOrderAcknRqd AS IsOrderAcknRqd,
  Document.ShippingInstruction AS ShippingInstruction,
  Document.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  Document.ServicePerformer AS ServicePerformer,
  Document.ProductType AS ProductType,
  Document.MaterialType AS MaterialType,
  Document.FormattedPurchaseContractItem AS FormattedPurchaseContractItem,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurchasingContractDeletionCode AS PurchasingContractDeletionCode,
  Document.PurgDocItmBlkRsnCode AS PurgDocItmBlkRsnCode,
  Document.PurgDocItemRenegotiationStatus AS PurgDocItemRenegotiationStatus,
  Document.ProcmtHubExtReferencedMaterial AS PurchasingCentralMaterial,
  Document.CntrlPurContrItmTargetAmount AS CntrlPurContrItmTargetAmount,
  Document.ProcmtHubRefcdConnectedSystem AS ProcmtHubRefcdConnectedSystem,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContrGRConsumptionPct AS CntrlPurContrGRConsumptionPct,
  _CntrlPurContrItmCnsmpnPct.ReleaseOrderItemQuantityUnit AS ReleaseOrderItemQuantityUnit,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContractGRQuantity AS CntrlPurContractGRQuantity,
  _CntrlPurContrItmCnsmpnPct.ReleaseOrderCurrency AS ReleaseOrderCurrency,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContractGRAmount AS CntrlPurContractGRAmount,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContrInvcRcptQuantity AS CntrlPurContrInvcRcptQuantity,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContrInvcRcptAmount AS CntrlPurContrInvcRcptAmount,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContrInvcRcptCnsmpnVal AS CntrlPurContrInvcRcptCnsmpnVal,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContrInvcRcptCnsmpnPct AS CntrlPurContrInvcRcptCnsmpnPct,
  Document.PurchasingParentItem AS PurchasingParentItem,
  Document.IsStatisticalItem AS IsStatisticalItem,
  cast( '' as rsnodeext ) AS HierarchyNode,
  cast( '' as rsnodeext ) AS HierarchyParentNode,
  cast( 0 as abap.int4 ) AS HierarchyLevel,
  cast( 0 as abap.int4 ) AS HierarchyNodeSubTreeSize,
  cast( '' as abap.char(22) ) AS HierarchyDrillState,
  cast( 0 as abap.int8 ) AS HierarchyNodeOrdinalNumber,
  Document.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  Document.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  Document.PurgExternalSortNumber AS PurgExternalSortNumber,
  Document.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays
FROM I_CntrlPurchaseContractItem AS Document
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrDistributionTP AS _CntrlPurContrDistributionTP ON CentralPurchaseContractItem = _CntrlPurContrDistributionTP.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrDistributionTP.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_CntrlPurContrItmCndnValdtyTP AS _CntrlPurContrItmCndnValdtyTP ON _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_CntrlPurContrItmCmmdtyQtyTP AS _CntrlPurContrItmCmmdtyQtyTP ON _CntrlPurContrItmCmmdtyQtyTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItmCmmdtyQtyTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON _StorageLocation.Plant = Plant AND _StorageLocation.StorageLocation = StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON _DocumentCurrency.Currency = DocumentCurrency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_Address AS _ManualDeliveryAddress ON _ManualDeliveryAddress.AddressID = ManualDeliveryAddressID  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgDocItemRenegttnStsText AS _PurgDocItemRenegttnStsText ON PurgDocItemRenegotiationStatus = _PurgDocItemRenegttnStsText.PurgDocItemRenegotiationStatus AND _PurgDocItemRenegttnStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgDocItmBlkRsnCodes AS _PurgDocItmBlkRsnCodesVH ON PurgDocItmBlkRsnCode = _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnCode AND _PurgDocItmBlkRsnCodesVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CntrlPurContrItmCnsmpnPct AS _CntrlPurContrItmCnsmpnPct ON CentralPurchaseContractItem = _CntrlPurContrItmCnsmpnPct.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCnsmpnPct.CentralPurchaseContract  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _CentralContractItemExtension ON CentralPurchaseContract = _CentralContractItemExtension.PurchasingDocument AND CentralPurchaseContractItem = _CentralContractItemExtension.PurchasingDocumentItem  -- association [1..1]
;