	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

190 COLUMNS | 1 INDEXES | ERP 6.0 | S481 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Media :: Advertising Management
1	ERP EHP7	6.0	S481	190	1	IS-M/AM: View of BP Sales Areas	Advertising Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, SSOUR, VRSIO, SPMON, SPTAG, SPWOC, SPBUP, GPAG, REGULIERER, INSERENT, VKORG, VTWEG, SPART, VKBUR, UR_BELEINH, BELEGEINH, PERIV, VWDAT, STWAE, J_VRKME_D, UMNETWR, UMBRTWR, UMKZWI1, UMKZWI2, UMKZWI3, UMKZWI4, UMKZWI5, UMKZWI6, GUNETWR, GUBRTWR, GUKZWI1, GUKZWI2, GUKZWI3, GUKZWI4, GUKZWI5, GUKZWI6, ANNETWR, ANBRTWR, ANKZWI1, ANKZWI2, ANKZWI3, ANKZWI4, ANKZWI5, ANKZWI6, SINETWR, SIBRTWR, SIKZWI1, SIKZWI2, SIKZWI3, SIKZWI4, SIKZWI5, SIKZWI6, DLNETWR, DLBRTWR, DLKZWI1, DLKZWI2, DLKZWI3, DLKZWI4, DLKZWI5, DLKZWI6, GUANNETWR, GUANBRTWR, GUANKZWI1, GUANKZWI2, GUANKZWI3, GUANKZWI4, GUANKZWI5, GUANKZWI6, GUSINETWR, GUSIBRTWR, GUSIKZWI1, GUSIKZWI2, GUSIKZWI3, GUSIKZWI4, GUSIKZWI5, GUSIKZWI6, GUDLNETWR, GUDLBRTWR, GUDLKZWI1, GUDLKZWI2, GUDLKZWI3, GUDLKZWI4, GUDLKZWI5, GUDLKZWI6, F_UMBRTWR, F_UMNETWR, F_UMKZWI1, F_UMKZWI2, F_UMKZWI3, F_UMKZWI4, F_UMKZWI5, F_UMKZWI6, F_GUBRTWR, F_GUNETWR, F_GUKZWI1, F_GUKZWI2, F_GUKZWI3, F_GUKZWI4, F_GUKZWI5, F_GUKZWI6, F_ANBRTWR, F_ANNETWR, F_ANKZWI1, F_ANKZWI2, F_ANKZWI3, F_ANKZWI4, F_ANKZWI5, F_ANKZWI6, F_SIBRTWR, F_SINETWR, F_SIKZWI1, F_SIKZWI2, F_SIKZWI3, F_SIKZWI4, F_SIKZWI5, F_SIKZWI6, F_DLBRTWR, F_DLNETWR, F_DLKZWI1, F_DLKZWI2, F_DLKZWI3, F_DLKZWI4, F_DLKZWI5, F_DLKZWI6, F_GUANBRTW, F_GUANNETW, F_GUANKZW1, F_GUANKZW2, F_GUANKZW3, F_GUANKZW4, F_GUANKZW5, F_GUANKZW6, F_GUSIBRTW, F_GUSINETW, F_GUSIKZW1, F_GUSIKZW2, F_GUSIKZW3, F_GUSIKZW4, F_GUSIKZW5, F_GUSIKZW6, F_GUDLBRTW, F_GUDLNETW, F_GUDLKZW1, F_GUDLKZW2, F_GUDLKZW3, F_GUDLKZW4, F_GUDLKZW5, F_GUDLKZW6, FMGGES, FMGGESGS, FMGAZ, FMGSI, FMGDL, FMGAZGS, FMGSIGS, FMGDLGS, WSNETWR, WSBRTWR, WSKZWI1, WSKZWI2, WSKZWI3, WSKZWI4, WSKZWI5, WSKZWI6, GUWSNETWR, GUWSBRTWR, GUWSKZWI1, GUWSKZWI2, GUWSKZWI3, GUWSKZWI4, GUWSKZWI5, GUWSKZWI6, F_WSBRTWR, F_WSNETWR, F_WSKZWI1, F_WSKZWI2, F_WSKZWI3, F_WSKZWI4, F_WSKZWI5, F_WSKZWI6, F_GUWSBRTW, F_GUWSNETW, F_GUWSKZW1, F_GUWSKZW2, F_GUWSKZW3, F_GUWSKZW4, F_GUWSKZW5, F_GUWSKZW6, FMGWS, FMGWSGS FROM S481

