P_Cfd_Reg_Transfer_Text_Source

DDL: P_CFD_REG_TRANSFER_TEXT_SOURCE SQL: P_CFD_TRANS_TS Type: view Package: S_CFD_REGISTRY_DB

Determine Source of Texts

P_Cfd_Reg_Transfer_Text_Source is a CDS View that provides data about "Determine Source of Texts" in SAP S/4HANA. It reads from 4 data sources (cfd_w_trans, tadir, cfd_w_trans_t, cfd_w_trans_t) and exposes 2 fields. Part of development package S_CFD_REGISTRY_DB.

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
cfd_w_trans DataTransfer from
tadir MasterRecord inner
cfd_w_trans_t SourceText left_outer
cfd_w_trans_t TargetText left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_TRANS_TS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Determine Source of Texts view

Fields (2)

KeyFieldSource TableSource FieldDescription
SourceUseRegistryTranslation
TargetUseRegistryTranslation 
@AbapCatalog.sqlViewName: 'P_CFD_TRANS_TS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Determine Source of Texts'
define view P_Cfd_Reg_Transfer_Text_Source as 
  select from cfd_w_trans as DataTransfer
  inner join tadir as MasterRecord
    on MasterRecord.obj_name = DataTransfer.data_transfer_name
   and MasterRecord.object   = 'CFDT'
  left outer join cfd_w_trans_t as SourceText
    on SourceText.data_transfer_name = DataTransfer.data_transfer_name
   and SourceText.language           = MasterRecord.masterlang
   and SourceText.is_source          = 'X'
  left outer join cfd_w_trans_t as TargetText
    on TargetText.data_transfer_name = DataTransfer.data_transfer_name
   and TargetText.language           = MasterRecord.masterlang   
   and TargetText.is_source          = ''
 {
  key DataTransfer.data_transfer_name,
  
  case when SourceText.language <> '' and SourceText.description <> '' then 'X' else ' ' end as SourceUseRegistryTranslation,
  case when TargetText.language <> '' and TargetText.description <> '' then 'X' else ' ' end as TargetUseRegistryTranslation
}

Learn More