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

119 columns | Print definition?ERP 6.0  | TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/PRSTT_LGUIDMaster Data (Time-Ind.): Characteristic Log GUID13TIMETimenvarchar60
2/BI0/STIMEMaster Data IDs: InfoObject Time1TIMETimenvarchar60
3/CIDEON/LOGLogtabelle2TIMEUTC-Zeitstempel in Langform (JJJJMMTThhmmssmmmuuun)decimal217
4/CPLM/ACTN_Vvalue table for the possible actions of the FPU4TIMEtime (PRE / POST) in BAdInvarchar40
5/CPLM/FPUACTNaction of the FPU during BAdI implementation5TIMEtime (PRE / POST) in BAdInvarchar40
6/KORA/EVENT_TTemporary saving of events2TIMEkr:SAP Object IDnvarchar400
7/OEE/MPH_NODESTRPlant Hierarchy Node Standard Rate15TIMEDurationdecimal3114
8/OTEI/RP_T_VARDTEFM Report Variants - Document types6TIMETime Periodnvarchar50
9/SAPSRM/APPLTERRStores Applet Exceptions4TIMESystem Timenvarchar60
10/SAPSRM/C_PWL_PANumber and Time Intervals for Attempting Automatic Refresh3TIMEIntervals for Attempting Automatic Refresh (Seconds)tinyint30
11/XLSO/WPCAlert Config Waitlist, Prebook, Cancellation for Course type6TIMETime Periodnvarchar10
12CNVHCM_TIMESTAMPTDMS4HCM: Timestamps to check if TEST function executed4TIMETDMS4HCM: Timestampnvarchar140
13CNV_20000_RESULTResult of the fiscal year analysis4TIMEField of type TIMSnvarchar60
14DMC_MT_TRACKMWB: Tracking Information for a Mass Transfer6TIMETimenvarchar60
15FUNCTIONTabelle der Funktionseinträge für Transaktion SVPQ5TIMEVerifikation : Zeitangabefloat1516
16GUI_E2E_TRACES_RGUI Epp Traces Used Root Context IDs3TIMETrace Step Start Timenvarchar140
17IUUC_REPL_CONFIGConfiguration of a replication mt_id7TIMEFixed processing timenvarchar60
18IUUC_SCHEMA_RMDStorage of Schema Replication Mode5TIMEFixed processing timenvarchar60
19NWS_EXT_INDXPersistence of Extraction (Excel Spreadsheet)8TIMETIME Data Element for SYSTnvarchar60
20RSVEPRUNSPerformance-Messungen: Meßlauf-Informationen6TIMESystemzeitnvarchar60
21SCR_ABAP_ASTCL_ABAP_COMPILER: Analysis Structure7TIMENatural Numberint100
22SCR_ABAP_SCANScan Results6TIMENatural Numberint100
23SCR_ABAP_SYMBScan Results6TIMENatural Numberint100
24SKNETCSSSKNETPING3TIMETIME-Datenelement fuer SYSTnvarchar60
25SKNETPINGPING RESULTS3TIMETIME-Datenelement fuer SYSTnvarchar60
26T7CNREW_APRHISPayroll approval item history7TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
27WBBGRFCTMPLog for Where Used Index Update in Backgound Tasks5TIMESystem Timenvarchar60
28T7PIQ_GB_UFILEINUCAS: Records UFileIn19TIMETimenvarchar60
TOPABAP Runtime Environment
29INSTVERSDocumentation for installation Status and History10TIMEField of type TIMSnvarchar60
TOPAuthentication and SSO
30TRACE_MESSAGEContains trace messages5TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPBalanced Scorecard
31UMB_SC145CCause-Effect Chain: XML Document11TIMETIME Data Element for SYSTnvarchar60
TOPBasic Functions
32TTSEGMAPPTime Segment: Map to Times1TIMELogical timenvarchar100
33TTSEGTIMETime Segment Time1TIMELogical timenvarchar100
34TTSEGTIMETTime Segment Text for Time2TIMELogical timenvarchar100
35WTMIGIFWithholding Tax Changeover: Commands Executed by Tool6TIMETimenvarchar60
TOPBusiness Planning and Simulation
36UPE_PARAMPlanning: Parameterization (SD files)5TIMECharacteristicnvarchar300
37UPWB_DEBUG_LOGLog DB for Debugging at Runtime3TIMETIME Data Element for SYSTnvarchar60
38UPX_LAYOUTEnhanced Planning Layouts: Main Table7TIMESystem Timenvarchar60
39UPX_LAYOUT_OFFBDOC: Offline Versions of the Layouts6TIMESystem Timenvarchar60
TOPCCMS Database Monitors for Oracle
40DBMSGORADatabase Check: Messages4TIMETime of Check or Changenvarchar140
TOPClaims Management
41TICLB_900CBRFplus Object Renamings13TIMEPoint in Time of Last Actiondecimal150
TOPClientServer Technology
42GUI_E2E_TRACESGui Epp Traces4TIMETrace Step Start Timenvarchar140
43GUI_E2E_XMLTable for storing BusinessTransaction.xml3TIMEnvarchar400
TOPClinical System
44N1CYDEF_EXTi.s.h.med: Single Time Definition for Cycles6TIMECycle: Time Individual Timenvarchar60
45N1MEODOSEMODAi.s.h.med: Assignment of Quantity Modulation to Order5TIMEMedication: Cycle Start Timenvarchar60
46N1OUTIMESi.s.h.med: Standard Times for Organizational Units5TIMECycle: Time Individual Timenvarchar60
47N1TPODOSEMODAi.s.h.med: Quantity Modulat. Assignment to Order Template5TIMEMedication: Cycle Start Timenvarchar60
48N1ZYINF_EXTi.s.h.med: Single Time Definition for Cycles (Master Data)6TIMECycle: Time Individual Timenvarchar60
49TN1MEUNITIS-H*MED: Medication - Units for Orders8TIMEMedication: Time Unit Indicatornvarchar10
50TN1RCODEIS-H*MED: Reason Code6TIMEMedication: Reason for Time Difference Indicatornvarchar10
TOPConsolidation
51TF080List Directory of MCDX12TIMETime of last changenvarchar60
52TF261CG/CU: Detail Status of Tasks - Data Monitor13TIMETime of last changenvarchar60
53TF262History of Data Entry Layouts10TIMETime of last changenvarchar60
54TF271CG/CU: Detail Status of Tasks - Consolidation Monitor13TIMETime of last changenvarchar60
TOPContract Accounts Receivable and Payable
55DFKKTRACEKFKKTRACE: Header for a Trace Run3TIMETime in CHAR Formatnvarchar60
56DFKKTRACEPFKKTRACE: Item Data3TIMETimenvarchar60
57DFK_JC_CNTR_MSGMessages for Background Processing5TIMETimenvarchar60
TOPContract Billing
58EMDUSDRQRESULTResults for Subrequest9TIMETimenvarchar60
TOPCross-Application Components
59HDB_STATUSERP Accelerators: Generic Status9TIMETimenvarchar60
TOPData Staging
60RSPCLOGTIMECACHECache for Runtime Statistics2TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPDenmark
61T5M7DStatus Line for Payroll Run9TIMECurrent timenvarchar60
TOPDevice Management
62EGEREDraw and Sampling Number of a Device4TIMETimenvarchar60
63TE271ESample Lot - Canadian Sampling Inspection4TIMETimenvarchar60
TOPDistribution Unit Distribution Packet
64DSPSTSALE Distribution Packet : Status History5TIMESystem Timenvarchar60
TOPDocument Builder
65/IPRO/TUR_LOGUpdate Report Log for Batch Processing5TIMETimenvarchar60
TOPDownloadUpload
66/DSD/HH_RAIVHDDSD Route Settlement: HH Billing Document Header6TIMEDSD - RA: Time Stamp Printout Time (UTC)decimal150
67/DSD/HH_RAIVPRTDSD Route Settlement: HH Billing Document Print6TIMEDSD - RA: Time Stamp Printout Time (UTC)decimal150
TOPDSD Connector
68/DSD/ME_DEL_HDDSD CN: Delivery Header Data13TIMEDSD Connector: Timenvarchar60
69/DSD/ME_INV_HDDSD CN: Billing Doc. Header Data12TIMEDSD Connector: Timenvarchar60
70/DSD/ME_ORD_HDDSD CN: Order Header Data12TIMEDSD Connector: Timenvarchar60
TOPEnd User Technology
71RSRXLSTESTTests for Excel Analyzer3TIMETimenvarchar60
TOPGlobal Performance Analysis Transaction ST3
72AMRFCGlobal Perfromance Analysis: RFC Trace Data9TIMEPerformance Log for RFC Trace: Statement Start Timenvarchar120
TOPIndustry Solution Oil
73OI0_PROPT_OB_TFSet time frame for outbond notification6TIMEField of type TIMSnvarchar60
74OIB_DEF_INDEX_GMDefault index for Goods Movement7TIMESystem Timenvarchar60
TOPInternet Communication Framework
75ICF_SERV_STATInterim Storage of ICF Statistics Data4TIMESAP Workload NW Collector: Text Field of 48 Charactersnvarchar480
TOPliveCache Applications
76/SAPAPO/OMTSTUIDTest Combination, Time, User, ...4TIMESystem Timenvarchar60
77/SAPAPO/OM_RESULResults table2TIMELocal Timenvarchar60
TOPMapping
78SMPPAUTOXI Mapping: Results of Automatic Test Cases4TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMedia Product Sales and Distribution
79JKSDWWWERROR01IS-M: Error Records for Retail via Internet10TIMETimenvarchar60
TOPMobiles User Interface
80PUSHLOGWAP Push Logging3TIMETimenvarchar60
TOPOLAP Technology
81RSCDS_ACTIONLOGActions that were triggered for the summarization2TIMESystem Timenvarchar60
82RSDDSTATWHMStatistics Data: BW for Warehouse Management12TIMERuntimedecimal216
83RSDDSTAT_WRITEStatistics for InfoCube Write1TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPOrganizational Management
84T77ZZPD XPRA Control8TIMESystem Timenvarchar60
TOPPayment Transactions
85FPCR_LINK_OBJLinked Objects for Garnishment17TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
86TFIBLOPVAROnline Payment: Administration of Variants6TIMESystem Timenvarchar60
TOPPayroll
87T5H84Payroll log19TIMETime in CHAR formatnvarchar60
TOPPlanning
88T8PL00FI Planning: Installed Plan Tables7TIMETime in CHAR Formatnvarchar60
TOPPlant Maintenance
89EAMS_SL_TIMERRefresh Timer for the Silverlight Appication2TIMEField of type TIMSnvarchar60
TOPPortal Content
90ISTNLMORDERALOrders with Triggered Alerts5TIMEAlert Creation Timenvarchar60
TOPProcess Monitoring Infrastructure
91SSPIDEMOSHIPMENTPMI Demo: Shipment4TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPProduction Planning
92TCPFS3External planning tool: lock table4TIMETimestamp (date and time) for usernvarchar140
TOPProfitability Analysis
93RKE_POST_LOGLog: Post Directly to CO-PA5TIMETimenvarchar60
94TKEBO_PROTPCM Model Log7TIMETimenvarchar60
95TKEHA_LOGHANA Protocol8TIMETimenvarchar60
96TKETRPROTAccess Log for Summarization Levels13TIMEGross Time Required to Readdecimal152
97TKE_HDB_REPLCO-PA Accelerator: Replication-Runs20TIMETimenvarchar60
TOPPublic Sector Contract Accounts Receivable and Payable
98DFMCA_BRF_MSGTax Calculation and Validation: Error Messages13TIMETimenvarchar60
TOPPurchasing
99WGRC_ASS_RASTERResource Table Grid3TIMETimenvarchar60
100WGRC_RES_RASTERResource Table Grid3TIMETimenvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
101NLGGZ_CODE_LOGGeisteskrankheit DBC protokoltabelle6TIMESystemzeitnvarchar60
102NLGGZ_DIAG_LOGGeisteskrankheit DBC zusatz diagnosen protkoltabelle7TIMESystemzeitnvarchar60
TOPSAP List Viewer
103ALV_T_T2Test Data for ALV32TIMEField of type TIMSnvarchar60
TOPSerial Numbers
104ARC_PM_OBJLISTCustomizing for Archiving of Serial Number Object Lists3TIMEResidence Time for Documentsnvarchar50
TOPService Data Download
105/SDF/ANALYSESAnalyses of report /SDF/MONITORING4TIMESystem Timenvarchar60
106/SDF/CLI_TRCTable for storing BusinessTransaction.xml3TIMEnvarchar400
107/SDF/CMO_ERR_LOGCMO Service: Error log4TIMECMO Service: Secondsint100
108/SDF/DBMSGORATable for messages from DB system check4TIMEnvarchar140
109/SDF/MON_HEADERMonitoring Data3TIMETimenvarchar60
110/SOMO/DOCSTASCHScheduling table for document volume statistics4TIMEnvarchar60
TOPTraders and Schedulers Workbench
111OIJ_EL_LAYT_EVLaytime start and end events14TIMEReference timenvarchar60
112TOIJ_EL_LAYT_EVDefault laytime terms for documents10TIMEReference timenvarchar60
TOPTransaction Manager
113IDCFM_FRIM_RUNSRuns of Impairment Report8TIMETime of Impairment Runnvarchar60
114THMEXT_PLANNERE-HA: Hedge Plan12TIMETimenvarchar60
TOPTransaction Variant and Table Control Settings
115SHDGUIXTScreen variants <--> GuiXT scripts (attributes)7TIMESystem Timenvarchar60
TOPTranslation Tools
116LXE_ATTR_PROPProperties of Additional Object Attributes6TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPTravel Planning
117TA23PROTLog for Sabre Interface6TIMELocal Timenvarchar60
TOPTreasury
118JBDT56PReference interest rate table dependent on exact time4TIMEDatafeed: Time of value (SAP format)nvarchar60
TOPWeb Service and SOAP - ABAP
119TUCC_TEST_TABLETable for TUCC Test Cases1TIMECharacter field, length 32nvarchar320