	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

157 COLUMNS | 5 INDEXES | ERP 6.0 | VVSCPOS TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: CollectionsDisbursements
1	ERP EHP7	6.0	VVSCPOS	157	5	Payment Plan Item	CollectionsDisbursements

SQL: selectupdate insert create

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

SELECT MANDT, GPART, VTREF, POSNR, SCPOSNR, BLTYP, STATPOST, ARCHI, XLOCK, PSNGL, PMTFR, PMTTO, RISKFR, RISKTO, PERFR, PMEND, PMEND_TIME, RENEW, RNEWX, RNEWD, RENEW_EXEC, CCODE, OPCCODE, GSBER, OPGSBER, PRGRP, SEGMENT, VSARL_VX, INSTAXS, TXPOS, AMOUNT_TOTAL, AMOUNT_INST, ATFRD, ATFRD_TIME, AMOUNT_DIFF, AMOUNT_TRANS, ENDTYPE, AMOUNT_NEED, AMOUNT_END, CHARGE_NEED, GLAET_AMT, CURR, PAYMENTFR, PAYMENTTO, CRDATE, CRTIME, CRUSER, CHDATE, CHTIME, CHUSER, POKEY, PKEY, PKEYFD, HVORG, TVORG, OPHVORG, OPTVORG, S_HKONT, H_HKONT, PAOBJNR, VBUND, KONTT, KONTL, BLART, VTRE2, VTRE3, XREVE, XDIST, BUGRD, PNTYP, XDERE, AMOUNT_DERE, VGPART2, VGPART3, GSFNR, BELNR, PEROFF, VALUT, PRCTR, KOSTL, AUFNR, LDGRP, PYGRP, PDTYP, GRKEY, XBEENDET, CFSET, CFPPC, CFAC, CFPE, FDDATE, FDDATE_FROM, FDDATE_TO, SCFDGRP, SCFDZTG, VOPBEL, MWSKZ, QSSKZ, STRKZ, OPKONTT, OPKONTL, STRNETTO, KTOSL, TXT, ORIGIN, MPPLAN, XEIBH_KO, XEIPH_OPK, HZUON, SGTXT, XEIPH_OP, FINRE, COINS_CODE, COINS_CAT, AWSYS, AWTYP, AWKEY, VERSION, EMGPA, EMBVT, EMADR, EMCCID, PYMET, PYBUK, FDGRP, FDZTG, FAEDS, SKTPZ, FAEDN, IKEY, BUDAT, STUDT, BLDAT, DUN_REASON, DUN_REASON_DAYS, PAY_REASON, PAY_REASON_DAYS, CLR_REASON, CLR_REASON_DAYS, INT_REASON, INT_REASON_DAYS, REFCLAIM, WWERT, MNDID, DUN_REASON_FDATE, DUN_REASON_TDATE, PAY_REASON_FDATE, PAY_REASON_TDATE, CLR_REASON_FDATE, CLR_REASON_TDATE, INT_REASON_FDATE, INT_REASON_TDATE, KSCHL, TAXAM, STPRZ, SBASW, XETAX FROM VVSCPOS

