I_IHBMstrDataObjFieldLabel

DDL: I_IHBMSTRDATAOBJFIELDLABEL Type: view_entity BASIC

IHB MD object Field Label for CDocs

I_IHBMstrDataObjFieldLabel is a Basic CDS View that provides data about "IHB MD object Field Label for CDocs" in SAP S/4HANA. It reads from 2 data sources (dd03l, dd04t) and exposes 8 fields with key fields DatabaseTable, DatabaseTableFieldName.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
dd03l dd03l from
dd04t dd04t inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IHB MD object Field Label for CDocs view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY DatabaseTable dd03l tabname
KEY DatabaseTableFieldName dd03l fieldname
ABAPDataElement dd04t rollname
ABAPDataElementDescription dd04t ddtext
ABAPDataElementHeading dd04t reptext
ABAPShortFieldLabel dd04t scrtext_s
ABAPMediumFieldLabel dd04t scrtext_m
ABAPLongFieldLabel dd04t scrtext_l 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'IHB MD object Field Label for CDocs'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_IHBMstrDataObjFieldLabel
  as select from dd03l
    inner join   dd04t on  dd04t.rollname   = dd03l.rollname
                       and dd04t.ddlanguage = $session.system_language
                       and dd04t.as4local   = dd03l.as4local
                       and dd04t.as4vers    = dd03l.as4vers
{
  key dd03l.tabname   as DatabaseTable,
  key dd03l.fieldname as DatabaseTableFieldName,
      dd04t.rollname  as ABAPDataElement,
      dd04t.ddtext    as ABAPDataElementDescription,
      dd04t.reptext   as ABAPDataElementHeading,
      dd04t.scrtext_s as ABAPShortFieldLabel,
      dd04t.scrtext_m as ABAPMediumFieldLabel,
      dd04t.scrtext_l as ABAPLongFieldLabel
}
where
       dd03l.as4local  =  'A'
  and  dd03l.as4vers   =  '0000'
  and(
       dd03l.tabname   =  '/PF1/DB_IHB_OBJ'
    or dd03l.tabname   =  '/PF1/DB_ACCT_LIM'
    or dd03l.tabname   =  '/PF1/DB_COND'
    or dd03l.tabname   =  '/PF1/DB_GP_ASSGN'
    or dd03l.tabname   =  '/PF1/DB_FEE'
    or dd03l.tabname   =  '/PF1/DB_FEE_DET'
  )
  and  dd03l.fieldname <> '.INCLUDE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03L",
"DD04T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More