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

53 columns | Print definition?ERP 6.0  | ANLKL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/TAXPERCLASSTax Percentage per year per asset class3ANLKLAsset Classnvarchar80
2BBPT_T023Material groups13ANLKLDefault: Asset class for creation of assetnvarchar80
3CNV_40305_ANKABackup of ANKA from prior to the conversion3ANLKLAsset classnvarchar80
4CNV_40305_ANKA_BBackup of ANKA from prior to the conversion3ANLKLAsset classnvarchar80
5CNV_40305_ANKPBackup of ANKP from prior to the conversion3ANLKLAsset classnvarchar80
6CNV_40305_ANKP_BBackup of ANKP from prior to the conversion3ANLKLAsset classnvarchar80
7CNV_40305_ANKTCNV backup table for Asset classes: Description4ANLKLAsset classnvarchar80
8CNV_40305_ANLA_BAssets with semantically changing account determination6ANLKLAsset classnvarchar80
9CNV_40305_POST_AAggregated amount to be reposted7ANLKLAsset classnvarchar80
10CNV_40305_POST_DValues to be reposted for a given asset9ANLKLAsset classnvarchar80
11CNV_40305_SIM_PAAggregated amount to be reposted8ANLKLAsset classnvarchar80
12CNV_40305_SIM_PDValues to be reposted for a given asset10ANLKLAsset classnvarchar80
13FIAAQAC_EVALACLSMaintain Asset Class and Evaluation Group Assignment2ANLKLAsset Classnvarchar80
14FIKZD_PROPTAXProperty tax Kazakstan10ANLKLAsset Classnvarchar80
15FIKZD_TRTAXTransport tax Kazakstan32ANLKLAsset Classnvarchar80
16FILUD_AA_MASTERSAFT: FI Asset master data and values9ANLKLAsset Classnvarchar80
17IDSAU_TD_C_AGACAssignment of Asset Group to Asset Class3ANLKLAsset Classnvarchar80
18T088Selection Table for Italian Asset Register4ANLKLAsset Classnvarchar80
19T090IDepreciation simulation (Reporting)4ANLKLAsset Classnvarchar80
20TABWIAllowed asset classes per transaction type group4ANLKLAsset Classnvarchar80
21TZ22Asset classes relationship table -- BAV- Sub-section2ANLKLAsset Classnvarchar80
TOPAsset Accounting
22IDCN_GA_ANLKLGA China: Specify Asset Classes2ANLKLAsset Classnvarchar80
23J_1GAM2GRRule Table for Fixed Asset Revaluation3ANLKLAsset Classnvarchar80
TOPBasic Functions
24ANKAAsset classes: general data2ANLKLAsset Classnvarchar80
25ANKAZAsset class: extension for technical fields2ANLKLAsset Classnvarchar80
26ANKBAsset class: depreciation area2ANLKLAsset Classnvarchar80
27ANKLGeneration table for generating asset classes from accounts36ANLKLAsset Classnvarchar80
28ANKLAYAsset class: Assignment of tab layouts2ANLKLAsset Classnvarchar80
29ANKLAYPAsset class: Assignment of tab layouts2ANLKLAsset Classnvarchar80
30ANKPAsset classes: Fld Cont Dpndnt on Chart of Depreciation2ANLKLAsset Classnvarchar80
31ANKTAsset classes: Description3ANLKLAsset Classnvarchar80
32ANKVAsset classes: insurance types2ANLKLAsset Classnvarchar80
33ANLAAsset Master Record Segment5ANLKLAsset Classnvarchar80
34T085PInvestment support: Default and check table8ANLKLAsset Classnvarchar80
35T090MTable for maximum depreciation amounts3ANLKLAsset Classnvarchar80
TOPBusiness Package for Manager Self-Service FI
36FCOM_EQMACL_CAsset Classes for Equipment Monitor3ANLKLAsset Classnvarchar80
TOPCapital Investments
37ANIADepr. simulation for invest. projects5ANLKLAsset Classnvarchar80
TOPConstruction Equipment Management
38/SAPCEM/WF_EQUIWorkflow: Asset from Equi. Master Record, Default Values3ANLKLAsset Classnvarchar80
39J_3GWFCEMCEM: Default Values for Workflow2ANLKLAsset Classnvarchar80
TOPData Collection
40CF003Projects22ANLKLAsset classnvarchar40
TOPFinancial Accounting
41/BGLOCS/FIFXAACLAuC Elements <->Assets Classes Connection4ANLKLAsset Classnvarchar80
42/BGLOCS/FIFXAFCLFixed Assets Legal Figures<->Assets Classes Connection4ANLKLAsset Classnvarchar80
TOPFlexible Real Estate Management
43TIVFANKALUM: Integration FI-AA - Zuordnung relev. Anlagenklassen3ANLKLAnlagenklassenvarchar80
TOPInformation System
44GLOFAAJPAX16ACFI-AA: Japan / Asset class selection for Annex162ANLKLAsset Classnvarchar80
45GLOFAAJPTSIDEFAnnex16: Default Value for Structure & Item in CSMD2ANLKLAsset Classnvarchar80
TOPJoint Venture und Production Sharing Accounting
46T8JHFFields to transport from sending to new receiving asset4ANLKLAsset Classnvarchar80
TOPLocalization
47J_3RFANKAFI-AA class settings for CIS2ANLKLAsset Classnvarchar80
48J_3RF_WRK_GROUPAssignment fixed-asset classes to material groups in Working4ANLKLAsset Classnvarchar80
49J_3RPTAXVALDefine Depreciation Areas for Property Tax Calculation2ANLKLAsset Classnvarchar80
TOPMaterial Groups
50T023Material Groups13ANLKLDefault: Asset Class for Creation of Assetnvarchar80
TOPProfit Center Accounting
51KE1_WU_ANLPCA Where-Used List: Assets8ANLKLAsset Classnvarchar80
TOPReal Estate Management
52TIV40Asset class assignment - Main usage type2ANLKLAsset Classnvarchar80
53VIOB37Relationship between real estate objects and SAP-FI-AA7ANLKLAsset Classnvarchar80