TOP ERP 6.0 | S481 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	SSOUR	Statistic(s) origin	nvarchar	4	0	CHAR	(N' ')	No		SSOUR	Allow NULL?
3	VRSIO	Version number in the information structure	nvarchar	3	0	CHAR	(N' ')	No	*	VRSIO	Allow NULL?
4	SPMON	Period to analyze - month	nvarchar	6	0	NUMC	(N'000000')	No		SPMON	Allow NULL?
5	SPTAG	Period to analyze - current date	nvarchar	8	0	DATS	(N'00000000')	No		SPTAG	Allow NULL?
6	SPWOC	Period to analyze - week	nvarchar	6	0	NUMC	(N'000000')	No		SPWOC	Allow NULL?
7	SPBUP	Period to analyze - posting period	nvarchar	6	0	NUMC	(N'000000')	No		SPBUP	Allow NULL?
8	GPAG	Business Partner: Sold-to Party	nvarchar	10	0	CHAR	(N' ')	No	JGTGPNR	GPAG	Allow NULL?
9	REGULIERER	IS-M: Payer	nvarchar	10	0	CHAR	(N' ')	No	JGTGPNR	REGULIERER	Allow NULL?
10	INSERENT	IS-M: Advertiser	nvarchar	10	0	CHAR	(N' ')	No	JGTGPNR	INSERENT	Allow NULL?
11	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	No	TVKO	VKORG	Allow NULL?
12	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	No	TVKOV	VTWEG	Allow NULL?
13	SPART	Division	nvarchar	2	0	CHAR	(N' ')	No	TVTA	SPART	Allow NULL?
14	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	No	TVKBZ	VKBUR	Allow NULL?
15	UR_BELEINH	IS-M: Initial Booking Unit for the OPM Item	nvarchar	10	0	CHAR	(N' ')	No	JJTBE	UR_BELEINH	Allow NULL?
16	BELEGEINH	IS-M/AM: Booking Unit	nvarchar	10	0	CHAR	(N' ')	No	JJTBE	BELEGEINH	Allow NULL?
17	PERIV	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	*	PERIV	Allow NULL?
18	VWDAT	Pointer to administrative data	nvarchar	10	0	NUMC	(N'0000000000')	Yes		VWDAT	Allow NULL?
19	STWAE	Statistics currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	STWAE	Allow NULL?
20	J_VRKME_D	IS-M: LIS Auxiliary Field for Sales Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	T006	J_VRKME_D	Allow NULL?
21	UMNETWR	IS-M/AM: LIS order net sales volume	decimal	19	2	CURR	((0))	Yes		J_UMNETWR
22	UMBRTWR	IS-M/AM: LIS order total gross sales volume	decimal	19	2	CURR	((0))	Yes		J_UMBRTWR
23	UMKZWI1	IS-M/AM: LIS order ST1 total	decimal	17	2	CURR	((0))	Yes		J_UMKZWI1
24	UMKZWI2	IS-M/AM: LIS order ST2 total	decimal	17	2	CURR	((0))	Yes		J_UMKZWI2
25	UMKZWI3	IS-M/AM: LIS order ST3 total	decimal	17	2	CURR	((0))	Yes		J_UMKZWI3
26	UMKZWI4	IS-M/AM: LIS order ST4 total	decimal	17	2	CURR	((0))	Yes		J_UMKZWI4
27	UMKZWI5	IS-M/AM: LIS order ST5 total	decimal	17	2	CURR	((0))	Yes		J_UMKZWI5
28	UMKZWI6	IS-M/AM: LIS order ST6 total	decimal	17	2	CURR	((0))	Yes		J_UMKZWI6
29	GUNETWR	IS-M/AM: LIS order sales volume net credit memo total	decimal	19	2	CURR	((0))	Yes		J_GUNETWR
30	GUBRTWR	IS-M/AM: LIS order sales volume gross credit memo total	decimal	19	2	CURR	((0))	Yes		J_GUBRTWR
31	GUKZWI1	IS-M/AM: LIS order ST1 total credit memo	decimal	17	2	CURR	((0))	Yes		J_GUKZWI1
32	GUKZWI2	IS-M/AM: LIS order ST2 total credit memo	decimal	17	2	CURR	((0))	Yes		J_GUKZWI2
33	GUKZWI3	IS-M/AM: LIS order ST3 total credit memo	decimal	17	2	CURR	((0))	Yes		J_GUKZWI3
34	GUKZWI4	IS-M/AM: LIS order ST4 total credit memo	decimal	17	2	CURR	((0))	Yes		J_GUKZWI4
35	GUKZWI5	IS-M/AM: LIS order ST5 total credit memo	decimal	17	2	CURR	((0))	Yes		J_GUKZWI5
36	GUKZWI6	IS-M/AM: LIS order ST6 total credit memo	decimal	17	2	CURR	((0))	Yes		J_GUKZWI6
37	ANNETWR	IS-M/AM: LIS Order Net Sales Volume for Ad	decimal	19	2	CURR	((0))	Yes		J_ANNETWR
38	ANBRTWR	IS-M/AM: LIS Order Gross Sales Volume Ad	decimal	19	2	CURR	((0))	Yes		J_ANBRTWR
39	ANKZWI1	IS-M/AM: LIS Order ST1 for Ad Item	decimal	17	2	CURR	((0))	Yes		J_ANKZWI1
40	ANKZWI2	IS-M/AM: LIS Order ST2 Ad	decimal	17	2	CURR	((0))	Yes		J_ANKZWI2
41	ANKZWI3	IS-M/AM: LIS Order ST3 Ad	decimal	17	2	CURR	((0))	Yes		J_ANKZWI3
42	ANKZWI4	IS-M/AM: LIS Order ST4 Ad	decimal	17	2	CURR	((0))	Yes		J_ANKZWI4
43	ANKZWI5	IS-M/AM: LIS Order ST5 Ad	decimal	17	2	CURR	((0))	Yes		J_ANKZWI5
44	ANKZWI6	IS-M/AM: LIS Order ST6 Ad	decimal	17	2	CURR	((0))	Yes		J_ANKZWI6
45	SINETWR	IS-M/AM: LIS order net sales vol.ad insert	decimal	19	2	CURR	((0))	Yes		J_SINETWR
46	SIBRTWR	IS-M/AM: LIS order gross sales volume for ad insert	decimal	19	2	CURR	((0))	Yes		J_SIBRTWR
47	SIKZWI1	IS-M/AM: LIS order ST1 ad insert	decimal	17	2	CURR	((0))	Yes		J_SIKZWI1
48	SIKZWI2	IS-M/AM: LIS order ST2 ad insert	decimal	17	2	CURR	((0))	Yes		J_SIKZWI2
49	SIKZWI3	IS-M/AM: LIS order ST3 ad insert	decimal	17	2	CURR	((0))	Yes		J_SIKZWI3
50	SIKZWI4	IS-M/AM: LIS order ST4 ad insert	decimal	17	2	CURR	((0))	Yes		J_SIKZWI4
51	SIKZWI5	IS-M/AM: LIS order ST5 ad insert	decimal	17	2	CURR	((0))	Yes		J_SIKZWI5
52	SIKZWI6	IS-M/AM: LIS order ST6 ad insert	decimal	17	2	CURR	((0))	Yes		J_SIKZWI6
53	DLNETWR	IS-M/AM: LIS order net sales volume service	decimal	19	2	CURR	((0))	Yes		J_DLNETWR
54	DLBRTWR	IS-M/AM: LIS order gross sales volume for service	decimal	19	2	CURR	((0))	Yes		J_DLBRTWR
55	DLKZWI1	IS-M/AM: LIS order ST1 service	decimal	17	2	CURR	((0))	Yes		J_DLKZWI1
56	DLKZWI2	IS-M/AM: LIS order ST2 service	decimal	17	2	CURR	((0))	Yes		J_DLKZWI2
57	DLKZWI3	IS-M/AM: LIS order ST3 service	decimal	17	2	CURR	((0))	Yes		J_DLKZWI3
58	DLKZWI4	IS-M/AM: LIS ST4 service	decimal	17	2	CURR	((0))	Yes		J_DLKZWI4
59	DLKZWI5	IS-M/AM: LIS order ST5 service	decimal	17	2	CURR	((0))	Yes		J_DLKZWI5
60	DLKZWI6	IS-M/AM: LIS order ST6 service	decimal	17	2	CURR	((0))	Yes		J_DLKZWI6
61	GUANNETWR	IS-M/AM: LIS Billing Net SVol Ad Credit Memo	decimal	19	2	CURR	((0))	Yes		JMC_GUANNE
62	GUANBRTWR	IS-M: LIS Order Gross SVol Ad Credit Memo	decimal	19	2	CURR	((0))	Yes		JMC_GUANBR
63	GUANKZWI1	IS-M/AM: LIS Order ST1 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		J_GUANKZW1
64	GUANKZWI2	IS-M/AM: LIS Order ST2 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		J_GUANKZW2
65	GUANKZWI3	IS-M/AM: LIS Order ST3 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		J_GUANKZW3
66	GUANKZWI4	IS-M/AM: LIS Order ST4 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		J_GUANKZW4
67	GUANKZWI5	IS-M/AM: LIS Order ST5 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		J_GUANKZW5
68	GUANKZWI6	IS-M/AM: LIS Order ST6 ad Credit Memo	decimal	17	2	CURR	((0))	Yes		J_GUANKZW6
69	GUSINETWR	IS-M: LIS order sales vol.net value ad insert credit memo	decimal	19	2	CURR	((0))	Yes		JMC_GUSINE
70	GUSIBRTWR	IS-M: LIS order sales vol.gro.value ad insert credit memo	decimal	19	2	CURR	((0))	Yes		JMC_GUSIBR
71	GUSIKZWI1	IS-M/AM: LIS order ST1 ad insert credit memo	decimal	17	2	CURR	((0))	Yes		J_GUSIKZW1
72	GUSIKZWI2	IS-M/AM: LIS order ST2 ad insert credit memo	decimal	17	2	CURR	((0))	Yes		J_GUSIKZW2
73	GUSIKZWI3	IS-M/AM: LIS order ST3 ad insert credit memo	decimal	17	2	CURR	((0))	Yes		J_GUSIKZW3
74	GUSIKZWI4	IS-M/AM: LIS order ST4 ad insert credit memo	decimal	17	2	CURR	((0))	Yes		J_GUSIKZW4
75	GUSIKZWI5	IS-M/AM: LIS order ST5 ad insert credit memo	decimal	17	2	CURR	((0))	Yes		J_GUSIKZW5
76	GUSIKZWI6	IS-M/AM: LIS order ST6 ad insert credit memo	decimal	17	2	CURR	((0))	Yes		J_GUSIKZW6
77	GUDLNETWR	IS-M/AM: LIS order SVol net value service credit memo	decimal	19	2	CURR	((0))	Yes		JMC_GUDLNE
78	GUDLBRTWR	IS-M: LIS order SVol gross value service credit memo	decimal	19	2	CURR	((0))	Yes		JMC_GUDLBR
79	GUDLKZWI1	IS-M/AM: LIS order ST1 service credit memo	decimal	17	2	CURR	((0))	Yes		J_GUDLKZW1
80	GUDLKZWI2	IS-M/AM: LIS order ST2 service credit memo	decimal	17	2	CURR	((0))	Yes		J_GUDLKZW2
81	GUDLKZWI3	IS-M/AM: LIS order ST3 service credit memo	decimal	17	2	CURR	((0))	Yes		J_GUDLKZW3
82	GUDLKZWI4	IS-M/AM: LIS order ST4 service credit memo	decimal	17	2	CURR	((0))	Yes		J_GUDLKZW4
83	GUDLKZWI5	IS-M/AM: LIS order ST5 service credit memo	decimal	17	2	CURR	((0))	Yes		J_GUDLKZW5
84	GUDLKZWI6	IS-M/AM: LIS order ST6 service credit memo	decimal	17	2	CURR	((0))	Yes		J_GUDLKZW6
85	F_UMBRTWR	IS-M: LIS Billing Total Gross Sales Volume	decimal	19	2	CURR	((0))	Yes		F_UMBRTWR
86	F_UMNETWR	IS-M: LIS billing total net sales volume	decimal	19	2	CURR	((0))	Yes		F_UMNETWR
87	F_UMKZWI1	IS-M: LIS Billing ST1 for All Items	decimal	17	2	CURR	((0))	Yes		F_UMKZWI1
88	F_UMKZWI2	IS-M: LIS Billing ST2 Total	decimal	17	2	CURR	((0))	Yes		F_UMKZWI2
89	F_UMKZWI3	IS-M: LIS Billing ST3 Total	decimal	17	2	CURR	((0))	Yes		F_UMKZWI3
90	F_UMKZWI4	IS-M: LIS Billing ST4 Total	decimal	17	2	CURR	((0))	Yes		F_UMKZWI4
91	F_UMKZWI5	IS-M: LIS Billing ST5 Total	decimal	17	2	CURR	((0))	Yes		F_UMKZWI5
92	F_UMKZWI6	IS-M: LIS Billing ST6 Total	decimal	17	2	CURR	((0))	Yes		F_UMKZWI6
93	F_GUBRTWR	IS-M/AM: LIS Billing Gross Sales Vol.Total CM	decimal	19	2	CURR	((0))	Yes		F_GUBRTWR
94	F_GUNETWR	IS-M: LIS Billing Net SVol Total CM	decimal	19	2	CURR	((0))	Yes		F_GUNETWR
95	F_GUKZWI1	IS-M: LIS billing ST1 credit memo for all items	decimal	17	2	CURR	((0))	Yes		F_GUKZWI1
96	F_GUKZWI2	IS-M: LIS billing ST2 total credit memo	decimal	17	2	CURR	((0))	Yes		F_GUKZWI2
97	F_GUKZWI3	IS-M: LIS billing ST3 total credit memo	decimal	17	2	CURR	((0))	Yes		F_GUKZWI3
98	F_GUKZWI4	IS-M: LIS billing ST4 total credit memo	decimal	17	2	CURR	((0))	Yes		F_GUKZWI4
99	F_GUKZWI5	IS-M: LIS billing ST5 total credit memo	decimal	17	2	CURR	((0))	Yes		F_GUKZWI5
100	F_GUKZWI6	IS-M: LIS billing ST6 total credit memo	decimal	17	2	CURR	((0))	Yes		F_GUKZWI6
101	F_ANBRTWR	IS-M: LIS Billing Gross Sales Volume for Ad	decimal	19	2	CURR	((0))	Yes		F_ANBRTWR
102	F_ANNETWR	IS-M: LIS Billing Net Sales Volume for Ad	decimal	19	2	CURR	((0))	Yes		F_ANNETWR
103	F_ANKZWI1	IS-M: LIS Billing ST1 Ad	decimal	17	2	CURR	((0))	Yes		F_ANKZWI1
104	F_ANKZWI2	IS-M: LIS Billing ST2 Ad	decimal	17	2	CURR	((0))	Yes		F_ANKZWI2
105	F_ANKZWI3	IS-M: LIS Billing ST3 for Ad	decimal	17	2	CURR	((0))	Yes		F_ANKZWI3
106	F_ANKZWI4	IS-M/AM: LIS Billing ST4 for Ad	decimal	17	2	CURR	((0))	Yes		F_ANKZWI4
107	F_ANKZWI5	IS-M: LIS Billing ST5 for Ad	decimal	17	2	CURR	((0))	Yes		F_ANKZWI5
108	F_ANKZWI6	IS-M: LIS Billing ST6 for Ad	decimal	17	2	CURR	((0))	Yes		F_ANKZWI6
109	F_SIBRTWR	IS-M: LIS Billing Gross Sales Volume for Ad Inserts	decimal	19	2	CURR	((0))	Yes		F_SIBRTWR
110	F_SINETWR	IS-M: LIS Billing Net Sales Volume for Ad Insert	decimal	19	2	CURR	((0))	Yes		F_SINETWR
111	F_SIKZWI1	IS-M: LIS Billing ST1 for Ad Insert Item	decimal	17	2	CURR	((0))	Yes		F_SIKZWI1
112	F_SIKZWI2	IS-M: LIS Billing ST2 Ad Insert	decimal	17	2	CURR	((0))	Yes		F_SIKZWI2
113	F_SIKZWI3	IS-M: LIS Billing ST3 Ad Insert	decimal	17	2	CURR	((0))	Yes		F_SIKZWI3
114	F_SIKZWI4	IS-M: LIS Billing ST4 Ad Insert	decimal	17	2	CURR	((0))	Yes		F_SIKZWI4
115	F_SIKZWI5	IS-M: LIS Billing ST5 Ad Insert	decimal	17	2	CURR	((0))	Yes		F_SIKZWI5
116	F_SIKZWI6	IS-M: LIS Billing ST6 Ad Insert	decimal	17	2	CURR	((0))	Yes		F_SIKZWI6
117	F_DLBRTWR	IS-M: LIS Billing Gross Sales Volume SV	decimal	19	2	CURR	((0))	Yes		F_DLBRTWR
118	F_DLNETWR	IS-M: LIS Billing Net Sales Volume for Service	decimal	19	2	CURR	((0))	Yes		F_DLNETWR
119	F_DLKZWI1	IS-M: LIS Billing ST1 Service	decimal	17	2	CURR	((0))	Yes		F_DLKZWI1
120	F_DLKZWI2	IS-M: LIS Billing ST2 for Service	decimal	17	2	CURR	((0))	Yes		F_DLKZWI2
121	F_DLKZWI3	IS-M: LIS Billing ST3 Service	decimal	17	2	CURR	((0))	Yes		F_DLKZWI3
122	F_DLKZWI4	IS-M: LIS Billing ST4 Service	decimal	17	2	CURR	((0))	Yes		F_DLKZWI4
123	F_DLKZWI5	IS-M: LIS Billing ST5 Service	decimal	17	2	CURR	((0))	Yes		F_DLKZWI5
124	F_DLKZWI6	IS-M: LIS Billing ST6 Service	decimal	17	2	CURR	((0))	Yes		F_DLKZWI6
125	F_GUANBRTW	IS-M: LIS Billing Gross Sales Vol.Ad Credit Memo	decimal	19	2	CURR	((0))	Yes		F_GUANBR
126	F_GUANNETW	IS-M: LIS Billing Net SVol Ad Credit Memo	decimal	19	2	CURR	((0))	Yes		F_GUANNE
127	F_GUANKZW1	IS-M: LIS Billing ST1 for Credit Memo for Ad Item	decimal	17	2	CURR	((0))	Yes		F_GUANKZW1
128	F_GUANKZW2	IS-M: LIS Billing ST2 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUANKZW2
129	F_GUANKZW3	IS-M: Billing ST3 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUANKZW3
130	F_GUANKZW4	IS-M: LIS Billing ST4 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUANKZW4
131	F_GUANKZW5	IS-M: LIS Billing ST5 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUANKZW5
132	F_GUANKZW6	IS-M: LIS Billing ST6 Ad Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUANKZW6
133	F_GUSIBRTW	IS-M: LIS Billing Gross SVol Ad Insert Credit Memo	decimal	19	2	CURR	((0))	Yes		F_GUSIBR
134	F_GUSINETW	IS-M: LIS Billing Net Sales Vol.Ad Insert Credit Memo	decimal	19	2	CURR	((0))	Yes		F_GUSINE
135	F_GUSIKZW1	IS-M: LIS Billing ST1 Credit Memo for Ad Insert Item	decimal	17	2	CURR	((0))	Yes		F_GUSIKZW1
136	F_GUSIKZW2	IS-M: LIS Billing ST2 Ad Insert Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUSIKZW2
137	F_GUSIKZW3	IS-M: LIS Billing ST3 Ad Insert Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUSIKZW3
138	F_GUSIKZW4	IS-M: LIS Billing ST4 Ad Insert Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUSIKZW4
139	F_GUSIKZW5	IS-M: LIS Billing ST5 Ad Insert Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUSIKZW5
140	F_GUSIKZW6	IS-M: LIS Billing ST6 Ad Insert Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUSIKZW6
141	F_GUDLBRTW	IS-M: LIS Billing Gross Sales Vol.Service Credit Memo	decimal	19	2	CURR	((0))	Yes		F_GUDLBR
142	F_GUDLNETW	IS-M: LIS billing net SVol service credit memo	decimal	19	2	CURR	((0))	Yes		F_GUDLNE
143	F_GUDLKZW1	IS-M: LIS Billing ST1 Credit Memo for Service Item	decimal	17	2	CURR	((0))	Yes		F_GUDLKZW1
144	F_GUDLKZW2	IS-M: LIS Billing ST2 Service Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUDLKZW2
145	F_GUDLKZW3	IS-M: LIS Billing ST3 Service Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUDLKZW3
146	F_GUDLKZW4	IS-M: LIS Billing ST4 Service Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUDLKZW4
147	F_GUDLKZW5	IS-M: LIS Blling ST5 Service Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUDLKZW5
148	F_GUDLKZW6	IS-M: LIS Billing ST6 Service Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUDLKZW6
149	FMGGES	IS-M: LIS actual billing quantity total	decimal	15	3	QUAN	((0))	Yes		J_FMGGES
150	FMGGESGS	IS-M: LIS actual billing quantity total credit memo	decimal	15	3	QUAN	((0))	Yes		J_FMGGESGS
151	FMGAZ	IS-M: LIS Actual Billing Quantity for Ad	decimal	15	3	QUAN	((0))	Yes		J_FMGAZ
152	FMGSI	IS-M: LIS actual billing quantity for ad insert	decimal	15	3	QUAN	((0))	Yes		J_FMGSI
153	FMGDL	IS-M: LIS actual billing quantity service	decimal	15	3	QUAN	((0))	Yes		J_FMGDL
154	FMGAZGS	IS-M: LIS Actual Billing Quantity Ad Credit Memo	decimal	15	3	QUAN	((0))	Yes		J_FMGAZGS
155	FMGSIGS	IS-M: LIS actual billing quantity ad insert credit memo	decimal	15	3	QUAN	((0))	Yes		J_FMGSIGS
156	FMGDLGS	IS-M: LIS actual billing quantity service credit memo	decimal	15	3	QUAN	((0))	Yes		J_FMGDLGS
157	WSNETWR	IS-M/AM: LIS order net sales volume for commercial	decimal	19	2	CURR	((0))	Yes		J_WSNETWR
158	WSBRTWR	IS-M/AM: LIS order gross sales volumne for commercial	decimal	19	2	CURR	((0))	Yes		J_WSBRTWR
159	WSKZWI1	IS-M: LIS order ST1 Commercial	decimal	17	2	CURR	((0))	Yes		J_WSKZWI1
160	WSKZWI2	IS-M: LIS order ST2 Commercial	decimal	17	2	CURR	((0))	Yes		J_WSKZWI2
161	WSKZWI3	IS-M: LIS order ST3 Commercial	decimal	17	2	CURR	((0))	Yes		J_WSKZWI3
162	WSKZWI4	IS-M: LIS order ST4 Commercial	decimal	17	2	CURR	((0))	Yes		J_WSKZWI4
163	WSKZWI5	IS-M: LIS order ST5 Commercial	decimal	17	2	CURR	((0))	Yes		J_WSKZWI5
164	WSKZWI6	IS-M: LIS order ST6 Commercial	decimal	17	2	CURR	((0))	Yes		J_WSKZWI6
165	GUWSNETWR	IS-M: LIS order net sales volume commercial credit memo	decimal	19	2	CURR	((0))	Yes		JMC_GUWSNE
166	GUWSBRTWR	IS-M: LIS order gross sales volume commercial credit memo	decimal	19	2	CURR	((0))	Yes		JMC_GUWSBR
167	GUWSKZWI1	IS-M: LIS order ST1 commercial credit memo	decimal	17	2	CURR	((0))	Yes		J_GUWSKZW1
168	GUWSKZWI2	IS-M: LIS order ST2 commercial credit memo	decimal	17	2	CURR	((0))	Yes		J_GUWSKZW2
169	GUWSKZWI3	IS-M: LIS order ST3 commercial credit memo	decimal	17	2	CURR	((0))	Yes		J_GUWSKZW3
170	GUWSKZWI4	IS-M: LIS order ST4 commercial credit memo	decimal	17	2	CURR	((0))	Yes		J_GUWSKZW4
171	GUWSKZWI5	IS-M: LIS order ST5 commercial credit memo	decimal	17	2	CURR	((0))	Yes		J_GUWSKZW5
172	GUWSKZWI6	IS-M: LIS order ST6 commercial credit memo	decimal	17	2	CURR	((0))	Yes		J_GUWSKZW6
173	F_WSBRTWR	IS-M: LIS Billing Gross Sales Volume for Commercial	decimal	19	2	CURR	((0))	Yes		F_WSBRTWR
174	F_WSNETWR	IS-M: LIS Billing Net Sales Volume for Commercial	decimal	19	2	CURR	((0))	Yes		F_WSNETWR
175	F_WSKZWI1	IS-M: LIS Billing ST1 for Commercial Item	decimal	17	2	CURR	((0))	Yes		F_WSKZWI1
176	F_WSKZWI2	IS-M: LIS Billing ST2 Commercial	decimal	17	2	CURR	((0))	Yes		F_WSKZWI2
177	F_WSKZWI3	IS-M: LIS Billing ST3 Credit Memo	decimal	17	2	CURR	((0))	Yes		F_WSKZWI3
178	F_WSKZWI4	IS-M: LIS Billing ST4 Credit Memo	decimal	17	2	CURR	((0))	Yes		F_WSKZWI4
179	F_WSKZWI5	IS-M: LIS Billing ST5 Commercial	decimal	17	2	CURR	((0))	Yes		F_WSKZWI5
180	F_WSKZWI6	IS-M: LIS Billing ST6 Commercial	decimal	17	2	CURR	((0))	Yes		F_WSKZWI6
181	F_GUWSBRTW	IS-M: LIS Billing Gross Sales Volume Commercial Credit Memo	decimal	19	2	CURR	((0))	Yes		F_GUWSBR
182	F_GUWSNETW	IS-M: LIS Billing Net Sales Volume Commercial Credit Memo	decimal	19	2	CURR	((0))	Yes		F_GUWSNE
183	F_GUWSKZW1	IS-M: LIS Billing ST1 for Credit Memo for Commercial Item	decimal	17	2	CURR	((0))	Yes		F_GUWSKZW1
184	F_GUWSKZW2	IS-M: LIS Billing ST2 Commercial Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUWSKZW2
185	F_GUWSKZW3	IS-M: LIS Billing ST3 Commercial Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUWSKZW3
186	F_GUWSKZW4	IS-M: LIS Billing ST4 Commercial Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUWSKZW4
187	F_GUWSKZW5	IS-M: LIS Billing ST5 Commercial Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUWSKZW5
188	F_GUWSKZW6	IS-M: LIS Billing ST6 Cmmercial Credit Memo	decimal	17	2	CURR	((0))	Yes		F_GUWSKZW6
189	FMGWS	IS-M: LIS actual billing quantity for commercial	decimal	15	3	QUAN	((0))	Yes		J_FMGWS
190	FMGWSGS	IS-M: LIS actual bill.quantity commercial credit memo	decimal	15	3	QUAN	((0))	Yes		J_FMGWSGS

TOP ERP 6.0 | S481 INDEXES

Name	Primary	Unique	Type	Columns
S481~0	Yes	Yes	CLUSTERED	BELEGEINH, UR_BELEINH, VKBUR, SPART, VTWEG, VKORG, INSERENT, REGULIERER, GPAG, SPBUP, SPWOC, SPTAG, SPMON, VRSIO, SSOUR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

190 COLUMNS | 1 INDEXES | ERP 6.0 | S481 TABLE

TOP ERP 6.0 | S481 COLUMNS

TOP ERP 6.0 | S481 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

190 COLUMNS | 1 INDEXES | ERP 6.0 | S481 TABLE

TOPERP 6.0 | S481 COLUMNS

TOPERP 6.0 | S481 INDEXES

TOP ERP 6.0 | S481 COLUMNS

TOP ERP 6.0 | S481 INDEXES