/ISDFPS/ALE_SYS
DFPS-Systemlandschaft - Verbindungsparameter und Flags
/ISDFPS/ALE_SYS is an SAP database table in S/4HANA. DFPS-Systemlandschaft - Verbindungsparameter und Flags. It contains 37 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DFS_DcncdOpsLinkedRemoteSyst | view_entity | from | BASIC | Linked Remote Systems |
| I_DFS_NmbrLogSystemsVH | view_entity | from | COMPOSITE | Logsys of Local and its Decentrl Systems |
| I_DFS_NmbrLogSystemsVH | view_entity | union | COMPOSITE | Logsys of Local and its Decentrl Systems |
Fields (37)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | logsys | /isdfps/logsys | Logical System | |||
| plan_con_mode | /isdfps/ale_connection_mode | System Type | ||||
| central_sys | /isdfps/ale_central_system | Central System | ||||
| rfcdest | /isdfps/sync_rfcdest | RFCDEST | ||||
| delta_t | btcdelay_d | Repetition pause | ||||
| n_max_repeat_t | btctries | Connection attempts | ||||
| delta_o | /isdfps/ale_delta_o | Delta O | ||||
| delta_s | /isdfps/ale_delta_s | Delta S | ||||
| m_max_repeat_s | /isdfps/ale_repeat_count | Repetitions | ||||
| delta_ale_ip | /isdfps/ale_delta_inproc | Delta IP | ||||
| delta_ale_ip_ups | /isdfps/ale_delta_inproc_ups | Delta IP After UPS | ||||
| handle_sync | /isdfps/sync_flag | Synchronize | ||||
| ping_count | /isdfps/ping_count | No. PINGS | ||||
| ping_timeout | /isdfps/ping_timeout | PING Timeout | ||||
| ping_max_loss | /isdfps/ping_loss | PING Loss | ||||
| transport_dest | /isdfps/trsp_rfcdest | TrspDest | ||||
| tr_ftp_host | /isdfps/hostname | Host Name | ||||
| tr_ftp_pw | /isdfps/tr_ftp_pw | TR Password | ||||
| state_info_dest | /isdfps/state_info_rfcdest | InfoDest | ||||
| gnr_admin_dest | /isdfps/gnr_rfcdest | GNR Dest. | ||||
| user_admin_dest | /isdfps/user_rfcdest | RFC Dest. for CUA | ||||
| cua_sys | /isdfps/cua_central_system | CUA Central System | ||||
| appl_type | /isdfps/appl_type | System Type | ||||
| user_dist | /isdfps/user_dist | User Distribution | ||||
| add_actgroups | /isdfps/add_agr | Additional Roles | ||||
| us_filter | /isdfps/us_filter | User Filter | ||||
| assign_actgroups | /isdfps/assign_agr | Assign Roles | ||||
| assign_profiles | /isdfps/assign_prof | Assign Profiles | ||||
| ale_routing_sys | /isdfps/ale_routing_system | ALE Routing System | ||||
| eh_org_type | otype | Object type | ||||
| eh_org_plvar | plvar | Plan version | ||||
| eh_org_unit | /isdfps/org_unit_err_handling | Person Resp. EH | ||||
| dfsdcncdopsadditionalinfotext | dfs_dis_addl_info | Addl Syst Info | ||||
| mobile_app | /syclo/core_mobile_app_dte | Mobile Application | ||||
| user_guid | dfsuser_guid | User GUID | ||||
| sap_userid | uname | User Name | ||||
| server_group | ssi_server_group | Server Group |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- DFPS-Systemlandschaft - Verbindungsparameter und Flags
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ISDFPS/ALE_SYS (
LOGSYS, -- Logical System [/isdfps/logsys]
PLAN_CON_MODE, -- System Type [/isdfps/ale_connection_mode]
CENTRAL_SYS, -- Central System [/isdfps/ale_central_system]
RFCDEST, -- RFCDEST [/isdfps/sync_rfcdest]
DELTA_T, -- Repetition pause [btcdelay_d]
N_MAX_REPEAT_T, -- Connection attempts [btctries]
DELTA_O, -- Delta O [/isdfps/ale_delta_o]
DELTA_S, -- Delta S [/isdfps/ale_delta_s]
M_MAX_REPEAT_S, -- Repetitions [/isdfps/ale_repeat_count]
DELTA_ALE_IP, -- Delta IP [/isdfps/ale_delta_inproc]
DELTA_ALE_IP_UPS, -- Delta IP After UPS [/isdfps/ale_delta_inproc_ups]
HANDLE_SYNC, -- Synchronize [/isdfps/sync_flag]
PING_COUNT, -- No. PINGS [/isdfps/ping_count]
PING_TIMEOUT, -- PING Timeout [/isdfps/ping_timeout]
PING_MAX_LOSS, -- PING Loss [/isdfps/ping_loss]
TRANSPORT_DEST, -- TrspDest [/isdfps/trsp_rfcdest]
TR_FTP_HOST, -- Host Name [/isdfps/hostname]
TR_FTP_PW, -- TR Password [/isdfps/tr_ftp_pw]
STATE_INFO_DEST, -- InfoDest [/isdfps/state_info_rfcdest]
GNR_ADMIN_DEST, -- GNR Dest. [/isdfps/gnr_rfcdest]
USER_ADMIN_DEST, -- RFC Dest. for CUA [/isdfps/user_rfcdest]
CUA_SYS, -- CUA Central System [/isdfps/cua_central_system]
APPL_TYPE, -- System Type [/isdfps/appl_type]
USER_DIST, -- User Distribution [/isdfps/user_dist]
ADD_ACTGROUPS, -- Additional Roles [/isdfps/add_agr]
US_FILTER, -- User Filter [/isdfps/us_filter]
ASSIGN_ACTGROUPS, -- Assign Roles [/isdfps/assign_agr]
ASSIGN_PROFILES, -- Assign Profiles [/isdfps/assign_prof]
ALE_ROUTING_SYS, -- ALE Routing System [/isdfps/ale_routing_system]
EH_ORG_TYPE, -- Object type [otype]
EH_ORG_PLVAR, -- Plan version [plvar]
EH_ORG_UNIT, -- Person Resp. EH [/isdfps/org_unit_err_handling]
DFSDCNCDOPSADDITIONALINFOTEXT, -- Addl Syst Info [dfs_dis_addl_info]
MOBILE_APP, -- Mobile Application [/syclo/core_mobile_app_dte]
USER_GUID, -- User GUID [dfsuser_guid]
SAP_USERID, -- User Name [uname]
SERVER_GROUP, -- Server Group [ssi_server_group]
PRIMARY KEY (LOGSYS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA