	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

182 COLUMNS | 1 INDEXES | ERP 6.0 | T702N TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Travel Management :: Travel Expenses
1	ERP EHP7	6.0	T702N	182	1	Trip Provision Variants	Travel Expenses

SQL: selectupdate insert create

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

SELECT MANDT, MOREI, B01, B02, B03, B04, B05, B06, B07, B08, B09, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, B22, B23, B24, B25, B26, B27, B28, B29, B30, V01, V02, V03, V04, V05, V06, V07, V08, V09, V10, V11, V12, V13, V14, V15, V16, V17, V18, V19, V20, V21, V22, V23, V24, V25, V26, V27, V28, V29, V30, U01, U02, U03, U04, U05, U06, U07, U08, U09, U10, U11, U12, U13, U14, U15, U16, U17, U18, U19, U20, U21, U22, U23, U24, U25, U26, U27, U28, U29, U30, F01, F02, F03, F04, F05, F06, F07, F08, F09, F10, F11, F12, F13, F14, F15, F16, F17, F18, F19, F20, F21, F22, F23, F24, F25, F26, F27, F28, F29, F30, R01, R02, R03, R04, R05, R06, R07, R08, R09, R10, R11, R12, R13, R14, R15, R16, R17, R18, R19, R20, R21, R22, R23, R24, R25, R26, R27, R28, R29, R30, P01, P02, P03, P04, P05, P06, P07, P08, P09, P10, P11, P12, P13, P14, P15, P16, P17, P18, P19, P20, P21, P22, P23, P24, P25, P26, P27, P28, P29, P30 FROM T702N

