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

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

181 tablesERP 6.0 

Financial Accounting :: Asset Accounting :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ANAR101Asset TypesBasic Functions
2ERP EHP76.0ANAT51Asset type textBasic Functions
3ERP EHP76.0ANEA271Asset Line Items for Proportional ValuesBasic Functions
4ERP EHP76.0ANEK512Document Header Asset PostingBasic Functions
5ERP EHP76.0ANEP241Asset Line ItemsBasic Functions
6ERP EHP76.0ANEV83Asset downpymt settlementBasic Functions
7ERP EHP76.0ANGA221Asset catalog general dataBasic Functions
8ERP EHP76.0ANGB161Asset catalog deprec. areaBasic Functions
9ERP EHP76.0ANGT61Asset catalog text tableBasic Functions
10ERP EHP76.0ANKA581Asset classes: general dataBasic Functions
11ERP EHP76.0ANKAZ171Asset class: extension for technical fieldsBasic Functions
12ERP EHP76.0ANKB331Asset class: depreciation areaBasic Functions
13ERP EHP76.0ANKL431Generation table for generating asset classes from accountsBasic Functions
14ERP EHP76.0ANKLAY41Asset class: Assignment of tab layoutsBasic Functions
15ERP EHP76.0ANKLAYP51Asset class: Assignment of tab layoutsBasic Functions
16ERP EHP76.0ANKP191Asset classes: Fld Cont Dpndnt on Chart of DepreciationBasic Functions
17ERP EHP76.0ANKT81Asset classes: DescriptionBasic Functions
18ERP EHP76.0ANKV101Asset classes: insurance typesBasic Functions
19ERP EHP76.0ANLA1418Asset Master Record SegmentBasic Functions
20ERP EHP76.0ANLB493Depreciation termsBasic Functions
21ERP EHP76.0ANLBZA133Time-Dependent Depreciation TermsBasic Functions
22ERP EHP76.0ANLBZW71Asset-specific base valuesBasic Functions
23ERP EHP76.0ANLC771Asset Value FieldsBasic Functions
24ERP EHP76.0ANLH81Main asset numberBasic Functions
25ERP EHP76.0ANLP562Asset Periodic ValuesBasic Functions
26ERP EHP76.0ANLQ352Period values from dep. posting run per posting levelBasic Functions
27ERP EHP76.0ANLT152Asset TextsBasic Functions
28ERP EHP76.0ANLU41Asset Master Record: User FieldsBasic Functions
29ERP EHP76.0ANLV221Insurance dataBasic Functions
30ERP EHP76.0ANLW101Insurable values (year dependent)Basic Functions
31ERP EHP76.0ANLX251Asset Master Record SegmentBasic Functions
32ERP EHP76.0ANLZ413Time-Dependent Asset AllocationsBasic Functions
33ERP EHP76.0FAAASSETID52Assignment Table - Asset Key to Asset GUIDBasic Functions
34ERP EHP76.0SMFIAA101Spec. FI-AA Data in Monitor (see Schedman_specific_fiaa)Basic Functions
35ERP EHP76.0T080A61Structure definition work list suffixBasic Functions
36ERP EHP76.0T082111Field group authorization assetsBasic Functions
37ERP EHP76.0T082AVIEW021Entity Table for Asset ViewsBasic Functions
38ERP EHP76.0T082AVIEW0T41Text Tables for Asset ViewsBasic Functions
39ERP EHP76.0T082AVIEW141View Authorization for Asset Master Data FieldsBasic Functions
40ERP EHP76.0T082AVIEW241View Authorization for Asset Depreciation Area FieldsBasic Functions
41ERP EHP76.0T082AVIEWB51View Authorization for Depreciation AreasBasic Functions
42ERP EHP76.0T082AVIEWTRANSG31Assignment of Transaction Group to Asset ViewBasic Functions
43ERP EHP76.0T082B31Field groups assets definitionBasic Functions
44ERP EHP76.0T082F41Field groups asset dataBasic Functions
45ERP EHP76.0T082G131Field strings for screen selection asset master data.Basic Functions
46ERP EHP76.0T082H51Field string name: Asset master data maintenanceBasic Functions
47ERP EHP76.0T082I41Create takeover rules from transfer for master dataBasic Functions
48ERP EHP76.0T082J51Create takeover rules from transfer for master data: areasBasic Functions
49ERP EHP76.0T082L31Summary of logical field groupsBasic Functions
50ERP EHP76.0T082M41Description for logical field groupsBasic Functions
51ERP EHP76.0T082T41Names For Field GroupsBasic Functions
52ERP EHP76.0T084141Incorrect assetsBasic Functions
53ERP EHP76.0T085201Investment support measuresBasic Functions
54ERP EHP76.0T085P91Investment support: Default and check tableBasic Functions
55ERP EHP76.0T085S51Description of individual investment support measuresBasic Functions
56ERP EHP76.0T085Z71Capital investment grants with time-dependent percentagesBasic Functions
57ERP EHP76.0T086411Sort version ReportingBasic Functions
58ERP EHP76.0T08731Evaluation groupsBasic Functions
59ERP EHP76.0T087G21Evaluation group 8 placesBasic Functions
60ERP EHP76.0T087K21Reason for investment protecting the environmentBasic Functions
61ERP EHP76.0T087L41Text table for reasons for environmental investmentsBasic Functions
62ERP EHP76.0T087S41Test table for evaluation group 8 placesBasic Functions
63ERP EHP76.0T087T51Description of Evaluation GroupsBasic Functions
64ERP EHP76.0T087U21Asset group number / asset groupBasic Functions
65ERP EHP76.0T087V41Text table asset group number / asset groupBasic Functions
66ERP EHP76.0T08961One-Time Revaluation on Key DateBasic Functions
67ERP EHP76.0T090281Depreciation calculation keysBasic Functions
68ERP EHP76.0T090A141Period control dep. calculationBasic Functions
69ERP EHP76.0T090C141External depreciation keysBasic Functions
70ERP EHP76.0T090L71Unit-of-production method of depreciationBasic Functions
71ERP EHP76.0T090M61Table for maximum depreciation amountsBasic Functions
72ERP EHP76.0T090MIG21FI-AA: Calculation Methods Were MigratedBasic Functions
73ERP EHP76.0T090NA131Depreciation KeysBasic Functions
74ERP EHP76.0T090NAT51Names of Depreciation KeysBasic Functions
75ERP EHP76.0T090NAZ161Depreciation Keys - Method AssignmentBasic Functions
76ERP EHP76.0T090ND61Declining-Balance MethodBasic Functions
77ERP EHP76.0T090NDT51Name for Declining-Balance MethodBasic Functions
78ERP EHP76.0T090NH51Maximum Amount MethodBasic Functions
79ERP EHP76.0T090NHT41Name for Maximum Amount MethodBasic Functions
80ERP EHP76.0T090NH_METH31Maximum Amount MethodBasic Functions
81ERP EHP76.0T090NP141Period Control MethodBasic Functions
82ERP EHP76.0T090NPT51Name of Period Control MethodBasic Functions
83ERP EHP76.0T090NR81Base MethodBasic Functions
84ERP EHP76.0T090NRT41Base MethodBasic Functions
85ERP EHP76.0T090NS101Multilevel MethodBasic Functions
86ERP EHP76.0T090NSG61Multi-Level Method - Start of ValidityBasic Functions
87ERP EHP76.0T090NSK81Multilevel MethodBasic Functions
88ERP EHP76.0T090NST51Name of Multi-Level MethodsBasic Functions
89ERP EHP76.0T090P91Dep. calc. key percentage recordsBasic Functions
90ERP EHP76.0T090R41Period control rules for transactionsBasic Functions
91ERP EHP76.0T090S41Names For Internal Calculation KeysBasic Functions
92ERP EHP76.0T090T51Names For External Depreciation KeysBasic Functions
93ERP EHP76.0T090U41Texts on depreciation simulation versionsBasic Functions
94ERP EHP76.0T090V41Name for period control in transactionsBasic Functions
95ERP EHP76.0T090Z81Period control for transactionsBasic Functions
96ERP EHP76.0T09141Cut-off value keyBasic Functions
97ERP EHP76.0T091C71Translation methods for Asset AccountingBasic Functions
98ERP EHP76.0T091P71Cut-off val. percent. ratesBasic Functions
99ERP EHP76.0T091S41Text for translation methodsBasic Functions
100ERP EHP76.0T091T41Names for Cut-Off Value KeysBasic Functions
101ERP EHP76.0T093421Real and derived depreciation areasBasic Functions
102ERP EHP76.0T093A201Real depreciation areaBasic Functions
103ERP EHP76.0T093B221Company code-related depreciation area specificationsBasic Functions
104ERP EHP76.0T093B_RSL111Company Code-Related Depreciation Area SpecificationsBasic Functions
105ERP EHP76.0T093C291Company codes in Asset AccountingBasic Functions
106ERP EHP76.0T093C_RSL31Default Values for Depreciation Key in Company CodeBasic Functions
107ERP EHP76.0T093G31Cross-System Depreciation AreasBasic Functions
108ERP EHP76.0T093GT51Texts for Cross-System Depreciation AreasBasic Functions
109ERP EHP76.0T093H51Assignment of FI-AA Line Item SchemaBasic Functions
110ERP EHP76.0T093R113Control Table for Archiving in Asset AccountingBasic Functions
111ERP EHP76.0T093SB91Substitution for Asset Management / Company CodeBasic Functions
112ERP EHP76.0T093T61Names for real and derived depreciation areasBasic Functions
113ERP EHP76.0T093V71Validation for Asset Management / Company CodeBasic Functions
114ERP EHP76.0T093_BSN_FUNC41ERP Business Function for FI-AABasic Functions
115ERP EHP76.0T094A41Index series for replacement valuesBasic Functions
116ERP EHP76.0T094B31Allowed base years per index seriesBasic Functions
117ERP EHP76.0T094P71Index Figures for Replacement ValuesBasic Functions
118ERP EHP76.0T094S41Names for Index ClassesBasic Functions
119ERP EHP76.0T094T41Index series namesBasic Functions
120ERP EHP76.0T095251Balance sheet accounts for depreciation areasBasic Functions
121ERP EHP76.0T095A21Account allocationBasic Functions
122ERP EHP76.0T095B241G/L accounts value adjustmentBasic Functions
123ERP EHP76.0T095C41FI-AA Standard Account DeterminationBasic Functions
124ERP EHP76.0T095P141Reconcil.accts. derived dep. areasBasic Functions
125ERP EHP76.0T095T41Name for account groupsBasic Functions
126ERP EHP76.0T09641Chart of depreciationBasic Functions
127ERP EHP76.0T096T41Chart of depreciation textsBasic Functions
128ERP EHP76.0T097JP121FI-AA: Percentage rates for property valuation JapanBasic Functions
129ERP EHP76.0T09951Insurance typesBasic Functions
130ERP EHP76.0T099A21Insurance companiesBasic Functions
131ERP EHP76.0T099T41Description of Insurance TypesBasic Functions
132ERP EHP76.0T099U41Insurance Companies DescriptionBasic Functions
133ERP EHP76.0TA1M31Line Item SchemaBasic Functions
134ERP EHP76.0TA1MT41Text Table for Line Item SchemaBasic Functions
135ERP EHP76.0TA1MZ61Line Item SchemaBasic Functions
136ERP EHP76.0TA1TV21Asset Transfer VariantBasic Functions
137ERP EHP76.0TA1TVB71Determination of the Asset Transfer MethodBasic Functions
138ERP EHP76.0TA1TVT41Asset Transfer VariantBasic Functions
139ERP EHP76.0TAAPM121Assignment for Field Link between FI-AA and PMBasic Functions
140ERP EHP76.0TAAPM1T41Assignment for Field Link between FI-AA and PMBasic Functions
141ERP EHP76.0TAAPM261Link from FI-AA to PM: Assignment of FieldsBasic Functions
142ERP EHP76.0TABA121Depreciation posting documentsBasic Functions
143ERP EHP76.0TABAS81Logging of periodic posting runs in FI-AABasic Functions
144ERP EHP76.0TABBR21Rules for determining asset value dateBasic Functions
145ERP EHP76.0TABBT41Names of the rules for determining the asset value dateBasic Functions
146ERP EHP76.0TABVA21Variants for determining asset value dateBasic Functions
147ERP EHP76.0TABVAT41Names of variants for determining asset value dateBasic Functions
148ERP EHP76.0TABVO61Determine asset value date in Asset Accounting transactionsBasic Functions
149ERP EHP76.0TABW301Asset transaction typesBasic Functions
150ERP EHP76.0TABWA61Transaction types/dep. areasBasic Functions
151ERP EHP76.0TABWD31Default transaction types for FI-AA posting transactionsBasic Functions
152ERP EHP76.0TABWD_FTC21Fields Used for Table Controls on Asset PostingsBasic Functions
153ERP EHP76.0TABWD_VID11Entity Table for Table TABWDBasic Functions
154ERP EHP76.0TABWD_VIT31Text Table for Table TABWD_VIDBasic Functions
155ERP EHP76.0TABWG211Transaction type groupsBasic Functions
156ERP EHP76.0TABWH41Name for asset transaction type groupsBasic Functions
157ERP EHP76.0TABWM201Asgnmt. hist. sheet (sub)groups to asset history sheet itemBasic Functions
158ERP EHP76.0TABWO41Names for the asset history sheet versionsBasic Functions
159ERP EHP76.0TABWP31Entity table for asset history sheet versionsBasic Functions
160ERP EHP76.0TABWT41Asset transaction types textsBasic Functions
161ERP EHP76.0TABWU61Special Treatment of RetirementsBasic Functions
162ERP EHP76.0TCREP101CATT-Test Reporting - Check of logical databasesBasic Functions
163ERP EHP76.0TFAA_PC_P31ProcessesBasic Functions
164ERP EHP76.0TFAA_PC_PS71Assignment Process -> SubprocessBasic Functions
165ERP EHP76.0TFAA_PC_PT51Process NamesBasic Functions
166ERP EHP76.0TFAA_PC_S31SubprocessesBasic Functions
167ERP EHP76.0TFAA_PC_SM61Assignment of Subprocess to Processing Methods/ModulesBasic Functions
168ERP EHP76.0TFAA_PC_ST51Subprocess NamesBasic Functions
Financial Accounting :: Asset Accounting :: Basic Functions :: Asset Maintenance
ProductVersionTableColumnsIndexesDescriptionModule
169ERP EHP76.0J_3RAOKOF31OKOF classifier of RussiaAsset Maintenance
170ERP EHP76.0J_3RAOKOFT51OKOF description classifier of RussiaAsset Maintenance
171ERP EHP76.0TAMLAY031Tab pages in master data: Tab layoutsAsset Maintenance
172ERP EHP76.0TAMLAY0T51Tab pages in master data: Tab layout descriptionsAsset Maintenance
173ERP EHP76.0TAMLAY141Tab pages in master data: Tab titles of layoutAsset Maintenance
174ERP EHP76.0TAMLAY1T61Tabs in Master Data: Tab Index TitlesAsset Maintenance
175ERP EHP76.0TAMLAY261Tab pages in master data: Assignment of group boxesAsset Maintenance
176ERP EHP76.0TAMLAYA61Tabs in master data: ApplicationsAsset Maintenance
177ERP EHP76.0TAMLAYAT31Tab pages in master data: Descript. of master data objectsAsset Maintenance
178ERP EHP76.0TAMLAYB71Tab pages in master data: Group boxesAsset Maintenance
179ERP EHP76.0TAMLAYBT41Tab pages in master data: Descriptions of group boxesAsset Maintenance
Financial Accounting :: Asset Accounting :: Basic Functions :: Transactions :: Transfer Postings
ProductVersionTableColumnsIndexesDescriptionModule
180ERP EHP76.0J_1AAFORMP71Assignment of document Form to movement reason AA waybillsTransfer Postings
181ERP EHP76.0J_1AAWAYBL471Way Bills for asset movementsTransfer Postings