C_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 C_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: CCNTRLPCONITMTP

CREATE VIEW C_CntrlPurchaseContractItemTP AS
SELECT
  CentralPurchaseContractItem,
  CentralPurchaseContract,
  PurgConfigurableItemNumber,
  PurchasingCentralMaterial,
  ProcmtHubRefcdConnectedSystem,
  Material,
  PurchaseContractItemText,
  ContractNetPriceAmount,
  OrderPriceUnit,
  VolumeUnit,
  OrderQuantityUnit,
  MaterialGroup,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  ManualDeliveryAddressID,
  Plant,
  StorageLocation,
  AccountAssignmentCategory,
  GoodsReceiptIsExpected,
  NetPriceQuantity,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  TargetQuantity,
  TargetAmount,
  CntrlPurContrItmTargetAmount,
  DocumentCurrency,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  PurchasingDocumentItemCategory,
  SupplierMaterialNumber,
  EvaldRcptSettlmtIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  SupplierConfirmationControlKey,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurgDocPriceDate,
  IsInfoRecordUpdated,
  ReleaseOrderItemQuantityUnit,
  CntrlPurContractGRQuantity,
  ReleaseOrderCurrency,
  CntrlPurContractGRAmount,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  PurgDocEstimatedPrice,
  IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  StockType,
  TaxCode,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  ProductType,
  MaterialType,
  FormattedPurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  TextIsDeleted,
  PurchasingContractDeletionCode,
  OutlineAgrmtItmBlockedText,
  PurgDocItmBlkRsnCode,
  PurgDocItemRenegotiationStatus,
  IsEndOfPurposeBlocked,
  cast( '' as abap.char( 450 ) ) AS NoteTypeListText,
  cast( ' ' as cmm_cmdty_code_dsbd preserving type) AS PurgDocCmmdtyCodeIsDisabled,
  cast( ' ' as cmm_cmdty_is_dsbd preserving type) AS CommodityIsDisabled,
  PurchasingParentItem,
  IsStatisticalItem,
  PurgExternalSortNumber,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyLevel,
  HierarchyNodeSubTreeSize,
  HierarchyDrillState,
  HierarchyNodeOrdinalNumber,
  IsOutline,
  _CentralPurchaseContract.ActivePurchasingDocument AS ActivePurchasingDocument,
  _CentralPurchaseContract.PurchasingDocumentName AS PurchasingDocumentName,
  _CentralPurchaseContract.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  _CentralPurchaseContract.IsExtPurgScenario AS IsExtPurgScenario,
  _CentralPurchaseContractTP.PurchaseContractType AS PurchaseContractType,
  _CentralPurchaseContractTP.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _CntrlPurContrItmCnsmpnPct.ContractConsumptionInPct AS ContractConsumptionInPct,
  _CntrlPurContrItmCnsmpnPct.CntrlPurContrGRConsumptionPct AS CntrlPurContrGRConsumptionPct,
  _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName,
  _PurgDocItemRenegttnStsText.PurgDocItmRenegotiationStsDesc AS PurgDocItmRenegotiationStsDesc,
  _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnDesc AS PurgDocItmBlkRsnDesc,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName
FROM I_CntrlPurchaseContractItemTP
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrDistributionTP AS _CntrlPurContrDistributionTP ON CentralPurchaseContractItem = _CntrlPurContrDistributionTP.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrDistributionTP.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_Purcontracttaxcodevh AS _Purcontracttaxcodevh ON TaxCode = _Purcontracttaxcodevh.TaxCode  -- association [1..*]
LEFT OUTER JOIN C_Mm_ConfirmationControlVH AS _ConfirmationControlVH ON SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrMaterialVH AS _CntrlPurContrMaterialVH ON _CntrlPurContrMaterialVH.Material = PurchasingCentralMaterial AND _CntrlPurContrMaterialVH.MaterialGroup = MaterialGroup AND _CntrlPurContrMaterialVH.MaterialName = PurchaseContractItemText AND _CntrlPurContrMaterialVH.MaterialBaseUnit = OrderQuantityUnit AND _CntrlPurContrMaterialVH.ProcurementHubSourceSystem = ProcmtHubRefcdConnectedSystem  -- association [0..*]
LEFT OUTER JOIN I_PurCtrStockType AS _PurCtrStockType ON StockType = _PurCtrStockType.StockType  -- association [1..1]
LEFT OUTER JOIN C_ContractPrdTypeVH AS _ContractPrdTypeVH ON ProductType = _ContractPrdTypeVH.ProductType  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON PurchasingDocumentItemCategory = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory AND _PurgDocumentItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_Mm_Shipinstructionvaluehelp AS _Mm_Shipinstructionvaluehelp ON _Mm_Shipinstructionvaluehelp.ShippingInstruction = ShippingInstruction  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrItemReleaseHist AS _CntrlPurContrItemReleaseHist ON CentralPurchaseContractItem = _CntrlPurContrItemReleaseHist.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItemReleaseHist.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_CntrlPurContrItmCnsmpnPct AS _CntrlPurContrItmCnsmpnPct ON CentralPurchaseContractItem = _CntrlPurContrItmCnsmpnPct.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCnsmpnPct.CentralPurchaseContract  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrItmCndnValdtyTP AS _CntrlPurContrItmCndnValdtyTP ON CentralPurchaseContractItem = _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrItmCmmdtyQtyTP AS _CntrlPurContrItmCmmdtyQtyTP ON CentralPurchaseContractItem = _CntrlPurContrItmCmmdtyQtyTP.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCmmdtyQtyTP.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN R_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubBackendSrceSystemVH AS _ProcmtHubBackendSrceSystemVH ON _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem = ProcmtHubRefcdConnectedSystem  -- association [1..1]
;