SAP Accounting Tables

Are you looking for the right table related to SAP Accounting Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Accounting (FS-CML-AC) module.

Top 10 tables in Accounting

TableDescription
TDIOA_SCHEME_DEFProfile Definition for Interest on Arrears Calculation
TDIOA_GSTEERGeneral Control Data for Interest on Arrears Calculation
TDIOA_BOInterest on Arrears Active in BO Interest on Arrears Calc.
VDDUNN_DISPDunning run data per loan and dunning run
TDDUNNLVLDunning Levels by Number of Overdue Installments
VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation
TDIOA_SCHEMETText Table for Profile Definition IOA Calculation
TDIOA_TEMPLTXTTemplate Texts for Interest on Arrears Calculation
TDDUNN_CORRESPFields for Correspondence, e.g. Action if Undeliverable
TDIOA_FT_BALANCEAssignment of Flows to Flow Type Grouping - IOA Calculation

List of tables in Accounting

TableDescription
TDIOA_SCHEME_DEFProfile Definition for Interest on Arrears Calculation
TDIOA_GSTEERGeneral Control Data for Interest on Arrears Calculation
TDIOA_BOInterest on Arrears Active in BO Interest on Arrears Calc.
VDDUNN_DISPDunning run data per loan and dunning run
TDDUNNLVLDunning Levels by Number of Overdue Installments
VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation
TDIOA_SCHEMETText Table for Profile Definition IOA Calculation
TDIOA_TEMPLTXTTemplate Texts for Interest on Arrears Calculation
TDDUNN_CORRESPFields for Correspondence, e.g. Action if Undeliverable
TDIOA_FT_BALANCEAssignment of Flows to Flow Type Grouping - IOA Calculation
TDIOA_BAL_CONDAssignment Condition Type to Flow Type Grouping - IOA Calc.
TDIOA_TRIV_AMTTrivial Amount per Currency and Profile IOA Calculation
TDIOA_SCHEME_BALAssignment of Product Type to Profile and Flow Type Grouping
VDIOA_CALC_CFOriginal Documents Without Model Account Int. on Arrears
TDIOA_TEMPLTemplate for Interest On Arrears Calculation
TDIOA_NOPOSTCALCFlow Types Without Recalculation
VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation