I_PurchaseRequisitionItemAPI01

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 I_PurchaseRequisitionItemAPI01.
-- 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: IPRITMAPI01

CREATE VIEW I_PurchaseRequisitionItemAPI01 AS
SELECT
  I_Purchaserequisitionitem.PurchaseRequisition AS PurchaseRequisition,
  I_Purchaserequisitionitem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_Purchaserequisitionitem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  I_Purchaserequisitionitem.PurchasingDocument AS PurchasingDocument,
  I_Purchaserequisitionitem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_Purchaserequisitionitem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  I_Purchaserequisitionitem.PurchaseRequisitionType AS PurchaseRequisitionType,
  I_Purchaserequisitionitem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  I_Purchaserequisitionitem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_Purchaserequisitionitem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  I_Purchaserequisitionitem.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_Purchaserequisitionitem.Material AS Material,
  I_Purchaserequisitionitem.MaterialGroup AS MaterialGroup,
  I_Purchaserequisitionitem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_Purchaserequisitionitem.RequestedQuantity AS RequestedQuantity,
  I_Purchaserequisitionitem.BaseUnit AS BaseUnit,
  I_Purchaserequisitionitem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  I_Purchaserequisitionitem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  I_Purchaserequisitionitem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_Purchaserequisitionitem.ReleaseCode AS ReleaseCode,
  I_Purchaserequisitionitem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  I_Purchaserequisitionitem.PurchasingOrganization AS PurchasingOrganization,
  I_Purchaserequisitionitem.PurchasingGroup AS PurchasingGroup,
  I_Purchaserequisitionitem.Plant AS Plant,
  I_Purchaserequisitionitem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  I_Purchaserequisitionitem.SupplyingPlant AS SupplyingPlant,
  I_Purchaserequisitionitem.OrderedQuantity AS OrderedQuantity,
  I_Purchaserequisitionitem.PurReqnLimitConsumptionAmt AS PurReqnLimitConsumptionAmt,
  I_Purchaserequisitionitem.DeliveryDate AS DeliveryDate,
  I_Purchaserequisitionitem.PurchaseReqnCreationDate AS PurchaseReqnCreationDate,
  I_Purchaserequisitionitem.CreationDate AS CreationDate,
  I_Purchaserequisitionitem.CreationTime AS CreationTime,
  I_Purchaserequisitionitem.ProcessingStatus AS ProcessingStatus,
  I_Purchaserequisitionitem.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_Purchaserequisitionitem.Supplier AS Supplier,
  I_Purchaserequisitionitem.IsDeleted AS IsDeleted,
  I_Purchaserequisitionitem.FixedSupplier AS FixedSupplier,
  I_Purchaserequisitionitem.RequisitionerName AS RequisitionerName,
  I_Purchaserequisitionitem.CreatedByUser AS CreatedByUser,
  I_Purchaserequisitionitem.PurReqCreationDate AS PurReqCreationDate,
  I_Purchaserequisitionitem.DeliveryAddressID AS DeliveryAddressID,
  I_Purchaserequisitionitem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_Purchaserequisitionitem.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_Purchaserequisitionitem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  I_Purchaserequisitionitem.DelivDateCategory AS DelivDateCategory,
  I_Purchaserequisitionitem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  I_Purchaserequisitionitem.StorageLocation AS StorageLocation,
  I_Purchaserequisitionitem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  I_Purchaserequisitionitem.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  I_Purchaserequisitionitem.PurchaseContract AS PurchaseContract,
  I_Purchaserequisitionitem.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  I_Purchaserequisitionitem.PurchaseContractItem AS PurchaseContractItem,
  I_Purchaserequisitionitem.ConsumptionPosting AS ConsumptionPosting,
  I_Purchaserequisitionitem.PurReqnOrigin AS PurReqnOrigin,
  I_Purchaserequisitionitem.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  I_Purchaserequisitionitem.PurReqnSSPCatalogItem AS PurReqnSSPCatalogItem,
  I_Purchaserequisitionitem.PurReqnSSPCrossCatalogItem AS PurReqnSSPCrossCatalogItem,
  I_Purchaserequisitionitem.IsPurReqnBlocked AS IsPurReqnBlocked,
  I_Purchaserequisitionitem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  I_Purchaserequisitionitem.Language AS Language,
  I_Purchaserequisitionitem.IsClosed AS IsClosed,
  I_Purchaserequisitionitem.Reservation AS Reservation,
  I_Purchaserequisitionitem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  I_Purchaserequisitionitem.ServicePerformer AS ServicePerformer,
  I_Purchaserequisitionitem.ProductType AS ProductType,
  I_Purchaserequisitionitem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  I_Purchaserequisitionitem.ReleaseStrategy AS ReleaseStrategy,
  I_Purchaserequisitionitem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_Purchaserequisitionitem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_Purchaserequisitionitem.CompanyCode AS CompanyCode,
  I_Purchaserequisitionitem.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_Purchaserequisitionitem.Batch AS Batch,
  cast( I_Purchaserequisitionitem.MaterialRevisionLevel as revlv ) AS MaterialRevisionLevel,
  I_Purchaserequisitionitem.MaterialRevisionLevel AS MaterialRevisionLevel_2,
  I_Purchaserequisitionitem.MinRemainingShelfLife AS MinRemainingShelfLife,
  I_Purchaserequisitionitem.ItemNetAmount AS ItemNetAmount,
  I_Purchaserequisitionitem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_Purchaserequisitionitem.InvoiceIsExpected AS InvoiceIsExpected,
  I_Purchaserequisitionitem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  I_Purchaserequisitionitem.RequirementTracking AS RequirementTracking,
  I_Purchaserequisitionitem.MRPArea AS MRPArea,
  I_Purchaserequisitionitem.MRPController AS MRPController,
  I_Purchaserequisitionitem.TaxCode AS TaxCode,
  I_Purchaserequisitionitem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  I_Purchaserequisitionitem.AddressID AS AddressID,
  I_Purchaserequisitionitem.LastChangeDateTime AS LastChangeDateTime,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  I_Purchaserequisitionitem.PurContractForOverallLimit AS PurContractForOverallLimit,
  I_Purchaserequisitionitem.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  I_Purchaserequisitionitem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  I_Purchaserequisitionitem.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  I_Purchaserequisitionitem.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  I_Purchaserequisitionitem.ExtPlantForPurg AS ExtPlantForPurg,
  I_Purchaserequisitionitem.ExtInfoRecordForPurg AS ExtInfoRecordForPurg,
  I_Purchaserequisitionitem.ExtContractItemForPurg AS ExtContractItemForPurg,
  I_Purchaserequisitionitem.ExtContractForPurg AS ExtContractForPurg,
  I_Purchaserequisitionitem.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  I_Purchaserequisitionitem.ExtFixedSupplierForPurg AS ExtFixedSupplierForPurg,
  I_Purchaserequisitionitem.ExtMaterialForPurg AS ExtMaterialForPurg,
  I_Purchaserequisitionitem.IsOutline AS IsOutline,
  I_Purchaserequisitionitem.PurchasingParentItem AS PurchasingParentItem,
  I_Purchaserequisitionitem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  I_Purchaserequisitionitem.PurgExternalSortNumber AS PurgExternalSortNumber,
  I_Purchaserequisitionitem.IsPurReqnCmplt AS IsPurReqnCmplt,
  I_Purchaserequisitionitem.PurReqnItemBlockingReasonText AS PurReqnItemBlockingReasonText,
  I_Purchaserequisitionitem.InventorySpecialStockType AS InventorySpecialStockType,
  I_Purchaserequisitionitem.QuotaArrangement AS QuotaArrangement,
  I_Purchaserequisitionitem.QuotaArrangementItem AS QuotaArrangementItem,
  I_Purchaserequisitionitem._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  I_Purchaserequisitionitem._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  I_Purchaserequisitionitem._Supplier.SupplierFullName AS FixedSupplierName,
  I_Purchaserequisitionitem._DesiredSupplier.SupplierFullName AS SupplierName
FROM I_Purchaserequisitionitem
LEFT OUTER JOIN I_PurchaseRequisitionAPI01 AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_PurReqnAcctAssgmtAPI01 AS _PurReqnAcctAssgmt ON PurchaseRequisition = _PurReqnAcctAssgmt.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAcctAssgmt.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _Extension ON PurchaseRequisition = _Extension.PurchaseRequisition AND PurchaseRequisitionItem = _Extension.PurchaseRequisitionItem  -- association [0..1]
;