I_RespyMgmtFunction

DDL: I_RESPYMGMTFUNCTION SQL: IRSMFUNCTION Type: view BASIC

Function in Responsibility Management

I_RespyMgmtFunction is a Basic CDS View that provides data about "Function in Responsibility Management" in SAP S/4HANA. It reads from 2 data sources (rsm_function_c, rsm_function_c_t) and exposes 2 fields with key field RespyMgmtFunction.

Data Sources (2)

SourceAliasJoin Type
rsm_function_c Function from
rsm_function_c_t FunctionDescription left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRSMFUNCTION view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label Function in Responsibility Management view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtFunction rsm_function_c function Unit Func.
RespyMgmtFunctionDescription rsm_function_c_t functiondescription Function Description

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_RespyMgmtFunction.
-- 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: IRSMFUNCTION

CREATE VIEW I_RespyMgmtFunction AS
SELECT
  Function.function AS RespyMgmtFunction,
  FunctionDescription.functiondescription AS RespyMgmtFunctionDescription
FROM rsm_function_c AS Function
LEFT OUTER JOIN rsm_function_c_t AS FunctionDescription ON /* join condition not captured in parsed metadata */
;