SAP ABAP Table J_3RSELL_BOOK (Structure for sale ledger)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-LOC (Application Component) Localization
⤷ J3RF (Package) Localization Russia: FI
⤷ FI-LOC (Application Component) Localization
⤷ J3RF (Package) Localization Russia: FI
Basic Data
Table Category | INTTAB | Structure |
Structure | J_3RSELL_BOOK | Table Relationship Diagram |
Short Description | Structure for sale 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 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
2 | GJAHR_INV | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
3 | BELNR_INV | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
4 | XBLNR_INV | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
5 | BUDAT_INV | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
6 | BLDAT_INV | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
7 | DMBTR_INV | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
8 | DMBTR_WRS_INV | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
9 | WRBTR_INV | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
10 | WRBTR_WRS_INV | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
11 | GJAHR_PAY | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
12 | BELNR_PAY | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
13 | XBLNR_PAY | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
14 | BUDAT_PAY | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
15 | BLDAT_PAY | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
16 | DMBTR_PAY | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
17 | DMBTR_WRS_PAY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
18 | WRBTR_PAY | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
19 | WRBTR_WRS_PAY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
20 | GJAHR_TRN | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
21 | BELNR_TRN | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
22 | BLDAT_TRN | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
23 | BUDAT_TRN | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
24 | DMBTR_TRN | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
25 | DMBTR_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
26 | WRBTR_TRN | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
27 | WRBTR_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
28 | HWBAS_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
29 | HWBAS_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
30 | FWBAS_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
31 | FWBAS_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
32 | HWBAS2_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
33 | HWBAS2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
34 | FWBAS2_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
35 | FWBAS2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
36 | HWBAS3_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
37 | HWBAS3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
38 | FWBAS3_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
39 | FWBAS3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
40 | HWBAS4_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
41 | HWBAS4_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
42 | FWBAS4_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
43 | FWBAS4_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
44 | HWBAS5_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
45 | HWBAS5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
46 | FWBAS5_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
47 | FWBAS5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
48 | BASGRUNO | BASGRUNO | NUM2 | NUMC | 2 | 0 | Group Number for Tax Base Amounts | ||
49 | HWSTE_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
50 | HWSTE_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
51 | HWSTE2_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
52 | HWSTE2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
53 | HWSTE3_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
54 | HWSTE3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
55 | HWSTE4_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
56 | HWSTE4_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
57 | HWSTE5_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
58 | HWSTE5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
59 | FWSTE_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
60 | FWSTE_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
61 | FWSTE2_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
62 | FWSTE2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
63 | FWSTE3_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
64 | FWSTE3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
65 | FWSTE4_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
66 | FWSTE4_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
67 | FWSTE5_TRN | ANZBT_F05L | WRTV7 | CURR | 13 | 2 | Amount Posted in Display Currency | ||
68 | FWSTE5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
69 | STEGRUNO | STEGRUNO | NUM2 | NUMC | 2 | 0 | Group Number for Tax Amounts | ||
70 | GJAHR_TEST | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
71 | BUZEI_TEST | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
72 | XBLNR_TEST | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
73 | LIFNR_CRED | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
74 | NAME1_CRED | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
75 | NAME2_CRED | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
76 | NAME3_CRED | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
77 | NAME4_CRED | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
78 | NAME1_CRED_R | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
79 | NAME2_CRED_R | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
80 | NAME3_CRED_R | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
81 | NAME4_CRED_R | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
82 | STCD1_CRED | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
83 | STCD3_CRED | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
84 | FLG_BELNR_TRN | J_3RF_BUE_F_D0 | KOART | CHAR | 1 | 0 | Reversal (Tax Transfer) | ||
85 | BKTXT_TRN | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
86 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
87 | FLG_BELNR_PAY | J_3RF_BUE_F_D2 | CHAR | 1 | 0 | Reversal (Payment) | |||
88 | FLG_BELNR_INV | J_3RF_BUE_F_D1 | KOART | CHAR | 1 | 0 | Reversal (Invoice) | ||
89 | FLG_XRAGL_PAY | XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
90 | FLG_BELNR_ALL | J_3RF_BUE_F_ALL | KOART | CHAR | 1 | 0 | Reversal (Clearing) | ||
91 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
92 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
93 | LINENUMB | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
94 | BELNR_BUY | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
95 | GJAHRBUY | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
96 | BUZEIBUY | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
97 | FLG_BARTER | XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
98 | BKTXT_PAY | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
99 | BKTXT_INV | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
100 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
101 | PART_PAYM | J_3RF_BUE_F_PP | CHAR | 1 | 0 | Partial Payment | |||
102 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
103 | EBELJ | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
104 | ZUONR | J_3RFZUONR | CHAR18 | CHAR | 18 | 0 | Assignment Number | ||
105 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
106 | XREF1_INV | XREF1 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
107 | XREF1_DAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
108 | HKONT_INV | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
109 | HKONT_TRN | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
110 | HKONT_CLN | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
111 | BELNR_ORIGPAY | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
112 | GJAHR_ORIGPAY | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
113 | BKTXT_ORIGPAY | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
114 | XBLNR_ORIGPAY | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
115 | BUDAT_ORIGPAY | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
116 | BLDAT_ORIGPAY | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
117 | USNAM_INV | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
118 | USNAM_PAY | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
119 | USNAM_PAY_FCT | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 500 |