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

71 columns | Print definition?ERP 6.0  | MESSAGE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/IVISEVTALTAlternative messages for DC event5MESSAGE_IDType for IVIS IDsnvarchar360
2/SDF/IVISEVTPREDPredecessor messages for DC event5MESSAGE_IDType for IVIS IDsnvarchar360
3/SDF/IVISEVTRELRelated messages for DC event5MESSAGE_IDType for IVIS IDsnvarchar360
4/SDF/IVISEVTSUCCSuccessor messages for DC event5MESSAGE_IDType for IVIS IDsnvarchar360
5/SLOAP/HELP_HEADapplication help header entries3MESSAGE_IDImprovement message idnvarchar700
6/SLOAP/IMP_LOGImprovement message log5MESSAGE_IDImprovement message idnvarchar700
7/XFT/DIOAIQ_HMESArchive: IQ History - Messages6MESSAGE_IDMessage Classnvarchar200
8/XFT/DIO_IQ_HMESIQ History - Messages6MESSAGE_IDMessage Classnvarchar200
9/XFT/SRM_REC35Process instance: Messages7MESSAGE_IDMessage Classnvarchar200
10/XFT/SSMMESS00SSM: Meldung: Kopftabelle2MESSAGE_IDSSM: Message IDnvarchar320
11BBP_PD_INITCHECKDescription of the PD Sets by Object Type9MESSAGE_IDMessage Classnvarchar200
12DMC_FM_RESTARTAssignment of IDs to sender objects for restart handling5MESSAGE_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
13DMC_FM_RESTART_KAssignment of IDs to sender objects for restart handling4MESSAGE_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
14DMC_RESTARTRestart handling: Assignment of message ID to sender keys3MESSAGE_IDUUID in character formnvarchar320
15EHPRCD_COD_CHKLCheck Log12MESSAGE_IDMessage Classnvarchar200
16HRSFI_D_COMP_ERRSuccessFactors: Comp Log Table for Errors in Delta Handling13MESSAGE_IDMessage Classnvarchar200
17HRSFI_D_ERR_LOGSuccessFactors: Log Table for Errors in Delta Handling11MESSAGE_IDMessage Classnvarchar200
18HRSFI_D_ONB_ERRSuccessFactors: Messages from Onboarding Integration9MESSAGE_IDMessage Classnvarchar200
19HRSFI_D_ONB_GERSuccessFactors: General Messages from Onboarding Integration10MESSAGE_IDMessage Classnvarchar200
20HRSFI_D_RCT_ERRSuccessFactors: Messages from Recruiting Import10MESSAGE_IDMessage Classnvarchar200
21HRSFI_D_RCT_GERSuccessFactors: General Messages from Recruiting Import10MESSAGE_IDMessage Classnvarchar200
22HRSFI_D_VARPY_ERSuccessFactors: Variable Pay Log Table for Errors14MESSAGE_IDMessage Classnvarchar200
23ZRDB_DEL_DIR16.09.2009: Delete DIR77MESSAGE_IDNachrichtenklassenvarchar200
TOPArchiveLink
24TOA_L03SAP ArchiveLink: Log table11MESSAGE_IDVersion Number Componentnvarchar20
TOPAuthentication and SSO
25TRACE_MESSAGEContains trace messages2MESSAGE_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
TOPBackground RFC bgRFC
26BGRFC_I_DEST_ERRError Messages for bgRFC Destinations in Inbound Case3MESSAGE_IDMessage Classnvarchar200
27BGRFC_O_DEST_ERRError Messages for bgRFC Outbound Destinations3MESSAGE_IDMessage Classnvarchar200
28QRFC_I_ERR_STATEInbound qRFC: Unit Error State3MESSAGE_IDMessage Classnvarchar200
29QRFC_O_ERR_STATEOutbound qRFC: Unit Error State3MESSAGE_IDMessage Classnvarchar200
30TRFC_I_ERR_STATEInbound tRFC: Unit Error Status3MESSAGE_IDMessage Classnvarchar200
31TRFC_O_ERR_STATEOutbound tRFC: Unit Error State3MESSAGE_IDMessage Classnvarchar200
TOPClient-System Adapter
32MDMFDBEVENTMDM: Message inbound events2MESSAGE_IDUUID in character formnvarchar320
TOPCommunication Channel
33CRM_CCS_MESSAGECRM CMS Simulator - Message3MESSAGE_IDCharacter field, length 64nvarchar640
34ICI_CCS_MESSAGECCS Simulator - Message4MESSAGE_IDCCS CHAR32nvarchar320
TOPCommunication Services Mail, Fax, SMS, Telephony
35BCSD_ENVIDMapping Envelope ID - Request ID4MESSAGE_IDnvarchar3000
TOPDangerous Goods Management
36TDG75DG: Hide Messages when Writing Log2MESSAGE_IDMessage identificationnvarchar200
TOPData Replication Framework
37DRFD_OBJ_DEP_INFInfo on dependencies of serialization relevant objects6MESSAGE_IDMessage Numbernvarchar320
38DRFD_OBJ_PRC_STAruntime Info on processing of access and dependend objects8MESSAGE_IDMessage Numbernvarchar320
TOPFunds Management
39FMSPLIT_APROF_AActions in Rule-Based Account Distributions Action Profile5MESSAGE_IDMessage Classnvarchar200
TOPIntegration Engine
40SXMSMSGREFMessage Reference Storage2MESSAGE_IDXI: Message IDvarbinary160
TOPInternet Communication Framework
41ICFRECORDERStore ICF Documents (Related to Recorder Layer)2MESSAGE_IDUUID in Character Representation for ICF Recordernvarchar320
TOPLocalization
42J_1BNFE_INVALIDElectronic Nota Fiscal: Invalid Status Actions23MESSAGE_IDID of Messages in the NF-e Lognvarchar200
TOPMaterial Master
43TMGW3Change Restrictions for structured Materials7MESSAGE_IDMessage Classnvarchar200
TOPMobile Applications
44/ISDFPS/EHMSGERRError Messages2MESSAGE_IDMessage IDnvarchar320
45/ISDFPS/EHMSGHDRError Correction Framework2MESSAGE_IDMessage IDnvarchar320
46/ISDFPS/ERR_LISTMBO Message: Errors List7MESSAGE_IDMessage IDnvarchar320
47/ISDFPS/MSG_BODYData for Error/Conflict Messages3MESSAGE_IDGUID (32 Character)nvarchar320
48/ISDFPS/MSG_HDRCommunication Information for Error/Conflict Messages3MESSAGE_IDMessage IDnvarchar320
49/ISDFPS/RCR_LISTList of Messages: Receiver3MESSAGE_IDMessage IDnvarchar320
TOPPeople Centric UI Framework
50CRMC_ACC_RESULTResults of Automatic Accessibility Checks for PC UI4MESSAGE_IDMessage ID Accessibility Errornvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
51DFMCA_NOTE_ATTNote Attributes for Process Objects7MESSAGE_IDMessage Classnvarchar200
TOPSAP Business Workflow
52SWN_MSG2PARTWF Notif: Assign.Message Template Parts to Message Templates2MESSAGE_IDMessage Template IDnvarchar320
TOPSAP Healthcare - Industry-Specific Components for Hospitals
53NNL_CLASS_MESSMeldung Klassification Nachrichten6MESSAGE_IDNachrichtenklassenvarchar200
54NNL_CLASS_MESSLMeldung Klassification Nachrichten Log6MESSAGE_IDNachrichtenklassenvarchar200
TOPSupply Chain Management
55/SDF/EM_MSGMessages7MESSAGE_IDMessage Classnvarchar200
TOPVisual Business
56VBCD_MESSAGE_OBJMessage Objects4MESSAGE_IDObject Identifier (GUID 36)nvarchar360
57VBCD_MOVisual Business Message Objects3MESSAGE_IDObject Identifier (GUID 36)nvarchar360
TOPWeb Screen Tools - ABAP
58WDY_DEPR_OBJ_TXTWeb Dynpro: Deprecated Object Description6MESSAGE_IDAS400-DDIC: Output message ID in T100nvarchar200
59WDY_NEW_LS_OBJWeb Dynpro: New Lightspeed UI Objects6MESSAGE_IDAS400-DDIC: Output message ID in T100nvarchar200
TOPWeb Service and SOAP - ABAP
60SRT_CFG_LOG_ITEMSRT Logging: Item Table11MESSAGE_IDMessage identificationnvarchar200
61SRT_EO_ACCESSIDEnqueue possible parallel requests in EO handling2MESSAGE_IDMessage ID in SOAP Runtimevarbinary160
62SRT_MMASTERWS message (Master table)3MESSAGE_IDMessage ID in SOAP Runtimevarbinary160
63SRT_SOAM_CONNECTSOAManager Connectivity : Application data for distribution16MESSAGE_IDMessage Classnvarchar200
64SRT_UTIL_ERRLOGSRT Utilities: Error Log Data19MESSAGE_IDnvarchar320
65SRT_UTIL_LOGSRT Utilities: Error Log Data17MESSAGE_IDnvarchar320
66SRT_UTIL_TRCFUNCSRT Utilities: Functional Trace Data20MESSAGE_IDnvarchar320
67SRT_UTIL_TRCPERFSRT Utilities: Performance Trace Data17MESSAGE_IDnvarchar320
68SRT_UTIL_TRCPLOASRT Utilities: Payload Trace Data22MESSAGE_IDnvarchar320
TOPWorkforce Management Application
69WFA_CALCSTMSGCalculation Status Messages7MESSAGE_IDMessage Number for Calc Status Messagesnvarchar300
TOPWorkforce Management Core
70WFMCAS_CALCSTMSGCalculation Status Messages7MESSAGE_IDMessage Number for Calc Status Messagesnvarchar300
71WFMFC_OPTIMZLOGSOptimization Logs4MESSAGE_IDMessage Idnvarchar50