SAP ABAP Table J_3RSELL_BOOK_EXT (Extended structure for sale 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_EXT	Table Relationship Diagram
Short Description	Extended structure for sale ledger

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	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	XBLNR	XBLNR	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	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
8	DMBTR_WRS_INV	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	WRBTR_INV	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
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	XBLNR	XBLNR	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	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
17	DMBTR_WRS_PAY	WAERS	WAERS	CUKY	5	0	Currency Key	*
18	WRBTR_PAY	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
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	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
25	DMBTR_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
26	WRBTR_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
27	WRBTR_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
28	HWBAS_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
29	HWBAS_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
30	FWBAS_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
31	FWBAS_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
32	HWBAS2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
33	HWBAS2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
34	FWBAS2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
35	FWBAS2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
36	HWBAS3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
37	HWBAS3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
38	FWBAS3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
39	FWBAS3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
40	HWBAS4_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
41	HWBAS4_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
42	FWBAS4_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
43	FWBAS4_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
44	HWBAS5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
45	HWBAS5_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
46	FWBAS5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
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	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
50	HWSTE_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
51	HWSTE2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
52	HWSTE2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
53	HWSTE3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
54	HWSTE3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
55	HWSTE4_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
56	HWSTE4_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
57	HWSTE5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
58	HWSTE5_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
59	FWSTE_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
60	FWSTE_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
61	FWSTE2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
62	FWSTE2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
63	FWSTE3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
64	FWSTE3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
65	FWSTE4_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
66	FWSTE4_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
67	FWSTE5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
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	XBLNR	XBLNR	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	XBLNR	XBLNR	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	*
120	.INCLUDE				0	0	Extension structure for Sales and Purchase Ledgers
121	BUKRS_ADD	BUKRS	BUKRS	CHAR	4	0	Company Code	*
122	BELNR_ADD	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
123	GJAHR_ADD	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
124	MONAT_ADD	MONAT	MONAT	NUMC	2	0	Fiscal period
125	BUZEI_ADD	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
126	FLAG_ADD	STORN	XFELD	CHAR	1	0	Indicator: Document is reversed