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

161 columns | Print definition?ERP 6.0  | STARTTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/PERF_MSGSStarted messages for Performance Analysis8STARTTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
2/GEP/T_NEEDGraphischer Leitstand: Bedarfe (einzuplanende Objekte)10STARTTIMEStartzeitnvarchar60
3/GEP/T_SPLITGraphischer Leitstand: Splits (eingeplante Objekte)11STARTTIMEStartzeitnvarchar60
4/OTX/RM_TMONITORMonitored jobs information4STARTTIMEJob log entry timenvarchar60
5/SLOAP/GEN_STATEState of output generation6STARTTIMESLOAP starttimedecimal150
6BWSD_LOGDStatus Information for Individual Transfer Locations10STARTTIMELast Change to Definitiondecimal150
7BWSD_LOGHHeader Data of Transfer Log5STARTTIMELast Change to Definitiondecimal150
8BWSD_LOGIStatus of Element Objects from Transfer12STARTTIMELast Change to Definitiondecimal150
9BWSD_LOGOStatus of Scenario Objects from Transfer12STARTTIMELast Change to Definitiondecimal150
10CNVA_00555_STATEState Table for Run Time Estimation8STARTTIMEField of type TIMSnvarchar60
11CNVA_CCD_ANA_STAState Table for CC Deletion Analysis Package9STARTTIMEField of type TIMSnvarchar60
12CNVC_SCNG_EXTRExtracts5STARTTIMETimenvarchar60
13CNVMBTDEXACTIONSDMIS PCL Data Extract Action history5STARTTIMETime Stamp for the Start of an Activitydecimal150
14CNVMBTDEXFILSTATDMIS PCL Status of Data Extract Files7STARTTIMETime Stamp for the Start of an Activitydecimal150
15CNVMBTPEBSTATEStatus table for execution of all process execution blocks10STARTTIMETime Stamp Start of Execution of a Specified Activitydecimal150
16CNVMBTPEMSTATEProcess Execution Information4STARTTIMETime Stamp Start of Execution of a Specified Activitydecimal150
17CNVMBTSTATEStatus table for execution of all activities and history10STARTTIMETime Stamp Start of Execution of a Specified Activitydecimal150
18CNVMBTSUBSTATEStatus table for execution of all subactivities and histor9STARTTIMETime Stamp Start of Execution of a Specified Activitydecimal150
19CNV_10020_ASTATEStatus of the analysis programs15STARTTIMEProgram start timedecimal150
20CNV_10020_STATEStatus of the determination programs20STARTTIMEProgram start timedecimal150
21CNV_10020_STATEHStatus of the determination programs - History21STARTTIMEProgram start timedecimal150
22CNV_10020_TRACKStatistics for executed determinations20STARTTIMEProgram start timedecimal150
23CNV_20308_CMPHeader Data for Package Comparison28STARTTIMETimenvarchar60
24CNV_20308_DLDownloads15STARTTIMETimenvarchar60
25CNV_ADT_DP_LOGT. Summary: Data provider execution log (single DP)6STARTTIMETimenvarchar60
26CNV_ADT_DP_LOGPT. Summary: Data provider execution log (whole package)6STARTTIMETimenvarchar60
27CNV_INDX_CHECKSCheck executions for the given package5STARTTIMESystem Timenvarchar60
28DMC_IU_UVERSMWB: Backup Copy of UVERS4STARTTIMETimenvarchar60
29DMC_MDS_AVERSMDS: Information About Updates of R/3 Add-On Products6STARTTIMETimenvarchar60
30DMC_MDS_UVERSMDS: Backup of Upgrade Information5STARTTIMETimenvarchar60
31EHPRCD_PERFCP: Performance Tests4STARTTIMEStarting Time of Performance Testnvarchar60
32RSCNVSTEPSteps for dimension conversion8STARTTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
33RSDB2A_STATDB2 Accelerator: Load statistics3STARTTIMEDB2-z/OS: General purpose timestamp in DB2 hex formatnvarchar200
34SUBST_SLANA_HDRSL Analytics Header Data6STARTTIMEnvarchar60
35ZEVENT_PRESENTATTable for the presentations4STARTTIMEStart time of presentationnvarchar60
36HRP1774DB Table for Infotype 177422STARTTIMEStart Time of Individual Worknvarchar60
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
37CRM_ECLOG_HEADTable for Replicated eCATT Log Header5STARTTIMEStart timenvarchar60
TOPALE Integration Technology
38EDADMDEBStorage of Debugging Settings4STARTTIMEnvarchar60
TOPBackground Processing
39BTCOMSDLControl table for operation type scheduler2STARTTIMEOperation mode start or end timenvarchar60
40BTCOMSETDefinition of operation type sets and exception op. modes3STARTTIMEOperation mode start or end timenvarchar60
TOPBank Customer Accounts
41BKKBENCHBenchmark Results5STARTTIMEStart timenvarchar60
42BKKBENCHACBALBenchmark Results Account Balancing13STARTTIMEStart timenvarchar60
43BKKBENCHBKSTATBenchmark Results Bank Statement9STARTTIMEStart timenvarchar60
TOPBatch-Oriented Parallel Processing of Mass Data
44BANK_PP_STEPDATAData for Processing Steps of a Parallel Mass Run10STARTTIMEChanged Atnvarchar150
TOPBilling in Contract Accounts Receivable and Payable
45TFK8026Billing Cycle5STARTTIMEStart Time for Billing Cyclenvarchar60
46TFK8026SSubordinate Billing Cycles5STARTTIMEStart Time for Billing Cyclenvarchar60
TOPBusiness Application Support
47CNVRUNTIMEHELPTemporary storage of runtime info for terminated programs10STARTTIMEConversion: Program start timedecimal150
48CNVSTATEConversion: Status of programs16STARTTIMEConversion: Program start timedecimal150
TOPChange Transport System
49TPALOGHDRHeader Table for TPALOG2STARTTIMETime Stamp in CTSnvarchar140
TOPClient Copy
50CCPROCTABParallel Client Copy Processes3STARTTIMETimenvarchar60
TOPClinical System
51N2GL_TM_SCHEDULEpathways Patient Pathway23STARTTIMEPatient Pathway Start Timenvarchar60
TOPContract Accounts Receivable and Payable
52DFK_JC_JOBINFOIndividual Job Overview5STARTTIMETIME Data Element for SYSTnvarchar60
TOPCross-Application Components
53RASUTADMASU: Toolbox: Started reports5STARTTIMETIME Data Element for SYSTnvarchar60
54TASUVADMASU: Variants: Started reports5STARTTIMETIME Data Element for SYSTnvarchar60
TOPData Basis
55RSCNVREQConversion Requests3STARTTIMEScheduled Conversion Start Timedecimal150
TOPDatabase Interface, Database Platforms
56DB6PMPROTDB6: Protocol Table for DBA Actions3STARTTIMEDB6: Timestamp (Format: YYYYMMDDHHMMSS)nvarchar140
57SDBAC_PATDB13: List of proposed actions5STARTTIMESystem Timenvarchar60
TOPDB2 Universal Database for UNIX NT
58DB6JOBTABDB6: parallel processing of tables through jobs2STARTTIMEDB6: Timestamp (Format: YYYYMMDDHHMMSS)nvarchar140
TOPDenmark
59T5M8KLog of report calls for Danish payroll accounting3STARTTIMECurrent timenvarchar60
TOPeCATT Extended Computer Aided Test Tool
60ECLOG_AIDXTable for Log Archive Index6STARTTIMEStart timenvarchar60
61ECLOG_EXECExecuted Configuration, Variant, Script, Version9STARTTIMEStart timenvarchar60
62ECLOG_HEADTable for Log Header4STARTTIMEStart timenvarchar60
63ECLOG_HYDRASeveral Header Entries for Log13STARTTIMEStart timenvarchar60
64ECTRACEeCATT Recordings13STARTTIMESystem Timenvarchar60
65TZRR_EXECTestZone: Result Repository Start Activity Data9STARTTIMEStart timenvarchar60
TOPEnd User Technology
66RSR_PREC_QUEUEPersistant Precalculation Queue7STARTTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPEnergy Data Management
67EEDMSETTLDOCRUNSettlement Document (Run)15STARTTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPEnvironment, Health and Safety
68/TDAG/CPT_PERFCP: Performance Tests4STARTTIMEStarting Time of Performance Testnvarchar60
TOPGeneral Ledger Accounting
69NGLM_ANA_HDAnalysis Run Header5STARTTIMETimenvarchar60
TOPGlobal Performance Analysis Transaction ST3
70AMASTAGlobal Performance Analysis: Application Statistc (from 7.0)9STARTTIMESAP Workload NW Collector: Timenvarchar60
71AMESISTAGlobal Performance Analysis: Statistics Main Rec + ESI Total9STARTTIMESAP Workload NW Collector: Timenvarchar60
72AMSTAGlobal Performance Analysis: Statistical Data5STARTTIMELocal Start Time for Performance Log Statistical Recordnvarchar60
TOPI18N Unicode
73UMGTSKQSUMG: Worklist9STARTTIMEStart Timenvarchar60
TOPImplementation Guide
74EXCEPT1IMG Activity-Specific BC Set Error Exception Table20STARTTIMETimenvarchar60
75EXCEPT2Object-Specific BC Set Error Case Exception Table17STARTTIMETimenvarchar60
TOPIndustry Solution Catch Weight Management
76/CWM/MIG_PROT_HMigration Log Header6STARTTIMEnvarchar60
TOPInformation Quality Management
77SIQMRUNSInspection Runs (Header Table)7STARTTIMEStart Time/Datedecimal217
TOPInternationalization I18N
78I18NSRHWLWorklist for I18N_SEARCH6STARTTIMEStart Time of Scannvarchar60
TOPliveCache Applications
79/SAPAPO/LCLOGLOGLogging of liveCache logging2STARTTIMEStart timenvarchar60
80/SAPAPO/OMLOGHDRLog for Function Modules of OM Layer - Header2STARTTIMEStart timenvarchar60
TOPMaintenance Orders
81/MRSS/D_ENG_LOGProtokolltabelle für Engineläufe8STARTTIMEStart Time of Engine Run in RCCFnvarchar60
TOPMedia Product Sales and Distribution
82JVSDDELIVCYCLEIS-M: Delivery Cycle per Plant5STARTTIMEStart Timenvarchar60
TOPMetadata Repository
83RSDDSTATBCACTBW Statistics: Activate Business Content6STARTTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPMonitoring
84ALDWNTIMEDowntime of systems for availability calculations9STARTTIMETimenvarchar60
85CSMCENTOOLCCMS Monitoring: Container for Methods Started Centrally15STARTTIMEAlert: Time value in timeformatnvarchar60
86SQLRUSER2User Table for Function for SQL Trace Interpreter9STARTTIMECharacter Field of Length 12nvarchar120
87SWNCCOLLPERFPerformance Data of the Workload Collector8STARTTIMESAP Workload NW Collector: Timenvarchar60
TOPOLAP Technology
88RSDDSTATAGGRStatistics data BW for aggregate selection and accounting14STARTTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
89RSDDSTATCONDBW Statistics: Data on Condensing Run InfoCube4STARTTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
90RSDDSTATDATAUSEFilter vals during query execution for selected InfoObjects10STARTTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
91RSDDSTATDELEBW Statistics: Data on Deletion of Data in InfoCube5STARTTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
92RSDDSTATINFOBW Statistics (OLAP), Information by Navigation Step5STARTTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
93RSDDSTATWHMStatistics Data: BW for Warehouse Management13STARTTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPOnline Correction Support Support Package and Add-On Tools
94PATHISTORYHistory of Imported SPAM/SAINT Queues6STARTTIMESupport Package import timenvarchar60
95PATRTPHASEOCS Runtime Analysis: Einspielphasen8STARTTIMESupport-Package-Einspielzeitnvarchar60
TOPOverhead Cost Controlling
96PFFLDPeriod-End Partner: Organizational Log Information24STARTTIMEStart Time of Processingnvarchar60
TOPPerformance Assessment Workbench
97SLS_PETPAW - Person/Event/Test Relationship Table26STARTTIMEPAW - Test starting timenvarchar60
TOPPerformance Monitors TCC
98GVD_WPTOTALINFOOracle Monitoring: Workprocess Information snapshot table28STARTTIMEOracle Monitoring: Start time for dialog stepnvarchar60
TOPPool Asset Management
99PAMS_NEEDGraphical Planning Board: Requests (Objects to Schedule)10STARTTIMEStart Timenvarchar60
100PAMS_SPLITGraphical Planning Board: Splits (Scheduled Objects)11STARTTIMEStart Timenvarchar60
TOPPosition Budgeting and Control
101HRFPM_RUNADMINSHRFPM: Administration Information for Commitment Runs4STARTTIMEStart Time of Commitment Runnvarchar60
TOPPrint and Output Management
102TSPJSTATStatistical data for output requests4STARTTIMESystem log time stampnvarchar160
103TSPQSTATStatistical data about print queues2STARTTIMESystem log time stampnvarchar160
TOPProduct Cost Controlling
104CATDHCATT Test Data Memory, History16STARTTIMESystem Timenvarchar60
TOPProduct Cost Planning
105TCWB_OBJECTS_HISHistorie zum Testobjekt13STARTTIMESystemzeitnvarchar60
TOPProfitability Analysis
106TKENC5CO-PA Realignments: Execution Logs11STARTTIMEStart time (HHMMSS)nvarchar60
TOPRadiology
107TN1PACSIS-H*MED RAD: PACS Descriptions11STARTTIMEStart Time for Daily Prefetchingsnvarchar60
TOPRemote Control and Communication Framework
108RCCD_ENG_LOGLog Table for Engine Runs8STARTTIMEStart Time of an Engine Run in RCCFnvarchar60
TOPSAP Business Workflow
109SWF_WFPRECWF: Recovery information for Workflow Wizards11STARTTIMETIME Data Element for SYSTnvarchar60
TOPSAP Retail Store
110WSMAN_PT_BUFFERStore Manager Portal: Buffer for Availability Display4STARTTIMETime of availabilitynvarchar60
TOPService Data Download
111/SDF/DB6PMPROTDB6: Protocol Table for DBA Actions2STARTTIMEnvarchar140
112/SDF/STADStatistical Records5STARTTIMESystem Timenvarchar60
113/SDF/SWCM_AVERSDR/3 Add-On Product (DEV) Update Information5STARTTIMETimenvarchar60
114/SDF/SWCM_AVERSPR/3 Add-On Product (PRD) Update Information5STARTTIMETimenvarchar60
115/SDF/SWCM_AVERSQR/3 Add-On Product (QAS) Update Information5STARTTIMETimenvarchar60
TOPTools
116HRPYO_D_CYSTPSteps of the cycles16STARTTIMEStart time of a stepnvarchar60
TOPTranslation Tools
117INDPROTShort Text Conversion: Log5STARTTIMETIME Data Element for SYSTnvarchar60
118LWRKLIDWork list ID for individual translator work lists3STARTTIMETimenvarchar60
119TRNL_WLWorklists of Translation (Header Data)6STARTTIMELast changed atnvarchar60
TOPTransport Management System
120CTWFTARGETTransport Proposal: Target Systems/Target Clients18STARTTIMEnvarchar60
TOPTransport Organizer
121GUPDLAYOUTList of Table Layouts that Need to Be Updated10STARTTIMELast changed atnvarchar60
TOPUI Services, Screen, Batch Input
122APQIQueue info definition20STARTTIMEQueue start timenvarchar60
TOPUpgrade - General
123AVERSInformation About Updates of R/3 Add-On Products5STARTTIMETimenvarchar60
124GODIRLOCKSynchronization for Reports that Fill GODIR4STARTTIMETimenvarchar60
125MERGEHRequest List of the Transport Merger (Header)11STARTTIMEMerge period - Start timenvarchar60
126NAVERSUPG: Information About Updates of R/3 Add-On Products6STARTTIMETimenvarchar60
127NAVERS2additional information about Addons in Upgrades/Updates5STARTTIMETimenvarchar60
128UVERSUpgrade Information4STARTTIMETimenvarchar60
129UVERS_HISTUpgrade Information - History6STARTTIMETimenvarchar60
TOPUpgrade Tools
130CRRRTICRR runtime information7STARTTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
131CRRRTITCRR runtime information9STARTTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
132DDCPRODD: Conversion projects5STARTTIMESystem Timenvarchar60
TOPWaste Management
133EWAOBJHService Frequency -> Services (History for EWAOBJ)10STARTTIMEStart time of a service windownvarchar60
134EWA_OBJADDRESSObject Address7STARTTIMEStart time of a service windownvarchar60
135EWA_SERVADDRESSService Address8STARTTIMEStart time of a service windownvarchar60
TOPWeb Service and SOAP - ABAP
136SRT_WSSELECTIONOBSOLETE Excerpt of Selection Criteria14STARTTIMESystem Timenvarchar60
TOPWithout Description
137RSDDSTATStatistics data BW for aggregate selection and accounting46STARTTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
138RSTT_LOGRUNArchive for Test Runs7STARTTIMELast Change to Definitiondecimal150
139RSTT_USERTrace Tool: Table for User Activation Settings4STARTTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWorkforce Management Application
140ITC_CALCRULE_SFTShift Differential Configuration on Shift Interval8STARTTIMEStart Timeint100
141WFAC_AVAIL_INTVAvailablility Template Time Interval7STARTTIMERelative Start Time in minutes (rel. to midnight)int100
142WFAC_SETSHFT_INTSet Shift Template Time Interval8STARTTIMERelative Start Time in minutes (rel. to midnight)int100
143WFAC_SPECDAYPT_DAvailablility Template Time Interval8STARTTIMERelative Start Time in minutes (rel. to midnight)int100
144WFAC_SPEC_DAY_DISpecial Day Part Data8STARTTIMERelative Start Time in minutes (rel. to midnight)int100
145WFAC_WKRLINTVN_DWork Rule Interval8STARTTIMERelative Start Time in minutes (rel. to midnight)int100
146WFAC_WKRL_INTVWork Rule Interval (out of use for Retail)7STARTTIMERelative Start Time in minutes (rel. to midnight)int100
147WFAFC_IND_TDATATime relative data associated with an indicator10STARTTIMERelative Start Time in minutes (rel. to midnight)int100
148WFATM_SR_AVA_TMPTM Temp Table: Schedule Rule - Availability15STARTTIMERelative Start Time in minutes (rel. to midnight)int100
149WFATM_SR_PRF_TMPTM Temp Table: Schedule Rule - Preference15STARTTIMERelative Start Time in minutes (rel. to midnight)int100
150WFATM_SR_SET_TMPTM Temp Table: Schedule Rule - Set Shift15STARTTIMERelative Start Time in minutes (rel. to midnight)int100
151WFA_CORE_SCHECore Scheduling13STARTTIMERelative Start Time in minutes (rel. to midnight)int100
152WFA_TMAP_INTVTime Map Interval Table6STARTTIMERelative Start Time in minutes (rel. to midnight)int100
TOPWorkforce Management Core
153WFMCAS_CORE_SCHECore Scheduling13STARTTIMERelative Start Time in minutes (rel. to midnight)int100
154WFMCAS_TMAP_INTVTime Map Interval Table6STARTTIMERelative Start Time in minutes (rel. to midnight)int100
155WFMC_AVAIL_INTVAvailablility Template Time Interval7STARTTIMERelative Start Time in minutes (rel. to midnight)int100
156WFMC_SETSHFT_INTSet Shift Template Time Interval8STARTTIMERelative Start Time in minutes (rel. to midnight)int100
157WFMC_WKRLINTVN_DWork Rule Interval8STARTTIMERelative Start Time in minutes (rel. to midnight)int100
158WFMC_WKRL_INTVWork Rule Interval (out of use for Retail)7STARTTIMERelative Start Time in minutes (rel. to midnight)int100
159WFMTM_SR_AVA_TMPTM Temp Table: Schedule Rule - Availability15STARTTIMERelative Start Time in minutes (rel. to midnight)int100
160WFMTM_SR_PRF_TMPTM Temp Table: Schedule Rule - Preference15STARTTIMERelative Start Time in minutes (rel. to midnight)int100
161WFMTM_SR_SET_TMPTM Temp Table: Schedule Rule - Set Shift15STARTTIMERelative Start Time in minutes (rel. to midnight)int100