Fields (26)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | db_key | RT_KEY | 6 |
| KEY | kokrs | kokrs | 1 |
| KEY | prctr | prctr,prctr_rt | 3 |
| KEY | valid_from | valid_from | 1 |
| application_id | ApplicationId | 4 | |
| building_block_id | BuildingBlockId | 2 | |
| comm_area_id | RT_COMM_AREA_ID | 2 | |
| crea_date_time | RT_CREA_DATE_TIME | 2 | |
| initiative_id | RT_INITIATIVE_ID | 6 | |
| initiative_version | RT_INITIATIVE_VERSION | 5 | |
| initiative_version_key | RT_INITIATIVE_VERSION_KEY | 1 | |
| life_cycle_status | RT_LIFE_CYCLE_STATUS | 6 | |
| marker | marker | 1 | |
| orgl_change | orgl_change | 16 | |
| pob_id | pob_id | 1 | |
| profile_id | SegProfileId | 2 | |
| reassgmt_status | reassgmt_status | 1 | |
| reassgmt_timestamp | reassgmt_timestamp | 1 | |
| ref_org_struc | RT_REF_ORG_STRUC | 2 | |
| schedule_date_time | RT_SCHEDULE_DATE_TIME | 6 | |
| segment | segment,segment_new | 2 | |
| segment_old | segment_old | 2 | |
| segmentation_model_id | SegmentationModelId | 2 | |
| segmentation_object | SegObjectId | 2 | |
| text | VariantDescription | 1 | |
| valid_to | valid_to | 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 RT (
DB_KEY,
KOKRS,
PRCTR,
VALID_FROM,
APPLICATION_ID,
BUILDING_BLOCK_ID,
COMM_AREA_ID,
CREA_DATE_TIME,
INITIATIVE_ID,
INITIATIVE_VERSION,
INITIATIVE_VERSION_KEY,
LIFE_CYCLE_STATUS,
MARKER,
ORGL_CHANGE,
POB_ID,
PROFILE_ID,
REASSGMT_STATUS,
REASSGMT_TIMESTAMP,
REF_ORG_STRUC,
SCHEDULE_DATE_TIME,
SEGMENT,
SEGMENT_OLD,
SEGMENTATION_MODEL_ID,
SEGMENTATION_OBJECT,
TEXT,
VALID_TO,
PRIMARY KEY (DB_KEY, KOKRS, PRCTR, VALID_FROM)
);
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