FndEI_C_LastDataSync_Tables

DDL: FNDEI_C_LASTDATASYNC_TABLES SQL: FNDEIDATASY_TAB Type: view Package: FNDEI_VR_CDS_COMPOSITE
3 Fields 3 Data Sources

Proj of last data sync for tables

FndEI_C_LastDataSync_Tables is a CDS View that provides data about "Proj of last data sync for tables" in SAP S/4HANA. It reads from 3 data sources (FndEI_I_TableViewRelation, FndEI_I_Configuration_Status, FndEI_I_TableReplicationStatus) and exposes 3 fields with key fields ViewName, TableName. Part of development package FNDEI_VR_CDS_COMPOSITE.

Data Sources (3)

SourceAliasJoin Type
FndEI_I_TableViewRelation cdstab inner
FndEI_I_Configuration_Status scope from
FndEI_I_TableReplicationStatus tabrep inner

Parameters (2)

NameTypeDefault
P_TargetSystem fndei_target_sys_uuid
P_CdsView sobj_name

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIDATASY_TAB view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Proj of last data sync for tables view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ViewName FndEI_I_TableViewRelation ViewName View Name
KEY TableName FndEI_I_TableReplicationStatus TableName Table/View Name
TableRepStatus FndEI_I_TableReplicationStatus TableRepStatus Tabl RepSt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FndEI_C_LastDataSync_Tables.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FNDEIDATASY_TAB
-- Parameters: P_TargetSystem : fndei_target_sys_uuid, P_CdsView : sobj_name

CREATE VIEW FndEI_C_LastDataSync_Tables AS
SELECT
  cdstab.ViewName AS ViewName,
  tabrep.TableName AS TableName,
  tabrep.TableRepStatus AS TableRepStatus
FROM FndEI_I_Configuration_Status AS scope
INNER JOIN FndEI_I_TableViewRelation AS cdstab ON /* join condition not captured in parsed metadata */
INNER JOIN FndEI_I_TableReplicationStatus AS tabrep ON /* join condition not captured in parsed metadata */
;

Learn More