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

67 columns | Print definition?ERP 6.0  | NEXTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/HFPIDHierarchy: InfoObject Structure Element10NEXTIDNext ID of a hierarchy nodenvarchar80
2/B364/HMPITEMSHierarchy: InfoObject Structure Element10NEXTIDNext ID of a hierarchy nodenvarchar80
3/B631/HACTTYPEHierarchy: InfoObject Activity Type10NEXTIDNext ID of a hierarchy nodenvarchar80
4/B631/HCOORDERHierarchy: InfoObject Order10NEXTIDNext ID of a hierarchy nodenvarchar80
5/B631/HCOSTCNTRHierarchy: InfoObject Cost Center10NEXTIDNext ID of a hierarchy nodenvarchar80
6/B631/HCOSTELMTHierarchy: InfoObject Cost Element10NEXTIDNext ID of a hierarchy nodenvarchar80
7/B631/HPLANTHierarchy: InfoObject Plant10NEXTIDNext ID of a hierarchy nodenvarchar80
8/B631/HPROFTCTRHierarchy: InfoObject Profit Center10NEXTIDNext ID of a hierarchy nodenvarchar80
9/B631/HWBSELMTHierarchy: InfoObject WBS Element10NEXTIDNext ID of a hierarchy nodenvarchar80
10/BI0/HBUCKETHierarchy: InfoObject Directory of Precalc10NEXTIDNext ID of a hierarchy nodenvarchar80
11/BI0/HCALMONTHHierarchy: InfoObject Calendar Year/Month10NEXTIDNext ID of a hierarchy nodenvarchar80
12/BI0/HCALMONTH2Hierarchy: InfoObject Calendar month10NEXTIDNext ID of a hierarchy nodenvarchar80
13/BI0/HDATEHierarchy: InfoObject Date10NEXTIDNext ID of a hierarchy nodenvarchar80
14/BI0/HFISCPERHierarchy: InfoObject Fiscal year/period10NEXTIDNext ID of a hierarchy nodenvarchar80
15/BI0/HHALFYEAR1Hierarchy: InfoObject Halfyear10NEXTIDNext ID of a hierarchy nodenvarchar80
16/BI0/HINFOPROVHierarchy: InfoObject InfoProvider10NEXTIDNext ID of a hierarchy nodenvarchar80
17/BI0/HIOBJNMHierarchy: InfoObject InfoObject10NEXTIDNext ID of a hierarchy nodenvarchar80
18/BI0/HRSPL_ORGHierarchy: InfoObject Area of Responsibil.10NEXTIDNext ID of a hierarchy nodenvarchar80
19/BI0/HRSTT_EIDHierarchy: InfoObject Error ID10NEXTIDNext ID of a hierarchy nodenvarchar80
20/BI0/HRSTT_FTPCHierarchy: InfoObject Function Subject10NEXTIDNext ID of a hierarchy nodenvarchar80
21/BI0/HRSTT_FUNCHierarchy: InfoObject Functions10NEXTIDNext ID of a hierarchy nodenvarchar80
22/BI0/HRSTT_IONMHierarchy: InfoObject InfoObject10NEXTIDNext ID of a hierarchy nodenvarchar80
23/BI0/HRSTT_IPBZMHierarchy: InfoObject RTM for Non-Cum.10NEXTIDNext ID of a hierarchy nodenvarchar80
24/BI0/HRSTT_IPNMHierarchy: InfoObject InfoProvider Name10NEXTIDNext ID of a hierarchy nodenvarchar80
25/BI0/HRSTT_JIDHierarchy: InfoObject Job ID10NEXTIDNext ID of a hierarchy nodenvarchar80
26/BI0/HRSTT_OBJNMHierarchy: InfoObject Object Name10NEXTIDNext ID of a hierarchy nodenvarchar80
27/BI0/HRSTT_PIDHierarchy: InfoObject Trace Package ID10NEXTIDNext ID of a hierarchy nodenvarchar80
28/BI0/HRSTT_PVARHierarchy: InfoObject Play Variant10NEXTIDNext ID of a hierarchy nodenvarchar80
29/BI0/HRSTT_QYNMHierarchy: InfoObject Query Name10NEXTIDNext ID of a hierarchy nodenvarchar80
30/BI0/HRSTT_RQIDHierarchy: InfoObject Test Request10NEXTIDNext ID of a hierarchy nodenvarchar80
31/BI0/HRSTT_RVARHierarchy: InfoObject Ref. Data Variant10NEXTIDNext ID of a hierarchy nodenvarchar80
32/BI0/HRSTT_SAPCPHierarchy: InfoObject SAP Component10NEXTIDNext ID of a hierarchy nodenvarchar80
33/BI0/HRSTT_SVARIHierarchy: InfoObject Selection Variant10NEXTIDNext ID of a hierarchy nodenvarchar80
34/BI0/HRSTT_TIDHierarchy: InfoObject Trace ID10NEXTIDNext ID of a hierarchy nodenvarchar80
35/BI0/HRSTT_TLAYHierarchy: InfoObject Trace Layer10NEXTIDNext ID of a hierarchy nodenvarchar80
36/BI0/HRSTT_TOTYPHierarchy: InfoObject Object Type (Transp)10NEXTIDNext ID of a hierarchy nodenvarchar80
37/BI0/HRSTT_TRANRHierarchy: InfoObject Transport Request10NEXTIDNext ID of a hierarchy nodenvarchar80
38/BI0/HRSTT_TRTGTHierarchy: InfoObject Transport Target10NEXTIDNext ID of a hierarchy nodenvarchar80
39/BI0/HRSTT_USERHierarchy: InfoObject Trace User10NEXTIDNext ID of a hierarchy nodenvarchar80
40/BI0/HTCAIFAREAHierarchy: InfoObject InfoArea Analys. Aut10NEXTIDNext ID of a hierarchy nodenvarchar80
41/BI0/HTCTAPPLHierarchy: InfoObject Appl. Component10NEXTIDNext ID of a hierarchy nodenvarchar80
42/BI0/HTCTBWOBJCTHierarchy: InfoObject BI Object10NEXTIDNext ID of a hierarchy nodenvarchar80
43/BI0/HTCTIFAREAHierarchy: InfoObject InfoArea10NEXTIDNext ID of a hierarchy nodenvarchar80
44/BI0/HTCTMDXFCHierarchy: InfoObject MDX Functions10NEXTIDNext ID of a hierarchy nodenvarchar80
45/BI0/HTCTPRCSCHNHierarchy: InfoObject Process Chain ID10NEXTIDNext ID of a hierarchy nodenvarchar80
46/BI0/HTCTQUERIDHierarchy: InfoObject Query (UID)10NEXTIDNext ID of a hierarchy nodenvarchar80
47/BI0/HTCTSOURSYSHierarchy: InfoObject Source System10NEXTIDNext ID of a hierarchy nodenvarchar80
48/BI0/HTCTSTATEVTHierarchy: InfoObject Statistics Event10NEXTIDNext ID of a hierarchy nodenvarchar80
49/BI0/HTCTSYSIDHierarchy: InfoObject BW System10NEXTIDNext ID of a hierarchy nodenvarchar80
50/BI0/HTCTUSERNMHierarchy: InfoObject User10NEXTIDNext ID of a hierarchy nodenvarchar80
51/BI0/HTCTUSRNMHierarchy: InfoObject User ID10NEXTIDNext ID of a hierarchy nodenvarchar80
52/BI0/SNEXTIDMaster Data IDs: InfoObject Next ID1NEXTIDNext ID of Node in Hierarchynvarchar80
53CMCBD_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)8NEXTIDNext ID for Hierarchy Nodenvarchar80
54CMCBD_ORG_RSOrganizational Hierarchy Relationship11NEXTIDNext ID of a hierarchy nodenvarchar80
55CMCB_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)6NEXTIDNext ID for Hierarchy Nodenvarchar80
56FCLM_LQH_HIERLiquidity Item Hierarchy Relationship6NEXTIDNext ID for Hierarchy Nodenvarchar80
57RSDMHIETAB740Model Table: Hierarchies of a Characteristic (from 3.0B)10NEXTIDNext ID of a hierarchy nodenvarchar80
TOPBRFplus - ABAP-Based Business Rules
58SFBMSTPFormula Builder Methods: Steps8NEXTIDTree Control: Node Keynvarchar120
TOPBW Service API
59ROVERFIELHHierarchy using Test Fields in Verification Scenario7NEXTIDNext ID of a hierarchy nodenvarchar80
TOPData Basis
60RSDIPROHNODEInfoProvider: Hierarchy Nodes9NEXTIDNext ID of a hierarchy nodenvarchar80
61RSMAXHIETABHierarchy Node Table with Maximum Possible Structure10NEXTIDNext ID of a hierarchy nodenvarchar80
TOPData Staging
62RSHIENODETMPHelp Table for Packaged Loading of Hierarchies9NEXTIDNext ID of a hierarchy nodenvarchar80
TOPMetadata Repository
63RSDMHIETABObsolete from APOLLO -> RSDMHIERTABNEW10NEXTIDNext ID of a hierarchy nodenvarchar80
64RSDMHIETABNEWModel Table: Hierarchies of a Characteristic (from 3.0B)10NEXTIDNext ID of a hierarchy nodenvarchar80
TOPTransport Management System
65CMSALOGHDRCMS: Lock for ALOG2NEXTIDCMS: ALOG IDnvarchar100
TOPWithout Description
66RSHIENODESHierarchy Node(s)10NEXTIDNext ID of a hierarchy nodenvarchar80
67RSRVTESTHIERHierarchical Storage for Tests of RSRV5NEXTIDTree Control: Node Keynvarchar120