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
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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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

235 tablesERP 6.0 

Financial Accounting :: Asset Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0AAACC_EXCL21Exception Table for Account Assignment Settings in FI-AAAsset Accounting
2ERP EHP76.0AAACC_OBJ71Account Assignment Settings in Asset AccountingAsset Accounting
3ERP EHP76.0AAACC_OBJ_ERR31Types of Error During Check of Acct Assignment in FI-AAAsset Accounting
4ERP EHP76.0APERB_ITEMS101Log Table for Dep. Areas Posted Directly to FIAsset Accounting
5ERP EHP76.0APERB_PROT131Log Table for Periodic PostingAsset Accounting
6ERP EHP76.0BWFIAA_AEDAT_AB71FIAA-BW: Modified Valuation Area Data for Delta UploadAsset Accounting
7ERP EHP76.0BWFIAA_AEDAT_AS61FIAA-BW: New and Modified Master Records for Delta UploadAsset Accounting
8ERP EHP76.0BWFIAA_AEDAT_TR91FIAA-BW: New and Modified Transactions for Delta UploadAsset Accounting
9ERP EHP76.0FAA_TENV_PATHMGT51ObsoleteAsset Accounting
10ERP EHP76.0FAA_TENV_TCMGT171Management Table for Test CasesAsset Accounting
11ERP EHP76.0IDCN_GA_ANLKL21GA China: Specify Asset ClassesAsset Accounting
12ERP EHP76.0IDCN_GA_ANLN81GA China: Asset depreciation ratio and costcenterAsset Accounting
13ERP EHP76.0IDCN_GA_BWASL31Asset Transaction Types (Golden Audit)Asset Accounting
14ERP EHP76.0IDCN_GA_DEP51Parameters for Asset Depreciation (Golden Audit)Asset Accounting
15ERP EHP76.0IDCN_GA_ORDNR51Asset Evaluation Group (Golden Audit)Asset Accounting
16ERP EHP76.0IDFIAA_UK_SORP31Activate SORP/MCHA FunctionsAsset Accounting
17ERP EHP76.0IDPT_A01151Revaluation Areas for Asset ReportsAsset Accounting
18ERP EHP76.0IDPT_A02181Revaluation Classes/ExceptionsAsset Accounting
19ERP EHP76.0IDPT_A031111Manual Entries for Form 32.1Asset Accounting
20ERP EHP76.0IDPT_A04161Currency Revaluation CoefficientsAsset Accounting
21ERP EHP76.0IDPT_A05151Transaction Types for Asset RetirementsAsset Accounting
22ERP EHP76.0IDPT_A06171Depreciation ForegoneAsset Accounting
23ERP EHP76.0IDPT_A07161Limit for assets which use Electric/ non-electric energyAsset Accounting
24ERP EHP76.0IDPT_A0921Checks for Asset Reports - Reference TableAsset Accounting
25ERP EHP76.0IDPT_A099101Checks for Asset ReportsAsset Accounting
26ERP EHP76.0J_1GAM2GR61Rule Table for Fixed Asset RevaluationAsset Accounting
27ERP EHP76.0J_1GAMAFA41Tax free reductionsAsset Accounting
28ERP EHP76.0J_1GAMASN51Asset Super Number Objective ValuesAsset Accounting
29ERP EHP76.0J_1GAMREG101Asset Register: FieldsAsset Accounting
30ERP EHP76.0J_1GAMREP41Asset Register: Page sizeAsset Accounting
31ERP EHP76.0T093_ACCOBJ51Account Assignment Objects in Asset AccountingAsset Accounting
32ERP EHP76.0T093_ACCOBJT41Texts for Account Assignment Objects in Asset AccountingAsset Accounting
33ERP EHP76.0T093_MAP_ACC91Mapping Table for Alternative Company CodesAsset Accounting
34ERP EHP76.0T095A_MAP31Customizing Table for Account Maintenance (Instead of T095)Asset Accounting
Financial Accounting :: Asset Accounting :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
35ERP EHP76.0ANAR101Asset TypesBasic Functions
36ERP EHP76.0ANAT51Asset type textBasic Functions
37ERP EHP76.0ANEA271Asset Line Items for Proportional ValuesBasic Functions
38ERP EHP76.0ANEK512Document Header Asset PostingBasic Functions
39ERP EHP76.0ANEP241Asset Line ItemsBasic Functions
40ERP EHP76.0ANEV83Asset downpymt settlementBasic Functions
41ERP EHP76.0ANGA221Asset catalog general dataBasic Functions
42ERP EHP76.0ANGB161Asset catalog deprec. areaBasic Functions
43ERP EHP76.0ANGT61Asset catalog text tableBasic Functions
44ERP EHP76.0ANKA581Asset classes: general dataBasic Functions
45ERP EHP76.0ANKAZ171Asset class: extension for technical fieldsBasic Functions
46ERP EHP76.0ANKB331Asset class: depreciation areaBasic Functions
47ERP EHP76.0ANKL431Generation table for generating asset classes from accountsBasic Functions
48ERP EHP76.0ANKLAY41Asset class: Assignment of tab layoutsBasic Functions
49ERP EHP76.0ANKLAYP51Asset class: Assignment of tab layoutsBasic Functions
50ERP EHP76.0ANKP191Asset classes: Fld Cont Dpndnt on Chart of DepreciationBasic Functions
51ERP EHP76.0ANKT81Asset classes: DescriptionBasic Functions
52ERP EHP76.0ANKV101Asset classes: insurance typesBasic Functions
53ERP EHP76.0ANLA1418Asset Master Record SegmentBasic Functions
54ERP EHP76.0ANLB493Depreciation termsBasic Functions
55ERP EHP76.0ANLBZA133Time-Dependent Depreciation TermsBasic Functions
56ERP EHP76.0ANLBZW71Asset-specific base valuesBasic Functions
57ERP EHP76.0ANLC771Asset Value FieldsBasic Functions
58ERP EHP76.0ANLH81Main asset numberBasic Functions
59ERP EHP76.0ANLP562Asset Periodic ValuesBasic Functions
60ERP EHP76.0ANLQ352Period values from dep. posting run per posting levelBasic Functions
61ERP EHP76.0ANLT152Asset TextsBasic Functions
62ERP EHP76.0ANLU41Asset Master Record: User FieldsBasic Functions
63ERP EHP76.0ANLV221Insurance dataBasic Functions
64ERP EHP76.0ANLW101Insurable values (year dependent)Basic Functions
65ERP EHP76.0ANLX251Asset Master Record SegmentBasic Functions
66ERP EHP76.0ANLZ413Time-Dependent Asset AllocationsBasic Functions
67ERP EHP76.0FAAASSETID52Assignment Table - Asset Key to Asset GUIDBasic Functions
68ERP EHP76.0SMFIAA101Spec. FI-AA Data in Monitor (see Schedman_specific_fiaa)Basic Functions
69ERP EHP76.0T080A61Structure definition work list suffixBasic Functions
70ERP EHP76.0T082111Field group authorization assetsBasic Functions
71ERP EHP76.0T082AVIEW021Entity Table for Asset ViewsBasic Functions
72ERP EHP76.0T082AVIEW0T41Text Tables for Asset ViewsBasic Functions
73ERP EHP76.0T082AVIEW141View Authorization for Asset Master Data FieldsBasic Functions
74ERP EHP76.0T082AVIEW241View Authorization for Asset Depreciation Area FieldsBasic Functions
75ERP EHP76.0T082AVIEWB51View Authorization for Depreciation AreasBasic Functions
76ERP EHP76.0T082AVIEWTRANSG31Assignment of Transaction Group to Asset ViewBasic Functions
77ERP EHP76.0T082B31Field groups assets definitionBasic Functions
78ERP EHP76.0T082F41Field groups asset dataBasic Functions
79ERP EHP76.0T082G131Field strings for screen selection asset master data.Basic Functions
80ERP EHP76.0T082H51Field string name: Asset master data maintenanceBasic Functions
81ERP EHP76.0T082I41Create takeover rules from transfer for master dataBasic Functions
82ERP EHP76.0T082J51Create takeover rules from transfer for master data: areasBasic Functions
83ERP EHP76.0T082L31Summary of logical field groupsBasic Functions
84ERP EHP76.0T082M41Description for logical field groupsBasic Functions
85ERP EHP76.0T082T41Names For Field GroupsBasic Functions
86ERP EHP76.0T084141Incorrect assetsBasic Functions
87ERP EHP76.0T085201Investment support measuresBasic Functions
88ERP EHP76.0T085P91Investment support: Default and check tableBasic Functions
89ERP EHP76.0T085S51Description of individual investment support measuresBasic Functions
90ERP EHP76.0T085Z71Capital investment grants with time-dependent percentagesBasic Functions
91ERP EHP76.0T086411Sort version ReportingBasic Functions
92ERP EHP76.0T08731Evaluation groupsBasic Functions
93ERP EHP76.0T087G21Evaluation group 8 placesBasic Functions
94ERP EHP76.0T087K21Reason for investment protecting the environmentBasic Functions
95ERP EHP76.0T087L41Text table for reasons for environmental investmentsBasic Functions
96ERP EHP76.0T087S41Test table for evaluation group 8 placesBasic Functions
97ERP EHP76.0T087T51Description of Evaluation GroupsBasic Functions
98ERP EHP76.0T087U21Asset group number / asset groupBasic Functions
99ERP EHP76.0T087V41Text table asset group number / asset groupBasic Functions
100ERP EHP76.0T08961One-Time Revaluation on Key DateBasic Functions
101ERP EHP76.0T090281Depreciation calculation keysBasic Functions
102ERP EHP76.0T090A141Period control dep. calculationBasic Functions
103ERP EHP76.0T090C141External depreciation keysBasic Functions
104ERP EHP76.0T090L71Unit-of-production method of depreciationBasic Functions
105ERP EHP76.0T090M61Table for maximum depreciation amountsBasic Functions
106ERP EHP76.0T090MIG21FI-AA: Calculation Methods Were MigratedBasic Functions
107ERP EHP76.0T090NA131Depreciation KeysBasic Functions
108ERP EHP76.0T090NAT51Names of Depreciation KeysBasic Functions
109ERP EHP76.0T090NAZ161Depreciation Keys - Method AssignmentBasic Functions
110ERP EHP76.0T090ND61Declining-Balance MethodBasic Functions
111ERP EHP76.0T090NDT51Name for Declining-Balance MethodBasic Functions
112ERP EHP76.0T090NH51Maximum Amount MethodBasic Functions
113ERP EHP76.0T090NHT41Name for Maximum Amount MethodBasic Functions
114ERP EHP76.0T090NH_METH31Maximum Amount MethodBasic Functions
115ERP EHP76.0T090NP141Period Control MethodBasic Functions
116ERP EHP76.0T090NPT51Name of Period Control MethodBasic Functions
117ERP EHP76.0T090NR81Base MethodBasic Functions
118ERP EHP76.0T090NRT41Base MethodBasic Functions
119ERP EHP76.0T090NS101Multilevel MethodBasic Functions
120ERP EHP76.0T090NSG61Multi-Level Method - Start of ValidityBasic Functions
121ERP EHP76.0T090NSK81Multilevel MethodBasic Functions
122ERP EHP76.0T090NST51Name of Multi-Level MethodsBasic Functions
123ERP EHP76.0T090P91Dep. calc. key percentage recordsBasic Functions
124ERP EHP76.0T090R41Period control rules for transactionsBasic Functions
125ERP EHP76.0T090S41Names For Internal Calculation KeysBasic Functions
126ERP EHP76.0T090T51Names For External Depreciation KeysBasic Functions
127ERP EHP76.0T090U41Texts on depreciation simulation versionsBasic Functions
128ERP EHP76.0T090V41Name for period control in transactionsBasic Functions
129ERP EHP76.0T090Z81Period control for transactionsBasic Functions
130ERP EHP76.0T09141Cut-off value keyBasic Functions
131ERP EHP76.0T091C71Translation methods for Asset AccountingBasic Functions
132ERP EHP76.0T091P71Cut-off val. percent. ratesBasic Functions
133ERP EHP76.0T091S41Text for translation methodsBasic Functions
134ERP EHP76.0T091T41Names for Cut-Off Value KeysBasic Functions
135ERP EHP76.0T093421Real and derived depreciation areasBasic Functions
136ERP EHP76.0T093A201Real depreciation areaBasic Functions
137ERP EHP76.0T093B221Company code-related depreciation area specificationsBasic Functions
138ERP EHP76.0T093B_RSL111Company Code-Related Depreciation Area SpecificationsBasic Functions
139ERP EHP76.0T093C291Company codes in Asset AccountingBasic Functions
140ERP EHP76.0T093C_RSL31Default Values for Depreciation Key in Company CodeBasic Functions
141ERP EHP76.0T093G31Cross-System Depreciation AreasBasic Functions
142ERP EHP76.0T093GT51Texts for Cross-System Depreciation AreasBasic Functions
143ERP EHP76.0T093H51Assignment of FI-AA Line Item SchemaBasic Functions
144ERP EHP76.0T093R113Control Table for Archiving in Asset AccountingBasic Functions
145ERP EHP76.0T093SB91Substitution for Asset Management / Company CodeBasic Functions
146ERP EHP76.0T093T61Names for real and derived depreciation areasBasic Functions
147ERP EHP76.0T093V71Validation for Asset Management / Company CodeBasic Functions
148ERP EHP76.0T093_BSN_FUNC41ERP Business Function for FI-AABasic Functions
149ERP EHP76.0T094A41Index series for replacement valuesBasic Functions
150ERP EHP76.0T094B31Allowed base years per index seriesBasic Functions
151ERP EHP76.0T094P71Index Figures for Replacement ValuesBasic Functions
152ERP EHP76.0T094S41Names for Index ClassesBasic Functions
153ERP EHP76.0T094T41Index series namesBasic Functions
154ERP EHP76.0T095251Balance sheet accounts for depreciation areasBasic Functions
155ERP EHP76.0T095A21Account allocationBasic Functions
156ERP EHP76.0T095B241G/L accounts value adjustmentBasic Functions
157ERP EHP76.0T095C41FI-AA Standard Account DeterminationBasic Functions
158ERP EHP76.0T095P141Reconcil.accts. derived dep. areasBasic Functions
159ERP EHP76.0T095T41Name for account groupsBasic Functions
160ERP EHP76.0T09641Chart of depreciationBasic Functions
161ERP EHP76.0T096T41Chart of depreciation textsBasic Functions
162ERP EHP76.0T097JP121FI-AA: Percentage rates for property valuation JapanBasic Functions
163ERP EHP76.0T09951Insurance typesBasic Functions
164ERP EHP76.0T099A21Insurance companiesBasic Functions
165ERP EHP76.0T099T41Description of Insurance TypesBasic Functions
166ERP EHP76.0T099U41Insurance Companies DescriptionBasic Functions
167ERP EHP76.0TA1M31Line Item SchemaBasic Functions
168ERP EHP76.0TA1MT41Text Table for Line Item SchemaBasic Functions
169ERP EHP76.0TA1MZ61Line Item SchemaBasic Functions
170ERP EHP76.0TA1TV21Asset Transfer VariantBasic Functions
171ERP EHP76.0TA1TVB71Determination of the Asset Transfer MethodBasic Functions
172ERP EHP76.0TA1TVT41Asset Transfer VariantBasic Functions
173ERP EHP76.0TAAPM121Assignment for Field Link between FI-AA and PMBasic Functions
174ERP EHP76.0TAAPM1T41Assignment for Field Link between FI-AA and PMBasic Functions
175ERP EHP76.0TAAPM261Link from FI-AA to PM: Assignment of FieldsBasic Functions
176ERP EHP76.0TABA121Depreciation posting documentsBasic Functions
177ERP EHP76.0TABAS81Logging of periodic posting runs in FI-AABasic Functions
178ERP EHP76.0TABBR21Rules for determining asset value dateBasic Functions
179ERP EHP76.0TABBT41Names of the rules for determining the asset value dateBasic Functions
180ERP EHP76.0TABVA21Variants for determining asset value dateBasic Functions
181ERP EHP76.0TABVAT41Names of variants for determining asset value dateBasic Functions
182ERP EHP76.0TABVO61Determine asset value date in Asset Accounting transactionsBasic Functions
183ERP EHP76.0TABW301Asset transaction typesBasic Functions
184ERP EHP76.0TABWA61Transaction types/dep. areasBasic Functions
185ERP EHP76.0TABWD31Default transaction types for FI-AA posting transactionsBasic Functions
186ERP EHP76.0TABWD_FTC21Fields Used for Table Controls on Asset PostingsBasic Functions
187ERP EHP76.0TABWD_VID11Entity Table for Table TABWDBasic Functions
188ERP EHP76.0TABWD_VIT31Text Table for Table TABWD_VIDBasic Functions
189ERP EHP76.0TABWG211Transaction type groupsBasic Functions
190ERP EHP76.0TABWH41Name for asset transaction type groupsBasic Functions
191ERP EHP76.0TABWM201Asgnmt. hist. sheet (sub)groups to asset history sheet itemBasic Functions
192ERP EHP76.0TABWO41Names for the asset history sheet versionsBasic Functions
193ERP EHP76.0TABWP31Entity table for asset history sheet versionsBasic Functions
194ERP EHP76.0TABWT41Asset transaction types textsBasic Functions
195ERP EHP76.0TABWU61Special Treatment of RetirementsBasic Functions
196ERP EHP76.0TCREP101CATT-Test Reporting - Check of logical databasesBasic Functions
197ERP EHP76.0TFAA_PC_P31ProcessesBasic Functions
198ERP EHP76.0TFAA_PC_PS71Assignment Process -> SubprocessBasic Functions
199ERP EHP76.0TFAA_PC_PT51Process NamesBasic Functions
200ERP EHP76.0TFAA_PC_S31SubprocessesBasic Functions
201ERP EHP76.0TFAA_PC_SM61Assignment of Subprocess to Processing Methods/ModulesBasic Functions
202ERP EHP76.0TFAA_PC_ST51Subprocess NamesBasic Functions
Financial Accounting :: Asset Accounting :: Information System
ProductVersionTableColumnsIndexesDescriptionModule
203ERP EHP76.0GLOFAAJPAX16AC41FI-AA: Japan / Asset class selection for Annex16Information System
204ERP EHP76.0GLOFAAJPT09341FI-AA: Japan / Additional attribute for Depreciation AreasInformation System
205ERP EHP76.0GLOFAAJPTSICHK51Annex16: Chk tab for the convination of Type-Structure-ItemInformation System
206ERP EHP76.0GLOFAAJPTSIDEF61Annex16: Default Value for Structure & Item in CSMDInformation System
207ERP EHP76.0TABWQ21Asset hist. sheet groupInformation System
208ERP EHP76.0TABWR41Name of asset hist. sheet groupInformation System
Financial Accounting :: Asset Accounting :: Basic Functions :: Asset Maintenance
ProductVersionTableColumnsIndexesDescriptionModule
209ERP EHP76.0J_3RAOKOF31OKOF classifier of RussiaAsset Maintenance
210ERP EHP76.0J_3RAOKOFT51OKOF description classifier of RussiaAsset Maintenance
211ERP EHP76.0TAMLAY031Tab pages in master data: Tab layoutsAsset Maintenance
212ERP EHP76.0TAMLAY0T51Tab pages in master data: Tab layout descriptionsAsset Maintenance
213ERP EHP76.0TAMLAY141Tab pages in master data: Tab titles of layoutAsset Maintenance
214ERP EHP76.0TAMLAY1T61Tabs in Master Data: Tab Index TitlesAsset Maintenance
215ERP EHP76.0TAMLAY261Tab pages in master data: Assignment of group boxesAsset Maintenance
216ERP EHP76.0TAMLAYA61Tabs in master data: ApplicationsAsset Maintenance
217ERP EHP76.0TAMLAYAT31Tab pages in master data: Descript. of master data objectsAsset Maintenance
218ERP EHP76.0TAMLAYB71Tab pages in master data: Group boxesAsset Maintenance
219ERP EHP76.0TAMLAYBT41Tab pages in master data: Descriptions of group boxesAsset Maintenance
Financial Accounting :: Asset Accounting :: Special Valuation :: Handling of Inflation
ProductVersionTableColumnsIndexesDescriptionModule
220ERP EHP76.0J_1AAA191Definition of revaluationHandling of Inflation
221ERP EHP76.0J_1AAA291Revaluation KeyHandling of Inflation
222ERP EHP76.0J_1AAA2M61Methods fore period control of transactionsHandling of Inflation
223ERP EHP76.0J_1AAA2MT41Period control methods descriptionHandling of Inflation
224ERP EHP76.0J_1AAA2T51Inflation Adjustment AA - Revaluation Key TextHandling of Inflation
225ERP EHP76.0J_1AAA531Transaction types excluded from revaluationHandling of Inflation
226ERP EHP76.0J_1AAA5A51Transaction Types exluded from RV-adjustmentHandling of Inflation
227ERP EHP76.0J_1AAOLDTA181Inflation Adjustment AA - Historic transact. period BalancesHandling of Inflation
228ERP EHP76.0J_1AAT089101Revaluation area assignmentHandling of Inflation
229ERP EHP76.0J_1APROLOG101Log table for Inflation Adjustment ProgramsHandling of Inflation
Financial Accounting :: Asset Accounting :: Special Valuation :: Net Worth Tax
ProductVersionTableColumnsIndexesDescriptionModule
230ERP EHP76.0IDFIAA_JP_COND1121Selection Criteria for Stored ReportsNet Worth Tax
231ERP EHP76.0IDFIAA_JP_RESULT462Results of Property Tax Report (Japan)Net Worth Tax
232ERP EHP76.0IDFIAA_JP_TAX1111Japanese Tax Report - Areas and Transaction TypesNet Worth Tax
233ERP EHP76.0IDFIAA_JP_TAX221Japanese Tax Report - Transaction Types Intra-City TransferNet Worth Tax
Financial Accounting :: Asset Accounting :: Basic Functions :: Transactions :: Transfer Postings
ProductVersionTableColumnsIndexesDescriptionModule
234ERP EHP76.0J_1AAFORMP71Assignment of document Form to movement reason AA waybillsTransfer Postings
235ERP EHP76.0J_1AAWAYBL471Way Bills for asset movementsTransfer Postings

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