FndEI_C_LastDataSync_Views

DDL: FNDEI_C_LASTDATASYNC_VIEWS SQL: FNDEIDATASY_VIEW Type: view

Proj of last data sync for views

FndEI_C_LastDataSync_Views is a CDS View that provides data about "Proj of last data sync for views" in SAP S/4HANA. It reads from 7 data sources and exposes 8 fields with key fields ViewReplicationID, ViewName.

Data Sources (7)

SourceAliasJoin Type
FndEI_PC_TableReplStatus_01 FndEI_PC_TableReplStatus_01 left_outer
FndEI_PC_TableReplStatus_02 FndEI_PC_TableReplStatus_02 left_outer
FndEI_PC_TableReplStatus_03 FndEI_PC_TableReplStatus_03 left_outer
FndEI_PC_TableReplStatus_04 FndEI_PC_TableReplStatus_04 left_outer
FndEI_PC_TableReplStatus_05 FndEI_PC_TableReplStatus_05 left_outer
FndEI_PC_TableReplStatus_06 FndEI_PC_TableReplStatus_06 left_outer
FndEI_I_Configuration_Status scope from

Parameters (1)

NameTypeDefault
P_TargetSystem fndei_target_sys_uuid

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIDATASY_VIEW 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 views view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ViewReplicationID FndEI_I_Configuration_Status ViewReplicationID TgtSysUUID
KEY ViewName FndEI_I_Configuration_Status ViewName View Name
TableRepStatus_06 tabrep06 TableRepStatus_06
TableRepStatus_05 tabrep05 TableRepStatus_05
TableRepStatus_04 tabrep04 TableRepStatus_04
TableRepStatus_03 tabrep03 TableRepStatus_03
TableRepStatus_02 tabrep02 TableRepStatus_02
TableRepStatus_01 tabrep01 TableRepStatus_01

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_Views.
-- 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_VIEW
-- Parameters: P_TargetSystem : fndei_target_sys_uuid

CREATE VIEW FndEI_C_LastDataSync_Views AS
SELECT
  scope.ViewReplicationID AS ViewReplicationID,
  scope.ViewName AS ViewName,
  tabrep06.TableRepStatus_06 AS TableRepStatus_06,
  tabrep05.TableRepStatus_05 AS TableRepStatus_05,
  tabrep04.TableRepStatus_04 AS TableRepStatus_04,
  tabrep03.TableRepStatus_03 AS TableRepStatus_03,
  tabrep02.TableRepStatus_02 AS TableRepStatus_02,
  tabrep01.TableRepStatus_01 AS TableRepStatus_01
FROM FndEI_I_Configuration_Status AS scope
LEFT OUTER JOIN FndEI_PC_TableReplStatus_06 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FndEI_PC_TableReplStatus_05 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FndEI_PC_TableReplStatus_04 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FndEI_PC_TableReplStatus_03 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FndEI_PC_TableReplStatus_02 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FndEI_PC_TableReplStatus_01 ON /* join condition not captured in parsed metadata */
;