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

62 columns | Print definition?ERP 6.0  | AFAPL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_40305_ANKPBackup of ANKP from prior to the conversion4AFAPLChart of depreciaton for asset valuationnvarchar40
2CNV_40305_ANKP_BBackup of ANKP from prior to the conversion4AFAPLChart of depreciaton for asset valuationnvarchar40
3J_3RFDEPB_CHARTDepreciation bonus: Chart of depreciation level2AFAPLChart of depreciaton for asset valuationnvarchar40
4T089TText table for T089 (appreciations)3AFAPLChart of depreciaton for asset valuationnvarchar40
5T093FCheck rules dep. calc. (not used!)2AFAPLChart of depreciaton for asset valuationnvarchar40
6T093SValue Field Names for Depreciation Areas3AFAPLChart of depreciaton for asset valuationnvarchar40
7TABWBTransaction types AuC (no longer used)2AFAPLChart of depreciaton for asset valuationnvarchar40
8TABWIAllowed asset classes per transaction type group2AFAPLChart of depreciaton for asset valuationnvarchar40
9TGLO_JP_IMPDepreciation areas to Impairment data mapping3AFAPLChart of depreciaton for asset valuationnvarchar40
TOPActual CostingMaterial Ledger
10FCML_FIAACOControl Table Transfer of Depreciation to CO2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPAddress ManagementBusiness Address
11T005Countries56AFAPLChart of depreciaton for asset valuationnvarchar40
TOPAsset Accounting
12IDCN_GA_DEPParameters for Asset Depreciation (Golden Audit)2AFAPLChart of depreciaton for asset valuationnvarchar40
13T093_MAP_ACCMapping Table for Alternative Company Codes7AFAPLChart of depreciaton for asset valuationnvarchar40
TOPBasic Functions
14ANGBAsset catalog deprec. area2AFAPLChart of depreciaton for asset valuationnvarchar40
15ANKBAsset class: depreciation area3AFAPLChart of depreciaton for asset valuationnvarchar40
16ANKLGeneration table for generating asset classes from accounts3AFAPLChart of depreciaton for asset valuationnvarchar40
17ANKLAYPAsset class: Assignment of tab layouts3AFAPLChart of depreciaton for asset valuationnvarchar40
18ANKPAsset classes: Fld Cont Dpndnt on Chart of Depreciation3AFAPLChart of depreciaton for asset valuationnvarchar40
19T082AVIEWBView Authorization for Depreciation Areas3AFAPLChart of depreciaton for asset valuationnvarchar40
20T085Investment support measures2AFAPLChart of depreciaton for asset valuationnvarchar40
21T085PInvestment support: Default and check table2AFAPLChart of depreciaton for asset valuationnvarchar40
22T085SDescription of individual investment support measures3AFAPLChart of depreciaton for asset valuationnvarchar40
23T085ZCapital investment grants with time-dependent percentages2AFAPLChart of depreciaton for asset valuationnvarchar40
24T089One-Time Revaluation on Key Date2AFAPLChart of depreciaton for asset valuationnvarchar40
25T090CExternal depreciation keys2AFAPLChart of depreciaton for asset valuationnvarchar40
26T090NADepreciation Keys2AFAPLChart of depreciaton for asset valuationnvarchar40
27T090NATNames of Depreciation Keys3AFAPLChart of depreciaton for asset valuationnvarchar40
28T090NAZDepreciation Keys - Method Assignment2AFAPLChart of depreciaton for asset valuationnvarchar40
29T090NDDeclining-Balance Method2AFAPLChart of depreciaton for asset valuationnvarchar40
30T090NDTName for Declining-Balance Method3AFAPLChart of depreciaton for asset valuationnvarchar40
31T090NPPeriod Control Method2AFAPLChart of depreciaton for asset valuationnvarchar40
32T090NPTName of Period Control Method3AFAPLChart of depreciaton for asset valuationnvarchar40
33T090NSMultilevel Method2AFAPLChart of depreciaton for asset valuationnvarchar40
34T090NSGMulti-Level Method - Start of Validity2AFAPLChart of depreciaton for asset valuationnvarchar40
35T090NSKMultilevel Method2AFAPLChart of depreciaton for asset valuationnvarchar40
36T090NSTName of Multi-Level Methods3AFAPLChart of depreciaton for asset valuationnvarchar40
37T090TNames For External Depreciation Keys3AFAPLChart of depreciaton for asset valuationnvarchar40
38T093Real and derived depreciation areas2AFAPLChart of depreciaton for asset valuationnvarchar40
39T093AReal depreciation area2AFAPLChart of depreciaton for asset valuationnvarchar40
40T093CCompany codes in Asset Accounting8AFAPLChart of depreciaton for asset valuationnvarchar40
41T093TNames for real and derived depreciation areas3AFAPLChart of depreciaton for asset valuationnvarchar40
42T096Chart of depreciation2AFAPLChart of depreciaton for asset valuationnvarchar40
43T096TChart of depreciation texts3AFAPLChart of depreciaton for asset valuationnvarchar40
44TABWATransaction types/dep. areas2AFAPLChart of depreciaton for asset valuationnvarchar40
45TABWUSpecial Treatment of Retirements2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPCost Object
46TKKAJText Table for Results Analysis Versions3AFAPLChart of depreciaton for asset valuationnvarchar40
47TKKALEntity Table for RA Versions for Assets Under Construction2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPHandling of Inflation
48J_1AAT089Revaluation area assignment2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPInformation System
49GLOFAAJPT093FI-AA: Japan / Additional attribute for Depreciation Areas2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPInterest
50TPI02Interest Calculation Profile and Interest Indicator10AFAPLChart of depreciaton for asset valuationnvarchar40
TOPJoint Venture und Production Sharing Accounting
51T8JHFFields to transport from sending to new receiving asset2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPLand Use Management
52TIVLMPLDPRAREALUM-Relevant Depreciation Areas2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPLease Accounting
53TFILA_FA_002Assignment Accounting Principle -> Depreciation Area3AFAPLChart of depreciaton for asset valuationnvarchar40
TOPLocal Currency Changeover
54EWUAFAPLEMU: Currencies for the participating investment supports3AFAPLChart of depreciation for the assetnvarchar40
TOPLocalization
55IDIN_FIAA_TAXTax Area for Asset Blocks2AFAPLChart of depreciaton for asset valuationnvarchar40
56J_3RF_WW_AREADepreciation area for Working wear2AFAPLChart of depreciaton for asset valuationnvarchar40
57J_3RMONTHACTIVMonthly depreciation flags for depreciation areas2AFAPLChart of depreciaton for asset valuationnvarchar40
58J_3RNEGPAFABEPermit Negative Posting for Depr. Area and Chart of Depr.2AFAPLChart of depreciaton for asset valuationnvarchar40
59TGLO_JP_IMPDEPRDepreciation areas to Impairment data mapping3AFAPLChart of depreciaton for asset valuationnvarchar40
TOPNet Worth Tax
60IDFIAA_JP_TAX1Japanese Tax Report - Areas and Transaction Types2AFAPLChart of depreciaton for asset valuationnvarchar40
TOPRegulatory reporting for insurance companies
61TISSR_STOCK_FIAAVermögenskennz. zu Bewertungsbereich FI-AA zuordnen5AFAPLBewertungsplan für die Anlagenbewertungnvarchar40
TOPTreasury
62TZ27Allocation: Valuation area for internal stock indicator3AFAPLChart of depreciaton for asset valuationnvarchar40