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

158 columns | Print definition?ERP 6.0  | END_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/DOCU_ID_IDXDocument search index table30END_TIMEEnd Timenvarchar60
2/AIF/FLBOOK_IDXStandard index table27END_TIMEEnd Timenvarchar60
3/AIF/IDC_IDX_TBLStandard index table27END_TIMEEnd Timenvarchar60
4/AIF/MIDX_TEMPLTemplate for a multi index table28END_TIMEEnd Timenvarchar60
5/AIF/PERS_XMLAIF XML Persistency: Message Header16END_TIMEEnd Timenvarchar60
6/AIF/QRFC_S_IDXqRFC Standard index table27END_TIMEEnd Timenvarchar60
7/AIF/Q_STD_IDX_TqRFC Standard index table27END_TIMEEnd Timenvarchar60
8/AIF/STD_IDX_TBLStandard index table27END_TIMEEnd Timenvarchar60
9/AIF/TEST_BP_IDXStandard index table27END_TIMEEnd Timenvarchar60
10/AIF/TRFC_S_IDXtRFC Standard index table27END_TIMEEnd Timenvarchar60
11/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing27END_TIMEEnd Timenvarchar60
12/AIF/T_MMSG_IDXMulti Msg class&No. search index table32END_TIMEEnd Timenvarchar60
13/AIF/T_STD_IDX_TtRFC Standard index table27END_TIMEEnd Timenvarchar60
14/AIFX/ECH_STD_TBStandard ECH key fields table42END_TIMEEnd Timenvarchar60
15/MRSS/C_PN_CAPACustomized Capacity Rule for Planning Nodes5END_TIMEDaily End Timenvarchar60
16/MRSS/D_PPM_RUNTMRS delay measurements12END_TIMEEnd Time Stampdecimal150
17/OPT/CT_IDH_LOGInbound Document Handler: Document Log11END_TIMEActual End Time of Processnvarchar60
18/OPT/VIM_PO_RUNTable to store time entry for PO download runs6END_TIMEField of type TIMSnvarchar60
19/OPT/X059Table to store time entry for PO download runs6END_TIMEField of type TIMSnvarchar60
20/OPT/Y059Table to store time entry for PO download runs6END_TIMEField of type TIMSnvarchar60
21/OPT/Z059Table to store time entry for PO download runs6END_TIMEField of type TIMSnvarchar60
22/SLOAP/SYS_MESSSystem messages8END_TIMETimenvarchar60
23/XLSO/OLD_COURSELearners' External Course Details10END_TIMEEnd time of a shiftnvarchar60
24/XLSO/USER_COMPXLSO Table to store the assignment of Company and User9END_TIMETime Stamp in XLSO Namespace That Has a Change Documentdecimal150
25BBPC_CF_TIMESDetermine Defaults for Time Recording4END_TIMEEnd Timenvarchar60
26BBP_PDISBBid Invitation/Bid-Specific Item Data10END_TIMETime Stamp f. Submissn Deadlinedecimal150
27CNVCDOP_STATECDOP : Status of the activities in a Project7END_TIMEBatch job start timenvarchar60
28CNVMBTCHKLOGCHKCheck Framework: Log Check Executions17END_TIMECheck Framework: Execution End Timenvarchar60
29CNV_00001_SIMMONTable for status of selection simulation jobs14END_TIMEConversion: Program finish timedecimal150
30CNV_10020_ASTATEStatus of the analysis programs12END_TIMEEnd timenvarchar60
31CNV_10020_STATEStatus of the determination programs17END_TIMEEnd timenvarchar60
32CNV_10020_STATEHStatus of the determination programs - History18END_TIMEEnd timenvarchar60
33CNV_10020_TRACKStatistics for executed determinations19END_TIMEEnd timenvarchar60
34CNV_10940_STATEJob status for RVS9END_TIMEBatch job start timenvarchar60
35CNV_10993_LOGLog activities in a project.8END_TIMEBatch job start timenvarchar60
36CNV_10993_STATEJob status state table9END_TIMEBatch job start timenvarchar60
37CNV_20330_TABLETable analysis - tables with object number fields8END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
38CTS_AIM_TRC_UPGCollection of AIM Traces Belonging to One Upgrade Event3END_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
39DMC_CU_RUNDETAILRun Execution Details6END_TIMESystem Timenvarchar60
40EHFNDD_TS_AMNTime Series - Amounts12END_TIMEEnd Timenvarchar60
41GRACPPJOBSBatch Processing Jobs.9END_TIMETimestamp when the Field was Last Updateddecimal150
42GRACPPOBJDATARisk Analysis PPF Runtime Package Data.7END_TIMETimestamp when the Field was Last Updateddecimal150
43HRRCF_D_INTVSCDLInterview Schedule8END_TIMETime of Qualifying Eventnvarchar60
44HRRCF_D_INTVTMSLInterview Time Slots6END_TIMETime of Qualifying Eventnvarchar60
45IUUC_REPL_LTNCYKeep history for the latency of each replicated portion4END_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
46IUUC_REPL_LTNCYHKeep history for the latency of each replicated portion3END_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
47IUUC_REPL_STATStatistics about the number of I/U/D entries for replication4END_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
48IUUC_REPL_STATHStatistics about the number of I/U/D entries for replication3END_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
49LXE_WRK_LOGWorklist Run Log34END_TIMESystem Timenvarchar60
50PPHMRPLOGMRP Live Log Header4END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
51PPHMRPPPLOGMRP Live Postprocessing Log Header7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
52RSCRMPACK_H.14END_TIMESystem Timenvarchar60
53RSDHARUNExecutions of HANA Analysis Processes6END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
54SRAL_TRACE_PERFSRAL Performance Trace15END_TIMESRAL Timestamp (long)decimal217
55SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO39END_TIMETime Stamp f. Submissn Deadlinedecimal150
56WFA_SHT_CHNG_MOBWFA: Shift Change Requests for Mobile9END_TIMETimenvarchar60
57ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN27END_TIMEEnd Timenvarchar60
58PIQDBATPREEXcm: Pre Excused Absence7END_TIMEPre-excused Absence 'To' Timenvarchar60
TOPAnalysis Process Designer
59RSANT_PROCESSRAnalysis Run7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPBasic Functions
60WTMIGSTEPSteps in Conversion Run6END_TIMEEnd of a Step in Conversion Runnvarchar60
TOPBatches
61MCHCLBatch Class Conversion16END_TIMESystem Timenvarchar60
62MCHCL_MATMaterials for Batch Class Conversion10END_TIMESystem Timenvarchar60
TOPBusiness Objects, Common Components
63EHFNDD_AMN_ROOTData Series for Amounts - Root12END_TIMEEnd Timenvarchar60
TOPClassification Toolset
64CLS_RUNRun directory9END_TIMEEnd time of a report runnvarchar60
TOPClinical System
65N1BCEXPBasic Cat.: Export9END_TIMEBasic Cat.: End Time of Exportnvarchar60
66N1BCIMPBasic Cat.: Import11END_TIMEBasic Cat.: End Time of Importnvarchar60
67N1CCYGENCORD: Cycle Generation Information8END_TIMECORD: Generation End Timenvarchar60
68N1CYSRVTPLCORD: Cyclical Service Template16END_TIMECORD: Ordered Cyclical Service End Timenvarchar60
TOPCollections Management
69UDM_PR_INTVIntervals for Parallel Processing of Program Runs11END_TIMEEnd of Processingdecimal150
TOPContract Accounts Receivable and Payable
70DFKK_BRF050BRF: Parameters for Expressions That Access the Context15END_TIMEField Name for End Datenvarchar300
TOPCross-Application Components
71/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices22END_TIMECreation Time of Work Itemnvarchar60
72/OPT/VIM_HD_NPOVIM IE Monitor: Header Data for Parked NPO Invoices27END_TIMEVIM IE Monitor: data element for end timenvarchar60
73/OPT/VIM_HD_POVIM IE Monitor: Header Data for Parked PO Invoices30END_TIMEVIM IE Monitor: data element for end timenvarchar60
74/OPT/VIM_NPO_WIDVIM IE Monitortable: WI Header Data for NPO Invoices16END_TIMECreation Time of Work Itemnvarchar60
75/OPT/VIM_NPO_WIHVIM IE Monitortable: WI Header Data for NPO Invoices17END_TIMECreation Time of Work Itemnvarchar60
76/OPT/VIM_PO_WIDVIM Report: WI Header Data for PO Invoices17END_TIMECreation Time of Work Itemnvarchar60
77/OPT/VIM_PO_WIHVIM Report: WI Header Data for PO Invoices18END_TIMECreation Time of Work Itemnvarchar60
TOPCross-System Tools
78CMPWLIMPCustomizing Comparison: Worklist Imports3END_TIMETime Stamp in CTSnvarchar140
TOPCustom Development Management Cockpit
79CNVCDMC_STATECDMC : Status of the activities in a Project7END_TIMEBatch job start timenvarchar60
TOPData Mining
80RSDMTP_BATCHDetails for batch job and monitoring11END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPDownloadUpload
81/DSD/HH_RATSDSD Route Settlement: Tour Time Sheet9END_TIMEDSD - RA: Date / Time End - Greenwich Mean Timedecimal150
TOPDSD Connector
82/DSD/ME_DEL_HDDSD CN: Delivery Header Data25END_TIMEField of type TIMSnvarchar60
83/DSD/ME_VIST_ACTDSD CN: Activities during the Customer Visit10END_TIMEDSD Connector: Timenvarchar60
TOPFinancial Accounting
84/OPT/VIM_1LOGDocument Log12END_TIMEActual End Time of Processnvarchar60
85/OPT/VIM_8LOGOpenText VIM Document Log18END_TIMEActual End Time of Processnvarchar60
TOPGeneral Ledger Accounting
86FAGL_FCV_ADMINForeign Currency Valuation: ID Numbers of Valuation Runs10END_TIMETimenvarchar60
TOPGovernance, Risk and Compliance
87GRFN_DOC_TICKETSPermission to Download the Document7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
88GRPC_DOC_TICKETSGRC: Permission to Download the Document7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPGRC Risk Management
89GRFNMWLOGMigration Log7END_TIMEMigration End Timedecimal150
TOPIncentive and Commission Management ICM
90CACSCP_RCP_WL_INRCP: Information on Worklist7END_TIMEEffective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)nvarchar140
91FPP_RUN_INTERVALStatus of Intervals for a Run8END_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
92YSVMA_RCP_WL_INRCP: Information on Worklist7END_TIMEEffective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)nvarchar140
93YTEL05_RCP_WL_INRCP: Information on Worklist7END_TIMEEffective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)nvarchar140
TOPIncident Recording
94EHHSSD_INC_RESDUIncident Restricted Duty database table28END_TIMEEnd Time of Absence or Restrictionnvarchar60
TOPIncident Workflow and Tasks
95EHHSSD_PIH_HRABSProcess Control: HR Absence17END_TIMEEnd Time of Absence or Restrictionnvarchar60
TOPInterface to Terminal Automation System
96TOIKOWCTime windows4END_TIMERota end timenvarchar60
TOPInventory Accounting
97UAINVREVCOHHeader Table for Tracking the Revaluation Runs19END_TIMETimenvarchar60
TOPKnowledge Warehouse
98IWBKEPKEP Data for Scheduling Training7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPliveCache
99LCINIT_LOGLog Entries: Start/Stop/Init of Prep./Postprocessing Reports9END_TIMEField of type TIMSnvarchar60
TOPMaintenance Orders
100/MRSS/C_PN_BREAKBreak information for Planning nodes5END_TIMEBreak End Timenvarchar60
101/MRSS/D_MRS_LOGLog Protocols6END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
102/MRSS/D_PN_CAPACapacity Rule Definition for Planning Nodes7END_TIMEField of type TIMSnvarchar60
TOPMaintenance Processing
103/MRSS/D_DPR_REJRejected resoruces16END_TIMEEnd Timenvarchar60
TOPManagement of Internal Controls
104FOPC_BTC_REPORTSBackground Reports in System9END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
105FOPC_DOC_TICKETSPermission to Download the Document7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMonitoring
106ALDTSCACHESDTS: Current/Next Downtimes for CCMS Systems/Instances7END_TIMEField of type TIMSnvarchar60
107ALPFREP_CATPerfDB Reporting Catalog12END_TIMEAlert: Time value in timeformatnvarchar60
108GRMG_RUN_LOGGRMG: Table for run log10END_TIMESystem Timenvarchar60
TOPNursing
109N1NRSPENursing Plan: Entry18END_TIMENursing Plan: End Time of an Entrynvarchar60
110N1NRSPEPNursing Plan: Suspension of an Entry8END_TIMENursing Plan: End Time of a Suspensionnvarchar60
111N1NRSPHNursing Plan: Header Data14END_TIMENursing Plan: End Timenvarchar60
112N1NRSPHPOBSOLETE7END_TIMEOBSOLETEnvarchar60
113N1NRSPHUNursing Plan: Update7END_TIMENursing Plan: End Time of an Updatenvarchar60
TOPOLAP Technology
114RSL_BACKUPBackup Header7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
115RSL_MI_RUNExecution Instances for Import Processes6END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPOracle Database Monitors
116ORA_ISQ_HISTORYIndex Storage Quality - Objectshistory Data14END_TIMEEnd Timenvarchar60
TOPOrganizational Management
117HRMDORIGINHR Master Data Distribution: Original Systems6END_TIMEValid to Time of Entry for Original Systemnvarchar60
TOPPerformance Monitors TCC
118GVD_SGARESIZEOPSOracle Monitoring: Copy of GV$SGA_RESIZE_OPS14END_TIMEOracle Monitoring: END_TIME: End time of operationnvarchar60
TOPPersonnel Time Management
119PTREQ_ATTABSDATARequest Data for Attendances/Absences6END_TIMEEnd Timenvarchar60
TOPProcess Controls
120GRPC_BTC_REPORTSBackground Reports in System9END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPProduct Safety
121CCRCT_RUNTime stamp of Tracking and Filling Runs8END_TIMEEnd Timenvarchar60
TOPProduction Backflush
122TASKLIST_HISTORYHistory of Parallel Valuation Jobs in MM-IM6END_TIMESystem Timenvarchar60
TOPProduction Optimization Interface POI
123CLOIDOWNLPROTPOI: Times/Dates of the last download to a log. System7END_TIMETime at which data record was creatednvarchar60
TOPProduction Orders
124COCF_CU_SR_REPDefinition Shift Report Type for Class CL_COCF_SR_REP13END_TIMEABAP/4: Name of SELECT-OPTION / PARAMETERnvarchar80
125COCF_SRShift Reports in PDF Format13END_TIMEEnd Time of Evaluation Periodnvarchar60
126COCF_SR_DSIGMETASignature Tool: Metadata for Shift Report14END_TIMEEnd Time of Evaluation Periodnvarchar60
TOPSAP Multiresource Scheduling
127/MRSS/C_BRK_SHDLBreak Schedule4END_TIMEEnd Timenvarchar60
128/MRSS/D_WRK_SCHDWork Schedule6END_TIMEEnd Timenvarchar60
TOPSAP NetWeaver Mobile - Use subcomponents
129MEMON_TECHAGS Monitoring: Main data technical Monitor (Index)9END_TIMEME:AGS - End time of the Synchronizationnvarchar60
TOPService Processing
130/WSCGMBH/C_ASSIGClickSchedule: Assignment8END_TIMEClickSchedule: Scheduling Finish (Time)nvarchar60
131/WSCGMBH/C_ASSIIClickSchedule: Assignment9END_TIMEClickSchedule: Scheduling Finish (Time)nvarchar60
TOPShift Planning
132HRPADUZPADUZ Additional Data: Requirements Assignment of Persons4END_TIMEEnd time of a shiftnvarchar60
TOPSupply Chain Management
133/SDF/EM_STEPException Management - Process Step Table10END_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPTalent Management
134HRT7436Talent Review Meeting Dates (Table Section)7END_TIMEEnd Timenvarchar60
TOPTraders and Schedulers Workbench
135OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE46END_TIMETimenvarchar60
TOPTranslation Tools
136LXE_PP_IMPProposal Pool Transports (Import Logs)7END_TIMELast changed atnvarchar60
137LXE_TAREA_LOCKLock operations for translation areas6END_TIMESystem Timenvarchar60
138TRMIDXLog Entries for TRM Processing Runs12END_TIMESystem Timenvarchar60
TOPTransportation and Distribution
139TOIGHTD Shift Table4END_TIMERota end timenvarchar60
TOPTravel Planning
140TA20NRADDAdditional Info for Negotiated Rates and Discounts11END_TIMEEnd time for request itemnvarchar60
TOPUser and Authorization Management
141BPO_MEASJOBSystem Measurement Jobs Scheduled and Running9END_TIMETimenvarchar60
142TUJOBSystem Measurement Jobs Scheduled and Running9END_TIMETimenvarchar60
143TUL_JOBSystem Measurement Jobs Scheduled and Running9END_TIMETimenvarchar60
TOPWaste Management
144EEWA_BULK_DATABulk refuse order data50END_TIMEEnd of service windownvarchar60
145EWA_ORDER_OBJECTItem Table for Waste Disposal Order16END_TIMEEnd of service windownvarchar60
TOPWork Clearance Management
146WCAHEWCM: Work Clearance Document (Header)79END_TIMEOT: Operation end timenvarchar60
TOPWorkforce Management Application
147WFAC_OPHOURS_DWFM Operating Hours Data7END_TIMEEnd Time of Shiftnvarchar60
148WFAC_SOPHOURS_DWFM Special Operating Hours Data7END_TIMEEnd Time of Shiftnvarchar60
149WFATM_SC_SEG_TMPTM Temp Table: Schedule - Shift Segment16END_TIMETimenvarchar60
TOPWorkforce Management Core
150/SAPAPO/LRPASGLCTable of Dispatching Details for Assignment7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
151/SAPAPO/LRPASSARTable of Dispatching Details for Assignment8END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
152/SAPAPO/LRPASSGNObsolete: Table of Dispatching Details for Assignment7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
153/SAPAPO/LRPASSIGTable of Dispatching Details for Assignment7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
154/SAPAPO/TSTASGLCTable of Dispatching Details for Assignment7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
155/SAPAPO/TSTASSIGTable of Dispatching Details for Assignment7END_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
156WFMC_OPHOURS_DWFM Operating Hours Data7END_TIMEEnd Timenvarchar60
157WFMC_SOPHOURS_DWFM Special Operating Hours Data7END_TIMEEnd Timenvarchar60
158WFMTM_SC_SEG_TMPTM Temp Table: Schedule - Shift Segment16END_TIMETimenvarchar60