C_PurchaseContrItemHierarchyTP

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_PurchaseContrItemHierarchyTP.
-- 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: CCTRMAINTITMHIER

CREATE VIEW C_PurchaseContrItemHierarchyTP AS
SELECT
  PurchaseContractItem._Material._Text[ Language = $session.system_language ].MaterialName AS MaterialName,
  PurchaseContractItem._MaterialGroup._Text[ Language = $session.system_language ].MaterialGroupName AS MaterialGroupName,
  cast ( PurchaseContractItem.ProductType as producttype ) AS ProductType,
  OutlineAgrmtItmBlockedText,
  TextIsDeleted,
  cast( PurchaseContractItem.HierarchyDrillState as abap.char( 22 ) ) AS HierarchyDrillState,
  cast ('' as boolean) AS ProductComplianceIsActive,
  cast ('' as ehfnd_bf_pcs_is_active) AS BusFtreProdCmplncSuplrIsActive,
  PurchasingIsCatalogRelevant,
  PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  PurchaseContractItem.PurchaseContract AS PurchaseContract,
  PurchaseContractItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  PurchaseContractItem.PurchaseContractItemForEdit AS PurchaseContractItemForEdit,
  PurchaseContractItem.CompanyCode AS CompanyCode,
  PurchaseContractItem.PurchaseContractType AS PurchaseContractType,
  PurchaseContractItem.Material AS Material,
  PurchaseContractItem.PurchaseContractItemText AS PurchaseContractItemText,
  PurchaseContractItem.ContractNetPriceAmount AS ContractNetPriceAmount,
  PurchaseContractItem.OrderPriceUnit AS OrderPriceUnit,
  PurchaseContractItem.VolumeUnit AS VolumeUnit,
  PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  PurchaseContractItem.MaterialGroup AS MaterialGroup,
  PurchaseContractItem.Customer AS Customer,
  PurchaseContractItem.Subcontractor AS Subcontractor,
  PurchaseContractItem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  PurchaseContractItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  PurchaseContractItem.Plant AS Plant,
  PurchaseContractItem.StorageLocation AS StorageLocation,
  PurchaseContractItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseContractItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  PurchaseContractItem.NetPriceQuantity AS NetPriceQuantity,
  PurchaseContractItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseContractItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  PurchaseContractItem.TargetQuantity AS TargetQuantity,
  PurchaseContractItem.TargetAmount AS TargetAmount,
  PurchaseContractItem.DocumentCurrency AS DocumentCurrency,
  PurchaseContractItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  PurchaseContractItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  PurchaseContractItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  PurchaseContractItem.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  PurchaseContractItem.PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  PurchaseContractItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  PurchaseContractItem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  PurchaseContractItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  PurchaseContractItem.PriceIsToBePrinted AS PriceIsToBePrinted,
  PurchaseContractItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  PurchaseContractItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  PurchaseContractItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  PurchaseContractItem.IncotermsClassification AS IncotermsClassification,
  PurchaseContractItem.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseContractItem.InvoiceIsExpected AS InvoiceIsExpected,
  PurchaseContractItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  PurchaseContractItem.PurgDocPriceDate AS PurgDocPriceDate,
  PurchaseContractItem.PurgDocReleaseOrderQuantity AS PurgDocReleaseOrderQuantity,
  PurchaseContractItem.ReleaseOrderQuantityUnit AS ReleaseOrderQuantityUnit,
  PurchaseContractItem.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  PurchaseContractItem.IsInfoAtRegistration AS IsInfoAtRegistration,
  PurchaseContractItem.NoDaysReminder1 AS NoDaysReminder1,
  PurchaseContractItem.NoDaysReminder2 AS NoDaysReminder2,
  PurchaseContractItem.NoDaysReminder3 AS NoDaysReminder3,
  PurchaseContractItem.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  PurchaseContractItem.StockType AS StockType,
  PurchaseContractItem.TaxCode AS TaxCode,
  PurchaseContractItem.TaxCountry AS TaxCountry,
  PurchaseContractItem.TaxDeterminationDate AS TaxDeterminationDate,
  PurchaseContractItem.RequirementTracking AS RequirementTracking,
  PurchaseContractItem.IsOrderAcknRqd AS IsOrderAcknRqd,
  PurchaseContractItem.ShippingInstruction AS ShippingInstruction,
  PurchaseContractItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  PurchaseContractItem.ServicePerformer AS ServicePerformer,
  PurchaseContractItem.MaterialType AS MaterialType,
  PurchaseContractItem.PurchasingContractDeletionCode AS PurchasingContractDeletionCode,
  PurchaseContractItem.PurchasingParentItem AS PurchasingParentItem,
  PurchaseContractItem.PurchasingParentItemForEdit AS PurchasingParentItemForEdit,
  PurchaseContractItem.IsStatisticalItem AS IsStatisticalItem,
  PurchaseContractItem.PurgExternalSortNumber AS PurgExternalSortNumber,
  PurchaseContractItem.IsOutline AS IsOutline,
  PurchaseContractItem.HierarchyNode AS HierarchyNode,
  PurchaseContractItem.HierarchyParentNode AS HierarchyParentNode,
  PurchaseContractItem.HierarchyLevel AS HierarchyLevel,
  PurchaseContractItem.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  PurchaseContractItem.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  PurchaseContractItem._Material AS _Material,
  PurchaseContractItem._MaterialGroup AS _MaterialGroup,
  PurchaseContractItem._OrderPriceUnit AS _OrderPriceUnit,
  PurchaseContractItem._OrderQuantityUnit AS _OrderQuantityUnit,
  PurchaseContractItem._StorageLocation AS _StorageLocation,
  _AccountAssignmentCategory.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  _PurchaseContractWD.PurchasingOrganization AS PurchasingOrganization,
  _StorageLocation.StorageLocationName AS StorageLocationName
