P_PurReqItemAPIhelper

DDL: P_PURREQITEMAPIHELPER SQL: PPUREQITMAPIHLP Type: view
80 Fields 1 Data Sources 1 Associations

API Helper to get the Employee name

P_PurReqItemAPIhelper is a CDS View that provides data about "API Helper to get the Employee name" in SAP S/4HANA. It reads from 1 data source (I_PurchaseRequisitionItemAPI01) and exposes 80 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Purchase Requisitions
StatusPurchase Requisition Release Status
Purpose
This CDS view is a helper/extension view for the Purchase Requisition Item API that provides additional fields, relationships, or transformations to support the main Purchase Requisition Item API view, especially for analytical queries, OData exposure, or custom extension scenarios.

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: M_BANF_BSA PurchaseRequisitionType in Purchase Order M_BANF_WRK Plant in Purchase Order M_BANF_EKO PurchasingOrganization in Purchase Order M_BANF_EKG PurchasingGroup in Purchase Order

Structure
Business Object This view is built on the Purchase Requisition business object. Important Fields Important fields in this view include the following: Field Name Description PurchaseRequisition Purchase Requisition Number PurchaseRequisitionItem Purchase Requisition Item Number PurchaseReqnItemUniqueID Purchase Requisition Item Unique ID PurchasingDocument Purchasing Document Number PurchasingDocumentItem Purchasing Document Item Number PurReqnReleaseStatus Purchase Requisition Release Status PurchaseRequisitionType Purchase Requisition Type

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_PurchaseRequisitionItemAPI01 _PurchaseRequisitionItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Employee _Employee _Employee.Employee = _PurchaseRequisitionItem.RequisitionerName

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPUREQITMAPIHLP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label API Helper to get the Employee name view
Metadata.ignorePropagatedAnnotations true view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_PurchaseRequisitionItemAPI01 PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_PurchaseRequisitionItemAPI01 PurchaseRequisitionItem Requisn. item
PurchaseReqnItemUniqueID I_PurchaseRequisitionItemAPI01 PurchaseReqnItemUniqueID Purch. Doc. ID
PurchasingDocument I_PurchaseRequisitionItemAPI01 PurchasingDocument Purchasing Document
PurchasingDocumentItem I_PurchaseRequisitionItemAPI01 PurchasingDocumentItem Purchasing Doc. Item
PurReqnReleaseStatus I_PurchaseRequisitionItemAPI01 PurReqnReleaseStatus Proc.state
PurchaseRequisitionType I_PurchaseRequisitionItemAPI01 PurchaseRequisitionType Order Type
PurchasingDocumentSubtype I_PurchaseRequisitionItemAPI01 PurchasingDocumentSubtype Control
PurchasingDocumentItemCategory I_PurchaseRequisitionItemAPI01 PurchasingDocumentItemCategory Item Category
PurchaseRequisitionItemText I_PurchaseRequisitionItemAPI01 PurchaseRequisitionItemText Short Text
AccountAssignmentCategory I_PurchaseRequisitionItemAPI01 AccountAssignmentCategory Acct Assgmt Cat
Material I_PurchaseRequisitionItemAPI01 Material Vehicle Model
MaterialGroup I_PurchaseRequisitionItemAPI01 MaterialGroup Product Group
PurchasingDocumentCategory I_PurchaseRequisitionItemAPI01 PurchasingDocumentCategory Doc. Category
RequestedQuantity I_PurchaseRequisitionItemAPI01 RequestedQuantity Requested Quantity
BaseUnit I_PurchaseRequisitionItemAPI01 BaseUnit Unit of Measure
PurchaseRequisitionPrice I_PurchaseRequisitionItemAPI01 PurchaseRequisitionPrice Valuation Price
PurReqnPriceQuantity I_PurchaseRequisitionItemAPI01 PurReqnPriceQuantity Price unit
MaterialGoodsReceiptDuration I_PurchaseRequisitionItemAPI01 MaterialGoodsReceiptDuration GR proc. time
PurchaseRequisitionReleaseDate I_PurchaseRequisitionItemAPI01 PurchaseRequisitionReleaseDate Release Date
PurchasingOrganization I_PurchaseRequisitionItemAPI01 PurchasingOrganization Purchasing Organization
PurchasingGroup I_PurchaseRequisitionItemAPI01 PurchasingGroup Purchasing Group
Plant I_PurchaseRequisitionItemAPI01 Plant Valuation Area
SourceOfSupplyIsAssigned I_PurchaseRequisitionItemAPI01 SourceOfSupplyIsAssigned Assigned
SupplyingPlant I_PurchaseRequisitionItemAPI01 SupplyingPlant Supplying Plant
OrderedQuantity I_PurchaseRequisitionItemAPI01 OrderedQuantity Quantity
PurReqnLimitConsumptionAmt I_PurchaseRequisitionItemAPI01 PurReqnLimitConsumptionAmt Consumption Value
DeliveryDate I_PurchaseRequisitionItemAPI01 DeliveryDate Delivery Date
CreationDate I_PurchaseRequisitionItemAPI01 CreationDate Time Stamp
ProcessingStatus I_PurchaseRequisitionItemAPI01 ProcessingStatus Worklist Status
PurchasingInfoRecord I_PurchaseRequisitionItemAPI01 PurchasingInfoRecord Info Record
Supplier I_PurchaseRequisitionItemAPI01 Supplier Supplier
FixedSupplier I_PurchaseRequisitionItemAPI01 FixedSupplier Fixed Vendor
RequisitionerName I_PurchaseRequisitionItemAPI01 RequisitionerName Requisitioner
CreatedByUser I_PurchaseRequisitionItemAPI01 CreatedByUser User Name
PurReqCreationDate I_PurchaseRequisitionItemAPI01 PurReqCreationDate Requisn Date
DeliveryAddressID I_PurchaseRequisitionItemAPI01 DeliveryAddressID Address
ManualDeliveryAddressID I_PurchaseRequisitionItemAPI01 ManualDeliveryAddressID Address Number
PurReqnItemCurrency I_PurchaseRequisitionItemAPI01 PurReqnItemCurrency Currency
MaterialPlannedDeliveryDurn I_PurchaseRequisitionItemAPI01 MaterialPlannedDeliveryDurn Pl. Deliv. Time
DelivDateCategory I_PurchaseRequisitionItemAPI01 DelivDateCategory Delivery Date
MultipleAcctAssgmtDistribution I_PurchaseRequisitionItemAPI01 MultipleAcctAssgmtDistribution Distribution
StorageLocation I_PurchaseRequisitionItemAPI01 StorageLocation StorageLocation
PurReqnSSPRequestor I_PurchaseRequisitionItemAPI01 PurReqnSSPRequestor Requestor
PurReqnSSPAuthor I_PurchaseRequisitionItemAPI01 PurReqnSSPAuthor Author
PurchaseContract I_PurchaseRequisitionItemAPI01 PurchaseContract Purchasing Doc.
PurReqnSourceOfSupplyType I_PurchaseRequisitionItemAPI01 PurReqnSourceOfSupplyType Doc. Category
PurchaseContractItem I_PurchaseRequisitionItemAPI01 PurchaseContractItem Item
ConsumptionPosting I_PurchaseRequisitionItemAPI01 ConsumptionPosting Consumption Posting
PurReqnOrigin I_PurchaseRequisitionItemAPI01 PurReqnOrigin Creation ind.
PurReqnSSPCatalog I_PurchaseRequisitionItemAPI01 PurReqnSSPCatalog Web Service ID
PurReqnSSPCatalogItem I_PurchaseRequisitionItemAPI01 PurReqnSSPCatalogItem Catalog Item
PurReqnSSPCrossCatalogItem I_PurchaseRequisitionItemAPI01 PurReqnSSPCrossCatalogItem Catalog item key
IsPurReqnBlocked I_PurchaseRequisitionItemAPI01 IsPurReqnBlocked Blocking Ind.
ItemDeliveryAddressID I_PurchaseRequisitionItemAPI01 ItemDeliveryAddressID Address
Language I_PurchaseRequisitionItemAPI01 Language Report Text Language
IsClosed I_PurchaseRequisitionItemAPI01 IsClosed Closed
ReleaseIsNotCompleted I_PurchaseRequisitionItemAPI01 ReleaseIsNotCompleted Subj.to Release
ServicePerformer I_PurchaseRequisitionItemAPI01 ServicePerformer Service Performer
PurchaseRequisitionStatus I_PurchaseRequisitionItemAPI01 PurchaseRequisitionStatus Release State
PerformancePeriodStartDate I_PurchaseRequisitionItemAPI01 PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate I_PurchaseRequisitionItemAPI01 PerformancePeriodEndDate End of Performance Period
CompanyCode I_PurchaseRequisitionItemAPI01 CompanyCode Receiver Company Code
SupplierMaterialNumber I_PurchaseRequisitionItemAPI01 SupplierMaterialNumber Supp. Mat. No.
Batch I_PurchaseRequisitionItemAPI01 Batch Lot No.
MinRemainingShelfLife I_PurchaseRequisitionItemAPI01 MinRemainingShelfLife Rem. Shelf Life
ItemNetAmount I_PurchaseRequisitionItemAPI01 ItemNetAmount Tot. val. rel.
GoodsReceiptIsExpected I_PurchaseRequisitionItemAPI01 GoodsReceiptIsExpected Goods Receipt
InvoiceIsExpected I_PurchaseRequisitionItemAPI01 InvoiceIsExpected Invoice Receipt
GoodsReceiptIsNonValuated I_PurchaseRequisitionItemAPI01 GoodsReceiptIsNonValuated GR Non-Valuated
RequirementTracking I_PurchaseRequisitionItemAPI01 RequirementTracking Tracking Number
MRPController I_PurchaseRequisitionItemAPI01 MRPController MRP Controller
PurchaseRequisitionIsFixed I_PurchaseRequisitionItemAPI01 PurchaseRequisitionIsFixed "Fixed" ind.
AddressID I_PurchaseRequisitionItemAPI01 AddressID Ship-to address
LastChangeDateTime I_PurchaseRequisitionItemAPI01 LastChangeDateTime Timestamp
PurchasingOrganizationName I_PurchaseRequisitionItemAPI01 PurchasingOrganizationName Purch. Org. Name
PurchasingGroupName I_PurchaseRequisitionItemAPI01 PurchasingGroupName Purchasing Grp. Name
SupplierName I_PurchaseRequisitionItemAPI01 SupplierName Supplier Name
FixedSupplierName I_PurchaseRequisitionItemAPI01 FixedSupplierName Name of Supplier
_Employee _Employee

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 P_PurReqItemAPIhelper.
-- 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: PPUREQITMAPIHLP

