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

145 columns | Print definition?ERP 6.0  | ENDTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEP/T_NEEDGraphischer Leitstand: Bedarfe (einzuplanende Objekte)12ENDTIMEEndzeitnvarchar60
2/GEP/T_SPLITGraphischer Leitstand: Splits (eingeplante Objekte)13ENDTIMEEndzeitnvarchar60
3/SAPPSSRM/SLBHSimultaneous Login Batch Process Details6ENDTIMETime in Processnvarchar60
4/SOMO/JOBMON11Job schedule information45ENDTIMEnvarchar60
5CNVA_00555_STATEState Table for Run Time Estimation10ENDTIMEField of type TIMSnvarchar60
6CNVA_CCD_ANA_STAState Table for CC Deletion Analysis Package11ENDTIMEField of type TIMSnvarchar60
7CNVCMISBACKUP_EXBackup Functionality - Runtime Information11ENDTIMEnvarchar60
8CNVC_SCNG_EXTRExtracts7ENDTIMETimenvarchar60
9CNVMBTDEXACTIONSDMIS PCL Data Extract Action history6ENDTIMETime Stamp for the End of the Activitydecimal150
10CNVMBTDEXFILSTATDMIS PCL Status of Data Extract Files8ENDTIMETime Stamp for the End of the Activitydecimal150
11CNVMBTPEBSTATEStatus table for execution of all process execution blocks11ENDTIMETime Stamp to Specify Completion of Specified Activitydecimal150
12CNVMBTPEMSTATEProcess Execution Information5ENDTIMETime Stamp to Specify Completion of Specified Activitydecimal150
13CNVMBTSTATEStatus table for execution of all activities and history11ENDTIMETime Stamp to Specify Completion of Specified Activitydecimal150
14CNVMBTSUBSTATEStatus table for execution of all subactivities and histor10ENDTIMETime Stamp to Specify Completion of Specified Activitydecimal150
15CNV_10020_ASTATEStatus of the analysis programs16ENDTIMEProgram end timedecimal150
16CNV_10020_STATEStatus of the determination programs21ENDTIMEProgram end timedecimal150
17CNV_10020_STATEHStatus of the determination programs - History22ENDTIMEProgram end timedecimal150
18CNV_10020_TRACKStatistics for executed determinations21ENDTIMEProgram end timedecimal150
19CNV_20308_CMPHeader Data for Package Comparison30ENDTIMETimenvarchar60
20CNV_20308_DLDownloads17ENDTIMETimenvarchar60
21CNV_ADT_DP_LOGT. Summary: Data provider execution log (single DP)8ENDTIMETimenvarchar60
22CNV_ADT_DP_LOGPT. Summary: Data provider execution log (whole package)8ENDTIMETimenvarchar60
23DMC_IU_UVERSMWB: Backup Copy of UVERS6ENDTIMETimenvarchar60
24DMC_MDS_AVERSMDS: Information About Updates of R/3 Add-On Products8ENDTIMETimenvarchar60
25DMC_MDS_UVERSMDS: Backup of Upgrade Information7ENDTIMETimenvarchar60
26DVM_BOF_RUNSBusiness Objects Footprint runs13ENDTIMETimenvarchar60
27EHPRCD_PERFCP: Performance Tests5ENDTIMEEnd Time of Performance Testnvarchar60
28REQLINESRTemporary Line Data: Requirement Coverage Request (Services)52ENDTIMEEnd Timenvarchar60
29RSCNVSTEPSteps for dimension conversion9ENDTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
30RSDB2A_STATDB2 Accelerator: Load statistics4ENDTIMEDB2-z/OS: General purpose timestamp in DB2 hex formatnvarchar200
31SUBST_SLANA_HDRSL Analytics Header Data8ENDTIMEnvarchar60
32ZEVENT_PRESENTATTable for the presentations5ENDTIMEEnd time of presentationnvarchar60
33HRP1774DB Table for Infotype 177424ENDTIMEEnd Time of Individual Worknvarchar60
34HRT1750Table Section for Infotype 175011ENDTIMEEnd Timenvarchar60
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
35CRM_ECLOG_HEADTable for Replicated eCATT Log Header7ENDTIMEFinish Timenvarchar60
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
36DDACLExclusion times for ABAP/4 Dictionary actions6ENDTIMEEnd of action locknvarchar60
TOPBackground Processing
37BTCOMSETDefinition of operation type sets and exception op. modes5ENDTIMEOperation mode start or end timenvarchar60
38TBTCOJob Status Overview Table21ENDTIMEBatch job start timenvarchar60
TOPBank Customer Accounts
39BKKBENCHBenchmark Results11ENDTIMEEnd timenvarchar60
40BKKBENCHACBALBenchmark Results Account Balancing15ENDTIMEEnd timenvarchar60
41BKKBENCHBKSTATBenchmark Results Bank Statement11ENDTIMEEnd timenvarchar60
TOPBusiness Application Support
42CNVRUNTIMEHELPTemporary storage of runtime info for terminated programs11ENDTIMEConversion: Program finish timedecimal150
43CNVSTATEConversion: Status of programs17ENDTIMEConversion: Program finish timedecimal150
TOPBusiness Consolidation
44UCST001SEM-BCS: Performance Statistics7ENDTIMESystem Timenvarchar60
TOPBusiness Server Pages
45AUOFFERAuction Offer Table5ENDTIMEAuction Time Formatnvarchar60
TOPChange Transport System
46TPALOGHDRHeader Table for TPALOG3ENDTIMETime Stamp in CTSnvarchar140
47TPLOGNAMEStp: Names of Log Files and Times Used5ENDTIMETime Stamp in CTSnvarchar140
48TPLOGNAMESStp: Namen und Verwendungszeiten von Protokollen (Non-Abap-S)6ENDTIMEZeitstempel im CTSnvarchar140
TOPClaims Management
49ICLSPAPPTAppointment with Vendor12ENDTIMETo Timenvarchar60
50ICL_RIRUNRI-Run Administration Table5ENDTIMEProcessing Period Todecimal150
51ICSSPAPPTAppointment with Vendor12ENDTIMETo Timenvarchar60
TOPClinical System
52N2GL_TM_SCHEDULEpathways Patient Pathway29ENDTIMEEnd Time of Patient Pathwaynvarchar60
TOPContract Accounts Receivable and Payable
53DFK_JC_JOBINFOIndividual Job Overview6ENDTIMETIME Data Element for SYSTnvarchar60
TOPData Retention Tool
54TXX_ADMI_RESDART-Administration ---Resource Management ---7ENDTIMEResource Creation Time: Endnvarchar60
55TXX_ADMI_SEGSDART-Administration ---Segment-Management---6ENDTIMESegment Creation Time: Endnvarchar60
TOPDatabase Interface, Database Platforms
56DB6PMPROTDB6: Protocol Table for DBA Actions5ENDTIMEDB6: Timestamp (Format: YYYYMMDDHHMMSS)nvarchar140
TOPeCATT Extended Computer Aided Test Tool
57ECLOG_AIDXTable for Log Archive Index14ENDTIMEFinish Timenvarchar60
58ECLOG_HEADTable for Log Header6ENDTIMEFinish Timenvarchar60
59ECLOG_HYDRASeveral Header Entries for Log15ENDTIMEFinish Timenvarchar60
60ECTRACEeCATT Recordings15ENDTIMESystem Timenvarchar60
61TZRR_EVCMDTestZone: Result Repository Event Command8ENDTIMETime Stamp of Eventnvarchar60
62TZRR_EXECTestZone: Result Repository Start Activity Data13ENDTIMEFinish Timenvarchar60
TOPEnd User Technology
63RSR_PREC_QUEUEPersistant Precalculation Queue10ENDTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPEnergy Data Management
64EEDMSETTLDOCRUNSettlement Document (Run)17ENDTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPEnvironment, Health and Safety
65/TDAG/CPT_PERFCP: Performance Tests5ENDTIMEEnd Time of Performance Testnvarchar60
TOPExternal Services
66ESLLLines of Service Package79ENDTIMEEnd Timenvarchar60
TOPGeneral Ledger Accounting
67NGLM_ANA_HDAnalysis Run Header7ENDTIMETimenvarchar60
TOPGlobal Performance Analysis Transaction ST3
68AMASTAGlobal Performance Analysis: Application Statistc (from 7.0)11ENDTIMESAP Workload NW Collector: Timenvarchar60
69AMESISTAGlobal Performance Analysis: Statistics Main Rec + ESI Total11ENDTIMESAP Workload NW Collector: Timenvarchar60
70AMSTAGlobal Performance Analysis: Statistical Data7ENDTIMEEnd Time (Local) for Performance Log Statistical Recordnvarchar60
TOPI18N Unicode
71UMGTSKQSUMG: Worklist11ENDTIMEEnd Timenvarchar60
TOPImplementation Guide
72EXCEPT1IMG Activity-Specific BC Set Error Exception Table21ENDTIMETimenvarchar60
73EXCEPT2Object-Specific BC Set Error Case Exception Table18ENDTIMETimenvarchar60
TOPIndustry Solution Catch Weight Management
74/CWM/MIG_PROT_HMigration Log Header9ENDTIMEnvarchar60
TOPInformation Quality Management
75SIQMRUNSInspection Runs (Header Table)8ENDTIMEEnd Time/Datedecimal217
TOPMaintenance Orders
76/MRSS/D_DEM_PSRejected and/or deleted requirements13ENDTIMEEnd Timenvarchar60
TOPMedia Product Sales and Distribution
77JVSDDELIVCYCLEIS-M: Delivery Cycle per Plant6ENDTIMEEnd Timenvarchar60
TOPMonitoring
78ALDWNTIMEDowntime of systems for availability calculations11ENDTIMETimenvarchar60
79SQLRUSER2User Table for Function for SQL Trace Interpreter10ENDTIMECharacter Field of Length 12nvarchar120
TOPOLAP Technology
80RSDDSTATWHMStatistics Data: BW for Warehouse Management14ENDTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPOnline Correction Support Support Package and Add-On Tools
81PAT02Conflicts Between Patches and Add-Ons9ENDTIMETimenvarchar60
82PATHISTORYHistory of Imported SPAM/SAINT Queues8ENDTIMESupport Package import timenvarchar60
83PATRTPHASEOCS Runtime Analysis: Einspielphasen10ENDTIMESupport-Package-Einspielzeitnvarchar60
TOPOverhead Cost Controlling
84PFFLDPeriod-End Partner: Organizational Log Information26ENDTIMEEnd Time of Processingnvarchar60
TOPPool Asset Management
85PAMS_NEEDGraphical Planning Board: Requests (Objects to Schedule)12ENDTIMEEnd Timenvarchar60
86PAMS_SPLITGraphical Planning Board: Splits (Scheduled Objects)13ENDTIMEEnd Timenvarchar60
TOPPosition Budgeting and Control
87HRFPM_RUNADMINSHRFPM: Administration Information for Commitment Runs6ENDTIMEEnd Time of Commitment Runnvarchar60
TOPPrint and Output Management
88TSPJSTATStatistical data for output requests33ENDTIMESystem log time stampnvarchar160
89TSPQSTATStatistical data about print queues5ENDTIMESystem log time stampnvarchar160
TOPProduct Cost Controlling
90CATDHCATT Test Data Memory, History18ENDTIMESystem Timenvarchar60
TOPProduct Cost Planning
91TCWB_OBJECTS_HISHistorie zum Testobjekt15ENDTIMESystemzeitnvarchar60
TOPProduction and Revenue Accounting
92OIUP_PDM_JOBSPDM: Job Data22ENDTIMEBatch job start timenvarchar60
TOPProfitability Analysis
93TKENC5CO-PA Realignments: Execution Logs13ENDTIMEFinish timenvarchar60
TOPRadiology
94TN1PACSIS-H*MED RAD: PACS Descriptions12ENDTIMEEnd Time of Daily Prefetchingnvarchar60
TOPSAP Business Workflow
95SWF_WFPRECWF: Recovery information for Workflow Wizards16ENDTIMETIME Data Element for SYSTnvarchar60
TOPSAP NetWeaver Mobile - Use subcomponents
96MEREP_208Replicator Run Control7ENDTIMEBatch job start timenvarchar60
97MEREP_UCLOGLog to keep track of status of data tables5ENDTIMEBatch job start timenvarchar60
TOPSAP Records Management
98SRMWFPTHPSProcess Route Item for Workflow20ENDTIMETime Process Route Item Executednvarchar60
TOPService Data Download
99/SDF/BPM_ASTADBPMon Application Statistical Records3ENDTIMESAP Workload: Workload: time of daynvarchar60
100/SDF/BPM_ASTAD2BPMon Application Statistical Records3ENDTIMESAP Workload: Workload: time of daynvarchar60
101/SDF/BPM_TSTADBPMon Technical Statistical Records3ENDTIMESAP Workload: Workload: time of daynvarchar60
102/SDF/DB6PMPROTDB6: Protocol Table for DBA Actions4ENDTIMEnvarchar140
103/SDF/SWCM_AVERSDR/3 Add-On Product (DEV) Update Information7ENDTIMETimenvarchar60
104/SDF/SWCM_AVERSPR/3 Add-On Product (PRD) Update Information7ENDTIMETimenvarchar60
105/SDF/SWCM_AVERSQR/3 Add-On Product (QAS) Update Information7ENDTIMETimenvarchar60
106/SOMO/JOSCHEDLJob scheduling table for business process monitoring25ENDTIMEnvarchar60
TOPTools
107HRPYO_D_CYSTPSteps of the cycles17ENDTIMETime by which the step should have been completednvarchar60
108T77PYOTMSTPTemplate for payroll schedule6ENDTIMETime by which the step should have been completednvarchar60
TOPTranslation Tools
109MLTTSTLOGPMLT Test Cases: Log Positions6ENDTIMESystem Timenvarchar60
110TRACOLHRequest list of transport collector (header)8ENDTIMELast changed atnvarchar60
TOPTransport Organizer
111GUPDLAYOUTList of Table Layouts that Need to Be Updated12ENDTIMELast changed atnvarchar60
TOPUpgrade - General
112AVERSInformation About Updates of R/3 Add-On Products7ENDTIMETimenvarchar60
113GODIRLOCKSynchronization for Reports that Fill GODIR6ENDTIMETimenvarchar60
114MERGEHRequest List of the Transport Merger (Header)13ENDTIMEMerge period - End timenvarchar60
115NAVERSUPG: Information About Updates of R/3 Add-On Products8ENDTIMETimenvarchar60
116UVERSUpgrade Information6ENDTIMETimenvarchar60
117UVERS_HISTUpgrade Information - History8ENDTIMETimenvarchar60
TOPUpgrade Tools
118CRRRTICRR runtime information8ENDTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
119CRRRTITCRR runtime information10ENDTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
120DDCPRODD: Conversion projects7ENDTIMESystem Timenvarchar60
TOPWeb Service and SOAP - ABAP
121SRT_WSSELECTIONOBSOLETE Excerpt of Selection Criteria15ENDTIMESystem Timenvarchar60
TOPWithout Description
122RSTT_LOGRUNArchive for Test Runs8ENDTIMELast Change to Definitiondecimal150
123RSTT_USERTrace Tool: Table for User Activation Settings5ENDTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWorkforce Management Application
124ITC_CALCRULE_SFTShift Differential Configuration on Shift Interval11ENDTIMEEnd Timeint100
125WFAC_AVAIL_INTVAvailablility Template Time Interval8ENDTIMERelative End Time in minutes (rel. to midnight)int100
126WFAC_SETSHFT_INTSet Shift Template Time Interval9ENDTIMERelative End Time in minutes (rel. to midnight)int100
127WFAC_SPECDAYPT_DAvailablility Template Time Interval9ENDTIMERelative End Time in minutes (rel. to midnight)int100
128WFAC_SPEC_DAY_DISpecial Day Part Data9ENDTIMERelative End Time in minutes (rel. to midnight)int100
129WFAC_WKRLINTVN_DWork Rule Interval9ENDTIMERelative End Time in minutes (rel. to midnight)int100
130WFAC_WKRL_INTVWork Rule Interval (out of use for Retail)8ENDTIMERelative End Time in minutes (rel. to midnight)int100
131WFAFC_IND_TDATATime relative data associated with an indicator13ENDTIMERelative End Time in minutes (rel. to midnight)int100
132WFATM_SR_AVA_TMPTM Temp Table: Schedule Rule - Availability16ENDTIMERelative End Time in minutes (rel. to midnight)int100
133WFATM_SR_PRF_TMPTM Temp Table: Schedule Rule - Preference16ENDTIMERelative End Time in minutes (rel. to midnight)int100
134WFATM_SR_SET_TMPTM Temp Table: Schedule Rule - Set Shift16ENDTIMERelative End Time in minutes (rel. to midnight)int100
135WFA_CORE_SCHECore Scheduling14ENDTIMERelative End Time in minutes (rel. to midnight)int100
136WFA_TMAP_INTVTime Map Interval Table7ENDTIMERelative End Time in minutes (rel. to midnight)int100
TOPWorkforce Management Core
137WFMCAS_CORE_SCHECore Scheduling14ENDTIMERelative End Time in minutes (rel. to midnight)int100
138WFMCAS_TMAP_INTVTime Map Interval Table7ENDTIMERelative End Time in minutes (rel. to midnight)int100
139WFMC_AVAIL_INTVAvailablility Template Time Interval8ENDTIMERelative End Time in minutes (rel. to midnight)int100
140WFMC_SETSHFT_INTSet Shift Template Time Interval9ENDTIMERelative End Time in minutes (rel. to midnight)int100
141WFMC_WKRLINTVN_DWork Rule Interval9ENDTIMERelative End Time in minutes (rel. to midnight)int100
142WFMC_WKRL_INTVWork Rule Interval (out of use for Retail)8ENDTIMERelative End Time in minutes (rel. to midnight)int100
143WFMTM_SR_AVA_TMPTM Temp Table: Schedule Rule - Availability16ENDTIMERelative End Time in minutes (rel. to midnight)int100
144WFMTM_SR_PRF_TMPTM Temp Table: Schedule Rule - Preference16ENDTIMERelative End Time in minutes (rel. to midnight)int100
145WFMTM_SR_SET_TMPTM Temp Table: Schedule Rule - Set Shift16ENDTIMERelative End Time in minutes (rel. to midnight)int100