P_RESPYMGMTTEAMHEADERMAINOBJ

CDS View

P_RESPYMGMTTEAMHEADERMAINOBJ is a CDS View in S/4HANA. It contains 5 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 5 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_RespyMgmtTeamHeaderBasic view from BASIC Team Header Basic data
I_RespyMgmtTeamHeaderDetail view from BASIC Team Header Details
P_RespyMgmtLeafTeamIndicator view from BASIC
P_RespyMgmtSubTeamOfAllLevel view from BASIC
P_RespyMgmtSuperTeamOfAllLevel view left_outer BASIC

Fields (5)

KeyField CDS FieldsUsed in Views
KEY ObjectID RespyMgmtTeamID 3
EndDate EndDate 2
ObjectType ObjectType 1
RespyMgmtTeamName RespyMgmtSuperTeamName,RespyMgmtTeamName,TeamName 3
StartDate StartDate 2 
@AbapCatalog.sqlViewName: 'PTEAMHDRMAINOBJ'
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'ObjectID'
@AbapCatalog.preserveKey: true
define view P_RespyMgmtTeamHeaderMainObj
  as select from hrp1000 as MainObject
{
  key MainObject.plvar    as PlanVersion,
  key MainObject.otype    as ObjectType,
  key MainObject.objid    as ObjectID,
  key MainObject.istat    as PlanningStatus,
  key MainObject.begda    as StartDate,
  key MainObject.endda    as EndDate,
  key MainObject.langu    as Language,
  key MainObject.seqnr    as SequenceNumber,
      MainObject.infty    as InfoType,
      MainObject.aedtm    as ChangedOn,
      MainObject.mc_stext as RespyMgmtTeamName
}
where
        MainObject.otype = 'TH'
  and   MainObject.plvar = '01'
  and   MainObject.infty = '1000'
  and   MainObject.istat = '1'
  and   MainObject.histo = ' '
  and(
        MainObject.begda <= $session.system_date
    and MainObject.endda >= $session.system_date
  );
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More