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

45 columns | Print definition?ERP 6.0  | FUNC_AREA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000159000PSA for 0COSTCENTER_ATTR T90CLNT090 Cost center17FUNC_AREAnvarchar160
2/SAPPSSRM/SPFSETSelective Release - Blocking Options by Account7FUNC_AREAFunctional Areanvarchar160
3BBP_PDACCAccount Assignment33FUNC_AREAFunctional Areanvarchar160
4CNV_20100_SKA1CNV backup copy for SKA119FUNC_AREAnvarchar40
5REQACCTAccount Assignment for the Req. Coverage Request Lines37FUNC_AREAFunctional Areanvarchar160
6ZCATSDBRecords changed with processing status '10'23FUNC_AREAnvarchar160
7ZCATSDB2Records changed with processing status '10'24FUNC_AREAnvarchar160
TOPAP-LIM Logistics Inventory Management Engine
8/LIME/COLL_APSCollection for Planning System104FUNC_AREAFunctional Areanvarchar40
9/LIME/COLL_BWCollection for Business Warehouse104FUNC_AREAFunctional Areanvarchar40
10/LIME/COLL_FINCollection for Financial System104FUNC_AREAFunctional Areanvarchar40
11/LIME/COLL_INVCollection for Inventory System104FUNC_AREAFunctional Areanvarchar40
12/LIME/COLL_LEGCollection for External System104FUNC_AREAFunctional Areanvarchar40
13/LIME/COLL_MMIMCollection for R/3 Inventory Management104FUNC_AREAFunctional Areanvarchar40
14/LIME/COLL_W2IMCollection for WME after ERP-MMIM104FUNC_AREAFunctional Areanvarchar40
TOPBasis Components
15/XFT/INV_Q_11Account assignment data26FUNC_AREAFunctional Areanvarchar40
16/XFT/INV_Q_11_SAccount assignment data26FUNC_AREAFunctional Areanvarchar40
TOPControlling
17CSKACost Elements (Data Dependent on Chart of Accounts)9FUNC_AREAFunctional Areanvarchar160
18CSKSCost Center Master Data64FUNC_AREAFunctional Areanvarchar160
19IAOM_CSCENARIOControlling Scenario11FUNC_AREAFunctional Areanvarchar160
20TKA05Cost Center Types12FUNC_AREAFunctional Areanvarchar160
TOPCross-Application Components
21AAUUFKOrder master data67FUNC_AREAFunctional Areanvarchar160
TOPDepreciation Simulation
22IMCCIM Summarization: Characteristics that are master data18FUNC_AREAFunctional Areanvarchar160
TOPESS Based on WD ABAP
23HRESS_D_CATS_FAVCATS Favorites: database table30FUNC_AREAReceiving Functional Areanvarchar160
TOPFinancial Accounting
24SKA1G/L Account Master (Chart of Accounts)18FUNC_AREAFunctional Areanvarchar160
TOPFunds Management
25FUMA_EVENTFund Management Events9FUNC_AREAFunctional Areanvarchar160
26IAOM_GTR_EXATGrantor: Account Assignment Manager External Characteristics15FUNC_AREAFunctional Areanvarchar160
TOPOperative Structures
27PROJProject definition70FUNC_AREAFunctional Areanvarchar160
28PRPSWBS (Work Breakdown Structure) Element Master Data92FUNC_AREAFunctional Areanvarchar160
29TCJ41Default Values for Work Breakdown Structure89FUNC_AREAFunctional Areanvarchar160
TOPOrganizational Management
30HRPADD3Additional Data PADD35FUNC_AREAApplication Componentnvarchar200
TOPOverhead Cost Controlling
31CMDT_CCGeneric Master Data: Cost Center Enhancements16FUNC_AREAFunctional Areanvarchar160
TOPOverhead Cost Orders
32AUFKOrder master data67FUNC_AREAFunctional Areanvarchar160
33T003OOrder Types25FUNC_AREAFunctional Areanvarchar160
TOPProduct Cost by Period
34CKPHMaster Record: Cost Object ID Number9FUNC_AREAFunctional Areanvarchar160
TOPProduction Orders
35AFVCOperation within an order170FUNC_AREAFunctional Areanvarchar160
TOPSimulation
36VSAFVC_CNVersion: Operation in order171FUNC_AREAFunctional Areanvarchar160
37VSAUFK_CNVersion: Order master data68FUNC_AREAFunctional Areanvarchar160
38VSPROJ_CNVersion: Project definition71FUNC_AREAFunctional Areanvarchar160
39VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data93FUNC_AREAFunctional Areanvarchar160
TOPTemplates
40PROJSStandard project definition71FUNC_AREAFunctional Areanvarchar160
41PRPSSStandard WBS Element (WBS element) - Master Data84FUNC_AREAFunctional Areanvarchar160
TOPTime Sheet
42CATSCOCross-Application Time Sheet (CATS): Transfer to CO38FUNC_AREAReceiving Functional Areanvarchar160
43CATSDBCATS: Database Table for Time Sheet23FUNC_AREAReceiving Functional Areanvarchar160
44CATS_TEMPCATS: Database Table for Templates25FUNC_AREAReceiving Functional Areanvarchar160
TOPTravel Expenses
45PTRV_SCOSTrip Statistics - Cost Assignment23FUNC_AREAFunctional Areanvarchar160