SAP Localization Financials Tables

Are you looking for the right table related to SAP Localization Financials 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 Localization Financials (FI-LOC-FI) module.

Top 10 tables in Localization Financials

TableDescription
RFIDPTPRPERTYPDefine Pro-Rata Period Type
FITDOMC_FSCLINESForm Structure: Lines (Oman)
IDITSR_POSNUMForeign Trade Declaration: Line Items
IDITSR_DOCTYPForeign Trade Declaration: Document Types
FIACRS_REP_RUNACRS Report Run
IDOM_CC_COMBAllowed combinations for Company Types (Oman)
IDES_SIAssign Number Range for Self Invoices to Company Code
FIMY_IDTY_INDCDTable for Identifying Industry code for Malaysia
IDGS_OBS_DEACTReactivated obsolete programs
RFIDPTPRENTVALDefine Pro-Rata Validation Entity

List of tables in Localization Financials

TableDescription
RFIDPTPRPERTYPDefine Pro-Rata Period Type
FITDOMC_FSCLINESForm Structure: Lines (Oman)
IDITSR_POSNUMForeign Trade Declaration: Line Items
IDITSR_DOCTYPForeign Trade Declaration: Document Types
FIACRS_REP_RUNACRS Report Run
IDOM_CC_COMBAllowed combinations for Company Types (Oman)
IDES_SIAssign Number Range for Self Invoices to Company Code
FIMY_IDTY_INDCDTable for Identifying Industry code for Malaysia
IDGS_OBS_DEACTReactivated obsolete programs
RFIDPTPRENTVALDefine Pro-Rata Validation Entity
VGTBSTax Box Structure
DEFTAX_ITEMData for Deferred Taxes
T007L_MYTable for Grouping Tax Balances for Malaysia
PTDART_TAX_DATATax Code Data
FIGEOMC_REPFORMAssign PDF Form to Report (Oman)
T007_ITRetail Value-Added Tax Settings
IDTDOM_CC_ACTCompany code activities (Oman)
FITDOM_FSCNODESForm Structure: Nodes (Oman)
RGOFFICELocal Tax Offices
IDT007RANew Grouping for Tax Amounts
VGTAXBOXTax Boxes
IDTW_VATVAT (Taiwan): Current Values
T007K_MYTable for Grouping Tax Basis Balances for Malaysia
RFIDPTDPRDefinitive Pro-Rata coefficient
IDOM_CC_COMB_ACTAllowed activities for Forms-Final Tax Statemenet (Oman)
IDTDOM_CC_ACTTCompany code activities description (Oman)
RFIDPTAAVPro-Rata Asset Acquisition Value
VGTGTBAssignment of Tax Groups to Tax Boxes
FITR_ELGLACTDS_TText Table For Electronic Ledger GL Account Description.
VGTAXBOXTTax Boxes text table
FICA_TXJ_FED_RELCanada specific classification of Tax Jurisdiction codes
IDEU_TAX_MAPMapping Tax Codes to Posting Types
FITRC_INIT_SEQNOTurkey : Intial Sequence Number For Electronic Ledger
RFIDPTDCADPro-Rata DPR adjustment documents
IDSL_GUCAccounts for Deferred Tax (Slovakia)
SECCODESection Code
IDEU_ACCOUNT_MAPMapping Posting Types to G/L Accounts
IDITSR_DOCTYPDForeign Trade Declaration: Document Type Description
RFIDPTFCATAGDefine Field Catalog Entries for Posting Aggregation Key
IDITSR_DMEE_TREEDMEE tree IDs for International Trade Statistic Reporting
IDITSR12_POSNUMDForeign Trade Declaration(Austria): Line Item Description
FIACRS_REP_ITEMACRS TPP Report Item
T007DTDeferred Tax Rules
IDSL_GDDTReport Date for Deferred Tax (Slovakia)
RFIDPTPOSTAGDefine Pro-Rata Posting Aggregation Key
MAP_TAX_CODEMap Tax code to the Corrections Tax code
FIGLO_LOGDTAccess Log Information
VGTBS_CTTax Box Structure Type Control Table
VGTBSTTax Box Structure Text Table
IDTDOM_CC_EXEMExemptions for Tax Dceclaration(Oman)
FITR_ELPAYMTHD_TTurkey : Text Table For Payment Method.
IDOM_CC_COMPAdditional Company Code Parametres (Oman)
IDTDOM_CC_EXEMTExemptions for Tax Dceclaration Text (Oman)
FIPDCOM_LOGOman PDC Printing log
BUSTYPEType of Business
IDUN_C_ASDCAdditional Customizing for ASDC
RFIDPTPOSTAG_TPro-Rata posting aggregation key description
SECCODETName of Section Code
FITDOM_FSCSUBNODForm Structure: Nodes (Oman)
J_1BBRANCHBusiness Place
RFIDPTFIELDAGPro-Rata posting aggregation key fields for adjustments
FITDOM_FSCLINESTForm Structure: Lines - Texts (Oman)
FIPDCOMC_PRDEVMaintain printers for users to Oman PDC
FITRC_ELPYMT_MAPTurkey : Assign Electronic Ledger Payment Method
IDITSR12_POSNUMForeign Trade Declaration(Austria): Line Items
FITR_EL_SEQNOTurkey : Electronic Ledger Sequence Number
FIGN_EXTDOCTYP_TText Table For External Document Type.
IDEU_VATAcquisition Tax
IDITSR_GLDATAGL accounts for company code and country
INDUSTYPEType of Industry
RGOFFICETName of Regional Tax Office
FIPDCOMC_PRPARParameters for Oman PDC printing
FITRC_ELPAYMTHDTurkey : Electronic Ledger Payment Method
VGTBTYPEAllowed Tax Box types
FITDOMC_FSCDEFForm Structure: Definition (Oman)
FIAPOM_WTHCLRDTDeclare Withholding Tax clearing details (Oman)
IDBUPLA_ACTIVEActivate Business Place per country
FITRC_ELGLACTDESTurkey : Electronic Ledger GL Account Description.
IDITSR12_SELECTIntern.Trade Statistic Reporting(Austria):Selection Criteria
RFIDPTPRTKDefine Trans. Key
FIPDCOMC_SGLPDC special G/L indicator
FIGNC_DOCTYP_MAPAssign Document Type to External Document Type
T007NVVDeferred taxes. Tax account assignment to non-deductible cod
TAXOFFICEDistrict Tax Offices
IDITSR_SELECTIntern. Trade Statistic Reporting: Selection Criteria
RFIDPTPPPRPeriodic Pro-Rata coefficient
RFIDPTPRPERDefine Pro-Rata Periods
FITDOMC_FSCVALUEForm Structure: Values (Oman)
J_1BFORCODECurrency codes for DME - Brazil
FIGNC_EXTDOCTYPMaintain External Document Type
T007BEBill of exchange customizing for deferred tax(RFUMSV50)
RFIDPTPRVALDefine Pro-Rata Validation Entity Values
FICA_ITC_RECRATECanada specific customizing table for storing Recapture Rate
IDGS_OBS_REACTReactivated obsolete programs
IDOM_CC_COMPTTexts of Additional Company Code Parametres (Oman)
IDITSR_POSNUMDForeign Trade Declaration: Line Item Description
RFIDPTPRENTCLCDefine Pro-Rata Calculation Entity
VGTAXGRTax Groups Definition
RFASLD15EC Sales List for new EU Countries
IDITSR_DMEEDMEE tree IDs for Foreign Trade Declaration Reporting
TAXOFFICETName of Tax Office
GLACCTS_REP_ITMGL Accounts selected per report run
RFUMSV00_BAL_BEAdvance Tax Return Belgium: Total balances
VGTBTYPETAllowed Tax Box types Text Table
VGTBS_CTTTax Box Structure Type Control Text Table
RFIDPTPCADPro-Rata periodic PPR calculation adjustment documents
J_1BRATEBANKVendor Operation - rates per bank
IDITSR_GROUP_CODtest
IDITSR_DATAOeNB ID number of customers, vendors and GL accounts