FROM I_PurchaseContractItemWD AS PurchaseContractItem
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractWD ON PurchaseContract = _PurchaseContractWD.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_Purcontracttaxcodevh AS _Purcontracttaxcodevh ON TaxCode = _Purcontracttaxcodevh.TaxCode  -- association [1..*]
LEFT OUTER JOIN C_MM_ServicePerformerValueHelp AS _ServicePerformerVH ON ServicePerformer = _ServicePerformerVH.ServicePerformer  -- association [0..*]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant AND _PlantValueHelp.PurchasingOrganization = purchasingorganization  -- association [0..1]
LEFT OUTER JOIN I_Contrconfirmationcontrol AS _Purcontractcnfrmctrlvh ON SupplierConfirmationControlKey = _Purcontractcnfrmctrlvh.SupplierConfirmationControlKey  -- association [1..1]
LEFT OUTER JOIN I_PurCtrStockType AS _PurCtrStockType ON StockType = _PurCtrStockType.StockType  -- association [1..1]
LEFT OUTER JOIN C_MltplAcctAssgmtDistrVH AS _MltplAcctAssgmtDistrVH ON MultipleAcctAssgmtDistribution = _MltplAcctAssgmtDistrVH.MultipleAcctAssgmtDistribution  -- association [0..1]
LEFT OUTER JOIN C_PartialGoodsReceiptIndVH AS _PartialGoodsReceiptIndVH ON PartialInvoiceDistribution = _PartialGoodsReceiptIndVH.PartialInvoiceDistribution  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON MaterialGroup = _MaterialGroupValueHelp.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_SourceOfSupply AS _SourceOfSupply ON PurchaseContract = _SourceOfSupply.PurchaseContract AND PurchaseContractItem = _SourceOfSupply.PurchaseContractItem AND Material = _SourceOfSupply.Material AND Plant = _SourceOfSupply.Plant  -- association [0..*]
LEFT OUTER JOIN C_ContractPrdTypeVH AS _ContractPrdTypeVH ON ProductType = _ContractPrdTypeVH.ProductType  -- association [0..1]
LEFT OUTER JOIN C_PurContrItemCategoryVH AS _PurContrItemCategoryVH ON PurchasingDocumentItemCategory = _PurContrItemCategoryVH.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseContractItemExtension ON PurchaseContract = _PurchaseContractItemExtension.PurchasingDocument AND PurchaseContractItem = _PurchaseContractItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PurgProdCmplncSupplierStsT AS _PurgProdCmplncSupplierStsT ON PurgProdCmplncSupplierStatus = _PurgProdCmplncSupplierStsT.PurgProdCmplncSupplierStatus AND _PurgProdCmplncSupplierStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurContrItmCmplncCriticality AS _PurContrItmCmplncCriticality ON PurchaseContract = _PurContrItmCmplncCriticality.PurchaseContract AND PurchaseContractItem = _PurContrItmCmplncCriticality.PurchaseContractItem  -- association [0..1]
;