I_ProcmtHubPurReqnPriceCalc

DDL: I_PROCMTHUBPURREQNPRICECALC SQL: IPRCMTHUBPRPRICE Type: view COMPOSITE
21 Fields 1 Data Sources

Purchase requisition price calculation

I_ProcmtHubPurReqnPriceCalc is a Composite CDS View that provides data about "Purchase requisition price calculation" in SAP S/4HANA. It reads from 1 data source (I_ProcmtHubPurReqnOpenForConf) and exposes 21 fields with key fields ProcmtHubPurchaseRequisition, ProcmtHubReferencePurOrder.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtHubPurReqnOpenForConf _externalPR from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRCMTHUBPRPRICE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase requisition price calculation view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ProcmtHubPurchaseRequisition I_ProcmtHubPurReqnOpenForConf ProcmtHubPurchaseRequisition Purchase Req.
KEY ProcmtHubReferencePurOrder I_ProcmtHubPurReqnOpenForConf ProcmtHubReferencePurOrder Purchasing Doc.
ProcmtHubPurRequisitionItem I_ProcmtHubPurReqnOpenForConf ProcmtHubPurRequisitionItem Requisn. item
ProcmtHubReferencePurOrderItm I_ProcmtHubPurReqnOpenForConf ProcmtHubReferencePurOrderItm Item
ProcurementHubSourceSystem I_ProcmtHubPurReqnOpenForConf ProcurementHubSourceSystem Connected System ID
ExtPlantForPurg I_ProcmtHubPurReqnOpenForConf ExtPlantForPurg Plant
ProcmtHubRefPurOrdItemMaterial I_ProcmtHubPurReqnOpenForConf ProcmtHubRefPurOrdItemMaterial Material
ProcmtHubRefPurOrderOpenQty I_ProcmtHubPurReqnOpenForConf ProcmtHubRefPurOrderOpenQty PO Quantity
ProcmtHubRefPurOrdItemUoM I_ProcmtHubPurReqnOpenForConf ProcmtHubRefPurOrdItemUoM Base Unit
ProcmtHubRefPurOrdItmIsDeleted I_ProcmtHubPurReqnOpenForConf ProcmtHubRefPurOrdItmIsDeleted Del. Indicator
PrmtHbRefPurOrdItmIsDelivCmplt I_ProcmtHubPurReqnOpenForConf PrmtHbRefPurOrdItmIsDelivCmplt Deliv. Compl.
PrmtHbRefPurchaseOrderStatus I_ProcmtHubPurReqnOpenForConf PrmtHbRefPurchaseOrderStatus Item status
ProcmtHubCreatedByUser I_ProcmtHubPurReqnOpenForConf ProcmtHubCreatedByUser Entered By
ProcmtHubCreationDate I_ProcmtHubPurReqnOpenForConf ProcmtHubCreationDate Created On
ProcmtHubPurchasingGroup I_ProcmtHubPurReqnOpenForConf ProcmtHubPurchasingGroup Purch. Group
PurReqnRequestor I_ProcmtHubPurReqnOpenForConf PurReqnRequestor Requestor
SSPAuthorExternalBPIdnNumber I_ProcmtHubPurReqnOpenForConf SSPAuthorExternalBPIdnNumber Author
ProcmtHubRefPurOrdSupplier I_ProcmtHubPurReqnOpenForConf ProcmtHubRefPurOrdSupplier Supplier
ExtCompanyCodeForPurg I_ProcmtHubPurReqnOpenForConf ExtCompanyCodeForPurg Company Code
LastChangeDateTime I_ProcmtHubPurReqnOpenForConf LastChangeDateTime Timestamp
PurReqnDescription PurRequisitionItem PurReqnDescription PurReqn Description

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 I_ProcmtHubPurReqnPriceCalc.
-- 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: IPRCMTHUBPRPRICE

CREATE VIEW I_ProcmtHubPurReqnPriceCalc AS
SELECT
  _externalPR.ProcmtHubPurchaseRequisition AS ProcmtHubPurchaseRequisition,
  _externalPR.ProcmtHubReferencePurOrder AS ProcmtHubReferencePurOrder,
  _externalPR.ProcmtHubPurRequisitionItem AS ProcmtHubPurRequisitionItem,
  _externalPR.ProcmtHubReferencePurOrderItm AS ProcmtHubReferencePurOrderItm,
  _externalPR.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _externalPR.ExtPlantForPurg AS ExtPlantForPurg,
  _externalPR.ProcmtHubRefPurOrdItemMaterial AS ProcmtHubRefPurOrdItemMaterial,
  _externalPR.ProcmtHubRefPurOrderOpenQty AS ProcmtHubRefPurOrderOpenQty,
  _externalPR.ProcmtHubRefPurOrdItemUoM AS ProcmtHubRefPurOrdItemUoM,
  _externalPR.ProcmtHubRefPurOrdItmIsDeleted AS ProcmtHubRefPurOrdItmIsDeleted,
  _externalPR.PrmtHbRefPurOrdItmIsDelivCmplt AS PrmtHbRefPurOrdItmIsDelivCmplt,
  _externalPR.PrmtHbRefPurchaseOrderStatus AS PrmtHbRefPurchaseOrderStatus,
  _externalPR.ProcmtHubCreatedByUser AS ProcmtHubCreatedByUser,
  _externalPR.ProcmtHubCreationDate AS ProcmtHubCreationDate,
  _externalPR.ProcmtHubPurchasingGroup AS ProcmtHubPurchasingGroup,
  _externalPR.PurReqnRequestor AS PurReqnRequestor,
  _externalPR.SSPAuthorExternalBPIdnNumber AS SSPAuthorExternalBPIdnNumber,
  _externalPR.ProcmtHubRefPurOrdSupplier AS ProcmtHubRefPurOrdSupplier,
  _externalPR.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  _externalPR.LastChangeDateTime AS LastChangeDateTime,
  PurRequisitionItem.PurReqnDescription AS PurReqnDescription
FROM I_ProcmtHubPurReqnOpenForConf AS _externalPR
;

Learn More