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

110 columns | Print definition?ERP 6.0  | LINK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/HFPIDHierarchy: InfoObject Structure Element7LINKLink indicator for a hierarchy nodenvarchar10
2/B364/HMPITEMSHierarchy: InfoObject Structure Element7LINKLink indicator for a hierarchy nodenvarchar10
3/B631/HACTTYPEHierarchy: InfoObject Activity Type7LINKLink indicator for a hierarchy nodenvarchar10
4/B631/HCOORDERHierarchy: InfoObject Order7LINKLink indicator for a hierarchy nodenvarchar10
5/B631/HCOSTCNTRHierarchy: InfoObject Cost Center7LINKLink indicator for a hierarchy nodenvarchar10
6/B631/HCOSTELMTHierarchy: InfoObject Cost Element7LINKLink indicator for a hierarchy nodenvarchar10
7/B631/HPLANTHierarchy: InfoObject Plant7LINKLink indicator for a hierarchy nodenvarchar10
8/B631/HPROFTCTRHierarchy: InfoObject Profit Center7LINKLink indicator for a hierarchy nodenvarchar10
9/B631/HWBSELMTHierarchy: InfoObject WBS Element7LINKLink indicator for a hierarchy nodenvarchar10
10/BI0/HBUCKETHierarchy: InfoObject Directory of Precalc7LINKLink indicator for a hierarchy nodenvarchar10
11/BI0/HCALMONTHHierarchy: InfoObject Calendar Year/Month7LINKLink indicator for a hierarchy nodenvarchar10
12/BI0/HCALMONTH2Hierarchy: InfoObject Calendar month7LINKLink indicator for a hierarchy nodenvarchar10
13/BI0/HDATEHierarchy: InfoObject Date7LINKLink indicator for a hierarchy nodenvarchar10
14/BI0/HFISCPERHierarchy: InfoObject Fiscal year/period7LINKLink indicator for a hierarchy nodenvarchar10
15/BI0/HHALFYEAR1Hierarchy: InfoObject Halfyear7LINKLink indicator for a hierarchy nodenvarchar10
16/BI0/HINFOPROVHierarchy: InfoObject InfoProvider7LINKLink indicator for a hierarchy nodenvarchar10
17/BI0/HIOBJNMHierarchy: InfoObject InfoObject7LINKLink indicator for a hierarchy nodenvarchar10
18/BI0/HRSPL_ORGHierarchy: InfoObject Area of Responsibil.7LINKLink indicator for a hierarchy nodenvarchar10
19/BI0/HRSTT_EIDHierarchy: InfoObject Error ID7LINKLink indicator for a hierarchy nodenvarchar10
20/BI0/HRSTT_FTPCHierarchy: InfoObject Function Subject7LINKLink indicator for a hierarchy nodenvarchar10
21/BI0/HRSTT_FUNCHierarchy: InfoObject Functions7LINKLink indicator for a hierarchy nodenvarchar10
22/BI0/HRSTT_IONMHierarchy: InfoObject InfoObject7LINKLink indicator for a hierarchy nodenvarchar10
23/BI0/HRSTT_IPBZMHierarchy: InfoObject RTM for Non-Cum.7LINKLink indicator for a hierarchy nodenvarchar10
24/BI0/HRSTT_IPNMHierarchy: InfoObject InfoProvider Name7LINKLink indicator for a hierarchy nodenvarchar10
25/BI0/HRSTT_JIDHierarchy: InfoObject Job ID7LINKLink indicator for a hierarchy nodenvarchar10
26/BI0/HRSTT_OBJNMHierarchy: InfoObject Object Name7LINKLink indicator for a hierarchy nodenvarchar10
27/BI0/HRSTT_PIDHierarchy: InfoObject Trace Package ID7LINKLink indicator for a hierarchy nodenvarchar10
28/BI0/HRSTT_PVARHierarchy: InfoObject Play Variant7LINKLink indicator for a hierarchy nodenvarchar10
29/BI0/HRSTT_QYNMHierarchy: InfoObject Query Name7LINKLink indicator for a hierarchy nodenvarchar10
30/BI0/HRSTT_RQIDHierarchy: InfoObject Test Request7LINKLink indicator for a hierarchy nodenvarchar10
31/BI0/HRSTT_RVARHierarchy: InfoObject Ref. Data Variant7LINKLink indicator for a hierarchy nodenvarchar10
32/BI0/HRSTT_SAPCPHierarchy: InfoObject SAP Component7LINKLink indicator for a hierarchy nodenvarchar10
33/BI0/HRSTT_SVARIHierarchy: InfoObject Selection Variant7LINKLink indicator for a hierarchy nodenvarchar10
34/BI0/HRSTT_TIDHierarchy: InfoObject Trace ID7LINKLink indicator for a hierarchy nodenvarchar10
35/BI0/HRSTT_TLAYHierarchy: InfoObject Trace Layer7LINKLink indicator for a hierarchy nodenvarchar10
36/BI0/HRSTT_TOTYPHierarchy: InfoObject Object Type (Transp)7LINKLink indicator for a hierarchy nodenvarchar10
37/BI0/HRSTT_TRANRHierarchy: InfoObject Transport Request7LINKLink indicator for a hierarchy nodenvarchar10
38/BI0/HRSTT_TRTGTHierarchy: InfoObject Transport Target7LINKLink indicator for a hierarchy nodenvarchar10
39/BI0/HRSTT_USERHierarchy: InfoObject Trace User7LINKLink indicator for a hierarchy nodenvarchar10
40/BI0/HTCAIFAREAHierarchy: InfoObject InfoArea Analys. Aut7LINKLink indicator for a hierarchy nodenvarchar10
41/BI0/HTCTAPPLHierarchy: InfoObject Appl. Component7LINKLink indicator for a hierarchy nodenvarchar10
42/BI0/HTCTBWOBJCTHierarchy: InfoObject BI Object7LINKLink indicator for a hierarchy nodenvarchar10
43/BI0/HTCTIFAREAHierarchy: InfoObject InfoArea7LINKLink indicator for a hierarchy nodenvarchar10
44/BI0/HTCTMDXFCHierarchy: InfoObject MDX Functions7LINKLink indicator for a hierarchy nodenvarchar10
45/BI0/HTCTPRCSCHNHierarchy: InfoObject Process Chain ID7LINKLink indicator for a hierarchy nodenvarchar10
46/BI0/HTCTQUERIDHierarchy: InfoObject Query (UID)7LINKLink indicator for a hierarchy nodenvarchar10
47/BI0/HTCTSOURSYSHierarchy: InfoObject Source System7LINKLink indicator for a hierarchy nodenvarchar10
48/BI0/HTCTSTATEVTHierarchy: InfoObject Statistics Event7LINKLink indicator for a hierarchy nodenvarchar10
49/BI0/HTCTSYSIDHierarchy: InfoObject BW System7LINKLink indicator for a hierarchy nodenvarchar10
50/BI0/HTCTUSERNMHierarchy: InfoObject User7LINKLink indicator for a hierarchy nodenvarchar10
51/BI0/HTCTUSRNMHierarchy: InfoObject User ID7LINKLink indicator for a hierarchy nodenvarchar10
52/BI0/SLINKMaster Data IDs: InfoObject Link Indicator1LINKLink Indicator for a Hierarchy Nodenvarchar10
53COAT_LINKCOAT: Links4LINKText, 255 Charactersnvarchar2550
54EHPRCC_IMMAPMapping table19LINKSpecification Linknvarchar10
55PYD_D_INSTLPayroll Data Source Instance Link4LINKPayroll Data Source Framework: Free textntext10737418230
56RSDMHIETAB740Model Table: Hierarchies of a Characteristic (from 3.0B)7LINKLink indicator for a hierarchy nodenvarchar10
57YIT_EXAMIDA: Examples8LINKIDA: Data link Demo examplenvarchar100
58YIT_PROCIDA: Processes in IDES12LINKIDA: Data link Ides processnvarchar100
59YIT_TRAIIDA: Training Courses8LINKIDA: Data link training coursenvarchar60
60ZEVENTLINKTable with links to application3LINKLink to applicationnvarchar2000
TOPActivity-Based Costing
61ABC_FTREECO-OM-ABC: Function Tree10LINKLink IDnvarchar10
TOPAdvertising Management
62JHAPAFPIS-M/AM: Contract Determination Log for OPM Item8LINKLink IDnvarchar10
63JJTIKOHYIS-M/AM: Content Components Hierarchy9LINKLink IDnvarchar10
TOPAlert Framework
64SALRTCFLWAlerts: Follow-On Activities of the Alert Category4LINKSubsequent Activityntext10737418230
TOPAnalyzer
65JBRHISPHBAUMSTree Structure for Deactivated Portfolio Hierarchies9LINKLink IDnvarchar10
TOPAuthentication and SSO
66SECURITY_CONTEXTHTTP Security Context (Cross-Server Attributes)4LINKInternal Reference to Security Context (Time-Invariant)varbinary160
TOPBusiness Server Pages
67TAGTREEVIEWTest6LINKntext10737418230
TOPContract Accounts Receivable and Payable
68DFKKCRRepository For Checks45LINKLink to Another Entrynvarchar350
69DFKKCRDELCR: Deleted Payment Medium / Basic Data48LINKLink to Another Entrynvarchar350
TOPCorporate Performance Monitor
70UMR_RI040Risk URL Assignment3LINKURL Link IDnvarchar250
71UMR_RI040TRisk URL Assignment Text Table3LINKURL Link IDnvarchar250
TOPCross-System and Cross-Partner Document Flow
72/SCMB/TREEVIEW2Obsolete - Copy of TAGTREEVIEW from Package SBSPEXT_HTMLB6LINKntext10737418230
TOPData Basis
73RSMAXHIETABHierarchy Node Table with Maximum Possible Structure7LINKLink indicator for a hierarchy nodenvarchar10
TOPData Staging
74RSHIENODETMPHelp Table for Packaged Loading of Hierarchies6LINKLink indicator for a hierarchy nodenvarchar10
TOPEnvironment, Health and Safety
75/TDAG/CPC_IMMAPMapping table19LINKSpecification Linknvarchar10
TOPFloorplan Manager Web Dynpro ABAP
76FPM_ADAPT_LINKAdaptation Links1LINKAdaptation Linknvarchar320
77FPM_ADAPT_RULEAdaptation Rule1LINKAdaptation Linknvarchar320
TOPGovernance, Risk and Compliance
78GRFNRELLINKRelated links3LINKObject IDnvarchar80
79GRFNREPCOLUMNReport: Columns9LINKReport: Assigned link to the fieldnvarchar300
80GRFNREPCOLUMNCReport: Columns - customer10LINKReport: Assigned link to the fieldnvarchar300
TOPHR Administrative Services
81T5ASRLINKHyperlink Types for Additional Information3LINKURL of Link for Additional Informationnvarchar2550
TOPItaly
82T5ITF24AArchive F24 Administration12LINKIdentifiernvarchar100
TOPMaintenance Orders
83/MRSS/C_SGE_CHActivate Change Documents4LINKActivate Change Documents for Tool Linksnvarchar10
84/MRSS/C_SGU_VIEUI Planning Profile: Views6LINKDisplay Linksnvarchar10
TOPMarket Risk Analyzer
85JBRRHBAUMTree Structure of Risk Hierarchy8LINKLink IDnvarchar10
86JBRRHBAUMHTree Structure of Risk Hierarchy (History)9LINKLink IDnvarchar10
87JBRRHBAUM_BACKBackup Table JBRRHBAUM (Required for Transport Imports)8LINKLink IDnvarchar10
TOPMaterial Groups
88WTREEVersion Management for Reclassification Trees10LINKLink IDnvarchar10
TOPMetadata Repository
89RSDMHIETABObsolete from APOLLO -> RSDMHIERTABNEW7LINKLink indicator for a hierarchy nodenvarchar10
90RSDMHIETABNEWModel Table: Hierarchies of a Characteristic (from 3.0B)7LINKLink indicator for a hierarchy nodenvarchar10
TOPRegulatory reporting for insurance companies
91TISSR_OUT_FILINKISSR: betriebswirtschaftliche Klammerung von Anzeigefelder5LINKVerbindung betriebswirtsch. zusammengehöriger Feldersmallint50
92TISSR_OUT_FILI_NISSR: betriebswirtschaftliche Klammerung von Anzeigefelder5LINKVerbindung betriebswirtsch. zusammengehöriger Feldernvarchar40
TOPRemaining Beverage - Obsolete Objects
93/BEV3/CHNODESStructure of Contract Tree9LINKLink IDnvarchar10
TOPReport Tree
94SERPTREEReporting: Tree Structure10LINKLink IDnvarchar10
TOPReporting
95MCSHIERBTree for general hierarchy9LINKLink IDnvarchar10
96MCSHIERKHeader of general hierarchy9LINKColor display of a hierarchy nodenvarchar10
TOPRisk Analysis
97JBRNODETXTAll Information for Display of Hierarchies8LINKLink IDnvarchar10
98JBRPHBAUMSStorage of Portfolio Hierarchy9LINKLink IDnvarchar10
99JBRSVPHBAUMRM: Portfolio Hierarchy for Saved Datasets (Backtesting)10LINKLink IDnvarchar10
TOPRisk Assessment
100EHHSSC_RAS_REGRisk Assessment Regulations3LINKURL Link to Regulationnvarchar2550
101EHHSSD_RAS_REGULRegulation9LINKURL Link to Regulationnvarchar2550
102EHHSSD_RAS_RSNReasons10LINKURL Link for Assessment Reasonnvarchar2550
103EHHSSD_RSK_REGULRisk regulation10LINKURL Link to Regulationnvarchar2550
TOPSales
104ERP_SLS_LINKWorklist Subset Link7LINKWorklist Link IDnvarchar400
TOPSAP NetWeaver Mobile - Use subcomponents
105BWAFVERMobile Engine Version Management5LINKText of length 132nvarchar1320
TOPTransaction Manager
106TCORFTS_CONFIGConfiguration Control6LINKStructure for key linknvarchar300
TOPUser Interface
107WCF_UST_REPORTShared Favorite reports5LINKLogical Link IDnvarchar100
TOPWebClient UI
108WCF_MLC_OBJ_FLDSFields for UI Object types6LINKCheckboxnvarchar10
109WCF_ML_OBJ_FLDSFields for UI Object types5LINKCheckboxnvarchar10
TOPWithout Description
110RSHIENODESHierarchy Node(s)7LINKLink indicator for a hierarchy nodenvarchar10