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  | LINKNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/KFPIDConversion of Hierarchy Nodes - SID: InfoObject Structure El4LINKNOLink numbernvarchar40
2/B364/KMPITEMSConversion of Hierarchy Nodes - SID: InfoObject Structure El4LINKNOLink numbernvarchar40
3/B631/KACTTYPEConversion of Hierarchy Nodes - SID: InfoObject Activity Typ4LINKNOLink numbernvarchar40
4/B631/KCOORDERConversion of Hierarchy Nodes - SID: InfoObject Order4LINKNOLink numbernvarchar40
5/B631/KCOSTCNTRConversion of Hierarchy Nodes - SID: InfoObject Cost Center4LINKNOLink numbernvarchar40
6/B631/KCOSTELMTConversion of Hierarchy Nodes - SID: InfoObject Cost Element4LINKNOLink numbernvarchar40
7/B631/KPLANTConversion of Hierarchy Nodes - SID: InfoObject Plant4LINKNOLink numbernvarchar40
8/B631/KPROFTCTRConversion of Hierarchy Nodes - SID: InfoObject Profit Cente4LINKNOLink numbernvarchar40
9/B631/KWBSELMTConversion of Hierarchy Nodes - SID: InfoObject WBS Element4LINKNOLink numbernvarchar40
10/BI0/KBUCKETConversion of Hierarchy Nodes - SID: InfoObject Directory of4LINKNOLink numbernvarchar40
11/BI0/KCALMONTHConversion of Hierarchy Nodes - SID: InfoObject Calendar Yea4LINKNOLink numbernvarchar40
12/BI0/KCALMONTH2Conversion of Hierarchy Nodes - SID: InfoObject Calendar mon4LINKNOLink numbernvarchar40
13/BI0/KDATEConversion of Hierarchy Nodes - SID: InfoObject Date4LINKNOLink numbernvarchar40
14/BI0/KFISCPERConversion of Hierarchy Nodes - SID: InfoObject Fiscal year/4LINKNOLink numbernvarchar40
15/BI0/KHALFYEAR1Conversion of Hierarchy Nodes - SID: InfoObject Halfyear4LINKNOLink numbernvarchar40
16/BI0/KINFOPROVConversion of Hierarchy Nodes - SID: InfoObject InfoProvider4LINKNOLink numbernvarchar40
17/BI0/KIOBJNMConversion of Hierarchy Nodes - SID: InfoObject InfoObject4LINKNOLink numbernvarchar40
18/BI0/KRSPL_ORGConversion of Hierarchy Nodes - SID: InfoObject Area of Resp4LINKNOLink numbernvarchar40
19/BI0/KRSTT_EIDConversion of Hierarchy Nodes - SID: InfoObject Error ID4LINKNOLink numbernvarchar40
20/BI0/KRSTT_FTPCConversion of Hierarchy Nodes - SID: InfoObject Function Sub4LINKNOLink numbernvarchar40
21/BI0/KRSTT_FUNCConversion of Hierarchy Nodes - SID: InfoObject Functions4LINKNOLink numbernvarchar40
22/BI0/KRSTT_IONMConversion of Hierarchy Nodes - SID: InfoObject InfoObject4LINKNOLink numbernvarchar40
23/BI0/KRSTT_IPBZMConversion of Hierarchy Nodes - SID: InfoObject RTM for Non-4LINKNOLink numbernvarchar40
24/BI0/KRSTT_IPNMConversion of Hierarchy Nodes - SID: InfoObject InfoProvider4LINKNOLink numbernvarchar40
25/BI0/KRSTT_JIDConversion of Hierarchy Nodes - SID: InfoObject Job ID4LINKNOLink numbernvarchar40
26/BI0/KRSTT_OBJNMConversion of Hierarchy Nodes - SID: InfoObject Object Name4LINKNOLink numbernvarchar40
27/BI0/KRSTT_PIDConversion of Hierarchy Nodes - SID: InfoObject Trace Packag4LINKNOLink numbernvarchar40
28/BI0/KRSTT_PVARConversion of Hierarchy Nodes - SID: InfoObject Play Variant4LINKNOLink numbernvarchar40
29/BI0/KRSTT_QYNMConversion of Hierarchy Nodes - SID: InfoObject Query Name4LINKNOLink numbernvarchar40
30/BI0/KRSTT_RQIDConversion of Hierarchy Nodes - SID: InfoObject Test Request4LINKNOLink numbernvarchar40
31/BI0/KRSTT_RVARConversion of Hierarchy Nodes - SID: InfoObject Ref. Data Va4LINKNOLink numbernvarchar40
32/BI0/KRSTT_SAPCPConversion of Hierarchy Nodes - SID: InfoObject SAP Componen4LINKNOLink numbernvarchar40
33/BI0/KRSTT_SVARIConversion of Hierarchy Nodes - SID: InfoObject Selection Va4LINKNOLink numbernvarchar40
34/BI0/KRSTT_TIDConversion of Hierarchy Nodes - SID: InfoObject Trace ID4LINKNOLink numbernvarchar40
35/BI0/KRSTT_TLAYConversion of Hierarchy Nodes - SID: InfoObject Trace Layer4LINKNOLink numbernvarchar40
36/BI0/KRSTT_TOTYPConversion of Hierarchy Nodes - SID: InfoObject Object Type4LINKNOLink numbernvarchar40
37/BI0/KRSTT_TRANRConversion of Hierarchy Nodes - SID: InfoObject Transport Re4LINKNOLink numbernvarchar40
38/BI0/KRSTT_TRTGTConversion of Hierarchy Nodes - SID: InfoObject Transport Ta4LINKNOLink numbernvarchar40
39/BI0/KRSTT_USERConversion of Hierarchy Nodes - SID: InfoObject Trace User4LINKNOLink numbernvarchar40
40/BI0/KTCAIFAREAConversion of Hierarchy Nodes - SID: InfoObject InfoArea Ana4LINKNOLink numbernvarchar40
41/BI0/KTCTAPPLConversion of Hierarchy Nodes - SID: InfoObject Appl. Compon4LINKNOLink numbernvarchar40
42/BI0/KTCTBWOBJCTConversion of Hierarchy Nodes - SID: InfoObject BI Object4LINKNOLink numbernvarchar40
43/BI0/KTCTIFAREAConversion of Hierarchy Nodes - SID: InfoObject InfoArea4LINKNOLink numbernvarchar40
44/BI0/KTCTMDXFCConversion of Hierarchy Nodes - SID: InfoObject MDX Function4LINKNOLink numbernvarchar40
45/BI0/KTCTPRCSCHNConversion of Hierarchy Nodes - SID: InfoObject Process Chai4LINKNOLink numbernvarchar40
46/BI0/KTCTQUERIDConversion of Hierarchy Nodes - SID: InfoObject Query (UID)4LINKNOLink numbernvarchar40
47/BI0/KTCTSOURSYSConversion of Hierarchy Nodes - SID: InfoObject Source Syste4LINKNOLink numbernvarchar40
48/BI0/KTCTSTATEVTConversion of Hierarchy Nodes - SID: InfoObject Statistics E4LINKNOLink numbernvarchar40
49/BI0/KTCTSYSIDConversion of Hierarchy Nodes - SID: InfoObject BW System4LINKNOLink numbernvarchar40
50/BI0/KTCTUSERNMConversion of Hierarchy Nodes - SID: InfoObject User4LINKNOLink numbernvarchar40
51/BI0/KTCTUSRNMConversion of Hierarchy Nodes - SID: InfoObject User ID4LINKNOLink numbernvarchar40
52RSDMHSITAB740Model table: Conversion of hierarchy nodes - SID4LINKNOLink numbernvarchar40
TOPAlert Framework
53SALRTCFLWAlerts: Follow-On Activities of the Alert Category3LINKNOSequence Number of Subsequent Activityint100
54SALRTCFLWTAlerts: Text Table for Follow-On Activities of Alert Categ.3LINKNOSequence Number of Subsequent Activityint100
TOPMetadata Repository
55RSDMHSITABObsolete from APOLLO ->RSDMHSITABNEW4LINKNOLink numbernvarchar40
56RSDMHSITABNEWModel table: Conversion of hierarchy nodes - SID4LINKNOLink numbernvarchar40
57RSDMHSITABTHJModel Table: Conversion Hierarchy Nodes - SID (THJ)4LINKNOLink numbernvarchar40