P_RESPYMGMTTEAMDESCRIPTION

CDS View

P_RESPYMGMTTEAMDESCRIPTION is a CDS View in S/4HANA. It contains 3 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 3 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RespyMgmtTeamDescription view from BASIC Team Description
R_RespyMgmtTeamHeaderAPIText view from BASIC Responsibility Team Header - Text

Fields (3)

KeyField CDS FieldsUsed in Views
KEY LanguageKey Language 1
KEY ObjectID RespyMgmtTeamID 1
tline TeamDescription 1 
@AbapCatalog.sqlViewName: 'PTEAMHDRDESC'

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

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog.preserveKey: true

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

define view P_RespyMgmtTeamDescription
  as select from    hrp1002 as TeamDescription
    left outer join hrt1002 as _Text on _Text.tabnr = TeamDescription.tabnr
{
  key objid                 as ObjectID,
  key langu                 as LanguageKey,
      otype                 as ObjectType,
      TeamDescription.tabnr as TableReference,
      _Text.tabseqnr        as SequenceNumber,
      _Text.tline
}
where
        otype = 'TH'
  and   plvar = '01'
  and   histo = ' '
  and   istat = '1'
  and(
        begda <= $session.system_date
    and endda >= $session.system_date
  );
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1002",
"HRT1002"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More