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
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

74 columns | Print definition?ERP 6.0  | AFABE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/AANLCAsset-value fields, like anlc, for areas 11,12...6AFABEReal depreciation areanvarchar20
2/ATL/AANLCPPeriodic Asset-value fields, like anlc, for all areas7AFABEReal depreciation areanvarchar20
3/ATL/AATRNSFAsset transfers9AFABEReal depreciation areanvarchar20
4/CCEE/RSFIAA_RVAActivate Revaluation Split3AFABEReal depreciation areanvarchar20
5CNVA_PCREA_AA_OLT PC Reorg Analysis: Asset Reconciliation results (Level 2)5AFABEDepreciation area real or derivednvarchar20
6CNVA_PCREA_AA_PPC Reorg Analysis: Parameters for Fixed Asset Recon4AFABEDepreciation area real or derivednvarchar20
7CNV_20200_T093BDifferences in Comp.code-related depreciation area specific.5AFABEnvarchar20
8CNV_40305_POST_AAggregated amount to be reposted4AFABEDepreciation areanvarchar20
9CNV_40305_POST_DValues to be reposted for a given asset6AFABEDepreciation areanvarchar20
10CNV_40305_SIM_PAAggregated amount to be reposted5AFABEDepreciation areanvarchar20
11CNV_40305_SIM_PDValues to be reposted for a given asset7AFABEDepreciation areanvarchar20
12CNV_40305_T095CNV Backup of T0955AFABEDepreciation areanvarchar20
13CNV_40305_T095BCNV Backup of T095B5AFABEDepreciation areanvarchar20
14FIAASKD_SUBACQUISlovakia: FIAA Subsequent Acquisition Postings7AFABEReal depreciation areanvarchar20
15FIKZD_PROPTAXProperty tax Kazakstan11AFABEReal depreciation areanvarchar20
16FILUD_AA_ITEMSSAFT: FI Asset line item details6AFABEReal depreciation areanvarchar20
17FILUD_AA_MASTERSAFT: FI Asset master data and values6AFABEReal depreciation areanvarchar20
18GLPCA_CTProfit Center Documents37AFABEReal depreciation areanvarchar20
19GLPCA_T_CTProfit Center Documents53AFABEReal depreciation areanvarchar20
20T090IDepreciation simulation (Reporting)3AFABEReal depreciation areanvarchar20
21T093UOptions for asset legacy data transfer4AFABEReal depreciation areanvarchar20
22T093YShortened fiscal year4AFABEReal depreciation areanvarchar20
23TGLO_JP_IMPDepreciation areas to Impairment data mapping4AFABEReal depreciation areanvarchar20
TOPAccounting Interface
24GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)280AFABEReal depreciation areanvarchar20
25GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)280AFABEReal depreciation areanvarchar20
TOPActual CostingMaterial Ledger
26FCML_FIAACOControl Table Transfer of Depreciation to CO3AFABEReal depreciation areanvarchar20
TOPAsset Accounting
27APERB_ITEMSLog Table for Dep. Areas Posted Directly to FI7AFABEReal depreciation areanvarchar20
28BWFIAA_AEDAT_ABFIAA-BW: Modified Valuation Area Data for Delta Upload5AFABEReal depreciation areanvarchar20
29BWFIAA_AEDAT_TRFIAA-BW: New and Modified Transactions for Delta Upload7AFABEReal depreciation areanvarchar20
30IDPT_A011Revaluation Areas for Asset Reports3AFABEDepreciation area real or derivednvarchar20
TOPBasic Functions
31ANEAAsset Line Items for Proportional Values7AFABEReal depreciation areanvarchar20
32ANEPAsset Line Items7AFABEReal depreciation areanvarchar20
33ANGBAsset catalog deprec. area4AFABEReal depreciation areanvarchar20
34ANKBAsset class: depreciation area4AFABEDepreciation area real or derivednvarchar20
35ANLBDepreciation terms5AFABEReal depreciation areanvarchar20
36ANLBZATime-Dependent Depreciation Terms5AFABEReal depreciation areanvarchar20
37ANLBZWAsset-specific base values5AFABEReal depreciation areanvarchar20
38ANLCAsset Value Fields6AFABEReal depreciation areanvarchar20
39T090MTable for maximum depreciation amounts4AFABEReal depreciation areanvarchar20
40T093AReal depreciation area3AFABEReal depreciation areanvarchar20
41T093BCompany code-related depreciation area specifications3AFABEReal depreciation areanvarchar20
42T093B_RSLCompany Code-Related Depreciation Area Specifications3AFABEReal depreciation areanvarchar20
43T095Balance sheet accounts for depreciation areas4AFABEReal depreciation areanvarchar20
44T095BG/L accounts value adjustment4AFABEReal depreciation areanvarchar20
45T099Insurance types3AFABEReal depreciation areanvarchar20
46TABWATransaction types/dep. areas4AFABEReal depreciation areanvarchar20
47TABWUSpecial Treatment of Retirements4AFABEReal depreciation areanvarchar20
TOPCapital Investments
48ANIBInvestment projects depr. simulation depr. areas4AFABEReal depreciation areanvarchar20
TOPConstruction Equipment Management
49J_3GPLKATAssignment Price List - Condition Types - Catalogs10AFABEReal depreciation areanvarchar20
TOPData Retention Tool
50TXW_S_ANEARetrieve ANEA from archive17AFABEReal depreciation areanvarchar20
51TXW_S_ANEPRetrieve ANEP from archive17AFABEReal depreciation areanvarchar20
TOPFinancial Accounting
52/BGLOCS/FITAXDPRAsset transaction types for Tax Depr. Plan3AFABEReal depreciation areanvarchar20
TOPFunctions for U.S. Federal Government
53FMFG_T095Contra accounts asset accounting4AFABEReal depreciation areanvarchar20
TOPGeneral Ledger Accounting
54FAGL_HST_T095Old Acct Determin. for Asset Value Adjustment and Portfolio4AFABEReal depreciation areanvarchar20
TOPHandling of Inflation
55J_1AAOLDTAInflation Adjustment AA - Historic transact. period Balances6AFABEReal depreciation areanvarchar20
TOPInformation System
56GLOFAAJPT093FI-AA: Japan / Additional attribute for Depreciation Areas3AFABEDepreciation area real or derivednvarchar20
TOPInterest
57TPI02Interest Calculation Profile and Interest Indicator11AFABEDepreciation Area of Base Value for Interest Calculationnvarchar20
TOPJoint Venture und Production Sharing Accounting
58T8JHFFields to transport from sending to new receiving asset7AFABEReal depreciation areanvarchar20
59T8JHRDepreciation areas not to update by recovery indicator4AFABEReal depreciation areanvarchar20
TOPLease Accounting
60TFILA_FA_002Assignment Accounting Principle -> Depreciation Area5AFABEDepreciation area real or derivednvarchar20
TOPLocal Currency Changeover
61EWUAFABEEMU: Currencies for the participating depreciation areas4AFABEDepreciation Areanvarchar20
TOPLocalization
62J_1ITAXDEPDepreciation computation as per Income Tax (India)5AFABEReal depreciation areanvarchar20
63J_3RF_WW_AREADepreciation area for Working wear3AFABEDepreciation area real or derivednvarchar20
64J_3RPTAXVALDefine Depreciation Areas for Property Tax Calculation4AFABEReal depreciation areanvarchar20
65J_3RT095BAdditional accounts for revaluation4AFABEReal depreciation areanvarchar20
66J_3RTRETLock table for update retired asset during TranspTaxCalc7AFABEReal depreciation areanvarchar20
67TGLO_JP_IMPDEPRDepreciation areas to Impairment data mapping4AFABEReal depreciation areanvarchar20
TOPOverhead Cost Orders
68AUAISettlement Amounts per Depreciation Area4AFABEReal depreciation areanvarchar20
TOPProfit Center Accounting
69GLPCAEC-PCA: Actual Line Items24AFABEReal depreciation areanvarchar20
70GLPCCEC-PCA: Transaction Attributes7AFABEReal depreciation areanvarchar20
71GLPCPEC-PCA: Plan Line Items24AFABEReal depreciation areanvarchar20
72GLPCTEC-PCA: Totals Table23AFABEReal depreciation areanvarchar20
73T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material25AFABEReal depreciation areanvarchar20
TOPStatistical Key Figures
74COEPBRCO Object: Valuated Line Item Settlement6AFABEReal depreciation areanvarchar20