The complete list of SAP Tables in Financials module. The most commonly used Tables are at the top of the list. Click on a sub-module to see the Tables specific to that module.

SAP Financials Tables by Sub-Module

FIN General Tables

Go to top of the page
S.No Table Description Table Type
1 NODE_KEY Node Table for Link Between ALV Tree and GIDNR Structure
2 REVAL Evaluation - Evaluation, determination of price gain Structure
3 RPROF Profit and loss (for BAV) Structure
4 FEBMKA Manual Bank Statement - General Fields Structure
5 FEBEP Electronic Bank Statement Line Items Transparent Table
6 FEBKO Electronic Bank Statement Header Records Transparent Table
7 INDEXS Index Values (Secur. Index) Structure
8 CODE2 Property description in an abbreviated or language-independe Structure
9 T028G Allocate External to Internal Transactions Transparent Table
10 VTVBAR NPVs of OTC transactions Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN General Tables
Go to top

Financials Basis Tables (FIN-FB)

Go to top of the page
S.No Table Description Table Type
1 FINB_TR_DEST FINB TR: RFC Destinations for Transport Methods Transparent Table
2 FINB_S_SBU_BUFFER_HASH_KEY Buffer Structure with Hash Key (Shared Buffer) Structure
3 UGMDTRANS FIN Master Data: Cluster Table for Transport Transparent Table
4 UGMD_S_SEL Row Structure: Selection Condition (Range per Field) Structure
5 ACCLEGENT0C Legal Entity Transparent Table
6 ACCJOURNAL0T Obsolete: Former Text Table for the Journals in the ACC Doc. Transparent Table
7 ACCLOGOBJCAT0T Logistical Object Categories Transparent Table
8 ACCLEGENT0T Texts for Legal Entities Transparent Table
9 ACCACCTGROUP0C Account Group Transparent Table
10 ACCACCOUNT0C G/L account Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Financials Basis Tables (FIN-FB)
Go to top

Financial Supply Chain Management Tables (FIN-FSCM)

Go to top of the page
S.No Table Description Table Type
1 NODE_KEY Node Table for Link Between ALV Tree and GIDNR Structure
2 REVAL Evaluation - Evaluation, determination of price gain Structure
3 RPROF Profit and loss (for BAV) Structure
4 FEBMKA Manual Bank Statement - General Fields Structure
5 FEBEP Electronic Bank Statement Line Items Transparent Table
6 FEBKO Electronic Bank Statement Header Records Transparent Table
7 INDEXS Index Values (Secur. Index) Structure
8 CODE2 Property description in an abbreviated or language-independe Structure
9 T028G Allocate External to Internal Transactions Transparent Table
10 VTVBAR NPVs of OTC transactions Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Financial Supply Chain Management Tables (FIN-FSCM)
Go to top

Strategic Enterprise Management Tables (FIN-SEM)

Go to top of the page
S.No Table Description Table Type
1 UCT200G Single Field Selection: GUID Transparent Table
2 UCMP000 Perm. Parameters: Current Cons Area Transparent Table
3 HRPERSONEE Linking Employee / Central Person Transparent Table
4 UCL2040 Log: Stored Logs Transparent Table
5 UMC_YS_DIMVALS Characteristic Values: Identifier, Description Structure
6 UCT9110 Workflow Documents: Approval Actions Transparent Table
7 UCT2010 Single Field Selection: Range for Selection Characteristic Transparent Table
8 UCS020T Task Groups: Text Transparent Table
9 UCS010T Tasks: Text Transparent Table
10 UCF001C Methods Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Strategic Enterprise Management Tables (FIN-SEM)
Go to top

Business Accounting Tables (FIN-BAC)

Go to top of the page
S.No Table Description Table Type
1 CFIORWBS0C FIN Objects for WBS Elements Transparent Table
2 CFIOGMVMT0C FIN Objects for Material Documents (GR-Based IV) Transparent Table
3 CFIOSENTR0C FIN Objects for Services Transparent Table
4 FINACHD Accounting Document Header Transparent Table
5 CFIORPURITM0C FIN Objects for Purchase Order Items Transparent Table
6 CFIPVLOCPRD0C Product Depending on Company/Location Transparent Table
7 FINACITGRI Line Items in the GR/IR Journal Transparent Table
8 CFIORGEN0C FIN Objects for Internal Orders Transparent Table
9 CFICC0C FIN Objects for Cost Centers Transparent Table
10 CFIORSRV0C FIN Objects for Service Orders Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Business Accounting Tables (FIN-BAC)
Go to top

Tables (FIN-CGV)

Go to top of the page
S.No Table Description Table Type
1 FOPC_UPLOAD MIC Excel Upload Structure for HR Org Master Data Structure
2 FOPCAIST AIS Systems for MIC (Text Table) Transparent Table
3 HRP1820 DB Table for Infotype 1820 Transparent Table
4 FOPCPHRE FOPC:: Outgoing Relationships of Physical Informatn Objects Transparent Table
5 FOPCLORI FOPC:: Incoming Relationships of Logical Information Objects Transparent Table
6 FOPCLORE FOPC:: Outgoing Relationships of Logical Information Objects Transparent Table
7 FOPCPHRI FOPC:: Incoming Relationships of Physical Informatn Objects Transparent Table
8 FOPCPHHR FOPC:: Outgoing Hyperlinks from Physical Objects Transparent Table
9 HRP1823 DB Table for Infotype 1823 Transparent Table
10 HRP1806 DB Table for InfoType 1806 Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Tables (FIN-CGV)
Go to top

