P_PurReqItmBasicAPIhelper

DDL: P_PURREQITMBASICAPIHELPER SQL: PREQITMBSCAPIHLP Type: view
161 Fields 1 Data Sources 1 Associations

Helper view to get the Employee information

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

Data Sources (1)

SourceAliasJoin Type
I_PurchaseRequisitionItemBasic I_PurchaseRequisitionItemBasic from

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PREQITMBSCAPIHLP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Helper view to get the Employee information view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view

Fields (161)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurReqnDescription PurReqnDescription PurReqn Description
PurchaseRequisitionType PurchaseRequisitionType Order Type
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentSubtype PurchasingDocumentSubtype Control
IsDeleted IsDeleted TRUE
ProcessingStatus ProcessingStatus Worklist Status
PurReqnOrigin PurReqnOrigin Creation ind.
ReleaseCode ReleaseCode Release ind.
PurchaseRequisitionStatus PurchaseRequisitionStatus Release State
ReleaseStrategy ReleaseStrategy Rel. strategy
PurchasingGroup PurchasingGroup Purchasing Group
CreatedByUser CreatedByUser User Name
LastChangedDate LastChangedDate Created On
RequisitionerName RequisitionerName Requisitioner
PurchaseRequisitionItemText PurchaseRequisitionItemText Short Text
Material Material Vehicle Model
ManufacturerMaterial ManufacturerMaterial MPN: Material
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
RequirementTracking RequirementTracking Tracking Number
MaterialGroup MaterialGroup Product Group
SupplyingPlant SupplyingPlant Supplying Plant
RequestedQuantity RequestedQuantity Requested Quantity
BaseUnit BaseUnit Unit of Measure
MaterialShortageQuantity MaterialShortageQuantity Shortage Qty
CreationDate CreationDate Time Stamp
PurchaseReqnCreationDate PurchaseReqnCreationDate Time Stamp
CreationTime CreationTime Time of Change
PurReqCreationDate PurReqCreationDate Requisn Date
DelivDateCategory DelivDateCategory Delivery Date
DeliveryDate DeliveryDate Delivery Date
PurchaseRequisitionReleaseDate PurchaseRequisitionReleaseDate Release Date
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
PurchaseRequisitionPrice PurchaseRequisitionPrice Valuation Price
PurReqnPriceQuantity PurReqnPriceQuantity Price unit
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
ConsumptionPosting ConsumptionPosting Consumption Posting
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
PartialInvoiceDistribution PartialInvoiceDistribution Partial invoice
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
Supplier Supplier Supplier
FixedSupplier FixedSupplier Fixed Vendor
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurReqnSourceOfSupplyType PurReqnSourceOfSupplyType Doc. Category
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchasingInfoRecord PurchasingInfoRecord Info Record
SourceOfSupplyIsAssigned SourceOfSupplyIsAssigned Assigned
MRPController MRPController MRP Controller
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PurchaseOrderDate PurchaseOrderDate PO Date
OrderedQuantity OrderedQuantity Quantity
PurReqnLimitConsumptionAmt PurReqnLimitConsumptionAmt Consumption Value
IsClosed IsClosed Closed
Reservation Reservation Reservation
InventorySpecialStockType InventorySpecialStockType Special Stock Type
PurchaseRequisitionIsFixed PurchaseRequisitionIsFixed "Fixed" ind.
MaterialOrderUnit MaterialOrderUnit Unit 'piece'
MaterialRevisionLevel MaterialRevisionLevel Revision Level
PurchaseOrderPriceType PurchaseOrderPriceType PO price
ReleaseGroup ReleaseGroup Release group
ReleaseIsNotCompleted ReleaseIsNotCompleted Subj.to Release
Batch Batch Lot No.
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
FundsCenter FundsCenter Funds Center
Fund Fund Sender Fund
AddressID AddressID Ship-to address
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ItemDeliveryAddressID ItemDeliveryAddressID Address
PurReqnReceivingCustomer PurReqnReceivingCustomer Stock customer
Subcontractor Subcontractor Supplier
PurReqnItemCurrency PurReqnItemCurrency Currency
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
IsPurReqnOvrlRel IsPurReqnOvrlRel Overall req. rel.
ManufacturerPartProfile ManufacturerPartProfile Mfr Part Profile
Language Language Report Text Language
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
MRPArea MRPArea MRP Area
TaxCode TaxCode Tax Code
FunctionalArea FunctionalArea Sendr Fctl Area
GrantID GrantID Sender Grant
IsPurReqnCmplt IsPurReqnCmplt Incomplete
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
IsPurReqnBlocked IsPurReqnBlocked Blocking Ind.
PurReqnItemBlockingReasonText PurReqnItemBlockingReasonText Blocking Text
ProcuringPlant ProcuringPlant Procuring Plant
ExternalProcurementProfile ExternalProcurementProfile Procurement prof.
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
PurReqnCmpltnsCat PurReqnCmpltnsCat Incompl. Cat.
MinRemainingShelfLife MinRemainingShelfLife Rem. Shelf Life
BudgetPeriod BudgetPeriod Budget Period
PurReqnIsCreatedInExpertMode PurReqnIsCreatedInExpertMode PR in Expert Mode
PurReqnIsValdInCntrlReqnProcg PurReqnIsValdInCntrlReqnProcg Is Central PR Procg.
ProductTypeCode ProductTypeCode Product Type Group
ServicePerformer ServicePerformer Service Performer
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
ExtMaterialForPurg ExtMaterialForPurg Material
ExtFixedSupplierForPurg ExtFixedSupplierForPurg Fixed Supplier
ExtDesiredSupplierForPurg ExtDesiredSupplierForPurg Desired Supplier
ExtContractForPurg ExtContractForPurg Contract
ExtContractItemForPurg ExtContractItemForPurg Item
ExtInfoRecordForPurg ExtInfoRecordForPurg Info Record
ExtPlantForPurg ExtPlantForPurg Plant
ProcmtHubStorageLocation ProcmtHubStorageLocation Storage Location
ExtCompanyCodeForPurg ExtCompanyCodeForPurg Company Code
ExtPurgOrgForPurg ExtPurgOrgForPurg Purch. Organization
ExtSourceSystem ExtSourceSystem Connected System ID
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
ProcmtHubPurReqnItmIsChanged ProcmtHubPurReqnItmIsChanged PR Change Indicator
ExtPurchaseRequisitionType ExtPurchaseRequisitionType PR DocTyp of ConnSys
ExternalApprovalStatus ExternalApprovalStatus Ext Prcsng. Status
ExtApprvlIntmdSts ExtApprvlIntmdSts Intmd Ext Apprvl Sts
PurchaseReqnItemUniqueID PurchaseReqnItemUniqueID Purch. Doc. ID
LastChangeDateTime LastChangeDateTime Timestamp
IsOnBehalfCart IsOnBehalfCart Shop On Behalf Ind.
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
OverallLimitAmount OverallLimitAmount Overall Limit
PurContractForOverallLimit PurContractForOverallLimit Contract For Limit
PurContractItemForOverallLimit PurContractItemForOverallLimit PurCon Itm for Limit
PurReqnIntObjNmbr PurReqnIntObjNmbr Object Number
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
PurReqnSSPCrossCatalogItem PurReqnSSPCrossCatalogItem Catalog item key
PurReqnSSPCatalog PurReqnSSPCatalog Web Service ID
PurReqnSSPCatalogItem PurReqnSSPCatalogItem Catalog Item
PurReqnSSPRequestor PurReqnSSPRequestor Requestor
PurReqnSSPAuthor PurReqnSSPAuthor Author
StockSegment StockSegment Stock Segment
RequirementSegment RequirementSegment Req. Segment
PurchasingDeliveryAddressType PurchasingDeliveryAddressType Delivery Addr Type
SettlementReservation SettlementReservation Settle.reser.No
SettlementReservationItem SettlementReservationItem Settle.item no.
PFMTransDataFootprintUUID PFMTransDataFootprintUUID Transaction Data Footprint
IsOutline IsOutline Item Set
PurchasingParentItem PurchasingParentItem Parent Item No
PurReqnItemOutlineType PurReqnItemOutlineType Outline Type
PurgConfigurableItemNumber PurgConfigurableItemNumber Hierarchy Number
PurgExternalSortNumber PurgExternalSortNumber External Sort No.
CntrlReqnIsRpldBfrApprvl CntrlReqnIsRpldBfrApprvl Is Rplctn Bfr Apprvl
CntrlReqnApprvlStsInRpldReqn CntrlReqnApprvlStsInRpldReqn Approval Sts. in Hub
PurReqnHasDelegateApproval PurReqnHasDelegateApproval PurReq Ext. approval
QuotaArrangement QuotaArrangement Quota arr.
QuotaArrangementItem QuotaArrangementItem Quota arr. item
_Currency _Currency
_PurchaseRequisition _PurchaseRequisition
_UnitOfMeasure _UnitOfMeasure
_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_PurReqItmBasicAPIhelper.
-- 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: PREQITMBSCAPIHLP

