P_PurReqnCurrencyConvrsn

DDL: P_PURREQNCURRENCYCONVRSN SQL: PPREQNCURRCONV Type: view CONSUMPTION
23 Fields 4 Data Sources

P_PurReqnCurrencyConvrsn is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_PurchaseOrderItem, I_CalendarDate, P_PurchaseRequisitionItem, I_PurReqnAccountAssignment) and exposes 23 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, AccountAssignmentNumber.

Data Sources (4)

SourceAliasJoin Type
I_PurchaseOrderItem _PurchaseOrderItem inner
I_CalendarDate CalendarDate left_outer
P_PurchaseRequisitionItem P_PurchaseRequisitionItem from
I_PurReqnAccountAssignment PurcReqnAccountAssignment left_outer

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate badat
P_EndDate badat

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPREQNCURRCONV view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseReqItem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseReqItem PurchaseRequisitionItem Requisn. item
KEY AccountAssignmentNumber I_PurReqnAccountAssignment PurchaseReqnAcctAssgmtNumber Ser.no.acc.ass.
PurchasingGroup PurchaseReqItem PurchasingGroup Purchasing Group
PurchasingOrganization PurchaseReqItem PurchasingOrganization Purchasing Organization
CostCenter I_PurReqnAccountAssignment CostCenter Cost Center
Supplier
SupplierCountry
AccountAssignmentCategory PurchaseReqItem AccountAssignmentCategory Acct Assgmt Cat
Material PurchaseReqItem Material Vehicle Model
MaterialGroup PurchaseReqItem MaterialGroup Product Group
Plant PurchaseReqItem Plant Valuation Area
ReleaseCode PurchaseReqItem ReleaseCode Release ind.
PurchaseRequisitionStatus PurchaseReqItem PurchaseRequisitionStatus Release State
ReleaseStrategy PurchaseReqItem ReleaseStrategy Rel. strategy
CreatedByUser PurchaseReqItem CreatedByUser User Name
PurchaseRequisitionType PurchaseRequisitionType Order Type
PurReqCreationDate PurReqCreationDate Requisn Date
CreationDate
CalendarWeek I_CalendarDate CalendarWeek Calendar Week
CalendarMonth I_CalendarDate CalendarMonth Calendar Month
CalendarQuarter I_CalendarDate CalendarQuarter Calendar Quarter
CalendarYear I_CalendarDate CalendarYear Year

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_PurReqnCurrencyConvrsn.
-- 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: PPREQNCURRCONV
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : badat, P_EndDate : badat

CREATE VIEW P_PurReqnCurrencyConvrsn AS
SELECT
  PurchaseReqItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseReqItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurcReqnAccountAssignment.PurchaseReqnAcctAssgmtNumber AS AccountAssignmentNumber,
  PurchaseReqItem.PurchasingGroup AS PurchasingGroup,
  PurchaseReqItem.PurchasingOrganization AS PurchasingOrganization,
  PurcReqnAccountAssignment.CostCenter AS CostCenter,
  cast(PurchaseReqItem.Supplier as md_supplier) AS Supplier,
  cast( _Supplier._StandardAddress._Country.Country as mm_a_supplier_country ) AS SupplierCountry,
  PurchaseReqItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseReqItem.Material AS Material,
  PurchaseReqItem.MaterialGroup AS MaterialGroup,
  PurchaseReqItem.Plant AS Plant,
  PurchaseReqItem.ReleaseCode AS ReleaseCode,
  PurchaseReqItem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  PurchaseReqItem.ReleaseStrategy AS ReleaseStrategy,
  PurchaseReqItem.CreatedByUser AS CreatedByUser,
  PurchaseRequisitionType,
  PurReqCreationDate,
  min( _PurchaseOrderItem._PurchaseOrder.CreationDate ) AS CreationDate,
  CalendarDate.CalendarWeek AS CalendarWeek,
  CalendarDate.CalendarMonth AS CalendarMonth,
  CalendarDate.CalendarQuarter AS CalendarQuarter,
  CalendarDate.CalendarYear AS CalendarYear
FROM P_PurchaseRequisitionItem
LEFT OUTER JOIN I_PurReqnAccountAssignment AS PurcReqnAccountAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS CalendarDate ON /* join condition not captured in parsed metadata */
;

Learn More