Business Analytics Tables (FIN-BA)

Go to top of the page
S.No Table Description Table Type
1 CFIORWBS0C FIN Objects for WBS Elements Transparent Table
2 CFIOGMVMT0C FIN Objects for Material Documents (GR-Based IV) Transparent Table
3 CFIOSENTR0C FIN Objects for Services Transparent Table
4 FINACHD Accounting Document Header Transparent Table
5 CFIORPURITM0C FIN Objects for Purchase Order Items Transparent Table
6 CFIPVLOCPRD0C Product Depending on Company/Location Transparent Table
7 FINACITGRI Line Items in the GR/IR Journal Transparent Table
8 CFIORGEN0C FIN Objects for Internal Orders Transparent Table
9 CFICC0C FIN Objects for Cost Centers Transparent Table
10 CFIORSRV0C FIN Objects for Service Orders Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Business Analytics Tables (FIN-BA)
Go to top

Real-Time Consolidation Tables (FIN-RTC)

Go to top of the page
S.No Table Description Table Type
1 ACDOCC Consolidation Journal Transparent Table
2 RTC_ENTITY_M Real-Time Consolidation Entity Mapping Transparent Table
3 RTC_DRR Real-Time Consolidation: Data Release Request Transparent Table
4 ACDOCC_GTT Consolidation Journal (Global Temporary Table) Transparent Table
5 RTC_EXT_SKA1 BPC Extension - G/L Account Transparent Table
6 RTC_PR_LOCK Real-Time Consolidation: Pull Request Lock Transparent Table
7 RTC_CT_ADDDATAG Additional Financial Data - Group currency Transparent Table
8 RTC_P100C Real-Time Consolidation Document Types Transparent Table
9 V_RTC_ACDOCC_MCK Generated Table for View General View Structure
10 RTC_CT_ADDDATA Additional Financial Data Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Real-Time Consolidation Tables (FIN-RTC)
Go to top

SAP Simple Finance data migration Tables (FIN-MIG)

Go to top of the page
S.No Table Description Table Type
1 BSIS_REC Generated Table for View General View Structure
2 FMLV_YEAR Generated Table for View General View Structure
3 FCOV_MIG Generated Table for View General View Structure
4 FINS_MIG_STATUS Overall sFIN migration status Transparent Table
5 FINS_CURTP_MAP Mapping of Currency Type + Valuation to mixed Currency Type Transparent Table
6 FMLV_ACCNT_DET Generated Table for View General View Structure
View the full list of SAP FIN SAP Simple Finance data migration Tables (FIN-MIG)
Go to top

Tables (FIN-FIO)

Go to top of the page
S.No Table Description Table Type
1 FCLM_S_TRACK_INCL Bank Transfer structure for track app - Extension Append Structure
2 FCLM_CP_S_ENTITY_TABLE_VIEW FCLM_CP_S_ENTITY_TABLE_VIEW Structure
3 FCLM_S_BANK_TRANSFER_INCL dummy structure for bank transfer Append Structure
4 FCLM_S_SEARCH_VALUE_HELP_INCL append structure for search value help Append Structure
5 FCLM_S_PAYMENT_METHOD_INCL dummy structure for payment method Append Structure
6 FCLM_CP_S_VIEW_EXTENSION_INCL Customer extension include Structure
7 FCLM_BT_S_SEARCH_VALUE_HELP bank transfer search value help Structure
8 FCLM_S_TRACK Bank Transfer structure for track app Structure
9 FCLM_BT_S_BANK_TRANSFER Bank transfer input data Structure
10 FCLM_BT_S_PAYMENT_METHOD Payment method for bank transfer Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN Tables (FIN-FIO)
Go to top

S4HANA Financial Consolidation[Cloud] Tables (FIN-CS)

Go to top of the page
S.No Table Description Table Type
1 RTC_PULL_REQ Real-Time Consolidation: Pull Request Transparent Table
2 ICCGROUP Generated Table for View General View Structure
3 V_FINCS_FLD_DEF Generated Table for View General View Structure
4 CCNSLDTNJRNLENTR Generated Table for View General View Structure
5 CCSTOTALS22Q Generated Table for View General View Structure
6 CCSTOTALS12Q Generated Table for View General View Structure
7 CCSTOTALSRR11Q Generated Table for View General View Structure
8 CCSTOTALSRR61Q Generated Table for View General View Structure
9 CCSTOTALSRR01Q Generated Table for View General View Structure
10 CCSTOTALSRR21Q Generated Table for View General View Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FIN S4HANA Financial Consolidation[Cloud] Tables (FIN-CS)
Go to top

Most viewed SAP Financials Tables