TOP ERP 6.0 | VVSCPOS 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	*	MANDT	Allow NULL?
2	GPART	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	No	*	GPART_KK	Allow NULL?
3	VTREF	Reference Specifications from Contract	nvarchar	20	0	CHAR	(N' ')	No		VTREF_KK	Allow NULL?
4	POSNR	Item ID	nvarchar	12	0	CHAR	(N' ')	No		SCCOUNT_SC	Allow NULL?
5	SCPOSNR	Time Stamp (Date and Time)	nvarchar	14	0	CHAR	(N' ')	No		TIMST_VK	Allow NULL?
6	BLTYP	Payment Plan Item Category	nvarchar	2	0	CHAR	(N' ')	Yes	*	BLTP1_SC	Allow NULL?
7	STATPOST	Post Payment Plan Item w/o Posting Stat.?	char	1	0	CHAR	(N' ')	Yes		STATPOST_SC	Allow NULL?
8	ARCHI	Payment item can be written to archive	char	1	0	CHAR	(N' ')	Yes		ARCHI_SC	Allow NULL?
9	XLOCK	Indicator: Item with Document Lock	char	1	0	CHAR	(N' ')	Yes		XLOCK_SC	Allow NULL?
10	PSNGL	Indicator: One-Time Payment	char	1	0	CHAR	(N' ')	Yes		PSNGL_SC	Allow NULL?
11	PMTFR	Valid-From Date for Payment Plan Item	nvarchar	8	0	DATS	(N'00000000')	Yes		PMFTR_SC	Allow NULL?
12	PMTTO	Valid-to date for payment plan items	nvarchar	8	0	DATS	(N'00000000')	Yes		PMTTO_SC	Allow NULL?
13	RISKFR	Valid-From Date for Payment Plan Item Risk	nvarchar	8	0	DATS	(N'00000000')	Yes		RISKFR_SC	Allow NULL?
14	RISKTO	Valid-To Date for Risk for Payment Plan Item	nvarchar	8	0	DATS	(N'00000000')	Yes		RISKTO_SC	Allow NULL?
15	PERFR	Start of Next Payment Period	nvarchar	8	0	DATS	(N'00000000')	Yes		PERFD_SC	Allow NULL?
16	PMEND	End early on	nvarchar	8	0	DATS	(N'00000000')	Yes		PMEND_SC	Allow NULL?
17	PMEND_TIME	Payment Plan Item: Event for Early Ending	nvarchar	6	0	TIMS	(N'000000')	Yes		PMEND_TIME_SC	Allow NULL?
18	RENEW	Indicator: Renew Item	char	1	0	CHAR	(N' ')	Yes		RENEW_SC	Allow NULL?
19	RNEWX	Number of Automatically Renewed Items	nvarchar	3	0	NUMC	(N'000')	Yes		RNEWX_SC	Allow NULL?
20	RNEWD	Number of current renewals	nvarchar	3	0	NUMC	(N'000')	Yes		RNEWD_SC	Allow NULL?
21	RENEW_EXEC	Payment Plan: Payment Plan Item Renewed	char	1	0	CHAR	(N' ')	Yes		RENEW_EXEC_SC	Allow NULL?
22	CCODE	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
23	OPCCODE	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
24	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
25	OPGSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
26	PRGRP	Product Group	nvarchar	2	0	CHAR	(N' ')	Yes	TKKVPRGRP	PRGRP_VK	Allow NULL?
27	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	SEGMT_KK	Allow NULL?
28	VSARL_VX	Insurance Type	nvarchar	6	0	CHAR	(N' ')	Yes	TLXXVAL	VSARL_VX	Allow NULL?
29	INSTAXS	Insurance Tax Schedule	nvarchar	4	0	CHAR	(N' ')	Yes	TKKV007A	INSTAXS_VK	Allow NULL?
30	TXPOS	Tax Referemce (Tax Reporting)	nvarchar	4	0	NUMC	(N'0000')	Yes		TXPOS_KK	Allow NULL?
31	AMOUNT_TOTAL	Amount in Transaction Currency with +/- Sign	decimal	13	2	CURR	((0))	Yes		BETRW_SC
32	AMOUNT_INST	Payment Plan Item: Installment for each Due Date	decimal	13	2	CURR	((0))	Yes		AMOUNT_INST_SC
33	ATFRD	Valid-From Date for Amount Changes	nvarchar	8	0	DATS	(N'00000000')	Yes		ATFRD_SC	Allow NULL?
34	ATFRD_TIME	Payment Plan Item: Event for Amount Change	nvarchar	6	0	TIMS	(N'000000')	Yes		ATFRD_TIME_SC	Allow NULL?
35	AMOUNT_DIFF	Amount in Transaction Currency with +/- Sign	decimal	13	2	CURR	((0))	Yes		BETRW_KK
36	AMOUNT_TRANS	Current distrib.amount of payment plan item	decimal	13	2	CURR	((0))	Yes		XBETRW_SC
37	ENDTYPE	Payment Plans: End Type for a Payment Plan Item	char	1	0	CHAR	(N' ')	Yes		ENDTYPE_SC	Allow NULL?
38	AMOUNT_NEED	Total amount when canceling payment plan early	decimal	13	2	CURR	((0))	Yes		AMNEED_SC
39	AMOUNT_END	Difference Amount for Ending Payment Plan Item	decimal	13	2	CURR	((0))	Yes		AMOUNT_END_SC
40	CHARGE_NEED	Charges Amount When Ending Payment Plan Item	decimal	13	2	CURR	((0))	Yes		CHNEED_SC
41	GLAET_AMT	Amount in Transaction Currency with +/- Sign	decimal	13	2	CURR	((0))	Yes		BETRW_SC
42	CURR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
43	PAYMENTFR	Lower Limit for Customer-Initiated Payment (in Percent)	nvarchar	3	0	NUMC	(N'000')	Yes		PAYMENTFR_SC	Allow NULL?
44	PAYMENTTO	Upper Limit for Customer-Initiated Payment (in Percent)	nvarchar	3	0	NUMC	(N'000')	Yes		PAYMENTTO_SC	Allow NULL?
45	CRDATE	Payment Plan Item Creation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		CRDATE_SC	Allow NULL?
46	CRTIME	Scheduling Item Created at	nvarchar	6	0	TIMS	(N'000000')	Yes		CRTIME_SC	Allow NULL?
47	CRUSER	Name of Person who Added Object	nvarchar	12	0	CHAR	(N' ')	Yes		CRUSER_SC	Allow NULL?
48	CHDATE	Date of Last Change of Scheduling Item	nvarchar	8	0	DATS	(N'00000000')	Yes		CHDATE_SC	Allow NULL?
49	CHTIME	Time of Last Change of Payment Plan Item	nvarchar	6	0	TIMS	(N'000000')	Yes		CHTIME_SC	Allow NULL?
50	CHUSER	Payment Plan Item Last Changed by	nvarchar	12	0	CHAR	(N' ')	Yes		CHUSER_SC	Allow NULL?
51	POKEY	Payment Option Key	nvarchar	2	0	CHAR	(N' ')	Yes	*	POKEY_VK	Allow NULL?
52	PKEY	Payment Plan Key	nvarchar	2	0	CHAR	(N' ')	Yes	*	PKEY_VK	Allow NULL?
53	PKEYFD	Valid-From Date for Payment Plan Key	nvarchar	8	0	DATS	(N'00000000')	Yes		PKEYFD_SC	Allow NULL?
54	HVORG	Main Transaction for Line Item	nvarchar	4	0	CHAR	(N' ')	Yes	TFKHVO	HVORG_KK	Allow NULL?
55	TVORG	Subtransaction for Document Item	nvarchar	4	0	CHAR	(N' ')	Yes	TFKTVO	TVORG_KK	Allow NULL?
56	OPHVORG	Main Transaction for Line Item	nvarchar	4	0	CHAR	(N' ')	Yes	TFKHVO	HVORG_KK	Allow NULL?
57	OPTVORG	Subtransaction for Document Item	nvarchar	4	0	CHAR	(N' ')	Yes	TFKTVO	TVORG_KK	Allow NULL?
58	S_HKONT	General ledger account	nvarchar	10	0	CHAR	(N' ')	Yes	*	HKONT_KK	Allow NULL?
59	H_HKONT	General ledger account	nvarchar	10	0	CHAR	(N' ')	Yes	*	HKONT_KK	Allow NULL?
60	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
61	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	*	RASSC	Allow NULL?
62	KONTT	Account Assignment Category	nvarchar	2	0	CHAR	(N' ')	Yes	*	KONTT_KK	Allow NULL?
63	KONTL	Acct assnmnt string for industry-specific account assngments	nvarchar	50	0	CHAR	(N' ')	Yes		KONTL_KK	Allow NULL?
64	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	TFK003	BLART_KK	Allow NULL?
65	VTRE2	Reference Specifications from Contract	nvarchar	20	0	CHAR	(N' ')	Yes		VTREF_KK	Allow NULL?
66	VTRE3	Reference Specifications from Contract	nvarchar	20	0	CHAR	(N' ')	Yes		VTREF_KK	Allow NULL?
67	XREVE	Document must be reversed	char	1	0	CHAR	(N' ')	Yes		XREVE_SC	Allow NULL?
68	XDIST	Indicator: Manual Distribution of Amount in Item	char	1	0	CHAR	(N' ')	Yes		XDIST_SC	Allow NULL?
69	BUGRD	Posting Reason	nvarchar	3	0	NUMC	(N'000')	Yes	*	BUGRD_VK	Allow NULL?
70	PNTYP	Item Category	nvarchar	2	0	CHAR	(N' ')	Yes	*	PNTYP_VK	Allow NULL?
71	XDERE	Indicator: Debt Recognition	char	1	0	CHAR	(N' ')	Yes		XDEREN_SC	Allow NULL?
72	AMOUNT_DERE	Amount in Transaction Currency with +/- Sign	decimal	13	2	CURR	((0))	Yes		BETRW_KK
73	VGPART2	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	GPART_KK	Allow NULL?
74	VGPART3	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	GPART_KK	Allow NULL?
75	GSFNR	Business Transaction Number	nvarchar	16	0	CHAR	(N' ')	Yes		GSFNR_VK	Allow NULL?
76	BELNR	Transfer Document Number	nvarchar	6	0	CHAR	(N' ')	Yes		BELNR_VK	Allow NULL?
77	PEROFF	Offset for Period Positioning	decimal	3	0	DEC	((0))	Yes		PEROFF_SC
78	VALUT	Value date	nvarchar	8	0	DATS	(N'00000000')	Yes		VALUT	Allow NULL?
79	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
80	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
81	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
82	LDGRP	Ledger Group	nvarchar	4	0	CHAR	(N' ')	Yes	FAGL_TLDGRP	LDGRP_KK	Allow NULL?
83	PYGRP	Grouping field for automatic payments	nvarchar	10	0	CHAR	(N' ')	Yes		PYGRP_KK	Allow NULL?
84	PDTYP	Category of Payment Specification	char	1	0	CHAR	(N' ')	Yes		PDTYP_KK	Allow NULL?
85	GRKEY	Grouping Key for Displaying Open Items	nvarchar	3	0	CHAR	(N' ')	Yes		GRKEY_KK	Allow NULL?
86	XBEENDET	Indicator: Scheduling Item Finished, Deletes Pmend Amt-Need	char	1	0	CHAR	(N' ')	Yes		XBEENDET_SC	Allow NULL?
87	CFSET	Indicator: Scheduling Item Processed in Cash Management	char	1	0	CHAR	(N' ')	Yes		CFSET_SC	Allow NULL?
88	CFPPC	Indicator: Payment Plan Change Processed in Cash Management	char	1	0	CHAR	(N' ')	Yes		CFPPC_SC	Allow NULL?
89	CFAC	Indicator: Amount Change Processed in Cash Management	char	1	0	CHAR	(N' ')	Yes		CFAC_SC	Allow NULL?
90	CFPE	Indicator: End Processed in Cash Management	char	1	0	CHAR	(N' ')	Yes		CFPE_SC	Allow NULL?
91	FDDATE	Date Used to Convert for Cash Management and Forecast	nvarchar	8	0	DATS	(N'00000000')	Yes		FDDATE_SC	Allow NULL?
92	FDDATE_FROM	Date from Which Cash Management Was Updated	nvarchar	8	0	DATS	(N'00000000')	Yes		FDDATE_FROM_SC	Allow NULL?
93	FDDATE_TO	Date up to Which Cash Management Was Updated	nvarchar	8	0	DATS	(N'00000000')	Yes		FDDATE_TO_SC	Allow NULL?
94	SCFDGRP	Planning Group	nvarchar	10	0	CHAR	(N' ')	Yes	*	FDGRP_KK	Allow NULL?
95	SCFDZTG	Additional Days for Cash Management	nvarchar	2	0	NUMC	(N'00')	Yes		FDZTG_KK	Allow NULL?
96	VOPBEL	Number of Contract Accts Rec. & Payable Doc.	nvarchar	12	0	CHAR	(N' ')	Yes	*	OPBEL_KK	Allow NULL?
97	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ	Allow NULL?
98	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	T059Q	QSSKZ	Allow NULL?
99	STRKZ	Tax Code for Other Taxes	nvarchar	2	0	CHAR	(N' ')	Yes	TFK007F	STRKZ_KK	Allow NULL?
100	OPKONTT	Account Assignment Category	nvarchar	2	0	CHAR	(N' ')	Yes	*	KONTT_KK	Allow NULL?
101	OPKONTL	Acct assnmnt string for industry-specific account assngments	nvarchar	50	0	CHAR	(N' ')	Yes		KONTL_KK	Allow NULL?
102	STRNETTO	Net Tax	char	1	0	CHAR	(N' ')	Yes		STRNETTO_SC	Allow NULL?
103	KTOSL	Transaction key for account determination	nvarchar	3	0	CHAR	(N' ')	Yes		KTOSL_KK	Allow NULL?
104	TXT	Item text	nvarchar	50	0	CHAR	(N' ')	Yes		OPTXT_KK	Allow NULL?
105	ORIGIN	Source of Data	nvarchar	30	0	CHAR	(N' ')	Yes		ORIGIN_DI	Allow NULL?
106	MPPLAN	Manual Payment Plan Linked with This Item	char	1	0	CHAR	(N' ')	Yes		MPPLAN_SC	Allow NULL?
107	XEIBH_KO	Create Separate Document in General Ledger	char	1	0	CHAR	(N' ')	Yes		XEIBH_KK	Allow NULL?
108	XEIPH_OPK	Create Line Item in General Ledger	char	1	0	CHAR	(N' ')	Yes		XEIPH_KK	Allow NULL?
109	HZUON	Assignment Number in G/L Document	nvarchar	18	0	CHAR	(N' ')	Yes		HZUON_KK	Allow NULL?
110	SGTXT	Item Text for G/L Document	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT_KK	Allow NULL?
111	XEIPH_OP	Create Line Item in General Ledger	char	1	0	CHAR	(N' ')	Yes		XEIPH_KK	Allow NULL?
112	FINRE	Contract Account of Final Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	*	FINRE_KK	Allow NULL?
113	COINS_CODE	Coinsurance Key	nvarchar	10	0	CHAR	(N' ')	Yes	*	COINS_REPID	Allow NULL?
114	COINS_CAT	Category for Coinsurance-Relevant Document	char	1	0	CHAR	(N' ')	Yes		COINS_DOC_TYPE_PRCL	Allow NULL?
115	AWSYS	Logical system of source document	nvarchar	10	0	CHAR	(N' ')	Yes	*	AWSYS	Allow NULL?
116	AWTYP	Reference Transaction	nvarchar	5	0	CHAR	(N' ')	Yes	*	AWTYP	Allow NULL?
117	AWKEY	Reference Key	nvarchar	20	0	CHAR	(N' ')	Yes		AWKEY	Allow NULL?
118	VERSION	Payment Plans: Version Number	nvarchar	4	0	CHAR	(N' ')	Yes		VERSION_SC	Allow NULL?
119	EMGPA	Alternative Business Partner for Payments	nvarchar	10	0	CHAR	(N' ')	Yes	BUT000	EMGPA_KK	Allow NULL?
120	EMBVT	Bank Details ID of Payee	nvarchar	4	0	CHAR	(N' ')	Yes		EMBVT_KK	Allow NULL?
121	EMADR	Address number	nvarchar	10	0	CHAR	(N' ')	Yes	*	AD_ADDRNUM	Allow NULL?
122	EMCCID	Payment Card ID for Payments	nvarchar	6	0	CHAR	(N' ')	Yes		CCID_KK	Allow NULL?
123	PYMET	Payment Method	char	1	0	CHAR	(N' ')	Yes	*	PYMET_KK	Allow NULL?
124	PYBUK	Company Code for Automatic Payment Transactions	nvarchar	4	0	CHAR	(N' ')	Yes	*	PYBUK_KK	Allow NULL?
125	FDGRP	Planning Group	nvarchar	10	0	CHAR	(N' ')	Yes	T035	FDGRP_KK	Allow NULL?
126	FDZTG	Additional Days for Cash Management	nvarchar	2	0	NUMC	(N'00')	Yes		FDZTG_KK	Allow NULL?
127	FAEDS	Due Date for Cash Discount	nvarchar	8	0	DATS	(N'00000000')	Yes		FAEDS_KK	Allow NULL?
128	SKTPZ	Cash discount rate	decimal	5	3	DEC	((0))	Yes		SKTPZ_KK
129	FAEDN	Due date for net payment	nvarchar	8	0	DATS	(N'00000000')	Yes		FAEDN_KK	Allow NULL?
130	IKEY	Interest Key	nvarchar	2	0	CHAR	(N' ')	Yes	TFK056A	IKEY_KK	Allow NULL?
131	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
132	STUDT	Deferral to	nvarchar	8	0	DATS	(N'00000000')	Yes		STUDT_KK	Allow NULL?
133	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
134	DUN_REASON	Dunning Lock Reason	char	1	0	CHAR	(N' ')	Yes	*	DUN_LOCKREASON_KK	Allow NULL?
135	DUN_REASON_DAYS	Number Of Days An Object Remains Locked	nvarchar	3	0	NUMC	(N'000')	Yes		LOCK_DAYS_KK	Allow NULL?
136	PAY_REASON	Lock Reason for Automatic Payment	char	1	0	CHAR	(N' ')	Yes	*	SPZAH_KK	Allow NULL?
137	PAY_REASON_DAYS	Number Of Days An Object Remains Locked	nvarchar	3	0	NUMC	(N'000')	Yes		LOCK_DAYS_KK	Allow NULL?
138	CLR_REASON	Clearing Lock Reason	char	1	0	CHAR	(N' ')	Yes	*	CLRLO_KK	Allow NULL?
139	CLR_REASON_DAYS	Number Of Days An Object Remains Locked	nvarchar	3	0	NUMC	(N'000')	Yes		LOCK_DAYS_KK	Allow NULL?
140	INT_REASON	Interest Lock Reason	char	1	0	CHAR	(N' ')	Yes	*	SPERZ_KK	Allow NULL?
141	INT_REASON_DAYS	Number Of Days An Object Remains Locked	nvarchar	3	0	NUMC	(N'000')	Yes		LOCK_DAYS_KK	Allow NULL?
142	REFCLAIM	Reference to Payment in Claims Management System	nvarchar	8	0	CHAR	(N' ')	Yes		REFCLAIM_VK	Allow NULL?
143	WWERT	Translation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WWERT_D	Allow NULL?
144	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	CHAR	(N' ')	Yes		SEPA_MNDID	Allow NULL?
145	DUN_REASON_FDATE	Valid-From Date of Dunning Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		DUN_REASON_FDATE_KK	Allow NULL?
146	DUN_REASON_TDATE	Valid-To Date of Dunning Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		DUN_REASON_TDATE_KK	Allow NULL?
147	PAY_REASON_FDATE	Valid-From Date of Payment Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		PAY_REASON_FDATE_KK	Allow NULL?
148	PAY_REASON_TDATE	Valid-To Date of Payment Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		PAY_REASON_TDATE_KK	Allow NULL?
149	CLR_REASON_FDATE	Valid-From Date of Clearing Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		CLR_REASON_FDATE_KK	Allow NULL?
150	CLR_REASON_TDATE	Valid-To Date of Clearing Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		CLR_REASON_TDATE_KK	Allow NULL?
151	INT_REASON_FDATE	Valid-From Date of Interest Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		INT_REASON_FDATE_KK	Allow NULL?
152	INT_REASON_TDATE	Valid-To Date of Interest Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		INT_REASON_TDATE_KK	Allow NULL?
153	KSCHL	Type of Tax Item for Other Tax Codes	nvarchar	4	0	CHAR	(N' ')	Yes		KSCHL_STRKZ_KK	Allow NULL?
154	TAXAM	Tax Amount in Transaction Currency with +/- Sign	decimal	13	2	CURR	((0))	Yes		TAXAM_SC
155	STPRZ	Tax Percentage	nvarchar	6	0	NUMC	(N'000000')	Yes		STPRZ_SC	Allow NULL?
156	SBASW	Amount Subject to Tax in Transaction Currency (Tax Base Amt)	decimal	13	2	CURR	((0))	Yes		SBASW_KK
157	XETAX	Indicator: Additional Entries Available in VVSCPOSETAX	char	1	0	CHAR	(N' ')	Yes		XETAX_SC	Allow NULL?

TOP ERP 6.0 | VVSCPOS INDEXES

Name	Primary	Unique	Type	Columns
VVSCPOS~0	Yes	Yes	CLUSTERED	MANDT, GPART, VTREF, POSNR, SCPOSNR
VVSCPOS~1	No	No	NONCLUSTERED	GSFNR
VVSCPOS~3	No	No	NONCLUSTERED	MANDT, GPART, ARCHI, XREVE, XLOCK
VVSCPOS~4	No	No	NONCLUSTERED	MANDT, ARCHI, GPART
VVSCPOS~6	No	No	NONCLUSTERED	MANDT, ARCHI, VTREF

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

157 COLUMNS | 5 INDEXES | ERP 6.0 | VVSCPOS TABLE

TOP ERP 6.0 | VVSCPOS COLUMNS

TOP ERP 6.0 | VVSCPOS 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

157 COLUMNS | 5 INDEXES | ERP 6.0 | VVSCPOS TABLE

TOPERP 6.0 | VVSCPOS COLUMNS

TOPERP 6.0 | VVSCPOS INDEXES

TOP ERP 6.0 | VVSCPOS COLUMNS

TOP ERP 6.0 | VVSCPOS INDEXES