R_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 R_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: RPURREQNITM

CREATE VIEW R_PurchaseReqnItem AS
SELECT
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurchasingDocument AS PurchasingDocument,
  Document.PurchasingDocumentItem AS PurchasingDocumentItem,
  Document.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  Document.PurchaseRequisitionType AS PurchaseRequisitionType,
  Document.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  Document.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.Material AS Material,
  Document.ManufacturerMaterial AS ManufacturerMaterial,
  Document.ManufacturerPartProfile AS ManufacturerPartProfile,
  Document.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  Document.MaterialGroup AS MaterialGroup,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.IsOutline AS IsOutline,
  Document.PurchasingParentItem AS PurchasingParentItem,
  Document.PurReqnItemOutlineType AS PurReqnItemOutlineType,
  Document.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  Document.PurgExternalSortNumber AS PurgExternalSortNumber,
  Document.RequestedQuantity AS RequestedQuantity,
  Document.BaseUnit AS BaseUnit,
  Document.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  Document.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  Document.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  Document.ReleaseCode AS ReleaseCode,
  Document.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Plant AS Plant,
  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,
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.Supplier AS Supplier,
  Document.IsDeleted AS IsDeleted,
  Document.FixedSupplier AS FixedSupplier,
  Document.RequisitionerName AS RequisitionerName,
  Document.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  Document.CreatedByUser AS CreatedByUser,
  _User.UserDescription AS UserDescription,
  Document.PurReqCreationDate AS PurReqCreationDate,
  Document.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  Document.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  Document.Subcontractor AS Subcontractor,
  Document.PurReqnReceivingCustomer AS PurReqnReceivingCustomer,
  Document.PurchasingDeliveryAddressType AS PurchasingDeliveryAddressType,
  case when Document.ManualDeliveryAddressID <> '' then Document.ManualDeliveryAddressID when Document.ItemDeliveryAddressID <> '' then Document.ItemDeliveryAddressID when Document.Subcontractor <> '' then _Supplier.AddressID when Document.PurReqnReceivingCustomer <> '' then _Customer.AddressID when Document.ManualDeliveryAddressID = '' and Document.ItemDeliveryAddressID = '' and Subcontractor = '' and PurReqnReceivingCustomer = '' and PurchasingDocumentItemCategory <> '5' then _Plant.AddressID else '' end as DeliveryAddressID AS AddressIDelseendasDeliveryAddressID,
  Document.PurReqnItemCurrency AS PurReqnItemCurrency,
  Document.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  Document.DelivDateCategory AS DelivDateCategory,
  Document.StorageLocation AS StorageLocation,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.ConsumptionPosting AS ConsumptionPosting,
  Document.PurReqnOrigin AS PurReqnOrigin,
  Document.IsPurReqnBlocked AS PurReqnItemBlockingStatus,
  Document.Language AS Language,
  Document.IsClosed AS IsClosed,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.ServicePerformer AS ServicePerformer,
  Document.ProductType AS ProductTypeCode,
  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,
  Document.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  Document.InvoiceIsExpected AS InvoiceIsExpected,
  Document.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  Document.RequirementTracking AS RequirementTracking,
  Document.MRPController AS MRPController,
  Document.TaxCode AS TaxCode,
  Document.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  Document.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  Document.PFMTransDataFootprintUUID AS PFMTransDataFootprintUUID,
  Document.PurReqnSSPCatalog AS PurReqnCatalog,
  Document.PurReqnSSPCatalogItem AS PurReqnCatalogItem,
  Document.PurReqnSSPCrossCatalogItem AS PurReqnCrossCatalogItem,
  Document.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  Document.OverallLimitAmount AS OverallLimitAmount,
  Document.PurContractForOverallLimit AS PurContractForOverallLimit,
  Document.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  Document.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  Document.ExternalApprovalStatus AS ExternalApprovalStatus,
  Document.CommitmentItemShortID AS CommitmentItemShortID,
  Document.FundsCenter AS FundsCenter,
  Document.Fund AS Fund,
  Document.GrantID AS GrantID,
  Document.FunctionalArea AS FunctionalArea,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.CostCenter AS CostCenter,
  Document.GLAccount AS GLAccount,
  cast ('00000000' as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  Document.FundedProgram AS FundedProgram,
  Document.ItemNetAmount AS ItemNetAmount,
  Document.CompanyCode AS CompanyCode
FROM I_Purchaserequisitionitem AS Document
LEFT OUTER JOIN I_PurchaseReqn AS _PurchaseReqn ON PurchaseRequisition = _PurchaseReqn.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_PurchaseReqnAcctAssgmt AS _PurchaseReqnAcctAssgmt ON PurchaseRequisition = _PurchaseReqnAcctAssgmt.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseReqnAcctAssgmt.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN I_PurchaseReqnDeliveryAddress AS _PurchaseReqnDeliveryAddress ON _PurchaseReqnDeliveryAddress.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnDeliveryAddress.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseReqnItemText AS _PurchaseReqnItemText ON _PurchaseReqnItemText.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemText.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON FixedSupplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON PurReqnReceivingCustomer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_StorageLocationAddress AS _StorageLocationAddress ON Plant = _StorageLocationAddress.Plant AND StorageLocation = _StorageLocationAddress.StorageLocation AND ItemDeliveryAddressID = _StorageLocationAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON PurReqnItemCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccAssgnmtCategory ON AccountAssignmentCategory = _AccAssgnmtCategory.AccountAssignmentCategory  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecord AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;