FMRBT
Summary table RIB (no more updated!)
FMRBT is an SAP database table in S/4HANA. Summary table RIB (no more updated!). It contains 76 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_FMRBT_Old | view | from | BASIC |
Fields (76)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rclnt | mandt | Client | |||
| KEY | rldnr | rldnr | Ledger | |||
| KEY | rrcty | rrcty | Record Type | |||
| KEY | rvers | rvers | Version | |||
| KEY | ryear | gjahr | Fiscal Year | |||
| KEY | robjnr | gobjnr_r | Object number | |||
| KEY | cobjnr | gobjnr_c | Trans.objct no. | |||
| KEY | sobjnr | gobjnr_s | Partner obj.no. | |||
| KEY | rtcur | rtcur | Currency | |||
| KEY | drcrk | shkzg | Debit/Credit | |||
| KEY | rpmax | rpmax | Period | |||
| rfikrs | fikrs | FM Area | ||||
| rfund | bp_geber | Fund | ||||
| rfundsctr | fistl | Funds Center | ||||
| rcmmtitem | fm_fipex | Commitment Item | ||||
| rfuncarea | fm_farea | Functional Area | ||||
| ruserdim | fm_userdim | Customer Field | ||||
| rgrant_nbr | gm_grant_nbr | Grant | ||||
| rmeasure | fm_measure | Funded Program | ||||
| rcvrgrp_9 | fmce_cvrgrp | Cover Group | ||||
| budget_pd_9 | fm_budget_period | Budget Period | ||||
| ceffyear_9 | gnjhr | YCE | ||||
| ribproc_9 | burb_process | RIB Process | ||||
| logsys | logsys | Logical system | ||||
| tslvt | tslvt9_cs | Bal. c/f TC | ||||
| tsl01 | tslxx9_cs | Total TC | ||||
| tsl02 | tslxx9_cs | Total TC | ||||
| tsl03 | tslxx9_cs | Total TC | ||||
| tsl04 | tslxx9_cs | Total TC | ||||
| tsl05 | tslxx9_cs | Total TC | ||||
| tsl06 | tslxx9_cs | Total TC | ||||
| tsl07 | tslxx9_cs | Total TC | ||||
| tsl08 | tslxx9_cs | Total TC | ||||
| tsl09 | tslxx9_cs | Total TC | ||||
| tsl10 | tslxx9_cs | Total TC | ||||
| tsl11 | tslxx9_cs | Total TC | ||||
| tsl12 | tslxx9_cs | Total TC | ||||
| tsl13 | tslxx9_cs | Total TC | ||||
| tsl14 | tslxx9_cs | Total TC | ||||
| tsl15 | tslxx9_cs | Total TC | ||||
| tsl16 | tslxx9_cs | Total TC | ||||
| hslvt | hslvt9_cs | Bal. c/f LC | ||||
| hsl01 | hslxx9_cs | Total LC | ||||
| hsl02 | hslxx9_cs | Total LC | ||||
| hsl03 | hslxx9_cs | Total LC | ||||
| hsl04 | hslxx9_cs | Total LC | ||||
| hsl05 | hslxx9_cs | Total LC | ||||
| hsl06 | hslxx9_cs | Total LC | ||||
| hsl07 | hslxx9_cs | Total LC | ||||
| hsl08 | hslxx9_cs | Total LC | ||||
| hsl09 | hslxx9_cs | Total LC | ||||
| hsl10 | hslxx9_cs | Total LC | ||||
| hsl11 | hslxx9_cs | Total LC | ||||
| hsl12 | hslxx9_cs | Total LC | ||||
| hsl13 | hslxx9_cs | Total LC | ||||
| hsl14 | hslxx9_cs | Total LC | ||||
| hsl15 | hslxx9_cs | Total LC | ||||
| hsl16 | hslxx9_cs | Total LC | ||||
| kslvt | kslvt9_cs | Bal. c/f GC | ||||
| ksl01 | kslxx9_cs | Total GC | ||||
| ksl02 | kslxx9_cs | Total GC | ||||
| ksl03 | kslxx9_cs | Total GC | ||||
| ksl04 | kslxx9_cs | Total GC | ||||
| ksl05 | kslxx9_cs | Total GC | ||||
| ksl06 | kslxx9_cs | Total GC | ||||
| ksl07 | kslxx9_cs | Total GC | ||||
| ksl08 | kslxx9_cs | Total GC | ||||
| ksl09 | kslxx9_cs | Total GC | ||||
| ksl10 | kslxx9_cs | Total GC | ||||
| ksl11 | kslxx9_cs | Total GC | ||||
| ksl12 | kslxx9_cs | Total GC | ||||
| ksl13 | kslxx9_cs | Total GC | ||||
| ksl14 | kslxx9_cs | Total GC | ||||
| ksl15 | kslxx9_cs | Total GC | ||||
| ksl16 | kslxx9_cs | Total GC | ||||
| cspred | cspred | Distr. key 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.
-- Summary table RIB (no more updated!)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMRBT (
RCLNT, -- Client [mandt]
RLDNR, -- Ledger [rldnr]
RRCTY, -- Record Type [rrcty]
RVERS, -- Version [rvers]
RYEAR, -- Fiscal Year [gjahr]
ROBJNR, -- Object number [gobjnr_r]
COBJNR, -- Trans.objct no. [gobjnr_c]
SOBJNR, -- Partner obj.no. [gobjnr_s]
RTCUR, -- Currency [rtcur]
DRCRK, -- Debit/Credit [shkzg]
RPMAX, -- Period [rpmax]
RFIKRS, -- FM Area [fikrs]
RFUND, -- Fund [bp_geber]
RFUNDSCTR, -- Funds Center [fistl]
RCMMTITEM, -- Commitment Item [fm_fipex]
RFUNCAREA, -- Functional Area [fm_farea]
RUSERDIM, -- Customer Field [fm_userdim]
RGRANT_NBR, -- Grant [gm_grant_nbr]
RMEASURE, -- Funded Program [fm_measure]
RCVRGRP_9, -- Cover Group [fmce_cvrgrp]
BUDGET_PD_9, -- Budget Period [fm_budget_period]
CEFFYEAR_9, -- YCE [gnjhr]
RIBPROC_9, -- RIB Process [burb_process]
LOGSYS, -- Logical system [logsys]
TSLVT, -- Bal. c/f TC [tslvt9_cs]
TSL01, -- Total TC [tslxx9_cs]
TSL02, -- Total TC [tslxx9_cs]
TSL03, -- Total TC [tslxx9_cs]
TSL04, -- Total TC [tslxx9_cs]
TSL05, -- Total TC [tslxx9_cs]
TSL06, -- Total TC [tslxx9_cs]
TSL07, -- Total TC [tslxx9_cs]
TSL08, -- Total TC [tslxx9_cs]
TSL09, -- Total TC [tslxx9_cs]
TSL10, -- Total TC [tslxx9_cs]
TSL11, -- Total TC [tslxx9_cs]
TSL12, -- Total TC [tslxx9_cs]
TSL13, -- Total TC [tslxx9_cs]
TSL14, -- Total TC [tslxx9_cs]
TSL15, -- Total TC [tslxx9_cs]
TSL16, -- Total TC [tslxx9_cs]
HSLVT, -- Bal. c/f LC [hslvt9_cs]
HSL01, -- Total LC [hslxx9_cs]
HSL02, -- Total LC [hslxx9_cs]
HSL03, -- Total LC [hslxx9_cs]
HSL04, -- Total LC [hslxx9_cs]
HSL05, -- Total LC [hslxx9_cs]
HSL06, -- Total LC [hslxx9_cs]
HSL07, -- Total LC [hslxx9_cs]
HSL08, -- Total LC [hslxx9_cs]
HSL09, -- Total LC [hslxx9_cs]
HSL10, -- Total LC [hslxx9_cs]
HSL11, -- Total LC [hslxx9_cs]
HSL12, -- Total LC [hslxx9_cs]
HSL13, -- Total LC [hslxx9_cs]
HSL14, -- Total LC [hslxx9_cs]
HSL15, -- Total LC [hslxx9_cs]
HSL16, -- Total LC [hslxx9_cs]
KSLVT, -- Bal. c/f GC [kslvt9_cs]
KSL01, -- Total GC [kslxx9_cs]
KSL02, -- Total GC [kslxx9_cs]
KSL03, -- Total GC [kslxx9_cs]
KSL04, -- Total GC [kslxx9_cs]
KSL05, -- Total GC [kslxx9_cs]
KSL06, -- Total GC [kslxx9_cs]
KSL07, -- Total GC [kslxx9_cs]
KSL08, -- Total GC [kslxx9_cs]
KSL09, -- Total GC [kslxx9_cs]
KSL10, -- Total GC [kslxx9_cs]
KSL11, -- Total GC [kslxx9_cs]
KSL12, -- Total GC [kslxx9_cs]
KSL13, -- Total GC [kslxx9_cs]
KSL14, -- Total GC [kslxx9_cs]
KSL15, -- Total GC [kslxx9_cs]
KSL16, -- Total GC [kslxx9_cs]
CSPRED, -- Distr. key currency [cspred]
PRIMARY KEY (RCLNT, RLDNR, RRCTY, RVERS, RYEAR, ROBJNR, COBJNR, SOBJNR, RTCUR, DRCRK, RPMAX)
);
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