J_3RFTAX_EXTRD is a SAP table coming under FI module and SAP_FIN component.View details, Fields & related tables of J_3RFTAX_EXTRD in SAP.
- Table description : Tax Extract Detail Lines
- Module : FI-LOC
- Parent Module : FI
- Package : J3RFTAX
- Software Component : SAP_FIN
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP J_3RFTAX_EXTRD Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| EXTRT | Extract name | J_3RF_TAX_EXTRACT | J_3RF_TAX_EXTRACT |
| BUKRS1 | Company Code | BUKRS | BUKRS |
| BELNR1 | Accounting Document Number | BELNR_D | BELNR |
| GJAHR1 | Fiscal Year | GJAHR | GJAHR |
| BUZEI1 | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
| .INCLUDE | Line Item data for Customer/Vendor/G/L Account | ||
| ACTIV | List Level in which the Line Item is Active | ACTIV | NUM02 |
| ANLN1 | Main Asset Number | ANLN1 | ANLN1 |
| ANLN2 | New asset subnumber, 4 characters | ANLN2_4 | ANLN2_4 |
| AUFNR | Order Number | AUFNR | AUFNR |
| AUGBL | Document Number of the Clearing Document | AUGBL | BELNR |
| AUGDT | Clearing Date | AUGDT | DATUM |
| BELNR | Accounting Document Number | BELNR_D | BELNR |
| BLART | Document type | BLART | BLART |
| BLDAT | Document Date in Document | BLDAT | DATUM |
| BSCHL | Posting Key | BSCHL | BSCHL |
| BSTAT | Document Status | BSTAT_D | BSTAT |
| BUDAT | Posting Date in the Document | BUDAT | DATUM |
| BUKRS | Company Code | BUKRS | BUKRS |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
| BWWRT | Amount Valuated in Local Currency | BWWRT | WRTV7 |
| BWWR2 | Amount Valuated in Local Currency 2 | BWWR2 | WRTV7 |
| BWWR3 | Amount Valuated in Local Currency 3 | BWWR3 | WRTV7 |
| DMSHB | Amount in Local Currency with +/- Signs | DMSHB | WRTV7 |
| HWAER | Local Currency | HWAER | WAERS |
| DMBE2 | Amount in Second Local Currency with +/- Sign | DMBE2_VZ | WRTV7 |
| HWAE2 | Currency Key of Second Local Currency | HWAE2 | WAERS |
| DMBE3 | Amount in Third Local Currency with +/- Sign | DMBE3_VZ | WRTV7 |
| HWAE3 | Currency Key of Third Local Currency | HWAE3 | WAERS |
| EBELN | Purchasing Document Number | EBELN | EBELN |
| EBELP | Item Number of Purchasing Document | EBELP | EBELP |
| ETEN2 | Schedule line | ETENR | ETENR |
| FAEDT | Net Due Date | FAEDT_FPOS | DATUM |
| FILKD | Account Number of the Branch | FILKD | MAXKK |
| GJAHR | Fiscal Year | GJAHR | GJAHR |
| GSBER | Business Area | GSBER | GSBER |
| JAMON | Fiscal Year/Posting Period from Posting Date | JAMON_XPO | JAMON_XPO |
| KOART | Account type | KOART | KOART |
| KONTO | Account Number | KTONR_AV | KTONR |
| KOSTL | Cost Center | KOSTL | KOSTL |
| MABER | Dunning Area | MABER | MABER |
| MADAT | Date of Last Dunning Notice | MADAT | DATUM |
| MANSP | Dunning block | MANSP | MANSP |
| MANST | Dunning Level | MAHNS_D | MAHNS |
| MONAT | Fiscal period | MONAT | MONAT |
| MSCHL | Dunning key | MSCHL | MSCHL |
| MWSKZ | Tax on sales/purchases code | MWSKZ | MWSKZ |
| POSN2 | Sales Document Item | POSNR_VA | POSNR |
| PRCTR | Profit Center | PRCTR | PRCTR |
| QBSHB | Withholding Tax Amount (in Doc. Currency) with +/- Sign | QBSHB_VZ | WRTV7 |
| QSFBT | Amount Free of Withhld.Tax (in Doc.Curr.) with +/- Sign | QSFBT_VZ | WRTV7 |
| QSSHB | Withholding Tax Base Amount with +/- Sign | QSSHB_VZ | WRTV7 |
| REBZG | Number of the Invoice the Transaction Belongs to | REBZG | BELNR |
| SAMNR | Invoice List Number | SAMNR | SAMNR |
| SGTXT | Item Text | SGTXT | TEXT50 |
| SHKZG | Debit/Credit Indicator | SHKZG | SHKZG |
| SKFBT | Amount Subject to Discount in Document Curr. with +/- Sign | SKFBT_VZ | WRTV7 |
| SKNTO | Cash Discount Amount (+/-) in Local Currency | SKNTO_VZ | WRTV7 |
| STAKZ | Indicator: Statistical document ? | XSTKZ | XFELD |
| UMSKS | Special G/L Transaction Type | UMSKS | UMSKS |
| UMSKZ | Special G/L Indicator | UMSKZ | UMSKZ |
| UZAWE | Payment method supplement | UZAWE | UZAWE |
| VALUT | Fixed Value Date | VALUT | DATUM |
| VBEL2 | Sales Document | VBELN_VA | VBELN |
| VBELN | Billing document | VBELN_VF | VBELN |
| VBEWA | Flow Type | SBEWART | SBEWART |
| VBUND | Company ID of trading partner | RASSC | RCOMP |
| VERTN | Contract Number | RANL | RANL |
| VERTT | Contract Type | RANTYP | RANTYP |
| VERZ1 | Days in Arrears for Cash Discount Terms 1 | VERZ1 | WRTV3 |
| VERZN | Days in Arrears by Net Due Date | VERZN | WRTV3 |
| WERKS | Plant | WERKS_D | WERKS |
| WRSHB | Foreign Currency Amount with Signs (+/-) | WRSHB | WRTV7 |
| WAERS | Currency Key | WAERS | WAERS |
| WSKTO | Cash discount amount in document currency with +/- sign | WSKTO_VZ | WRTV7 |
| WVERW | Bill of Exchange Usage Type | WVERW | WVERW |
| XBLNR | Reference Document Number | XBLNR1 | XBLNR1 |
| XSTRP | Indicator: Disputed item? | XSTRP | XFELD |
| XZAHL | Indicator: Is Posting Key Used in a Payment Transaction? | XZAHL | XFELD |
| ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATUM |
| ZBD1P | Cash discount percentage 1 | DZBD1P | PRZ23 |
| ZBD1T | Cash discount days 1 | DZBD1T | ZBDXT |
| ZBD2P | Cash Discount Percentage 2 | DZBD2P | PRZ23 |
| ZBD2T | Cash discount days 2 | DZBD2T | ZBDXT |
| ZBD3T | Net Payment Terms Period | DZBD3T | ZBDXT |
| ZFBDT | Baseline date for due date calculation | DZFBDT | DATUM |
| ZINSZ | Interest Calculation Numerator (Days in Arrears * Amount) | DZINSZ | WRTV8 |
| ZLSCH | Payment method | DZLSCH | ZLSCH |
| ZLSPR | Payment Block Key | DZLSPR | ZAHLS |
| ZTERM | Terms of payment key | DZTERM | ZTERM |
| ZUONR | Assignment number | DZUONR | ZUONR |
| XREF1 | Business partner reference key | XREF1 | CHAR12 |
| XREF2 | Business partner reference key | XREF2 | CHAR12 |
| XARCH | Indicator: Document already archived ? | XARCH | XFELD |
| RSTGR | Reason Code for Payments | RSTGR | RSTGR |
| ASKTO | Current Cash Disc. Amount in Document Currency with +/- Sign | ASKTO_VZ | WRTV7 |
| KURSE | Effective Exchange Rate in the Line Item | KURSE | KURSF |
| REBZT | Follow-On Document Type | REBZT | REBZT |
| PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | WAERS |
| PSWBT | Amount for Updating in General Ledger | PSWBT | WERT7 |
| HKONT | General Ledger Account | HKONT | SAKNR |
| XNEGP | Indicator: Negative posting | XNEGP | XFELD |
| ZBFIX | Fixed Payment Terms | DZBFIX | ZBFIX |
| RFZEI | Payment Card Item | RFZEI_CC | NUM03 |
| CCBTC | Payment cards: Settlement run | CCBTC | CCBTC |
| KKBER | Credit control area | KKBER | KKBER |
| XREF3 | Reference key for line item | XREF3 | CHAR20 |
| DTWS1 | Instruction key 1 | DTAT16 | DTWSX |
| DTWS2 | Instruction key 2 | DTAT17 | DTWSX |
| DTWS3 | Instruction key 3 | DTAT18 | DTWSX |
| DTWS4 | Instruction key 4 | DTAT19 | DTWSX |
| ABSBT | Credit Management: Hedged Amount | ABSBT | WERT7 |
| KKBWR | Currency of Credit Control Area | KKBWR | WAERS |
| PROJK | Individual Structural Element (WBS Element) in Ext. Format | PROJK_EXT | CHAR24 |
| XPYPR | Indicator: Items from Payment Program Blocked | XPYPR | XFELD |
| KIDNO | Payment Reference | KIDNO | CHAR30 |
| XAUGP | Indicator: Item has been cleared? | XAUGP | XFELD |
| BUPLA | Business Place | BUPLA | J_1BBRANCH |
| SECCO | Section Code | SECCO | SECCO |
| GKART | Offsetting Account Type | GKART | GKART |
| GKONT | Offsetting Account Number | GKONT | GKONT |
| PYCUR | Currency for Automatic Payment | PYCUR | WAERS |
| PYAMT | Amount in Payment Currency | PYAMT | WERT7 |
| PYORD | Payment Order | PYORD | PYORD |
| XTEXT | Indicator: Texts exist ? | XTEXT_F02L | XFELD |
| TDID | Text ID | TDID | TDID |
| XDUEN | Indicator: Item is due net? | XDUEN | XFELD |
| XDUE1 | Indicator: Cash discount term 1 is due on item? | XDUE1 | XFELD |
| XRAGL | Indicator: Clearing was Reversed | XRAGL | XFELD |
| XSELP | Item selected (selected, chosen, ...) | XSELP | XFELD |
| CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CESSION_KZ |
| BUZID | Identification of the Line Item | BUZID | CHAR1 |
| AUGGJ | Fiscal Year of Clearing Document | AUGGJ | GJAHR |
| AGZEI | Clearing Item | AGZEI | AGZEI |
| VNAME | Joint venture | JV_NAME | JV_NAME |
| EGRUP | Equity group | JV_EGROUP | JV_EGROUP |
| BTYPE | Payroll Type | JV_BILIND | JV_BILIND |
| VORGN | Transaction Type for General Ledger | VORGN | VORGN |
J_3RFTAX_EXTRD related tables
| Table | Note |
|---|---|
| J_3RFTAX_EXTRD | Tax Extract Detail Lines |
| OIUX6_WY_CRPDTDT | Tax 2.0 - Wyoming Conservation Tax Report Detail Detail |
| OIUX6_WY_SRPDTDT | Tax 2.0 - Wyoming Severance Tax Report Detail Detail |
| COAT_E_TY_T | COAT: Extract Text Table to Extract Types |
| ERCHZ_SHORT | Billing Document Individual Lines Extract |
| ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data |
| TINV_LINEB_SHORT | Extract of Bill Receipt (Evaluation System): Bill Lines |
| PPMIX | Index Payroll Results Lines -> Posting Lines for Payment |
| PPOIX | Index of Payroll Result Lines -> Posting Lines |
| PRSD_CO_MAPPING | EM: Mapping original DMR lines to Carry Over lines |
| /ISDFPS/CFDPDA02 | Detail Area - Customizing Detail Screens |
| OIUX3_TX_PRDTB | Tax Reporting - Texas PRA Detail Txns-Tier Tax Below |
| OIUX3_TX_PRDTI | Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental |
| OIUX3_TX_PRDTN | Tax Reporting - Texas PRA Detail Txns - No Tier Tax |
| OIUX5_OK_PRDT | Tax 2.0 - Oklahoma PRA Detail Tax Transactions |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP