	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

173 COLUMNS | 1 INDEXES | ERP 6.0 | TVAK TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Sales and Distribution :: Sales :: Basic Functions
1	ERP EHP7	6.0	TVAK	173	1	Sales Document Types	Basic Functions

SQL: selectupdate insert create

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

SELECT MANDT, AUART, KOPGR, LFARV, FKARV, FKARA, NUMKI, NUMKE, INCPO, UEVOR, AUGRP, UMFNG, DABAR, PARGR, FAKSK, LIFSK, TRVOG, SPAPO, SPAPR, VSTRM, TRTRM, TXN08, DIAFE, FELDK, DATVO, AWAHR, VBTYP, VSBED, BEZOB, TXTGR, KALVG, ERNAM, FEHGR, INFLS, KUNN0, KLIMP, KALSM, KAPPL, KSCHL, SPERR, STGAK, KALSU, KALLI, KALAU, FKAIV, CMGRA, OBJART_HIN, OBJART_VER, HITYP_PR, ABRVW, ABDIS, KPRGBZ, PRDATV, VLAUF, GUEBGV, VTERL, HNWAG, HNWKM, STSMA, LISOF, AUARA, KORLI, VPROF, AUFAK, DIAPA, FPART, KSCHL_KO, EXCOK, EXMOD, KSKPF, KSPOS, LIFSM, FKTKT, EXDIA, ABGRU_IN, PRBST, SCHEME_GRP, HNWGK, PUSH_GRP, ABRUF_PART, RPART, AKTFI, VBKLT, J_1BNFTYPE, INCUP, BABSS, EMPFI, DELCF, CCPGR, EXCBC, EXCEM, EXCLG, HNWK2, EXTNR_RMA, TDID, AAUART1, AAUART2, RFPA_SW, VARIANT, ATPGM, VERLI, TENUR, J_1AFCTYPE, FAUPR, PVBSM, BPROC, ERMAT, BSTVO, EXTCONT, KSCHL_BUDGET, KSCHL_CAPS, MSR_ACTIVE, MSR_NEXT_NUMBER, MSR_AUARA, MSR_BILLING_BLK, MSR_CM_IMMEDIATE, MSR_LFART, FCS_ACTIVE, MSR_DELIVERY_BLK, MSR_SDF_AUART, RDP_PROFILE, FKART_MEV_POST, FKART_MEV_POST_IB, FSH_VASS_ACT, FSH_VASS_KALSM, FSH_VASS_DEL, FSH_VASS_DETDT, FSH_CQ_CHECK, VCLASSIFIC, KALPG, KALVL, /SAPMP/PDACT, /SAPMP/PPROT, /SAPMP/PUSER, /SAPMP/PAUSW, /SAPMP/GAUF, AD01AURET, AD04NUMFLG, KALGT, UNITSALE, CPFREE, NO_BUTTON, XZEROORDER, XASSORTMENT, ISM_CONTRACT, ISM_WERKSDET, J_3GKBAUL, MILL_SE_ATNAM, OIPIPEVAL, OIISOILPD, OICSEGI, OIMSG_PRD, OIMSG_SHP, OIMSG_QTY, OIMSG_TRM, OIMSG_DAT, OIMSG_UOM, OIPRTFNC, OIFCONTI, OICFKARTDI, OIPARVW1, OIPARVW2, OIPARVW3, OIPARVW4, OIPARVW5, OIPARVW6, OIPARVW7, OIPARVW8, OIPARVW9, OISUBHEAD, OISUBITEM, OIUSEREXIT, OIU_FKARA FROM TVAK

