R_PPS_ProcPurReqnItemTP

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 R_PPS_ProcPurReqnItemTP.
-- 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.

CREATE VIEW R_PPS_ProcPurReqnItemTP AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  cast ( concat_with_space( concat( ltrim( PurchaseRequisition, '0' ), ' /' ), ltrim( PurchaseRequisitionItem , '0' ), 1 ) as pps_pr_frmtd_itm ) AS PPSFormattedPurReqnItm,
  cast ( hextobin( '00000000000000000000000000000000' ) as sysuuid_x16 ) AS PurchaseOrderUUID,
  cast ( hextobin( '00000000000000000000000000000000' ) as sysuuid_x16 ) AS PurchaseContractUUID,
  cast ( '' as ebeln ) AS PurchaseOrder,
  PurchasingIsItemSet,
  PurchasingParentItem,
  PurReqnItemOutlineType,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber,
  _PurReqnItemExtension.PPSPurReqnItemCompletionStatus AS PPSPurReqnItemCompletionStatus,
  _PurReqnItemExtension.PPSPurReqnItemProcessingStatus AS PPSPurReqnItemProcessingStatus,
  _PurReqnItemExtension.PPSSmartNumberItem AS PPSSmartNumberItem,
  _PurReqnItemExtension.PPSResponsiblePurchaser AS PPSResponsiblePurchaser,
  _PurReqnItemExtension.PPSPurReqnSourcingType AS PPSPurReqnSourcingType,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurReqnReleaseStatus,
  PurchaseRequisitionType,
  PurchasingDocumentItemCategory,
  PurchaseRequisitionItemText,
  AccountAssignmentCategory,
  Material,
  ManufacturerMaterial,
  ManufacturerPartProfile,
  ManufacturerPartNmbr,
  MaterialGroup,
  PurchasingDocumentCategory,
  RequestedQuantity,
  OrderedQuantity,
  BaseUnit,
  PurReqnPriceQuantity,
  MaterialGoodsReceiptDuration,
  ReleaseCode,
  PurchaseRequisitionReleaseDate,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  SourceOfSupplyIsAssigned,
  SupplyingPlant,
  DeliveryDate,
  CreationDate,
  ProcessingStatus,
  PurchasingInfoRecord,
  PurgDocumentItemDeletionCode,
  FixedSupplier,
  _Supplier.SupplierName AS FixedSupplierName,
  RequisitionerName,
  PurReqnSSPRequestor,
  CreatedByUser,
  PurReqCreationDate,
  ManualDeliveryAddressID,
  ItemDeliveryAddressID,
  DeliveryAddressID,
  PurReqnItemCurrency,
  PurReqnItemCurrency AS PurReqnLmtConsumptionCurrency,
  PurReqnItemCurrency AS Currency,
  MaterialPlannedDeliveryDurn,
  DelivDateCategory,
  StorageLocation,
  PurchaseContract,
  PurReqnSourceOfSupplyType,
  PurchaseContractItem,
  ConsumptionPosting,
  PurReqnOrigin,
  PurReqnItemBlockingStatus,
  Language,
  IsClosed,
  ReleaseIsNotCompleted,
  ServicePerformer,
  ProductTypeCode,
  PurchaseRequisitionStatus,
  ReleaseStrategy,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  SupplierMaterialNumber,
  Batch,
  MaterialRevisionLevel,
  MinRemainingShelfLife,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  RequirementTracking,
  MRPController,
  TaxCode,
  PurchaseRequisitionIsFixed,
  PurchasingDocumentSubtype,
  PFMTransDataFootprintUUID,
  PurContractForOverallLimit,
  PurchaseReqnItemUniqueID,
  PurchaseOrderPriceType,
  IsPurReqnOvrlRel,
  CompanyCode,
  ItemNetAmount,
  ExternalApprovalStatus,
  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
FROM R_PPS_ProcPurReqnItemHN
LEFT OUTER JOIN R_PPS_ProcPurReqnItemTP AS _Parent ON PurchaseRequisition = _Parent.PurchaseRequisition AND PurchasingParentItem = _Parent.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchaseRequisitionType = _PurchasingDocumentTypeText.PurchasingDocumentType AND Language = _PurchasingDocumentTypeText.Language AND PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurReqnItemExtension AS _PurReqnItemExtension ON PurchaseRequisition = _PurReqnItemExtension.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnItemExtension.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurReqnHeaderExtension AS _PurReqnHeaderExtension ON PurchaseRequisition = _PurReqnHeaderExtension.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurContractHdrExtension AS _PurContractHdrExtension ON PurchaseContract = _PurContractHdrExtension.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurReqnItmProcgStatusTxt AS _ItmProcgStatusText ON ppspurreqnitemprocessingstatus = _ItmProcgStatusText.PPSPurReqnItemProcessingStatus  -- association [0..*]
LEFT OUTER JOIN I_BusinessUser AS _BusinessUser ON ppsresponsiblepurchaser = _BusinessUser.BusinessPartner AND _BusinessUser.IsBusinessPurposeCompleted = ''  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurReqnItmCompltnStsTxt AS _ItmCompltnStsText ON ppspurreqnitemcompletionstatus = _ItmCompltnStsText.PPSPurReqnItemCompletionStatus  -- association [0..*]
LEFT OUTER JOIN I_PPS_PurchaseReqnSourceType AS _PurchaseReqnSourceType ON _PurchaseReqnSourceType.PurchasingSourceType = PurchasingSourceType  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurReqnReleaseStatus AS _PurchaseReqnReleaseStatus ON PurReqnReleaseStatus = _PurchaseReqnReleaseStatus.DomainValue  -- association [1..1]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _PurchaseReqnItemExtension ON _PurchaseReqnItemExtension.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemExtension.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
;