I_GHOProdnNtwkLinkTableFieldT

DDL: I_GHOPRODNNTWKLINKTABLEFIELDT SQL: IGHOTABLEFIELDT Type: view BASIC

Prodn Ntwk/Clstr Link Table Field - Text

I_GHOProdnNtwkLinkTableFieldT is a Basic CDS View that provides data about "Prodn Ntwk/Clstr Link Table Field - Text" in SAP S/4HANA. It reads from 1 data source (dd03l) and exposes 2 fields.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd03l _fieldname from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGHOTABLEFIELDT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Prodn Ntwk/Clstr Link Table Field - Text view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
ChangeDocDatabaseTableField dd03l fieldname
DatabaseTableFieldName _fieldtext ddtext 
@AbapCatalog.sqlViewName: 'IGHOTABLEFIELDT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Prodn Ntwk/Clstr Link Table Field - Text'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #BASIC

define view I_GHOProdnNtwkLinkTableFieldT
  as select from           dd03l as _fieldname

    left outer to one join dd04t as _fieldtext on  
        _fieldtext.rollname                     = _fieldname.rollname
                                               and _fieldtext.ddlanguage = $session.system_language
{
  _fieldname.fieldname as ChangeDocDatabaseTableField,
  _fieldtext.ddtext    as DatabaseTableFieldName
}
where
  (
       _fieldname.tabname   =  'INETX'
    or _fieldname.tabname   =  'INET'
  )
  and  _fieldname.fieldname <> 'KEY'

  //

//  as select from dd03l

//

//  association [0..*] to dd04t as _fieldtext on  $projection.rollname = _fieldtext.rollname

//                                            and _fieldtext.ddlanguage = $session.system_language                                          

//                                            

//{

//  key rollname,

//   fieldname as ChangeDocDatabaseTableField,

//   _fieldtext 

//}

// where (

//       tabname   =  'INETX'

//    or tabname   =  'INET'

//  )

//  and fieldname <> 'KEY'

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03L",
"DD04T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More