SAP ABAP Table J_3RSELL_BOOK_12C (Sales Book)
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_12C |
![]() |
Short Description | Sales Book |
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 | ![]() |
0 | 0 | Extended structure for sale ledger | |||||
2 | ![]() |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
4 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
5 | ![]() |
XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
6 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
7 | ![]() |
BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
8 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
9 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
10 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
11 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
12 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
13 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
14 | ![]() |
XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
15 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
16 | ![]() |
BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
17 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
18 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
19 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
20 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
21 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
22 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
23 | ![]() |
BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
24 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
25 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
26 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
27 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
28 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
29 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
30 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
31 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
32 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
33 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
34 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
35 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
36 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
37 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
38 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
39 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
40 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
41 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
42 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
43 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
44 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
45 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
46 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
47 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
48 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
49 | ![]() |
BASGRUNO | NUM2 | NUMC | 2 | 0 | Group Number for Tax Base Amounts | ||
50 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
51 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
52 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
53 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
54 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
55 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
56 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
57 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
58 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
59 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
60 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
61 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
62 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
63 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
64 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
65 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
66 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
67 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
68 | ![]() |
HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
69 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
70 | ![]() |
STEGRUNO | NUM2 | NUMC | 2 | 0 | Group Number for Tax Amounts | ||
71 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
72 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
73 | ![]() |
XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
74 | ![]() |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
75 | ![]() |
NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
76 | ![]() |
NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
77 | ![]() |
NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
78 | ![]() |
NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
79 | ![]() |
NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
80 | ![]() |
NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
81 | ![]() |
NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
82 | ![]() |
NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
83 | ![]() |
STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
84 | ![]() |
STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
85 | ![]() |
J_3RF_BUE_F_D0 | KOART | CHAR | 1 | 0 | Reversal (Tax Transfer) | ||
86 | ![]() |
BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
87 | ![]() |
MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
88 | ![]() |
J_3RF_BUE_F_D2 | CHAR | 1 | 0 | Reversal (Payment) | |||
89 | ![]() |
J_3RF_BUE_F_D1 | KOART | CHAR | 1 | 0 | Reversal (Invoice) | ||
90 | ![]() |
XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
91 | ![]() |
J_3RF_BUE_F_ALL | KOART | CHAR | 1 | 0 | Reversal (Clearing) | ||
92 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
93 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
94 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
95 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
96 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
97 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
98 | ![]() |
XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
99 | ![]() |
BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
100 | ![]() |
BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
101 | ![]() |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
102 | ![]() |
J_3RF_BUE_F_PP | CHAR | 1 | 0 | Partial Payment | |||
103 | ![]() |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
104 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
105 | ![]() |
J_3RFZUONR | CHAR18 | CHAR | 18 | 0 | Assignment Number | ||
106 | ![]() |
SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
107 | ![]() |
XREF1 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
108 | ![]() |
BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
109 | ![]() |
HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
110 | ![]() |
HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
111 | ![]() |
HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
112 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
113 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
114 | ![]() |
BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
115 | ![]() |
XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
116 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
117 | ![]() |
BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
118 | ![]() |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
119 | ![]() |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
120 | ![]() |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
121 | ![]() |
0 | 0 | Extension structure for Sales and Purchase Ledgers | |||||
122 | ![]() |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
123 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
124 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
125 | ![]() |
MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
126 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
127 | ![]() |
STORN | XFELD | CHAR | 1 | 0 | Indicator: Document is reversed | ||
128 | ![]() |
J_3RF_BUE_CORR_TYPE | J_3RF_BUE_CORR_TYPE | CHAR | 1 | 0 | Correction Type | ||
129 | ![]() |
J_3RF_BUE_CORR_BOOK | FLAG | CHAR | 1 | 0 | Correction invoice from opposite book | ||
130 | ![]() |
J_3RFINV_ORIGS | BELNR | CHAR | 10 | 0 | Number of Original VAT Invoice | ||
131 | ![]() |
J_3RFINV_ORIGY | GJAHR | NUMC | 4 | 0 | Year of Original VAT Invoice | ||
132 | ![]() |
J_3RFINV_ORIGD | DATUM | DATS | 8 | 0 | Date of Original VAT Invoice | ||
133 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
134 | ![]() |
J_3RF_EXT_NUMBER | TEXT50 | CHAR | 50 | 0 | External Document Number | ||
135 | ![]() |
J_3RFINV_REVNO | NUM03 | NUMC | 3 | 0 | Revision Number | ||
136 | ![]() |
J_3RFINV_REVNO_CORR | NUM03 | NUMC | 3 | 0 | Revision Number of Correction | ||
137 | ![]() |
VATDATE | DATUM | DATS | 8 | 0 | Tax Reporting Date | ||
138 | ![]() |
VATDATE | DATUM | DATS | 8 | 0 | Tax Reporting Date | ||
139 | ![]() |
J_3RFINV_CORRD | DATUM | DATS | 8 | 0 | Date of Corrective VAT Invoice | ||
140 | ![]() |
J_3RFINV_REGFLAG | J_3RF_REGFLAG | CHAR | 1 | 0 | Register in Journal |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 617 |