SAP ABAP Table J_3RFTAX_EXTRD (Tax Extract Detail Lines)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J3RFTAX (Package) Tax Accounting
Basic Data
Table Category TRANSP    Transparent table 
Transparent table J_3RFTAX_EXTRD   Table Relationship Diagram
Short Description Tax Extract Detail Lines    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 EXTRT J_3RF_TAX_EXTRACT J_3RF_TAX_EXTRACT CHAR 12   0   Extract name J_3RFTAX_EXTRH
3 BUKRS1 BUKRS BUKRS CHAR 4   0   Company Code T001
4 BELNR1 BELNR_D BELNR CHAR 10   0   Accounting Document Number  
5 GJAHR1 GJAHR GJAHR NUMC 4   0   Fiscal Year  
6 BUZEI1 BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
7 .INCLUDE       0   0   Line Item data for Customer/Vendor/G/L Account  
8 ACTIV ACTIV NUM02 NUMC 2   0   List Level in which the Line Item is Active  
9 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
10 ANLN2 ANLN2_4 ANLN2_4 CHAR 4   0   New asset subnumber, 4 characters  
11 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
12 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
13 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
14 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
15 BLART BLART BLART CHAR 2   0   Document type T003
16 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
17 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
18 BSTAT BSTAT_D BSTAT CHAR 1   0   Document Status  
19 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
20 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
21 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
22 BWWRT BWWRT WRTV7 CURR 13   2   Amount Valuated in Local Currency  
23 BWWR2 BWWR2 WRTV7 CURR 13   2   Amount Valuated in Local Currency 2  
24 BWWR3 BWWR3 WRTV7 CURR 13   2   Amount Valuated in Local Currency 3  
25 DMSHB DMSHB WRTV7 CURR 13   2   Amount in Local Currency with +/- Signs  
26 HWAER HWAER WAERS CUKY 5   0   Local Currency TCURC
27 DMBE2 DMBE2_VZ WRTV7 CURR 13   2   Amount in Second Local Currency with +/- Sign  
28 HWAE2 HWAE2 WAERS CUKY 5   0   Currency Key of Second Local Currency *
29 DMBE3 DMBE3_VZ WRTV7 CURR 13   2   Amount in Third Local Currency with +/- Sign  
30 HWAE3 HWAE3 WAERS CUKY 5   0   Currency Key of Third Local Currency *
31 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
32 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
33 ETEN2 ETENR ETENR NUMC 4   0   Schedule line *
34 FAEDT FAEDT_FPOS DATUM DATS 8   0   Net Due Date  
35 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
36 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
37 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
38 JAMON JAMON_XPO JAMON_XPO CHAR 7   0   Fiscal Year/Posting Period from Posting Date  
39 KOART KOART KOART CHAR 1   0   Account type  
40 KONTO KTONR_AV KTONR CHAR 10   0   Account Number  
41 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
42 MABER MABER MABER CHAR 2   0   Dunning Area *
43 MADAT MADAT DATUM DATS 8   0   Date of Last Dunning Notice  
44 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
45 MANST MAHNS_D MAHNS NUMC 1   0   Dunning Level  
46 MONAT MONAT MONAT NUMC 2   0   Fiscal period  
47 MSCHL MSCHL MSCHL CHAR 1   0   Dunning key T040
48 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
49 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item *
50 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
51 QBSHB QBSHB_VZ WRTV7 CURR 13   2   Withholding Tax Amount (in Doc. Currency) with +/- Sign  
52 QSFBT QSFBT_VZ WRTV7 CURR 13   2   Amount Free of Withhld.Tax (in Doc.Curr.) with +/- Sign  
53 QSSHB QSSHB_VZ WRTV7 CURR 13   2   Withholding Tax Base Amount with +/- Sign  
54 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
55 SAMNR SAMNR SAMNR NUMC 8   0   Invoice List Number  
56 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
57 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
58 SKFBT SKFBT_VZ WRTV7 CURR 13   2   Amount Subject to Discount in Document Curr. with +/- Sign  
59 SKNTO SKNTO_VZ WRTV7 CURR 13   2   Cash Discount Amount (+/-) in Local Currency  
60 STAKZ XSTKZ XFELD CHAR 1   0   Indicator: Statistical document ?  
61 UMSKS UMSKS UMSKS CHAR 1   0   Special G/L Transaction Type  
62 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator *
63 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
64 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
65 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document *
66 VBELN VBELN_VF VBELN CHAR 10   0   Billing document *
67 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
68 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
69 VERTN RANL RANL CHAR 13   0   Contract Number  
70 VERTT RANTYP RANTYP CHAR 1   0   Contract Type  
71 VERZ1 VERZ1 WRTV3 DEC 5   0   Days in Arrears for Cash Discount Terms 1  
72 VERZN VERZN WRTV3 DEC 5   0   Days in Arrears by Net Due Date  
73 WERKS WERKS_D WERKS CHAR 4   0   Plant *
74 WRSHB WRSHB WRTV7 CURR 13   2   Foreign Currency Amount with Signs (+/-)  
75 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
76 WSKTO WSKTO_VZ WRTV7 CURR 13   2   Cash discount amount in document currency with +/- sign  
77 WVERW WVERW WVERW CHAR 1   0   Bill of Exchange Usage Type  
78 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
79 XSTRP XSTRP XFELD CHAR 1   0   Indicator: Disputed item?  
80 XZAHL XZAHL XFELD CHAR 1   0   Indicator: Is Posting Key Used in a Payment Transaction?  
81 ZALDT DZALDT DATUM DATS 8   0   Probable Payment Date (Cash Discount 1 Due)  
82 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
83 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
84 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
85 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
86 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
87 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
88 ZINSZ DZINSZ WRTV8 CURR 15   2   Interest Calculation Numerator (Days in Arrears * Amount)  
89 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
90 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key *
91 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
92 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
93 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
94 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
95 XARCH XARCH XFELD CHAR 1   0   Indicator: Document already archived ?  
96 RSTGR RSTGR RSTGR CHAR 3   0   Reason Code for Payments *
97 ASKTO ASKTO_VZ WRTV7 CURR 13   2   Current Cash Disc. Amount in Document Currency with +/- Sign  
98 KURSE KURSE KURSF DEC 9   5   Effective Exchange Rate in the Line Item  
99 REBZT REBZT REBZT CHAR 1   0   Follow-On Document Type  
100 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures TCURC
101 PSWBT PSWBT WERT7 CURR 13   2   Amount for Updating in General Ledger  
102 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
103 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
104 ZBFIX DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
105 RFZEI RFZEI_CC NUM03 NUMC 3   0   Payment Card Item  
106 CCBTC CCBTC CCBTC CHAR 10   0   Payment cards: Settlement run  
107 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
108 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
109 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
110 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
111 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
112 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
113 ABSBT ABSBT WERT7 CURR 13   2   Credit Management: Hedged Amount  
114 KKBWR KKBWR WAERS CUKY 5   0   Currency of Credit Control Area *
115 PROJK PROJK_EXT CHAR24 CHAR 24   0   Individual Structural Element (WBS Element) in Ext. Format  
116 XPYPR XPYPR XFELD CHAR 1   0   Indicator: Items from Payment Program Blocked  
117 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
118 XAUGP XAUGP XFELD CHAR 1   0   Indicator: Item has been cleared?  
119 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
120 SECCO SECCO SECCO CHAR 4   0   Section Code *
121 GKART GKART GKART CHAR 1   0   Offsetting Account Type  
122 GKONT GKONT GKONT CHAR 10   0   Offsetting Account Number  
123 PYCUR PYCUR WAERS CUKY 5   0   Currency for Automatic Payment *
124 PYAMT PYAMT WERT7 CURR 13   2   Amount in Payment Currency  
125 PYORD PYORD PYORD CHAR 10   0   Payment Order  
126 XTEXT XTEXT_F02L XFELD CHAR 1   0   Indicator: Texts exist ?  
127 TDID TDID TDID CHAR 4   0   Text ID *
128 XDUEN XDUEN XFELD CHAR 1   0   Indicator: Item is due net?  
129 XDUE1 XDUE1 XFELD CHAR 1   0   Indicator: Cash discount term 1 is due on item?  
130 XRAGL XRAGL XFELD CHAR 1   0   Indicator: Clearing was Reversed  
131 XSELP XSELP XFELD CHAR 1   0   Item selected (selected, chosen, ...)  
132 CESSION_KZ CESSION_KZ CESSION_KZ CHAR 2   0   Accounts Receivable Pledging Indicator *
133 BUZID BUZID CHAR1 CHAR 1   0   Identification of the Line Item  
134 AUGGJ AUGGJ GJAHR NUMC 4   0   Fiscal Year of Clearing Document  
135 AGZEI AGZEI AGZEI DEC 5   0   Clearing Item  
136 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture T8JV
137 EGRUP JV_EGROUP JV_EGROUP CHAR 3   0   Equity group T8JF
138 BTYPE JV_BILIND JV_BILIND CHAR 2   0   Payroll Type T8JA
139 VORGN VORGN VORGN CHAR 4   0   Transaction Type for General Ledger  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_3RFTAX_EXTRD BLART T003 BLART    
2 J_3RFTAX_EXTRD BSCHL TBSL BSCHL    
3 J_3RFTAX_EXTRD BTYPE T8JA BILIND REF C CN
4 J_3RFTAX_EXTRD BUKRS T001 BUKRS    
5 J_3RFTAX_EXTRD BUKRS1 T001 BUKRS    
6 J_3RFTAX_EXTRD EGRUP T8JF EGRUP REF C CN
7 J_3RFTAX_EXTRD EXTRT J_3RFTAX_EXTRH EXTRT    
8 J_3RFTAX_EXTRD GSBER TGSB GSBER    
9 J_3RFTAX_EXTRD HWAER TCURC WAERS    
10 J_3RFTAX_EXTRD KKBER T014 KKBER REF 1 CN
11 J_3RFTAX_EXTRD MANDT T000 MANDT    
12 J_3RFTAX_EXTRD MANSP T040S MANSP    
13 J_3RFTAX_EXTRD MSCHL T040 MSCHL    
14 J_3RFTAX_EXTRD PSWSL TCURC WAERS    
15 J_3RFTAX_EXTRD VNAME T8JV VNAME REF C CN
16 J_3RFTAX_EXTRD WAERS TCURC WAERS    
17 J_3RFTAX_EXTRD ZLSCH T042Z ZLSCH    
History
Last changed by/on SAP  20130529 
SAP Release Created in