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 
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

169 tablesERP 6.0 

Financial Accounting :: Travel Management :: Travel Expenses
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FITV_HINZ_WERB_B101Additional Amounts and Income-Related Expenses for ReceiptsTravel Expenses
2ERP EHP76.0FITV_HINZ_WERB_S101Additional Amounts and Income-Related ExpensesTravel Expenses
3ERP EHP76.0FTPT_REQ_CAT111Type of Transport/Accomm. and Est.Cost of Travel RequestTravel Expenses
4ERP EHP76.0PA0017511HR master record: Infotype 0017 (Travel Privileges)Travel Expenses
5ERP EHP76.0PTRV_ADMIN31Travel Management: Administrative Data for Personnel NumbersTravel Expenses
6ERP EHP76.0PTRV_ARCHIVE101Administrative Table for Archived Trip DataTravel Expenses
7ERP EHP76.0PTRV_ARCH_HEAD601Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary)Travel Expenses
8ERP EHP76.0PTRV_ARCH_PERIO681Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary)Travel Expenses
9ERP EHP76.0PTRV_BEIHILFE71Subsidies for Trips Home for Entire Separation AllowanceTravel Expenses
10ERP EHP76.0PTRV_BEIH_BEL71Assignment of Receipts to a Subsidy for Trips HomeTravel Expenses
11ERP EHP76.0PTRV_BEIH_TAG101Assignment of Days to a Subsidy for Trips HomeTravel Expenses
12ERP EHP76.0PTRV_BEIH_WEG71Assignment of Trip Segments to a Subsidy for Trips HomeTravel Expenses
13ERP EHP76.0PTRV_BTRGSUM51Table for Treatment for Amount AccumulationTravel Expenses
14ERP EHP76.0PTRV_CCC371Error Receipts for Credit Card ClearingTravel Expenses
15ERP EHP76.0PTRV_CCC_RUNS41Assign Personnel Number to Credit Card Clearing RunTravel Expenses
16ERP EHP76.0PTRV_CHANGE171Change to TripTravel Expenses
17ERP EHP76.0PTRV_COMM_AMT231Detail Data: Transfer to FM When Trip SavedTravel Expenses
18ERP EHP76.0PTRV_COMM_ITM311Header Data: Transfer to FM When Trip SavedTravel Expenses
19ERP EHP76.0PTRV_COMP381Comparison Calculation Results PSTravel Expenses
20ERP EHP76.0PTRV_COUNT171Number of function calls in posting run managementTravel Expenses
21ERP EHP76.0PTRV_DOC_HD182Transfer Travel -> FI/CO: Header of TRV int. documentTravel Expenses
22ERP EHP76.0PTRV_DOC_IT501Transfer Travel -> FI/CO: Lines of TRV interm. documentTravel Expenses
23ERP EHP76.0PTRV_DOC_MESS181Transfer Travel -> FI/CO: CO Replacements of TRV ReceiptTravel Expenses
24ERP EHP76.0PTRV_DOC_TAX201Transfer Travel -> FI/CO: Tax lines of TRV documentTravel Expenses
25ERP EHP76.0PTRV_F_CLM21Columns for Which Suppression in Form Block is AllowedTravel Expenses
26ERP EHP76.0PTRV_F_CLM_TXT41Columns that may be suppressed in form block (sp)Travel Expenses
27ERP EHP76.0PTRV_F_COLDEP11Display Forms for TextsTravel Expenses
28ERP EHP76.0PTRV_F_COLDEPS31Display Formats for Texts (Language-Dependent)Travel Expenses
29ERP EHP76.0PTRV_F_FBLK11Form Blocks of the Trip Costs FormTravel Expenses
30ERP EHP76.0PTRV_F_FBLK_TXT31Form Blocks of the Trip Costs FormTravel Expenses
31ERP EHP76.0PTRV_F_SORTKEY21Sort Key for Individual Receipt BlockTravel Expenses
32ERP EHP76.0PTRV_F_SORTKEY_T31Sort Key for Individual Receipt BlockTravel Expenses
33ERP EHP76.0PTRV_HEAD602General Trip DataTravel Expenses
34ERP EHP76.0PTRV_KMSUM91Table for Use of Miles/Kms AccumulationTravel Expenses
35ERP EHP76.0PTRV_ME_CCC_RUN41Assign Personnel Number to Credit Card Clearing RunTravel Expenses
36ERP EHP76.0PTRV_NOT_CH_TR381Storage of New Data from Temporarily Unchangable TripsTravel Expenses
37ERP EHP76.0PTRV_PERIO683Period Data of a TripTravel Expenses
38ERP EHP76.0PTRV_REASGN_FM251Conversion of FM Data in Trip (e.g. Fiscal Year Change)Travel Expenses
39ERP EHP76.0PTRV_RECDETAIL141Participant(s) in Entertainment ReceiptsTravel Expenses
40ERP EHP76.0PTRV_REDUCTION161Decision Fields: Change of Statutory Trip Type for ReductionTravel Expenses
41ERP EHP76.0PTRV_ROT_AWKEY153Assignment of Trip Results to Posting Doc. Number and LineTravel Expenses
42ERP EHP76.0PTRV_RPRPOSTD181Log of Posting Program RPRPOSTDTravel Expenses
43ERP EHP76.0PTRV_SADD441Trip Statistics - Add. Receipt DataTravel Expenses
44ERP EHP76.0PTRV_SBACKLOG61Trip Statistics - Batch/Backlog ProcessingTravel Expenses
45ERP EHP76.0PTRV_SCOM111Travel Statistic - Request/Plan/Settlement Cost ComparisonTravel Expenses
46ERP EHP76.0PTRV_SCOS324Trip Statistics - Cost AssignmentTravel Expenses
47ERP EHP76.0PTRV_SHDR241Trip Statistics - Trip AmountsTravel Expenses
48ERP EHP76.0PTRV_SREC323Trip Statistics - ReceiptsTravel Expenses
49ERP EHP76.0PTRV_T706Z_DNPR51Field Control ScreensTravel Expenses
50ERP EHP76.0PTRV_T706Z_DNPRT51Field Control ScreensTravel Expenses
51ERP EHP76.0PTRV_T706Z_FLDS111Field Names for Field ControlTravel Expenses
52ERP EHP76.0PTRV_TRIPCHN_46C411Table of all Trip Destinations f. Processing Recurring Dest.Travel Expenses
53ERP EHP76.0PTRV_TRIP_CHAIN411Table of all Trip Destinations f. Processing Recurring Dest.Travel Expenses
54ERP EHP76.0PTRV_TRIP_DELETE41Trips Deleted in SAP System for Offline Travel ManagerTravel Expenses
55ERP EHP76.0PTRV_USERPREFS291User Profiles in Travel ManagementTravel Expenses
56ERP EHP76.0PTRV_VATDETAIL142Supplier Data for VAT Refund in Travel ManagementTravel Expenses
57ERP EHP76.0PTRV_VERSION301History TableTravel Expenses
58ERP EHP76.0PTRV_WAFGUID41Logging for Synchronization GUID (DUPRECS)Travel Expenses
59ERP EHP76.0PTRV_WAF_CONFLCT31Offline Travel Management: Conflict ProcessingTravel Expenses
60ERP EHP76.0PTRV_WAF_RESTART51Restart File for Mobile Solution with Overlapping TripsTravel Expenses
61ERP EHP76.0T702A31Employee Grouping for Travel Expense TypeTravel Expenses
62ERP EHP76.0T702B171Credit Card Clearing Assignment TableTravel Expenses
63ERP EHP76.0T702C51Name for Employee Grouping for Travel Expense TypeTravel Expenses
64ERP EHP76.0T702E31Vehicle TypesTravel Expenses
65ERP EHP76.0T702G151Statutory trip typesTravel Expenses
66ERP EHP76.0T702H181Caculation Guide Lines: Meals PD/Max.Amounts Scaled by TimeTravel Expenses
67ERP EHP76.0T702I31Statutory Reimbursement Groups for Meals/AccommodationsTravel Expenses
68ERP EHP76.0T702J31Enterprise-spec.Reimbursement Groups for Meals/Accomm.Travel Expenses
69ERP EHP76.0T702K51Service providerTravel Expenses
70ERP EHP76.0T702L51Name of Service ProviderTravel Expenses
71ERP EHP76.0T702N1821Trip Provision VariantsTravel Expenses
72ERP EHP76.0T702O51Trip country/Trip region/Trip country groupTravel Expenses
73ERP EHP76.0T702P31Reimbursement Groups for Travel Costs/Add.Flat Rate TypesTravel Expenses
74ERP EHP76.0T702Q51Name: Reimburs.Group for Travel Costs/Add.Flat Rate TypesTravel Expenses
75ERP EHP76.0T702R31Trip Activity TypesTravel Expenses
76ERP EHP76.0T702V171Calc.Guide Lines for Scaling Meals PD/Max.Amounts by HoursTravel Expenses
77ERP EHP76.0T702W41Vehicle ClassesTravel Expenses
78ERP EHP76.0T702X41Enterprise-specific Trip TypesTravel Expenses
79ERP EHP76.0T702Y31Employee Groupings for Travel ManagementTravel Expenses
80ERP EHP76.0T702_ACCTTYPET41Description of American Express Account TypesTravel Expenses
81ERP EHP76.0T702_ACCT_TYPE31AMEX: Account TypesTravel Expenses
82ERP EHP76.0T702_BEREI_REL41Assignment of Trip Types Enterprise-Specific (PS AT)Travel Expenses
83ERP EHP76.0T702_BKZ61Country and Industry Specific Indicator (Public Sector)Travel Expenses
84ERP EHP76.0T702_SIC21List of MCC CodesTravel Expenses
85ERP EHP76.0T702_SIC_ATR71Assignment of MCC to Transaction Key of Credit Card CompanyTravel Expenses
86ERP EHP76.0T702_SIC_T41Description of Merchant Category CodeTravel Expenses
87ERP EHP76.0T702_VCF4_D61Assignment of Detail Info. to Trans. Keys of Card CompaniesTravel Expenses
88ERP EHP76.0T702_VCF4_ER21Enhanced Data Record TypesTravel Expenses
89ERP EHP76.0T706A161Trip Provision Deduction Amount/PercentageTravel Expenses
90ERP EHP76.0T706B371Travel Expense TypesTravel Expenses
91ERP EHP76.0T706B1601Travel Expense TypesTravel Expenses
92ERP EHP76.0T706B2211Travel Expense Types: Default Value/Maximum AmountsTravel Expenses
93ERP EHP76.0T706B3111Travel Expense Type GroupingTravel Expenses
94ERP EHP76.0T706B491Travel Expense Types: Assignment of Wage TypesTravel Expenses
95ERP EHP76.0T706B4_ALTERN111Travel Expense Type: Alternative Assignment of Wage TypesTravel Expenses
96ERP EHP76.0T706B551Names for Travel Expense TypesTravel Expenses
97ERP EHP76.0T706B641Default Values When Difference Values Are ExceededTravel Expenses
98ERP EHP76.0T706B6_T61Default Values When Difference Values Are ExceededTravel Expenses
99ERP EHP76.0T706C51Names for Travel Expense TypesTravel Expenses
100ERP EHP76.0T706D241Default Values for DialogTravel Expenses
101ERP EHP76.0T706E51Names for vehicle typesTravel Expenses
102ERP EHP76.0T706ESS151FI-TV: Customizing Table Intranet ScenarioTravel Expenses
103ERP EHP76.0T706ESS2111Travel Expenses Customizing for ESS ScenarioTravel Expenses
104ERP EHP76.0T706ESS351Mapping table for docu in Excel sheetTravel Expenses
105ERP EHP76.0T706F181Trip Provision: Flat Rates for Travel CostsTravel Expenses
106ERP EHP76.0T706F191Cumulation Procedure Dependent on Vehicle Type/ClassTravel Expenses
107ERP EHP76.0T706F271Amount Accumulation Depending on Vehicle Type/ClassTravel Expenses
108ERP EHP76.0T706FORM_BCKGRND101Form backgroundTravel Expenses
109ERP EHP76.0T706FORM_BLKATTR101Form block attributesTravel Expenses
110ERP EHP76.0T706FORM_BLKHDLS61Form block titlesTravel Expenses
111ERP EHP76.0T706FORM_BLK_HDL41Form block titlesTravel Expenses
112ERP EHP76.0T706FORM_CLMATTR61Suppressable columns per blockTravel Expenses
113ERP EHP76.0T706FORM_FIXTXT31Fixed textsTravel Expenses
114ERP EHP76.0T706FORM_FIXTXTS51Fixed texts (language-dependent)Travel Expenses
115ERP EHP76.0T706FORM_FLDS121Information in fixed positionsTravel Expenses
116ERP EHP76.0T706FORM_VAR41Form variantTravel Expenses
117ERP EHP76.0T706FORM_VARFLD11Variable fieldsTravel Expenses
118ERP EHP76.0T706FORM_VARFLDS31Variable fields (language-dependent)Travel Expenses
119ERP EHP76.0T706FORM_VAR_TXT51Form variant (language-dependent)Travel Expenses
120ERP EHP76.0T706G51Names for statutory trip typesTravel Expenses
121ERP EHP76.0T706H191Trip Provision:Per-diem/Maximum Amount for Meals by TimeTravel Expenses
122ERP EHP76.0T706I51Name for statutory reimbursement group for meals/accomm.Travel Expenses
123ERP EHP76.0T706J51Name for enterprise-specific reimburs.group for meals/acc.Travel Expenses
124ERP EHP76.0T706K161Initial Account Assignment for FITravel Expenses
125ERP EHP76.0T706L141Assignment of Trip Country - Country Group - RegionTravel Expenses
126ERP EHP76.0T706M91Input Tax for International Per DiemsTravel Expenses
127ERP EHP76.0T706N41Names for trip provision variantsTravel Expenses
128ERP EHP76.0T706O61Names for Trip Country/Trip Country Group/Trip RegionTravel Expenses
129ERP EHP76.0T706P71Date Interval for Miles/Kms AccumulationTravel Expenses
130ERP EHP76.0T706Q51Names for period indicator for miles/kms accumulationTravel Expenses
131ERP EHP76.0T706R51Names for trip activity typesTravel Expenses
132ERP EHP76.0T706S521Trip SchemaTravel Expenses
133ERP EHP76.0T706S_RECEIPT61Trip Schemas: Assignment of Travel Expense TypesTravel Expenses
134ERP EHP76.0T706T51Names for trip schemaTravel Expenses
135ERP EHP76.0T706T_ABWH61Texts for Absence Types (PS Separation Allowance)Travel Expenses
136ERP EHP76.0T706U161Trip Provision: Per Diem for AccommodationsTravel Expenses
137ERP EHP76.0T706V191Trip Provision: Meals Per-diem/Maximum Amount by HoursTravel Expenses
138ERP EHP76.0T706W51Names for vehicle classesTravel Expenses
139ERP EHP76.0T706WWW51HTML Links and File PathsTravel Expenses
140ERP EHP76.0T706WWW_TXT61Text Table HTML Links and File PathsTravel Expenses
141ERP EHP76.0T706X51Names for enterprise-specific trip typesTravel Expenses
142ERP EHP76.0T706Y51Names for Employee Groupings for Travel ManagementTravel Expenses
143ERP EHP76.0T706Z71Single Field Control for DialogTravel Expenses
144ERP EHP76.0T706Z1101Single Field Control for DialogTravel Expenses
145ERP EHP76.0T706Z1_TXT101Text table: Individual Field Control for DialogTravel Expenses
146ERP EHP76.0T706_ABWH51Absence Types from Place of Work (PS; Separation Allowance)Travel Expenses
147ERP EHP76.0T706_CCOMP31Credit Card CompaniesTravel Expenses
148ERP EHP76.0T706_CCOMP_TXT41Name of Credit Card CompanyTravel Expenses
149ERP EHP76.0T706_CITY_CD_46C61Table for Specifying the City Code/Community Code NumberTravel Expenses
150ERP EHP76.0T706_CITY_CD_D101Definition: City Codes / Community Code No., Date-DependentTravel Expenses
151ERP EHP76.0T706_CITY_CD_D_281Definition: City Codes / Community Code No., Date-DependentTravel Expenses
152ERP EHP76.0T706_CITY_CODE61Table for Specifying the City Code/Community Code NumberTravel Expenses
153ERP EHP76.0T706_CONST101PA parameters: Travel ManagementTravel Expenses
154ERP EHP76.0T706_CONSTTEXT51Names of Accounting Constants for Travel ExpensesTravel Expenses
155ERP EHP76.0T706_COST_CP141Cost Comparison on Trip Level: Maximum DifferenceTravel Expenses
156ERP EHP76.0T706_COST_CP_R31Cost Comparison at Trip Level: Default ValuesTravel Expenses
157ERP EHP76.0T706_COST_CP_R_T51Cost Comparison at Trip Level: Default ValuesTravel Expenses
158ERP EHP76.0T706_DEFAULTTEXT81Names of Reference Texts for Entering TripsTravel Expenses
159ERP EHP76.0T706_LGART41Wage Type Assignmt Table for Clearing Add.Amts/Inc.Rel Exp.Travel Expenses
160ERP EHP76.0T706_REQ_CAT111Types of Transport/Accomm. and Est.Cost of Travel RequestTravel Expenses
161ERP EHP76.0T706_REQ_CATTEXT51Name for Types of Transp/Accomm. and Est.Cost of Travel Req.Travel Expenses
162ERP EHP76.0T706_SRV_CODE61VAT Refund CodesTravel Expenses
163ERP EHP76.0T706_SRV_CODE_T71Country-Dependent Field Control for Receipt DataTravel Expenses
164ERP EHP76.0T706_SUB_SRV_C61Subcodes for Goods and ServicesTravel Expenses
165ERP EHP76.0T706_SUB_SRV_C_T81Subcodes for Goods and ServicesTravel Expenses
166ERP EHP76.0T706_TEXTNAMES41Names of Reference Texts for Entering TripsTravel Expenses
167ERP EHP76.0T706_VAT_DEFLT91Country- and Expense Type-Dependent Defaults f. Receipt DataTravel Expenses
168ERP EHP76.0T706_VAT_FLDS171Country-Dependent Field Control for Receipt DataTravel Expenses
169ERP EHP76.0T706_VAT_POSTING61Data Entry and Posting of VAT Amount per Country of ReceiptTravel Expenses

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