C_PurchaseReqnItemHierTP

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_PurchaseReqnItemHierTP.
-- 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: CPURREQNHIER

CREATE VIEW C_PurchaseReqnItemHierTP AS
SELECT
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurchasingDocument AS PurchasingDocument,
  Document.PurchasingDocumentItem AS PurchasingDocumentItem,
  Document.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _PurchaseReqnReleaseStatus.DomainText AS PurReqnReleaseStatusDesc,
  Document.ExternalApprovalStatus AS ExternalApprovalStatus,
  _PurReqnExtApprovalStatusText.ExternalApprovalStatusText AS ExternalApprovalStatusText,
  Document.PurchaseRequisitionType AS PurchaseRequisitionType,
  Document.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  Document.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  Document.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  _AccountAssignCatValueHelp.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  Document.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  Document.MaterialGroup AS MaterialGroup,
  _MaterialGroupValueHelp.MaterialGroupName AS MaterialGroupName,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.RequestedQuantity AS RequestedQuantity,
  Document.BaseUnit AS BaseUnit,
  Document.BaseUnit AS ItemUoM,
  _UnitOfMeasureStdVH.UnitOfMeasureLongName AS BaseUnitText,
  Document.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  Document.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  Document.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  Document.ReleaseCode AS ReleaseCode,
  Document.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  Document.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrgValueHelp.PurchasingOrganizationName AS PurchasingOrganizationName,
  Document.PurchasingGroup AS PurchasingGroup,
  _PurchasingGroupValueHelp.PurchasingGroupName AS PurchasingGroupName,
  Document.Plant AS Plant,
  _PlantName.PlantName AS PlantName,
  Document.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  Document.SupplyingPlant AS SupplyingPlant,
  Document.OrderedQuantity AS OrderedQuantity,
  Document.PurReqnLimitConsumptionAmt AS PurReqnLimitConsumptionAmt,
  Document.DeliveryDate AS DeliveryDate,
  Document.CreationDate AS CreationDate,
  Document.ProcessingStatus AS ProcessingStatus,
  _PurReqnProcessingStatus.DomainText AS ProcessingStatusName,
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.Supplier AS Supplier,
  _SupplierName.SupplierName AS SupplierName,
  Document.IsDeleted AS IsDeleted,
  Document.FixedSupplier AS FixedSupplier,
  _FixedSupplier.SupplierName AS FixedSupplierName,
  Document.PurContractForOverallLimit AS PurContractForOverallLimit,
  Document.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  Document.RequisitionerName AS RequisitionerName,
  Document.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  _BusinessUser.PersonFullName AS PersonFullName,
  Document.CreatedByUser AS CreatedByUser,
  Document.UserDescription AS UserDescription,
  Document.PurReqCreationDate AS PurReqCreationDate,
  Document.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  Document.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  Document.DeliveryAddressID AS DeliveryAddressID,
  Document.PurReqnItemCurrency AS PurReqnItemCurrency,
  Document.PurReqnItemCurrency AS PurReqnLmtConsumptionCurrency,
  Document.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  Document.DelivDateCategory AS DelivDateCategory,
  Document.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  Document.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  Document.StorageLocation AS StorageLocation,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.ConsumptionPosting AS ConsumptionPosting,
  Document.PurReqnOrigin AS PurReqnOrigin,
  _PurchaseReqnOrigin.DomainText AS PurReqnOriginDesc,
  Document.IsPurReqnBlocked AS IsPurReqnBlocked,
  _PurReqnBlockedIndicator.PurReqnBlockedIndicatorDesc AS PurReqnBlockedIndicatorDesc,
  Document.Language AS Language,
  Document.IsClosed AS IsClosed,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.ServicePerformer AS ServicePerformer,
  _ServicePerformerValueHelp.ServicePerformerName AS ServicePerformerName,
  Document.ProductType AS ProductType,
  _ProductTypeValueHelp.ProductTypeName AS ProductTypeName,
  Document.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  Document.ReleaseStrategy AS ReleaseStrategy,
  Document.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  Document.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  Document.SupplierMaterialNumber AS SupplierMaterialNumber,
  Document.Batch AS Batch,
  Document.MaterialRevisionLevel AS MaterialRevisionLevel,
  Document.MinRemainingShelfLife AS MinRemainingShelfLife,
  PurReqnItemCurrency AS Currency,
  Document.ItemNetAmount AS ItemNetAmount,
  Document.PurchaseOrderPriceType AS PurchaseOrderPriceType,
  _PurOrdPriceTypeVH.PurchaseOrderPriceTypeDesc AS PurchaseOrderPriceTypeDesc,
  Document.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  Document.InvoiceIsExpected AS InvoiceIsExpected,
  Document.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  Document.RequirementTracking AS RequirementTracking,
  Document.MRPController AS MRPController,
  _MM_MRPCtrlrsValueHelp.MRPControllerName AS MRPControllerName,
  Document.TaxCode AS TaxCode,
  Document._Plant._Address._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  Document.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  Document.PurReqnCatalog AS PurReqnCatalog,
  _ProcCatalogCallDetails.OpnCtlgWebServiceName AS OpnCtlgWebServiceName,
  Document.PurReqnCatalogItem AS PurReqnCatalogItem,
  Document.PurReqnCrossCatalogItem AS PurReqnCrossCatalogItem,
  Document.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  Document.PFMTransDataFootprintUUID AS PFMTransDataFootprintUUID,
  _PurchaseReqnItemCO2eqFprnt.PFMFootprintQuantity AS PFMFootprintQuantity,
  _PurchaseReqnItemCO2eqFprnt.PFMFootprintUnit AS PFMFootprintUnit,
  Document.PurReqnIsPFMFootprintVisible AS PurReqnIsPFMFootprintVisible,
  Document._PurchasingGroup.PhoneNumber AS PhoneNumber,
  Document._PurchasingGroup.FaxNumber AS FaxNumber,
  Document.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  Document.PurReqnIsApplicableForRework AS PurReqnIsApplicableForRework,
  Document.PurReqnReworkCommentText AS PurReqnReworkCommentText,
  Document.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  Document.OverallLimitAmount AS OverallLimitAmount,
  Document.Fund AS Fund,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.FundsCenter AS FundsCenter,
  Document.CommitmentItem AS CommitmentItem,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  Document.GrantID AS GrantID,
  Document.FunctionalArea AS FunctionalArea,
  Document.GLAccount AS GLAccount,
  Document.CostCenter AS CostCenter,
  Document.WBSElement AS WBSElement,
  Document.FundedProgram AS FundedProgram,
  Document.FundMgmtIsActive AS FundMgmtIsActive,
  Document.IsOutline AS IsOutline,
  Document.PurchasingParentItem AS PurchasingParentItem,
  Document.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  Document.PurgExternalSortNumber AS PurgExternalSortNumber,
  Document.HierarchyNode AS HierarchyNode,
  Document.HierarchyParentNode AS HierarchyParentNode,
  Document.HierarchyLevel AS HierarchyLevel,
  Document.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  Document.HierarchyDrillState AS HierarchyDrillState,
  Document.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  Document._Currency AS _Currency,
  Document._PurchasingGroup AS _PurchasingGroup,
  Document._Supplier AS _Supplier,
  Document._UnitOfMeasure AS _UnitOfMeasure,
  Document._Plant AS _Plant
