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

74 columns | Print definition?ERP 6.0  | EVENTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRFNEVTEVALEvent Evaluation Log3EVENTIDEvent IDnvarchar200
2GRFNEVTPOOLEvent Pool3EVENTIDEvent IDnvarchar200
3N1WD_EVENTEvent Management for WD Notification Events2EVENTIDUnique ID of Registrationnvarchar800
4OAF_C_SCHEDTMPLTemplate for Job Scheduling11EVENTIDBackground Processing Eventsnvarchar320
5RSMONREQDELREDU1Monitoring of Reduce/Delete Runs for critical DTAs18EVENTIDBackground Processing Eventnvarchar320
6RSVARIREQDELREDUVariant for Start Selections of Reduce/Delete Runs20EVENTIDBackground Processing Eventnvarchar320
7TBTCYTable for Jobs in Status "Ready"14EVENTIDBackground Processing Eventnvarchar320
8TFM07Event Type1EVENTIDEvent type IDnvarchar40
9TFM08Event Type Long Name2EVENTIDEvent type IDnvarchar40
10TFM09Process-Function-Event Type Assignment7EVENTIDEvent type IDnvarchar40
11TFM10Entity-Event Type Assignment4EVENTIDEvent type IDnvarchar40
12ZSYSTEM_JOBSJob Control for Landscape Conversion19EVENTIDBackground event IDnvarchar320
TOPAMI Event Management
13TEAMI_EM_EVTATTRIS-U Event Management Attributes for AMI Events2EVENTIDIS-U AMI Event Management Internal Event IDnvarchar200
14TEAMI_EM_EVTINTSmart Meter Event Interrupts2EVENTIDIS-U AMI Event Management Internal Event IDnvarchar200
15TEAMI_EM_EVTMSGMessages for Smart Meter Events2EVENTIDIS-U AMI Event Management Internal Event IDnvarchar200
16TEAMI_EM_EVTRESResults for AMI Events2EVENTIDIS-U AMI Event Management Internal Event IDnvarchar200
17TEAMI_EM_EVTSIS-U AMI Event Management AMI Events2EVENTIDIS-U AMI Event Management Internal Event IDnvarchar200
TOPBackground Processing
18BTCEVTHISTORYEvent History: History of Background Processing Events2EVENTIDBackground Processing Eventnvarchar320
19BTCEVTJOBList of jobs waiting for events1EVENTIDEvent ID for background processingnvarchar320
20BTCSEDDescription of system event IDs for background processing2EVENTIDBackground Processing Eventnvarchar320
21BTCSEVTable for system event IDs for background processing1EVENTIDBackground Processing Eventnvarchar320
22BTCUEDDescription of user event IDs for background processing2EVENTIDBackground Processing Eventnvarchar320
23BTCUEVUser event IDs for background processing1EVENTIDBackground Processing Eventnvarchar320
24FAVSELSUser-Specific Favorite Selection Criteria12EVENTIDBackground Processing Eventnvarchar320
25TBTCOJob Status Overview Table41EVENTIDBackground Processing Eventnvarchar320
TOPCommunication
26NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events2EVENTIDIdentification of an Eventnvarchar320
TOPContract Accounts Receivable and Payable
27TFK065BCollection History: Customizing of Events2EVENTIDIdentification of Collection History Eventnvarchar40
28TFK065BTCollection History: Customizing of Events3EVENTIDIdentification of Collection History Eventnvarchar40
29TFK066BCollection History: Customizing of Variants, Details4EVENTIDIdentification of Collection History Eventnvarchar40
TOPData Basis
30RSLPOSCHEDLogical Partitioning: Scheduling Options for BTC Jobs12EVENTIDBackground Processing Eventnvarchar320
TOPData Staging
31RSCSTRUHelp table for structure change21EVENTIDBackground Processing Eventnvarchar320
32RSDELPARTAggregation management of the IC for the Monitor16EVENTIDBackground Processing Eventnvarchar320
33RSICAGGRAggregation management of the IC for the Monitor17EVENTIDBackground Processing Eventnvarchar320
34RSICCOMPPLANScheduling InfoCube compression17EVENTIDBackground Processing Eventnvarchar320
35RSICNEWAggregation management of the IC for the Monitor15EVENTIDBackground Processing Eventnvarchar320
36RSICSTATInfoCube settings for aggregating from the monitor17EVENTIDBackground Processing Eventnvarchar320
37RSODSACTActivation of ODS M Records19EVENTIDBackground Processing Eventnvarchar320
38RSPCINTERRUPTVariants for the Trigger Processes10EVENTIDBackground Processing Eventnvarchar320
39RSPCTRIGGERVariants for the Trigger Processes10EVENTIDBackground Processing Eventnvarchar320
40RSPSADELDelete PSA request in batch22EVENTIDBackground Processing Eventnvarchar320
41RSSDBATCHTable for batch run scheduler (new)24EVENTIDBackground Processing Eventnvarchar320
42RSSDBATCHHISTTable for Background Run of Scheduler - Changes/History25EVENTIDBackground Processing Eventnvarchar320
43RSSDBATCHSHTable for Batch Run Scheduler (New)23EVENTIDBackground Processing Eventnvarchar320
TOPFramework
44CRMC_IC_EVENTSRepository of IC Events3EVENTIDEvent IDnvarchar600
45CRMC_IC_EVENTS_TRepository of IC Events3EVENTIDEvent IDnvarchar600
46CRMC_IC_EV_GR_EVEvent Assignment to Group5EVENTIDEvent IDnvarchar600
47CRMC_IC_EV_PARAMEvent Parameters3EVENTIDEvent IDnvarchar600
48CRMC_IC_EV_PARATEvent Parameters3EVENTIDEvent IDnvarchar600
TOPMonitoring
49SAPWLDMTHDSAP Workload: Dynamically-Called Method for Events1EVENTIDSAP workload: Event IDnvarchar30
TOPOLAP Technology
50RSDDSTATEVDATABW Statistics (OLAP), Key Figures for the Events4EVENTIDOLAP Statistics Event (Type NUMC9)nvarchar90
51RSDDSTATEVENTSOLAP Statistics Events1EVENTIDOLAP Statistics Event (Type NUMC9)nvarchar90
52RSDDSTATEVENTSTOLAP Statistics Events, Texts2EVENTIDOLAP Statistics Event (Type NUMC9)nvarchar90
53RSDDSTATLOGGINGLogging Table for OLAP Statistics6EVENTIDOLAP Statistics Event (Type NUMC9)nvarchar90
TOPPerformance Assessment Workbench
54SLS_BLOGPAW - logging table for BAPIs3EVENTIDEvent identification (PAW)nvarchar80
55SLS_LOGPAW - Logging Table (remake)3EVENTIDEvent identification (PAW)nvarchar80
56SLS_LOG2PAW - Logging Table (remake)3EVENTIDEvent identification (PAW)nvarchar80
57SLS_LOGLPAW - logging error3EVENTIDEvent identification (PAW)nvarchar80
58SLS_PRESPAW - Person Results Structure11EVENTIDEvent identification (PAW)nvarchar80
59SLS_QLOGPAW - Qualification Generation Log9EVENTIDEvent identification (PAW)nvarchar80
60SLS_QPROTPAW - Batch Qualification Generation Protocol3EVENTIDEvent identification (PAW)nvarchar80
TOPProduct Safety
61CVCHEEHS: Event buffer for report shipping1EVENTIDBackground Processing Eventnvarchar320
62CVDDHEHS: Report shipping orders130EVENTIDBackground Processing Eventnvarchar320
TOPProduction and Revenue Accounting
63OIUP_PDM_JOBSPDM: Job Data42EVENTIDBackground Processing Eventnvarchar320
TOPRevenue
64OIUE2_RUN_HDRProc 2.0 - Run Header24EVENTIDBackground Processing Eventnvarchar320
TOPRoyalty Reporting
65OIUREP_2014_INFOMMS-2014 - Report Executions Start information13EVENTIDBackground Processing Eventnvarchar320
TOPSAP Healthcare - Industry-Specific Components for Hospitals
66N2BIEVENTBase Items: Customizing for Event Processing4EVENTIDEvent Mgmt: Event Definition IDnvarchar100
TOPService Data Download
67/SOMO/JOSCHEDLJob scheduling table for business process monitoring18EVENTIDnvarchar320
68/SOMO/JOSCHEDLTJob Schedule Local Template15EVENTIDnvarchar320
TOPTax Reporting
69OIUX3_MIG_CTRLTax Reporting - Migration Control22EVENTIDBackground Processing Eventnvarchar320
70OIUX3_RUN_HDRTax Reporting - Run Header16EVENTIDBackground Processing Eventnvarchar320
71OIUX7_RUN_HDRTax 2.0 - WYGP Run Header15EVENTIDBackground Processing Eventnvarchar320
TOPTranslation Tools
72LXELOGSLXE log events1EVENTIDEight-digit numeric valuenvarchar80
TOPWithout Description
73RSACTION2EVIDMapping of Action types to Event IDs2EVENTIDOLAP Statistics Event (Type NUMC9)nvarchar90
74RSSUBSTEP2EVIDMapping of DTP Command, Sub-step to Event IDs3EVENTIDOLAP Statistics Event (Type NUMC9)nvarchar90