C_PurReqnItemExtTP

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_PurReqnItemExtTP.
-- 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: RPURREQNITEM

CREATE VIEW C_PurReqnItemExtTP AS
SELECT
  ebn1.PurchaseRequisition AS PurchaseRequisition,
  ebn1.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  ebn1.PurchasingDocument AS PurchasingDocument,
  ebn1.PurchasingDocumentItem AS PurchasingDocumentItem,
  ebn1.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  ebn1.PurchaseRequisitionType AS PurchaseRequisitionType,
  ebn1.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurDocItemCategoryValueHelp.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  ebn1.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  ebn1.Material AS Material,
  ebn1.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  ebn1.RequestedQuantity AS RequestedQuantity,
  ebn1.BaseUnit AS BaseUnit,
  ebn1.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  ebn1.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  ebn1.MaterialOrderUnit AS MaterialOrderUnit,
  ebn1.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  ebn1.ReleaseCode AS ReleaseCode,
  ebn1.PurchasingOrganization AS PurchasingOrganization,
  ebn1.PurchasingGroup AS PurchasingGroup,
  ebn1.Plant AS Plant,
  ebn1.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  ebn1.SupplyingPlant AS SupplyingPlant,
  ebn1.OrderedQuantity AS OrderedQuantity,
  ebn1.ProcessingStatus AS ProcessingStatus,
  ebn1.PurchasingInfoRecord AS PurchasingInfoRecord,
  ebn1.Supplier AS Supplier,
  ebn1.IsDeleted AS IsDeleted,
  ebn1.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  ebn1.FixedSupplier AS FixedSupplier,
  ebn1.RequisitionerName AS RequisitionerName,
  ebn1.CreatedByUser AS CreatedByUser,
  _User.UserDescription AS CreatedByUserDescription,
  ebn1.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  _RequestedBy.PersonFullName AS UserDescription,
  ebn1.DeliveryDate AS DeliveryDate,
  ebn1.PurReqCreationDate AS PurReqCreationDate,
  ebn1.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  ebn1.PurReqnItemCurrency AS PurReqnItemCurrency,
  ebn1.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  cast (0 as abap.int4 ) AS PurReqnSourceOfSupplyCount,
  ebn1.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  ebn1.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  ebn1.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  ebn1.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  ebn1.PurchaseContract AS PurchaseContract,
  ebn1.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  ebn1.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,
  _FixedSupplierText.SupplierName AS FixedSupplierName,
  _SupplierText.SupplierName AS SupplierName,
  ebn1.Language AS Language,
  ebn1.MaterialGroup AS MaterialGroup,
  ebn1.IsOutline AS IsOutline,
  ebn1.PurchasingParentItem AS PurchasingParentItem,
  _MaterialText.MaterialName AS MaterialName,
  _Plant.PlantName AS SupplyingPlantName,
  ebn1.AccountAssignmentCategory AS AccountAssignmentCategory,
  _AccAssgnmtCategory.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  ebn1.ConsumptionPosting AS ConsumptionPosting,
  ebn1.DeliveryAddressID AS DeliveryAddressID,
  _Address.AddresseeFullName AS FullName,
  _Address.HouseNumber AS HouseNumber,
  _Address.DistrictName AS DistrictName,
  0 AS NumberOfRecords,
  cast (0000 as abap.int4) AS NumberOfInfoRecords,
  _Address.CityName AS CityName,
  _Address.Country AS Country,
  ebn1.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  ebn1.ItemNetAmount AS PurReqnPrice,
  _ProcessingStatusText.ProcessingStatusName AS ProcessingStatusName,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  ebn1.ProductType AS PurgDocProductType,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  ebn1.PurReqnOrigin AS PurReqnOrigin,
  ebn1.IsPurReqnCmplt AS IsPurReqnCmplt,
  ebn1.PurReqnCmpltnsCat AS PurReqnCmpltnsCat,
  ebn1.IsPurReqnBlocked AS IsPurReqnBlocked,
  ebn1.IsClosed AS IsClosed,
  _PurchaseReqnItemCO2eqFprnt.PFMFootprintQuantity AS PFMFootprintQuantity,
  _PurchaseReqnItemCO2eqFprnt.PFMFootprintUnit AS PFMFootprintUnit,
  ebn1.CompanyCode AS CompanyCode,
  _PurDocItemCategoryValueHelp.PurgDocExternalItemCategory AS PurgDocExternalItemCategory
FROM I_Purchaserequisitionitem AS ebn1
LEFT OUTER JOIN C_PurDocItemCategoryValueHelp AS _PurDocItemCategoryValueHelp ON _PurDocItemCategoryValueHelp.PurchasingDocumentItemCategory = PurchasingDocumentItemCategory AND _PurDocItemCategoryValueHelp.PurgDocExternalItemCategory = PurgDocExternalItemCategory  -- association [0..1]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _Purchaserequisitionitem ON PurchaseRequisition = _Purchaserequisitionitem.PurchaseRequisition AND PurchaseRequisitionItem = _Purchaserequisitionitem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurReqnProcessingStatusVH AS _PurReqnProcessingStatusVH ON ProcessingStatus = _PurReqnProcessingStatusVH.ProcessingStatus  -- association [1..1]
LEFT OUTER JOIN C_PurchaseReqnItemCO2eqFprnt AS _PurchaseReqnItemCO2eqFprnt ON _PurchaseReqnItemCO2eqFprnt.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemCO2eqFprnt.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_RfqBidderVH AS _RFQBidderVH ON FixedSupplier = _RFQBidderVH.Supplier  -- association [0..1]
LEFT OUTER JOIN C_PurReqnProposedSOS AS _PurReqnProposedSOS ON PurchaseRequisition = _PurReqnProposedSOS.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnProposedSOS.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_SupplierContactCard AS _ContactCard ON FixedSupplier = _ContactCard.ContactCardID  -- association [0..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 C_MM_PlantValueHelp AS _PlantValueHelp ON Plant = _PlantValueHelp.Plant  -- association [0..*]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _FixedSupplierValueHelp ON _FixedSupplierValueHelp.Supplier = FixedSupplier  -- association [0..*]
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 ebn1.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON _SupplierText.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _FixedSupplierText ON _FixedSupplierText.Supplier = FixedSupplier  -- association [0..1]
LEFT OUTER JOIN C_PurReqnReqdByUsrVH AS _RequestedBy ON PurReqnSSPRequestor = _RequestedBy.Employee  -- association [0..1]
;