I_RespyMgmtTeamTypeFuncBfrExcl

DDL: I_RESPYMGMTTEAMTYPEFUNCBFREXCL SQL: IRSMFUNCTEAMTYPE Type: view COMPOSITE
4 Fields 2 Data Sources

View Functions for Team Type

I_RespyMgmtTeamTypeFuncBfrExcl is a Composite CDS View that provides data about "View Functions for Team Type" in SAP S/4HANA. It reads from 2 data sources (I_RespyMgmtFuncProfileMap, I_RespyMgmtTeamTypeBasic) and exposes 4 fields with key fields RespyMgmtTeamType, RespyMgmtFunction.

Data Sources (2)

SourceAliasJoin Type
I_RespyMgmtFuncProfileMap FuncProfMap inner
I_RespyMgmtTeamTypeBasic TeamType inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRSMFUNCTEAMTYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
EndUserText.label View Functions for Team Type view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtTeamType I_RespyMgmtTeamTypeBasic RespyMgmtTeamType Team Type
KEY RespyMgmtFunction I_RespyMgmtFuncProfileMap RespyMgmtFunction Function
RespyMgmtFunctionDescription I_RespyMgmtFuncProfileMap RespyMgmtFunctionDescription
RespyMgmtTeamCategory TeamCatFuncPr RespyMgmtTeamCategory Team Category

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_RespyMgmtTeamTypeFuncBfrExcl.
-- 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: IRSMFUNCTEAMTYPE

CREATE VIEW I_RespyMgmtTeamTypeFuncBfrExcl AS
SELECT
  TeamType.RespyMgmtTeamType AS RespyMgmtTeamType,
  FuncProfMap.RespyMgmtFunction AS RespyMgmtFunction,
  FuncProfMap.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription,
  TeamCatFuncPr.RespyMgmtTeamCategory AS RespyMgmtTeamCategory
INNER JOIN I_RespyMgmtTeamTypeBasic AS TeamType ON /* join condition not captured in parsed metadata */
INNER JOIN I_RespyMgmtFuncProfileMap AS FuncProfMap ON /* join condition not captured in parsed metadata */
;

Learn More