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	Table Relationship Diagram
Short Description	Sales Book

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	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	JOURNAL	J_3RFINV_REGFLAG	J_3RF_REGFLAG	CHAR	1	0	Register in Journal