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

69 columns | Print definition?ERP 6.0  | CHILDID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/HFPIDHierarchy: InfoObject Structure Element9CHILDIDChild ID of a hierarchy nodenvarchar80
2/B364/HMPITEMSHierarchy: InfoObject Structure Element9CHILDIDChild ID of a hierarchy nodenvarchar80
3/B631/HACTTYPEHierarchy: InfoObject Activity Type9CHILDIDChild ID of a hierarchy nodenvarchar80
4/B631/HCOORDERHierarchy: InfoObject Order9CHILDIDChild ID of a hierarchy nodenvarchar80
5/B631/HCOSTCNTRHierarchy: InfoObject Cost Center9CHILDIDChild ID of a hierarchy nodenvarchar80
6/B631/HCOSTELMTHierarchy: InfoObject Cost Element9CHILDIDChild ID of a hierarchy nodenvarchar80
7/B631/HPLANTHierarchy: InfoObject Plant9CHILDIDChild ID of a hierarchy nodenvarchar80
8/B631/HPROFTCTRHierarchy: InfoObject Profit Center9CHILDIDChild ID of a hierarchy nodenvarchar80
9/B631/HWBSELMTHierarchy: InfoObject WBS Element9CHILDIDChild ID of a hierarchy nodenvarchar80
10/BI0/HBUCKETHierarchy: InfoObject Directory of Precalc9CHILDIDChild ID of a hierarchy nodenvarchar80
11/BI0/HCALMONTHHierarchy: InfoObject Calendar Year/Month9CHILDIDChild ID of a hierarchy nodenvarchar80
12/BI0/HCALMONTH2Hierarchy: InfoObject Calendar month9CHILDIDChild ID of a hierarchy nodenvarchar80
13/BI0/HDATEHierarchy: InfoObject Date9CHILDIDChild ID of a hierarchy nodenvarchar80
14/BI0/HFISCPERHierarchy: InfoObject Fiscal year/period9CHILDIDChild ID of a hierarchy nodenvarchar80
15/BI0/HHALFYEAR1Hierarchy: InfoObject Halfyear9CHILDIDChild ID of a hierarchy nodenvarchar80
16/BI0/HINFOPROVHierarchy: InfoObject InfoProvider9CHILDIDChild ID of a hierarchy nodenvarchar80
17/BI0/HIOBJNMHierarchy: InfoObject InfoObject9CHILDIDChild ID of a hierarchy nodenvarchar80
18/BI0/HRSPL_ORGHierarchy: InfoObject Area of Responsibil.9CHILDIDChild ID of a hierarchy nodenvarchar80
19/BI0/HRSTT_EIDHierarchy: InfoObject Error ID9CHILDIDChild ID of a hierarchy nodenvarchar80
20/BI0/HRSTT_FTPCHierarchy: InfoObject Function Subject9CHILDIDChild ID of a hierarchy nodenvarchar80
21/BI0/HRSTT_FUNCHierarchy: InfoObject Functions9CHILDIDChild ID of a hierarchy nodenvarchar80
22/BI0/HRSTT_IONMHierarchy: InfoObject InfoObject9CHILDIDChild ID of a hierarchy nodenvarchar80
23/BI0/HRSTT_IPBZMHierarchy: InfoObject RTM for Non-Cum.9CHILDIDChild ID of a hierarchy nodenvarchar80
24/BI0/HRSTT_IPNMHierarchy: InfoObject InfoProvider Name9CHILDIDChild ID of a hierarchy nodenvarchar80
25/BI0/HRSTT_JIDHierarchy: InfoObject Job ID9CHILDIDChild ID of a hierarchy nodenvarchar80
26/BI0/HRSTT_OBJNMHierarchy: InfoObject Object Name9CHILDIDChild ID of a hierarchy nodenvarchar80
27/BI0/HRSTT_PIDHierarchy: InfoObject Trace Package ID9CHILDIDChild ID of a hierarchy nodenvarchar80
28/BI0/HRSTT_PVARHierarchy: InfoObject Play Variant9CHILDIDChild ID of a hierarchy nodenvarchar80
29/BI0/HRSTT_QYNMHierarchy: InfoObject Query Name9CHILDIDChild ID of a hierarchy nodenvarchar80
30/BI0/HRSTT_RQIDHierarchy: InfoObject Test Request9CHILDIDChild ID of a hierarchy nodenvarchar80
31/BI0/HRSTT_RVARHierarchy: InfoObject Ref. Data Variant9CHILDIDChild ID of a hierarchy nodenvarchar80
32/BI0/HRSTT_SAPCPHierarchy: InfoObject SAP Component9CHILDIDChild ID of a hierarchy nodenvarchar80
33/BI0/HRSTT_SVARIHierarchy: InfoObject Selection Variant9CHILDIDChild ID of a hierarchy nodenvarchar80
34/BI0/HRSTT_TIDHierarchy: InfoObject Trace ID9CHILDIDChild ID of a hierarchy nodenvarchar80
35/BI0/HRSTT_TLAYHierarchy: InfoObject Trace Layer9CHILDIDChild ID of a hierarchy nodenvarchar80
36/BI0/HRSTT_TOTYPHierarchy: InfoObject Object Type (Transp)9CHILDIDChild ID of a hierarchy nodenvarchar80
37/BI0/HRSTT_TRANRHierarchy: InfoObject Transport Request9CHILDIDChild ID of a hierarchy nodenvarchar80
38/BI0/HRSTT_TRTGTHierarchy: InfoObject Transport Target9CHILDIDChild ID of a hierarchy nodenvarchar80
39/BI0/HRSTT_USERHierarchy: InfoObject Trace User9CHILDIDChild ID of a hierarchy nodenvarchar80
40/BI0/HTCAIFAREAHierarchy: InfoObject InfoArea Analys. Aut9CHILDIDChild ID of a hierarchy nodenvarchar80
41/BI0/HTCTAPPLHierarchy: InfoObject Appl. Component9CHILDIDChild ID of a hierarchy nodenvarchar80
42/BI0/HTCTBWOBJCTHierarchy: InfoObject BI Object9CHILDIDChild ID of a hierarchy nodenvarchar80
43/BI0/HTCTIFAREAHierarchy: InfoObject InfoArea9CHILDIDChild ID of a hierarchy nodenvarchar80
44/BI0/HTCTMDXFCHierarchy: InfoObject MDX Functions9CHILDIDChild ID of a hierarchy nodenvarchar80
45/BI0/HTCTPRCSCHNHierarchy: InfoObject Process Chain ID9CHILDIDChild ID of a hierarchy nodenvarchar80
46/BI0/HTCTQUERIDHierarchy: InfoObject Query (UID)9CHILDIDChild ID of a hierarchy nodenvarchar80
47/BI0/HTCTSOURSYSHierarchy: InfoObject Source System9CHILDIDChild ID of a hierarchy nodenvarchar80
48/BI0/HTCTSTATEVTHierarchy: InfoObject Statistics Event9CHILDIDChild ID of a hierarchy nodenvarchar80
49/BI0/HTCTSYSIDHierarchy: InfoObject BW System9CHILDIDChild ID of a hierarchy nodenvarchar80
50/BI0/HTCTUSERNMHierarchy: InfoObject User9CHILDIDChild ID of a hierarchy nodenvarchar80
51/BI0/HTCTUSRNMHierarchy: InfoObject User ID9CHILDIDChild ID of a hierarchy nodenvarchar80
52/BI0/SCHILDIDMaster Data IDs: InfoObject Lower-Level ID1CHILDIDLower-Level ID of Node in Hierarchynvarchar80
53CMCBD_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)7CHILDIDChild ID for Hierarchy Nodenvarchar80
54CMCBD_ORG_RSOrganizational Hierarchy Relationship10CHILDIDChild ID of a hierarchy nodenvarchar80
55CMCB_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)5CHILDIDChild ID for Hierarchy Nodenvarchar80
56FCLM_LQH_HIERLiquidity Item Hierarchy Relationship5CHILDIDChild ID for Hierarchy Nodenvarchar80
57RSDMHIETAB740Model Table: Hierarchies of a Characteristic (from 3.0B)9CHILDIDChild ID of a hierarchy nodenvarchar80
TOPBRFplus - ABAP-Based Business Rules
58SFBMSTPFormula Builder Methods: Steps7CHILDIDTree Control: Node Keynvarchar120
TOPBusiness Server Pages
59TAGTREEVIEWTest4CHILDIDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPBW Service API
60ROVERFIELHHierarchy using Test Fields in Verification Scenario6CHILDIDChild ID of a hierarchy nodenvarchar80
TOPClinical System
61N1MEAi.s.h.med: Medication, Assignments6CHILDIDMedication: ID of Subordinate Objectnvarchar500
TOPCross-System and Cross-Partner Document Flow
62/SCMB/TREEVIEW2Obsolete - Copy of TAGTREEVIEW from Package SBSPEXT_HTMLB4CHILDIDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPData Basis
63RSDIPROHNODEInfoProvider: Hierarchy Nodes8CHILDIDChild ID of a hierarchy nodenvarchar80
64RSMAXHIETABHierarchy Node Table with Maximum Possible Structure9CHILDIDChild ID of a hierarchy nodenvarchar80
TOPData Staging
65RSHIENODETMPHelp Table for Packaged Loading of Hierarchies8CHILDIDChild ID of a hierarchy nodenvarchar80
TOPMetadata Repository
66RSDMHIETABObsolete from APOLLO -> RSDMHIERTABNEW9CHILDIDChild ID of a hierarchy nodenvarchar80
67RSDMHIETABNEWModel Table: Hierarchies of a Characteristic (from 3.0B)9CHILDIDChild ID of a hierarchy nodenvarchar80
TOPWithout Description
68RSHIENODESHierarchy Node(s)9CHILDIDChild ID of a hierarchy nodenvarchar80
69RSRVTESTHIERHierarchical Storage for Tests of RSRV4CHILDIDTree Control: Node Keynvarchar120