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

123 columns | Print definition?ERP 6.0  | HIESID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/IFPIDSID Structure of Hierarchies: InfoObject Structure Element1HIESIDSID for Hierarchy IDint100
2/B364/IMPITEMSSID Structure of Hierarchies: InfoObject Structure Element1HIESIDSID for Hierarchy IDint100
3/B364/KFPIDConversion of Hierarchy Nodes - SID: InfoObject Structure El1HIESIDSID for Hierarchy IDint100
4/B364/KMPITEMSConversion of Hierarchy Nodes - SID: InfoObject Structure El1HIESIDSID for Hierarchy IDint100
5/B631/IACTTYPESID Structure of Hierarchies: InfoObject Activity Type1HIESIDSID for Hierarchy IDint100
6/B631/ICOORDERSID Structure of Hierarchies: InfoObject Order1HIESIDSID for Hierarchy IDint100
7/B631/ICOSTCNTRSID Structure of Hierarchies: InfoObject Cost Center1HIESIDSID for Hierarchy IDint100
8/B631/ICOSTELMTSID Structure of Hierarchies: InfoObject Cost Element1HIESIDSID for Hierarchy IDint100
9/B631/IPLANTSID Structure of Hierarchies: InfoObject Plant1HIESIDSID for Hierarchy IDint100
10/B631/IPROFTCTRSID Structure of Hierarchies: InfoObject Profit Center1HIESIDSID for Hierarchy IDint100
11/B631/IWBSELMTSID Structure of Hierarchies: InfoObject WBS Element1HIESIDSID for Hierarchy IDint100
12/B631/KACTTYPEConversion of Hierarchy Nodes - SID: InfoObject Activity Typ1HIESIDSID for Hierarchy IDint100
13/B631/KCOORDERConversion of Hierarchy Nodes - SID: InfoObject Order1HIESIDSID for Hierarchy IDint100
14/B631/KCOSTCNTRConversion of Hierarchy Nodes - SID: InfoObject Cost Center1HIESIDSID for Hierarchy IDint100
15/B631/KCOSTELMTConversion of Hierarchy Nodes - SID: InfoObject Cost Element1HIESIDSID for Hierarchy IDint100
16/B631/KPLANTConversion of Hierarchy Nodes - SID: InfoObject Plant1HIESIDSID for Hierarchy IDint100
17/B631/KPROFTCTRConversion of Hierarchy Nodes - SID: InfoObject Profit Cente1HIESIDSID for Hierarchy IDint100
18/B631/KWBSELMTConversion of Hierarchy Nodes - SID: InfoObject WBS Element1HIESIDSID for Hierarchy IDint100
19/BI0/IBUCKETSID Structure of Hierarchies: InfoObject Directory of Precal1HIESIDSID for Hierarchy IDint100
20/BI0/ICALMONTHSID Structure of Hierarchies: InfoObject Calendar Year/Month1HIESIDSID for Hierarchy IDint100
21/BI0/ICALMONTH2SID Structure of Hierarchies: InfoObject Calendar month1HIESIDSID for Hierarchy IDint100
22/BI0/IDATESID Structure of Hierarchies: InfoObject Date1HIESIDSID for Hierarchy IDint100
23/BI0/IFISCPERSID Structure of Hierarchies: InfoObject Fiscal year/period1HIESIDSID for Hierarchy IDint100
24/BI0/IHALFYEAR1SID Structure of Hierarchies: InfoObject Halfyear1HIESIDSID for Hierarchy IDint100
25/BI0/IINFOPROVSID Structure of Hierarchies: InfoObject InfoProvider1HIESIDSID for Hierarchy IDint100
26/BI0/IIOBJNMSID Structure of Hierarchies: InfoObject InfoObject1HIESIDSID for Hierarchy IDint100
27/BI0/IRSPL_ORGSID Structure of Hierarchies: InfoObject Area of Responsibil1HIESIDSID for Hierarchy IDint100
28/BI0/IRSTT_EIDSID Structure of Hierarchies: InfoObject Error ID1HIESIDSID for Hierarchy IDint100
29/BI0/IRSTT_FTPCSID Structure of Hierarchies: InfoObject Function Subject1HIESIDSID for Hierarchy IDint100
30/BI0/IRSTT_FUNCSID Structure of Hierarchies: InfoObject Functions1HIESIDSID for Hierarchy IDint100
31/BI0/IRSTT_IONMSID Structure of Hierarchies: InfoObject InfoObject1HIESIDSID for Hierarchy IDint100
32/BI0/IRSTT_IPBZMSID Structure of Hierarchies: InfoObject RTM for Non-Cum.1HIESIDSID for Hierarchy IDint100
33/BI0/IRSTT_IPNMSID Structure of Hierarchies: InfoObject InfoProvider Name1HIESIDSID for Hierarchy IDint100
34/BI0/IRSTT_JIDSID Structure of Hierarchies: InfoObject Job ID1HIESIDSID for Hierarchy IDint100
35/BI0/IRSTT_OBJNMSID Structure of Hierarchies: InfoObject Object Name1HIESIDSID for Hierarchy IDint100
36/BI0/IRSTT_PIDSID Structure of Hierarchies: InfoObject Trace Package ID1HIESIDSID for Hierarchy IDint100
37/BI0/IRSTT_PVARSID Structure of Hierarchies: InfoObject Play Variant1HIESIDSID for Hierarchy IDint100
38/BI0/IRSTT_QYNMSID Structure of Hierarchies: InfoObject Query Name1HIESIDSID for Hierarchy IDint100
39/BI0/IRSTT_RQIDSID Structure of Hierarchies: InfoObject Test Request1HIESIDSID for Hierarchy IDint100
40/BI0/IRSTT_RVARSID Structure of Hierarchies: InfoObject Ref. Data Variant1HIESIDSID for Hierarchy IDint100
41/BI0/IRSTT_SAPCPSID Structure of Hierarchies: InfoObject SAP Component1HIESIDSID for Hierarchy IDint100
42/BI0/IRSTT_SVARISID Structure of Hierarchies: InfoObject Selection Variant1HIESIDSID for Hierarchy IDint100
43/BI0/IRSTT_TIDSID Structure of Hierarchies: InfoObject Trace ID1HIESIDSID for Hierarchy IDint100
44/BI0/IRSTT_TLAYSID Structure of Hierarchies: InfoObject Trace Layer1HIESIDSID for Hierarchy IDint100
45/BI0/IRSTT_TOTYPSID Structure of Hierarchies: InfoObject Object Type (Transp1HIESIDSID for Hierarchy IDint100
46/BI0/IRSTT_TRANRSID Structure of Hierarchies: InfoObject Transport Request1HIESIDSID for Hierarchy IDint100
47/BI0/IRSTT_TRTGTSID Structure of Hierarchies: InfoObject Transport Target1HIESIDSID for Hierarchy IDint100
48/BI0/IRSTT_USERSID Structure of Hierarchies: InfoObject Trace User1HIESIDSID for Hierarchy IDint100
49/BI0/ITCAIFAREASID Structure of Hierarchies: InfoObject InfoArea Analys. Au1HIESIDSID for Hierarchy IDint100
50/BI0/ITCTAPPLSID Structure of Hierarchies: InfoObject Appl. Component1HIESIDSID for Hierarchy IDint100
51/BI0/ITCTBWOBJCTSID Structure of Hierarchies: InfoObject BI Object1HIESIDSID for Hierarchy IDint100
52/BI0/ITCTIFAREASID Structure of Hierarchies: InfoObject InfoArea1HIESIDSID for Hierarchy IDint100
53/BI0/ITCTMDXFCSID Structure of Hierarchies: InfoObject MDX Functions1HIESIDSID for Hierarchy IDint100
54/BI0/ITCTPRCSCHNSID Structure of Hierarchies: InfoObject Process Chain ID1HIESIDSID for Hierarchy IDint100
55/BI0/ITCTQUERIDSID Structure of Hierarchies: InfoObject Query (UID)1HIESIDSID for Hierarchy IDint100
56/BI0/ITCTSOURSYSSID Structure of Hierarchies: InfoObject Source System1HIESIDSID for Hierarchy IDint100
57/BI0/ITCTSTATEVTSID Structure of Hierarchies: InfoObject Statistics Event1HIESIDSID for Hierarchy IDint100
58/BI0/ITCTSYSIDSID Structure of Hierarchies: InfoObject BW System1HIESIDSID for Hierarchy IDint100
59/BI0/ITCTUSERNMSID Structure of Hierarchies: InfoObject User1HIESIDSID for Hierarchy IDint100
60/BI0/ITCTUSRNMSID Structure of Hierarchies: InfoObject User ID1HIESIDSID for Hierarchy IDint100
61/BI0/KBUCKETConversion of Hierarchy Nodes - SID: InfoObject Directory of1HIESIDSID for Hierarchy IDint100
62/BI0/KCALMONTHConversion of Hierarchy Nodes - SID: InfoObject Calendar Yea1HIESIDSID for Hierarchy IDint100
63/BI0/KCALMONTH2Conversion of Hierarchy Nodes - SID: InfoObject Calendar mon1HIESIDSID for Hierarchy IDint100
64/BI0/KDATEConversion of Hierarchy Nodes - SID: InfoObject Date1HIESIDSID for Hierarchy IDint100
65/BI0/KFISCPERConversion of Hierarchy Nodes - SID: InfoObject Fiscal year/1HIESIDSID for Hierarchy IDint100
66/BI0/KHALFYEAR1Conversion of Hierarchy Nodes - SID: InfoObject Halfyear1HIESIDSID for Hierarchy IDint100
67/BI0/KINFOPROVConversion of Hierarchy Nodes - SID: InfoObject InfoProvider1HIESIDSID for Hierarchy IDint100
68/BI0/KIOBJNMConversion of Hierarchy Nodes - SID: InfoObject InfoObject1HIESIDSID for Hierarchy IDint100
69/BI0/KRSPL_ORGConversion of Hierarchy Nodes - SID: InfoObject Area of Resp1HIESIDSID for Hierarchy IDint100
70/BI0/KRSTT_EIDConversion of Hierarchy Nodes - SID: InfoObject Error ID1HIESIDSID for Hierarchy IDint100
71/BI0/KRSTT_FTPCConversion of Hierarchy Nodes - SID: InfoObject Function Sub1HIESIDSID for Hierarchy IDint100
72/BI0/KRSTT_FUNCConversion of Hierarchy Nodes - SID: InfoObject Functions1HIESIDSID for Hierarchy IDint100
73/BI0/KRSTT_IONMConversion of Hierarchy Nodes - SID: InfoObject InfoObject1HIESIDSID for Hierarchy IDint100
74/BI0/KRSTT_IPBZMConversion of Hierarchy Nodes - SID: InfoObject RTM for Non-1HIESIDSID for Hierarchy IDint100
75/BI0/KRSTT_IPNMConversion of Hierarchy Nodes - SID: InfoObject InfoProvider1HIESIDSID for Hierarchy IDint100
76/BI0/KRSTT_JIDConversion of Hierarchy Nodes - SID: InfoObject Job ID1HIESIDSID for Hierarchy IDint100
77/BI0/KRSTT_OBJNMConversion of Hierarchy Nodes - SID: InfoObject Object Name1HIESIDSID for Hierarchy IDint100
78/BI0/KRSTT_PIDConversion of Hierarchy Nodes - SID: InfoObject Trace Packag1HIESIDSID for Hierarchy IDint100
79/BI0/KRSTT_PVARConversion of Hierarchy Nodes - SID: InfoObject Play Variant1HIESIDSID for Hierarchy IDint100
80/BI0/KRSTT_QYNMConversion of Hierarchy Nodes - SID: InfoObject Query Name1HIESIDSID for Hierarchy IDint100
81/BI0/KRSTT_RQIDConversion of Hierarchy Nodes - SID: InfoObject Test Request1HIESIDSID for Hierarchy IDint100
82/BI0/KRSTT_RVARConversion of Hierarchy Nodes - SID: InfoObject Ref. Data Va1HIESIDSID for Hierarchy IDint100
83/BI0/KRSTT_SAPCPConversion of Hierarchy Nodes - SID: InfoObject SAP Componen1HIESIDSID for Hierarchy IDint100
84/BI0/KRSTT_SVARIConversion of Hierarchy Nodes - SID: InfoObject Selection Va1HIESIDSID for Hierarchy IDint100
85/BI0/KRSTT_TIDConversion of Hierarchy Nodes - SID: InfoObject Trace ID1HIESIDSID for Hierarchy IDint100
86/BI0/KRSTT_TLAYConversion of Hierarchy Nodes - SID: InfoObject Trace Layer1HIESIDSID for Hierarchy IDint100
87/BI0/KRSTT_TOTYPConversion of Hierarchy Nodes - SID: InfoObject Object Type1HIESIDSID for Hierarchy IDint100
88/BI0/KRSTT_TRANRConversion of Hierarchy Nodes - SID: InfoObject Transport Re1HIESIDSID for Hierarchy IDint100
89/BI0/KRSTT_TRTGTConversion of Hierarchy Nodes - SID: InfoObject Transport Ta1HIESIDSID for Hierarchy IDint100
90/BI0/KRSTT_USERConversion of Hierarchy Nodes - SID: InfoObject Trace User1HIESIDSID for Hierarchy IDint100
91/BI0/KTCAIFAREAConversion of Hierarchy Nodes - SID: InfoObject InfoArea Ana1HIESIDSID for Hierarchy IDint100
92/BI0/KTCTAPPLConversion of Hierarchy Nodes - SID: InfoObject Appl. Compon1HIESIDSID for Hierarchy IDint100
93/BI0/KTCTBWOBJCTConversion of Hierarchy Nodes - SID: InfoObject BI Object1HIESIDSID for Hierarchy IDint100
94/BI0/KTCTIFAREAConversion of Hierarchy Nodes - SID: InfoObject InfoArea1HIESIDSID for Hierarchy IDint100
95/BI0/KTCTMDXFCConversion of Hierarchy Nodes - SID: InfoObject MDX Function1HIESIDSID for Hierarchy IDint100
96/BI0/KTCTPRCSCHNConversion of Hierarchy Nodes - SID: InfoObject Process Chai1HIESIDSID for Hierarchy IDint100
97/BI0/KTCTQUERIDConversion of Hierarchy Nodes - SID: InfoObject Query (UID)1HIESIDSID for Hierarchy IDint100
98/BI0/KTCTSOURSYSConversion of Hierarchy Nodes - SID: InfoObject Source Syste1HIESIDSID for Hierarchy IDint100
99/BI0/KTCTSTATEVTConversion of Hierarchy Nodes - SID: InfoObject Statistics E1HIESIDSID for Hierarchy IDint100
100/BI0/KTCTSYSIDConversion of Hierarchy Nodes - SID: InfoObject BW System1HIESIDSID for Hierarchy IDint100
101/BI0/KTCTUSERNMConversion of Hierarchy Nodes - SID: InfoObject User1HIESIDSID for Hierarchy IDint100
102/BI0/KTCTUSRNMConversion of Hierarchy Nodes - SID: InfoObject User ID1HIESIDSID for Hierarchy IDint100
103RSDB2A_STA_HIEDB2 Accelerator: hierarchy status table4HIESIDMaster data IDint100
104RSDMHSITAB740Model table: Conversion of hierarchy nodes - SID1HIESIDSID for Hierarchy IDint100
105RSECHIE_STRINGStatus of Authorization Hierarchies5HIESIDSID for Hierarchy IDint100
106RSRHINTAB_OLAP_SHierarchy interval for the OLAP processor1HIESIDSID for Hierarchy IDint100
TOPMetadata Repository
107RSDMHSITABObsolete from APOLLO ->RSDMHSITABNEW1HIESIDSID for Hierarchy IDint100
108RSDMHSITABNEWModel table: Conversion of hierarchy nodes - SID1HIESIDSID for Hierarchy IDint100
109RSDMHSITABTHJModel Table: Conversion Hierarchy Nodes - SID (THJ)1HIESIDSID for Hierarchy IDint100
110RSDMINCTABModel table: SID structure of the hierarchies of a charact.1HIESIDSID for Hierarchy IDint100
TOPOLAP Technology
111RSDDAGGRCOMPDescription of the aggregates6HIESIDSID for Hierarchy IDint100
112RSDDSTATAGGRDEFStatistics data OLAP: Navigation step / aggregate definition9HIESIDMaster data IDint100
113RSDDTPS_HIER_IDXPolestar Hierarchy Indexes1HIESIDSID for Hierarchy IDint100
114RSDDTPS_HIER_IPAssignment of Hiers to InfoProvider/InfoObject Combination3HIESIDSID for Hierarchy IDint100
115RSDRHLRUBUFFERLRU-Buffer for the Hierarchy Processing1HIESIDMaster data IDint100
116RSDRHTREXBUFFERLRU-Buffer for the Hierarchy Processing1HIESIDMaster data IDint100
117RSECHIEStatus of Authorization Hierarchies4HIESIDSID for Hierarchy IDint100
118RSECHIE_CLAuthorization Hierarchies Changes Change Log8HIESIDSID for Hierarchy IDint100
119RSRHIEDIR_OLAPOLAP Relevant Information for the Hierarchies1HIESIDSID for Hierarchy IDint100
120RSRHIEDIR_SHORTStructure for Appropriate Lock Object for Hierarchies1HIESIDSID for Hierarchy IDint100
121RSRHIEDIR_TIMDEPTime Intervals with Time-Dependent Hierarchies1HIESIDSID for Hierarchy IDint100
122RSRHINTAB_OLAP(obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel1HIESIDSID for Hierarchy IDint100
123RSSAUTHHIERDefinition of the Authorizations for Hierarchies2HIESIDSID for Hierarchy IDint100