C_CntrlPurContrHierItemTP

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_CntrlPurContrHierItemTP.
-- 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: CPCHIERITM

CREATE VIEW C_CntrlPurContrHierItemTP AS
SELECT
  CentralPurchaseContractItem,
  CentralPurchaseContract,
  _CentralPurchaseContract.ActivePurchasingDocument AS ActivePurchasingDocument,
  _CentralPurchaseContract.PurchasingDocumentName AS PurchasingDocumentName,
  _CentralPurchaseContract.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  _CentralPurchaseContractTP.PurchaseContractType AS PurchaseContractType,
  _CentralPurchaseContractTP.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingDocumentItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  PurchasingCentralMaterial,
  Material,
  PurchaseContractItemText,
  ContractNetPriceAmount,
  OrderPriceUnit,
  VolumeUnit,
  OrderQuantityUnit,
  MaterialGroup,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  ManualDeliveryAddressID,
  Plant,
  StorageLocation,
  AccountAssignmentCategory,
  GoodsReceiptIsExpected,
  NetPriceQuantity,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  TargetQuantity,
  TargetAmount,
  CntrlPurContrItmTargetAmount,
  DocumentCurrency,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  SupplierMaterialNumber,
  EvaldRcptSettlmtIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  SupplierConfirmationControlKey,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  PlannedDeliveryDurationInDays,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurgDocPriceDate,
  IsInfoRecordUpdated AS PurchasingInfoRecordUpdateCode,
  _CntrlPurContrHierItmCnsmpn.CntrlPurContractGRQuantity AS CntrlPurContractGRQuantity,
  _CntrlPurContrHierItmCnsmpn.CntrlPurContractGRAmount AS CntrlPurContractGRAmount,
  _CntrlPurContrHierItmCnsmpn.CntrlPurContrInvcRcptQuantity AS CntrlPurContrInvcRcptQuantity,
  _CntrlPurContrHierItmCnsmpn.CntrlPurContrInvcRcptAmount AS CntrlPurContrInvcRcptAmount,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  PurgDocEstimatedPrice AS PurchasingPriceIsEstimated,
  IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  StockType,
  TaxCode,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  ProductType,
  MaterialType,
  FormattedPurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  TextIsDeleted,
  PurchasingContractDeletionCode,
  OutlineAgrmtItmBlockedText,
  PurgDocItmBlkRsnCode,
  PurgDocItemRenegotiationStatus,
  _PurgDocItemRenegttnStsText.PurgDocItmRenegotiationStsDesc AS PurgDocItmRenegotiationStsDesc,
  _CntrlPurContrHierItmCnsmpn.ContractConsumptionInPct AS ContractConsumptionInPct,
  _CntrlPurContrHierItmCnsmpn.CntrlPurContrGRConsumptionPct AS CntrlPurContrGRConsumptionPct,
  _CntrlPurContrHierItmCnsmpn.CntrlPurContrInvcRcptCnsmpnPct AS CntrlPurContrInvcRcptCnsmpnPct,
  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,
  _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnDesc AS PurgDocItmBlkRsnDesc
FROM I_CntrlPurchaseContractItemTP AS CntrlPurchaseContractItemTP
LEFT OUTER JOIN C_CntrlPurContrHierHdrTP AS _CentralPurchaseContractTP ON CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrHierItemDistrTP AS _CntrlPurContrDistributionTP ON CentralPurchaseContractItem = _CntrlPurContrDistributionTP.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrDistributionTP.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_CPurConHierItmCndnValdtyTP AS _CntrlPurContrItmCndnValdtyTP ON CentralPurchaseContractItem = _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_CPurConHierItmCmmdtyQtyTP AS _CntrlPurContrItmCmmdtyQtyTP ON CentralPurchaseContractItem = _CntrlPurContrItmCmmdtyQtyTP.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCmmdtyQtyTP.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  -- 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_CntrlPurContrHierItmCnsmpn AS _CntrlPurContrHierItmCnsmpn ON CentralPurchaseContractItem = _CntrlPurContrHierItmCnsmpn.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrHierItmCnsmpn.CentralPurchaseContract  -- association [0..1]
LEFT OUTER JOIN R_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_PurgDocItmBlkRsnCodesVH AS _PurgDocItmBlkRsnCodesVH ON PurgDocItmBlkRsnCode = _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnCode AND _PurgDocItmBlkRsnCodesVH.Language = $session.system_language  -- association [1..1]
;