TOP ERP 6.0 | TVAK COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	AUART	Sales Document Type	nvarchar	4	CHAR	(N' ')	No		AUART	Allow NULL?
3	KOPGR	Screen sequence group for document header & item	nvarchar	4	CHAR	(N' ')	No	TVHB	BIFGR	Allow NULL?
4	LFARV	Default delivery type	nvarchar	4	CHAR	(N' ')	No	TVLK	LFARV	Allow NULL?
5	FKARV	Proposed billing type for a delivery-related billing doc.	nvarchar	4	CHAR	(N' ')	No	TVFK	FKARV	Allow NULL?
6	FKARA	Proposed billing type for an order-related billing document	nvarchar	4	CHAR	(N' ')	No	TVFK	FKARA	Allow NULL?
7	NUMKI	Number range in the case of internal number assignment	nvarchar	2	CHAR	(N' ')	No		NUMKI	Allow NULL?
8	NUMKE	Number range in the case of external number assignment	nvarchar	2	CHAR	(N' ')	No		NUMKE	Allow NULL?
9	INCPO	Increment of item number in the SD document	nvarchar	6	NUMC	(N'000000')	No		INCPO	Allow NULL?
10	UEVOR	F-code default for overview screen	nvarchar	20	CHAR	(N' ')	No		UEVOR_VA	Allow NULL?
11	AUGRP	Version Number Component	nvarchar	2	CHAR	(N' ')	No		CHAR2	Allow NULL?
12	UMFNG	Display Range	nvarchar	20	CHAR	(N' ')	No		UMFNG	Allow NULL?
13	DABAR	Default release type	char	1	CHAR	(N' ')	No		DABAR	Allow NULL?
14	PARGR	Partner Determination Procedure	nvarchar	4	CHAR	(N' ')	No	TVPG	PARGR	Allow NULL?
15	FAKSK	Block	nvarchar	2	CHAR	(N' ')	No	TVFS	FAKSP	Allow NULL?
16	LIFSK	Delivery block (document header)	nvarchar	2	CHAR	(N' ')	No	TVLS	LIFSK	Allow NULL?
17	TRVOG	Transaction group	char	1	CHAR	(N' ')	No		TRVOG_VA	Allow NULL?
18	SPAPO	Division in sales order item comes from the material	char	1	CHAR	(N' ')	No		SPAPO	Allow NULL?
19	SPAPR	Check division	char	1	CHAR	(N' ')	No		SPAPR	Allow NULL?
20	VSTRM	Activate delivery scheduling	char	1	CHAR	(N' ')	No		VSTRM	Allow NULL?
21	TRTRM	Activate transportation scheduling	char	1	CHAR	(N' ')	No		TRTRM	Allow NULL?
22	TXN08	Number of the standard text	nvarchar	8	CHAR	(N' ')	No		TXN08	Allow NULL?
23	DIAFE	Dialog message for incompletion	char	1	CHAR	(N' ')	No		DIAUV	Allow NULL?
24	FELDK	Field selection group for document header	nvarchar	4	CHAR	(N' ')	No	TVHF	FELDK	Allow NULL?
25	DATVO	Propose current date as requested delivery date	char	1	CHAR	(N' ')	No		DATVO_VAK	Allow NULL?
26	AWAHR	Sales probability	nvarchar	3	NUMC	(N'000')	No		AWAHR_AK	Allow NULL?
27	VBTYP	SD document category	char	1	CHAR	(N' ')	No		VBTYP	Allow NULL?
28	VSBED	Shipping conditions	nvarchar	2	CHAR	(N' ')	No	TVSB	VSBED_VAK	Allow NULL?
29	BEZOB	Reference mandatory	char	1	CHAR	(N' ')	No		BEZOB	Allow NULL?
30	TXTGR	Text determination procedure	nvarchar	2	CHAR	(N' ')	No	TTXG	TXTGR	Allow NULL?
31	KALVG	Document procedure (for determining pricing procedure)	char	1	CHAR	(N' ')	No	TVKV	KALVG	Allow NULL?
32	ERNAM	Name of Person who Created the Object	nvarchar	12	CHAR	(N' ')	No		ERNAM	Allow NULL?
33	FEHGR	Incompletion procedure for sales document	nvarchar	2	CHAR	(N' ')	No	TVUV	FEHGR	Allow NULL?
34	INFLS	Read customer-material info record ?	char	1	CHAR	(N' ')	No		INFLS	Allow NULL?
35	KUNN0	Customer number ZERO (0) allowed	char	1	CHAR	(N' ')	No		KUNN0	Allow NULL?
36	KLIMP	Check credit limit	char	1	CHAR	(N' ')	No		KLIMP	Allow NULL?
37	KALSM	Output determination procedure	nvarchar	6	CHAR	(N' ')	No	T683	KALSMB	Allow NULL?
38	KAPPL	Application for output conditions	nvarchar	2	CHAR	(N' ')	No	T681A	NA_KAPPL	Allow NULL?
39	KSCHL	Output Type	nvarchar	4	CHAR	(N' ')	No	*	NA_KSCHL	Allow NULL?
40	SPERR	Sales document block	char	1	CHAR	(N' ')	No		SPEVB	Allow NULL?
41	STGAK	Statistics group for sales document type	nvarchar	2	CHAR	(N' ')	No	TVSF	STGAK	Allow NULL?
42	KALSU	Procedure for material determination	nvarchar	6	CHAR	(N' ')	No	T683	KALSU	Allow NULL?
43	KALLI	Procedure for material listing	nvarchar	6	CHAR	(N' ')	No	T683	KALLI	Allow NULL?
44	KALAU	Procedure for material exclusion	nvarchar	6	CHAR	(N' ')	No	T683	KALAU	Allow NULL?
45	FKAIV	Billing type for intercompany billing	nvarchar	4	CHAR	(N' ')	No	TVFK	FKAIV	Allow NULL?
46	CMGRA	Credit group sales order	nvarchar	2	CHAR	(N' ')	No	T691D	CMGRA	Allow NULL?
47	OBJART_HIN	Archiving document type when you create a document	nvarchar	10	CHAR	(N' ')	No	TOADV	SDOBJARTH	Allow NULL?
48	OBJART_VER	Archiving document type used when you change a document	nvarchar	10	CHAR	(N' ')	No	TOADV	SDOBJARTV	Allow NULL?
49	HITYP_PR	Hierarchy type for pricing	char	1	CHAR	(N' ')	No	THIT	HITYP_PR	Allow NULL?
50	ABRVW	Usage Indicator	nvarchar	3	CHAR	(N' ')	No	TVLV	ABRVW	Allow NULL?
51	ABDIS	MRP for delivery schedule types	char	1	CHAR	(N' ')	No		ABDIS	Allow NULL?
52	KPRGBZ	Date type (day, week, month, interval)	char	1	CHAR	(N' ')	No		PRGRS	Allow NULL?
53	PRDATV	Proposed pricing date based on the requested dlv.date	char	1	CHAR	(N' ')	No		PRDATV	Allow NULL?
54	VLAUF	Lead Time in Days	decimal	2	DEC	((0))	No		VLAUF
55	GUEBGV	Proposed valid-from date	char	1	CHAR	(N' ')	No		GUEBGV	Allow NULL?
56	VTERL	Contract data allowed for sales order type	char	1	CHAR	(N' ')	No		VTERL	Allow NULL?
57	HNWAG	On/off switch for messages about quotations	char	1	CHAR	(N' ')	No		HNWAG	Allow NULL?
58	HNWKM	On/off switch for messages about outline agreements	char	1	CHAR	(N' ')	No		HNWKM	Allow NULL?
59	STSMA	Status Profile	nvarchar	8	CHAR	(N' ')	No	TJ20	J_STSMA	Allow NULL?
60	LISOF	Create delivery immediately	char	1	CHAR	(N' ')	No		LISOF	Allow NULL?
61	AUARA	Proposal for order type for the subsequent function	nvarchar	4	CHAR	(N' ')	No	TVAK	AUARA	Allow NULL?
62	KORLI	Delivery type for correction deliveries	nvarchar	4	CHAR	(N' ')	No	TVLK	KORLI	Allow NULL?
63	VPROF	Profile with default values for contract data	nvarchar	4	CHAR	(N' ')	No	TVVD	VPROF	Allow NULL?
64	AUFAK	Order type for request for billing	nvarchar	4	CHAR	(N' ')	No	TVAK	AUFAK	Allow NULL?
65	DIAPA	Dialog message for product attribute	char	1	CHAR	(N' ')	No		DIAPA	Allow NULL?
66	FPART	Billing/Invoicing Plan Type	nvarchar	2	CHAR	(N' ')	No	TFPLA	FPART	Allow NULL?
67	KSCHL_KO	Condition type for copying costs from line items	nvarchar	4	CHAR	(N' ')	No	T685	KSCHL_KO	Allow NULL?
68	EXCOK	Carry out legal control for sales document type	char	1	CHAR	(N' ')	No		EXCOK	Allow NULL?
69	EXMOD	Time interval for legal control	char	1	CHAR	(N' ')	No		EXMOD	Allow NULL?
70	KSKPF	Pricing procedure for contract conditions at header level	nvarchar	6	CHAR	(N' ')	No	T683	KSKPF	Allow NULL?
71	KSPOS	Pricing procedure for contract conditions at item level	nvarchar	6	CHAR	(N' ')	No	T683	KSPOS	Allow NULL?
72	LIFSM	Delivery block	nvarchar	2	CHAR	(N' ')	No	TVLS	LIFSM	Allow NULL?
73	FKTKT	Activity type for the actions procedure	nvarchar	4	CHAR	(N' ')	No	TVKK	FKTKT	Allow NULL?
74	EXDIA	Automatic dialog in document for legal control	char	1	CHAR	(N' ')	No		EXDIA	Allow NULL?
75	ABGRU_IN	Reason for rejection, internally assigned by system	nvarchar	2	CHAR	(N' ')	No	TVAG	ABGRU_IN	Allow NULL?
76	PRBST	Check purchase order number	char	1	CHAR	(N' ')	No		PRBST	Allow NULL?
77	SCHEME_GRP	Referencing requirement: Procedure	nvarchar	4	CHAR	(N' ')	Yes	TVGRPS	SCHEME_GRP	Allow NULL?
78	HNWGK	On/off switch for master contract messages	char	1	CHAR	(N' ')	Yes		HNWGK	Allow NULL?
79	PUSH_GRP	Update lower level contract - on/off	char	1	CHAR	(N' ')	Yes		PUSH_GRP	Allow NULL?
80	ABRUF_PART	Check partner authorizations	char	1	CHAR	(N' ')	Yes		ABRUF_PART	Allow NULL?
81	RPART	Payment card plan type	nvarchar	2	CHAR	(N' ')	Yes	TFPLA	RPART	Allow NULL?
82	AKTFI	Promo determination	char	1	CHAR	(N' ')	Yes		AKTFI	Allow NULL?
83	VBKLT	Sales document indicator (for display in TVAK only)	char	1	CHAR	(N' ')	Yes		VBKLT_VA	Allow NULL?
84	J_1BNFTYPE	Nota Fiscal Type	nvarchar	2	CHAR	(N' ')	Yes	J_1BAA	J_1BNFTYPE	Allow NULL?
85	INCUP	Increment of sub-item number in sales document	nvarchar	6	NUMC	(N'000000')	Yes		INCUP	Allow NULL?
86	BABSS	Document payment guarantee procedure	nvarchar	2	CHAR	(N' ')	Yes	T691R	BABSSCH_CM	Allow NULL?
87	EMPFI	Receiving point determination	char	1	CHAR	(N' ')	Yes		EMPFI	Allow NULL?
88	DELCF	Commitment dates switch for calculation rule	char	1	CHAR	(N' ')	Yes		DELCF	Allow NULL?
89	CCPGR	Payment cards: Checking group - Sales document	nvarchar	2	CHAR	(N' ')	Yes	TVCAA	CCPGA	Allow NULL?
90	EXCBC	Boycott list check of standard partners f.Foreign Trade - On	char	1	CHAR	(N' ')	Yes		EXCBC	Allow NULL?
91	EXCEM	Embargo check of standard partners for Foreign Trade - On	char	1	CHAR	(N' ')	Yes		EXCEM	Allow NULL?
92	EXCLG	Indicator: Save legal control log	char	1	CHAR	(N' ')	Yes		EXCLG	Allow NULL?
93	HNWK2	Add ref. to all contracts partner is authorized to release	char	1	CHAR	(N' ')	Yes		HNWK2	Allow NULL?
94	EXTNR_RMA	Use document number to enter external PO number	char	1	CHAR	(N' ')	Yes		RMA_EXTNR	Allow NULL?
95	TDID	Text ID	nvarchar	4	CHAR	(N' ')	Yes	*	TDID	Allow NULL?
96	AAUART1	Alternative sales document type	nvarchar	4	CHAR	(N' ')	Yes	*	AAUART	Allow NULL?
97	AAUART2	Alternative sales document type	nvarchar	4	CHAR	(N' ')	Yes	*	AAUART	Allow NULL?
98	RFPA_SW	Route schedule switch for order types	char	1	CHAR	(N' ')	Yes		RFPA_SW	Allow NULL?
99	VARIANT	Transaction variant	nvarchar	30	CHAR	(N' ')	Yes	SHDTVCIU	TCVARIANT	Allow NULL?
100	ATPGM	Type of group calls for the availability check	char	1	CHAR	(N' ')	Yes		ATPGM	Allow NULL?
101	VERLI	Procedure for material listing	char	1	CHAR	(N' ')	Yes		VERLI	Allow NULL?
102	TENUR	Carry out backwards delivery scheduling only	char	1	CHAR	(N' ')	Yes		TENUR	Allow NULL?
103	J_1AFCTYPE	Category of Credit Memo Billing Document	nvarchar	2	CHAR	(N' ')	Yes		J_1AFCTYP	Allow NULL?
104	FAUPR	Shipment Cost Information Profile	nvarchar	14	CHAR	(N' ')	Yes	TVFAP	FAUPR	Allow NULL?
105	PVBSM	Document procedure for determining product proposal proced.	nvarchar	2	CHAR	(N' ')	Yes	TPVV	PVBSM	Allow NULL?
106	BPROC	ATP: Business Transaction for ATP	nvarchar	4	CHAR	(N' ')	Yes	TVBPROC	BPROC	Allow NULL?
107	ERMAT	Material entry control	char	1	CHAR	(N' ')	Yes		ERMAT	Allow NULL?
108	BSTVO	Propose current date as purchase order date	char	1	CHAR	(N' ')	Yes		BSTVO	Allow NULL?
109	EXTCONT	Advanced Order Processing and Billing	char	1	CHAR	(N' ')	Yes		/CBAD/EXTCONT	Allow NULL?
110	KSCHL_BUDGET	Condition Budget	nvarchar	4	CHAR	(N' ')	Yes	*	/CBAD/KSCHL_BUDGET	Allow NULL?
111	KSCHL_CAPS	Condition Caps	nvarchar	4	CHAR	(N' ')	Yes	*	/CBAD/KSCHL_CAPS	Allow NULL?
112	MSR_ACTIVE	Advanced Returns Management Active	char	1	CHAR	(N' ')	Yes		MSR_ACTIVE	Allow NULL?
113	MSR_NEXT_NUMBER	Determination of Returns Order Number	char	1	CHAR	(N' ')	Yes		MSR_GET_NEXT_NUMBER	Allow NULL?
114	MSR_AUARA	Default Credit Memo Request Order Type	nvarchar	4	CHAR	(N' ')	Yes	TVAK	MSR_AUARA	Allow NULL?
115	MSR_BILLING_BLK	Billing Block	nvarchar	2	CHAR	(N' ')	Yes	TVFS	MSR_BILLING_BLOCK	Allow NULL?
116	MSR_CM_IMMEDIATE	Create Credit Memo Automatically	char	1	CHAR	(N' ')	Yes		MSR_CM_IMMEDIATELY	Allow NULL?
117	MSR_LFART	Default Delivery Type for Send Back to Customer	nvarchar	4	CHAR	(N' ')	Yes	TVLK	MSR_LFART	Allow NULL?
118	FCS_ACTIVE	Full Text Search for Sold-To Party Active	char	1	CHAR	(N' ')	Yes		FCS_ACTIVE	Allow NULL?
119	MSR_DELIVERY_BLK	Delivery Block	nvarchar	2	CHAR	(N' ')	Yes	TVLS	MSR_DELIVERY_BLOCK	Allow NULL?
120	MSR_SDF_AUART	Sales Document Type for Subsequent Delivery Free of Charge	nvarchar	4	CHAR	(N' ')	Yes	TVAK	MSR_REPLACEMENT_AUART	Allow NULL?
121	RDP_PROFILE	Risk Distribution Plan Profile	nvarchar	8	CHAR	(N' ')	Yes	L2TC_RDP_PROFILE	LOGTRM_RDP_PROFILE	Allow NULL?
122	FKART_MEV_POST	Billing Type for Period-End Posting	nvarchar	4	CHAR	(N' ')	Yes	TVFK	FKART_MEV_POST	Allow NULL?
123	FKART_MEV_POST_IB	Billing Type for Period-End Posting (ICB)	nvarchar	4	CHAR	(N' ')	Yes	TVFK	FKART_MEV_POST_IB	Allow NULL?
124	FSH_VASS_ACT	VAS Active Flag in SD	char	1	CHAR	(N' ')	Yes		FSH_VASS_ACT	Allow NULL?
125	FSH_VASS_KALSM	Determination Procedure in SD	nvarchar	6	CHAR	(N' ')	Yes		FSH_VASS_KALSM	Allow NULL?
126	FSH_VASS_DEL	Criteria for VAS Deletion during Determination in SD	char	1	CHAR	(N' ')	Yes		FSH_VASS_DEL	Allow NULL?
127	FSH_VASS_DETDT	Date for VAS Determination in SD	char	1	CHAR	(N' ')	Yes		FSH_VASS_DETDT	Allow NULL?
128	FSH_CQ_CHECK	Requirement Relevance for Contract	char	1	CHAR	(N' ')	Yes		FSH_CQ_CHECK	Allow NULL?
129	VCLASSIFIC	Contract classification SD customizing	char	1	CHAR	(N' ')	Yes		/SAPHT/SW_CONTRCLASS	Allow NULL?
130	KALPG	Product List eligibility: Procedure for product lists	nvarchar	6	CHAR	(N' ')	Yes	*	/SAPHT/SW_KALPG	Allow NULL?
131	KALVL	Procedure for material listing	nvarchar	6	CHAR	(N' ')	Yes	*	/SAPHT/SW_KALVL	Allow NULL?
132	/SAPMP/PDACT	Activate Inheritance	char	1	CHAR	(N' ')	Yes		/SAPMP/PDACT	Allow NULL?
133	/SAPMP/PPROT	Log of Characteristic Value Inheritance	char	1	CHAR	(N' ')	Yes		/SAPMP/PPROT	Allow NULL?
134	/SAPMP/PUSER	Inheritance: Overwrite User Values	char	1	CHAR	(N' ')	Yes		/SAPMP/PUSER	Allow NULL?
135	/SAPMP/PAUSW	Inheritance of Characteristics Selection List	char	1	CHAR	(N' ')	Yes		/SAPMP/PAUSW	Allow NULL?
136	/SAPMP/GAUF	Global/Local Group May Be Undone	char	1	CHAR	(N' ')	Yes		/SAPMP/GAUF	Allow NULL?
137	AD01AURET	Order type billing request for retroactive billing	nvarchar	4	CHAR	(N' ')	Yes	TVAK	AD01AURET	Allow NULL?
138	AD04NUMFLG	Document type relevant for numbering	char	1	CHAR	(N' ')	Yes		AD04NUMFLG	Allow NULL?
139	KALGT	Procedure for GTIN Mapping	nvarchar	6	CHAR	(N' ')	Yes	T683	KALGT	Allow NULL?
140	UNITSALE	Unit Sales	char	1	CHAR	(N' ')	Yes		HB_UNTSALE	Allow NULL?
141	CPFREE	Suppress Copy Control	char	1	CHAR	(N' ')	Yes		HB_CPFREE	Allow NULL?
142	NO_BUTTON	Number of Generate Button in Browser	char	1	NUMC	(N'0')	Yes		NO_BUTTON	Allow NULL?
143	XZEROORDER	IS-M: Generate Order with Quantity 0	char	1	CHAR	(N' ')	Yes		ISM_ZEROORDER	Allow NULL?
144	XASSORTMENT	IS-M: Allowed Contract Type for Assortments (Retail)	char	1	CHAR	(N' ')	Yes		XASSORTMENT	Allow NULL?
145	ISM_CONTRACT	IS-M: Contract Usage	nvarchar	2	CHAR	(N' ')	Yes		ISM_CONTRACT	Allow NULL?
146	ISM_WERKSDET	Plant Determination Type in Order	char	1	CHAR	(N' ')	Yes		ISM_WERKSDET	Allow NULL?
147	J_3GKBAUL	ETM-Relevant Indicator	char	1	CHAR	(N' ')	Yes		J_3GKBAUL	Allow NULL?
148	MILL_SE_ATNAM	Characteristic name	nvarchar	30	CHAR	(N' ')	Yes		MILL_SE_ATNAM1	Allow NULL?
149	OIPIPEVAL	Validation indicator for pipeline fields (X=ON, blank=OFF)	char	1	CHAR	(N' ')	Yes		OID_PIPEV	Allow NULL?
150	OIISOILPD	IS-Oil plant determination indicator: x=yes blank=no	char	1	CHAR	(N' ')	Yes		OID_BYPASS	Allow NULL?
151	OICSEGI	Quantity schedule creation permitted	char	1	CHAR	(N' ')	Yes		OIA_CSEGI	Allow NULL?
152	OIMSG_PRD	Message type for product with contract restrictions	char	1	CHAR	(N' ')	Yes		OIDMSG_PRD	Allow NULL?
153	OIMSG_SHP	Message type for contract restrictions ship-to party	char	1	CHAR	(N' ')	Yes		OIDMSG_SHP	Allow NULL?
154	OIMSG_QTY	Message type for contract restrictions quantity	char	1	CHAR	(N' ')	Yes		OIDMSG_QTY	Allow NULL?
155	OIMSG_TRM	Message type for contract restrictions payment terms	char	1	CHAR	(N' ')	Yes		OIDMSG_TRM	Allow NULL?
156	OIMSG_DAT	Message type for contract restrictions validity period	char	1	CHAR	(N' ')	Yes		OIDMSG_DAT	Allow NULL?
157	OIMSG_UOM	Message type for contract restrictions unit of measure	char	1	CHAR	(N' ')	Yes		OIDMSG_UOM	Allow NULL?
158	OIPRTFNC	Partner function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	OID_PTRFNC	Allow NULL?
159	OIFCONTI	IS-Oil MRN indicator for additional contract data	char	1	CHAR	(N' ')	Yes		OIF_CONTI	Allow NULL?
160	OICFKARTDI	Differential invoice billing type proposal	nvarchar	4	CHAR	(N' ')	Yes	TVFK	OICFKARTDI	Allow NULL?
161	OIPARVW1	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
162	OIPARVW2	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
163	OIPARVW3	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
164	OIPARVW4	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
165	OIPARVW5	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
166	OIPARVW6	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
167	OIPARVW7	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
168	OIPARVW8	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
169	OIPARVW9	Partner Function	nvarchar	2	CHAR	(N' ')	Yes	TPAR	PARVW	Allow NULL?
170	OISUBHEAD	Subscreen number (header)	nvarchar	4	CHAR	(N' ')	Yes		OID_SSCRHD	Allow NULL?
171	OISUBITEM	Subscreen number (item level)	nvarchar	4	CHAR	(N' ')	Yes		OID_SSCRIT	Allow NULL?
172	OIUSEREXIT	Number of the routine used for copying	nvarchar	3	NUMC	(N'000')	Yes	*	GRPNO	Allow NULL?
173	OIU_FKARA	PRA Order related billing type	nvarchar	4	CHAR	(N' ')	Yes	TVFK	OIU_FKARA	Allow NULL?

TOP ERP 6.0 | TVAK INDEXES

Name	Primary	Unique	Type	Columns
TVAK~0	Yes	Yes	CLUSTERED	MANDT, AUART

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

173 COLUMNS | 1 INDEXES | ERP 6.0 | TVAK TABLE

TOP ERP 6.0 | TVAK COLUMNS

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

173 COLUMNS | 1 INDEXES | ERP 6.0 | TVAK TABLE

TOPERP 6.0 | TVAK COLUMNS

TOPERP 6.0 | TVAK INDEXES

TOP ERP 6.0 | TVAK COLUMNS

TOP ERP 6.0 | TVAK INDEXES