Fields (40)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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