GLE_ADB_GR_KFC
ADB GR Key figure values
GLE_ADB_GR_KFC is an SAP database table in S/4HANA. ADB GR Key figure values. It contains 108 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_FinSGLCnsldtnADB | view_entity | from | EXTENSION | Consolidation ADB - Extension |
| I_FinSGLCnsldtnADB | view_entity | from | BASIC | Consolidation Average Daily Balance |
Fields (108)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rclnt | MANDT | Client | |||
| KEY | runid | GLE_DTE_UUID | UUID | |||
| KEY | id | GLE_DTE_UUID | UUID | |||
| KEY | rldnr | RLDNR | Ledger | |||
| KEY | rbukrs | BUKRS | Company Code | |||
| ryear | GJAHR | Fiscal Year | ||||
| poper | POPER | Posting Period | ||||
| usnam | USNAM | User Name | ||||
| timestamp | TIMESTAMP | Time Stamp | ||||
| rtcur | FINS_CURRT | Bal. Transac. Crcy | ||||
| rwcur | FINS_CURRW | Transaction Currency | ||||
| rhcur | FINS_CURRH | CompanyCode Currency | ||||
| rkcur | FINS_CURRK | Global Currency | ||||
| rfccur | FINS_CURRFC | Functional Currency | ||||
| rocur | FINS_CURR1 | Free Defined Crcy 1 | ||||
| rvcur | FINS_CURR2 | Free Defined Crcy 2 | ||||
| rbcur | FINS_CURR3 | Free Defined Crcy 3 | ||||
| rccur | FINS_CURR4 | Free Defined Crcy 4 | ||||
| rdcur | FINS_CURR5 | Free Defined Crcy 5 | ||||
| recur | FINS_CURR6 | Free Defined Crcy 6 | ||||
| rfcur | FINS_CURR7 | Free Defined Crcy 7 | ||||
| rgcur | FINS_CURR8 | Free Defined Crcy 8 | ||||
| rco_ocur | FINS_CO_OCUR | CO Object Currency | ||||
| rgm_ocur | GM_GRANT_CURRENCY | Grant Currency | ||||
| m2davgbal_t | GLE_DTE_ADB_M2DAVGBAL_T | MTD TranCrcy | ||||
| q2davgbal_t | GLE_DTE_ADB_Q2DAVGBAL_T | QTD TranCrcy | ||||
| y2davgbal_t | GLE_DTE_ADB_Y2DAVGBAL_T | YTD TranCrcy | ||||
| m2davgbal_h | GLE_DTE_ADB_M2DAVGBAL_H | MTD CC Crcy | ||||
| q2davgbal_h | GLE_DTE_ADB_Q2DAVGBAL_H | QTD CC Crcy | ||||
| y2davgbal_h | GLE_DTE_ADB_Y2DAVGBAL_H | YTD CC Crcy | ||||
| m2davgbal_k | GLE_DTE_ADB_M2DAVGBAL_K | MTD GloCrcy | ||||
| q2davgbal_k | GLE_DTE_ADB_Q2DAVGBAL_K | QTD GloCrcy | ||||
| y2davgbal_k | GLE_DTE_ADB_Y2DAVGBAL_K | YTD GloCrcy | ||||
| m2davgbal_fc | GLE_DTE_ADB_MTD_ADB_FCC | MTD ADB Funcnl Crcy | ||||
| q2davgbal_fc | GLE_DTE_ADB_QTD_ADB_FCC | QTD ADB FuncnlCrcy | ||||
| y2davgbal_fc | GLE_DTE_ADB_YTD_ADB_FCC | YTD ADB Funcnl Crcy | ||||
| m2davgbal_o | GLE_DTE_ADB_M2DAVGBAL_O | MTD FrDefCrcy1 | ||||
| q2davgbal_o | GLE_DTE_ADB_Q2DAVGBAL_O | QTD FrDefCrcy1 | ||||
| y2davgbal_o | GLE_DTE_ADB_Y2DAVGBAL_O | YTD FrDefCrcy1 | ||||
| m2davgbal_v | GLE_DTE_ADB_M2DAVGBAL_V | MTD FrDefCrcy2 | ||||
| q2davgbal_v | GLE_DTE_ADB_Q2DAVGBAL_V | QTD FrDefCrcy2 | ||||
| y2davgbal_v | GLE_DTE_ADB_Y2DAVGBAL_V | YTD FrDefCrcy2 | ||||
| m2davgbal_b | GLE_DTE_ADB_M2DAVGBAL_B | MTD FrDefCrcy3 | ||||
| q2davgbal_b | GLE_DTE_ADB_Q2DAVGBAL_B | QTD FrDefCrcy3 | ||||
| y2davgbal_b | GLE_DTE_ADB_Y2DAVGBAL_B | YTD FrDefCrcy3 | ||||
| m2davgbal_c | GLE_DTE_ADB_M2DAVGBAL_C | MTD FrDefCrcy4 | ||||
| q2davgbal_c | GLE_DTE_ADB_Q2DAVGBAL_C | QTD FrDefCrcy4 | ||||
| y2davgbal_c | GLE_DTE_ADB_Y2DAVGBAL_C | YTD FrDefCrcy4 | ||||
| m2davgbal_d | GLE_DTE_ADB_M2DAVGBAL_D | MTD FrDefCrcy5 | ||||
| q2davgbal_d | GLE_DTE_ADB_Q2DAVGBAL_D | QTD FrDefCrcy5 | ||||
| y2davgbal_d | GLE_DTE_ADB_Y2DAVGBAL_D | YTD FrDefCrcy5 | ||||
| m2davgbal_e | GLE_DTE_ADB_M2DAVGBAL_E | MTD FrDefCrcy6 | ||||
| q2davgbal_e | GLE_DTE_ADB_Q2DAVGBAL_E | QTD FrDefCrcy6 | ||||
| y2davgbal_e | GLE_DTE_ADB_Y2DAVGBAL_E | YTD FrDefCrcy6 | ||||
| m2davgbal_f | GLE_DTE_ADB_M2DAVGBAL_F | MTD FrDefCrcy7 | ||||
| q2davgbal_f | GLE_DTE_ADB_Q2DAVGBAL_F | QTD FrDefCrcy7 | ||||
| y2davgbal_f | GLE_DTE_ADB_Y2DAVGBAL_F | YTD FrDefCrcy7 | ||||
| m2davgbal_g | GLE_DTE_ADB_M2DAVGBAL_G | MTD FrDefCrcy8 | ||||
| q2davgbal_g | GLE_DTE_ADB_Q2DAVGBAL_G | QTD FrDefCrcy8 | ||||
| y2davgbal_g | GLE_DTE_ADB_Y2DAVGBAL_G | YTD FrDefCrcy8 | ||||
| ktopl | KTOPL | Chart of Accts | ||||
| racct | RACCT | Account Number | ||||
| xblnr | XBLNR1 | Reference | ||||
| zuonr | DZUONR | Assignment | ||||
| rcntr | KOSTL | Cost Center | ||||
| prctr | PRCTR | Profit Center | ||||
| rfarea | FKBER | Functional Area | ||||
| rbusa | GSBER | Business Area | ||||
| kokrs | KOKRS | CO Area | ||||
| segment | FB_SEGMENT | Segment | ||||
| scntr | SKOST | Sender Cost Ctr | ||||
| pprctr | PPRCTR | Partner PC | ||||
| sfarea | SFKBER | Partner FArea | ||||
| sbusa | PARGB | Trdg Part.BA | ||||
| rassc | RASSC | Trading Partner | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| aufnr | AUFNR | Order | ||||
| kunnr | KUNNR | Customer | ||||
| lifnr | LIFNR | Supplier | ||||
| matnr | MATNR | Material | ||||
| matkl_mm | FINS_MATKL_MM | Material Group | ||||
| werks | WERKS_D | Plant | ||||
| rmvct | RMVCT | Transact. Type | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| ps_posid | PS_POSID | WBS Element | ||||
| ps_pspid | PS_PSPID | Project def. | ||||
| fkart | FKART | Billing Type | ||||
| vkorg | VKORG | Sales Org. | ||||
| vtweg | VTWEG | Distr. Channel | ||||
| spart | SPART | Division | ||||
| matnr_copa | FINS_MATNR_PA | Product Sold | ||||
| matkl | FINS_MATKL_PA | Product Sold Group | ||||
| kdgrp | KDGRP | Customer Group | ||||
| land1 | COBL_LAND1_GP | Country/Region | ||||
| brsch | BRSCH | Industry | ||||
| bzirk | BZIRK | Sales District | ||||
| kunre | KUNRE | Bill-to Party | ||||
| kunwe | KUNWE | Ship-to Party | ||||
| konzs | KONZS | Group | ||||
| rbunit | FINCS_MD_BUNIT | Consolidation Unit | ||||
| rbuptr | FINCS_MD_BUPTR | Partner Unit | ||||
| rcomp | RCOMP_D | Company | ||||
| ritclg | FC_ITCLG | Cons. COA | ||||
| ritem | FINCS_FSI_ITEM | FS Item | ||||
| sityp | FC_SITYP | Subitem Category | ||||
| subit | FC_SITEM | Subitem | ||||
| acdoc_eew_dummy | CFD_DUMMY | Dummy | ||||
| dummy_incl_eew_cobl | CFD_DUMMY | Dummy |
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.
-- ADB GR Key figure values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLE_ADB_GR_KFC (
RCLNT, -- Client [MANDT]
RUNID, -- UUID [GLE_DTE_UUID]
ID, -- UUID [GLE_DTE_UUID]
RLDNR, -- Ledger [RLDNR]
RBUKRS, -- Company Code [BUKRS]
RYEAR, -- Fiscal Year [GJAHR]
POPER, -- Posting Period [POPER]
USNAM, -- User Name [USNAM]
TIMESTAMP, -- Time Stamp [TIMESTAMP]
RTCUR, -- Bal. Transac. Crcy [FINS_CURRT]
RWCUR, -- Transaction Currency [FINS_CURRW]
RHCUR, -- CompanyCode Currency [FINS_CURRH]
RKCUR, -- Global Currency [FINS_CURRK]
RFCCUR, -- Functional Currency [FINS_CURRFC]
ROCUR, -- Free Defined Crcy 1 [FINS_CURR1]
RVCUR, -- Free Defined Crcy 2 [FINS_CURR2]
RBCUR, -- Free Defined Crcy 3 [FINS_CURR3]
RCCUR, -- Free Defined Crcy 4 [FINS_CURR4]
RDCUR, -- Free Defined Crcy 5 [FINS_CURR5]
RECUR, -- Free Defined Crcy 6 [FINS_CURR6]
RFCUR, -- Free Defined Crcy 7 [FINS_CURR7]
RGCUR, -- Free Defined Crcy 8 [FINS_CURR8]
RCO_OCUR, -- CO Object Currency [FINS_CO_OCUR]
RGM_OCUR, -- Grant Currency [GM_GRANT_CURRENCY]
M2DAVGBAL_T, -- MTD TranCrcy [GLE_DTE_ADB_M2DAVGBAL_T]
Q2DAVGBAL_T, -- QTD TranCrcy [GLE_DTE_ADB_Q2DAVGBAL_T]
Y2DAVGBAL_T, -- YTD TranCrcy [GLE_DTE_ADB_Y2DAVGBAL_T]
M2DAVGBAL_H, -- MTD CC Crcy [GLE_DTE_ADB_M2DAVGBAL_H]
Q2DAVGBAL_H, -- QTD CC Crcy [GLE_DTE_ADB_Q2DAVGBAL_H]
Y2DAVGBAL_H, -- YTD CC Crcy [GLE_DTE_ADB_Y2DAVGBAL_H]
M2DAVGBAL_K, -- MTD GloCrcy [GLE_DTE_ADB_M2DAVGBAL_K]
Q2DAVGBAL_K, -- QTD GloCrcy [GLE_DTE_ADB_Q2DAVGBAL_K]
Y2DAVGBAL_K, -- YTD GloCrcy [GLE_DTE_ADB_Y2DAVGBAL_K]
M2DAVGBAL_FC, -- MTD ADB Funcnl Crcy [GLE_DTE_ADB_MTD_ADB_FCC]
Q2DAVGBAL_FC, -- QTD ADB FuncnlCrcy [GLE_DTE_ADB_QTD_ADB_FCC]
Y2DAVGBAL_FC, -- YTD ADB Funcnl Crcy [GLE_DTE_ADB_YTD_ADB_FCC]
M2DAVGBAL_O, -- MTD FrDefCrcy1 [GLE_DTE_ADB_M2DAVGBAL_O]
Q2DAVGBAL_O, -- QTD FrDefCrcy1 [GLE_DTE_ADB_Q2DAVGBAL_O]
Y2DAVGBAL_O, -- YTD FrDefCrcy1 [GLE_DTE_ADB_Y2DAVGBAL_O]
M2DAVGBAL_V, -- MTD FrDefCrcy2 [GLE_DTE_ADB_M2DAVGBAL_V]
Q2DAVGBAL_V, -- QTD FrDefCrcy2 [GLE_DTE_ADB_Q2DAVGBAL_V]
Y2DAVGBAL_V, -- YTD FrDefCrcy2 [GLE_DTE_ADB_Y2DAVGBAL_V]
M2DAVGBAL_B, -- MTD FrDefCrcy3 [GLE_DTE_ADB_M2DAVGBAL_B]
Q2DAVGBAL_B, -- QTD FrDefCrcy3 [GLE_DTE_ADB_Q2DAVGBAL_B]
Y2DAVGBAL_B, -- YTD FrDefCrcy3 [GLE_DTE_ADB_Y2DAVGBAL_B]
M2DAVGBAL_C, -- MTD FrDefCrcy4 [GLE_DTE_ADB_M2DAVGBAL_C]
Q2DAVGBAL_C, -- QTD FrDefCrcy4 [GLE_DTE_ADB_Q2DAVGBAL_C]
Y2DAVGBAL_C, -- YTD FrDefCrcy4 [GLE_DTE_ADB_Y2DAVGBAL_C]
M2DAVGBAL_D, -- MTD FrDefCrcy5 [GLE_DTE_ADB_M2DAVGBAL_D]
Q2DAVGBAL_D, -- QTD FrDefCrcy5 [GLE_DTE_ADB_Q2DAVGBAL_D]
Y2DAVGBAL_D, -- YTD FrDefCrcy5 [GLE_DTE_ADB_Y2DAVGBAL_D]
M2DAVGBAL_E, -- MTD FrDefCrcy6 [GLE_DTE_ADB_M2DAVGBAL_E]
Q2DAVGBAL_E, -- QTD FrDefCrcy6 [GLE_DTE_ADB_Q2DAVGBAL_E]
Y2DAVGBAL_E, -- YTD FrDefCrcy6 [GLE_DTE_ADB_Y2DAVGBAL_E]
M2DAVGBAL_F, -- MTD FrDefCrcy7 [GLE_DTE_ADB_M2DAVGBAL_F]
Q2DAVGBAL_F, -- QTD FrDefCrcy7 [GLE_DTE_ADB_Q2DAVGBAL_F]
Y2DAVGBAL_F, -- YTD FrDefCrcy7 [GLE_DTE_ADB_Y2DAVGBAL_F]
M2DAVGBAL_G, -- MTD FrDefCrcy8 [GLE_DTE_ADB_M2DAVGBAL_G]
Q2DAVGBAL_G, -- QTD FrDefCrcy8 [GLE_DTE_ADB_Q2DAVGBAL_G]
Y2DAVGBAL_G, -- YTD FrDefCrcy8 [GLE_DTE_ADB_Y2DAVGBAL_G]
KTOPL, -- Chart of Accts [KTOPL]
RACCT, -- Account Number [RACCT]
XBLNR, -- Reference [XBLNR1]
ZUONR, -- Assignment [DZUONR]
RCNTR, -- Cost Center [KOSTL]
PRCTR, -- Profit Center [PRCTR]
RFAREA, -- Functional Area [FKBER]
RBUSA, -- Business Area [GSBER]
KOKRS, -- CO Area [KOKRS]
SEGMENT, -- Segment [FB_SEGMENT]
SCNTR, -- Sender Cost Ctr [SKOST]
PPRCTR, -- Partner PC [PPRCTR]
SFAREA, -- Partner FArea [SFKBER]
SBUSA, -- Trdg Part.BA [PARGB]
RASSC, -- Trading Partner [RASSC]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
AUFNR, -- Order [AUFNR]
KUNNR, -- Customer [KUNNR]
LIFNR, -- Supplier [LIFNR]
MATNR, -- Material [MATNR]
MATKL_MM, -- Material Group [FINS_MATKL_MM]
WERKS, -- Plant [WERKS_D]
RMVCT, -- Transact. Type [RMVCT]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
PS_POSID, -- WBS Element [PS_POSID]
PS_PSPID, -- Project def. [PS_PSPID]
FKART, -- Billing Type [FKART]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
SPART, -- Division [SPART]
MATNR_COPA, -- Product Sold [FINS_MATNR_PA]
MATKL, -- Product Sold Group [FINS_MATKL_PA]
KDGRP, -- Customer Group [KDGRP]
LAND1, -- Country/Region [COBL_LAND1_GP]
BRSCH, -- Industry [BRSCH]
BZIRK, -- Sales District [BZIRK]
KUNRE, -- Bill-to Party [KUNRE]
KUNWE, -- Ship-to Party [KUNWE]
KONZS, -- Group [KONZS]
RBUNIT, -- Consolidation Unit [FINCS_MD_BUNIT]
RBUPTR, -- Partner Unit [FINCS_MD_BUPTR]
RCOMP, -- Company [RCOMP_D]
RITCLG, -- Cons. COA [FC_ITCLG]
RITEM, -- FS Item [FINCS_FSI_ITEM]
SITYP, -- Subitem Category [FC_SITYP]
SUBIT, -- Subitem [FC_SITEM]
ACDOC_EEW_DUMMY, -- Dummy [CFD_DUMMY]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
PRIMARY KEY (RCLNT, RUNID, ID, RLDNR, RBUKRS)
);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