I_EHSAGENTNAMETEXT

CDS View

Agent Name

I_EHSAGENTNAMETEXT is a CDS View in S/4HANA. Agent Name. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CurrentEHSAgentNameText view from COMPOSITE Current EHS Agent Name Text
I_CurrentEHSAgentNameText view from COMPOSITE Current Agent Name 
@EndUserText.label: 'Agent Name'
@Analytics.dataExtraction.enabled:true
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'EHSAgentUUID'
@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'IEHSAGTNAMET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MASTER }

define view I_EHSAgentNameText
  as select from P_EHSAgentNameUnion
  association [0..1] to I_Language as _Language on  $projection.Language = _Language.Language
  association [1..1] to I_EHSAgent as _EHSAgent on  $projection.RevisionEndDate = _EHSAgent.RevisionEndDate
                                                and $projection.EHSAgentUUID    = _EHSAgent.EHSAgentUUID

{

  key cast( EHSAgentUUID as ehhss_agent_combined_uuid_ref preserving type ) as EHSAgentUUID,

      @Semantics.businessDate.to
  key RevisionEndDate,

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key Language,
      _Language,

      EHSAgentRevisionUUID,

      @Semantics.businessDate.from
      RevisionStartDate,

      @Semantics.text:true
      cast( EHSAgentName as ehhss_agent_combined_name ) as EHSAgentName,

      _EHSAgent,
      EHSAgentType

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EHSAGENTNAMEUNION"
],
"ASSOCIATED":
[
"I_EHSAGENT",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More