RDBRA_REC_VAR_PL
RA RDB: Single Records for Key Figure Category P&L
RDBRA_REC_VAR_PL is an SAP database table in S/4HANA. RA RDB: Single Records for Key Figure Category P&L. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TrsyValueAtRiskProfitAndLoss | view | from | BASIC | Treasury Value at Risk Profit and Loss |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | keydate | RDB_KEYDATE | Key date | |||
| KEY | recordnr | RDB_RECNR | Single record | |||
| KEY | keyfigure | AFWKF_DEFINITION | Key Figure | |||
| KEY | rknoten | RDBRA_RKNOTEN | Risk Hier. Node | |||
| KEY | simidx | RDBRA_SIMIDX | Simulatn Index | |||
| objnr | JBOBJNR | Object Number | ||||
| mra_kf_set | AFWGO_MRA_KF_SET | MR Key Figure Set | ||||
| profitandloss | RDBRA_PROFIT_AND_LOSS | Profit/Loss | ||||
| evaluation_currency | AFW_EVAL_CURRENCY | Evaluation Currency |
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.
-- RA RDB: Single Records for Key Figure Category P&L
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RDBRA_REC_VAR_PL (
MANDT, -- Client [MANDT]
KEYDATE, -- Key date [RDB_KEYDATE]
RECORDNR, -- Single record [RDB_RECNR]
KEYFIGURE, -- Key Figure [AFWKF_DEFINITION]
RKNOTEN, -- Risk Hier. Node [RDBRA_RKNOTEN]
SIMIDX, -- Simulatn Index [RDBRA_SIMIDX]
OBJNR, -- Object Number [JBOBJNR]
MRA_KF_SET, -- MR Key Figure Set [AFWGO_MRA_KF_SET]
PROFITANDLOSS, -- Profit/Loss [RDBRA_PROFIT_AND_LOSS]
EVALUATION_CURRENCY, -- Evaluation Currency [AFW_EVAL_CURRENCY]
PRIMARY KEY (MANDT, KEYDATE, RECORDNR, KEYFIGURE, RKNOTEN, SIMIDX)
);
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