1. SAP Tutorial
  2. FI Module

J_3RFTAXRVT SAP table for – Tax Accounting: Summary table

Here we would like to draw your attention to J_3RFTAXRVT 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_3RFTAXRVT is a SAP standard transp table used for storing Tax Accounting: Summary table related data in SAP. It comes under the package J3RFTAX.

SAP J_3RFTAXRVT table

Table J_3RFTAXRVT technical data

TableJ_3RFTAXRVT
Data storingTax Accounting: Summary table
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RFTAX
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RFTAXRVT 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_3RFTAXRVT table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RLDNR : Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ROBJNR : Object number for objects (account assignment elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • SOBJNR : Object number for partner objects (accnt assignmnt elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RTCUR : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • RUNIT : Base Unit of Measure
    Its a key field. Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DRCRK : Debit/Credit Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RTAXOBJ : Tax Object
    Its data type is CHAR (Character String) with field length 21
  • RACTIVTYP : Activity Type
    Its data type is CHAR (Character String) with field length 10
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • RMATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • RANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • RANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • RTAXROW : Tax Return Row Number
    Its data type is CHAR (Character String) with field length 17
  • RCONTRACT : Contract Number
    Its data type is CHAR (Character String) with field length 18
  • RKTRLAGT : Customer number
    Its data type is CHAR (Character String) with field length 10
  • RPRODUCT : Product type
    Its data type is CHAR (Character String) with field length 18
  • RKORRPER : Correction period
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • RKOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • RAUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • RDIVISION : Division Number
    Its data type is CHAR (Character String) with field length 5
  • SBUKRS : Company code of partner
    Its data type is CHAR (Character String) with field length 4
  • STAXOBJ : Sending Tax Object
    Its data type is CHAR (Character String) with field length 21
  • SACTIVTYP : Sending Activity Type
    Its data type is CHAR (Character String) with field length 10
  • SACCT : Account number
    Its data type is CHAR (Character String) with field length 10
  • SMATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • SPRODUCT : Sender product type
    Its data type is CHAR (Character String) with field length 18
  • SKORRPER : Sending correction period
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • SKOSTL : Sender Cost Center
    Its data type is CHAR (Character String) with field length 10
  • SAUFNR : Sender order
    Its data type is CHAR (Character String) with field length 12
  • SDIVISION : Sending Division Number
    Its data type is CHAR (Character String) with field length 5
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • MSLVT : Balance carried forward of quantity
    Its data type is QUAN (Quantity field) with field length 15
  • MSL01 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL02 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL03 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL04 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL05 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL06 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL07 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL08 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL09 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL10 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL11 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL12 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL13 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL14 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL15 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL16 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • CSPRED : Distribution key for currency amounts
    Its data type is CHAR (Character String) with field length 4
  • QSPRED : Distribution key for quantities
    Its data type is CHAR (Character String) with field length 4

    • J_3RFTAXRVT related tables

    • J_3RFREP_TECHDAT : Reporting Hierarchy Technical Settings
    • J_3RFTAX_ASSIGN : Tax hierarchy assignment to company code
    • J_3RFTAX_CHAIND : Tax chain details
    • J_3RFTAXRVA : Tax Accounting: Actual line item table
    • J_3RFREP_ADP_MAP : XML Data Provider Parameters Definition
    • J_3RFTAX_LINKD : Tax Accounting: Table link details
    • J_3R_T056P : Reference interest table
    • J_3RFREP_SPLGRP : Matching table of attributes to splitting groups
    • J_3RFTAX_CHAIN : Tax chains
    • J_3RFTAX_MPRL : Electronic Tax Report Mapping Rules
    • J_3RFREP_DICTT : Description of Dictionary Value for Reporting Obj. Attribute
    • J_3RFTAX_FRMTST : Text table for Electronic Tax Format Versions
    • J_3RFREP_DP_PAR : Type of XML Data Provider Parameter for Reporting Object
    • J_3R_PBU_HIER : Hierarchies which have settings for PBU18
    • J_3RFREP_SS_GRPT : Selection screen groups localization table
    • J_3RFREP_ADP : XML Report Data Provider
    • J_3RTAX_SELTRVAL : Selective transfer values
    • J_3RFREP_OBJSEL : Tax reporting object selections
    • J_3RFREP_VALFMT : Predefined Attributes for the Reporting Hierarchy Elements
    • J_3RFTAXRVO : Tax Accounting: Object table

    J_3RFTAXRVT related transaction codes under SAP package J3RFTAX

    • J3RTAXCS : Create FI-SL settings
    • J3RTAXTB : Maintain table links
    • J3RTAXDD : Provision for Doubtful Receivables
    • J3RTAXGR : Maintain FI-SL activity groups
    • J3RTAXCD : Tax chain definition
    • J3RTAXDPED : GUI DP editor tool
    • J3RTAXIN : Table group install.for tax account.
    • J3RTAXAE : Assign Tax Hierarchy to CC/ledger
    • J3RTAXDP : Electronic Tax Format Maintenance
    • J3RXMLEXP : XML Hierarchy output
    • J3RPBU18RA : Rates and accounts for PBU18 setting
    • J3RTAXDR : Tax declaration rows
    • J3RTAXJR : Tax journal
    • J3RTAXCE : Execute tax chain
    • J3RTAXHR : Tax Hierarchy Maintanance
    • J3RTAXRL : Hierarchy rollup creation
    • J3RTAXID : Tax hierarchy assignment ID
    • J3RTAXTR : Tax hierarchy transport
    • J3RPBU18DT : Transfer Tax Differences to FI-SL
    • J3RTAXLA : List accounts used in hierarchy

    Related References

    Related Tutorials

    J_3RFTAXRT SAP table for – Tax Accounting: Summary table

    J_3RFTAXRT table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Summary...

    /CCIS/PBU18T SAP table for – PBU18: Summary table x

    /CCIS/PBU18T table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of PBU18:...

    J_3RFTAXRVP SAP table for – Tax Accounting: Plan line item table

    J_3RFTAXRVP table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Plan...

    J_3RFTAXRP SAP table for – Tax Accounting: Plan line item table

    J_3RFTAXRP table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Plan...

    GLT3 SAP table for – Summary Data Preparations for Consolidation

    GLT3 table in SAP FI (Consolidation in FI) module. This table is used for storing data of Summary Data Preparations...

    J_3RKKR0 SAP table for – Account correspondence – summary table

    J_3RKKR0 table in SAP FI (Localization in FI) module. This table is used for storing data of Account correspondence -...

    GLT2 SAP table for – Consolidation totals table

    GLT2 table in SAP FI (Consolidation in FI) module. This table is used for storing data of Consolidation totals table....

    «
    »