P_ReqnAvgApprovalTime

DDL: P_REQNAVGAPPROVALTIME SQL: PREQNAVGAPPTIME Type: view CONSUMPTION
19 Fields 1 Data Sources

Requisition Average Approval Time 1

P_ReqnAvgApprovalTime is a Consumption CDS View that provides data about "Requisition Average Approval Time 1" in SAP S/4HANA. It reads from 1 data source (P_PurReqnAvgApprvlCrcyConvrsn) and exposes 19 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
P_PurReqnAvgApprvlCrcyConvrsn P_PurReqnAvgApprvlCrcyConvrsn from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate badat
P_EndDate badat

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PREQNAVGAPPTIME view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Requisition Average Approval Time 1 view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition P_PurReqnCurrencyConvrsn PurchaseRequisition Requisition
KEY PurchaseRequisitionItem P_PurReqnCurrencyConvrsn PurchaseRequisitionItem Requisn. item
PurchasingGroup P_PurReqnCurrencyConvrsn PurchasingGroup Purchasing Group
PurchasingOrganization P_PurReqnCurrencyConvrsn PurchasingOrganization Purchasing Organization
Supplier P_PurReqnCurrencyConvrsn Supplier Supplier
SupplierCountry P_PurReqnCurrencyConvrsn SupplierCountry
Material P_PurReqnCurrencyConvrsn Material Vehicle Model
MaterialGroup P_PurReqnCurrencyConvrsn MaterialGroup Product Group
Plant P_PurReqnCurrencyConvrsn Plant Valuation Area
PurReqCreationDate P_PurReqnCurrencyConvrsn PurReqCreationDate Requisn Date
CreationDate P_PurReqnCurrencyConvrsn CreationDate Time Stamp
CostCenter P_PurReqnCurrencyConvrsn CostCenter Cost Center
CreatedByUser P_PurReqnCurrencyConvrsn CreatedByUser User Name
PurchaseRequisitionPrice P_PurReqnCurrencyConvrsn PurchaseRequisitionPrice Valuation Price
CalendarWeek P_PurReqnCurrencyConvrsn CalendarWeek Calendar Week
CalendarMonth P_PurReqnCurrencyConvrsn CalendarMonth Calendar Month
CalendarQuarter P_PurReqnCurrencyConvrsn CalendarQuarter Calendar Quarter
CalendarYear P_PurReqnCurrencyConvrsn CalendarYear Year
PurchaseRequisitionType PurchaseRequisitionType Order Type

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

CREATE VIEW P_ReqnAvgApprovalTime AS
SELECT
  P_PurReqnCurrencyConvrsn.PurchaseRequisition AS PurchaseRequisition,
  P_PurReqnCurrencyConvrsn.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  P_PurReqnCurrencyConvrsn.PurchasingGroup AS PurchasingGroup,
  P_PurReqnCurrencyConvrsn.PurchasingOrganization AS PurchasingOrganization,
  P_PurReqnCurrencyConvrsn.Supplier AS Supplier,
  P_PurReqnCurrencyConvrsn.SupplierCountry AS SupplierCountry,
  P_PurReqnCurrencyConvrsn.Material AS Material,
  P_PurReqnCurrencyConvrsn.MaterialGroup AS MaterialGroup,
  P_PurReqnCurrencyConvrsn.Plant AS Plant,
  P_PurReqnCurrencyConvrsn.PurReqCreationDate AS PurReqCreationDate,
  P_PurReqnCurrencyConvrsn.CreationDate AS CreationDate,
  P_PurReqnCurrencyConvrsn.CostCenter AS CostCenter,
  P_PurReqnCurrencyConvrsn.CreatedByUser AS CreatedByUser,
  P_PurReqnCurrencyConvrsn.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  P_PurReqnCurrencyConvrsn.CalendarWeek AS CalendarWeek,
  P_PurReqnCurrencyConvrsn.CalendarMonth AS CalendarMonth,
  P_PurReqnCurrencyConvrsn.CalendarQuarter AS CalendarQuarter,
  P_PurReqnCurrencyConvrsn.CalendarYear AS CalendarYear,
  PurchaseRequisitionType
FROM P_PurReqnAvgApprvlCrcyConvrsn
;

Learn More