How many fields does P_RespyMgmtTeamHeader have?

P_RespyMgmtTeamHeader has 15 fields. Key fields: RespyMgmtTeamID, LanguageKey.

P_RespyMgmtTeamHeader

Q: Which tables does P_RespyMgmtTeamHeader use?

P_RespyMgmtTeamHeader reads from 3 data source(s): I_RespyMgmtTeamHeaderAdminData, I_RespyMgmtTeamDescription, I_RespyMgmtTeamHeaderDetail.

DDL: P_RESPYMGMTTEAMHEADER SQL: PTEAMHEADER Type: view COMPOSITE

P_RespyMgmtTeamHeader is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_RespyMgmtTeamHeaderAdminData, I_RespyMgmtTeamDescription, I_RespyMgmtTeamHeaderDetail) and exposes 15 fields with key fields RespyMgmtTeamID, LanguageKey. It has 2 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_RespyMgmtTeamHeaderAdminData	_AdminData	left_outer
I_RespyMgmtTeamDescription	_TeamDescription	left_outer
I_RespyMgmtTeamHeaderDetail	Team	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_RespyMgmtSuperTeamOfAllLevel	_AllLevelSuperTeam	`$projection.RespyMgmtTeamID = _AllLevelSuperTeam.RespyMgmtTeamID`
[0..1]	I_RespyMgmtTeamType	_RespyMgmtTeamType	`_RespyMgmtTeamType.RespyMgmtTeamType = $projection.TeamType`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PTEAMHEADER	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (15)

Key	Field	Source Table	Source Field
KEY	RespyMgmtTeamID
KEY	LanguageKey	I_RespyMgmtTeamDescription	Language
	TeamName	I_RespyMgmtTeamHeaderDetail	TeamName
	RespyMgmtGlobalTeamID	I_RespyMgmtTeamHeaderDetail	RespyMgmtGlobalTeamID
	TeamDescription	I_RespyMgmtTeamDescription	TeamDescription
	TeamStatus	I_RespyMgmtTeamHeaderDetail	TeamStatus
	TeamType	I_RespyMgmtTeamHeaderDetail	RespyMgmtTeamType
	TeamCategory	_RespyMgmtTeamType	RespyMgmtTeamCategoryForSearch
	CreationDateTime	I_RespyMgmtTeamHeaderAdminData	CreationDateTime
	CreatedByUser	I_RespyMgmtTeamHeaderAdminData	CreatedByUser
	LastChangeDateTime	I_RespyMgmtTeamHeaderAdminData	LastChangeDateTime
	LastChangedByUser	I_RespyMgmtTeamHeaderAdminData	LastChangedByUser
	StartDate	I_RespyMgmtTeamHeaderDetail	StartDate
	EndDate	I_RespyMgmtTeamHeaderDetail	EndDate
	_AllLevelSuperTeam		_AllLevelSuperTeam

@AbapCatalog.sqlViewName: 'PTEAMHEADER'

@VDM.private: true
@VDM.viewType: #COMPOSITE

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

define view P_RespyMgmtTeamHeader
  as select from    I_RespyMgmtTeamHeaderDetail    as Team
  //left outer join P_RespyMgmtTeamHeaderDet     as _TeamDetail      on _TeamDetail.ObjectID = Team.RespyMgmtTeamID

  //Urgent: Put condition for team details begda and endda for bringing only current records.

    left outer join I_RespyMgmtTeamDescription     as _TeamDescription on  _TeamDescription.RespyMgmtTeamID = Team.RespyMgmtTeamID
                                                                       and _TeamDescription.Language        = $session.system_language
    left outer join I_RespyMgmtTeamHeaderAdminData as _AdminData       on _AdminData.RespyMgmtTeamID = Team.RespyMgmtTeamID
  association [0..*] to I_RespyMgmtSuperTeamOfAllLevel as _AllLevelSuperTeam on $projection.RespyMgmtTeamID = _AllLevelSuperTeam.RespyMgmtTeamID
  association [0..1] to I_RespyMgmtTeamType            as _RespyMgmtTeamType on _RespyMgmtTeamType.RespyMgmtTeamType = $projection.TeamType
{
  key cast(Team.RespyMgmtTeamID as hrobjid)             as RespyMgmtTeamID,
  key _TeamDescription.Language                         as LanguageKey,
      Team.TeamName                                     as TeamName,
      Team.RespyMgmtGlobalTeamID,
      _TeamDescription.TeamDescription                  as TeamDescription,
      Team.TeamStatus                                   as TeamStatus,
      Team.RespyMgmtTeamType                            as TeamType,
      _RespyMgmtTeamType.RespyMgmtTeamCategoryForSearch as TeamCategory,
      _AdminData.CreationDateTime                       as CreationDateTime,
      _AdminData.CreatedByUser                          as CreatedByUser,
      _AdminData.LastChangeDateTime                     as LastChangeDateTime,
      _AdminData.LastChangedByUser                      as LastChangedByUser,
      Team.StartDate                                    as StartDate,
      Team.EndDate                                      as EndDate,
      _AllLevelSuperTeam
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESPYMGMTTEAMDESCRIPTION",
"I_RESPYMGMTTEAMHEADERADMINDATA",
"I_RESPYMGMTTEAMHEADERDETAIL",
"I_RESPYMGMTTEAMTYPE"
],
"ASSOCIATED":
[
"I_RESPYMGMTSUPERTEAMOFALLLEVEL",
"I_RESPYMGMTTEAMTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_RespyMgmtTeamHeader view