CREATE VIEW P_PurReqItmBasicAPIhelper AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurReqnDescription,
  PurchaseRequisitionType,
  PurchasingDocumentCategory,
  PurchasingDocumentSubtype,
  IsDeleted,
  ProcessingStatus,
  PurReqnOrigin,
  ReleaseCode,
  PurchaseRequisitionStatus,
  ReleaseStrategy,
  PurchasingGroup,
  CreatedByUser,
  LastChangedDate,
  RequisitionerName,
  PurchaseRequisitionItemText,
  Material,
  ManufacturerMaterial,
  Plant,
  StorageLocation,
  RequirementTracking,
  MaterialGroup,
  SupplyingPlant,
  RequestedQuantity,
  BaseUnit,
  MaterialShortageQuantity,
  CreationDate,
  PurchaseReqnCreationDate,
  CreationTime,
  PurReqCreationDate,
  DelivDateCategory,
  DeliveryDate,
  PurchaseRequisitionReleaseDate,
  MaterialGoodsReceiptDuration,
  PurchaseRequisitionPrice,
  PurReqnPriceQuantity,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  ConsumptionPosting,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  Supplier,
  FixedSupplier,
  PurchasingOrganization,
  PurReqnSourceOfSupplyType,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecord,
  SourceOfSupplyIsAssigned,
  MRPController,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurchaseOrderDate,
  OrderedQuantity,
  PurReqnLimitConsumptionAmt,
  IsClosed,
  Reservation,
  InventorySpecialStockType,
  PurchaseRequisitionIsFixed,
  MaterialOrderUnit,
  MaterialRevisionLevel,
  PurchaseOrderPriceType,
  ReleaseGroup,
  ReleaseIsNotCompleted,
  Batch,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  AddressID,
  ManualDeliveryAddressID,
  ItemDeliveryAddressID,
  PurReqnReceivingCustomer,
  Subcontractor,
  PurReqnItemCurrency,
  SupplierMaterialNumber,
  IsPurReqnOvrlRel,
  ManufacturerPartProfile,
  Language,
  ManufacturerPartNmbr,
  MaterialPlannedDeliveryDurn,
  MRPArea,
  TaxCode,
  FunctionalArea,
  GrantID,
  IsPurReqnCmplt,
  PurReqnReleaseStatus,
  IsPurReqnBlocked,
  PurReqnItemBlockingReasonText,
  ProcuringPlant,
  ExternalProcurementProfile,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  PurReqnCmpltnsCat,
  MinRemainingShelfLife,
  BudgetPeriod,
  PurReqnIsCreatedInExpertMode,
  PurReqnIsValdInCntrlReqnProcg,
  ProductTypeCode,
  ServicePerformer,
  IsEndOfPurposeBlocked,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ExtMaterialForPurg,
  ExtFixedSupplierForPurg,
  ExtDesiredSupplierForPurg,
  ExtContractForPurg,
  ExtContractItemForPurg,
  ExtInfoRecordForPurg,
  ExtPlantForPurg,
  ProcmtHubStorageLocation,
  ExtCompanyCodeForPurg,
  ExtPurgOrgForPurg,
  ExtSourceSystem,
  ProcurementHubSourceSystem,
  ProcmtHubPurReqnItmIsChanged,
  ExtPurchaseRequisitionType,
  ExternalApprovalStatus,
  ExtApprvlIntmdSts,
  PurchaseReqnItemUniqueID,
  LastChangeDateTime,
  IsOnBehalfCart,
  GLAccount,
  CostCenter,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PurContractForOverallLimit,
  PurContractItemForOverallLimit,
  PurReqnIntObjNmbr,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  PurReqnSSPCrossCatalogItem,
  PurReqnSSPCatalog,
  PurReqnSSPCatalogItem,
  PurReqnSSPRequestor,
  PurReqnSSPAuthor,
  StockSegment,
  RequirementSegment,
  PurchasingDeliveryAddressType,
  SettlementReservation,
  SettlementReservationItem,
  PFMTransDataFootprintUUID,
  IsOutline,
  PurchasingParentItem,
  PurReqnItemOutlineType,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber,
  CntrlReqnIsRpldBfrApprvl,
  CntrlReqnApprvlStsInRpldReqn,
  PurReqnHasDelegateApproval,
  QuotaArrangement,
  QuotaArrangementItem
FROM I_PurchaseRequisitionItemBasic
LEFT OUTER JOIN I_Employee AS _Employee ON _Employee.Employee = I_PurchaseRequisitionItemBasic.RequisitionerName  -- association [0..1]
;

Learn More