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

50 columns | Print definition?ERP 6.0  | LAST_USER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CFUNC_DETFunction Information21LAST_USERLast Usernvarchar120
2/AIF/CIFPP_TJSELDefine Selection for CIF Postprocessing11LAST_USERLast Usernvarchar120
3/AIF/CLINKCustom Data Link13LAST_USERLast Usernvarchar120
4/AIF/CTEXTCustom Message Text13LAST_USERLast Usernvarchar120
5/AIF/DOCU_ID_IDXDocument search index table25LAST_USERLast Usernvarchar120
6/AIF/FLBOOK_IDXStandard index table22LAST_USERLast Usernvarchar120
7/AIF/HINTSDB Table for saving the hints14LAST_USERLast Usernvarchar120
8/AIF/IDC_IDX_TBLStandard index table22LAST_USERLast Usernvarchar120
9/AIF/MIDX_TEMPLTemplate for a multi index table23LAST_USERLast Usernvarchar120
10/AIF/NS_LOCKDefine Namespace12LAST_USERLast Usernvarchar120
11/AIF/PERS_RTCFGRAIF Persistence: Runtime Configuration Group8LAST_USERLast Usernvarchar120
12/AIF/PERS_XMLAIF XML Persistency: Message Header11LAST_USERLast Usernvarchar120
13/AIF/QRFC_S_IDXqRFC Standard index table22LAST_USERLast Usernvarchar120
14/AIF/QRFC_TJ_SOSelection Options for qRFC transfer job9LAST_USERLast Usernvarchar120
15/AIF/QRFC_TJ_SYSSelection Options for qRFC Transfer Job12LAST_USERLast Usernvarchar120
16/AIF/Q_STD_IDX_TqRFC Standard index table22LAST_USERLast Usernvarchar120
17/AIF/RUNNING_WFRunning Workflow for AIF10LAST_USERLast Usernvarchar120
18/AIF/STD_IDX_TBLStandard index table22LAST_USERLast Usernvarchar120
19/AIF/TEST_BP_IDXStandard index table22LAST_USERLast Usernvarchar120
20/AIF/TIDOC_STRAIF IDoc structure mapping table12LAST_USERLast Usernvarchar120
21/AIF/TRFC_S_IDXtRFC Standard index table22LAST_USERLast Usernvarchar120
22/AIF/TRFC_TJ_SOSelection Options for tRFC transfer job6LAST_USERLast Usernvarchar120
23/AIF/TRFC_TJ_SYSSelection Options for Transfer Job10LAST_USERLast Usernvarchar120
24/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing22LAST_USERLast Usernvarchar120
25/AIF/T_MMSG_IDXMulti Msg class&No. search index table27LAST_USERLast Usernvarchar120
26/AIF/T_QRFC_LOGLog table for Playback Functions generation8LAST_USERLast Usernvarchar120
27/AIF/T_RFC_FGLOGFunction Module List Generation Log27LAST_USERLast Usernvarchar120
28/AIF/T_STD_IDX_TtRFC Standard index table22LAST_USERLast Usernvarchar120
29/AIF/T_TJ_SSSelection set for transfer job10LAST_USERLast Usernvarchar120
30/AIF/T_TRFC_FUNCPlayback Functions for tRFC Reader12LAST_USERLast Usernvarchar120
31/AIF/VALID_PERIOAIF Validity Period8LAST_USERLast Usernvarchar120
32/AIFX/ECH_STD_TBStandard ECH key fields table37LAST_USERLast Usernvarchar120
33/IWBEP/SU_CONFIGSUTIL Configuration6LAST_USERUser Namenvarchar120
34/IWFND/SU_CONFIGSUTIL Configuration6LAST_USERUser Namenvarchar120
35HDB_ABAPCLIENTHANA: global parameters for ABAP Client3LAST_USERLast Changed bynvarchar120
36ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN22LAST_USERLast Usernvarchar120
TOPBusiness Partners
37NBP_MIGR_STATEStore State of BP Migration8LAST_USERUser Namenvarchar120
TOPData Basis
38RSCNVMONTable to store the general data for Monitor6LAST_USERUser Namenvarchar120
TOPInformation System
39T803JReport Writer: Report Groups26LAST_USERLast user who selectednvarchar120
TOPPersonnel Administration
40T51B1HR-ARC: Global Characteristics of Archiving Group12LAST_USERChanged bynvarchar120
TOPTREX ABAP JAVA API
41NEWDB_GLOBALNewDB: Global parameters4LAST_USERLast Changed bynvarchar120
42NEWDB_RESET_INFLatest user and timestamp for resetting NewDB global flags3LAST_USERLast Changed bynvarchar120
43TREXHDB_GLOBALTREX: Global parameter for HDB-DBSL communication3LAST_USERLast Changed bynvarchar120
44TREXICM_GLOBALTREX: Global parameters for BasisClient15LAST_USERLast Changed bynvarchar120
45TREXICM_GLOBAL2TREX: Global parameters for BasisClient10LAST_USERLast Changed bynvarchar120
46TREX_ASYNC_ADMINTREX internal use: Activation of TREX async communication.2LAST_USERUser Namenvarchar120
47TRX_BC_RESET_INFLatest user and timestamp for resetting TREX global flags2LAST_USERLast Changed bynvarchar120
TOPWeb Service and SOAP - ABAP
48SRT_UTIL_ADMSRT Utilities: Administration5LAST_USERUser Namenvarchar120
49SRT_UTIL_CONFIGSRT Utilities: Trace Configuration6LAST_USERUser Namenvarchar120
50SRT_UTIL_GLOBALSRT Utilities: Global Properties2LAST_USERUser Namenvarchar120