1. SAP Tutorial
  2. FI Module

J_3R_FATAX SAP table for – Transport Tax Data

Here we would like to draw your attention to J_3R_FATAX table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_3R_FATAX is a SAP standard transp table used for storing Transport Tax Data related data in SAP. It comes under the package J3RALF.

SAP J_3R_FATAX table

Table J_3R_FATAX technical data

TableJ_3R_FATAX
Data storingTransport Tax Data
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RALF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3R_FATAX Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_3R_FATAX table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key Fields For The Transport Tax Table – J_3R_TTAX
    Its a key field.
  • TAX_TYPE : Tax Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OKATO : OKATO Code
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • STRUCT_DIV : Internal Code of Structural Division
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • ANLN1 : Main Asset Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • VERSION : Version Of The Transport Tax Entry
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • LIGHT : Temporary delivery status during wave creation
    Its data type is CHAR (Character String) with field length 4
  • TAX01 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX02 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX03 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX04 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX05 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX06 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX07 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX08 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX09 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX10 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX11 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TAX12 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • STATUS : Status of The Transport Tax Entry
    Its data type is CHAR (Character String) with field length 1
  • LAST_DECLARED : Indicator If This Entry Is The Last Declared Entry
    Its data type is CHAR (Character String) with field length 1
  • CREATED_ON : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CALC_ID : Identifier name of the Saved Transport Tax Entry
    Its data type is CHAR (Character String) with field length 30
  • DECL_01 : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DECL_NUM1 : Tax Return Document Number
    Its data type is CHAR (Character String) with field length 10
  • DECL_02 : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DECL_NUM2 : Tax Return Document Number
    Its data type is CHAR (Character String) with field length 10
  • DECL_03 : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DECL_NUM3 : Tax Return Document Number
    Its data type is CHAR (Character String) with field length 10
  • DECL_04 : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DECL_NUM4 : Tax Return Document Number
    Its data type is CHAR (Character String) with field length 10
  • NBV01 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV02 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV03 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV04 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV05 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV06 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV07 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV08 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV09 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV10 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV11 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV12 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • NBV13 : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • VALID_MONTH : Number of Valid Months with Respect To The Tax
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ASSETNAME : Asset Description and Additional Description
    Its data type is CHAR (Character String) with field length 100
  • TTAX01_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX02_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX03_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX04_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX05_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX06_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX07_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX08_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX09_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX10_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX11_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX12_ORIG : Monthly Transport Tax Amount For
    Its data type is CURR (Currency Field) with field length 17
  • TTAX_RATE : Transport Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • BRAND : Vehicle Brand
    Its data type is CHAR (Character String) with field length 120
  • TAX_SUM : Annual Tax Amount
    Its data type is CURR (Currency Field) with field length 17
  • PRIVILEGE : Property Tax Reduction
    Its data type is CHAR (Character String) with field length 4
  • AMOUNTRED : Property tax amount reduction code
    Its data type is CHAR (Character String) with field length 4
  • EXEMPTION : Property Tax Exemption Code
    Its data type is CHAR (Character String) with field length 4
  • CNOTX : Transport Tax Exemption Code
    Its data type is CHAR (Character String) with field length 5
  • CPRTX : Transport Tax Reduction Code
    Its data type is CHAR (Character String) with field length 5
  • USAGE_YEARS : Term of Use
    Its data type is CHAR (Character String) with field length 3
  • TAX_COEFF : Tax Coefficient
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3

    • J_3R_FATAX related tables

    • J_3R_LFHDR : Legal form header
    • J_3R_FATAX_DECLH : Declaration Header (Transport, Property Tax)
    • J_3RF_TTAX_NPR : Russian transport new tax priv. values and justifications
    • J_3R_T520S_EXT : Service fee (payment) text key description; text table
    • J_3R_CLFORMT : Description of legal forms
    • J_3R_STRDIV_TD : Table of Structural Division Intervals
    • J_3R_INV26_SET : Table Grouping of General Ledger Accounts
    • J_3R_CLFCT : Customizing table for cluster tables
    • J_3R_CLFORMCMP : Legal forms in company
    • J_3R_CLNRELDAT : Not relevant gathered data of Legal Forms
    • J_3R_CAUTH : Output control for Goods Withholding Authorization
    • J_3R_INVDIFFGRT : Groups of inventory differences: (Text table)
    • J_3R_PTYPE_SECT : Connection Between the Property Types and The Decl. Sections
    • J_3R_INVDIFFGR : Inventory differences groups
    • J_3R_CLNRELPAR : Not relevant parameters and select options for Legal Forms
    • J_3R_INVDIFFMAT : Material group assignment to group of inventory difference
    • J_3R_CLFT10TXT : Customizing Table for TORG-10 Text Types
    • J_3R_CLFORM : Legal forms
    • J_3R_INVDIFF : Offsetting inventory differences of goods
    • J_3R_TAX_SETTING : Settings for Transport & Property Tax (eg. Struct. div.)

    J_3R_FATAX related transaction codes under SAP package J3RALF

    • J3RALFOS1A : OS-1A Acc. and Ret. Record of Bldngs
    • J3RALFINV3 : INV-3 Physical Inventory List
    • J3RALFINV1 : INV-1 Inventory List of Fixed Assets
    • J3RALFINV1A : INV-1A Inventory List of Int. Assets
    • J3RALFTTAXDECL : Transport Tax Return
    • J3RALFGEN : Russian Legal Form Generator
    • J3RALFOS6A : OS-6A Inventory Card for FA Groups
    • J3RALFAO1 : AO-1 Advance Report
    • J3RALFOS1 : OS-1 Accept. and Ret. Record of FA
    • J3RALFOS3 : OS-3 Repairs and Bett. Record of FA
    • J3RALFOS15 : OS-15 Act on recept. & trans. equip.
    • J3RALFTTAXCALC : Transport Tax Calculation
    • J3RALFNRNG : Number range maintenance: J3RFORMS
    • J3RALFOS4B : OS-4B Scrapping Record of FA Groups
    • J3RALFOS1B : OS-1B Acc. and Ret. Rec. of FA Group
    • J3RALFFATAXLIST : Asset Taxes
    • J3RALFOS4 : OS-4 Scrapping Record of Fixed Asset
    • S_E38_98000046 : IMG Activity
    • J3RALFINV26 : Statement of result of ph.inventory
    • J3RLFNPOSTR : Notification of Postal Money Transf.

    Related References

    Related Tutorials

    J_1AWITH SAP table for – Withholding transaction data

    J_1AWITH table in SAP FI (Localization in FI) module. This table is used for storing data of Withholding transaction data....

    ETXDCJ SAP table for – Ext. tax document: tax rates and amounts by Jurisdict. level

    ETXDCJ table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Ext....

    J_3RFSEC_ITEM SAP table for – Data for Secondary events for deferred tax

    J_3RFSEC_ITEM table in SAP FI (Localization in FI) module. This table is used for storing data of Data for Secondary...

    DFKKREP07 SAP table for – Tax Report Data (Clearing Time)

    DFKKREP07 table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    RFUMSV00_HIST SAP table for – Maintain data for previous VAT return run

    RFUMSV00_HIST table in SAP FI (Localization in FI) module. This table is used for storing data of Maintain data for...

    DFKKREP07_T SAP table for – Tax Report Data (Additional Data for Transfer Posting)

    DFKKREP07_T table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    J_3RFTTAXR SAP table for – Transport tax rates

    J_3RFTTAXR table in SAP FI (Localization in FI) module. This table is used for storing data of Transport tax rates....

    «
    »