P_RFM_SlsOrdPrgrsMntrPurReqn

DDL: P_RFM_SLSORDPRGRSMNTRPURREQN Type: view COMPOSITE
13 Fields 2 Data Sources

P_RFM_SlsOrdPrgrsMntrPurReqn is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchaseReqnAcctAssgmt, I_Purchaserequisitionitem) and exposes 13 fields with key fields SalesOrder, SalesOrderItem, PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseReqnAcctAssgmt PurReqnAcctAssgmt from
I_Purchaserequisitionitem PurReqnItm inner

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName PRFMSOPMPURREQN view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_PurchaseReqnAcctAssgmt SalesOrder SD Document
KEY SalesOrderItem I_PurchaseReqnAcctAssgmt SalesOrderItem Sales Order Item
KEY PurchaseRequisition I_Purchaserequisitionitem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_Purchaserequisitionitem PurchaseRequisitionItem Requisn. item
RequestedQuantity I_Purchaserequisitionitem RequestedQuantity Requested Quantity
BaseUnit I_Purchaserequisitionitem BaseUnit Unit of Measure
DeliveryDate I_Purchaserequisitionitem DeliveryDate Delivery Date
PurOrdItmFirstGRPostingDate _PurOrdHist PostingDate Posting Date for GR
DeliveryDateasdue_daysendasDueDays
TotalSupplyQuantity RequestedQuantity Requested Quantity
ProcessedSupplyQuantity OrderedQuantity Quantity
Material I_Purchaserequisitionitem Material Vehicle Model
Plant I_Purchaserequisitionitem Plant Valuation Area

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_RFM_SlsOrdPrgrsMntrPurReqn.
-- 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.

CREATE VIEW P_RFM_SlsOrdPrgrsMntrPurReqn AS
SELECT
  PurReqnAcctAssgmt.SalesOrder AS SalesOrder,
  PurReqnAcctAssgmt.SalesOrderItem AS SalesOrderItem,
  PurReqnItm.PurchaseRequisition AS PurchaseRequisition,
  PurReqnItm.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurReqnItm.RequestedQuantity AS RequestedQuantity,
  PurReqnItm.BaseUnit AS BaseUnit,
  PurReqnItm.DeliveryDate AS DeliveryDate,
  _PurOrdHist.PostingDate AS PurOrdItmFirstGRPostingDate,
  case when _PurOrdHist.PostingDate is not initial then cast(Dats_Days_Between( _PurOrdHist.PostingDate, PurReqnItm.DeliveryDate) as due_days) else cast(Dats_Days_Between( cast($session.system_date as dats), PurReqnItm.DeliveryDate) as due_days) end as DueDays AS DeliveryDateasdue_daysendasDueDays,
  RequestedQuantity AS TotalSupplyQuantity,
  OrderedQuantity AS ProcessedSupplyQuantity,
  PurReqnItm.Material AS Material,
  PurReqnItm.Plant AS Plant
FROM I_PurchaseReqnAcctAssgmt AS PurReqnAcctAssgmt
INNER JOIN I_Purchaserequisitionitem AS PurReqnItm ON /* join condition not captured in parsed metadata */
;

Learn More