P_RSHDueOperForKPIDetails

DDL: P_RSHDUEOPERFORKPIDETAILS SQL: PRSHDUEOPKPIDET Type: view CONSUMPTION Package: RSH_CDS_ORD
9 Fields 7 Data Sources

Due Order Operation KPI Details

P_RSHDueOperForKPIDetails is a Consumption CDS View that provides data about "Due Order Operation KPI Details" in SAP S/4HANA. It reads from 7 data sources and exposes 9 fields with key fields MaintOrderRoutingNumber, OrderOperationInternalID. Part of development package RSH_CDS_ORD.

Data Sources (7)

SourceAliasJoin Type
I_RSHAssignedWorkCenters _AssignedWorkCenter inner
I_RSHOrder _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 PRSHDUEOPKPIDET 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 Due Order Operation KPI Details view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderRoutingNumber I_RSHOrder MaintOrderRoutingNumber Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID Plan No.f.Oper.
MaintenanceOrder I_RSHOrder MaintenanceOrder Order
WorkCenterInternalID I_OrderOperationBasic WorkCenterInternalID Work Center
Plant I_OrderOperationBasic Plant Valuation Area
OperationControlProfile I_OrderOperationBasic OperationControlProfile Control Key
Equipment I_RSHOrder Equipment Equipment check
MaintObjectLocAcctAssgmtNmbr I_RSHOrder 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_RSHDueOperForKPIDetails.
-- 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: PRSHDUEOPKPIDET
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_RSHDueOperForKPIDetails 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_RSHOrder 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