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

119 columns | Print definition?ERP 6.0  | LOG_HANDLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data48LOG_HANDLEApplication Log: Log Handlenvarchar220
2/1RA/0SD012MIItems for Class SD01 - Processable49LOG_HANDLEApplication Log: Log Handlenvarchar220
3/1RA/0SD014MIItems for Class SD01 - Processed48LOG_HANDLEApplication Log: Log Handlenvarchar220
4/1RA/0SD020MIItems for Class SD02 - Raw Data27LOG_HANDLEApplication Log: Log Handlenvarchar220
5/1RA/0SD022MIItems for Class SD02 - Processable28LOG_HANDLEApplication Log: Log Handlenvarchar220
6/1RA/0SD024MIItems for Class SD02 - Processed27LOG_HANDLEApplication Log: Log Handlenvarchar220
7/1RA/0SD030MIItems for Class SD03 - Raw Data35LOG_HANDLEApplication Log: Log Handlenvarchar220
8/1RA/0SD032MIItems for Class SD03 - Processable36LOG_HANDLEApplication Log: Log Handlenvarchar220
9/1RA/0SD034MIItems for Class SD03 - Processed35LOG_HANDLEApplication Log: Log Handlenvarchar220
10/AIF/CLINKCustom Data Link21LOG_HANDLEApplication Log: Log Handlenvarchar220
11/AIF/T_QRFC_LOGLog table for Playback Functions generation11LOG_HANDLEApplication Log: Log Handlenvarchar220
12/AIF/T_TRFC_FUNCPlayback Functions for tRFC Reader15LOG_HANDLEApplication Log: Log Handlenvarchar220
13BUBAS_LOG_STOREStored Application Logs2LOG_HANDLEApplication Log: Log Handlenvarchar220
14CNVCDOP_STATECDOP : Status of the activities in a Project8LOG_HANDLEApplication Log: Log Handlenvarchar220
15CNVCMIS_U_XKDBCMIS XPRA Knowledge base19LOG_HANDLEApplication Log: Log Handlenvarchar220
16CNV_10940_STATEJob status for RVS5LOG_HANDLEApplication Log: Log Handlenvarchar220
17CNV_10993_LOGLog activities in a project.9LOG_HANDLEApplication Log: Log Handlenvarchar220
18CNV_10993_STATEJob status state table5LOG_HANDLEApplication Log: Log Handlenvarchar220
19CNV_MBT_LOG_INDXIndex for log filtering2LOG_HANDLEApplication Log: Log Handlenvarchar220
20DFKKBIXCIT_GENGeneration Info for Consumption Item Class9LOG_HANDLEApplication Log: Log Handlenvarchar220
21DFKKBIXCIT_GENHGeneration Info for Consumption Item Class (History)10LOG_HANDLEApplication Log: Log Handlenvarchar220
22DMC_LOG_INDEXIndex for log filtering2LOG_HANDLEApplication Log: Log Handlenvarchar220
23EHPRCD_COD_BOMBOM Information12LOG_HANDLEApplication Log: Log Handlenvarchar220
24EHPRCD_PBB_GENGeneral Workflow information15LOG_HANDLEApplication Log: Log Handlenvarchar220
25EHPRCD_PBB_TRSFProcess Control - BomBos Transfer14LOG_HANDLEApplication Log: Log Handlenvarchar220
26FARR_D_CONT_ERRLog Message of Contract Error3LOG_HANDLEApplication Log: Log Handlenvarchar220
27FARR_D_RAI_GENGeneration Info for Revenue Accounting Item Class10LOG_HANDLEApplication Log: Log Handlenvarchar220
28FARR_D_RAI_GENHGeneration Info for a Revenue Accounting Item Class (Hist)10LOG_HANDLEApplication Log: Log Handlenvarchar220
29GRFNMWRTARCHHISTMSMP Archiving History8LOG_HANDLEApplication Log: Log Handlenvarchar220
30HRP1107DB Table for Infotype 110731LOG_HANDLEApplication Log: Log Handlenvarchar220
31HRSFI_D_RCT_REQChange Pointer Table for Job Requisitions26LOG_HANDLEApplication Log: Log Handlenvarchar220
32N1MCI_MSGMessage Log4LOG_HANDLEApplication Log: Log Handlenvarchar220
33N1MCI_PROCCommunication Process Log5LOG_HANDLEApplication Log: Log Handlenvarchar220
34RSDHARUNExecutions of HANA Analysis Processes9LOG_HANDLEApplication Log: Log Handlenvarchar220
35TLANOCSSprachentransport - OCS Import12LOG_HANDLEAnwendungs-Log: Handle eines Protokollsnvarchar220
36TREAT_KEY_FIGUREProvides Key Figures for TREA11LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPAnalysis Process Designer
37RSANT_PROCESSRAnalysis Run13LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPBank Customer Accounts
38BKKTERMPPRCTerm Agreements in Postprocessing Status11LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPBasis Application Log
39BALDATApplication Log: Log data3LOG_HANDLEApplication Log: Log Handlenvarchar220
40BALHANDLEApplication Log: Lock object dummy table2LOG_HANDLEApplication Log: Log Handlenvarchar220
41BALHDRApplication log: log header23LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPBatch-Oriented Parallel Processing of Mass Data
42BANK_PP_RUN_LOGLogs Generated During a Mass Run6LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPBilling in Contract Accounts Receivable and Payable
43DFKKBIXBIT_GENGeneration Info for Billable Items Class9LOG_HANDLEApplication Log: Log Handlenvarchar220
44DFKKBIXBIT_GENHGeneration Info for Billable Item Class (History)10LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPBudget Control System
45BUBAS_CLUSTERCluster to store application log3LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPBusiness Objects, Common Components
46EHFNDD_PSE_LOGProcess Setup - Log15LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPBusiness Partners
47NBP_MIGR_STATEStore State of BP Migration2LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPClassification System New
48CHARACTER_DMLDBCharacteristic11LOG_HANDLEApplication Log: Log Handlenvarchar220
49CHARACTER_DMLHCharacteristic13LOG_HANDLEApplication Log: Log Handlenvarchar220
50DEFSCOPE_DMLDBDefinition Scope11LOG_HANDLEApplication Log: Log Handlenvarchar220
51DEFSCOPE_DMLHDefinition Scope13LOG_HANDLEApplication Log: Log Handlenvarchar220
52DTYPE_DMLDBCME Data Type11LOG_HANDLEApplication Log: Log Handlenvarchar220
53DTYPE_DMLHCME Data Type13LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPConsumption-Based Planning See Also PP-MRP
54WSAF_APPL_LOGLog Table for Application Logs6LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPCustom Development Management Cockpit
55CNVCDMC_STATECDMC : Status of the activities in a Project8LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPData Replication Framework
56FOX3_REQUEST_DBFOX Requests5LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPData Staging
57RSCOPY_RUNCopy Process (Run for Copy Tool)12LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPDistributed Maintenance
58/ISDFPS/PMCPRUNTransfer Change Authorization - Runtime Data10LOG_HANDLEApplication Log: Log Handlenvarchar220
59/ISDFPS/PMDISRHDistribution Factory - Runtime Data10LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPDistributor-Reseller-Management
60/SAPHT/DRMINVSUMDRM Inventory Summary26LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPEasy Enhancement Workbench
61AXT_EXTENSION_STExtension Status6LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPeCATT Extended Computer Aided Test Tool
62ECATT_LOG_DSP_MATo log the details after mass change of attributes3LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPEEW Services
63OXT_CUS_EXTCustomer Extension Header10LOG_HANDLEApplication Log: Log Handlenvarchar220
64OXT_CUS_PPROCPostprocessing Activities15LOG_HANDLEApplication Log: Log Handlenvarchar220
65OXT_CUS_PRJObject Extension Projects6LOG_HANDLEApplication Log: Log Handlenvarchar220
66OXT_TASKLINKInterlinkage OXT_CUS_EXT -> OXT_TASKLIST (local+global)10LOG_HANDLEOXT Object GUID22nvarchar220
TOPEnvironment, Health and Safety
67/TDAG/CPT_TASKICP: Positionsdaten für Aufgaben23LOG_HANDLEApplication Log: Log Handlenvarchar220
68/TDAG/CPT_TASKIACP: Positionsdaten für Aufgaben / Archiv23LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPHospital Structure
69NOM_MIGR_STATETable to Store States of Migration of Org. Units2LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPIncentive and Commission Management ICM
70CACS00_B_VAR_CASVariants for Commission Case56LOG_HANDLEApplication Log: Log Handlenvarchar220
71CACS00_CASCommission Case52LOG_HANDLEApplication Log: Log Handlenvarchar220
72CACS00_DOCHDCommission Document Header44LOG_HANDLEApplication Log: Log Handlenvarchar220
73TCACS_PATCH_U02Patch Manager: Job Log8LOG_HANDLEApplication Log: Log Handlenvarchar220
74TCACS_PATCH_U03Patch Manager: Job Log (Steps of Job)8LOG_HANDLEApplication Log: Log Handlenvarchar220
75YCRM01_B_VAR_CASVariants for Commission Case64LOG_HANDLEApplication Log: Log Handlenvarchar220
76YCRM01_CASCommission Case52LOG_HANDLEApplication Log: Log Handlenvarchar220
77YCRM01_DOCHDCommission Document Header44LOG_HANDLEApplication Log: Log Handlenvarchar220
78YHITEC_B_VAR_CASVariants for Commission Case63LOG_HANDLEApplication Log: Log Handlenvarchar220
79YHITEC_CASCommission Case59LOG_HANDLEApplication Log: Log Handlenvarchar220
80YHITEC_DOCHDCommission Document Header58LOG_HANDLEApplication Log: Log Handlenvarchar220
81YSVMA_B_VAR_CASVariants for Commission Case64LOG_HANDLEApplication Log: Log Handlenvarchar220
82YSVMA_CASCommission Case60LOG_HANDLEApplication Log: Log Handlenvarchar220
83YSVMA_DOCHDCommission Document Header52LOG_HANDLEApplication Log: Log Handlenvarchar220
84YTEL01_B_VAR_CASVariants for Commission Case63LOG_HANDLEApplication Log: Log Handlenvarchar220
85YTEL01_CASCommission Case59LOG_HANDLEApplication Log: Log Handlenvarchar220
86YTEL01_DOCHDCommission Document Header58LOG_HANDLEApplication Log: Log Handlenvarchar220
87YTEL05_B_VAR_CASVariants for Commission Case64LOG_HANDLEApplication Log: Log Handlenvarchar220
88YTEL05_CASCommission Case60LOG_HANDLEApplication Log: Log Handlenvarchar220
89YTEL05_DOCHDCommission Document Header52LOG_HANDLEApplication Log: Log Handlenvarchar220
90ZICMAG_B_VAR_CASVariants for Commission Case63LOG_HANDLEApplication Log: Log Handlenvarchar220
91ZICMAG_CASCommission Case59LOG_HANDLEApplication Log: Log Handlenvarchar220
92ZICMAG_DOCHDCommission Document Header58LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPInventory Management
93WRMA_TRANSHeader Data for Posting Run5LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPLanguage Transport
94TLANEXPLanguage Transport: Export Actions13LOG_HANDLEApplication Log: Log Handlenvarchar220
95TLANIMPLanguage Transport: Import Action12LOG_HANDLEApplication Log: Log Handlenvarchar220
96TLANSUPLanguage Transport: Supplementation Action12LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPLease Accounting
97/LSIERP/PROC_LOGPersistence for Payment Trigger Containing Errors2LOG_HANDLEReference Document ID for Leasing Paymentvarbinary160
TOPNetWeaver Enterprise Search
98ESH_EX_FU_FBKFast Update Feedback13LOG_HANDLEApplication Log: Log Handlenvarchar220
99ESH_PRC_TASKProcess step (task)8LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPPostprocessing Office
100/SAPPO/ORDER_HDRPostprocessing Order - Header Data31LOG_HANDLELog Handlenvarchar220
101/SAPPO/ORDER_MSGMessages for Postprocessing Order13LOG_HANDLELog Handlenvarchar220
TOPProduct Cost Planning
102CKCMVCosting Model: Model Valuation8LOG_HANDLEApplication Log: Log Handlenvarchar220
103CKHSHeader: Unit Costing (Control + Totals)83LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPProduction Orders
104FUNOCMFunction marked for Order Change Management32LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPRecords and Case Management
105RMPSD_TRF_EX_ITExport Run - Item List7LOG_HANDLEApplication Log: Log Handlenvarchar220
106RMPSD_TRF_IM_HIImport Run - Hierarchy Work List6LOG_HANDLEApplication Log: Log Handlenvarchar220
107RMPSD_TRF_IM_ITImport Run - Item Work List7LOG_HANDLEApplication Log: Log Handlenvarchar220
108RMPSD_TRF_IM_RLImport Run - Relation Work List7LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPRetention Warehouse
109IWP_WP_LOGLog for Backgroundprocessing3LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPSAP NetWeaver Mobile - Use subcomponents
110MEMPAMONITORAlert ID: Reply Details for MPA3LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPSchedule Manager
111SMMESSAGEMessages Saved for Monitor8LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPTalent Management
112HRP7431Basic Data of Talent Review Meeting27LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPTransaction Manager
113IDCFM_FRIM_RUNSRuns of Impairment Report10LOG_HANDLEApplication Log: Log Handlenvarchar220
114TCORT_COCorrespondence Administrative Data78LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPTranslation Tools
115TRMIDXLog Entries for TRM Processing Runs24LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPUS Prompt Payment Act
116FMFG_PPA_LINKLink the application log to an Invoice (PPA)5LOG_HANDLEApplication Log: Log Handlenvarchar220
TOPWarranty Claim Processing
117PNWTYHWarranty Claim Header (PVS Node)24LOG_HANDLEApplication Log: Log Handlenvarchar220
118PVWTYWarranty Claim Item (PPE Variant)24LOG_HANDLEMessage Existsnvarchar220
TOPWithout Description
119RSRVCHECKLOGCross Table Check name/Log handle5LOG_HANDLEApplication Log: Log Handlenvarchar220