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

52 columns | Print definition?ERP 6.0  | NTYPEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/IFPIDSID Structure of Hierarchies: InfoObject Structure Element8NTYPEIDInternal ID for the Node Typeint100
2/B364/IMPITEMSSID Structure of Hierarchies: InfoObject Structure Element8NTYPEIDInternal ID for the Node Typeint100
3/B631/IACTTYPESID Structure of Hierarchies: InfoObject Activity Type8NTYPEIDInternal ID for the Node Typeint100
4/B631/ICOORDERSID Structure of Hierarchies: InfoObject Order8NTYPEIDInternal ID for the Node Typeint100
5/B631/ICOSTCNTRSID Structure of Hierarchies: InfoObject Cost Center8NTYPEIDInternal ID for the Node Typeint100
6/B631/ICOSTELMTSID Structure of Hierarchies: InfoObject Cost Element8NTYPEIDInternal ID for the Node Typeint100
7/B631/IPLANTSID Structure of Hierarchies: InfoObject Plant8NTYPEIDInternal ID for the Node Typeint100
8/B631/IPROFTCTRSID Structure of Hierarchies: InfoObject Profit Center8NTYPEIDInternal ID for the Node Typeint100
9/B631/IWBSELMTSID Structure of Hierarchies: InfoObject WBS Element8NTYPEIDInternal ID for the Node Typeint100
10/BI0/IBUCKETSID Structure of Hierarchies: InfoObject Directory of Precal8NTYPEIDInternal ID for the Node Typeint100
11/BI0/ICALMONTHSID Structure of Hierarchies: InfoObject Calendar Year/Month8NTYPEIDInternal ID for the Node Typeint100
12/BI0/ICALMONTH2SID Structure of Hierarchies: InfoObject Calendar month8NTYPEIDInternal ID for the Node Typeint100
13/BI0/IDATESID Structure of Hierarchies: InfoObject Date8NTYPEIDInternal ID for the Node Typeint100
14/BI0/IFISCPERSID Structure of Hierarchies: InfoObject Fiscal year/period8NTYPEIDInternal ID for the Node Typeint100
15/BI0/IHALFYEAR1SID Structure of Hierarchies: InfoObject Halfyear8NTYPEIDInternal ID for the Node Typeint100
16/BI0/IINFOPROVSID Structure of Hierarchies: InfoObject InfoProvider8NTYPEIDInternal ID for the Node Typeint100
17/BI0/IIOBJNMSID Structure of Hierarchies: InfoObject InfoObject8NTYPEIDInternal ID for the Node Typeint100
18/BI0/IRSPL_ORGSID Structure of Hierarchies: InfoObject Area of Responsibil8NTYPEIDInternal ID for the Node Typeint100
19/BI0/IRSTT_EIDSID Structure of Hierarchies: InfoObject Error ID8NTYPEIDInternal ID for the Node Typeint100
20/BI0/IRSTT_FTPCSID Structure of Hierarchies: InfoObject Function Subject8NTYPEIDInternal ID for the Node Typeint100
21/BI0/IRSTT_FUNCSID Structure of Hierarchies: InfoObject Functions8NTYPEIDInternal ID for the Node Typeint100
22/BI0/IRSTT_IONMSID Structure of Hierarchies: InfoObject InfoObject8NTYPEIDInternal ID for the Node Typeint100
23/BI0/IRSTT_IPBZMSID Structure of Hierarchies: InfoObject RTM for Non-Cum.8NTYPEIDInternal ID for the Node Typeint100
24/BI0/IRSTT_IPNMSID Structure of Hierarchies: InfoObject InfoProvider Name8NTYPEIDInternal ID for the Node Typeint100
25/BI0/IRSTT_JIDSID Structure of Hierarchies: InfoObject Job ID8NTYPEIDInternal ID for the Node Typeint100
26/BI0/IRSTT_OBJNMSID Structure of Hierarchies: InfoObject Object Name8NTYPEIDInternal ID for the Node Typeint100
27/BI0/IRSTT_PIDSID Structure of Hierarchies: InfoObject Trace Package ID8NTYPEIDInternal ID for the Node Typeint100
28/BI0/IRSTT_PVARSID Structure of Hierarchies: InfoObject Play Variant8NTYPEIDInternal ID for the Node Typeint100
29/BI0/IRSTT_QYNMSID Structure of Hierarchies: InfoObject Query Name8NTYPEIDInternal ID for the Node Typeint100
30/BI0/IRSTT_RQIDSID Structure of Hierarchies: InfoObject Test Request8NTYPEIDInternal ID for the Node Typeint100
31/BI0/IRSTT_RVARSID Structure of Hierarchies: InfoObject Ref. Data Variant8NTYPEIDInternal ID for the Node Typeint100
32/BI0/IRSTT_SAPCPSID Structure of Hierarchies: InfoObject SAP Component8NTYPEIDInternal ID for the Node Typeint100
33/BI0/IRSTT_SVARISID Structure of Hierarchies: InfoObject Selection Variant8NTYPEIDInternal ID for the Node Typeint100
34/BI0/IRSTT_TIDSID Structure of Hierarchies: InfoObject Trace ID8NTYPEIDInternal ID for the Node Typeint100
35/BI0/IRSTT_TLAYSID Structure of Hierarchies: InfoObject Trace Layer8NTYPEIDInternal ID for the Node Typeint100
36/BI0/IRSTT_TOTYPSID Structure of Hierarchies: InfoObject Object Type (Transp8NTYPEIDInternal ID for the Node Typeint100
37/BI0/IRSTT_TRANRSID Structure of Hierarchies: InfoObject Transport Request8NTYPEIDInternal ID for the Node Typeint100
38/BI0/IRSTT_TRTGTSID Structure of Hierarchies: InfoObject Transport Target8NTYPEIDInternal ID for the Node Typeint100
39/BI0/IRSTT_USERSID Structure of Hierarchies: InfoObject Trace User8NTYPEIDInternal ID for the Node Typeint100
40/BI0/ITCAIFAREASID Structure of Hierarchies: InfoObject InfoArea Analys. Au8NTYPEIDInternal ID for the Node Typeint100
41/BI0/ITCTAPPLSID Structure of Hierarchies: InfoObject Appl. Component8NTYPEIDInternal ID for the Node Typeint100
42/BI0/ITCTBWOBJCTSID Structure of Hierarchies: InfoObject BI Object8NTYPEIDInternal ID for the Node Typeint100
43/BI0/ITCTIFAREASID Structure of Hierarchies: InfoObject InfoArea8NTYPEIDInternal ID for the Node Typeint100
44/BI0/ITCTMDXFCSID Structure of Hierarchies: InfoObject MDX Functions8NTYPEIDInternal ID for the Node Typeint100
45/BI0/ITCTPRCSCHNSID Structure of Hierarchies: InfoObject Process Chain ID8NTYPEIDInternal ID for the Node Typeint100
46/BI0/ITCTQUERIDSID Structure of Hierarchies: InfoObject Query (UID)8NTYPEIDInternal ID for the Node Typeint100
47/BI0/ITCTSOURSYSSID Structure of Hierarchies: InfoObject Source System8NTYPEIDInternal ID for the Node Typeint100
48/BI0/ITCTSTATEVTSID Structure of Hierarchies: InfoObject Statistics Event8NTYPEIDInternal ID for the Node Typeint100
49/BI0/ITCTSYSIDSID Structure of Hierarchies: InfoObject BW System8NTYPEIDInternal ID for the Node Typeint100
50/BI0/ITCTUSERNMSID Structure of Hierarchies: InfoObject User8NTYPEIDInternal ID for the Node Typeint100
51/BI0/ITCTUSRNMSID Structure of Hierarchies: InfoObject User ID8NTYPEIDInternal ID for the Node Typeint100
TOPMetadata Repository
52RSDMINCTABModel table: SID structure of the hierarchies of a charact.8NTYPEIDInternal ID for the Node Typeint100