FROM T_PurchaseReqnItem AS Document
LEFT OUTER JOIN C_PurchaseReqnHeader AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_PurchaseReqnAcctAssgmt AS _PurchaseReqnAcctAssgmt ON _PurchaseReqnAcctAssgmt.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnAcctAssgmt.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN C_PurchaseReqnDelivAdd AS _PurchaseReqnDeliveryAddress ON _PurchaseReqnDeliveryAddress.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnDeliveryAddress.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN C_PurReqnReleaseStatus AS _PurchaseReqnReleaseStatus ON _PurchaseReqnReleaseStatus.DomainValue = PurReqnReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_PurReqnExtApprovalStsT AS _PurReqnExtApprovalStatusText ON ExternalApprovalStatus = _PurReqnExtApprovalStatusText.ExternalApprovalStatus  -- association [0..*]
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_PurOrdPriceTypeVH AS _PurOrdPriceTypeVH ON _PurOrdPriceTypeVH.PurchaseOrderPriceType = PurchaseOrderPriceType  -- association [0..1]
LEFT OUTER JOIN C_MM_AccountAssignCatValueHelp AS _AccountAssignCatValueHelp ON _AccountAssignCatValueHelp.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_StorLocValueHelp AS _StorageLocationValueHelp ON _StorageLocationValueHelp.StorageLocation = StorageLocation AND _StorageLocationValueHelp.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantBasicValueHelp AS _PlantName ON _PlantName.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_PurReqnProcessingStatus AS _PurReqnProcessingStatus ON _PurReqnProcessingStatus.DomainValue = ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierName ON _SupplierName.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN C_PurReqnCreationInd AS _PurchaseReqnOrigin ON _PurchaseReqnOrigin.DomainValue = PurReqnOrigin  -- association [0..1]
LEFT OUTER JOIN C_MM_ServicePerformerValueHelp AS _ServicePerformerValueHelp ON _ServicePerformerValueHelp.ServicePerformer = ServicePerformer AND _ServicePerformerValueHelp.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN C_MM_ProductTypeValueHelp AS _ProductTypeValueHelp ON _ProductTypeValueHelp.ProductType = ProductType  -- association [0..1]
LEFT OUTER JOIN C_MM_MatlBatchValueHelp AS _MM_MatlBatchValueHelp ON _MM_MatlBatchValueHelp.Material = Material AND _MM_MatlBatchValueHelp.Batch = Batch  -- association [0..1]
LEFT OUTER JOIN C_MM_RevisionLvlValueHelp AS _MM_RevisionLvlValueHelp ON _MM_RevisionLvlValueHelp.ObjectType = Material AND _MM_RevisionLvlValueHelp.MaterialRevisionLevel = MaterialRevisionLevel  -- association [0..*]
LEFT OUTER JOIN C_MM_MRPCtrlrsValueHelp AS _MM_MRPCtrlrsValueHelp ON _MM_MRPCtrlrsValueHelp.Plant = Plant AND _MM_MRPCtrlrsValueHelp.MRPController = MRPController  -- association [0..1]
LEFT OUTER JOIN C_PurchaseReqnInfoRecordVH AS _PurchaseReqnInfoRecordVH ON Material = _PurchaseReqnInfoRecordVH.Material AND PurchasingOrganization = _PurchaseReqnInfoRecordVH.PurchasingOrganization AND Plant = _PurchaseReqnInfoRecordVH.Plant  -- association [1..*]
LEFT OUTER JOIN C_PurchaseReqnContractVH AS _PurchaseReqnContractVH ON _PurchaseReqnContractVH.Material = Material  -- association [1..*]
LEFT OUTER JOIN C_PurReqnSchedAgrmtVH AS _PurReqnSchedAgrmtVH ON _PurReqnSchedAgrmtVH.Material = Material  -- association [1..*]
LEFT OUTER JOIN I_Supplier AS _FixedSupplier ON _FixedSupplier.Supplier = FixedSupplier  -- association [0..1]
LEFT OUTER JOIN C_MM_TaxCodeValueHelp AS _TaxCodeValueHelp ON _TaxCodeValueHelp.TaxCode = TaxCode AND _TaxCodeValueHelp.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_Proccatalogcalldetails AS _ProcCatalogCallDetails ON _ProcCatalogCallDetails.OpnCtlgWebServiceID = PurReqnCatalog  -- association [0..1]
LEFT OUTER JOIN C_MultiAcctgDistrIndValueAdjVH AS _MltplAcctAssgmtDistrVH ON _MltplAcctAssgmtDistrVH.MultipleAcctAssgmtDistribution = MultipleAcctAssgmtDistribution  -- association [0..1]
LEFT OUTER JOIN C_PartialInvoiceIndVH AS _PartialInvoiceIndVH ON _PartialInvoiceIndVH.PartialInvoiceDistribution = PartialInvoiceDistribution  -- association [0..1]
LEFT OUTER JOIN I_BusinessUser AS _BusinessUser ON _BusinessUser.BPIdentificationNumber = PurReqnSSPRequestor  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFundsStdVH AS _EarmarkedFundsStdVH ON _EarmarkedFundsStdVH.EarmarkedFunds = EarmarkedFundsDocument AND _EarmarkedFundsStdVH.EarmarkedFundsItem = EarmarkedFundsDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureStdVH AS _UnitOfMeasureStdVH ON BaseUnit = _UnitOfMeasureStdVH.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN C_PurchaseReqnItemCO2eqFprnt AS _PurchaseReqnItemCO2eqFprnt ON _PurchaseReqnItemCO2eqFprnt.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemCO2eqFprnt.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_PurReqnBlockedIndicator AS _PurReqnBlockedIndicator ON _PurReqnBlockedIndicator.IsPurReqnBlocked = IsPurReqnBlocked  -- association [0..1]
;