C_PurchaseRequisitionItmDtls

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_PurchaseRequisitionItmDtls.
-- 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: C_MM_PR_LIST

CREATE VIEW C_PurchaseRequisitionItmDtls AS
SELECT
  ebn.PurchaseRequisition AS PurchaseRequisition,
  ebn.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  concat(ebn.PurchaseRequisition, concat('/', ebn.PurchaseRequisitionItem)) AS FormattedPurRequisitionItem,
  ebn.PurchasingDocument AS PurchasingDocument,
  ebn.PurchasingDocumentItem AS PurchasingDocumentItem,
  ebn.PurchaseRequisitionType AS PurchaseRequisitionType,
  ebn.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  ebn.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  ebn.Material AS Material,
  ebn.MaterialGroup AS MaterialGroup,
  ebn.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  ebn.RequestedQuantity AS RequestedQuantity,
  ebn.BaseUnit AS BaseUnit,
  ebn.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  ebn.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  ebn.MaterialOrderUnit AS MaterialOrderUnit,
  ebn.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  ebn.ReleaseCode AS ReleaseCode,
  ebn.PurchasingOrganization AS PurchasingOrganization,
  ebn.PurchasingGroup AS PurchasingGroup,
  ebn.Plant AS Plant,
  ebn.IsOutline AS IsOutline,
  ebn.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  ebn.SupplyingPlant AS SupplyingPlant,
  ebn.OrderedQuantity AS OrderedQuantity,
  ebn.DeliveryDate AS FirstDeliveryDate,
  ebn.DeliveryDate AS DeliveryDate,
  ebn.ProcessingStatus AS ProcessingStatus,
  ebn.PurchasingInfoRecord AS PurchasingInfoRecord,
  ebn.Supplier AS Supplier,
  ebn.IsDeleted AS IsDeleted,
  ebn.FixedSupplier AS FixedSupplier,
  ebn.RequisitionerName AS RequisitionerName,
  ebn.CreatedByUser AS CreatedByUser,
  ebn.PurReqCreationDate AS PurReqCreationDate,
  ebn.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  ebn.PurReqnItemCurrency AS PurReqnItemCurrency,
  ebn.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  ebn.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  ebn.PurchaseContract AS PurchaseContract,
  ebn.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  ebn.PurchaseContractItem AS PurchaseContractItem,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurchasingGroup.PurchasingGroupPhoneNumber AS PurchasingGroupPhoneNumber,
  _PurchasingGroup.PhoneNumber AS PhoneNumber,
  _PurchasingGroup.PhoneNumberExtension AS PhoneNumberExtension,
  _PurchasingGroup.EmailAddress AS EmailAddress,
  _SupplierPRDetails.SupplyingVendorName AS SupplierName,
  _SupplierPRDetails.VendorSearchText AS SupplierSearchText,
  _MaterialGroupText.Language AS Language,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  _MaterialText.MaterialName AS MaterialName,
  _Plant.PlantName AS SupplyingPlantName,
  ebn.AccountAssignmentCategory AS AccountAssignmentCategory,
  _AccAssgnmtCategory.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  ebn.ConsumptionPosting AS ConsumptionPosting,
  ebn.ProductType AS ProductType,
  _Address.AddresseeFullName AS FullName,
  _Address.HouseNumber AS HouseNumber,
  _Address.DistrictName AS District,
  ebn.ItemNetAmount AS PurReqnPrice,
  0 AS NumberOfRecords,
  cast (0000 as abap.int4) AS NumberOfInfoRecords,
  cast( ebn.PurchaseRequisitionReleaseDate as abap.dats) AS DueDays,
  ebn.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  ebn.DeliveryAddressID AS DeliveryAddressID,
  ebn.IsPurReqnCmplt AS IsPurReqnCmplt,
  ebn.PurReqnCmpltnsCat AS PurReqnCmpltnsCat,
  ebn.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  ebn.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  ebn.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  cast (0 as abap.int4 ) AS PurReqnSourceOfSupplyCount,
  _Processingstatustext.ProcessingStatusName AS ProcessingStatusName,
  _Address.CityName AS CityName,
  _Address.Country AS Country,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  _PurchaseReqnTF.PurReqnHasAdvncdUsrInterface AS PurReqnHasAdvncdUsrInterface,
  ebn.PurReqnOrigin AS PurReqnOrigin,
  ebn.CompanyCode AS CompanyCode,
  ebn.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg
FROM I_Purchaserequisitionitem AS ebn
LEFT OUTER JOIN P_SupplierPRDetails AS _SupplierPRDetails ON FixedSupplier = _SupplierPRDetails.Vendor  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON Plant = _PlantValueHelp.Plant  -- association [0..*]
LEFT OUTER JOIN I_PurReqnAcctAssgmt AS _PurReqnAcctAssgmt ON PurchaseRequisition = _PurReqnAcctAssgmt.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAcctAssgmt.PurchaseRequisitionItem  -- association [1..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_AddressDefaultRepresentation AS _Address ON DeliveryAddressID = _Address.AddressID  -- association [1..1]
LEFT OUTER JOIN I_PurchasingInfoRecord AS _PurchasingInfoRecord ON Material = _PurchasingInfoRecord.Material AND MaterialGroup = _PurchasingInfoRecord.MaterialGroup AND BaseUnit = _PurchasingInfoRecord.BaseUnit  -- association [1..*]
LEFT OUTER JOIN I_TextFileInter AS _TextFileInter ON PurchaseRequisition = _TextFileInter.PurchaseRequisition AND PurchaseRequisitionItem = _TextFileInter.PurchaseRequisitionItem  -- association [1..*]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccAssgnmtCategory ON AccountAssignmentCategory = _AccAssgnmtCategory.AccountAssignmentCategory  -- association [1..1]
LEFT OUTER JOIN I_Processingstatustext AS _Processingstatustext ON ProcessingStatus = _Processingstatustext.ProcessingStatus AND _Processingstatustext.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON ebn.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchaseReqnTF AS _PurchaseReqnTF ON PurchaseRequisition = _PurchaseReqnTF.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _FixedSupplierValueHelp ON _FixedSupplierValueHelp.Supplier = FixedSupplier  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
;