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

88 columns | Print definition?ERP 6.0  | JOBID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/SLBHSimultaneous Login Batch Process Details3JOBIDJob IDnvarchar80
2GRACCLMQUERYCLM query mapping2JOBIDUUID of the GRC object (char32)nvarchar320
3GRFNEVTPOOLEvent Pool2JOBIDJob IDnvarchar320
4GRFNJOBJob2JOBIDJob IDnvarchar320
5GRFNJOBCASECase Data for Job2JOBIDJob IDnvarchar320
6GRFNJOBDETAILJob Step2JOBIDJob IDnvarchar320
7GRFNJOBPCTXJob Step Context2JOBIDJob IDnvarchar320
8GRFNJOBPOLSPSNPJob Step OLSP Snapshot2JOBIDJob IDnvarchar320
9GRFNJOBPRESULTJob Step Result - Deficiency2JOBIDJob IDnvarchar320
10GRFNJOBPRSTCTXJob Step Result - Context2JOBIDJob IDnvarchar320
11GRFNJOBREGSHRTSTJob - Regulation Shared Test2JOBIDJob IDnvarchar320
12GRPCCLMIDMAPTable to Save CLM PC Job Id mapping2JOBIDUUID of the GRC object (char32)nvarchar320
13T5H81KRegistered employment relationships -- for comm. contracts8JOBIDProgram run identificationnvarchar140
14T5H81TRegistered employment relationships (multiple employer)9JOBIDProgram run identificationnvarchar140
15T5H82KRegistered employment relationships -- for comm. contracts9JOBIDProgram run identificationnvarchar140
16T5H82TRegistered employment relationships (multiple employer)9JOBIDProgram run identificationnvarchar140
17TMAS_D_DDDocument data2JOBIDJob idnvarchar90
18TMAS_D_DFPDocuments for processing4JOBIDJob idnvarchar90
19TMAS_D_DFP7Documents for processing by Trados 20073JOBIDJob idnvarchar90
20TMAS_D_DIPDocuments in process2JOBIDJob idnvarchar90
21TMAS_D_DIP7Documents in process by Trados 20073JOBIDJob idnvarchar90
22TMAS_D_JOBJob table1JOBIDJob idnvarchar90
23TMAS_D_RERRAnalysis result error table2JOBIDJob idnvarchar90
24TMAS_D_RHDAnalysis result header data2JOBIDJob idnvarchar90
25TMAS_D_RT2007Trados 2007 analysis results3JOBIDJob idnvarchar90
26TMAS_D_UDSDUser-defined string document data3JOBIDJob idnvarchar90
27TMAS_D_UDXDUser-defined xstring document data3JOBIDJob idnvarchar90
28TMAS_OLA_D_AERAccumulated results of failed analyses1JOBIDJob idnvarchar90
29TMAS_OLA_D_ASR7Accumulated results of successful analyses1JOBIDJob idnvarchar90
30TMAS_OLA_D_BGJOBBackground jobs of analysis jobs1JOBIDJob idnvarchar90
31TMAS_OLA_D_ERResults of failed analyses1JOBIDJob idnvarchar90
32TMAS_OLA_D_GRAPHAnalysis graphs1JOBIDJob idnvarchar90
33TMAS_OLA_D_JOBAnalysis jobs1JOBIDJob idnvarchar90
34TMAS_OLA_D_LANGAnalysis languages1JOBIDJob idnvarchar90
35TMAS_OLA_D_OBJAnalysis objects1JOBIDJob idnvarchar90
36TMAS_OLA_D_OBJLAnalysis object lists1JOBIDJob idnvarchar90
37TMAS_OLA_D_OBJTAnalysis object types1JOBIDJob idnvarchar90
38TMAS_OLA_D_SR7Results of successful analyses1JOBIDJob idnvarchar90
39VEG_JOB_DETAILJob details for multiple conversion3JOBIDJob IDint100
TOPBackground Processing
40FAVSELSUser-Specific Favorite Selection Criteria13JOBIDBackground job namenvarchar320
TOPE-Recruiting
41HRP5125DB Table for Infotype 512534JOBIDJobnvarchar80
TOPHR Managers Desktop
42HRT1019Table Section Infotype 1019 Required Positions4JOBIDObject IDnvarchar80
TOPOffice Suite Program
43/OSP/T_JOBINFOOSP Report Schedule Jobs information3JOBIDJob IDnvarchar80
TOPOLAP Technology
44RSDDBMDJOBPROTBIA Master Data Indexing Job Log1JOBIDJob ID of BWA Master Data Indexing Jobint100
45RSDDBMDJOBSTATMaster Data Indexing Job - Status1JOBIDJob ID of BWA Master Data Indexing Jobint100
46RSDDTREXNEWMDMD Upload: SIDs for InfoObjects in TREX Aggregates3JOBIDJob ID of BWA Master Data Indexing Jobint100
47RSDDTREXNEWSIDNew SIDs for InfoObjects in TREX Aggregates3JOBIDJob ID of BWA Master Data Indexing Jobint100
TOPPayroll
48T5H42Jelentett GYED sorszámok27JOBIDProgramfutás azonosítójanvarchar140
49T5H43Jelentett TGYS sorszámok24JOBIDProgramfutás azonosítójanvarchar140
50T5H4OReported "closed incapacities to work"34JOBIDProgram run identificationnvarchar140
51T5H81Registered employment relationships5JOBIDProgram run identificationnvarchar140
52T5H81MRegistered employment relationships -- for comm. contracts7JOBIDProgram run identificationnvarchar140
53T5H82Registered employment relationships - sent statuses5JOBIDProgram run identificationnvarchar140
54T5H82IBejelentett munkaviszonyok - futásazonosítók3JOBIDProgramfutás azonosítójanvarchar140
55T5H82MRegistered employment relationships -- for comm. contracts7JOBIDProgram run identificationnvarchar140
56T5H83Data of other legal relationships23JOBIDProgram run identificationnvarchar140
57T5H8XChanges reported to MEP5JOBIDProgram run identificationnvarchar140
TOPProcess Controls
58GRPCJOBCASECase Data for Job2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
59GRPCJOBLOGJob Log from Scheduler2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
60GRPCRLSETT_SNPRule Parameters Description3JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
61GRPCRULET_SNPRule Description3JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
62GRPCRULE_SNPRule for Snapshot2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
63GRPCRVVAL_SNPRule Criteria Value2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
64GRPCSCHEDULELISTScheduler Watch List2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
65GRPCSCHEDULERScheduler2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
66GRPCTRANS_SNPGRC Rules Analysis2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
67GRPC_OLSP_SNPAssign Organization unit value to Organization Unit Group2JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPProcess Controls -Automated Controls
68GRPCRTA_TJOBSScheduler Watch List1JOBIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPProduct Safety
69CVDDHEHS: Report shipping orders104JOBIDProcessing Cycle ID Numbernvarchar200
70ESTOHEHS: WWI generation / print jobs41JOBIDProcessing Cycle ID Numbernvarchar200
TOPService Data Download
71/SDF/RBE_CS3SQL Check Steps for SDA Analysis5JOBIDRBE Job IDnvarchar40
72/SDF/RBE_JOBJobs for SQL Check Step Execution in SDA Analysis3JOBIDRBE Job IDnvarchar40
TOPTransport Management System
73TMSBCIBOXTMS CI Background Container1JOBIDTMS CI Background Job Numbernvarchar100
74TMSBCIIBOXTMS CI Background Container1JOBIDTMS CI Background Job Numbernvarchar100
75TMSBCIJOYTMS CI Background Control1JOBIDTMS CI Background Job Numbernvarchar100
76TMSBCINEXTMS CI Next Job Number2JOBIDTMS CI Background Job Numbernvarchar100
77TMSBCINTABTMS CI Background Container1JOBIDTMS CI Background Job Numbernvarchar100
78TMSBCIOBJTMS: Object Table of Structured Objects in Container1JOBIDTMS CI Background Job Numbernvarchar100
79TMSBCIXBOXTMS CI Background Container1JOBIDTMS CI Background Job Numbernvarchar100
80TMSBUFCNTTMS Manager: Total Number of Requests in Transport Buffer21JOBIDTMS CI Background Job Numbernvarchar100
81TMSBUFREQTMS Manager: Transport Requests in Transport Buffer15JOBIDTMS CI Background Job Numbernvarchar100
82TMSTLOCKNPTMS tp: New Lock Table for Project Imports4JOBIDTMS CI Background Job Numbernvarchar100
83TMSTLOCKNRTMS tp: New Lock Table for Single Imports4JOBIDTMS CI Background Job Numbernvarchar100
84TMSTLOCKPTMS TP: Lock Table for Project Imports3JOBIDTMS CI Background Job Numbernvarchar100
85TMSTLOCKRTMS TP: Lock Table for Individual Imports3JOBIDTMS CI Background Job Numbernvarchar100
TOPUtilities
86TBILOGDirect Input: Historical Data4JOBIDJob ID (direct input)nvarchar320
87TBIZUJob ID to job name assignments4JOBIDJob ID (direct input)nvarchar320
TOPVisual Enterprise Generator
88VEG_JOBLOGJob Ids of business objects with status3JOBIDJob IDint100