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

112 columns | Print definition?ERP 6.0  | RUNTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/LIF_RUNTIMEFILE TO SHAAM - VENDOR'S LAST RUNTIME3RUNTIMEDatenvarchar80
2/BOBF/BUF_LOGLocal table to store BOPF buffer logs4RUNTIMEint100
3/GSINS/NLG_FILESGBA NL: Values of Importing/Exporting Reports3RUNTIMETime of Runnvarchar60
4/GSINS/NLG_FIMSGGBA NL: Link Import/Export Report to Incoming/Outgoing Msg3RUNTIMETime of Runnvarchar60
5/MRSS/D_PPM_RUNTMRS delay measurements13RUNTIMERuntimeint100
6/OPT/IT_BJLOGTable to store last run time stamp5RUNTIMETimenvarchar60
7BWSD_LOGDStatus Information for Individual Transfer Locations9RUNTIMERuntime in Millisecondsdecimal103
8BWSD_LOGIStatus of Element Objects from Transfer13RUNTIMERuntime in Millisecondsdecimal103
9BWSD_LOGOStatus of Scenario Objects from Transfer13RUNTIMERuntime in Millisecondsdecimal103
10BWSD_LOGSStatus for Elementary Transfer Processes5RUNTIMERuntime in Millisecondsdecimal103
11CNVA_00555_ANAAnalysis details for Run Time Estimation17RUNTIMERun Time (in seconds)nvarchar100
12CNVCMIS_POSTPROSCMIS: Status table post-processing17RUNTIMETimenvarchar60
13CNV_LM_DDIC_EFEffects of DDIC Changes2RUNTIMEText Linenvarchar720
14DOCM_STG_PREREQDBOSC-CM: Staging Prerequisites3RUNTIMEnvarchar100
15GRACHROBJACTVLHR Object Action Violation Table16RUNTIMETimestamp when the Field was Last Updateddecimal150
16GRACHROBJCRPVLHR Object Critical Role/Profile Violation Table10RUNTIMETimestamp when the Field was Last Updateddecimal150
17GRACHROBJPRMVLUser Permission Violation Table21RUNTIMETimestamp when the Field was Last Updateddecimal150
18GRACPROFACTVLEXTProfile Action Violations for Extended Objects12RUNTIMETimestamp when the Field was Last Updateddecimal150
19GRACPROFILEACTVLProfile Action Violation Table12RUNTIMETimestamp when the Field was Last Updateddecimal150
20GRACPROFILECRPVLProfile Critical Role/Profile Violation Table6RUNTIMETimestamp when the Field was Last Updateddecimal150
21GRACPROFILEPRMVLProfile Permission Violation Table16RUNTIMETimestamp when the Field was Last Updateddecimal150
22GRACPROFPRMVLEXTProfile Permission Violations for Extended Objects16RUNTIMETimestamp when the Field was Last Updateddecimal150
23GRACROLEACTVLRole Action Violation Table15RUNTIMETimestamp when the Field was Last Updateddecimal150
24GRACROLEACTVLEXTRole Action Violations for Extended Objects15RUNTIMETimestamp when the Field was Last Updateddecimal150
25GRACROLECRPVLRole Critical Role/Profile Violation Table9RUNTIMETimestamp when the Field was Last Updateddecimal150
26GRACROLEPRMVLRole Permission Violation Table20RUNTIMETimestamp when the Field was Last Updateddecimal150
27GRACROLEPRMVLEXTRole Permission Violation Table20RUNTIMETimestamp when the Field was Last Updateddecimal150
28GRACUSERACTVLUser Action Violation Table15RUNTIMETimestamp when the Field was Last Updateddecimal150
29GRACUSERACTVLEXTUser Action Violations for Extended Objects15RUNTIMETimestamp when the Field was Last Updateddecimal150
30GRACUSERCRPVLUser Critical Role/Profile Violation Table9RUNTIMETimestamp when the Field was Last Updateddecimal150
31GRACUSERPRMVLUser Permission Violation Table20RUNTIMETimestamp when the Field was Last Updateddecimal150
32GRACUSERPRMVLEXTUser Permission Violations for Extended Objects20RUNTIMETimestamp when the Field was Last Updateddecimal150
33HRBW_CNTB_DELTATime stamps for Payroll Reconcilliation Extractors6RUNTIMETimenvarchar60
34PYD_D_INSTLOGPayroll Data Source Instance Log5RUNTIMEint100
35RSCRMD_IMP_TRACETrace results table8RUNTIMENatural Numberint100
36RSCRM_IMP_TRACETrace results table8RUNTIMERuntime measurement in microsecondsdecimal110
37RSVEPVALUEPerformance-Messungen: Messergebnisse4RUNTIMEfloat150
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
38CRM_ECLOG_SCRReplicated Log Entries of a Script Line20RUNTIMETotal Runtime in the Command Blockdecimal60
TOPAccounting Interface
39GLE_ECS_DI_ADM0Management of ECS Direct Input9RUNTIMETime of Program Runnvarchar60
TOPAssortment
40WRF_APC_MPAMarkdown Profile Assignment13RUNTIMERuntime of Markdown Profilenvarchar30
TOPBackground Processing
41TBTCRBatch scheduler execution time3RUNTIMEBatch scheduler start timenvarchar60
TOPBank Customer Accounts
42BKKBENCHBenchmark Results18RUNTIMERuntimenvarchar60
43BKKBENCHACBALBenchmark Results Account Balancing17RUNTIMERuntimenvarchar60
44BKKBENCHBKSTATBenchmark Results Bank Statement13RUNTIMERuntimenvarchar60
TOPBatch-Oriented Parallel Processing of Mass Data
45BANK_PP_PARUNHDGeneral Data on Mass Runs (Header)12RUNTIMETime of Program Runnvarchar60
TOPBusiness Planning and Simulation
46UPWB_DATAData in XML Format of BSP Applications2RUNTIMEStorage Type (Save, Runtime, Memory,...)nvarchar10
TOPBW Service API
47RSBIWBENCHBenchmarking Business Information Warehouse4RUNTIMERuntimeint100
TOPClaims Management
48ICL_RIRUNRI-Run Administration Table3RUNTIMETime Stampdecimal150
TOPClient Copy
49CCCFLOWClient Copy Control Flow15RUNTIMERuntimeint100
TOPContract Accounts Receivable and Payable
50DFKKCMBRFTRACEBRF Trace for Collections Management21RUNTIMERuntimeint100
TOPCross-Application Components
51/OPT/VIM_LOAD_LGLog of data load4RUNTIMESystem Timenvarchar60
52TASUTREPASU: Toolbox: Reports to be started11RUNTIMEASU: Toolbox: Runtime of the repair reportnvarchar10
TOPData Basis
53RSCNVMONTable to store the general data for Monitor8RUNTIMELast Run Time for Conversion Requestnvarchar60
54RSDRI_DS_TC_LOGTest Data RSDRI10RUNTIMENatural Numberint100
55RSR_PE_LOGLog for Planning Engine7RUNTIMEint100
TOPData Collection
56TKEV6technical report information per variant8RUNTIMERuntimeint100
TOPData Replication Framework
57DRFD_SERVOUT_LOGInformation for a DRF_OUTBOUND Run11RUNTIMERuntimeint100
TOPData Staging
58RSPCLOGTIMECACHECache for Runtime Statistics3RUNTIMEField of type FLTPfloat1516
TOPDatabase Interface, Database Platforms
59DBA_DBH_COLL_JOBDBA-DBH: Collector Controller Jobs6RUNTIMEDBA-DBH: Runtimeint100
60DBA_DBH_COLL_RUNDBA-DBH: Collector Runtime Statistics nad Return Codes4RUNTIMEDBA-DBH: Runtimeint100
TOPeCATT Extended Computer Aided Test Tool
61ECLOG_SCRTable of Log Entries for a Script Line19RUNTIMETotal Runtime in the Command Blockdecimal60
TOPEnterprise SOA
62BSSOA_RSPR_CORResponse Receiver Correlation7RUNTIMEProxy Runtimenvarchar10
TOPGlobal Performance Analysis Transaction ST3
63AMESISUBGlobal Performance Analysis: ESI Statistics: Single Records10RUNTIMEResponse Time in Millisecondsdecimal240
TOPGRC Access Control Plug-In
64/VIRSA/ALERTLISTCompliance Calibrator Alert List35RUNTIMESystem Timenvarchar60
TOPInterestCharge Calculation
65BKKM3BCA: Parameters for Mass Runs in Parallel Processing11RUNTIMETime of Program Runnvarchar60
66BKKMPARUNHDGeneral Data for Mass Runs (Header)10RUNTIMETime of Program Runnvarchar60
TOPJoint Venture und Production Sharing Accounting
67RGJAFVC470Control table for transfer JV data from AFVC to AFVU8RUNTIMECPU consumption for dialog work processint100
TOPliveCache Applications
68/SAPAPO/OM_LVCliveCache Description10RUNTIMEliveCache: Version of runtime environmentnvarchar400
TOPMaintenance Orders
69/MRSS/C_OPT_SYSDefine Optimization Profile6RUNTIMERuntime for Optimizerint100
TOPMonitoring
70ALDBSTOOLCCMS Monitoring Arch.: Database Segment: MTE Method Data14RUNTIMEAlert: Time value in timeformatnvarchar60
TOPOLAP Technology
71RSDDICREPARTREQParameter for a Repartitioning Request27RUNTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
72RSDDSTATINFOBW Statistics (OLAP), Information by Navigation Step8RUNTIMERuntimedecimal216
73RSDRC_TC_LOGTest Data RSDRI12RUNTIMENatural Numberint100
74RSDRI_TC_LOGTest Data RSDRI15RUNTIMENatural Numberint100
75RSDRP_TC_LOGTest Data RSDRP (Parallelizes Query)9RUNTIMENatural Numberint100
76RSDRS_TC_LOGTest Data RSDRS14RUNTIMENatural Numberint100
77RSDRV_TC_LOGTest Data RSDRV11RUNTIMENatural Numberint100
78RSDRW_TC_LOGTest Data RSDRP (Parallelizes Query)8RUNTIMENatural Numberint100
TOPPerformance Assessment Workbench
79SLS_BLOGPAW - logging table for BAPIs6RUNTIMETimenvarchar60
80SLS_CEVENTPAW - Comments for an event6RUNTIMETimenvarchar60
81SLS_CPETPAW -Comments for an event / test / participant assignment4RUNTIMETimenvarchar60
82SLS_CXETPAW - Comments for an event / test assignment7RUNTIMETimenvarchar60
83SLS_QPROTPAW - Batch Qualification Generation Protocol6RUNTIMEPAW - Program Run Timenvarchar80
TOPProfit Center Accounting
84KE1_WU_RUNIDPCA Where-Used List: Runs11RUNTIMERuntimeint100
TOPProfitability Analysis
85TKEBO_PROTPCM Model Log17RUNTIMEGross Time Required to Readdecimal152
86TKETD_SETTINGSCO-PA Top-Down: Technical Settings16RUNTIMERuntime Analysisnvarchar10
TOPRetail Enterprise Services
87WESD_SERVOUT_LOGInformation for a RWES_SERVICES_OUT Run11RUNTIMEint100
TOPSAP Business Workflow
88SWFPFRUNTIMEData for Runtime Collector6RUNTIMERuntime Fieldnvarchar120
TOPSAP NetWeaver Mobile - Use subcomponents
89MEMON_TECH_CONAGS Monitoring: Resource Consumtion Monitor8RUNTIMEExact Execution Timedecimal217
90MEMON_TECH_STATMName, runtime of each executed method5RUNTIMEAverage runtime of the methodint100
91MEMSD_RUNTIMTYPEMI:Runtime Environments2RUNTIMERuntime Environment for Mobile Component Descriptornvarchar400
92MEREP_505Inbox/Outbox Worklist13RUNTIMEExact Execution Timedecimal217
93MEREP_505IInbound Worklist10RUNTIMEExact Execution Timedecimal217
94MEREP_505JJob Worklist10RUNTIMEExact Execution Timedecimal217
95MEREP_505OOutbound Worklist11RUNTIMEExact Execution Timedecimal217
96MEREP_506Synchronizer Worklist12RUNTIMEExact Execution Timedecimal217
97MEREP_602Runtime Table12RUNTIMEExact Execution Timedecimal217
98MSDRUNTIMETMI:Runtime Environments4RUNTIMERuntime Environment for Mobile Component Descriptornvarchar400
TOPSAP Records Management
99SRM_INDX1Table for Queue Elements24RUNTIMERuntime in Microsecondsint100
100SRM_INDX3Table for Deleted Queue Elements24RUNTIMERuntime in Microsecondsint100
TOPSchedule Manager
101SCMA_CONTSchedule Manager: TVARV Variable in Workflow Container4RUNTIMESchedule Manager: Container Element from Runtime/Defin. Timenvarchar10
TOPService Data Download
102/SDF/BPM_ASTADBPMon Application Statistical Records21RUNTIMEint100
103/SDF/BPM_ASTAD2BPMon Application Statistical Records26RUNTIMEint100
104/SDF/BPM_TSTADBPMon Technical Statistical Records12RUNTIMEint100
TOPUSA
105BTXEERRBSI: Error messages4RUNTIMETime of payroll runnvarchar60
106BTXERESBSI: Employee/Employer tax4RUNTIMETime of payroll runnvarchar60
107BTXTERRBSI: Employee Payroll Error Message Grouping9RUNTIMETime of payroll runnvarchar60
108BTXTRESBSI: Tax Results9RUNTIMETime of payroll runnvarchar60
TOPWithout Description
109RSTT_LOGRUNArchive for Test Runs16RUNTIMERuntimedecimal216
110RSTT_LOGSEQArchive for Results of Test Sequences12RUNTIMERuntimedecimal216
111RSTT_LOGUNITArchive for Results of Test Units14RUNTIMERuntimedecimal216
112RSTT_TDATALData Transfer Logs13RUNTIMEDecimal Numberdecimal102