P_ReqnToOrderCycleTime1

DDL: P_REQNTOORDERCYCLETIME1 SQL: PMMREQORDCYCL1 Type: view CONSUMPTION
19 Fields 3 Data Sources

P_ReqnToOrderCycleTime1 is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (P_PurReqnCurrencyConvrsn, I_PurchaseOrder, I_PurchaseOrderItem) and exposes 19 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, AccountAssignmentNumber.

Data Sources (3)

SourceAliasJoin Type
P_PurReqnCurrencyConvrsn P_PurReqnCurrencyConvrsn from
I_PurchaseOrder PurchaseOrder inner
I_PurchaseOrderItem PurchaseOrderItem inner

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate badat
P_EndDate badat

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMMREQORDCYCL1 view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #CHECK 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
KEY AccountAssignmentNumber P_PurReqnCurrencyConvrsn AccountAssignmentNumber Account Assgmt No.
PurchaseOrder
PurchasingGroup P_PurReqnCurrencyConvrsn PurchasingGroup Purchasing Group
PurchasingOrganization P_PurReqnCurrencyConvrsn PurchasingOrganization Purchasing Organization
Supplier P_PurReqnCurrencyConvrsn Supplier Supplier
Material P_PurReqnCurrencyConvrsn Material Vehicle Model
MaterialGroup P_PurReqnCurrencyConvrsn MaterialGroup Product Group
Plant P_PurReqnCurrencyConvrsn Plant Valuation Area
PurReqCreationDate P_PurReqnCurrencyConvrsn PurReqCreationDate Requisn Date
PurchaseRequisitionType PurchaseRequisitionType Order Type
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

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

CREATE VIEW P_ReqnToOrderCycleTime1 AS
SELECT
  P_PurReqnCurrencyConvrsn.PurchaseRequisition AS PurchaseRequisition,
  P_PurReqnCurrencyConvrsn.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  P_PurReqnCurrencyConvrsn.AccountAssignmentNumber AS AccountAssignmentNumber,
  min(PurchaseOrderItem.PurchaseOrder) AS PurchaseOrder,
  P_PurReqnCurrencyConvrsn.PurchasingGroup AS PurchasingGroup,
  P_PurReqnCurrencyConvrsn.PurchasingOrganization AS PurchasingOrganization,
  P_PurReqnCurrencyConvrsn.Supplier AS Supplier,
  P_PurReqnCurrencyConvrsn.Material AS Material,
  P_PurReqnCurrencyConvrsn.MaterialGroup AS MaterialGroup,
  P_PurReqnCurrencyConvrsn.Plant AS Plant,
  P_PurReqnCurrencyConvrsn.PurReqCreationDate AS PurReqCreationDate,
  PurchaseRequisitionType,
  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
FROM P_PurReqnCurrencyConvrsn
INNER JOIN I_PurchaseOrderItem AS PurchaseOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
;

Learn More