SAP Localization Tables
Are you looking for the right table related to SAP Localization 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 (FI-LOC) module.
Top 10 tables in Localization
| Table | Description |
|---|---|
| TIVXCFRBDGPRD | Annual Budget Periods |
| IDAR_TXCINCT | Texts of Internal Codes in country specific Taxation |
| ACRSI_REP_CT_GRP | Grouping of Report Category |
| J_1AINFT02 | Text for table J_1INFT01 |
| J_1AIFSKVZ | Inflation Revaluation G/L Account - Transaction Figures |
| ACRSC_EXTR_PVAL | Table for Extracting Parameter Values |
| J_1AINFPCL | FI Inflation adjustment: Process control |
| ACRSC_EXTR_TASKP | Table for Extracting Parameter Values |
| J_1AINFT09 | Date lock table for inflation indexes |
| ACRSC_REPCAT_EXT | Table for Report Category Extraction Per Destination |
List of tables in Localization
| Table | Description |
|---|---|
| TIVXCFRBDGPRD | Annual Budget Periods |
| IDAR_TXCINCT | Texts of Internal Codes in country specific Taxation |
| ACRSI_REP_CT_GRP | Grouping of Report Category |
| J_1AINFT02 | Text for table J_1INFT01 |
| J_1AIFSKVZ | Inflation Revaluation G/L Account - Transaction Figures |
| ACRSC_EXTR_PVAL | Table for Extracting Parameter Values |
| J_1AINFPCL | FI Inflation adjustment: Process control |
| ACRSC_EXTR_TASKP | Table for Extracting Parameter Values |
| J_1AINFT09 | Date lock table for inflation indexes |
| ACRSC_REPCAT_EXT | Table for Report Category Extraction Per Destination |
| TIVXCPTSTCNTYPE | Stamp Tax Type - Contract Type Mapping |
| VIXCPTSIPT | Digital Signature for Invoices |
| J_1AINFT21 | Text for Table J_1INFT01 |
| J_1AINFT04 | Time base definition |
| VIXCPTIMIDATA | IMI Master Data |
| IDAR_TXCKEY | Tax Condition Keys for country specific Taxation |
| VIXCFRAPLOG | Log of Calculation of Complementary Budget Amounts |
| TIVXCJPCDSET | Kanji and Katakana Name Locations for Lease-Out Offices |
| TIVXCNLSUBSICOND | Define Condition Types for Subsidized Rent |
| TIVXCINGSTREGTAX | Mapping of Region to Tax Group |
| J_1AINFT08 | Composed index |
| TIVXCESPTTAXRATE | Municipal Property Tax Rate |
| TIVXCFRSBA | Obsolete - To be deleted!!! |
| TIVXCNLBPIDTYPE | BP: ID Number type for Subsidized Rent |
| J_1AINFSKT | Text Table: Inflation Keys - G/L Account |
| J_1AINFT14 | Valid posting dates |
| TIVXCPTSTRATE | Stamp Tax Rate |
| VIXCESM180DEC | Modelo 180 - Witholding Tax Declarer Line 01 |
| TIVXCESPTSURCHRT | Municipal Property Tax - Surcharges |
| VIXCFRSRULOG | Log of SRU Postings |
| TIVXCNLSUBSICATT | Category texts for Subsidizable Rent |
| TIVXCPTINSTALLM | Installment dates |
| VIXCCORROC | One Time condition header, item text |
| J_1AINFT25 | Composite Indexes |
| J_1AINFT23 | Inflation: Index Versions (Reference Table) |
| TIVXCCHSTAT | Localization Switzerland: GWR Building Status |
| TIVXCPTEXPERIOD | Exemption periods |
| TIVXCESPTSURCHRG | Municipal Property Tax - Surcharges |
| TIVXCESPTTAXCATT | Municipal Property Tax Category Description |
| TIVXCPTINSTLIMIT | Installment limit for the Municipal Property Tax |
| TIVXCESCADREFS | Modelo 347: Steps to find Cadaster Reference |
| TIVXCPTEXPERT | Exemption periods (obsolete) |
| J_1AINFT13 | Name table for table j_1ainft12 |
| TIVXCPTTGROUPMAP | Map Tax Group |
| VIXCFREO | Statuses of Extraordinary Operation |
| ACRS_ODP_EXT_NEW | Obsolete: ACRS ODP Table for Data Extraction Failed Runs |
| GLO_ACRS_SNAME | ACRS Source System Name |
| ACRS_ODP_EXTRACT | [OBSOLETE] - ACRS ODP Table for Data Extraction |
| VIXCJPSCCOSTSEXT | Costs per Object - Legacy Data Transfer |
| TIVXCPTPROPTYP | Property type (obsolote) |
| TIVXCPTSTTYT | Stamp Tax Type Description |
| J_1ASKCLS | Account class |
| ACRSI_RP_GRP_EXT | Grouping of Extractors |
| J_1AMINFCT | Material inflation class texts |
| VIXCCORRVIIR | Invoice Item Reference for Corr/Rev Invoices |
| TIVXCCHUSAGE | Localization Switzerland: GWR Usage Type |
| J_1AINFW_FILES | Foreign Currency Inflation Adjustment: File Management |
| TIVXCPTPOSTPAR | Technical Parameters for Postings and Payments (obsolate) |
| J_1AINFT22 | Index Versions |
| VIXCCHCATEGID | Localization Switzerland: RE Property Cataster EGID |
| TIVXCPTPTTAXCATT | Municipal Property Tax Category Description |
| J_1AINFMET | Inflation Methods |
| VIXCESIBIDATA | IBI master data |
| TIVXCPTRACONST | This table shall contain the language dependent texts for t |
| ACRS_ODP_SELECT | [OBSOLETE] - ACRS Selection table for ODP extraction |
| J_1AINFMBW | Material Master - Inflation |
| TIVXCESPTTAXCAT | Municipal Property Tax Category |
| J_1AINFMTY | Inflation: Relevant Movement Types |
| TIVXCESPARAM | Parameters for Security Deposit |
| GLO_BDT_COUNTRY | Country Specific BP Enhancement: Deactivate BDT Applications |
| TIVXCJPCCSET | Company-Specific Data Customizing |
| TIVXCESFULDAT | Define Derivation Rule of Tax Fulfillment Date for Spain |
| VIXCCHEGID | Localization Switzerland: EGID |
| TIVXCNLHPCITY | Highly populated cities |
| TIVXCJPPCRCAT | Payment Categories |
| ACRSI_EXTRACTOR | Table for Extractor Details |
| TIVXCJPTAXOFFICE | Tax Office Data for Lease-Out Offices |
| J_1AINFT05 | Name table for table J_1AINFT04 |
| TIVXCPTCERT | Invoice certification |
| IDAR_TXCINC | Internal Codes in country specific Taxation |
| VIXCCHOBJREL | Localization Switzerland: Object Relation Property / Land Re |
| TIVXCESCDMSR | Define the measurements that affect the rent |
| J_1AINFT12 | Posting variant definition |
| TIVXCPTRAPARAM | customizing parameters for the Rent adjustment |
| J_1AINFT03 | Inflation: definitive index ( values ) |
| TIVXCCHFLOORT | Localization Switzerland: GWR Building Floor Text |
| VIXCJPFXDUNPRICE | Fixed Unit Prices for Service Charge Settlement |
| TIVXCPTPOSTPARN | Technical Parameters for Cash Flow Creation |
| J_1AINFT01 | Inflation: Index Definition |
| J_1AINFT06 | Time base and exposure to inflation values |
| J_1AINFT20 | Inflation: Index Definition |
| IDAR_TXCFRM | Tax Conditions and Formulas, country specific |
| TIVXCNLWOZMIN | Minimum WOZ value |
| TIVXCCHGENSRCT | Localization Switzerland: GWR Energy Source Text |
| TIVXCCHUSAGET | Localization Switzerland: GWR Usage Type Text |
| TIVXCPTEXPCATT | Exemption period category description |
| J_1AINFT15 | Inflation: index version ( reference table ) |
| TIVXCCHHEATT | Localization Switzerland: GWR Building Heating Type Text |
| TIVXCFRCONDTYP | Condition types relevant for EO specific AP calculation |
| TIVXCJPFLWTYP | Flow Type Defined for Service Charge Keys |
| VIXCBPLTMOA | Org. Assignment Enhancement with Business Place |
| TIVXCESEVALID | External Validations |
| J_1ASKCLST | Account class text table |
| TIVXCPTEXPCAT | Exemption period category |
| VIXCHUOC | One Time condition header, item text |
| TIVXCCORRCNTRY | Country assignment for Correction/Reversal invoices |
| TIVXCCHGENSRC | Localization Switzerland: GWR Energy Source |
| TIVXCJPPCRCATT | Text table for Payment Categories |
| IDAR_TXCKEYT | Texts of Tax Condition Keys for country specific Taxation |
| TIVXCCHACTIVE | Localization Switzerland: GWR Land Register Active |
| TIVXCESREGION | Province |
| TIVXCFREOACC | Accounts for Extraordinary Operations |
| TIVXCCHCONDT | Localization Switzerland: GWR Building Condition Text |
| TIVXCHUFF | Service continuity |
| TIVXCPTSTTY | Stamp Tax Type |
| TIVXCJPPRGROUP | Grouping of result in Payment Charges Report |
| J_1AINFMTX | Inflation Methods: Description |
| TIVXCCORRALLCNTR | All Allowed Countries for Correction/Reversal invoices |
| TIVXCEDOBPROLE | Determine BP role for e-invoice customer |
| TIVXCCHKATT | Localization Switzerland: GWR Building Category Text |
| VIXCPTCASHF | IMI Cash flow data for the incoming payments |
| J_1AINFINV | Inflation: Invoices for Replacement Value Determination |
| J_1A030IF | Account Determination for Inflation Revaluation Postings |
| TIVXCESCORRINV | Correction Invocie Settings for Spain |
| ACRSI_EXTR_PARAM | Table for Extraction Parameters |
| J_1AOIFWVL | Open item foreign currency valuation: temp. storage |
| J_1AMINFCL | Material Inflation Class |
| IDAR_TXDITM | Document item used in country specific taxation |
| TIVXCPTRACONS | customizing parameters for the conservation factor. |
| TIVXCPTTAXRATE | Municipal Property Tax Rate for Portugal (obsolete) |
| TIVXCPTPTTAXCAT | Municipal Property Tax Category |
| TIVXCNLWOZMT | Assign MeasType and Characteristics to Company Code |
| TIVXCNLWOZBAS | Define basic settings for extra point calculation |
| VIXCCHCATASTER | Localization Switzerland: RE Property Cataster |
| TIVXCHUTP | Account assignment for transfer posting |
| J_1AINFT26 | Date Lock Table for Inflation Indexes |
| TIVXCNLCHARARD | Fixtures and Fittings Characteristic NL |
| TIVXCCHKITT | Localization Switzerland: GWR Rental Object Kitchen Text |
| ACRSI_REPCAT_EXT | Table for Report Category Extraction |
| J_1AINFT16 | Warehouse report ( data of previous fiscal years ) |
| VIXCFRPROCID | Localized Process |
| VIXCFRBUDGET | Budget Seasonality Data |
| VIXCAJTHREADS | Adjustment: processing threads |
| TIVXCESPTDISCHRT | Municipal Property Tax - Discharges |
| TIVXCESPTDISCHRG | Municipal Property Tax - Discharges |
| VIXCESPROPREG | Property Registry |
| TIVXCPTPTTAXRATE | Municipal Property Tax Rate |
| J_1AINFSKS | Inflation Keys - G/L Account |
| TIVXCPTPROPTYPT | Property tax category description (obsolete) |
| VIXCESM180REC | Modelo 180 - Witholding Tax Recipients DMEE Line 02 |
| J_1AINFT24 | Index Values |
| VIXCESCDLOG | Log of Secure Deposit Files |
| TIVXCCHSTATT | Localization Switzerland: GWR Building Status Text |
| TIVXCESBUPA | Bussiness Partner to Company |
| TIVXCCHHEAT | Localization Switzerland: GWR Building Heating Type |
| TIVXCPTPTTAXLIM | Municipal Property Tax Limit |
| TIVXCESAUTCOM | Autonomous community |
| TIVXCINGSTCONSAC | Mapping of Condition Type to SAC code |
| TIVXCFREOACCT | Accounts for Extraordinary Operations |
| VIXCPTRACONTRACT | The table will store the years for the rent adjustment at t |
| TIVXCESACCOMP | Companies with agreement of Autonomous community |
| TIVXCESPTPSTNG | Property Tax: Posting |
| VIXCNLCHARACT | Fixtures/Fittings NL |
| TIVXCPTEXPER | Exemption periods (obsolete) |
| TIVXCBPLDOCTYP | Document Type Determination Based on Company Code |
| TIVXCFRTRSTEPS | Extraordinary Operation specific posting steps |
| TIVXCESPOSTING | Posting Deposits |
| TIVXCCHFLOOR | Localization Switzerland: GWR Building Floor |
| REXC_IN_ERR_CONF | REFX - India Localization: Error configuration |
| TIVXCFRTIME | Time Units |
| TIVXCJPMEASTYPE | Measurement Types for Lease-Out Offices in Mega Cities |
| TIVXCCHKAT | Localization Switzerland: GWR Building Category |
| TIVXCFRTIMET | Description for Time Units |
| TIVXCCHKIT | Localization Switzerland: GWR Rental Object Kitchen Infrastr |
| TIVXCNLSUBSICAT | Define Categories for Subsidized Rent |
| TIVXCNLWOZPTS | Extra points per Rental object value/M2 |
| TIVXCNLRLRACHCT | Rounding per Characteristic Category - NL |
| TIVXCCHCOND | Localization Switzerland: GWR Building Condition |
| TIVXCNLSMAPYEARS | Assign Renovation Years to Small Apartments |
| TIVXCJPPCATF | Payment Categories and Flow Types Customizing |
| TIVXCNLWOZSMAC | WOZ for Small Appartments - Cities |
| TIVXCJPLICT | Lease-In Contract Types |
| TIVXCFRPOSTINGS | Document types of postings on SUs (Extraordinary expenses) |
| TIVXCPTSAFTPAR | SAFT report customizing parameters |