fiscds_trk_fld_text

DDL: FISVD_TRK_FLD_TEXT SQL: FISV_TRK_FLD_TXT Type: view

Changed Field Name of Dcoument

fiscds_trk_fld_text is a CDS View that provides data about "Changed Field Name of Dcoument" in SAP S/4HANA. It reads from 3 data sources (dd03l, dd04l, dd04t) and exposes 4 fields with key fields fieldname, tabname, language.

Data Sources (3)

SourceAliasJoin Type
dd03l a from
dd04l b inner
dd04t c inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_TRK_FLD_TXT view
EndUserText.label Changed Field Name of Dcoument view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY fieldname dd03l fieldname
KEY tabname dd03l tabname
KEY language dd04t ddlanguage
ddtext dd04t ddtext
@AbapCatalog.sqlViewName: 'FISV_TRK_FLD_TXT'
@EndUserText.label: 'Changed Field Name of Dcoument'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view fiscds_trk_fld_text    
as select from dd03l as a inner join dd04l as b on a.rollname = b.rollname 
 inner join dd04t as c on b.rollname = c.rollname {
    key a.fieldname,
    key a.tabname,
    key c.ddlanguage as language, 
    c.ddtext
}   
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03L",
"DD04L",
"DD04T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/