J_3RFTAX_EXTRD SAP (Tax Extract Detail Lines) Table details
Dictionary Type: Table
Description: Tax Extract Detail Lines
Description: Tax Extract Detail Lines
ABAP Code to SELECT data from J_3RFTAX_EXTRD
Related tables to J_3RFTAX_EXTRD
Access table J_3RFTAX_EXTRD
Related tables to J_3RFTAX_EXTRD
Access table J_3RFTAX_EXTRD
Table field list including key, data, relationships and ABAP select examples
J_3RFTAX_EXTRD is a standard SAP Table which is used to store Tax Extract Detail Lines data and is available within R/3 SAP systems depending on the version and release level.
The J_3RFTAX_EXTRD table consists of various fields, each holding specific information or linking keys about Tax Extract Detail Lines data available in SAP. These include EXTRT (Extract name), BUKRS1 (Company Code), BELNR1 (Accounting Document Number), GJAHR1 (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP J_3RFTAX_EXTRD table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EXTRT | Extract name | J_3RF_TAX_EXTRACT | CHAR | 12 | J_3RFTAX_EXTRH | J_3RF_TAX_EXTRACT | J_3RFTAX_EXTRH | ||
BUKRS1 | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BELNR1 | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR1 | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUZEI1 | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
ACTIV | List Level in which the Line Item is Active | ACTIV | NUMC | 2 | NUM02 | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | New asset subnumber, 4 characters | ANLN2_4 | CHAR | 4 | ALPHA | ANLN2_4 | AN2 | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BWWRT | Amount Valuated in Local Currency | BWWRT | CURR | 13(2) | WRTV7 | ||||
BWWR2 | Amount Valuated in Local Currency 2 | BWWR2 | CURR | 13(2) | WRTV7 | ||||
BWWR3 | Amount Valuated in Local Currency 3 | BWWR3 | CURR | 13(2) | WRTV7 | ||||
DMSHB | Amount in Local Currency with +/- Signs | DMSHB | CURR | 13(2) | WRTV7 | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
DMBE2 | Amount in Second Local Currency with +/- Sign | DMBE2_VZ | CURR | 13(2) | WRTV7 | ||||
HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | Assigned to domain | WAERS | |||
DMBE3 | Amount in Third Local Currency with +/- Sign | DMBE3_VZ | CURR | 13(2) | WRTV7 | ||||
HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | Assigned to domain | WAERS | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | Assigned to domain | ETENR | |||
FAEDT | Net Due Date | FAEDT_FPOS | DATS | 8 | DATUM | ||||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
JAMON | Fiscal Year/Posting Period from Posting Date | JAMON_XPO | CHAR | 7 | JAMON_XPO | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
KONTO | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
QBSHB | Withholding Tax Amount (in Doc. Currency) with +/- Sign | QBSHB_VZ | CURR | 13(2) | WRTV7 | ||||
QSFBT | Amount Free of Withhld.Tax (in Doc.Curr.) with +/- Sign | QSFBT_VZ | CURR | 13(2) | WRTV7 | ||||
QSSHB | Withholding Tax Base Amount with +/- Sign | QSSHB_VZ | CURR | 13(2) | WRTV7 | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
SKFBT | Amount Subject to Discount in Document Curr. with +/- Sign | SKFBT_VZ | CURR | 13(2) | WRTV7 | ||||
SKNTO | Cash Discount Amount (+/-) in Local Currency | SKNTO_VZ | CURR | 13(2) | WRTV7 | ||||
STAKZ | Indicator: Statistical document ? | XSTKZ | CHAR | 1 | XFELD | ||||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERZ1 | Days in Arrears for Cash Discount Terms 1 | VERZ1 | DEC | 5 | WRTV3 | ||||
VERZN | Days in Arrears by Net Due Date | VERZN | DEC | 5 | WRTV3 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
WRSHB | Foreign Currency Amount with Signs (+/-) | WRSHB | CURR | 13(2) | WRTV7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
WSKTO | Cash discount amount in document currency with +/- sign | WSKTO_VZ | CURR | 13(2) | WRTV7 | ||||
WVERW | Bill of exchange usage type | WVERW | CHAR | 1 | WVERW | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
XSTRP | Indicator: Disputed item? | XSTRP | CHAR | 1 | XFELD | ||||
XZAHL | Indicator: Is the posting key used in a payment transaction? | XZAHL | CHAR | 1 | XFELD | ||||
ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATS | 8 | DATUM | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZINSZ | Interest Calculation Numerator (Days in Arrears * Amount) | DZINSZ | CURR | 15(2) | WRTV8 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XARCH | Indicator: Document already archived ? | XARCH | CHAR | 1 | XFELD | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | Assigned to domain | RSTGR | |||
ASKTO | Current Cash Disc. Amount in Document Currency with +/- Sign | ASKTO_VZ | CURR | 13(2) | WRTV7 | ||||
KURSE | Effective Exchange Rate in the Line Item | KURSE | DEC | 9(5) | EXCRT | KURSF | |||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | TCURC | WAERS | |||
PSWBT | Amount for Updating in General Ledger | PSWBT | CURR | 13(2) | WERT7 | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
RFZEI | Payment Card Item | RFZEI_CC | NUMC | 3 | NUM03 | ||||
CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 10 | ALPHA | CCBTC | |||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX | |||
ABSBT | Credit management: Hedged amount | ABSBT | CURR | 13(2) | WERT7 | ||||
KKBWR | Currency of Credit Control Area | KKBWR | CUKY | 5 | Assigned to domain | WAERS | |||
PROJK | Individual Structural Element (WBS Element) in Ext. Format | PROJK_EXT | CHAR | 24 | CHAR24 | ||||
XPYPR | Indicator: Items from Payment Program Blocked | XPYPR | CHAR | 1 | XFELD | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
XAUGP | Indicator: Item has been cleared? | XAUGP | CHAR | 1 | XFELD | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
GKART | Offsetting Account Type | GKART | CHAR | 1 | GKART | ||||
GKONT | Offsetting Account Number | GKONT | CHAR | 10 | ALPHA | GKONT | GKONT | ||
PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | Assigned to domain | WAERS | |||
PYAMT | Amount in Payment Currency | PYAMT | CURR | 13(2) | WERT7 | ||||
PYORD | Payment Order | PYORD | CHAR | 10 | ALPHA | PYORD | |||
XTEXT | Indicator: Texts exist ? | XTEXT_F02L | CHAR | 1 | XFELD | ||||
TDID | Text ID | TDID | CHAR | 4 | Assigned to domain | TDID | |||
XDUEN | Indicator: Item is due net? | XDUEN | CHAR | 1 | XFELD | ||||
XDUE1 | Indicator: Cash discount term 1 is due on item? | XDUE1 | CHAR | 1 | XFELD | ||||
XRAGL | Indicator: Clearing was Reversed | XRAGL | CHAR | 1 | XFELD | ||||
XSELP | Item selected (selected, chosen, ...) | XSELP | CHAR | 1 | XFELD | ||||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | Assigned to domain | CESSION_KZ | |||
BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
AUGGJ | Fiscal Year of Clearing Document | AUGGJ | NUMC | 4 | GJAHR | GJAHR | |||
AGZEI | Clearing Item | AGZEI | DEC | 5 | AGZEI | ||||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | T8JF | ALPHA | JV_EGROUP | GJE | |
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | T8JA | ALPHA | JV_BILIND | ||
VORGN | Transaction Type for General Ledger | VORGN | CHAR | 4 | VORGN |
Key field | Non-key field |
How do I retrieve data from SAP table J_3RFTAX_EXTRD using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_3RFTAX_EXTRD to SELECT all data from the tableDATA: WA_J_3RFTAX_EXTRD TYPE J_3RFTAX_EXTRD.
SELECT SINGLE *
FROM J_3RFTAX_EXTRD
INTO CORRESPONDING FIELDS OF WA_J_3RFTAX_EXTRD
WHERE...
How to access SAP table J_3RFTAX_EXTRD
Within an ECC or HANA version of SAP you can also view further information about J_3RFTAX_EXTRD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects