SAP ABAP Table J_3RSELL_BOOK_12 (Extended structure for sales ledger)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J3RF (Package) Localization Russia: FI
Basic Data
Table Category INTTAB    Structure 
Structure J_3RSELL_BOOK_12   Table Relationship Diagram
Short Description Extended structure for sales ledger    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 .INCLUDE       0   0   Extended structure for sale ledger  
2 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
3 GJAHR_INV GJAHR GJAHR NUMC 4   0   Fiscal Year  
4 BELNR_INV BELNR_D BELNR CHAR 10   0   Accounting Document Number  
5 XBLNR_INV XBLNR XBLNR CHAR 16   0   Reference Document Number  
6 BUDAT_INV BUDAT DATUM DATS 8   0   Posting Date in the Document  
7 BLDAT_INV BLDAT DATUM DATS 8   0   Document Date in Document  
8 DMBTR_INV HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
9 DMBTR_WRS_INV WAERS WAERS CUKY 5   0   Currency Key *
10 WRBTR_INV HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
11 WRBTR_WRS_INV WAERS WAERS CUKY 5   0   Currency Key *
12 GJAHR_PAY GJAHR GJAHR NUMC 4   0   Fiscal Year  
13 BELNR_PAY BELNR_D BELNR CHAR 10   0   Accounting Document Number  
14 XBLNR_PAY XBLNR XBLNR CHAR 16   0   Reference Document Number  
15 BUDAT_PAY BUDAT DATUM DATS 8   0   Posting Date in the Document  
16 BLDAT_PAY BLDAT DATUM DATS 8   0   Document Date in Document  
17 DMBTR_PAY HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
18 DMBTR_WRS_PAY WAERS WAERS CUKY 5   0   Currency Key *
19 WRBTR_PAY HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
20 WRBTR_WRS_PAY WAERS WAERS CUKY 5   0   Currency Key *
21 GJAHR_TRN GJAHR GJAHR NUMC 4   0   Fiscal Year  
22 BELNR_TRN BELNR_D BELNR CHAR 10   0   Accounting Document Number  
23 BLDAT_TRN BLDAT DATUM DATS 8   0   Document Date in Document  
24 BUDAT_TRN BUDAT DATUM DATS 8   0   Posting Date in the Document  
25 DMBTR_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
26 DMBTR_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
27 WRBTR_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
28 WRBTR_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
29 HWBAS_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
30 HWBAS_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
31 FWBAS_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
32 FWBAS_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
33 HWBAS2_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
34 HWBAS2_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
35 FWBAS2_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
36 FWBAS2_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
37 HWBAS3_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
38 HWBAS3_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
39 FWBAS3_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
40 FWBAS3_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
41 HWBAS4_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
42 HWBAS4_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
43 FWBAS4_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
44 FWBAS4_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
45 HWBAS5_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
46 HWBAS5_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
47 FWBAS5_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
48 FWBAS5_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
49 BASGRUNO BASGRUNO NUM2 NUMC 2   0   Group Number for Tax Base Amounts  
50 HWSTE_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
51 HWSTE_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
52 HWSTE2_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
53 HWSTE2_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
54 HWSTE3_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
55 HWSTE3_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
56 HWSTE4_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
57 HWSTE4_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
58 HWSTE5_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
59 HWSTE5_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
60 FWSTE_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
61 FWSTE_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
62 FWSTE2_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
63 FWSTE2_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
64 FWSTE3_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
65 FWSTE3_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
66 FWSTE4_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
67 FWSTE4_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
68 FWSTE5_TRN HSLXX WERTV8 CURR 15   2   Total transactions in the period in local currency (curr 2)  
69 FWSTE5_WRS_TRN WAERS WAERS CUKY 5   0   Currency Key *
70 STEGRUNO STEGRUNO NUM2 NUMC 2   0   Group Number for Tax Amounts  
71 GJAHR_TEST GJAHR GJAHR NUMC 4   0   Fiscal Year  
72 BUZEI_TEST BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
73 XBLNR_TEST XBLNR XBLNR CHAR 16   0   Reference Document Number  
74 LIFNR_CRED LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
75 NAME1_CRED NAME1_GP NAME CHAR 35   0   Name 1  
76 NAME2_CRED NAME2_GP NAME CHAR 35   0   Name 2  
77 NAME3_CRED NAME3_GP NAME CHAR 35   0   Name 3  
78 NAME4_CRED NAME4_GP NAME CHAR 35   0   Name 4  
79 NAME1_CRED_R NAME1_GP NAME CHAR 35   0   Name 1  
80 NAME2_CRED_R NAME2_GP NAME CHAR 35   0   Name 2  
81 NAME3_CRED_R NAME3_GP NAME CHAR 35   0   Name 3  
82 NAME4_CRED_R NAME4_GP NAME CHAR 35   0   Name 4  
83 STCD1_CRED STCD1 STCD1 CHAR 16   0   Tax Number 1  
84 STCD3_CRED STCD3 CHAR18 CHAR 18   0   Tax Number 3  
85 FLG_BELNR_TRN J_3RF_BUE_F_D0 KOART CHAR 1   0   Reversal (Tax Transfer)  
86 BKTXT_TRN BKTXT TEXT25 CHAR 25   0   Document Header Text  
87 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
88 FLG_BELNR_PAY J_3RF_BUE_F_D2   CHAR 1   0   Reversal (Payment)  
89 FLG_BELNR_INV J_3RF_BUE_F_D1 KOART CHAR 1   0   Reversal (Invoice)  
90 FLG_XRAGL_PAY XRAGL XFELD CHAR 1   0   Indicator: Clearing was Reversed  
91 FLG_BELNR_ALL J_3RF_BUE_F_ALL KOART CHAR 1   0   Reversal (Clearing)  
92 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
93 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
94 LINENUMB BELNR_D BELNR CHAR 10   0   Accounting Document Number  
95 BELNR_BUY BELNR_D BELNR CHAR 10   0   Accounting Document Number  
96 GJAHRBUY GJAHR GJAHR NUMC 4   0   Fiscal Year  
97 BUZEIBUY BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
98 FLG_BARTER XRAGL XFELD CHAR 1   0   Indicator: Clearing was Reversed  
99 BKTXT_PAY BKTXT TEXT25 CHAR 25   0   Document Header Text  
100 BKTXT_INV BKTXT TEXT25 CHAR 25   0   Document Header Text  
101 GSBER GSBER GSBER CHAR 4   0   Business Area *
102 PART_PAYM J_3RF_BUE_F_PP   CHAR 1   0   Partial Payment  
103 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
104 EBELJ GJAHR GJAHR NUMC 4   0   Fiscal Year  
105 ZUONR J_3RFZUONR CHAR18 CHAR 18   0   Assignment Number  
106 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
107 XREF1_INV XREF1 CHAR12 CHAR 12   0   Business partner reference key  
108 XREF1_DAT BLDAT DATUM DATS 8   0   Document Date in Document  
109 HKONT_INV HKONT SAKNR CHAR 10   0   General Ledger Account *
110 HKONT_TRN HKONT SAKNR CHAR 10   0   General Ledger Account *
111 HKONT_CLN HKONT SAKNR CHAR 10   0   General Ledger Account *
112 BELNR_ORIGPAY BELNR_D BELNR CHAR 10   0   Accounting Document Number  
113 GJAHR_ORIGPAY GJAHR GJAHR NUMC 4   0   Fiscal Year  
114 BKTXT_ORIGPAY BKTXT TEXT25 CHAR 25   0   Document Header Text  
115 XBLNR_ORIGPAY XBLNR XBLNR CHAR 16   0   Reference Document Number  
116 BUDAT_ORIGPAY BUDAT DATUM DATS 8   0   Posting Date in the Document  
117 BLDAT_ORIGPAY BLDAT DATUM DATS 8   0   Document Date in Document  
118 USNAM_INV USNAM XUBNAME CHAR 12   0   User name *
119 USNAM_PAY USNAM XUBNAME CHAR 12   0   User name *
120 USNAM_PAY_FCT USNAM XUBNAME CHAR 12   0   User name *
121 .INCLUDE       0   0   Extension structure for Sales and Purchase Ledgers  
122 BUKRS_ADD BUKRS BUKRS CHAR 4   0   Company Code *
123 BELNR_ADD BELNR_D BELNR CHAR 10   0   Accounting Document Number  
124 GJAHR_ADD GJAHR GJAHR NUMC 4   0   Fiscal Year  
125 MONAT_ADD MONAT MONAT NUMC 2   0   Fiscal period  
126 BUZEI_ADD BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
127 FLAG_ADD STORN XFELD CHAR 1   0   Indicator: Document is reversed  
128 CORR_TYPE J_3RF_BUE_CORR_TYPE J_3RF_BUE_CORR_TYPE CHAR 1   0   Correction Type  
129 CORR_BOOK J_3RF_BUE_CORR_BOOK FLAG CHAR 1   0   Correction invoice from opposite book  
130 BELNR_ORIG_INV J_3RFINV_ORIGS BELNR CHAR 10   0   Number of Original VAT Invoice  
131 GJAHR_ORIG_INV J_3RFINV_ORIGY GJAHR NUMC 4   0   Year of Original VAT Invoice  
132 BLDAT_ORIG_INV J_3RFINV_ORIGD DATUM DATS 8   0   Date of Original VAT Invoice  
133 BUDAT_ORIG_INV BUDAT DATUM DATS 8   0   Posting Date in the Document  
134 XBLNR_ORIG_INV J_3RF_EXT_NUMBER TEXT50 CHAR 50   0   External Document Number  
135 NUMBER_REV J_3RFINV_REVNO NUM03 NUMC 3   0   Revision Number  
136 NUMBER_CORR_REV J_3RFINV_REVNO_CORR NUM03 NUMC 3   0   Revision Number of Correction  
137 VATDATE_INV VATDATE DATUM DATS 8   0   Tax Reporting Date  
138 VATDATE_TRN VATDATE DATUM DATS 8   0   Tax Reporting Date  
139 BLDAT_CORR_INV J_3RFINV_CORRD DATUM DATS 8   0   Date of Corrective VAT Invoice  
140 XBLNR_CORR_INV J_3RF_EXT_NUMBER TEXT50 CHAR 50   0   External Document Number  
141 JOURNAL J_3RFINV_REGFLAG J_3RF_REGFLAG CHAR 1   0   Register in Journal  
142 BELNR_CORR_INV J_3RFINV_CORRS BELNR CHAR 10   0   Number of Corrective VAT Invoice  
143 GJAHR_CORR_INV J_3RFINV_CORRY GJAHR NUMC 4   0   Year of Corrective VAT Invoice  
144 BELNR_ORIG_REV J_3RFINV_REVS BELNR CHAR 10   0   Number of Revised VAT Invoice  
145 GJAHR_ORIG_REV J_3RFINV_REVY GJAHR NUMC 4   0   Year of Revised VAT Invoice  
146 BLDAT_ORIG_REV J_3RFINV_REVD DATUM DATS 8   0   Revision Date  
147 BELNR_CORR_REV J_3RFINV_CORR_REVS BELNR CHAR 10   0   Number of Revised Correction Invoice  
148 GJAHR_CORR_REV J_3RFINV_CORR_REVY GJAHR NUMC 4   0   Year of Revised Correction Invoice  
149 BLDAT_CORR_REV J_3RFINV_CORR_REVD DATUM DATS 8   0   Revision Date of Correction  
150 EXT_TEXT_ORIG FLAG FLAG CHAR 1   0   General Flag  
151 EXT_TEXT_CORR FLAG FLAG CHAR 1   0   General Flag  
History
Last changed by/on SAP  20131127 
SAP Release Created in 607