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

68 columns | Print definition?ERP 6.0  | LOGNUMBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/DOCU_ID_IDXDocument search index table18LOGNUMBERApplication log: log numbernvarchar200
2/AIF/FLBOOK_IDXStandard index table15LOGNUMBERApplication log: log numbernvarchar200
3/AIF/IDC_IDX_TBLStandard index table15LOGNUMBERApplication log: log numbernvarchar200
4/AIF/MIDX_TEMPLTemplate for a multi index table16LOGNUMBERApplication log: log numbernvarchar200
5/AIF/QRFC_S_IDXqRFC Standard index table15LOGNUMBERApplication log: log numbernvarchar200
6/AIF/Q_STD_IDX_TqRFC Standard index table15LOGNUMBERApplication log: log numbernvarchar200
7/AIF/STD_IDX_TBLStandard index table15LOGNUMBERApplication log: log numbernvarchar200
8/AIF/TEST_BP_IDXStandard index table15LOGNUMBERApplication log: log numbernvarchar200
9/AIF/TRFC_S_IDXtRFC Standard index table15LOGNUMBERApplication log: log numbernvarchar200
10/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing15LOGNUMBERApplication log: log numbernvarchar200
11/AIF/T_MMSG_IDXMulti Msg class&No. search index table20LOGNUMBERApplication log: log numbernvarchar200
12/AIF/T_STD_IDX_TtRFC Standard index table15LOGNUMBERApplication log: log numbernvarchar200
13/AIFX/ECH_STD_TBStandard ECH key fields table30LOGNUMBERApplication log: log numbernvarchar200
14/GEOE/GISMSGMessage Table11LOGNUMBERApplication log: log numbernvarchar200
15/GSINS/NLG_FILESGBA NL: Values of Importing/Exporting Reports12LOGNUMBERApplication log: log numbernvarchar200
16/OTX/RM_ERRORQArchiveLink entries whose RM processing failed13LOGNUMBERApplication log: log numbernvarchar200
17/OTX/RM_ERRORQPLPrintlist entries whose RM processing failed23LOGNUMBERApplication log: log numbernvarchar200
18/OTX/RM_WSC_ERRQECM Workspace Error Queue10LOGNUMBERApplication log: log numbernvarchar200
19CNVA_COA_CONV_VSChart of Accounts to conversion analysis6LOGNUMBERApplication log: log numbernvarchar200
20CNVHCM_COMPARLOGTDMS4HCM: Protocoll information for payroll compare10LOGNUMBERApplication log: log numbernvarchar200
21CNVHCM_COMPARL_TTDMS4HCM: Protocoll information for payroll compare7LOGNUMBERApplication log: log numbernvarchar200
22CNVHCM_D_PSLIDTDMS4HCM: Object Selection ID13LOGNUMBERApplication log: log numbernvarchar200
23CNVMBTCOTLOGCOT: Object Logs3LOGNUMBERApplication log: log numbernvarchar200
24CNVMBTDELREFTECHTechnical info about the reorganization like job and log6LOGNUMBERApplication log: log numbernvarchar200
25CNVMBTDEXACTIONSDMIS PCL Data Extract Action history11LOGNUMBERApplication log: log numbernvarchar200
26CNVMBTDEXFILSTATDMIS PCL Status of Data Extract Files13LOGNUMBERApplication log: log numbernvarchar200
27CNVMBTSTATEStatus table for execution of all activities and history27LOGNUMBERApplication log: log numbernvarchar200
28CNVMBTSUBSTATEStatus table for execution of all subactivities and histor32LOGNUMBERApplication log: log numbernvarchar200
29CNV_MBT_ACT_LOGApplication log for DMIS Actions4LOGNUMBERApplication log: log numbernvarchar200
30CNV_PROTDOWN6LOGNUMBERApplication log: log numbernvarchar200
31DMC_ACT_REC_LOGApplication logs assigned to a DMC activity2LOGNUMBERApplication log: log numbernvarchar200
32DMC_ERROR_LOGMWB: store latest error messages per mass transfer and table7LOGNUMBERApplication log: log numbernvarchar200
33TREAT_KEY_FIGUREProvides Key Figures for TREA13LOGNUMBERApplication log: log numbernvarchar200
34ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN15LOGNUMBERApplication log: log numbernvarchar200
TOPBasis Application Log
35BALCApplication Log: Log or message context2LOGNUMBERApplication log: log numbernvarchar200
36BALHDRApplication log: log header2LOGNUMBERApplication log: log numbernvarchar200
37BALHDRPApplication log: log parameter2LOGNUMBERApplication log: log numbernvarchar200
38BALMApplication log: log message2LOGNUMBERApplication log: log numbernvarchar200
39BALMPApplication log: message parameter2LOGNUMBERApplication log: log numbernvarchar200
40BAL_INDXApplication Log: INDX tables3LOGNUMBERApplication log: log numbernvarchar200
TOPBusiness Partner
41MDM_TESTDATA_1Test Data Directory13LOGNUMBERApplication log: log numbernvarchar200
TOPContract Billing
42ISU_BALHDRLast Log as Starting Point for Extract Generation3LOGNUMBERApplication log: log numbernvarchar200
43ISU_PROC_LOGProcessed External Log Numbers per Extract Generation4LOGNUMBERApplication log: log numbernvarchar200
TOPData Mining
44RSDMTP_BATCHDetails for batch job and monitoring14LOGNUMBERApplication log: log numbernvarchar200
TOPDistributed Maintenance
45/ISDFPS/FWOBJDSPDFPS: Objects to Be Distributed from Maintenance Calls7LOGNUMBERApplication log: log numbernvarchar200
TOPEnd User Technology
46RSRD_REGISTRATNRegistration of Settings to Events (Broadcasting)8LOGNUMBERApplication log: log numbernvarchar200
TOPEnvironment, Health and Safety
47/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten35LOGNUMBERApplication log: log numbernvarchar200
48/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv35LOGNUMBERApplication log: log numbernvarchar200
TOPGenerating, Monitoring for Mass Data Archiving Solutions
49AFX_OBJECT_LOGApplication Log of AFX Objects4LOGNUMBERApplication log: log numbernvarchar200
TOPGuided Structure Synchronization
50/PLMB/GSS_SU_LOGLogs of Sync Unit3LOGNUMBERApplication log: log numbernvarchar200
TOPMeter Reading
51ELWEG_LOGLog Numbers for Street Routes3LOGNUMBERApplication log: log numbernvarchar200
TOPPegging, Grouping, and Distribution
52DIS_ADMINDistribution - Administration Table2LOGNUMBERApplication log: log numbernvarchar200
53PEG_ADMINPegging - Administration Table2LOGNUMBERApplication log: log numbernvarchar200
54PEG_DIS_ADMINPegging and Distribution - administration table2LOGNUMBERApplication log: log numbernvarchar200
TOPPlanning
55RSPLS_SQLOG_HEADParallel Execution: Log Table Header - Sequence Execution3LOGNUMBERApplication log: log numbernvarchar200
TOPPortfolio
56VDBILL_HISTBilling History16LOGNUMBERApplication Log: External IDnvarchar1000
TOPProduction Orders
57FUNOCMFunction marked for Order Change Management28LOGNUMBERApplication log: log numbernvarchar200
TOPReceivablesPayment Management
58VDAD_HISTAuto Debits, Historical Data11LOGNUMBERApplication Log: External IDnvarchar1000
TOPRecipe Development
59/PLMB/CCK_HDRCompliance Check12LOGNUMBERApplication log: log numbernvarchar200
TOPRecords and Case Management
60RMPSPRO_DP_REP1PRO Disposal Process: Disposal Transaction14LOGNUMBERApplication log: log numbernvarchar200
TOPResults Recording
61QEWLQM Handheld: Worklist for Transfer21LOGNUMBERApplication log: log numbernvarchar200
TOPRevenue
62OIUE2_RUN_DTLProc 2.0 - Run Detail4LOGNUMBERApplication log: log numbernvarchar200
TOPRoute Settlement
63/DSD/SL_APPLINFOApplication Log: INDX tables3LOGNUMBERApplication log: log numbernvarchar200
TOPSCM Basis
64CIFBALSELApplication Log: CIF Extension for Log Selection2LOGNUMBERCIF: Log Number in Application Lognvarchar220
TOPTax Reporting
65OIUX3_MIG_CTRLTax Reporting - Migration Control9LOGNUMBERApplication log: log numbernvarchar200
66OIUX3_RUN_DTLTax Reporting - Run Detail5LOGNUMBERApplication log: log numbernvarchar200
67OIUX7_RUN_DTLTax 2.0 - WYGP Run Detail5LOGNUMBERApplication log: log numbernvarchar200
TOPWithout Description
68RSDMTU_AWB_MONMonitoring AWB11LOGNUMBERApplication log: log numbernvarchar200