TOP ERP 6.0 | T702N 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	MOREI	Trip Provision Variant	nvarchar	2	CHAR	(N' ')	No		MOREI	Allow NULL?
3	B01	Dialog control for receipt accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_01	Allow NULL?
4	B02	Date indicator of receipt accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_02	Allow NULL?
5	B03	Dom./International indic. for deducts in receipt acctg	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_03	Allow NULL?
6	B04	Statutory trip type for deductions in receipt accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_04	Allow NULL?
7	B05	Trip activity type for deducts in receipt accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_05	Allow NULL?
8	B06	Reimburs. group M/A statutory for deducts in receipt acctg	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_06	Allow NULL?
9	B07	Reimbursement group M/A enterpr. for deducts in receipt actg	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_07	Allow NULL?
10	B08	Deduction of unrecorded breakfasts in accommodations receipt	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_08	Allow NULL?
11	B09	Statutory trip type for receipt max. rates and def.values	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_09	Allow NULL?
12	B10	Trip type enterpr. for receipt max.rates and def.values	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_10	Allow NULL?
13	B11	Trip activity type for receipt max.rates and def.values	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_11	Allow NULL?
14	B12	Trip country/country grp for receipt max.rates and def.value	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_12	Allow NULL?
15	B13	Reimbursement group accommodations, meals - statutory	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_13	Allow NULL?
16	B14	Reimbursement group M/A enterprise specific	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_14	Allow NULL?
17	B15	Proposed Value for Exchange Rate for Receipts	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_15	Allow NULL?
18	B16	Receipt accounting item 16 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_16	Allow NULL?
19	B17	Receipt Itemization for Each Receipt Upon Transfer to FI	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_17	Allow NULL?
20	B18	Document for Estimated Costs Can Be Added After Trip End	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_18	Allow NULL?
21	B19	Receipt accounting item 19 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_19	Allow NULL?
22	B20	Receipt accounting item 20 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_20	Allow NULL?
23	B21	Receipt accounting item 21 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_21	Allow NULL?
24	B22	Receipt accounting item 22 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_22	Allow NULL?
25	B23	Receipt accounting item 23 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_23	Allow NULL?
26	B24	Receipt accounting item 24 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_24	Allow NULL?
27	B25	Receipt accounting item 25 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_25	Allow NULL?
28	B26	Receipt accounting item 26 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_26	Allow NULL?
29	B27	Receipt accounting item 27 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_27	Allow NULL?
30	B28	Receipt accounting item 28 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_28	Allow NULL?
31	B29	Receipt accounting item 29 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_29	Allow NULL?
32	B30	Receipt accounting item 30 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_B_30	Allow NULL?
33	V01	Individual Receipt (M Receipt) + Per Diem Settlement Dialog	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_01	Allow NULL?
34	V02	Date for reading meals per diems	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_02	Allow NULL?
35	V03	Domestic/Internat. indicator for deductions in meals accntng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_03	Allow NULL?
36	V04	Statutory trip type for deductions in meals accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_04	Allow NULL?
37	V05	Trip activity type for deductions in meals accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_05	Allow NULL?
38	V06	Reimbursement group M/A statutory for deducts in meals acctg	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_06	Allow NULL?
39	V07	Reimbursement group M/A enterpr. for deducts in meals acctg	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_07	Allow NULL?
40	V08	Statutory trip type for meals per diems accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_08	Allow NULL?
41	V09	Trip activity type for meals per diem accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_09	Allow NULL?
42	V10	Reimbursement group M/A statutory for meals per diems acctng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_10	Allow NULL?
43	V11	Reimbursement group M/A enterpr. for meals per diems acctng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_11	Allow NULL?
44	V12	Day Scaling for Reimbursement by Number of Trip Hours	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_12	Allow NULL?
45	V13	Compare additional amounts and income-rel.expenses	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_13	Allow NULL?
46	V14	Meals Receipt (M Receipt) + Per Diem Settlement in Dialog	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_14	Allow NULL?
47	V15	Minimum garantie for breakfast, French accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_15	Allow NULL?
48	V16	Reimbursement of differences for mixed accounting in Spain	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_16	Allow NULL?
49	V17	Subdivision of trip duration (domestic trips)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_17	Allow NULL?
50	V18	Valuation of trip duration (domestic trips)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_18	Allow NULL?
51	V19	Subdivision of trip duration (international trips)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_19	Allow NULL?
52	V20	Valuation of trip duration (international trips)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_20	Allow NULL?
53	V21	Special Deduction Calculation	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_21	Allow NULL?
54	V22	Reimbursement of Meals Per Diem on Days with Meals Receipts	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_22	Allow NULL?
55	V23	Calculation of Company-Specific Deduction	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_23	Allow NULL?
56	V24	Exact-to-the-Minute Reading	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_24	Allow NULL?
57	V25	Activate Pocket Money Settlement	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_25	Allow NULL?
58	V26	Deduction Calculation for Meal Calculation by Times	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_26	Allow NULL?
59	V27	Meals accounting item 27 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_27	Allow NULL?
60	V28	Meals accounting item 28 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_28	Allow NULL?
61	V29	Meals accounting item 299(reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_29	Allow NULL?
62	V30	Meals accounting item 30 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_V_30	Allow NULL?
63	U01	Individual Receipt + Per Diem Settlement in Dialog	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_01	Allow NULL?
64	U02	Date for reading accommodations per diems	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_02	Allow NULL?
65	U03	Domestic/Internat. indicator for deductions in accomm.acctng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_03	Allow NULL?
66	U04	Statutory trip type for deductions in accommodations acctng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_04	Allow NULL?
67	U05	Trip activity type for deductions in accommodations acctng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_05	Allow NULL?
68	U06	Reimbursement group M/A statutory for deducts in accom.acctg	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_06	Allow NULL?
69	U07	Reimburs.grp M/A enter.for deductions in accomm. accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_07	Allow NULL?
70	U08	Statutory trip type for accommodations per diem accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_08	Allow NULL?
71	U09	Trip activity type for accommodations per diem accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_09	Allow NULL?
72	U10	Reimbursement group M/A statutory for accomm.per diem acctng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_10	Allow NULL?
73	U11	Reimbursement group M/A enterpr. for accomm.per diem accntng	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_11	Allow NULL?
74	U12	Generate Accommod. Deductions Auto.via Acc. Rcpt for SAP-EP	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_12	Allow NULL?
75	U13	Accommodations accounting item 13 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_13	Allow NULL?
76	U14	Accommodations accounting item 14 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_14	Allow NULL?
77	U15	Per diem valuation of the recorded overnight stays	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_15	Allow NULL?
78	U16	Reimbursement of Differences for Mixed Accounting in Spain	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_16	Allow NULL?
79	U17	Accommodations accounting item 17 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_17	Allow NULL?
80	U18	Accommodations accounting item 18 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_18	Allow NULL?
81	U19	Accommodations accounting item 19 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_19	Allow NULL?
82	U20	Accommodations accounting item 20 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_20	Allow NULL?
83	U21	Accommodations accounting item 21 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_21	Allow NULL?
84	U22	Accommodations accounting item 22 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_22	Allow NULL?
85	U23	Accommodations accounting item 23 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_23	Allow NULL?
86	U24	Accommodations accounting item 24 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_24	Allow NULL?
87	U25	Accommodations accounting item 25 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_25	Allow NULL?
88	U26	Accommodations accounting item 26 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_26	Allow NULL?
89	U27	Accommodations accounting item 27 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_27	Allow NULL?
90	U28	Accommodations accounting, item 28 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_28	Allow NULL?
91	U29	Accommodations accounting, item 29 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_29	Allow NULL?
92	U30	Accommodations accounting, item 30 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_U_30	Allow NULL?
93	F01	Individual Receipt + Per Diem Settlement in Dialog	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_01	Allow NULL?
94	F02	Date for reading travel flat rates	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_02	Allow NULL?
95	F03	Miles/Km Cumulation	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_03	Allow NULL?
96	F04	Travel costs item 04 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_04	Allow NULL?
97	F05	Miles/Kms cumulation: exceeding of cumulation limit	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_05	Allow NULL?
98	F06	Consider main destination for reading travel flat rate	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_06	Allow NULL?
99	F07	Travel costs item 7 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_07	Allow NULL?
100	F08	Statutory trip type for travel costs reimbursement	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_08	Allow NULL?
101	F09	Trip activity type for travel costs reimbursement	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_09	Allow NULL?
102	F10	Travel costs item 10 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_10	Allow NULL?
103	F11	Trip area for travel costs reimbursement	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_11	Allow NULL?
104	F12	Specification of vehicle type for miles/kms cumulation	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_12	Allow NULL?
105	F13	Specification of vehicle class for miles/kms cumulation	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_13	Allow NULL?
106	F14	Specification of trip area for miles/kms cumulation	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_14	Allow NULL?
107	F15	Clear Additional Amounts and Income-Related Expenses	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_15	Allow NULL?
108	F16	Travel costs item 16 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_16	Allow NULL?
109	F17	Travel costs item 17 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_17	Allow NULL?
110	F18	Travel costs item 18 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_18	Allow NULL?
111	F19	Travel costs item 19 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_19	Allow NULL?
112	F20	Travel costs item 20 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_20	Allow NULL?
113	F21	Travel costs item 21 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_21	Allow NULL?
114	F22	Travel costs item 22 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_22	Allow NULL?
115	F23	Travel costs item 23 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_23	Allow NULL?
116	F24	Travel costs item 24 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_24	Allow NULL?
117	F25	Travel costs item 25 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_25	Allow NULL?
118	F26	Travel costs item 26 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_26	Allow NULL?
119	F27	Travel costs item 27 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_27	Allow NULL?
120	F28	Travel costs item 28 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_28	Allow NULL?
121	F29	Travel costs item 29 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_29	Allow NULL?
122	F30	Travel costs item 30 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_F_30	Allow NULL?
123	R01	Posting of receipts paid by company	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_01	Allow NULL?
124	R02	Posting of Advances	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_02	Allow NULL?
125	R03	Trip Country Groups for Per Diem/Flat Rate Settlement	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_03	Allow NULL?
126	R04	Date for reading master account assignment	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_04	Allow NULL?
127	R05	Currency translation for per diem/flat rate amounts	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_05	Allow NULL?
128	R06	Remaining accounting variants item 6 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_06	Allow NULL?
129	R07	Posting of Cash Advances	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_07	Allow NULL?
130	R08	Sign of advance for storage in ROT	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_08	Allow NULL?
131	R09	Sign of cash advance for storage in ROT	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_09	Allow NULL?
132	R10	Remaining accounting variants, position 10 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_10	Allow NULL?
133	R11	Validation: Multiple Trips on One Day	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_11	Allow NULL?
134	R12	Create statistics data for Travel Management	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_12	Allow NULL?
135	R13	Messages during master account assignment check	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_13	Allow NULL?
136	R14	Transaction TRIP: Edit request, plan and expense report	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_14	Allow NULL?
137	R15	Data Area Behavior, 1st Level in Travel Manager	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_15	Allow NULL?
138	R16	Time Sheet Integration (CATSXT)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_16	Allow NULL?
139	R17	Date for Determining Vendors when Transferring Data to FI	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_17	Allow NULL?
140	R18	Procedure for Trips to Same Destination	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_18	Allow NULL?
141	R19	Offline Travel Manager Active	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_19	Allow NULL?
142	R20	Transaction To Change Accounting From WF or PRAP	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_20	Allow NULL?
143	R21	Determine FI Clearing Date	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_21	Allow NULL?
144	R22	Integration: Travel Management - CATS Approval	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_22	Allow NULL?
145	R23	Posting of Receipts to be Reimbursed to Employee	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_23	Allow NULL?
146	R24	ADOBE Form Deactivation	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_24	Allow NULL?
147	R25	Default Value: Posting Date for Funds Management	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_25	Allow NULL?
148	R26	Version Creation	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_26	Allow NULL?
149	R27	Archiving	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_27	Allow NULL?
150	R28	Cost Comparison	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_28	Allow NULL?
151	R29	Selection of Travel Requests and Plans in Web Dynpro ABAP	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_29	Allow NULL?
152	R30	Remaining accounting variants item 30 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_R_30	Allow NULL?
153	P01	Industry sector ID	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_01	Allow NULL?
154	P02	Regional privision indicator	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_02	Allow NULL?
155	P03	Organizational provision indicator	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_03	Allow NULL?
156	P04	Comparison Calculation: Accom. Receipts With Accom. per Diem	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_04	Allow NULL?
157	P05	Comparison Calculation: Meals Receipts With Meals per Diem	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_05	Allow NULL?
158	P06	Separation Allowance Accounting	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_06	Allow NULL?
159	P07	Comparison Calculation Travel Costs and Trip Segments	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_07	Allow NULL?
160	P08	Public Sector item 8 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_08	Allow NULL?
161	P09	Clearing of Additional Amounts and Income-rel. Expenses	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_09	Allow NULL?
162	P10	Border crossing/return trip	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_10	Allow NULL?
163	P11	Border Crossing Trip Out	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_11	Allow NULL?
164	P12	Activate Travel Request Versions	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_12	Allow NULL?
165	P13	Include Deductions with Taxation of Meals per Diem	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_13	Allow NULL?
166	P14	Reduction of Meals per Diem with Subsidies for Trips Home	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_14	Allow NULL?
167	P15	Time-Based Reduction of Separation Allowance	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_15	Allow NULL?
168	P16	Inclusion of M Deductions with Separation Allowance per Diem	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_16	Allow NULL?
169	P17	Deduction Meals Per Diem w/ Full-Day Parallel Business Trips	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_17	Allow NULL?
170	P18	Deduction Meals Per Diem w/ Part-Day Parallel Business Trips	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_18	Allow NULL?
171	P19	Include Own Share with Daily Return	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_19	Allow NULL?
172	P20	Apply Separation Allowance Spouse with External Stay	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_20	Allow NULL?
173	P21	Trip to Start Work and Return from Work with Fictitious ES	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_21	Allow NULL?
174	P22	Comparison Calculation Between DR and ES	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_22	Allow NULL?
175	P23	Separation Allowance for Travel w/ Fictitious External Stay	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_23	Allow NULL?
176	P24	Public Sector item 24 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_24	Allow NULL?
177	P25	Public Sector item 25 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_25	Allow NULL?
178	P26	Public Sector item 26 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_26	Allow NULL?
179	P27	Public Sector item 27 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_27	Allow NULL?
180	P28	Public Sector item 28 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_28	Allow NULL?
181	P29	Public Sector item 29 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_29	Allow NULL?
182	P30	Public Sector item 30 (reserved)	char	1	CHAR	(N' ')	Yes		PTRV_TRVCT_P_30	Allow NULL?

TOP ERP 6.0 | T702N INDEXES

Name	Primary	Unique	Type	Columns
T702N~0	Yes	Yes	CLUSTERED	MOREI, 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

182 COLUMNS | 1 INDEXES | ERP 6.0 | T702N TABLE

TOP ERP 6.0 | T702N COLUMNS

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

182 COLUMNS | 1 INDEXES | ERP 6.0 | T702N TABLE

TOPERP 6.0 | T702N COLUMNS

TOPERP 6.0 | T702N INDEXES

TOP ERP 6.0 | T702N COLUMNS

TOP ERP 6.0 | T702N INDEXES