C_PurchaseRequisitionItemDEX

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_PurchaseRequisitionItemDEX.
-- 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: CMMPRITMDEX

CREATE VIEW C_PurchaseRequisitionItemDEX AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseReqnItemUniqueID,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurReqnReleaseStatus,
  PurchaseRequisitionType,
  PurchasingDocumentSubtype,
  PurchasingDocumentItemCategory,
  PurchaseRequisitionItemText,
  AccountAssignmentCategory,
  Material,
  MaterialGroup,
  PurchasingDocumentCategory,
  PurchaseRequisitionPrice,
  MaterialGoodsReceiptDuration,
  ReleaseCode,
  PurchaseRequisitionReleaseDate,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  SourceOfSupplyIsAssigned,
  SupplyingPlant,
  PurReqnLimitConsumptionAmt,
  DeliveryDate,
  CreationDate,
  ProcessingStatus,
  PurchasingInfoRecord,
  Supplier,
  IsDeleted,
  FixedSupplier,
  RequisitionerName,
  CreatedByUser,
  PurReqCreationDate,
  cast ( DeliveryAddressID as adrn2_ll preserving type) AS DeliveryAddressID,
  ManualDeliveryAddressID,
  PurReqnItemCurrency,
  MaterialPlannedDeliveryDurn,
  DelivDateCategory,
  MultipleAcctAssgmtDistribution,
  StorageLocation,
  PurReqnSSPRequestor,
  PurReqnSSPAuthor,
  PurchaseContract,
  PurReqnSourceOfSupplyType,
  PurchaseContractItem,
  ConsumptionPosting,
  PurReqnOrigin,
  PurReqnSSPCatalog,
  PurReqnSSPCatalogItem,
  PurReqnSSPCrossCatalogItem,
  IsPurReqnBlocked,
  ItemDeliveryAddressID,
  Language,
  IsClosed,
  ReleaseIsNotCompleted,
  ServicePerformer,
  cast(ProductType as abap.char(4)) AS ProductType,
  PurchaseRequisitionStatus,
  ReleaseStrategy,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  CompanyCode,
  SupplierMaterialNumber,
  Batch,
  MaterialRevisionLevel_2 AS MaterialRevisionLevel,
  MinRemainingShelfLife,
  ItemNetAmount,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  RequirementTracking,
  MRPController,
  TaxCode,
  PurchaseRequisitionIsFixed,
  AddressID,
  LastChangeDateTime,
  ProcurementHubSourceSystem,
  ExtPurgOrgForPurg,
  ExtCompanyCodeForPurg,
  ExtPlantForPurg,
  ExtInfoRecordForPurg,
  ExtContractItemForPurg,
  ExtContractForPurg,
  ExtDesiredSupplierForPurg,
  ExtFixedSupplierForPurg,
  ExtMaterialForPurg,
  RequestedQuantity,
  PurReqnPriceQuantity,
  BaseUnit,
  IsPurReqnCmplt,
  PurReqnItemBlockingReasonText,
  InventorySpecialStockType,
  QuotaArrangement,
  QuotaArrangementItem
FROM I_PurchaseRequisitionItemAPI01
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchaseRequisitionType = _PurchasingDocumentType.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON MaterialGroup = _ProductGroup.ProductGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingObjectCategory AS _PurchasingObjectCategory ON PurchasingDocumentCategory = _PurchasingObjectCategory.PurchasingDocumentCategory  -- 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 [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _FixedSupplier ON FixedSupplier = _FixedSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _DeliveryAddress ON DeliveryAddressID = _DeliveryAddress.AddressID AND _DeliveryAddress.AddressPersonID = '' AND _DeliveryAddress.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _ManualDeliveryAddress ON ManualDeliveryAddressID = _ManualDeliveryAddress.AddressID AND _ManualDeliveryAddress.AddressPersonID = '' AND _ManualDeliveryAddress.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON PurReqnItemCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _ItemDeliveryAddress ON ItemDeliveryAddressID = _ItemDeliveryAddress.AddressID AND _ItemDeliveryAddress.AddressPersonID = '' AND _ItemDeliveryAddress.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON ServicePerformer = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductTypeCode ON ProductType = _ProductTypeCode.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _Address ON AddressID = _Address.AddressID AND _Address.AddressPersonID = '' AND _Address.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN C_PurchaseContractDEX AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_PurchaseContractItemDEX AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract AND PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_PurchasingInfoRecordDEX AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [1..1]
;