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

60 columns | Print definition?ERP 6.0  | SVER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/IFPIDSID Structure of Hierarchies: InfoObject Structure Element2SVERVersion in Inclusion Table Keynvarchar10
2/B364/IMPITEMSSID Structure of Hierarchies: InfoObject Structure Element2SVERVersion in Inclusion Table Keynvarchar10
3/B631/IACTTYPESID Structure of Hierarchies: InfoObject Activity Type2SVERVersion in Inclusion Table Keynvarchar10
4/B631/ICOORDERSID Structure of Hierarchies: InfoObject Order2SVERVersion in Inclusion Table Keynvarchar10
5/B631/ICOSTCNTRSID Structure of Hierarchies: InfoObject Cost Center2SVERVersion in Inclusion Table Keynvarchar10
6/B631/ICOSTELMTSID Structure of Hierarchies: InfoObject Cost Element2SVERVersion in Inclusion Table Keynvarchar10
7/B631/IPLANTSID Structure of Hierarchies: InfoObject Plant2SVERVersion in Inclusion Table Keynvarchar10
8/B631/IPROFTCTRSID Structure of Hierarchies: InfoObject Profit Center2SVERVersion in Inclusion Table Keynvarchar10
9/B631/IWBSELMTSID Structure of Hierarchies: InfoObject WBS Element2SVERVersion in Inclusion Table Keynvarchar10
10/BI0/IBUCKETSID Structure of Hierarchies: InfoObject Directory of Precal2SVERVersion in Inclusion Table Keynvarchar10
11/BI0/ICALMONTHSID Structure of Hierarchies: InfoObject Calendar Year/Month2SVERVersion in Inclusion Table Keynvarchar10
12/BI0/ICALMONTH2SID Structure of Hierarchies: InfoObject Calendar month2SVERVersion in Inclusion Table Keynvarchar10
13/BI0/IDATESID Structure of Hierarchies: InfoObject Date2SVERVersion in Inclusion Table Keynvarchar10
14/BI0/IFISCPERSID Structure of Hierarchies: InfoObject Fiscal year/period2SVERVersion in Inclusion Table Keynvarchar10
15/BI0/IHALFYEAR1SID Structure of Hierarchies: InfoObject Halfyear2SVERVersion in Inclusion Table Keynvarchar10
16/BI0/IINFOPROVSID Structure of Hierarchies: InfoObject InfoProvider2SVERVersion in Inclusion Table Keynvarchar10
17/BI0/IIOBJNMSID Structure of Hierarchies: InfoObject InfoObject2SVERVersion in Inclusion Table Keynvarchar10
18/BI0/IRSPL_ORGSID Structure of Hierarchies: InfoObject Area of Responsibil2SVERVersion in Inclusion Table Keynvarchar10
19/BI0/IRSTT_EIDSID Structure of Hierarchies: InfoObject Error ID2SVERVersion in Inclusion Table Keynvarchar10
20/BI0/IRSTT_FTPCSID Structure of Hierarchies: InfoObject Function Subject2SVERVersion in Inclusion Table Keynvarchar10
21/BI0/IRSTT_FUNCSID Structure of Hierarchies: InfoObject Functions2SVERVersion in Inclusion Table Keynvarchar10
22/BI0/IRSTT_IONMSID Structure of Hierarchies: InfoObject InfoObject2SVERVersion in Inclusion Table Keynvarchar10
23/BI0/IRSTT_IPBZMSID Structure of Hierarchies: InfoObject RTM for Non-Cum.2SVERVersion in Inclusion Table Keynvarchar10
24/BI0/IRSTT_IPNMSID Structure of Hierarchies: InfoObject InfoProvider Name2SVERVersion in Inclusion Table Keynvarchar10
25/BI0/IRSTT_JIDSID Structure of Hierarchies: InfoObject Job ID2SVERVersion in Inclusion Table Keynvarchar10
26/BI0/IRSTT_OBJNMSID Structure of Hierarchies: InfoObject Object Name2SVERVersion in Inclusion Table Keynvarchar10
27/BI0/IRSTT_PIDSID Structure of Hierarchies: InfoObject Trace Package ID2SVERVersion in Inclusion Table Keynvarchar10
28/BI0/IRSTT_PVARSID Structure of Hierarchies: InfoObject Play Variant2SVERVersion in Inclusion Table Keynvarchar10
29/BI0/IRSTT_QYNMSID Structure of Hierarchies: InfoObject Query Name2SVERVersion in Inclusion Table Keynvarchar10
30/BI0/IRSTT_RQIDSID Structure of Hierarchies: InfoObject Test Request2SVERVersion in Inclusion Table Keynvarchar10
31/BI0/IRSTT_RVARSID Structure of Hierarchies: InfoObject Ref. Data Variant2SVERVersion in Inclusion Table Keynvarchar10
32/BI0/IRSTT_SAPCPSID Structure of Hierarchies: InfoObject SAP Component2SVERVersion in Inclusion Table Keynvarchar10
33/BI0/IRSTT_SVARISID Structure of Hierarchies: InfoObject Selection Variant2SVERVersion in Inclusion Table Keynvarchar10
34/BI0/IRSTT_TIDSID Structure of Hierarchies: InfoObject Trace ID2SVERVersion in Inclusion Table Keynvarchar10
35/BI0/IRSTT_TLAYSID Structure of Hierarchies: InfoObject Trace Layer2SVERVersion in Inclusion Table Keynvarchar10
36/BI0/IRSTT_TOTYPSID Structure of Hierarchies: InfoObject Object Type (Transp2SVERVersion in Inclusion Table Keynvarchar10
37/BI0/IRSTT_TRANRSID Structure of Hierarchies: InfoObject Transport Request2SVERVersion in Inclusion Table Keynvarchar10
38/BI0/IRSTT_TRTGTSID Structure of Hierarchies: InfoObject Transport Target2SVERVersion in Inclusion Table Keynvarchar10
39/BI0/IRSTT_USERSID Structure of Hierarchies: InfoObject Trace User2SVERVersion in Inclusion Table Keynvarchar10
40/BI0/ITCAIFAREASID Structure of Hierarchies: InfoObject InfoArea Analys. Au2SVERVersion in Inclusion Table Keynvarchar10
41/BI0/ITCTAPPLSID Structure of Hierarchies: InfoObject Appl. Component2SVERVersion in Inclusion Table Keynvarchar10
42/BI0/ITCTBWOBJCTSID Structure of Hierarchies: InfoObject BI Object2SVERVersion in Inclusion Table Keynvarchar10
43/BI0/ITCTIFAREASID Structure of Hierarchies: InfoObject InfoArea2SVERVersion in Inclusion Table Keynvarchar10
44/BI0/ITCTMDXFCSID Structure of Hierarchies: InfoObject MDX Functions2SVERVersion in Inclusion Table Keynvarchar10
45/BI0/ITCTPRCSCHNSID Structure of Hierarchies: InfoObject Process Chain ID2SVERVersion in Inclusion Table Keynvarchar10
46/BI0/ITCTQUERIDSID Structure of Hierarchies: InfoObject Query (UID)2SVERVersion in Inclusion Table Keynvarchar10
47/BI0/ITCTSOURSYSSID Structure of Hierarchies: InfoObject Source System2SVERVersion in Inclusion Table Keynvarchar10
48/BI0/ITCTSTATEVTSID Structure of Hierarchies: InfoObject Statistics Event2SVERVersion in Inclusion Table Keynvarchar10
49/BI0/ITCTSYSIDSID Structure of Hierarchies: InfoObject BW System2SVERVersion in Inclusion Table Keynvarchar10
50/BI0/ITCTUSERNMSID Structure of Hierarchies: InfoObject User2SVERVersion in Inclusion Table Keynvarchar10
51/BI0/ITCTUSRNMSID Structure of Hierarchies: InfoObject User ID2SVERVersion in Inclusion Table Keynvarchar10
52RSDB2A_STA_HIEDB2 Accelerator: hierarchy status table5SVERVersion in Inclusion Table Keynvarchar10
53RSRHINTAB_OLAP_SHierarchy interval for the OLAP processor2SVERVersion in Inclusion Table Keynvarchar10
TOPMetadata Repository
54RSDMINCTABModel table: SID structure of the hierarchies of a charact.2SVERVersion in Inclusion Table Keynvarchar10
TOPOLAP Technology
55RSDDTPS_HIER_IDXPolestar Hierarchy Indexes2SVERVersion in Inclusion Table Keynvarchar10
56RSDDTPS_HIER_IPAssignment of Hiers to InfoProvider/InfoObject Combination4SVERVersion in Inclusion Table Keynvarchar10
57RSDRHLRUBUFFERLRU-Buffer for the Hierarchy Processing2SVERVersion in Inclusion Table Keynvarchar10
58RSDRHTREXBUFFERLRU-Buffer for the Hierarchy Processing2SVERVersion in Inclusion Table Keynvarchar10
59RSRHIEDIR_OLAPOLAP Relevant Information for the Hierarchies6SVERVersion in Inclusion Table Keynvarchar10
60RSRHINTAB_OLAP(obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel2SVERVersion in Inclusion Table Keynvarchar10