SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | T702N
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Financial Accounting :: Travel Management :: Travel Expenses
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T702N1821Trip Provision VariantsTravel 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
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2MOREITrip Provision Variantnvarchar20 Allow NULL? 
3B01Dialog control for receipt accountingchar10 Allow NULL? 
4B02Date indicator of receipt accountingchar10 Allow NULL? 
5B03Dom./International indic. for deducts in receipt acctgchar10 Allow NULL? 
6B04Statutory trip type for deductions in receipt accountingchar10 Allow NULL? 
7B05Trip activity type for deducts in receipt accountingchar10 Allow NULL? 
8B06Reimburs. group M/A statutory for deducts in receipt acctgchar10 Allow NULL? 
9B07Reimbursement group M/A enterpr. for deducts in receipt actgchar10 Allow NULL? 
10B08Deduction of unrecorded breakfasts in accommodations receiptchar10 Allow NULL? 
11B09Statutory trip type for receipt max. rates and def.valueschar10 Allow NULL? 
12B10Trip type enterpr. for receipt max.rates and def.valueschar10 Allow NULL? 
13B11Trip activity type for receipt max.rates and def.valueschar10 Allow NULL? 
14B12Trip country/country grp for receipt max.rates and def.valuechar10 Allow NULL? 
15B13Reimbursement group accommodations, meals - statutorychar10 Allow NULL? 
16B14Reimbursement group M/A enterprise specificchar10 Allow NULL? 
17B15Proposed Value for Exchange Rate for Receiptschar10 Allow NULL? 
18B16Receipt accounting item 16 (reserved)char10 Allow NULL? 
19B17Receipt Itemization for Each Receipt Upon Transfer to FIchar10 Allow NULL? 
20B18Document for Estimated Costs Can Be Added After Trip Endchar10 Allow NULL? 
21B19Receipt accounting item 19 (reserved)char10 Allow NULL? 
22B20Receipt accounting item 20 (reserved)char10 Allow NULL? 
23B21Receipt accounting item 21 (reserved)char10 Allow NULL? 
24B22Receipt accounting item 22 (reserved)char10 Allow NULL? 
25B23Receipt accounting item 23 (reserved)char10 Allow NULL? 
26B24Receipt accounting item 24 (reserved)char10 Allow NULL? 
27B25Receipt accounting item 25 (reserved)char10 Allow NULL? 
28B26Receipt accounting item 26 (reserved)char10 Allow NULL? 
29B27Receipt accounting item 27 (reserved)char10 Allow NULL? 
30B28Receipt accounting item 28 (reserved)char10 Allow NULL? 
31B29Receipt accounting item 29 (reserved)char10 Allow NULL? 
32B30Receipt accounting item 30 (reserved)char10 Allow NULL? 
33V01Individual Receipt (M Receipt) + Per Diem Settlement Dialogchar10 Allow NULL? 
34V02Date for reading meals per diemschar10 Allow NULL? 
35V03Domestic/Internat. indicator for deductions in meals accntngchar10 Allow NULL? 
36V04Statutory trip type for deductions in meals accountingchar10 Allow NULL? 
37V05Trip activity type for deductions in meals accountingchar10 Allow NULL? 
38V06Reimbursement group M/A statutory for deducts in meals acctgchar10 Allow NULL? 
39V07Reimbursement group M/A enterpr. for deducts in meals acctgchar10 Allow NULL? 
40V08Statutory trip type for meals per diems accountingchar10 Allow NULL? 
41V09Trip activity type for meals per diem accountingchar10 Allow NULL? 
42V10Reimbursement group M/A statutory for meals per diems acctngchar10 Allow NULL? 
43V11Reimbursement group M/A enterpr. for meals per diems acctngchar10 Allow NULL? 
44V12Day Scaling for Reimbursement by Number of Trip Hourschar10 Allow NULL? 
45V13Compare additional amounts and income-rel.expenseschar10 Allow NULL? 
46V14Meals Receipt (M Receipt) + Per Diem Settlement in Dialogchar10 Allow NULL? 
47V15Minimum garantie for breakfast, French accountingchar10 Allow NULL? 
48V16Reimbursement of differences for mixed accounting in Spainchar10 Allow NULL? 
49V17Subdivision of trip duration (domestic trips)char10 Allow NULL? 
50V18Valuation of trip duration (domestic trips)char10 Allow NULL? 
51V19Subdivision of trip duration (international trips)char10 Allow NULL? 
52V20Valuation of trip duration (international trips)char10 Allow NULL? 
53V21Special Deduction Calculationchar10 Allow NULL? 
54V22Reimbursement of Meals Per Diem on Days with Meals Receiptschar10 Allow NULL? 
55V23Calculation of Company-Specific Deductionchar10 Allow NULL? 
56V24Exact-to-the-Minute Readingchar10 Allow NULL? 
57V25Activate Pocket Money Settlementchar10 Allow NULL? 
58V26Deduction Calculation for Meal Calculation by Timeschar10 Allow NULL? 
59V27Meals accounting item 27 (reserved)char10 Allow NULL? 
60V28Meals accounting item 28 (reserved)char10 Allow NULL? 
61V29Meals accounting item 299(reserved)char10 Allow NULL? 
62V30Meals accounting item 30 (reserved)char10 Allow NULL? 
63U01Individual Receipt + Per Diem Settlement in Dialogchar10 Allow NULL? 
64U02Date for reading accommodations per diemschar10 Allow NULL? 
65U03Domestic/Internat. indicator for deductions in accomm.acctngchar10 Allow NULL? 
66U04Statutory trip type for deductions in accommodations acctngchar10 Allow NULL? 
67U05Trip activity type for deductions in accommodations acctngchar10 Allow NULL? 
68U06Reimbursement group M/A statutory for deducts in accom.acctgchar10 Allow NULL? 
69U07Reimburs.grp M/A enter.for deductions in accomm. accountingchar10 Allow NULL? 
70U08Statutory trip type for accommodations per diem accountingchar10 Allow NULL? 
71U09Trip activity type for accommodations per diem accountingchar10 Allow NULL? 
72U10Reimbursement group M/A statutory for accomm.per diem acctngchar10 Allow NULL? 
73U11Reimbursement group M/A enterpr. for accomm.per diem accntngchar10 Allow NULL? 
74U12Generate Accommod. Deductions Auto.via Acc. Rcpt for SAP-EPchar10 Allow NULL? 
75U13Accommodations accounting item 13 (reserved)char10 Allow NULL? 
76U14Accommodations accounting item 14 (reserved)char10 Allow NULL? 
77U15Per diem valuation of the recorded overnight stayschar10 Allow NULL? 
78U16Reimbursement of Differences for Mixed Accounting in Spainchar10 Allow NULL? 
79U17Accommodations accounting item 17 (reserved)char10 Allow NULL? 
80U18Accommodations accounting item 18 (reserved)char10 Allow NULL? 
81U19Accommodations accounting item 19 (reserved)char10 Allow NULL? 
82U20Accommodations accounting item 20 (reserved)char10 Allow NULL? 
83U21Accommodations accounting item 21 (reserved)char10 Allow NULL? 
84U22Accommodations accounting item 22 (reserved)char10 Allow NULL? 
85U23Accommodations accounting item 23 (reserved)char10 Allow NULL? 
86U24Accommodations accounting item 24 (reserved)char10 Allow NULL? 
87U25Accommodations accounting item 25 (reserved)char10 Allow NULL? 
88U26Accommodations accounting item 26 (reserved)char10 Allow NULL? 
89U27Accommodations accounting item 27 (reserved)char10 Allow NULL? 
90U28Accommodations accounting, item 28 (reserved)char10 Allow NULL? 
91U29Accommodations accounting, item 29 (reserved)char10 Allow NULL? 
92U30Accommodations accounting, item 30 (reserved)char10 Allow NULL? 
93F01Individual Receipt + Per Diem Settlement in Dialogchar10 Allow NULL? 
94F02Date for reading travel flat rateschar10 Allow NULL? 
95F03Miles/Km Cumulationchar10 Allow NULL? 
96F04Travel costs item 04 (reserved)char10 Allow NULL? 
97F05Miles/Kms cumulation: exceeding of cumulation limitchar10 Allow NULL? 
98F06Consider main destination for reading travel flat ratechar10 Allow NULL? 
99F07Travel costs item 7 (reserved)char10 Allow NULL? 
100F08Statutory trip type for travel costs reimbursementchar10 Allow NULL? 
101F09Trip activity type for travel costs reimbursementchar10 Allow NULL? 
102F10Travel costs item 10 (reserved)char10 Allow NULL? 
103F11Trip area for travel costs reimbursementchar10 Allow NULL? 
104F12Specification of vehicle type for miles/kms cumulationchar10 Allow NULL? 
105F13Specification of vehicle class for miles/kms cumulationchar10 Allow NULL? 
106F14Specification of trip area for miles/kms cumulationchar10 Allow NULL? 
107F15Clear Additional Amounts and Income-Related Expenseschar10 Allow NULL? 
108F16Travel costs item 16 (reserved)char10 Allow NULL? 
109F17Travel costs item 17 (reserved)char10 Allow NULL? 
110F18Travel costs item 18 (reserved)char10 Allow NULL? 
111F19Travel costs item 19 (reserved)char10 Allow NULL? 
112F20Travel costs item 20 (reserved)char10 Allow NULL? 
113F21Travel costs item 21 (reserved)char10 Allow NULL? 
114F22Travel costs item 22 (reserved)char10 Allow NULL? 
115F23Travel costs item 23 (reserved)char10 Allow NULL? 
116F24Travel costs item 24 (reserved)char10 Allow NULL? 
117F25Travel costs item 25 (reserved)char10 Allow NULL? 
118F26Travel costs item 26 (reserved)char10 Allow NULL? 
119F27Travel costs item 27 (reserved)char10 Allow NULL? 
120F28Travel costs item 28 (reserved)char10 Allow NULL? 
121F29Travel costs item 29 (reserved)char10 Allow NULL? 
122F30Travel costs item 30 (reserved)char10 Allow NULL? 
123R01Posting of receipts paid by companychar10 Allow NULL? 
124R02Posting of Advanceschar10 Allow NULL? 
125R03Trip Country Groups for Per Diem/Flat Rate Settlementchar10 Allow NULL? 
126R04Date for reading master account assignmentchar10 Allow NULL? 
127R05Currency translation for per diem/flat rate amountschar10 Allow NULL? 
128R06Remaining accounting variants item 6 (reserved)char10 Allow NULL? 
129R07Posting of Cash Advanceschar10 Allow NULL? 
130R08Sign of advance for storage in ROTchar10 Allow NULL? 
131R09Sign of cash advance for storage in ROTchar10 Allow NULL? 
132R10Remaining accounting variants, position 10 (reserved)char10 Allow NULL? 
133R11Validation: Multiple Trips on One Daychar10 Allow NULL? 
134R12Create statistics data for Travel Managementchar10 Allow NULL? 
135R13Messages during master account assignment checkchar10 Allow NULL? 
136R14Transaction TRIP: Edit request, plan and expense reportchar10 Allow NULL? 
137R15Data Area Behavior, 1st Level in Travel Managerchar10 Allow NULL? 
138R16Time Sheet Integration (CATSXT)char10 Allow NULL? 
139R17Date for Determining Vendors when Transferring Data to FIchar10 Allow NULL? 
140R18Procedure for Trips to Same Destinationchar10 Allow NULL? 
141R19Offline Travel Manager Activechar10 Allow NULL? 
142R20Transaction To Change Accounting From WF or PRAPchar10 Allow NULL? 
143R21Determine FI Clearing Datechar10 Allow NULL? 
144R22Integration: Travel Management - CATS Approvalchar10 Allow NULL? 
145R23Posting of Receipts to be Reimbursed to Employeechar10 Allow NULL? 
146R24ADOBE Form Deactivationchar10 Allow NULL? 
147R25Default Value: Posting Date for Funds Managementchar10 Allow NULL? 
148R26Version Creationchar10 Allow NULL? 
149R27Archivingchar10 Allow NULL? 
150R28Cost Comparisonchar10 Allow NULL? 
151R29Selection of Travel Requests and Plans in Web Dynpro ABAPchar10 Allow NULL? 
152R30Remaining accounting variants item 30 (reserved)char10 Allow NULL? 
153P01Industry sector IDchar10 Allow NULL? 
154P02Regional privision indicatorchar10 Allow NULL? 
155P03Organizational provision indicatorchar10 Allow NULL? 
156P04Comparison Calculation: Accom. Receipts With Accom. per Diemchar10 Allow NULL? 
157P05Comparison Calculation: Meals Receipts With Meals per Diemchar10 Allow NULL? 
158P06Separation Allowance Accountingchar10 Allow NULL? 
159P07Comparison Calculation Travel Costs and Trip Segmentschar10 Allow NULL? 
160P08Public Sector item 8 (reserved)char10 Allow NULL? 
161P09Clearing of Additional Amounts and Income-rel. Expenseschar10 Allow NULL? 
162P10Border crossing/return tripchar10 Allow NULL? 
163P11Border Crossing Trip Outchar10 Allow NULL? 
164P12Activate Travel Request Versionschar10 Allow NULL? 
165P13Include Deductions with Taxation of Meals per Diemchar10 Allow NULL? 
166P14Reduction of Meals per Diem with Subsidies for Trips Homechar10 Allow NULL? 
167P15Time-Based Reduction of Separation Allowancechar10 Allow NULL? 
168P16Inclusion of M Deductions with Separation Allowance per Diemchar10 Allow NULL? 
169P17Deduction Meals Per Diem w/ Full-Day Parallel Business Tripschar10 Allow NULL? 
170P18Deduction Meals Per Diem w/ Part-Day Parallel Business Tripschar10 Allow NULL? 
171P19Include Own Share with Daily Returnchar10 Allow NULL? 
172P20Apply Separation Allowance Spouse with External Staychar10 Allow NULL? 
173P21Trip to Start Work and Return from Work with Fictitious ESchar10 Allow NULL? 
174P22Comparison Calculation Between DR and ESchar10 Allow NULL? 
175P23Separation Allowance for Travel w/ Fictitious External Staychar10 Allow NULL? 
176P24Public Sector item 24 (reserved)char10 Allow NULL? 
177P25Public Sector item 25 (reserved)char10 Allow NULL? 
178P26Public Sector item 26 (reserved)char10 Allow NULL? 
179P27Public Sector item 27 (reserved)char10 Allow NULL? 
180P28Public Sector item 28 (reserved)char10 Allow NULL? 
181P29Public Sector item 29 (reserved)char10 Allow NULL? 
182P30Public Sector item 30 (reserved)char10 Allow NULL? 
NamePrimaryUniqueTypeColumns
T702N~0YesYesCLUSTEREDMOREI, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy