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

63 columns | Print definition?ERP 6.0  | LAST_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/ALERT_IDXStandard index table for multiple recipients10LAST_DATELast Datenvarchar80
2/AIF/CFUNC_DETFunction Information22LAST_DATELast Datenvarchar80
3/AIF/CIFPP_TJSELDefine Selection for CIF Postprocessing12LAST_DATELast Datenvarchar80
4/AIF/CLINKCustom Data Link14LAST_DATELast Datenvarchar80
5/AIF/CTEXTCustom Message Text14LAST_DATELast Datenvarchar80
6/AIF/DOCU_ID_IDXDocument search index table26LAST_DATELast Datenvarchar80
7/AIF/FLBOOK_IDXStandard index table23LAST_DATELast Datenvarchar80
8/AIF/HINTSDB Table for saving the hints15LAST_DATELast Datenvarchar80
9/AIF/IDC_IDX_TBLStandard index table23LAST_DATELast Datenvarchar80
10/AIF/MIDX_TEMPLTemplate for a multi index table24LAST_DATELast Datenvarchar80
11/AIF/NS_LOCKDefine Namespace13LAST_DATELast Datenvarchar80
12/AIF/PERS_RTCFGRAIF Persistence: Runtime Configuration Group9LAST_DATELast Datenvarchar80
13/AIF/PERS_XMLAIF XML Persistency: Message Header12LAST_DATELast Datenvarchar80
14/AIF/QRFC_S_IDXqRFC Standard index table23LAST_DATELast Datenvarchar80
15/AIF/QRFC_TJ_SOSelection Options for qRFC transfer job10LAST_DATELast Datenvarchar80
16/AIF/QRFC_TJ_SYSSelection Options for qRFC Transfer Job13LAST_DATELast Datenvarchar80
17/AIF/Q_STD_IDX_TqRFC Standard index table23LAST_DATELast Datenvarchar80
18/AIF/REP_MSG_CNTAIF Automatic Reprocessing: Message Counter6LAST_DATELast Datenvarchar80
19/AIF/RUNNING_WFRunning Workflow for AIF11LAST_DATELast Datenvarchar80
20/AIF/STD_IDX_MULStandard index table for multiple recipients10LAST_DATELast Datenvarchar80
21/AIF/STD_IDX_TBLStandard index table23LAST_DATELast Datenvarchar80
22/AIF/TEST_BP_IDXStandard index table23LAST_DATELast Datenvarchar80
23/AIF/TIDOC_STRAIF IDoc structure mapping table13LAST_DATELast Datenvarchar80
24/AIF/TRFC_S_IDXtRFC Standard index table23LAST_DATELast Datenvarchar80
25/AIF/TRFC_TJ_SOSelection Options for tRFC transfer job7LAST_DATELast Datenvarchar80
26/AIF/TRFC_TJ_SYSSelection Options for Transfer Job11LAST_DATELast Datenvarchar80
27/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing23LAST_DATELast Datenvarchar80
28/AIF/T_MMSG_IDXMulti Msg class&No. search index table28LAST_DATELast Datenvarchar80
29/AIF/T_QRFC_LOGLog table for Playback Functions generation9LAST_DATELast Datenvarchar80
30/AIF/T_RFC_FGLOGFunction Module List Generation Log28LAST_DATELast Datenvarchar80
31/AIF/T_STD_IDX_TtRFC Standard index table23LAST_DATELast Datenvarchar80
32/AIF/T_TJ_SSSelection set for transfer job11LAST_DATELast Datenvarchar80
33/AIF/T_TRFC_FUNCPlayback Functions for tRFC Reader13LAST_DATELast Datenvarchar80
34/AIF/VALID_PERIOAIF Validity Period9LAST_DATELast Datenvarchar80
35/AIFX/ECH_STD_TBStandard ECH key fields table38LAST_DATELast Datenvarchar80
36/OPT/VT_JOBJob Details3LAST_DATEDatenvarchar80
37BBPD_IMS_BE_INVIMS: Last Update for TREX3LAST_DATEDatenvarchar80
38BBP_USRBDGTTable for Update of User-Defined Budget5LAST_DATEPosting Date for a Business Transactionnvarchar80
39CNVC_CCE_TABCONTChecksum for table contents9LAST_DATESystem Datenvarchar80
40HDB_ABAPCLIENTHANA: global parameters for ABAP Client4LAST_DATEDate of Last Changenvarchar80
41J_1UF_TP_MAINMain Information of Notification35LAST_DATEPosting Date in the Documentnvarchar80
42J_3RF_TP_MAINMain Information of Notification24LAST_DATEPosting Date in the Documentnvarchar80
43ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN23LAST_DATELast Datenvarchar80
TOPBank Customer Accounts
44BKKSOBCA: Standing Orders15LAST_DATELast Executionnvarchar80
TOPBasic Data
45TNC301F0IS-H EDI Table for File Name Composition27LAST_DATEIS-H: EDI Date when Counter Last Incrementednvarchar80
TOPClient Copy
46CCCFLOWClient Copy Control Flow38LAST_DATESystem Datenvarchar80
TOPDistributed System Landscape
47/ISDFPS/ALE_RBDSALE RDBSTATE: Time Stamp for Logging of Reports3LAST_DATEField of type DATSnvarchar80
TOPGRC Risk Management
48/ORM/ORMTEVNTLOSILD Event Losses11LAST_DATEEvent Loss - Last Day of Impactnvarchar80
TOPInformation System
49T803JReport Writer: Report Groups24LAST_DATELast date selectednvarchar80
TOPMonitoring
50ALTSTLODMonitoring Arch.: For Report to Measure a Standard Load3LAST_DATEAlert: datenvarchar80
TOPPrint Workbench
51EPRINTACTPrint Action Record6LAST_DATEDate last processednvarchar80
TOPProcess Monitoring Infrastructure
52SSPIMODSSTORPMI: Database Tables and Sizes3LAST_DATESystem Datenvarchar80
TOPSAP Business Workflow
53SWU_WLSCANDate and time of last work list scan for R3F transmission3LAST_DATEDate of last work list scan for R3F message transmissionnvarchar80
TOPSecurity
54USR41_MLDTransaction Data for USR418LAST_DATEModification datenvarchar80
TOPTravel Planning
55FTPT_FLIGHT_TSTTicket information9LAST_DATELast Ticketing Datenvarchar80
56FTPT_FLIGHT_TSTKTicket Information10LAST_DATELast Ticketing Datenvarchar80
TOPTREX ABAP JAVA API
57NEWDB_GLOBALNewDB: Global parameters5LAST_DATEDate of Last Changenvarchar80
58NEWDB_RESET_INFLatest user and timestamp for resetting NewDB global flags4LAST_DATEDate of Last Changenvarchar80
59TREXHDB_GLOBALTREX: Global parameter for HDB-DBSL communication4LAST_DATEDate of Last Changenvarchar80
60TREXICM_GLOBALTREX: Global parameters for BasisClient16LAST_DATEDate of Last Changenvarchar80
61TREXICM_GLOBAL2TREX: Global parameters for BasisClient11LAST_DATEDate of Last Changenvarchar80
62TREX_ASYNC_ADMINTREX internal use: Activation of TREX async communication.3LAST_DATESystem Datenvarchar80
63TRX_BC_RESET_INFLatest user and timestamp for resetting TREX global flags3LAST_DATEDate of Last Changenvarchar80