C_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 C_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 C_PPS_ProcPurReqnItemTP AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingIsItemSet,
  PurchasingParentItem,
  PurReqnItemOutlineType,
  PPSFormattedPurReqnItm,
  PurchaseOrderUUID,
  PurchaseContractUUID,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurReqnReleaseStatus,
  PPSPurReqnItemStatus,
  PurchaseRequisitionType,
  _PurchasingDocumentTypeText[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingDocumentItemCategory,
  _PurgDocumentItemCategoryText.PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  ProductTypeCode,
  _ProductTypeCodeText.Name AS ProductTypeName,
  PurchaseRequisitionItemText,
  AccountAssignmentCategory,
  PPSPurReqnItemCompletionStatus,
  _ItmCompltnStsText[1:Language = $session.system_language].PPSPurReqnItmCompltnStatusText AS PPSPurReqnItmCompltnStatusText,
  PPSPurReqnItemProcessingStatus,
  _ItmProcgStatusText[1:Language = $session.system_language].PPSPurReqnItemProcgStatusText AS PPSPurReqnItemProcgStatusText,
  PPSResponsiblePurchaser,
  _BusinessUser.PersonFullName AS PPSResponsiblePurchaserName,
  _PurReqnHeaderExtension.PPSSmartNumberHeader AS PPSSmartNumberHeader,
  PPSSmartNumberItem,
  _PurReqnHeaderExtension.PPSPurgDocClassfctnCode AS PPSPurgDocClassfctnCode,
  _PurReqnItemExtension.PPSEstimatedDeliveryDate AS PPSEstimatedDeliveryDate,
  _PurReqnItemExtension.PPSConfigurableLineItemNumber AS PPSConfigurableLineItemNumber,
  _PurReqnItemExtension.PPSPurReqnItemApprovalDate AS PPSPurReqnItemApprovalDate,
  _PurReqnItemExtension.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PurReqnItemExtension.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  CompanyCode,
  _PurchaseReqnReleaseStatus.DomainText AS PurReqnReleaseStatusName,
  Material,
  ManufacturerMaterial,
  _MaterialText[1:Language = $session.system_language].MaterialName AS MaterialName,
  ManufacturerPartProfile,
  ManufacturerPartNmbr,
  MaterialGroup,
  _MaterialGroupText[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  PurchasingDocumentCategory,
  RequestedQuantity,
  OrderedQuantity,
  BaseUnit,
  virtual OpenQuantity : abap.quan( 13, 3 ) AS quan133,
  PurReqnPriceQuantity,
  MaterialGoodsReceiptDuration,
  ReleaseCode,
  PurchaseRequisitionReleaseDate,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  Plant,
  _Plant.PlantName AS PlantName,
  SourceOfSupplyIsAssigned,
  SupplyingPlant,
  DeliveryDate,
  CreationDate,
  ProcessingStatus,
  PurchasingInfoRecord,
  PurgDocumentItemDeletionCode,
  FixedSupplier AS Supplier,
  _Supplier.SupplierName AS FixedSupplierName,
  RequisitionerName,
  PurReqnSSPRequestor,
  CreatedByUser,
  PurReqCreationDate,
  ManualDeliveryAddressID,
  ItemDeliveryAddressID,
  PurReqnItemCurrency,
  PurReqnLmtConsumptionCurrency,
  MaterialPlannedDeliveryDurn,
  DelivDateCategory,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  StorageLocation,
  PurchaseContract,
  PurReqnSourceOfSupplyType,
  PurchaseContractItem,
  ConsumptionPosting,
  PurReqnOrigin,
  _ItmPurReqnOriginText[1:Language = $session.system_language].PurReqnOriginDesc AS PurReqnOriginDesc,
  PurReqnItemBlockingStatus,
  Language,
  IsClosed,
  ReleaseIsNotCompleted,
  ServicePerformer,
  PurchaseRequisitionStatus,
  ReleaseStrategy,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  SupplierMaterialNumber,
  Batch,
  MaterialRevisionLevel,
  MinRemainingShelfLife,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  RequirementTracking,
  MRPController,
  TaxCode,
  PurchaseRequisitionIsFixed,
  PurchasingDocumentSubtype,
  PFMTransDataFootprintUUID,
  PurContractForOverallLimit,
  PurchaseReqnItemUniqueID,
  PurchaseOrder,
  IsPurReqnOvrlRel,
  PurReqnCatalog,
  PurReqnCatalogItem,
  PurReqnDescription,
  virtual PPSSrceOfSupDocSemanticObject : abap.char( 30 ) AS char30,
  _PurContractHdrExtension.PPSSmartDocumentNumber AS PPSSrceOfSupSmartDocumentNmbr,
  SourceDocument,
  PurchasingSourceType,
  _PurchaseReqnSourceType.PurchasingSourceTypeDesc AS PurchasingSourceTypeDesc,
  ItemNetAmount,
  ExternalApprovalStatus,
  / _MaterialText AS _MaterialText
FROM R_PPS_ProcPurReqnItemTP
LEFT OUTER JOIN C_PPS_SupplierDetail AS _SupplierDetail ON Supplier = _SupplierDetail.Supplier  -- association [1..1]
;