P_PurchaseReqnItem

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_PurchaseReqnItem.
-- 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: PPURREQNITM

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