P_PrmtHbRpldPurchaseReqnItem

DDL: P_PRMTHBRPLDPURCHASEREQNITEM SQL: PHBPRITM Type: view CONSUMPTION
36 Fields 1 Data Sources

P-view for Cntral PR Item

P_PrmtHbRpldPurchaseReqnItem is a Consumption CDS View that provides data about "P-view for Cntral PR Item" in SAP S/4HANA. It reads from 1 data source (P_PrmtHubPRItemWithAcctAssign) and exposes 36 fields with key fields ProcmtHubPurchaseRequisition, ProcmtHubPurRequisitionItem, ProcurementHubSourceSystem.

Data Sources (1)

SourceAliasJoin Type
P_PrmtHubPRItemWithAcctAssign PurReqn from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PHBPRITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label P-view for Cntral PR Item view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ProcmtHubPurchaseRequisition P_PrmtHubPRItemWithAcctAssign ProcmtHubPurchaseRequisition Purchase Req.
KEY ProcmtHubPurRequisitionItem P_PrmtHubPRItemWithAcctAssign ProcmtHubPurRequisitionItem Requisn. item
KEY ProcurementHubSourceSystem P_PrmtHubPRItemWithAcctAssign ProcurementHubSourceSystem Connected System ID
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
ProcmtHubGLAccount ProcmtHubGLAccount G/L Account
ProcmtHubCostCenter ProcmtHubCostCenter Cost Center
ProcmtHubProjectNetwork ProcmtHubProjectNetwork Network
ProcmtHubMasterFixedAsset ProcmtHubMasterFixedAsset Asset
ProcmtHubWBSElementInternalID ProcmtHubWBSElementInternalID WBS Element
ValidityDate ValidityDate Valid On
ProcmtHubControllingArea ProcmtHubControllingArea CO Area
ChartOfAccounts ChartOfAccounts Node Class
000endasOpenQuantity
curr212endasItemNetAmount Net Amount
ProcmtHubAcctAssgmtCategory ProcmtHubAcctAssgmtCategory Acct Assgmt Cat
PurchaseRequisitionItemText PurchaseRequisitionItemText Short Text
ProcmtHubPurgDocItmCategory ProcmtHubPurgDocItmCategory Item Category
ProcmtHubPurRequisitionType ProcmtHubPurRequisitionType
ProcmtHubPurchasingGroup ProcmtHubPurchasingGroup Purch. Group
ProcmtHubCompanyCode ProcmtHubCompanyCode Company Code
ProcmtHubPurchasingOrg ProcmtHubPurchasingOrg Purchasing Org.
ProcmtHubPlant ProcmtHubPlant Plant
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
ProcmtHubCreatedByUser ProcmtHubCreatedByUser Entered By
CreationDate CreationDate Time Stamp
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
ProcessingStatus ProcessingStatus Worklist Status
PurReqnPriceQuantity PurReqnPriceQuantity Price unit
DeliveryDate DeliveryDate Delivery Date
RequestedQuantity RequestedQuantity Requested Quantity
OrderedQuantity OrderedQuantity Quantity
BaseUnit BaseUnit Unit of Measure
PurchaseRequisitionPrice PurchaseRequisitionPrice Valuation Price
PurReqnItemCurrency PurReqnItemCurrency Currency
ProcmtHubFixedSupplier ProcmtHubFixedSupplier

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_PrmtHbRpldPurchaseReqnItem.
-- 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: PHBPRITM

CREATE VIEW P_PrmtHbRpldPurchaseReqnItem AS
SELECT
  PurReqn.ProcmtHubPurchaseRequisition AS ProcmtHubPurchaseRequisition,
  PurReqn.ProcmtHubPurRequisitionItem AS ProcmtHubPurRequisitionItem,
  PurReqn.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  AccountAssignmentNumber,
  ProcmtHubGLAccount,
  ProcmtHubCostCenter,
  ProcmtHubProjectNetwork,
  ProcmtHubMasterFixedAsset,
  ProcmtHubWBSElementInternalID,
  ValidityDate,
  ProcmtHubControllingArea,
  ChartOfAccounts,
  case when RequestedQuantity > OrderedQuantity then RequestedQuantity - OrderedQuantity else 0.000 end as OpenQuantity AS 000endasOpenQuantity,
  case when PurReqnPriceQuantity = 0 then cast( RequestedQuantity * PurchaseRequisitionPrice as abap.curr(21,2)) else cast( division(RequestedQuantity * PurchaseRequisitionPrice , PurReqnPriceQuantity, 2) as abap.curr(21,2)) end as ItemNetAmount AS curr212endasItemNetAmount,
  ProcmtHubAcctAssgmtCategory,
  PurchaseRequisitionItemText,
  ProcmtHubPurgDocItmCategory,
  ProcmtHubPurRequisitionType,
  ProcmtHubPurchasingGroup,
  ProcmtHubCompanyCode,
  ProcmtHubPurchasingOrg,
  ProcmtHubPlant,
  Material,
  MaterialGroup,
  ProcmtHubCreatedByUser,
  CreationDate,
  PurReqnReleaseStatus,
  ProcessingStatus,
  PurReqnPriceQuantity,
  DeliveryDate,
  RequestedQuantity,
  OrderedQuantity,
  BaseUnit,
  PurchaseRequisitionPrice,
  PurReqnItemCurrency,
  ProcmtHubFixedSupplier
FROM P_PrmtHubPRItemWithAcctAssign AS PurReqn
;

Learn More