APS_IAM_W_RTFLD

Transparent Table System Table (transport)

IAM: Restriction Type - Fields

APS_IAM_W_RTFLD is an SAP database table in S/4HANA. IAM: Restriction Type - Fields. It contains 3 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
aps_iam_bc_core_rt_av view_entity left_outer IAM: Business Catalog - Restriction Types AAV
aps_iam_bc_core_rt_bc view_entity left_outer IAM: Business Catalog - Restriction Types BC
APS_IAM_BC_RT_FLD view inner Business Catalog Restriction Type Field
APS_IAM_BR_RES_DEF view inner Get restriction metadata of roles
aps_iam_br_rtf view inner Business Role Aggregatable Restriction Type Fields
APS_IAM_BR_RTF_A view_entity inner Role Aggregatable Restriction Type Field for Apps
APS_IAM_BR_RTF_AD view_entity inner Role Aggregatable RTField Apps in draft
APS_IAM_BR_RTF_D view inner Business Role Aggregatable Restriction Type Fields
APS_IAM_BROLE_CHECK view_entity left_outer BR Check Brole Data
APS_IAM_BROLE_SYNCH_LEADING view_entity inner BR Synch Leading Values
APS_IAM_INFO_APP_RE_BASIC view_entity inner Basic View for App - Restriction Types
aps_iam_info_bc_re_basic view inner Business Catalog - Restriction Field
APS_IAM_INFO_BR_FLD view_entity left_outer Business Role - Restriction Field
APS_IAM_REP_RES_FLD view from IAM Key Figures App Fields
APS_IAM_REP_RES_FLD_DEF view from IAM Key Figures App Field Defaults
APS_IAM_RSTR_FLD_MDV view from IAM Restriction Type Fields
APS_IAM_RSTR_FLD_Names_UI view from Restriction Field - Fiori UI
APS_IAM_RSTR_FLD_UI view from Restriction Type Field - Fiori UI
aps_iam_vrtf_ddl view from Restriction Type Field
i_aps_iam_app_core_rt view_entity left_outer IAM: App - Restriction Types
p_aps_iam_iag_rt_field view_entity from IAM Restriction Type - Fields

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY rtype_id aps_iam_cat_rtype_id
KEY field_name aps_iam_field_name
sort_order order Order

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.

-- IAM: Restriction Type - Fields
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_W_RTFLD (
    RTYPE_ID,    -- aps_iam_cat_rtype_id
    FIELD_NAME,  -- aps_iam_field_name
    SORT_ORDER,  -- Order [order]
    PRIMARY KEY (RTYPE_ID, FIELD_NAME)
);