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

57 columns | Print definition?ERP 6.0  | LISTNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/IFPIDSID Structure of Hierarchies: InfoObject Structure Element5LISTNOSequence of the inclusion relationshipsint100
2/B364/IMPITEMSSID Structure of Hierarchies: InfoObject Structure Element5LISTNOSequence of the inclusion relationshipsint100
3/B631/IACTTYPESID Structure of Hierarchies: InfoObject Activity Type5LISTNOSequence of the inclusion relationshipsint100
4/B631/ICOORDERSID Structure of Hierarchies: InfoObject Order5LISTNOSequence of the inclusion relationshipsint100
5/B631/ICOSTCNTRSID Structure of Hierarchies: InfoObject Cost Center5LISTNOSequence of the inclusion relationshipsint100
6/B631/ICOSTELMTSID Structure of Hierarchies: InfoObject Cost Element5LISTNOSequence of the inclusion relationshipsint100
7/B631/IPLANTSID Structure of Hierarchies: InfoObject Plant5LISTNOSequence of the inclusion relationshipsint100
8/B631/IPROFTCTRSID Structure of Hierarchies: InfoObject Profit Center5LISTNOSequence of the inclusion relationshipsint100
9/B631/IWBSELMTSID Structure of Hierarchies: InfoObject WBS Element5LISTNOSequence of the inclusion relationshipsint100
10/BI0/IBUCKETSID Structure of Hierarchies: InfoObject Directory of Precal5LISTNOSequence of the inclusion relationshipsint100
11/BI0/ICALMONTHSID Structure of Hierarchies: InfoObject Calendar Year/Month5LISTNOSequence of the inclusion relationshipsint100
12/BI0/ICALMONTH2SID Structure of Hierarchies: InfoObject Calendar month5LISTNOSequence of the inclusion relationshipsint100
13/BI0/IDATESID Structure of Hierarchies: InfoObject Date5LISTNOSequence of the inclusion relationshipsint100
14/BI0/IFISCPERSID Structure of Hierarchies: InfoObject Fiscal year/period5LISTNOSequence of the inclusion relationshipsint100
15/BI0/IHALFYEAR1SID Structure of Hierarchies: InfoObject Halfyear5LISTNOSequence of the inclusion relationshipsint100
16/BI0/IINFOPROVSID Structure of Hierarchies: InfoObject InfoProvider5LISTNOSequence of the inclusion relationshipsint100
17/BI0/IIOBJNMSID Structure of Hierarchies: InfoObject InfoObject5LISTNOSequence of the inclusion relationshipsint100
18/BI0/IRSPL_ORGSID Structure of Hierarchies: InfoObject Area of Responsibil5LISTNOSequence of the inclusion relationshipsint100
19/BI0/IRSTT_EIDSID Structure of Hierarchies: InfoObject Error ID5LISTNOSequence of the inclusion relationshipsint100
20/BI0/IRSTT_FTPCSID Structure of Hierarchies: InfoObject Function Subject5LISTNOSequence of the inclusion relationshipsint100
21/BI0/IRSTT_FUNCSID Structure of Hierarchies: InfoObject Functions5LISTNOSequence of the inclusion relationshipsint100
22/BI0/IRSTT_IONMSID Structure of Hierarchies: InfoObject InfoObject5LISTNOSequence of the inclusion relationshipsint100
23/BI0/IRSTT_IPBZMSID Structure of Hierarchies: InfoObject RTM for Non-Cum.5LISTNOSequence of the inclusion relationshipsint100
24/BI0/IRSTT_IPNMSID Structure of Hierarchies: InfoObject InfoProvider Name5LISTNOSequence of the inclusion relationshipsint100
25/BI0/IRSTT_JIDSID Structure of Hierarchies: InfoObject Job ID5LISTNOSequence of the inclusion relationshipsint100
26/BI0/IRSTT_OBJNMSID Structure of Hierarchies: InfoObject Object Name5LISTNOSequence of the inclusion relationshipsint100
27/BI0/IRSTT_PIDSID Structure of Hierarchies: InfoObject Trace Package ID5LISTNOSequence of the inclusion relationshipsint100
28/BI0/IRSTT_PVARSID Structure of Hierarchies: InfoObject Play Variant5LISTNOSequence of the inclusion relationshipsint100
29/BI0/IRSTT_QYNMSID Structure of Hierarchies: InfoObject Query Name5LISTNOSequence of the inclusion relationshipsint100
30/BI0/IRSTT_RQIDSID Structure of Hierarchies: InfoObject Test Request5LISTNOSequence of the inclusion relationshipsint100
31/BI0/IRSTT_RVARSID Structure of Hierarchies: InfoObject Ref. Data Variant5LISTNOSequence of the inclusion relationshipsint100
32/BI0/IRSTT_SAPCPSID Structure of Hierarchies: InfoObject SAP Component5LISTNOSequence of the inclusion relationshipsint100
33/BI0/IRSTT_SVARISID Structure of Hierarchies: InfoObject Selection Variant5LISTNOSequence of the inclusion relationshipsint100
34/BI0/IRSTT_TIDSID Structure of Hierarchies: InfoObject Trace ID5LISTNOSequence of the inclusion relationshipsint100
35/BI0/IRSTT_TLAYSID Structure of Hierarchies: InfoObject Trace Layer5LISTNOSequence of the inclusion relationshipsint100
36/BI0/IRSTT_TOTYPSID Structure of Hierarchies: InfoObject Object Type (Transp5LISTNOSequence of the inclusion relationshipsint100
37/BI0/IRSTT_TRANRSID Structure of Hierarchies: InfoObject Transport Request5LISTNOSequence of the inclusion relationshipsint100
38/BI0/IRSTT_TRTGTSID Structure of Hierarchies: InfoObject Transport Target5LISTNOSequence of the inclusion relationshipsint100
39/BI0/IRSTT_USERSID Structure of Hierarchies: InfoObject Trace User5LISTNOSequence of the inclusion relationshipsint100
40/BI0/ITCAIFAREASID Structure of Hierarchies: InfoObject InfoArea Analys. Au5LISTNOSequence of the inclusion relationshipsint100
41/BI0/ITCTAPPLSID Structure of Hierarchies: InfoObject Appl. Component5LISTNOSequence of the inclusion relationshipsint100
42/BI0/ITCTBWOBJCTSID Structure of Hierarchies: InfoObject BI Object5LISTNOSequence of the inclusion relationshipsint100
43/BI0/ITCTIFAREASID Structure of Hierarchies: InfoObject InfoArea5LISTNOSequence of the inclusion relationshipsint100
44/BI0/ITCTMDXFCSID Structure of Hierarchies: InfoObject MDX Functions5LISTNOSequence of the inclusion relationshipsint100
45/BI0/ITCTPRCSCHNSID Structure of Hierarchies: InfoObject Process Chain ID5LISTNOSequence of the inclusion relationshipsint100
46/BI0/ITCTQUERIDSID Structure of Hierarchies: InfoObject Query (UID)5LISTNOSequence of the inclusion relationshipsint100
47/BI0/ITCTSOURSYSSID Structure of Hierarchies: InfoObject Source System5LISTNOSequence of the inclusion relationshipsint100
48/BI0/ITCTSTATEVTSID Structure of Hierarchies: InfoObject Statistics Event5LISTNOSequence of the inclusion relationshipsint100
49/BI0/ITCTSYSIDSID Structure of Hierarchies: InfoObject BW System5LISTNOSequence of the inclusion relationshipsint100
50/BI0/ITCTUSERNMSID Structure of Hierarchies: InfoObject User5LISTNOSequence of the inclusion relationshipsint100
51/BI0/ITCTUSRNMSID Structure of Hierarchies: InfoObject User ID5LISTNOSequence of the inclusion relationshipsint100
52RSRHINTAB_OLAP_SHierarchy interval for the OLAP processor4LISTNOSequence of the inclusion relationshipsint100
TOPBank Customer Accounts
53TBKK10BCA Lists2LISTNOList Number of Programnvarchar30
54TBKK10TBCA Lists: Texts3LISTNOList Number of Programnvarchar30
55TBKK11BCA Lists: Field Catalog for List Tool (KKBLO_FIELDCAT)2LISTNOList Number of Programnvarchar30
TOPMetadata Repository
56RSDMINCTABModel table: SID structure of the hierarchies of a charact.5LISTNOSequence of the inclusion relationshipsint100
TOPOLAP Technology
57RSRHINTAB_OLAP(obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel6LISTNOSequence of the inclusion relationshipsint100