FndEI_C_CcdrTableWithStatus

DDL: FNDEI_C_CCDRTABLEWITHSTATUS SQL: FNDEICCDRTAB Type: view

Display list of CCDR tables with status

FndEI_C_CcdrTableWithStatus is a CDS View that provides data about "Display list of CCDR tables with status" in SAP S/4HANA. It reads from 3 data sources (FndEI_I_CustomerCtrDataRepl, dd02t, FndEI_I_TableReplicationStatus) and exposes 5 fields with key fields ViewReplicationID, TableName.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
FndEI_I_CustomerCtrDataRepl CCDRTable from
dd02t Tabdesc inner
FndEI_I_TableReplicationStatus TableReplicationStatus left_outer

Parameters (1)

NameTypeDefault
p_ViewReplicationID fndei_target_sys_uuid

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FNDEICCDRTAB view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #META view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Display list of CCDR tables with status view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ViewReplicationID FndEI_I_CustomerCtrDataRepl ViewReplicationID
KEY TableName FndEI_I_CustomerCtrDataRepl TableName
TableRepStatus FndEI_I_TableReplicationStatus TableRepStatus
IsCCDRActive FndEI_I_CustomerCtrDataRepl Active
Description dd02t ddtext 
@AbapCatalog.sqlViewName: 'FNDEICCDRTAB'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #META
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Display list of CCDR tables with status'
define view FndEI_C_CcdrTableWithStatus
  with parameters
    p_ViewReplicationID : fndei_target_sys_uuid
  as select from    FndEI_I_CustomerCtrDataRepl    as CCDRTable
    left outer join FndEI_I_TableReplicationStatus as TableReplicationStatus on  CCDRTable.ViewReplicationID              = $parameters.p_ViewReplicationID
                                                                             and TableReplicationStatus.TableName         = CCDRTable.TableName
                                                                             and TableReplicationStatus.ViewReplicationID = CCDRTable.ViewReplicationID
    inner join      dd02t                          as Tabdesc                on Tabdesc.tabname = CCDRTable.TableName
{
  key CCDRTable.ViewReplicationID           as ViewReplicationID,
  key CCDRTable.TableName                   as TableName,
      TableReplicationStatus.TableRepStatus as TableRepStatus,
      CCDRTable.Active                      as IsCCDRActive,
      Tabdesc.ddtext                        as Description

}
where
      Tabdesc.as4local            = 'A'
  and Tabdesc.ddlanguage          = 'E'
  and CCDRTable.Active            = 'X'
  and CCDRTable.ViewReplicationID = $parameters.p_ViewReplicationID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FNDEI_I_CUSTOMERCTRDATAREPL",
"FNDEI_I_TABLEREPLICATIONSTATUS",
"DD02T",
"T000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More