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

86 columns | Print definition?ERP 6.0  | PARENTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/HFPIDHierarchy: InfoObject Structure Element8PARENTIDParent ID for a hierarchy nodenvarchar80
2/B364/HMPITEMSHierarchy: InfoObject Structure Element8PARENTIDParent ID for a hierarchy nodenvarchar80
3/B631/HACTTYPEHierarchy: InfoObject Activity Type8PARENTIDParent ID for a hierarchy nodenvarchar80
4/B631/HCOORDERHierarchy: InfoObject Order8PARENTIDParent ID for a hierarchy nodenvarchar80
5/B631/HCOSTCNTRHierarchy: InfoObject Cost Center8PARENTIDParent ID for a hierarchy nodenvarchar80
6/B631/HCOSTELMTHierarchy: InfoObject Cost Element8PARENTIDParent ID for a hierarchy nodenvarchar80
7/B631/HPLANTHierarchy: InfoObject Plant8PARENTIDParent ID for a hierarchy nodenvarchar80
8/B631/HPROFTCTRHierarchy: InfoObject Profit Center8PARENTIDParent ID for a hierarchy nodenvarchar80
9/B631/HWBSELMTHierarchy: InfoObject WBS Element8PARENTIDParent ID for a hierarchy nodenvarchar80
10/BI0/HBUCKETHierarchy: InfoObject Directory of Precalc8PARENTIDParent ID for a hierarchy nodenvarchar80
11/BI0/HCALMONTHHierarchy: InfoObject Calendar Year/Month8PARENTIDParent ID for a hierarchy nodenvarchar80
12/BI0/HCALMONTH2Hierarchy: InfoObject Calendar month8PARENTIDParent ID for a hierarchy nodenvarchar80
13/BI0/HDATEHierarchy: InfoObject Date8PARENTIDParent ID for a hierarchy nodenvarchar80
14/BI0/HFISCPERHierarchy: InfoObject Fiscal year/period8PARENTIDParent ID for a hierarchy nodenvarchar80
15/BI0/HHALFYEAR1Hierarchy: InfoObject Halfyear8PARENTIDParent ID for a hierarchy nodenvarchar80
16/BI0/HINFOPROVHierarchy: InfoObject InfoProvider8PARENTIDParent ID for a hierarchy nodenvarchar80
17/BI0/HIOBJNMHierarchy: InfoObject InfoObject8PARENTIDParent ID for a hierarchy nodenvarchar80
18/BI0/HRSPL_ORGHierarchy: InfoObject Area of Responsibil.8PARENTIDParent ID for a hierarchy nodenvarchar80
19/BI0/HRSTT_EIDHierarchy: InfoObject Error ID8PARENTIDParent ID for a hierarchy nodenvarchar80
20/BI0/HRSTT_FTPCHierarchy: InfoObject Function Subject8PARENTIDParent ID for a hierarchy nodenvarchar80
21/BI0/HRSTT_FUNCHierarchy: InfoObject Functions8PARENTIDParent ID for a hierarchy nodenvarchar80
22/BI0/HRSTT_IONMHierarchy: InfoObject InfoObject8PARENTIDParent ID for a hierarchy nodenvarchar80
23/BI0/HRSTT_IPBZMHierarchy: InfoObject RTM for Non-Cum.8PARENTIDParent ID for a hierarchy nodenvarchar80
24/BI0/HRSTT_IPNMHierarchy: InfoObject InfoProvider Name8PARENTIDParent ID for a hierarchy nodenvarchar80
25/BI0/HRSTT_JIDHierarchy: InfoObject Job ID8PARENTIDParent ID for a hierarchy nodenvarchar80
26/BI0/HRSTT_OBJNMHierarchy: InfoObject Object Name8PARENTIDParent ID for a hierarchy nodenvarchar80
27/BI0/HRSTT_PIDHierarchy: InfoObject Trace Package ID8PARENTIDParent ID for a hierarchy nodenvarchar80
28/BI0/HRSTT_PVARHierarchy: InfoObject Play Variant8PARENTIDParent ID for a hierarchy nodenvarchar80
29/BI0/HRSTT_QYNMHierarchy: InfoObject Query Name8PARENTIDParent ID for a hierarchy nodenvarchar80
30/BI0/HRSTT_RQIDHierarchy: InfoObject Test Request8PARENTIDParent ID for a hierarchy nodenvarchar80
31/BI0/HRSTT_RVARHierarchy: InfoObject Ref. Data Variant8PARENTIDParent ID for a hierarchy nodenvarchar80
32/BI0/HRSTT_SAPCPHierarchy: InfoObject SAP Component8PARENTIDParent ID for a hierarchy nodenvarchar80
33/BI0/HRSTT_SVARIHierarchy: InfoObject Selection Variant8PARENTIDParent ID for a hierarchy nodenvarchar80
34/BI0/HRSTT_TIDHierarchy: InfoObject Trace ID8PARENTIDParent ID for a hierarchy nodenvarchar80
35/BI0/HRSTT_TLAYHierarchy: InfoObject Trace Layer8PARENTIDParent ID for a hierarchy nodenvarchar80
36/BI0/HRSTT_TOTYPHierarchy: InfoObject Object Type (Transp)8PARENTIDParent ID for a hierarchy nodenvarchar80
37/BI0/HRSTT_TRANRHierarchy: InfoObject Transport Request8PARENTIDParent ID for a hierarchy nodenvarchar80
38/BI0/HRSTT_TRTGTHierarchy: InfoObject Transport Target8PARENTIDParent ID for a hierarchy nodenvarchar80
39/BI0/HRSTT_USERHierarchy: InfoObject Trace User8PARENTIDParent ID for a hierarchy nodenvarchar80
40/BI0/HTCAIFAREAHierarchy: InfoObject InfoArea Analys. Aut8PARENTIDParent ID for a hierarchy nodenvarchar80
41/BI0/HTCTAPPLHierarchy: InfoObject Appl. Component8PARENTIDParent ID for a hierarchy nodenvarchar80
42/BI0/HTCTBWOBJCTHierarchy: InfoObject BI Object8PARENTIDParent ID for a hierarchy nodenvarchar80
43/BI0/HTCTIFAREAHierarchy: InfoObject InfoArea8PARENTIDParent ID for a hierarchy nodenvarchar80
44/BI0/HTCTMDXFCHierarchy: InfoObject MDX Functions8PARENTIDParent ID for a hierarchy nodenvarchar80
45/BI0/HTCTPRCSCHNHierarchy: InfoObject Process Chain ID8PARENTIDParent ID for a hierarchy nodenvarchar80
46/BI0/HTCTQUERIDHierarchy: InfoObject Query (UID)8PARENTIDParent ID for a hierarchy nodenvarchar80
47/BI0/HTCTSOURSYSHierarchy: InfoObject Source System8PARENTIDParent ID for a hierarchy nodenvarchar80
48/BI0/HTCTSTATEVTHierarchy: InfoObject Statistics Event8PARENTIDParent ID for a hierarchy nodenvarchar80
49/BI0/HTCTSYSIDHierarchy: InfoObject BW System8PARENTIDParent ID for a hierarchy nodenvarchar80
50/BI0/HTCTUSERNMHierarchy: InfoObject User8PARENTIDParent ID for a hierarchy nodenvarchar80
51/BI0/HTCTUSRNMHierarchy: InfoObject User ID8PARENTIDParent ID for a hierarchy nodenvarchar80
52/BI0/SPARENTIDMaster Data IDs: InfoObject Higher-Level ID1PARENTIDHigher-Level ID for a Hierarchy Nodenvarchar80
53/PLMI/PRT_TREEtemplate tasks relation tree node4PARENTIDItem Number in Process Routenvarchar50
54ACMNESTEDROLEACM: Nested Role Relations (fully resolved)2PARENTIDACM: UUID of a Rolevarbinary160
55CMCBD_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)6PARENTIDParent ID for Hierarchy Nodenvarchar80
56CMCBD_ORG_RSOrganizational Hierarchy Relationship6PARENTIDParent ID for a hierarchy nodenvarchar80
57CMCB_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)4PARENTIDParent ID for Hierarchy Nodenvarchar80
58CNV_ADT_MENUTransformation Summary: Menu tree4PARENTIDParent node ID in menunvarchar120
59DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE15PARENTIDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
60FCLM_LQH_HIERLiquidity Item Hierarchy Relationship4PARENTIDParent ID for Hierarchy Nodenvarchar80
61GRACBGPERMISSIONName Value Pairs for Background Job Permission Parameter3PARENTIDUUID of the GRC object (char32)nvarchar320
62GRACBGRANGERange table values for Background Job variant3PARENTIDUUID of the GRC object (char32)nvarchar320
63GRACBGTECHROLEStores values for Background Job Parameter Value3PARENTIDUUID of the GRC object (char32)nvarchar320
64RSDMHIETAB740Model Table: Hierarchies of a Characteristic (from 3.0B)8PARENTIDParent ID for a hierarchy nodenvarchar80
TOPBackground Processing
65BTC_CRITNODESSelection Criteria: Criteria4PARENTIDSelection Criteria: IDint100
TOPBRFplus - ABAP-Based Business Rules
66SFBMSTPFormula Builder Methods: Steps6PARENTIDTree Control: Node Keynvarchar120
TOPBusiness Server Pages
67TAGTREEVIEWTest3PARENTIDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPBW Service API
68ROVERFIELHHierarchy using Test Fields in Verification Scenario5PARENTIDParent ID for a hierarchy nodenvarchar80
TOPClinical System
69N1MEAi.s.h.med: Medication, Assignments5PARENTIDMedication: ID Superordinate Objectnvarchar500
TOPCross-System and Cross-Partner Document Flow
70/SCMB/TREEVIEW2Obsolete - Copy of TAGTREEVIEW from Package SBSPEXT_HTMLB3PARENTIDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPData Basis
71RSDIPROHNODEInfoProvider: Hierarchy Nodes7PARENTIDParent ID for a hierarchy nodenvarchar80
72RSLPO_DFG_DTPFOLTable for Managing Folders for DTP Templates2PARENTIDID of DTP Template Foldernvarchar250
73RSMAXHIETABHierarchy Node Table with Maximum Possible Structure8PARENTIDParent ID for a hierarchy nodenvarchar80
TOPData Conversion
74DMC_STREEDMC: Tree Structure for Administration of Structures12PARENTIDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPData Staging
75RSHIENODETMPHelp Table for Packaged Loading of Hierarchies7PARENTIDParent ID for a hierarchy nodenvarchar80
TOPECM ABAP Stack
76NWECMD_NODEtable for persistent node objects3PARENTIDnwecm: UU Identifiervarbinary160
TOPEnvironment, Health and Safety
77/TDAG/CPC_REP011CP: Define hierarchy for report format4PARENTIDParent Node IDnvarchar60
TOPInformation System
78TIVISREPTREEInfo System Report Tree2PARENTIDHigher-Level Nodenvarchar200
TOPKnowledge Management and Collaboration
79CPETASKLOGDatabase table with log information for Ad hoc Workflow2PARENTIDNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPMetadata Repository
80RSDMHIETABObsolete from APOLLO -> RSDMHIERTABNEW8PARENTIDParent ID for a hierarchy nodenvarchar80
81RSDMHIETABNEWModel Table: Hierarchies of a Characteristic (from 3.0B)8PARENTIDParent ID for a hierarchy nodenvarchar80
TOPProfitability Analysis
82TKEPPLPROTOTREEStorage of Tree Structure for Logs7PARENTIDALV Tree Control: Node Keynvarchar120
TOPSchedule Manager
83KPEP_WL_HIEHierarchy Information for Worklists of Schedule Manager4PARENTIDObject Node Number in Worklistnvarchar80
TOPWithout Description
84RSHIENODESHierarchy Node(s)8PARENTIDParent ID for a hierarchy nodenvarchar80
85RSRVTESTHIERHierarchical Storage for Tests of RSRV3PARENTIDTree Control: Node Keynvarchar120
86RSTT_CHECKSELTrace Tool: Check Select Table8PARENTIDTrace Tool: Integer Valueint100