I_DFS_DcncdOpsLinkedRemoteSyst

DDL: I_DFS_DCNCDOPSLINKEDREMOTESYST Type: view_entity BASIC

Linked Remote Systems

I_DFS_DcncdOpsLinkedRemoteSyst is a Basic CDS View that provides data about "Linked Remote Systems" in SAP S/4HANA. It reads from 1 data source (/isdfps/ale_sys) and exposes 6 fields with key field DfsDcncdOpsLogicalSystem.

Data Sources (1)

SourceAliasJoin Type
/isdfps/ale_sys /isdfps/ale_sys from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Linked Remote Systems view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DfsDcncdOpsLogicalSystem logsys Source system
DfsDcncdOpsSystemConncnMode plan_con_mode System Type
DfsDcncdOpsCentralLogicalSyst central_sys Central System
DfsDcncdOpsRemoteLogicalSystem RFCDEST
DfsDcncdOpsLogicalSystemType appl_type System Type
DfsDcncdOpsAddlInformationText dfsdcncdopsadditionalinfotext Addl Syst Info

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 I_DFS_DcncdOpsLinkedRemoteSyst.
-- 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.

CREATE VIEW I_DFS_DcncdOpsLinkedRemoteSyst AS
SELECT
  logsys AS DfsDcncdOpsLogicalSystem,
  plan_con_mode AS DfsDcncdOpsSystemConncnMode,
  central_sys AS DfsDcncdOpsCentralLogicalSyst,
  cast ( rfcdest as /isdfps/sync_rfcdest preserving type ) AS DfsDcncdOpsRemoteLogicalSystem,
  appl_type AS DfsDcncdOpsLogicalSystemType,
  dfsdcncdopsadditionalinfotext AS DfsDcncdOpsAddlInformationText
FROM /isdfps/ale_sys
;