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

158 columns | Print definition?ERP 6.0  | TLEVEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/HFPIDHierarchy: InfoObject Structure Element6TLEVELLevel of a hierarchy nodenvarchar20
2/B364/HMPITEMSHierarchy: InfoObject Structure Element6TLEVELLevel of a hierarchy nodenvarchar20
3/B364/IFPIDSID Structure of Hierarchies: InfoObject Structure Element7TLEVELLevel of a hierarchy nodenvarchar20
4/B364/IMPITEMSSID Structure of Hierarchies: InfoObject Structure Element7TLEVELLevel of a hierarchy nodenvarchar20
5/B631/HACTTYPEHierarchy: InfoObject Activity Type6TLEVELLevel of a hierarchy nodenvarchar20
6/B631/HCOORDERHierarchy: InfoObject Order6TLEVELLevel of a hierarchy nodenvarchar20
7/B631/HCOSTCNTRHierarchy: InfoObject Cost Center6TLEVELLevel of a hierarchy nodenvarchar20
8/B631/HCOSTELMTHierarchy: InfoObject Cost Element6TLEVELLevel of a hierarchy nodenvarchar20
9/B631/HPLANTHierarchy: InfoObject Plant6TLEVELLevel of a hierarchy nodenvarchar20
10/B631/HPROFTCTRHierarchy: InfoObject Profit Center6TLEVELLevel of a hierarchy nodenvarchar20
11/B631/HWBSELMTHierarchy: InfoObject WBS Element6TLEVELLevel of a hierarchy nodenvarchar20
12/B631/IACTTYPESID Structure of Hierarchies: InfoObject Activity Type7TLEVELLevel of a hierarchy nodenvarchar20
13/B631/ICOORDERSID Structure of Hierarchies: InfoObject Order7TLEVELLevel of a hierarchy nodenvarchar20
14/B631/ICOSTCNTRSID Structure of Hierarchies: InfoObject Cost Center7TLEVELLevel of a hierarchy nodenvarchar20
15/B631/ICOSTELMTSID Structure of Hierarchies: InfoObject Cost Element7TLEVELLevel of a hierarchy nodenvarchar20
16/B631/IPLANTSID Structure of Hierarchies: InfoObject Plant7TLEVELLevel of a hierarchy nodenvarchar20
17/B631/IPROFTCTRSID Structure of Hierarchies: InfoObject Profit Center7TLEVELLevel of a hierarchy nodenvarchar20
18/B631/IWBSELMTSID Structure of Hierarchies: InfoObject WBS Element7TLEVELLevel of a hierarchy nodenvarchar20
19/BI0/HBUCKETHierarchy: InfoObject Directory of Precalc6TLEVELLevel of a hierarchy nodenvarchar20
20/BI0/HCALMONTHHierarchy: InfoObject Calendar Year/Month6TLEVELLevel of a hierarchy nodenvarchar20
21/BI0/HCALMONTH2Hierarchy: InfoObject Calendar month6TLEVELLevel of a hierarchy nodenvarchar20
22/BI0/HDATEHierarchy: InfoObject Date6TLEVELLevel of a hierarchy nodenvarchar20
23/BI0/HFISCPERHierarchy: InfoObject Fiscal year/period6TLEVELLevel of a hierarchy nodenvarchar20
24/BI0/HHALFYEAR1Hierarchy: InfoObject Halfyear6TLEVELLevel of a hierarchy nodenvarchar20
25/BI0/HINFOPROVHierarchy: InfoObject InfoProvider6TLEVELLevel of a hierarchy nodenvarchar20
26/BI0/HIOBJNMHierarchy: InfoObject InfoObject6TLEVELLevel of a hierarchy nodenvarchar20
27/BI0/HRSPL_ORGHierarchy: InfoObject Area of Responsibil.6TLEVELLevel of a hierarchy nodenvarchar20
28/BI0/HRSTT_EIDHierarchy: InfoObject Error ID6TLEVELLevel of a hierarchy nodenvarchar20
29/BI0/HRSTT_FTPCHierarchy: InfoObject Function Subject6TLEVELLevel of a hierarchy nodenvarchar20
30/BI0/HRSTT_FUNCHierarchy: InfoObject Functions6TLEVELLevel of a hierarchy nodenvarchar20
31/BI0/HRSTT_IONMHierarchy: InfoObject InfoObject6TLEVELLevel of a hierarchy nodenvarchar20
32/BI0/HRSTT_IPBZMHierarchy: InfoObject RTM for Non-Cum.6TLEVELLevel of a hierarchy nodenvarchar20
33/BI0/HRSTT_IPNMHierarchy: InfoObject InfoProvider Name6TLEVELLevel of a hierarchy nodenvarchar20
34/BI0/HRSTT_JIDHierarchy: InfoObject Job ID6TLEVELLevel of a hierarchy nodenvarchar20
35/BI0/HRSTT_OBJNMHierarchy: InfoObject Object Name6TLEVELLevel of a hierarchy nodenvarchar20
36/BI0/HRSTT_PIDHierarchy: InfoObject Trace Package ID6TLEVELLevel of a hierarchy nodenvarchar20
37/BI0/HRSTT_PVARHierarchy: InfoObject Play Variant6TLEVELLevel of a hierarchy nodenvarchar20
38/BI0/HRSTT_QYNMHierarchy: InfoObject Query Name6TLEVELLevel of a hierarchy nodenvarchar20
39/BI0/HRSTT_RQIDHierarchy: InfoObject Test Request6TLEVELLevel of a hierarchy nodenvarchar20
40/BI0/HRSTT_RVARHierarchy: InfoObject Ref. Data Variant6TLEVELLevel of a hierarchy nodenvarchar20
41/BI0/HRSTT_SAPCPHierarchy: InfoObject SAP Component6TLEVELLevel of a hierarchy nodenvarchar20
42/BI0/HRSTT_SVARIHierarchy: InfoObject Selection Variant6TLEVELLevel of a hierarchy nodenvarchar20
43/BI0/HRSTT_TIDHierarchy: InfoObject Trace ID6TLEVELLevel of a hierarchy nodenvarchar20
44/BI0/HRSTT_TLAYHierarchy: InfoObject Trace Layer6TLEVELLevel of a hierarchy nodenvarchar20
45/BI0/HRSTT_TOTYPHierarchy: InfoObject Object Type (Transp)6TLEVELLevel of a hierarchy nodenvarchar20
46/BI0/HRSTT_TRANRHierarchy: InfoObject Transport Request6TLEVELLevel of a hierarchy nodenvarchar20
47/BI0/HRSTT_TRTGTHierarchy: InfoObject Transport Target6TLEVELLevel of a hierarchy nodenvarchar20
48/BI0/HRSTT_USERHierarchy: InfoObject Trace User6TLEVELLevel of a hierarchy nodenvarchar20
49/BI0/HTCAIFAREAHierarchy: InfoObject InfoArea Analys. Aut6TLEVELLevel of a hierarchy nodenvarchar20
50/BI0/HTCTAPPLHierarchy: InfoObject Appl. Component6TLEVELLevel of a hierarchy nodenvarchar20
51/BI0/HTCTBWOBJCTHierarchy: InfoObject BI Object6TLEVELLevel of a hierarchy nodenvarchar20
52/BI0/HTCTIFAREAHierarchy: InfoObject InfoArea6TLEVELLevel of a hierarchy nodenvarchar20
53/BI0/HTCTMDXFCHierarchy: InfoObject MDX Functions6TLEVELLevel of a hierarchy nodenvarchar20
54/BI0/HTCTPRCSCHNHierarchy: InfoObject Process Chain ID6TLEVELLevel of a hierarchy nodenvarchar20
55/BI0/HTCTQUERIDHierarchy: InfoObject Query (UID)6TLEVELLevel of a hierarchy nodenvarchar20
56/BI0/HTCTSOURSYSHierarchy: InfoObject Source System6TLEVELLevel of a hierarchy nodenvarchar20
57/BI0/HTCTSTATEVTHierarchy: InfoObject Statistics Event6TLEVELLevel of a hierarchy nodenvarchar20
58/BI0/HTCTSYSIDHierarchy: InfoObject BW System6TLEVELLevel of a hierarchy nodenvarchar20
59/BI0/HTCTUSERNMHierarchy: InfoObject User6TLEVELLevel of a hierarchy nodenvarchar20
60/BI0/HTCTUSRNMHierarchy: InfoObject User ID6TLEVELLevel of a hierarchy nodenvarchar20
61/BI0/IBUCKETSID Structure of Hierarchies: InfoObject Directory of Precal7TLEVELLevel of a hierarchy nodenvarchar20
62/BI0/ICALMONTHSID Structure of Hierarchies: InfoObject Calendar Year/Month7TLEVELLevel of a hierarchy nodenvarchar20
63/BI0/ICALMONTH2SID Structure of Hierarchies: InfoObject Calendar month7TLEVELLevel of a hierarchy nodenvarchar20
64/BI0/IDATESID Structure of Hierarchies: InfoObject Date7TLEVELLevel of a hierarchy nodenvarchar20
65/BI0/IFISCPERSID Structure of Hierarchies: InfoObject Fiscal year/period7TLEVELLevel of a hierarchy nodenvarchar20
66/BI0/IHALFYEAR1SID Structure of Hierarchies: InfoObject Halfyear7TLEVELLevel of a hierarchy nodenvarchar20
67/BI0/IINFOPROVSID Structure of Hierarchies: InfoObject InfoProvider7TLEVELLevel of a hierarchy nodenvarchar20
68/BI0/IIOBJNMSID Structure of Hierarchies: InfoObject InfoObject7TLEVELLevel of a hierarchy nodenvarchar20
69/BI0/IRSPL_ORGSID Structure of Hierarchies: InfoObject Area of Responsibil7TLEVELLevel of a hierarchy nodenvarchar20
70/BI0/IRSTT_EIDSID Structure of Hierarchies: InfoObject Error ID7TLEVELLevel of a hierarchy nodenvarchar20
71/BI0/IRSTT_FTPCSID Structure of Hierarchies: InfoObject Function Subject7TLEVELLevel of a hierarchy nodenvarchar20
72/BI0/IRSTT_FUNCSID Structure of Hierarchies: InfoObject Functions7TLEVELLevel of a hierarchy nodenvarchar20
73/BI0/IRSTT_IONMSID Structure of Hierarchies: InfoObject InfoObject7TLEVELLevel of a hierarchy nodenvarchar20
74/BI0/IRSTT_IPBZMSID Structure of Hierarchies: InfoObject RTM for Non-Cum.7TLEVELLevel of a hierarchy nodenvarchar20
75/BI0/IRSTT_IPNMSID Structure of Hierarchies: InfoObject InfoProvider Name7TLEVELLevel of a hierarchy nodenvarchar20
76/BI0/IRSTT_JIDSID Structure of Hierarchies: InfoObject Job ID7TLEVELLevel of a hierarchy nodenvarchar20
77/BI0/IRSTT_OBJNMSID Structure of Hierarchies: InfoObject Object Name7TLEVELLevel of a hierarchy nodenvarchar20
78/BI0/IRSTT_PIDSID Structure of Hierarchies: InfoObject Trace Package ID7TLEVELLevel of a hierarchy nodenvarchar20
79/BI0/IRSTT_PVARSID Structure of Hierarchies: InfoObject Play Variant7TLEVELLevel of a hierarchy nodenvarchar20
80/BI0/IRSTT_QYNMSID Structure of Hierarchies: InfoObject Query Name7TLEVELLevel of a hierarchy nodenvarchar20
81/BI0/IRSTT_RQIDSID Structure of Hierarchies: InfoObject Test Request7TLEVELLevel of a hierarchy nodenvarchar20
82/BI0/IRSTT_RVARSID Structure of Hierarchies: InfoObject Ref. Data Variant7TLEVELLevel of a hierarchy nodenvarchar20
83/BI0/IRSTT_SAPCPSID Structure of Hierarchies: InfoObject SAP Component7TLEVELLevel of a hierarchy nodenvarchar20
84/BI0/IRSTT_SVARISID Structure of Hierarchies: InfoObject Selection Variant7TLEVELLevel of a hierarchy nodenvarchar20
85/BI0/IRSTT_TIDSID Structure of Hierarchies: InfoObject Trace ID7TLEVELLevel of a hierarchy nodenvarchar20
86/BI0/IRSTT_TLAYSID Structure of Hierarchies: InfoObject Trace Layer7TLEVELLevel of a hierarchy nodenvarchar20
87/BI0/IRSTT_TOTYPSID Structure of Hierarchies: InfoObject Object Type (Transp7TLEVELLevel of a hierarchy nodenvarchar20
88/BI0/IRSTT_TRANRSID Structure of Hierarchies: InfoObject Transport Request7TLEVELLevel of a hierarchy nodenvarchar20
89/BI0/IRSTT_TRTGTSID Structure of Hierarchies: InfoObject Transport Target7TLEVELLevel of a hierarchy nodenvarchar20
90/BI0/IRSTT_USERSID Structure of Hierarchies: InfoObject Trace User7TLEVELLevel of a hierarchy nodenvarchar20
91/BI0/ITCAIFAREASID Structure of Hierarchies: InfoObject InfoArea Analys. Au7TLEVELLevel of a hierarchy nodenvarchar20
92/BI0/ITCTAPPLSID Structure of Hierarchies: InfoObject Appl. Component7TLEVELLevel of a hierarchy nodenvarchar20
93/BI0/ITCTBWOBJCTSID Structure of Hierarchies: InfoObject BI Object7TLEVELLevel of a hierarchy nodenvarchar20
94/BI0/ITCTIFAREASID Structure of Hierarchies: InfoObject InfoArea7TLEVELLevel of a hierarchy nodenvarchar20
95/BI0/ITCTMDXFCSID Structure of Hierarchies: InfoObject MDX Functions7TLEVELLevel of a hierarchy nodenvarchar20
96/BI0/ITCTPRCSCHNSID Structure of Hierarchies: InfoObject Process Chain ID7TLEVELLevel of a hierarchy nodenvarchar20
97/BI0/ITCTQUERIDSID Structure of Hierarchies: InfoObject Query (UID)7TLEVELLevel of a hierarchy nodenvarchar20
98/BI0/ITCTSOURSYSSID Structure of Hierarchies: InfoObject Source System7TLEVELLevel of a hierarchy nodenvarchar20
99/BI0/ITCTSTATEVTSID Structure of Hierarchies: InfoObject Statistics Event7TLEVELLevel of a hierarchy nodenvarchar20
100/BI0/ITCTSYSIDSID Structure of Hierarchies: InfoObject BW System7TLEVELLevel of a hierarchy nodenvarchar20
101/BI0/ITCTUSERNMSID Structure of Hierarchies: InfoObject User7TLEVELLevel of a hierarchy nodenvarchar20
102/BI0/ITCTUSRNMSID Structure of Hierarchies: InfoObject User ID7TLEVELLevel of a hierarchy nodenvarchar20
103/BI0/STLEVELMaster Data IDs: InfoObject Level1TLEVELLevel of a Hierarchy Nodenvarchar20
104CMCBD_ORG_RSOrganizational Hierarchy Relationship9TLEVELLevel of a hierarchy nodenvarchar20
105CNVMBTIMGProcess plan, order of activities to be executed5TLEVELPCL Process Tree Levelnvarchar10
106PYC_D_PY_MSGPYC: payroll message36TLEVELNode levelnvarchar20
107PYC_D_PY_MSG_JOBPYC: payroll message19TLEVELNode levelnvarchar20
108RSBPCB_MEM_HIEBPC: BPF Driver Dimension Hierarchy Member Item13TLEVELLevel of a hierarchy nodenvarchar20
109RSDMHIETAB740Model Table: Hierarchies of a Characteristic (from 3.0B)6TLEVELLevel of a hierarchy nodenvarchar20
110RSRHINTAB_OLAP_SHierarchy interval for the OLAP processor8TLEVELLevel of a hierarchy nodenvarchar20
TOPAccounting - General
111KPEP_WL_PSHIERHierarchy for WL Type Projects in Schedule Manager Worklist6TLEVELNode levelnvarchar20
TOPActivity-Based Costing
112ABC_FTREECO-OM-ABC: Function Tree9TLEVELNode levelnvarchar20
TOPAdvertising Management
113JHAPAFPIS-M/AM: Contract Determination Log for OPM Item7TLEVELNode levelnvarchar20
114JJTIKOHYIS-M/AM: Content Components Hierarchy8TLEVELNode levelnvarchar20
115TJJBEWRK1IS-M: Sales Booking Units Work Area4TLEVELNode levelnvarchar20
TOPAnalyzer
116JBRHISPHBAUMSTree Structure for Deactivated Portfolio Hierarchies8TLEVELNode levelnvarchar20
TOPBusiness Server Pages
117TAGTREEVIEWTest8TLEVELSingle-Character Indicatornvarchar10
TOPBW Service API
118ROVERFIELHHierarchy using Test Fields in Verification Scenario4TLEVELHierarchy Level in Verification Scenarionvarchar20
TOPCorporate Performance Monitor
119UMR_RI112OBSOLETE RMS: Deviations per Thread Level for Measure7TLEVELThreat Levelnvarchar20
120UMR_RI126OBSOLETE RMS: Probability and Risk Intensity11TLEVELThreat Levelnvarchar20
121UMR_TL100Threat Level: Master2TLEVELThreat Levelnvarchar20
122UMR_TL100TThreat Level: Text Table2TLEVELThreat Levelnvarchar20
TOPCross-System and Cross-Partner Document Flow
123/SCMB/TREEVIEW2Obsolete - Copy of TAGTREEVIEW from Package SBSPEXT_HTMLB8TLEVELSingle-Character Indicatornvarchar10
TOPData Basis
124RSCNVMONSTEPSSteps of any operation on a BW Object5TLEVELLevel of Node in Monitor Treenvarchar20
125RSDIPROHNODEInfoProvider: Hierarchy Nodes6TLEVELLevel of a hierarchy nodenvarchar20
126RSHIELVTLevels Table for Hierarchies in BW4TLEVELLevel of a hierarchy nodenvarchar20
127RSMAXHIETABHierarchy Node Table with Maximum Possible Structure6TLEVELLevel of a hierarchy nodenvarchar20
TOPData Staging
128RSHIENODETMPHelp Table for Packaged Loading of Hierarchies5TLEVELLevel of a hierarchy nodenvarchar20
TOPDepreciation Simulation
129IMCHIEIM Summarization: Buffer for investment program hierarchy9TLEVELNode levelnvarchar20
TOPInformation System
130PSJHIEDATAHierarchy data to test LDB PSJ5TLEVELNode levelnvarchar20
TOPMarket Risk Analyzer
131JBRRHBAUMTree Structure of Risk Hierarchy7TLEVELNode levelnvarchar20
132JBRRHBAUMHTree Structure of Risk Hierarchy (History)8TLEVELNode levelnvarchar20
133JBRRHBAUM_BACKBackup Table JBRRHBAUM (Required for Transport Imports)7TLEVELNode levelnvarchar20
TOPMaterial Groups
134WTREEVersion Management for Reclassification Trees9TLEVELNode levelnvarchar20
TOPMetadata Repository
135RSDMHIETABObsolete from APOLLO -> RSDMHIERTABNEW6TLEVELLevel of a hierarchy nodenvarchar20
136RSDMHIETABNEWModel Table: Hierarchies of a Characteristic (from 3.0B)6TLEVELLevel of a hierarchy nodenvarchar20
137RSDMINCTABModel table: SID structure of the hierarchies of a charact.7TLEVELLevel of a hierarchy nodenvarchar20
TOPOLAP Technology
138RSDDAGGRCOMPDescription of the aggregates7TLEVELLevel of a hierarchy nodenvarchar20
139RSDDSTATAGGRDEFStatistics data OLAP: Navigation step / aggregate definition10TLEVELLevel of a hierarchy nodenvarchar20
140RSRHINTAB_OLAP(obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel7TLEVELLevel of a hierarchy nodenvarchar20
141RSSAUTHHIERDefinition of the Authorizations for Hierarchies10TLEVELHierarchy Levelnvarchar20
142RSSAUTHHIERNODEBW Reporting Authorizations: Hierarchy Nodes5TLEVELHierarchy Levelnvarchar20
TOPPeriodical Sales and Distribution
143TJYUSRUTILIS-M/SD: User Utilities4TLEVELNode levelnvarchar20
TOPProduct Safety
144TCG53EHS: Property Tree - Value Assignment Type Assignment9TLEVELNode Levelnvarchar20
TOPProject System
145PSHLPDB_HIER_TMPTable to store temporary hierarchy data9TLEVELNode levelnvarchar20
146PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy9TLEVELNode levelnvarchar20
TOPReport Tree
147SERPENTRReporting: Initial Position and Sub-trees (User-specific)6TLEVELNode levelnvarchar20
148SERPTREEReporting: Tree Structure9TLEVELNode levelnvarchar20
TOPReporting
149MCSHIERBTree for general hierarchy8TLEVELNode levelnvarchar20
TOPRepository Browser
150APTREEApplication Hierarchy4TLEVELNode levelnvarchar20
151TREELOGChange log for table TREE (tree administration)9TLEVELNode levelnvarchar20
TOPRisk Analysis
152JBRNODETXTAll Information for Display of Hierarchies7TLEVELNode levelnvarchar20
153JBRPHBAUMSStorage of Portfolio Hierarchy8TLEVELNode levelnvarchar20
154JBRSVPHBAUMRM: Portfolio Hierarchy for Saved Datasets (Backtesting)9TLEVELNode levelnvarchar20
TOPSettlement
155TSR01Automatic Generation of Settlement Rules3TLEVELNode levelnvarchar20
TOPTranslation Tools
156APP_FCTRApplication ID Node Number6TLEVELNode levelnvarchar20
TOPWithout Description
157RSHIENODESHierarchy Node(s)6TLEVELLevel of a hierarchy nodenvarchar20
158RSRVPACKAGEMEMComponents of a Test Package of Check and Repair Tool6TLEVELNatural Numberint100