P_RSHOperationsForKPIDetails

DDL: P_RSHOPERATIONSFORKPIDETAILS SQL: PRSHOPERKPIDET Type: view CONSUMPTION
9 Fields 7 Data Sources

Order KPI Details

P_RSHOperationsForKPIDetails is a Consumption CDS View that provides data about "Order KPI Details" in SAP S/4HANA. It reads from 7 data sources and exposes 9 fields with key fields MaintOrderRoutingNumber, OrderOperationInternalID.

Data Sources (7)

SourceAliasJoin Type
I_RSHAssignedWorkCenters _AssignedWorkCenter inner
I_MaintenanceOrder _MaintOrder from
I_MaintOrderOperPlanningValues _MaintOrderOpPlanValue inner
I_RSHOperationStatusObject _OperationStatusObj inner
I_OperationControlProfile _OperControlProfile inner
I_OrderOperationBasic _OrderOpBasic inner
I_SchedulingType _SchedulingType inner

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRSHOPERKPIDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Order KPI Details view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderRoutingNumber I_MaintenanceOrder MaintOrderRoutingNumber Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID Plan No.f.Oper.
MaintenanceOrder I_MaintenanceOrder MaintenanceOrder Order
WorkCenterInternalID I_OrderOperationBasic WorkCenterInternalID Work Center
Plant I_OrderOperationBasic Plant Valuation Area
OperationControlProfile I_OrderOperationBasic OperationControlProfile Control Key
Equipment I_MaintenanceOrder Equipment Equipment check
MaintObjectLocAcctAssgmtNmbr I_MaintenanceOrder MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
OperationPersonResponsible I_OrderOperationBasic OperationPersonResponsible Personnel no.

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_RSHOperationsForKPIDetails.
-- 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: PRSHOPERKPIDET
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_RSHOperationsForKPIDetails AS
SELECT
  _MaintOrder.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _OrderOpBasic.OrderOperationInternalID AS OrderOperationInternalID,
  _MaintOrder.MaintenanceOrder AS MaintenanceOrder,
  _OrderOpBasic.WorkCenterInternalID AS WorkCenterInternalID,
  _OrderOpBasic.Plant AS Plant,
  _OrderOpBasic.OperationControlProfile AS OperationControlProfile,
  _MaintOrder.Equipment AS Equipment,
  _MaintOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _OrderOpBasic.OperationPersonResponsible AS OperationPersonResponsible
FROM I_MaintenanceOrder AS _MaintOrder
INNER JOIN I_OrderOperationBasic AS _OrderOpBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintOrderOperPlanningValues AS _MaintOrderOpPlanValue ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters AS _AssignedWorkCenter ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS _OperControlProfile ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHOperationStatusObject AS _OperationStatusObj ON /* join condition not captured in parsed metadata */
INNER JOIN I_SchedulingType AS _SchedulingType ON /* join condition not captured in parsed metadata */
;

Learn More