R

R is an SAP database table in S/4HANA. It contains 40 fields.

Fields (40)

KeyField CDS FieldsUsed in Views
KEY rdim_guid id 1
KEY request_tsn request_tsn 1
KEY rule_id rule_id 1
KEY storage storage 2
auth_group auth_grp 1
constant_value_t res_unit,ret_unit 2
creation_end_time creation_end_time 1
datatarget datatarget 1
devclass abap_package 1
FunctionalArea FunctionalArea1 1
GLAccount GLAccount1 1
iteration iteration 1
last_time_stamp last_time_stamp 1
LedgerFiscalYear LedgerFiscalYear 2
maint_type maint_type 1
max_instances max_instances 1
NUMBER c 1
object_type_id object_type 1
okStatus okStatus 1
ps_provider ps_provider 1
rdim ranking_factor 1
records records 1
request_is_in_process request_is_in_process 1
request_status request_status 1
request_status_before_deletion request_status_before_deletion 1
requestStatus requestStatus 1
residence_period residence_period 1
rule_end_date end_date 1
rule_start_date start_date 1
rule_status rule_status 1
run_id run_id 1
status status 1
syst_date syst_date 1
syst_time syst_time 1
systemDate systemDate 1
timestmp_aen_seg changed_on 1
tlogo tlogo 1
uname uname 1
x_invalidated x_invalidated 1
x_reset x_reset 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R (
    RDIM_GUID,
    REQUEST_TSN,
    RULE_ID,
    STORAGE,
    AUTH_GROUP,
    CONSTANT_VALUE_T,
    CREATION_END_TIME,
    DATATARGET,
    DEVCLASS,
    FUNCTIONALAREA,
    GLACCOUNT,
    ITERATION,
    LAST_TIME_STAMP,
    LEDGERFISCALYEAR,
    MAINT_TYPE,
    MAX_INSTANCES,
    NUMBER,
    OBJECT_TYPE_ID,
    OKSTATUS,
    PS_PROVIDER,
    RDIM,
    RECORDS,
    REQUEST_IS_IN_PROCESS,
    REQUEST_STATUS,
    REQUEST_STATUS_BEFORE_DELETION,
    REQUESTSTATUS,
    RESIDENCE_PERIOD,
    RULE_END_DATE,
    RULE_START_DATE,
    RULE_STATUS,
    RUN_ID,
    STATUS,
    SYST_DATE,
    SYST_TIME,
    SYSTEMDATE,
    TIMESTMP_AEN_SEG,
    TLOGO,
    UNAME,
    X_INVALIDATED,
    X_RESET,
    PRIMARY KEY (RDIM_GUID, REQUEST_TSN, RULE_ID, STORAGE)
);