I_FreeDfndTblFieldSemanticText

DDL: I_FREEDFNDTBLFIELDSEMANTICTEXT SQL: IFREDEFTABFLDSMT Type: view BASIC

Free Defined Table Field Semantic - Text

I_FreeDfndTblFieldSemanticText is a Basic CDS View that provides data about "Free Defined Table Field Semantic - Text" in SAP S/4HANA. It reads from 1 data source (tcn01) and exposes 17 fields with key fields Language, FreeDefinedTableFieldSemantic. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
tcn01 tcn01 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_FreeDfndTableFieldSemantic _FreeDfndTableFieldSemantic $projection.FreeDefinedTableFieldSemantic = _FreeDfndTableFieldSemantic.FreeDefinedTableFieldSemantic

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IFREDEFTABFLDSMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 001 view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.representativeKey FreeDefinedTableFieldSemantic view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
EndUserText.label Free Defined Table Field Semantic - Text view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Language spras
KEY FreeDefinedTableFieldSemantic slwid
FreeDfndTableFieldSemanticName ktext
FreeDefinedAttribute01Label swrt0
FreeDefinedAttribute02Label swrt1
FreeDefinedAttribute03Label swrt2
FreeDefinedAttribute04Label swrt3
FreeDefinedQuantity1Label swrt4
FreeDefinedQuantity2Label swrt5
FreeDefinedAmount1Label swrt6
FreeDefinedAmount2Label swrt7
FreeDefinedDate1Label swrt8
FreeDefinedDate2Label swrt9
FreeDefinedIndicator1Label swrt10
FreeDefinedIndicator2Label swrt11
Associations_Language
_FreeDfndTableFieldSemantic _FreeDfndTableFieldSemantic 
@AbapCatalog.sqlViewName: 'IFREDEFTABFLDSMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering: { status: #ACTIVE, type: #GENERIC, numberOfKeyFields: 001 }
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
@ObjectModel.representativeKey: 'FreeDefinedTableFieldSemantic'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING }     --> check!
@VDM.viewType: #BASIC
@EndUserText.label: 'Free Defined Table Field Semantic - Text'

define view I_FreeDfndTblFieldSemanticText
  as select from tcn01

  association [0..1] to I_Language                   as _Language                   on $projection.Language = _Language.Language
  association [0..1] to I_FreeDfndTableFieldSemantic as _FreeDfndTableFieldSemantic on $projection.FreeDefinedTableFieldSemantic = _FreeDfndTableFieldSemantic.FreeDefinedTableFieldSemantic

{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key spras                                               as Language,
      @ObjectModel.foreignKey.association: '_FreeDfndTableFieldSemantic'
      @ObjectModel.text.element: 'FreeDfndTableFieldSemanticName'
  key slwid                                               as FreeDefinedTableFieldSemantic,
      @Semantics.text: true
      ktext                                               as FreeDfndTableFieldSemanticName,
      swrt0                                               as FreeDefinedAttribute01Label,
      swrt1                                               as FreeDefinedAttribute02Label,
      swrt2                                               as FreeDefinedAttribute03Label,
      swrt3                                               as FreeDefinedAttribute04Label,
      swrt4                                               as FreeDefinedQuantity1Label,
      swrt5                                               as FreeDefinedQuantity2Label,
      swrt6                                               as FreeDefinedAmount1Label,
      swrt7                                               as FreeDefinedAmount2Label,
      swrt8                                               as FreeDefinedDate1Label,
      swrt9                                               as FreeDefinedDate2Label,
      swrt10                                              as FreeDefinedIndicator1Label,
      swrt11                                              as FreeDefinedIndicator2Label,

      --- Associations ---
      _Language,
      _FreeDfndTableFieldSemantic
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TCN01"
],
"ASSOCIATED":
[
"I_FREEDFNDTABLEFIELDSEMANTIC",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More