I_JITOutbTeamAssignment

DDL: I_JITOUTBTEAMASSIGNMENT Type: view_entity COMPOSITE
12 Fields 1 Data Sources 3 Associations

JIT Outbound Team Details

I_JITOutbTeamAssignment is a Composite CDS View that provides data about "JIT Outbound Team Details" in SAP S/4HANA. It reads from 1 data source (I_RespyMgmtTeamMember) and exposes 12 fields with key fields RespyMgmtTeamID, RespyMgmtFunction. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RespyMgmtTeamMember I_RespyMgmtTeamMember from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_JITOutbTeamMemberFunction _OutbTeamMemberFunction $projection.RespyMgmtTeamID = _OutbTeamMemberFunction.RespyMgmtTeamID
[1..*] I_RespyMgmtTeamAttribute _Attribute $projection.RespyMgmtTeamID = _Attribute.RespyMgmtTeamID
[1..1] I_RespyMgmtTeamCategory _TeamCategory $projection.RespyMgmtTeamCategory = _TeamCategory.RespyMgmtTeamCategory

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label JIT Outbound Team Details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtTeamID RespyMgmtTeamID Team ID
KEY RespyMgmtFunction _OutbTeamMemberFunction RespyMgmtFunction Function
RespyMgmtTeamName _Team RespyMgmtTeamName Team Name
RespyMgmtFunctionDescription _OutbTeamMemberFunction RespyMgmtFunctionDescription
RespyMgmtTeamDescription _Team RespyMgmtTeamDescription
RespyMgmtTeamCategory _Team RespyMgmtTeamCategory Team Category
RespyMgmtTeamType _Team RespyMgmtTeamType
RespyMgmtTeamStatus _Team RespyMgmtTeamStatus
_OutbTeamMemberFunction _OutbTeamMemberFunction
_Attribute _Attribute
_Team _Team
_TeamCategory _TeamCategory

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_JITOutbTeamAssignment.
-- 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_JITOutbTeamAssignment AS
SELECT
  RespyMgmtTeamID,
  _OutbTeamMemberFunction.RespyMgmtFunction AS RespyMgmtFunction,
  _Team.RespyMgmtTeamName AS RespyMgmtTeamName,
  _OutbTeamMemberFunction.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription,
  _Team.RespyMgmtTeamDescription AS RespyMgmtTeamDescription,
  _Team.RespyMgmtTeamCategory AS RespyMgmtTeamCategory,
  _Team.RespyMgmtTeamType AS RespyMgmtTeamType,
  _Team.RespyMgmtTeamStatus AS RespyMgmtTeamStatus
FROM I_RespyMgmtTeamMember
LEFT OUTER JOIN I_JITOutbTeamMemberFunction AS _OutbTeamMemberFunction ON RespyMgmtTeamID = _OutbTeamMemberFunction.RespyMgmtTeamID  -- association [1..*]
LEFT OUTER JOIN I_RespyMgmtTeamAttribute AS _Attribute ON RespyMgmtTeamID = _Attribute.RespyMgmtTeamID  -- association [1..*]
LEFT OUTER JOIN I_RespyMgmtTeamCategory AS _TeamCategory ON RespyMgmtTeamCategory = _TeamCategory.RespyMgmtTeamCategory  -- association [1..1]
;

Learn More