1. SAP Tutorial
  2. FI Module

J_3RFTAX_EXTRD SAP table for – Tax Extract Detail Lines

Here we would like to draw your attention to J_3RFTAX_EXTRD 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_3RFTAX_EXTRD is a SAP standard transp table used for storing Tax Extract Detail Lines related data in SAP. It comes under the package J3RFTAX.

SAP J_3RFTAX_EXTRD table

Table J_3RFTAX_EXTRD technical data

TableJ_3RFTAX_EXTRD
Data storingTax Extract Detail Lines
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RFTAX
Delivery ClassL – Table for storing temporary data
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RFTAX_EXTRD 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_3RFTAX_EXTRD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • EXTRT : Extract name
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • BUKRS1 : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNR1 : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR1 : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI1 : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Line Item data for Customer/Vendor/G/L Account
  • ACTIV : List Level in which the Line Item is Active
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : New asset subnumber, 4 characters
    Its data type is CHAR (Character String) with field length 4
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • AUGBL : Document Number of the Clearing Document
    Its data type is CHAR (Character String) with field length 10
  • AUGDT : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BWWRT : Amount Valuated in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • BWWR2 : Amount Valuated in Local Currency 2
    Its data type is CURR (Currency Field) with field length 13
  • BWWR3 : Amount Valuated in Local Currency 3
    Its data type is CURR (Currency Field) with field length 13
  • DMSHB : Amount in Local Currency with +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBE2 : Amount in Second Local Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • HWAE2 : Currency Key of Second Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBE3 : Amount in Third Local Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • HWAE3 : Currency Key of Third Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • ETEN2 : Schedule line
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FAEDT : Net Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FILKD : Account Number of the Branch
    Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • JAMON : Fiscal Year/Posting Period from Posting Date
    Its data type is CHAR (Character String) with field length 7
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • KONTO : Account Number
    Its data type is CHAR (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • MABER : Dunning Area
    Its data type is CHAR (Character String) with field length 2
  • MADAT : Date of Last Dunning Notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • MANST : Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MONAT : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MSCHL : Dunning key
    Its data type is CHAR (Character String) with field length 1
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • POSN2 : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • QBSHB : Withholding Tax Amount (in Doc. Currency) with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • QSFBT : Amount Free of Withhld.Tax (in Doc.Curr.) with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • QSSHB : Withholding Tax Base Amount with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • SAMNR : Invoice List Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • SKFBT : Amount Subject to Discount in Document Curr. with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • SKNTO : Cash Discount Amount (+/-) in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • STAKZ : Indicator: Statistical document ?
    Its data type is CHAR (Character String) with field length 1
  • UMSKS : Special G/L Transaction Type
    Its data type is CHAR (Character String) with field length 1
  • UMSKZ : Special G/L Indicator
    Its data type is CHAR (Character String) with field length 1
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBEL2 : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • VBELN : Billing document
    Its data type is CHAR (Character String) with field length 10
  • VBEWA : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • VERTN : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • VERTT : Contract Type
    Its data type is CHAR (Character String) with field length 1
  • VERZ1 : Days in Arrears for Cash Discount Terms 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VERZN : Days in Arrears by Net Due Date
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • WRSHB : Foreign Currency Amount with Signs (+/-)
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WSKTO : Cash discount amount in document currency with +/- sign
    Its data type is CURR (Currency Field) with field length 13
  • WVERW : Bill of Exchange Usage Type
    Its data type is CHAR (Character String) with field length 1
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • XSTRP : Indicator: Disputed item?
    Its data type is CHAR (Character String) with field length 1
  • XZAHL : Indicator: Is Posting Key Used in a Payment Transaction?
    Its data type is CHAR (Character String) with field length 1
  • ZALDT : Probable Payment Date (Cash Discount 1 Due)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZBD1P : Cash discount percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD1T : Cash discount days 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD2P : Cash Discount Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD2T : Cash discount days 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD3T : Net Payment Terms Period
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZINSZ : Interest Calculation Numerator (Days in Arrears * Amount)
    Its data type is CURR (Currency Field) with field length 15
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • ZLSPR : Payment Block Key
    Its data type is CHAR (Character String) with field length 1
  • ZTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • XREF1 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XREF2 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XARCH : Indicator: Document already archived ?
    Its data type is CHAR (Character String) with field length 1
  • RSTGR : Reason Code for Payments
    Its data type is CHAR (Character String) with field length 3
  • ASKTO : Current Cash Disc. Amount in Document Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • KURSE : Effective Exchange Rate in the Line Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • REBZT : Follow-On Document Type
    Its data type is CHAR (Character String) with field length 1
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PSWBT : Amount for Updating in General Ledger
    Its data type is CURR (Currency Field) with field length 13
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • XNEGP : Indicator: Negative posting
    Its data type is CHAR (Character String) with field length 1
  • ZBFIX : Fixed Payment Terms
    Its data type is CHAR (Character String) with field length 1
  • RFZEI : Payment Card Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CCBTC : Payment cards: Settlement run
    Its data type is CHAR (Character String) with field length 10
  • KKBER : Credit control area
    Its data type is CHAR (Character String) with field length 4
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • DTWS1 : Instruction key 1
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS2 : Instruction key 2
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS3 : Instruction key 3
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS4 : Instruction key 4
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ABSBT : Credit Management: Hedged Amount
    Its data type is CURR (Currency Field) with field length 13
  • KKBWR : Currency of Credit Control Area
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PROJK : Individual Structural Element (WBS Element) in Ext. Format
    Its data type is CHAR (Character String) with field length 24
  • XPYPR : Indicator: Items from Payment Program Blocked
    Its data type is CHAR (Character String) with field length 1
  • KIDNO : Payment Reference
    Its data type is CHAR (Character String) with field length 30
  • XAUGP : Indicator: Item has been cleared?
    Its data type is CHAR (Character String) with field length 1
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • GKART : Offsetting Account Type
    Its data type is CHAR (Character String) with field length 1
  • GKONT : Offsetting Account Number
    Its data type is CHAR (Character String) with field length 10
  • PYCUR : Currency for Automatic Payment
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PYAMT : Amount in Payment Currency
    Its data type is CURR (Currency Field) with field length 13
  • PYORD : Payment Order
    Its data type is CHAR (Character String) with field length 10
  • XTEXT : Indicator: Texts exist ?
    Its data type is CHAR (Character String) with field length 1
  • TDID : Text ID
    Its data type is CHAR (Character String) with field length 4
  • XDUEN : Indicator: Item is due net?
    Its data type is CHAR (Character String) with field length 1
  • XDUE1 : Indicator: Cash discount term 1 is due on item?
    Its data type is CHAR (Character String) with field length 1
  • XRAGL : Indicator: Clearing was Reversed
    Its data type is CHAR (Character String) with field length 1
  • XSELP : Item selected (selected, chosen, …)
    Its data type is CHAR (Character String) with field length 1
  • CESSION_KZ : Accounts Receivable Pledging Indicator
    Its data type is CHAR (Character String) with field length 2
  • BUZID : Identification of the Line Item
    Its data type is CHAR (Character String) with field length 1
  • AUGGJ : Fiscal Year of Clearing Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • AGZEI : Clearing Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • EGRUP : Equity group
    Its data type is CHAR (Character String) with field length 3
  • BTYPE : Payroll Type
    Its data type is CHAR (Character String) with field length 2
  • VORGN : Transaction Type for General Ledger
    Its data type is CHAR (Character String) with field length 4

    • J_3RFTAX_EXTRD related tables

    • J_3RFREP_PRESETS : Predefined Attributes for the Reporting Hierarchy Elements
    • J_3RFREP_ADP_RET : Parameters Definition of XML Data Provider
    • J_3RFREP_SPLIT : Splitting rules for multiple XML files generation
    • J_3RCESSION_CUST : Document Types Selections For Cession Report
    • J_3RFREP_ATTRT : Description of Reporting Hierarchy Object Attribues
    • J_3R_PBU_TCODES : Transformation codes for data transfer to FI-SL for PBU18
    • J_3RTAX_SELTRSRC : Selective transfer source field
    • J_3RFTAXRVA : Tax Accounting: Actual line item table
    • J_3RFTAXRVO : Tax Accounting: Object table
    • J_3RFREP_VALFMT : Predefined Attributes for the Reporting Hierarchy Elements
    • J_3RFTAX_FRMTT : Text table for Electronic Format Version Entries
    • J_3RFTAX_ACTVTXT : FI-SL Activity group texts
    • J_3RFTAX_ASSIGID : Hierarchy assignment ID
    • J_3RFTAX_OBJECTT : Tax objects list texts
    • J_3R_T030K : Tax Accounts Determination
    • J_3RFREP_DP_PAR : Type of XML Data Provider Parameter for Reporting Object
    • J_3RFTAX_ASSIGNE : Tax hierarchy assignment to company code/ledger
    • J_3RFTAX_OBJSEL : Tax object selections
    • J_3R_PBU_SETCLS : Set Classes Assignment to Source Tables Fields
    • J_3RFREP_TECHDAT : Reporting Hierarchy Technical Settings

    J_3RFTAX_EXTRD related transaction codes under SAP package J3RFTAX

    • J3RTAXID : Tax hierarchy assignment ID
    • J3RTAXIN : Table group install.for tax account.
    • J3RTAXJR : Tax journal
    • J3RTAXLA : List accounts used in hierarchy
    • J3RTAXDD : Provision for Doubtful Receivables
    • J3RPBU18DT : Transfer Tax Differences to FI-SL
    • J3RTAXRL : Hierarchy rollup creation
    • J3RTAXDP : Electronic Tax Format Maintenance
    • J3RTAXHR : Tax Hierarchy Maintanance
    • J3RTAXDR : Tax declaration rows
    • J3RTAXUC : Maintain unclassified objects
    • J3RXMLEXP : XML Hierarchy output
    • J3RTAXTB : Maintain table links
    • J3RTAXREP : Reporting hierarchy
    • J3RTAXCD : Tax chain definition
    • J3RTAXDPED : GUI DP editor tool
    • J3RPBU18SC : Set Classes Assignment
    • J3RTAXUL : Unclassified transactions listing
    • J3RTAXCE : Execute tax chain
    • J3RTAXTR : Tax hierarchy transport

    Related References

    Related Tutorials

    PTRV_DOC_TAX SAP table for – Transfer Travel -> FI/CO: Tax lines of TRV document

    PTRV_DOC_TAX table in SAP FI (Travel Management in FI) module. This table is used for storing data of Transfer Travel...

    RFITEMAP_NO_ITEM SAP table for – Item wise detail for the Vendor Transactions

    RFITEMAP_NO_ITEM table in SAP FI (Localization in FI) module. This table is used for storing data of Item wise detail...

    RFITEMAR_NO_ITEM SAP table for – Item wise detail for the Customer Transactions

    RFITEMAR_NO_ITEM table in SAP FI (Localization in FI) module. This table is used for storing data of Item wise detail...

    RFITEMGL_NO_ITEM SAP table for – Item wise detail for the GL Account Transactions

    RFITEMGL_NO_ITEM table in SAP FI (Localization in FI) module. This table is used for storing data of Item wise detail...

    DFKKREV07 SAP table for – Report on Tax on Sales/Purchases (clearing time)

    DFKKREV07 table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing 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_1ISERVC SAP table for – Service tax details

    J_1ISERVC table in SAP FI (Localization in FI) module. This table is used for storing data of Service tax details....

    «
    »