CREATE VIEW P_PurReqItemAPIhelper AS
SELECT
  _PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseRequisitionItem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  _PurchaseRequisitionItem.PurchasingDocument AS PurchasingDocument,
  _PurchaseRequisitionItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  _PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  _PurchaseRequisitionItem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PurchaseRequisitionItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PurchaseRequisitionItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurchaseRequisitionItem.Material AS Material,
  _PurchaseRequisitionItem.MaterialGroup AS MaterialGroup,
  _PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseRequisitionItem.RequestedQuantity AS RequestedQuantity,
  _PurchaseRequisitionItem.BaseUnit AS BaseUnit,
  _PurchaseRequisitionItem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _PurchaseRequisitionItem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  _PurchaseRequisitionItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  _PurchaseRequisitionItem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  _PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
  _PurchaseRequisitionItem.Plant AS Plant,
  _PurchaseRequisitionItem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  _PurchaseRequisitionItem.SupplyingPlant AS SupplyingPlant,
  _PurchaseRequisitionItem.OrderedQuantity AS OrderedQuantity,
  _PurchaseRequisitionItem.PurReqnLimitConsumptionAmt AS PurReqnLimitConsumptionAmt,
  _PurchaseRequisitionItem.DeliveryDate AS DeliveryDate,
  _PurchaseRequisitionItem.CreationDate AS CreationDate,
  _PurchaseRequisitionItem.ProcessingStatus AS ProcessingStatus,
  _PurchaseRequisitionItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurchaseRequisitionItem.Supplier AS Supplier,
  _PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
  _PurchaseRequisitionItem.RequisitionerName AS RequisitionerName,
  _PurchaseRequisitionItem.CreatedByUser AS CreatedByUser,
  _PurchaseRequisitionItem.PurReqCreationDate AS PurReqCreationDate,
  _PurchaseRequisitionItem.DeliveryAddressID AS DeliveryAddressID,
  _PurchaseRequisitionItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  _PurchaseRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  _PurchaseRequisitionItem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _PurchaseRequisitionItem.DelivDateCategory AS DelivDateCategory,
  _PurchaseRequisitionItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _PurchaseRequisitionItem.StorageLocation AS StorageLocation,
  _PurchaseRequisitionItem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  _PurchaseRequisitionItem.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  _PurchaseRequisitionItem.PurchaseContract AS PurchaseContract,
  _PurchaseRequisitionItem.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  _PurchaseRequisitionItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseRequisitionItem.ConsumptionPosting AS ConsumptionPosting,
  _PurchaseRequisitionItem.PurReqnOrigin AS PurReqnOrigin,
  _PurchaseRequisitionItem.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  _PurchaseRequisitionItem.PurReqnSSPCatalogItem AS PurReqnSSPCatalogItem,
  _PurchaseRequisitionItem.PurReqnSSPCrossCatalogItem AS PurReqnSSPCrossCatalogItem,
  _PurchaseRequisitionItem.IsPurReqnBlocked AS IsPurReqnBlocked,
  _PurchaseRequisitionItem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _PurchaseRequisitionItem.Language AS Language,
  _PurchaseRequisitionItem.IsClosed AS IsClosed,
  _PurchaseRequisitionItem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  _PurchaseRequisitionItem.ServicePerformer AS ServicePerformer,
  _PurchaseRequisitionItem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  _PurchaseRequisitionItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _PurchaseRequisitionItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _PurchaseRequisitionItem.CompanyCode AS CompanyCode,
  _PurchaseRequisitionItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  _PurchaseRequisitionItem.Batch AS Batch,
  _PurchaseRequisitionItem.MinRemainingShelfLife AS MinRemainingShelfLife,
  _PurchaseRequisitionItem.ItemNetAmount AS ItemNetAmount,
  _PurchaseRequisitionItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _PurchaseRequisitionItem.InvoiceIsExpected AS InvoiceIsExpected,
  _PurchaseRequisitionItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _PurchaseRequisitionItem.RequirementTracking AS RequirementTracking,
  _PurchaseRequisitionItem.MRPController AS MRPController,
  _PurchaseRequisitionItem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  _PurchaseRequisitionItem.AddressID AS AddressID,
  _PurchaseRequisitionItem.LastChangeDateTime AS LastChangeDateTime,
  _PurchaseRequisitionItem.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchaseRequisitionItem.PurchasingGroupName AS PurchasingGroupName,
  _PurchaseRequisitionItem.SupplierName AS SupplierName,
  _PurchaseRequisitionItem.FixedSupplierName AS FixedSupplierName
FROM I_PurchaseRequisitionItemAPI01 AS _PurchaseRequisitionItem
LEFT OUTER JOIN I_Employee AS _Employee ON _Employee.Employee = _PurchaseRequisitionItem.RequisitionerName  -- association [0..1]
;

Learn More