I_EntProjChgDocTableFieldText

DDL: I_ENTPROJCHGDOCTABLEFIELDTEXT Type: view BASIC Package: VDM_PPM_OBJECTS_CHANGEDOC

Chg Doc Names of changed Table Fields

I_EntProjChgDocTableFieldText is a Basic CDS View that provides data about "Chg Doc Names of changed Table Fields" in SAP S/4HANA. It reads from 1 data source (/s4ppm/cd_fld_t) and exposes 5 fields with key fields ChangeDocDatabaseTableField, DatabaseTable, Language. It has 1 association to related views. Part of development package VDM_PPM_OBJECTS_CHANGEDOC.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
/s4ppm/cd_fld_t TableFields from

Associations (1)

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

Annotations (13)

NameValueLevelField
EndUserText.label Chg Doc Names of changed Table Fields view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.sqlViewName IPROJCHGDOCFLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ChangeDocDatabaseTableField view
ObjectModel.usageType.serviceQuality B view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.dataClass CUSTOMIZING view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocDatabaseTableField /s4ppm/cd_fld_t field
KEY DatabaseTable /s4ppm/cd_fld_t tabname
KEY Language /s4ppm/cd_fld_t language
ChangeDocDatabaseTblFieldText /s4ppm/cd_fld_t description
_Language _Language 
@EndUserText.label: 'Chg Doc Names of changed Table Fields'

@VDM: {
   viewType: #BASIC,
   lifecycle.contract.type: #SAP_INTERNAL_API
}

@AbapCatalog: {
   sqlViewName: 'IPROJCHGDOCFLD',
   compiler.compareFilter: true,
   preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   dataCategory: #TEXT,
   representativeKey: 'ChangeDocDatabaseTableField',
   usageType: { 
     serviceQuality: 'B',
     sizeCategory: 'M',
     dataClass: 'CUSTOMIZING'
   }
}

define view I_EntProjChgDocTableFieldText as select from  /s4ppm/cd_fld_t as TableFields

   association [0..1] to I_Language     as _Language on $projection.Language    = _Language.Language
   
 {     
    key TableFields.field             as ChangeDocDatabaseTableField,    
    key TableFields.tabname           as DatabaseTable,
    
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    @UI.hidden: true
    key TableFields.language          as Language, 

        @Semantics.text: true
        TableFields.description       as ChangeDocDatabaseTblFieldText,

        _Language
}  



//--------- Old version  with read field texts from data elements ------------

// --------is working, but texts are not nice as in Fiori Apps 

//define view I_EntProjChgDocTableFieldText as select from  dd03l as TableFields

//

////   association [1..*]  to dd04t as _ElemText  on $projection.ABAPDataElement = _ElemText.rollname  

// left outer to many join  dd04t as ElemText  on TableFields.rollname = ElemText.rollname  

//

//   association [0..1] to I_Language     as _Language on $projection.Language    = _Language.Language

//   

// {     

//    key TableFields.fieldname         as ChangeDocDatabaseTableField,    

//    key TableFields.tabname           as DatabaseTable,

//        TableFields.rollname          as ABAPDataElement,

//         ElemText.reptext              as ChangeDocDatabaseTblFieldText,

////        ElemText.scrtext_s              as ChangeDocDatabaseTblFieldText,

////        ElemText.scrtext_m              as ChangeDocDatabaseTblFieldText,

//        ElemText.ddlanguage          as Language, 

////        _ElemText,

//        _Language

//}  

////   where (    TableFields.tabname = '/S4PPM/PSTASK_CD' 

////           or TableFields.tabname = '/S4PPM/BLKFCT_CD' )

Learn More