P_PPS_PurchaseRequisitionItem

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 P_PPS_PurchaseRequisitionItem.
-- 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: PPSPPURREQNITM

CREATE VIEW P_PPS_PurchaseRequisitionItem AS
SELECT
  R_PPS_PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  R_PPS_PurchaseRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  R_PPS_PurchaseRequisitionItem.PurchasingDocument AS PurchasingDocument,
  R_PPS_PurchaseRequisitionItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  R_PPS_PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  R_PPS_PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  R_PPS_PurchaseRequisitionItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  R_PPS_PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  R_PPS_PurchaseRequisitionItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  R_PPS_PurchaseRequisitionItem.Material AS Material,
  R_PPS_PurchaseRequisitionItem.ManufacturerMaterial AS ManufacturerMaterial,
  R_PPS_PurchaseRequisitionItem.ManufacturerPartProfile AS ManufacturerPartProfile,
  R_PPS_PurchaseRequisitionItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  R_PPS_PurchaseRequisitionItem.MaterialGroup AS MaterialGroup,
  R_PPS_PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  R_PPS_PurchaseRequisitionItem.IsOutline AS IsOutline,
  R_PPS_PurchaseRequisitionItem.PurchasingParentItem AS PurchasingParentItem,
  R_PPS_PurchaseRequisitionItem.PurReqnItemOutlineType AS PurReqnItemOutlineType,
  R_PPS_PurchaseRequisitionItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  R_PPS_PurchaseRequisitionItem.PurgExternalSortNumber AS PurgExternalSortNumber,
  R_PPS_PurchaseRequisitionItem.RequestedQuantity AS RequestedQuantity,
  R_PPS_PurchaseRequisitionItem.BaseUnit AS BaseUnit,
  R_PPS_PurchaseRequisitionItem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  R_PPS_PurchaseRequisitionItem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  R_PPS_PurchaseRequisitionItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  R_PPS_PurchaseRequisitionItem.ReleaseCode AS ReleaseCode,
  R_PPS_PurchaseRequisitionItem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  R_PPS_PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  R_PPS_PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
  R_PPS_PurchaseRequisitionItem.Plant AS Plant,
  R_PPS_PurchaseRequisitionItem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  R_PPS_PurchaseRequisitionItem.SupplyingPlant AS SupplyingPlant,
  R_PPS_PurchaseRequisitionItem.OrderedQuantity AS OrderedQuantity,
  R_PPS_PurchaseRequisitionItem.PurReqnLimitConsumptionAmt AS PurReqnLimitConsumptionAmt,
  R_PPS_PurchaseRequisitionItem.DeliveryDate AS DeliveryDate,
  R_PPS_PurchaseRequisitionItem.CreationDate AS CreationDate,
  R_PPS_PurchaseRequisitionItem.ProcessingStatus AS ProcessingStatus,
  R_PPS_PurchaseRequisitionItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  R_PPS_PurchaseRequisitionItem.Supplier AS Supplier,
  R_PPS_PurchaseRequisitionItem.IsDeleted AS IsDeleted,
  R_PPS_PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
  R_PPS_PurchaseRequisitionItem.RequisitionerName AS RequisitionerName,
  R_PPS_PurchaseRequisitionItem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  R_PPS_PurchaseRequisitionItem.CreatedByUser AS CreatedByUser,
  R_PPS_PurchaseRequisitionItem.UserDescription AS UserDescription,
  R_PPS_PurchaseRequisitionItem.PurReqCreationDate AS PurReqCreationDate,
  R_PPS_PurchaseRequisitionItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  R_PPS_PurchaseRequisitionItem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  R_PPS_PurchaseRequisitionItem.DeliveryAddressID AS DeliveryAddressID,
  R_PPS_PurchaseRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  R_PPS_PurchaseRequisitionItem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  R_PPS_PurchaseRequisitionItem.DelivDateCategory AS DelivDateCategory,
  R_PPS_PurchaseRequisitionItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  R_PPS_PurchaseRequisitionItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  R_PPS_PurchaseRequisitionItem.StorageLocation AS StorageLocation,
  R_PPS_PurchaseRequisitionItem.PurchaseContract AS PurchaseContract,
  R_PPS_PurchaseRequisitionItem.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  R_PPS_PurchaseRequisitionItem.PurchaseContractItem AS PurchaseContractItem,
  R_PPS_PurchaseRequisitionItem.ConsumptionPosting AS ConsumptionPosting,
  R_PPS_PurchaseRequisitionItem.PurReqnOrigin AS PurReqnOrigin,
  R_PPS_PurchaseRequisitionItem.PurReqnItemBlockingStatus AS PurReqnItemBlockingStatus,
  R_PPS_PurchaseRequisitionItem.Language AS Language,
  R_PPS_PurchaseRequisitionItem.IsClosed AS IsClosed,
  R_PPS_PurchaseRequisitionItem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  R_PPS_PurchaseRequisitionItem.ServicePerformer AS ServicePerformer,
  cast ( R_PPS_PurchaseRequisitionItem.ProductTypeCode as product_type ) AS ProductType,
  R_PPS_PurchaseRequisitionItem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  R_PPS_PurchaseRequisitionItem.ReleaseStrategy AS ReleaseStrategy,
  R_PPS_PurchaseRequisitionItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  R_PPS_PurchaseRequisitionItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  R_PPS_PurchaseRequisitionItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  R_PPS_PurchaseRequisitionItem.Batch AS Batch,
  R_PPS_PurchaseRequisitionItem.MaterialRevisionLevel AS MaterialRevisionLevel,
  R_PPS_PurchaseRequisitionItem.MinRemainingShelfLife AS MinRemainingShelfLife,
  R_PPS_PurchaseRequisitionItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  R_PPS_PurchaseRequisitionItem.InvoiceIsExpected AS InvoiceIsExpected,
  R_PPS_PurchaseRequisitionItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  R_PPS_PurchaseRequisitionItem.RequirementTracking AS RequirementTracking,
  R_PPS_PurchaseRequisitionItem.MRPController AS MRPController,
  R_PPS_PurchaseRequisitionItem.TaxCode AS TaxCode,
  R_PPS_PurchaseRequisitionItem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  R_PPS_PurchaseRequisitionItem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  R_PPS_PurchaseRequisitionItem.PFMTransDataFootprintUUID AS PFMTransDataFootprintUUID,
  R_PPS_PurchaseRequisitionItem.PurReqnCatalog AS PurReqnCatalog,
  R_PPS_PurchaseRequisitionItem.PurReqnCatalogItem AS PurReqnCatalogItem,
  R_PPS_PurchaseRequisitionItem.PurReqnCrossCatalogItem AS PurReqnCrossCatalogItem,
  R_PPS_PurchaseRequisitionItem.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  R_PPS_PurchaseRequisitionItem.OverallLimitAmount AS OverallLimitAmount,
  R_PPS_PurchaseRequisitionItem.PurContractForOverallLimit AS PurContractForOverallLimit,
  R_PPS_PurchaseRequisitionItem.LastChangeDateTime AS LastChangeDateTime,
  R_PPS_PurchaseRequisitionItem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  R_PPS_PurchaseRequisitionItem.PurchaseOrderPriceType AS PurchaseOrderPriceType,
  R_PPS_PurchaseRequisitionItem.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  R_PPS_PurchaseRequisitionItem.ExternalApprovalStatus AS ExternalApprovalStatus,
  R_PPS_PurchaseRequisitionItem.ItemNetAmount AS ItemNetAmount,
  R_PPS_PurchaseRequisitionItem.CommitmentItemShortID AS CommitmentItemShortID,
  R_PPS_PurchaseRequisitionItem.FundsCenter AS FundsCenter,
  R_PPS_PurchaseRequisitionItem.Fund AS Fund,
  R_PPS_PurchaseRequisitionItem.GrantID AS GrantID,
  R_PPS_PurchaseRequisitionItem.FunctionalArea AS FunctionalArea,
  R_PPS_PurchaseRequisitionItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  R_PPS_PurchaseRequisitionItem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  R_PPS_PurchaseRequisitionItem.BudgetPeriod AS BudgetPeriod,
  R_PPS_PurchaseRequisitionItem.CostCenter AS CostCenter,
  R_PPS_PurchaseRequisitionItem.GLAccount AS GLAccount,
  R_PPS_PurchaseRequisitionItem.WBSElementInternalID AS WBSElementInternalID,
  R_PPS_PurchaseRequisitionItem.FundedProgram AS FundedProgram,
  R_PPS_PurchaseRequisitionItem._AccAssgmtCategory AS _AccAssgmtCategory,
  R_PPS_PurchaseRequisitionItem._Currency AS _Currency,
  R_PPS_PurchaseRequisitionItem._Material AS _Material,
  R_PPS_PurchaseRequisitionItem._MaterialGroup AS _MaterialGroup,
  R_PPS_PurchaseRequisitionItem._Plant AS _Plant,
  R_PPS_PurchaseRequisitionItem._PurchaseReqn AS _PurchaseReqn,
  R_PPS_PurchaseRequisitionItem._PurchaseReqnAcctAssgmt AS _PurchaseReqnAcctAssgmt,
  R_PPS_PurchaseRequisitionItem._PurchaseReqnDeliveryAddress AS _PurchaseReqnDeliveryAddress,
  R_PPS_PurchaseRequisitionItem._PurchaseReqnItemText AS _PurchaseReqnItemText,
  R_PPS_PurchaseRequisitionItem._PurchasingGroup AS _PurchasingGroup,
  R_PPS_PurchaseRequisitionItem._PurchasingInfoRecord AS _PurchasingInfoRecord,
  R_PPS_PurchaseRequisitionItem._PurchasingOrganization AS _PurchasingOrganization,
  R_PPS_PurchaseRequisitionItem._StorageLocation AS _StorageLocation,
  R_PPS_PurchaseRequisitionItem._Supplier AS _Supplier,
  R_PPS_PurchaseRequisitionItem._DesiredSupplier AS _DesiredSupplier,
  R_PPS_PurchaseRequisitionItem._SupplyingPlant AS _SupplyingPlant,
  R_PPS_PurchaseRequisitionItem._UnitOfMeasure AS _UnitOfMeasure
FROM R_PPS_PurchaseRequisitionItem
;