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

47 columns | Print definition?ERP 6.0  | LAST_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CFUNC_DETFunction Information23LAST_TIMELast Timenvarchar60
2/AIF/CIFPP_TJSELDefine Selection for CIF Postprocessing13LAST_TIMELast Timenvarchar60
3/AIF/CLINKCustom Data Link15LAST_TIMELast Timenvarchar60
4/AIF/CTEXTCustom Message Text15LAST_TIMELast Timenvarchar60
5/AIF/DOCU_ID_IDXDocument search index table27LAST_TIMELast Timenvarchar60
6/AIF/FLBOOK_IDXStandard index table24LAST_TIMELast Timenvarchar60
7/AIF/HINTSDB Table for saving the hints16LAST_TIMELast Timenvarchar60
8/AIF/IDC_IDX_TBLStandard index table24LAST_TIMELast Timenvarchar60
9/AIF/MIDX_TEMPLTemplate for a multi index table25LAST_TIMELast Timenvarchar60
10/AIF/NS_LOCKDefine Namespace14LAST_TIMELast Timenvarchar60
11/AIF/PERS_RTCFGRAIF Persistence: Runtime Configuration Group10LAST_TIMELast Timenvarchar60
12/AIF/PERS_XMLAIF XML Persistency: Message Header13LAST_TIMELast Timenvarchar60
13/AIF/QRFC_S_IDXqRFC Standard index table24LAST_TIMELast Timenvarchar60
14/AIF/QRFC_TJ_SOSelection Options for qRFC transfer job11LAST_TIMELast Timenvarchar60
15/AIF/QRFC_TJ_SYSSelection Options for qRFC Transfer Job14LAST_TIMELast Timenvarchar60
16/AIF/Q_STD_IDX_TqRFC Standard index table24LAST_TIMELast Timenvarchar60
17/AIF/REP_MSG_CNTAIF Automatic Reprocessing: Message Counter7LAST_TIMELast Timenvarchar60
18/AIF/RUNNING_WFRunning Workflow for AIF12LAST_TIMELast Timenvarchar60
19/AIF/STD_IDX_TBLStandard index table24LAST_TIMELast Timenvarchar60
20/AIF/TEST_BP_IDXStandard index table24LAST_TIMELast Timenvarchar60
21/AIF/TIDOC_STRAIF IDoc structure mapping table14LAST_TIMELast Timenvarchar60
22/AIF/TRFC_S_IDXtRFC Standard index table24LAST_TIMELast Timenvarchar60
23/AIF/TRFC_TJ_SOSelection Options for tRFC transfer job8LAST_TIMELast Timenvarchar60
24/AIF/TRFC_TJ_SYSSelection Options for Transfer Job12LAST_TIMELast Timenvarchar60
25/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing24LAST_TIMELast Timenvarchar60
26/AIF/T_MMSG_IDXMulti Msg class&No. search index table29LAST_TIMELast Timenvarchar60
27/AIF/T_QRFC_LOGLog table for Playback Functions generation10LAST_TIMELast Timenvarchar60
28/AIF/T_RFC_FGLOGFunction Module List Generation Log29LAST_TIMELast Timenvarchar60
29/AIF/T_STD_IDX_TtRFC Standard index table24LAST_TIMELast Timenvarchar60
30/AIF/T_TJ_SSSelection set for transfer job12LAST_TIMELast Timenvarchar60
31/AIF/T_TRFC_FUNCPlayback Functions for tRFC Reader14LAST_TIMELast Timenvarchar60
32/AIF/VALID_PERIOAIF Validity Period10LAST_TIMELast Timenvarchar60
33/AIFX/ECH_STD_TBStandard ECH key fields table39LAST_TIMELast Timenvarchar60
34/OPT/VT_JOBJob Details4LAST_TIMETimenvarchar60
35BBPD_IMS_BE_INVIMS: Last Update for TREX4LAST_TIMETimenvarchar60
36CNVC_CCE_TABCONTChecksum for table contents10LAST_TIMESystem Timenvarchar60
37ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN24LAST_TIMELast Timenvarchar60
TOPDB2 Universal Database for UNIX NT
38DB6CSTRACEDB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace)13LAST_TIMEnvarchar260
TOPDistributed System Landscape
39/ISDFPS/ALE_RBDSALE RDBSTATE: Time Stamp for Logging of Reports4LAST_TIMEField of type TIMSnvarchar60
TOPInformation System
40T803JReport Writer: Report Groups25LAST_TIMELast time selectednvarchar60
TOPMonitoring
41ALTSTLODMonitoring Arch.: For Report to Measure a Standard Load2LAST_TIMEAlert: Time value in timeformatnvarchar60
TOPProcess Monitoring Infrastructure
42SSPIMODSSTORPMI: Database Tables and Sizes4LAST_TIMESystem Timenvarchar60
TOPSAP Business Workflow
43SWU_WLSCANDate and time of last work list scan for R3F transmission4LAST_TIMETIme of last work list scan for R3F message transmissionnvarchar60
TOPSecurity
44USR41_MLDTransaction Data for USR419LAST_TIMEModification timenvarchar60
TOPTravel Planning
45FTPT_FLIGHT_TSTTicket information19LAST_TIMELatest Ticketing Timenvarchar60
46FTPT_FLIGHT_TSTKTicket Information34LAST_TIMELatest Ticketing Timenvarchar60
TOPTREX ABAP JAVA API
47TREX_ASYNC_ADMINTREX internal use: Activation of TREX async communication.4LAST_TIMESystem Timenvarchar60