I_RSHOperationHasSubOperation

DDL: I_RSHOPERATIONHASSUBOPERATION SQL: IRSHOPWTHSUBOP Type: view BASIC

Maintenance Operation with Suboperation

I_RSHOperationHasSubOperation is a Basic CDS View that provides data about "Maintenance Operation with Suboperation" in SAP S/4HANA. It reads from 1 data source (I_RSHOperationStatusObject) and exposes 3 fields with key fields MaintOrderRoutingNumber, MaintOrderOperationCounter.

Data Sources (1)

SourceAliasJoin Type
I_RSHOperationStatusObject _IsDeletedStatus left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IRSHOPWTHSUBOP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Operation with Suboperation view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderRoutingNumber OrderInternalID Plan No.f.Oper.
KEY MaintOrderOperationCounter SuperiorOperationInternalID Sup. Op. Node
OperationHasSubOperations

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 I_RSHOperationHasSubOperation.
-- 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: IRSHOPWTHSUBOP

CREATE VIEW I_RSHOperationHasSubOperation AS
SELECT
  OrderInternalID AS MaintOrderRoutingNumber,
  SuperiorOperationInternalID AS MaintOrderOperationCounter,
  'X' AS OperationHasSubOperations
LEFT OUTER JOIN I_RSHOperationStatusObject AS _IsDeletedStatus ON /* join condition not captured in parsed metadata */
;