I_JITTeamMemberFunction

DDL: I_JITTEAMMEMBERFUNCTION Type: view_entity COMPOSITE
8 Fields 1 Data Sources 3 Associations

Details of defined Functions

I_JITTeamMemberFunction is a Composite CDS View that provides data about "Details of defined Functions" in SAP S/4HANA. It reads from 1 data source (I_RespyMgmtTeamMbrFunc) and exposes 8 fields with key fields RespyMgmtFunction, RespyMgmtTeamID, RespyMgmtBusinessPartner. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RespyMgmtTeamMbrFunc I_RespyMgmtTeamMbrFunc from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_RespyMgmtFunction _Function $projection.RespyMgmtFunction = _Function.RespyMgmtFunction
[0..1] I_BusinessUser _BusinessUser $projection.RespyMgmtBusinessPartner = _BusinessUser.BusinessPartner
[0..1] I_RespyMgmtTeamAttribute _RespyMgmtTeamAttribute $projection.RespyMgmtTeamID = _RespyMgmtTeamAttribute.RespyMgmtTeamID and _RespyMgmtTeamAttribute.RespyMgmtReferenceAttribName = 'JITRESPYMGMTALTVFUNCTION'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Details of defined Functions view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtFunction RespyMgmtFunction Function
KEY RespyMgmtTeamID RespyMgmtTeamID Team ID
KEY RespyMgmtBusinessPartner RespyMgmtBusinessPartner Busn. Partner
RespyMgmtFunctionDescription _Function RespyMgmtFunctionDescription
_Function _Function
_Team _Team
_BusinessUser _BusinessUser
_RespyMgmtTeamAttribute _RespyMgmtTeamAttribute

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_JITTeamMemberFunction.
-- 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.

CREATE VIEW I_JITTeamMemberFunction AS
SELECT
  RespyMgmtFunction,
  RespyMgmtTeamID,
  RespyMgmtBusinessPartner,
  _Function.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription
FROM I_RespyMgmtTeamMbrFunc
LEFT OUTER JOIN I_RespyMgmtFunction AS _Function ON RespyMgmtFunction = _Function.RespyMgmtFunction  -- association [1..1]
LEFT OUTER JOIN I_BusinessUser AS _BusinessUser ON RespyMgmtBusinessPartner = _BusinessUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _RespyMgmtTeamAttribute ON RespyMgmtTeamID = _RespyMgmtTeamAttribute.RespyMgmtTeamID AND _RespyMgmtTeamAttribute.RespyMgmtReferenceAttribName = 'JITRESPYMGMTALTVFUNCTION'  -- association [0..1]
;

Learn More