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

161 columns | Print definition?ERP 6.0  | MESSAGE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_ALRT_EXTExternal Address <-> Recipient8MESSAGEMessage Typenvarchar10
2/AIF/T_ALRT_ROLERole <-> Recipient6MESSAGEMessage Typenvarchar10
3/AIF/T_ALRT_USERUser <-> Recipient6MESSAGEMessage Typenvarchar10
4/DSCSAG/PR_DNCDNC - Protocol Table17MESSAGEChar255nvarchar2550
5/FLDQ/AD_ERRCUSTCustomer defined error messages4MESSAGEMessage to be logged in Error Lognvarchar2550
6/FLDQ/AD_ERRMAPTable to store error codes9MESSAGEMessage to be logged in Error Lognvarchar2550
7/FLDQ/AD_PERFTSTPerformance Test Time Stamps - Obsolete as of SP24MESSAGEMessage variable 01nvarchar500
8/GEOE/GISMSGMessage Table13MESSAGEMessage Textnvarchar1000
9/GEOE/REQ_LOGLogs3MESSAGEChar255nvarchar2550
10/IXOS/RSA_T_PROTTable: Protocol Table for Return Messages10MESSAGEMessage Textnvarchar2200
11/LOCSRM/SYS_MSGSystem messages in Live auction for Brazil PPS6MESSAGEChar255nvarchar2550
12/OPT/BAPIRET2Table to log ICC <-> SAP process errors8MESSAGEMessage Textnvarchar2200
13/ORS/EXCL_MESSTable of excluded messages in validation step4MESSAGEMessage Textnvarchar2200
14/SAPPSSRM/SP_LOGSelective Release Batch Job Log Table7MESSAGECharacter 100nvarchar1000
15/SAPSRM/APPLTERRStores Applet Exceptions14MESSAGEntext10737418230
16/SLCE/CACHE_KBKnowledge Bases Cached in EJB-IPC5MESSAGEMessagentext10737418230
17/SLOAP/GEN_STATEState of output generation8MESSAGEError messagenvarchar2550
18/SYCLO/PSH00Push Scenario Definition13MESSAGESMS Messagenvarchar1400
19BBPC_TEXT_XMLXML Communication of Texts3MESSAGEBBP XML Message Namenvarchar400
20BBPC_XML_MSGBBP XML Messages Customizing1MESSAGEBBP XML Message Namenvarchar400
21BBPD_LA_CHATChat6MESSAGEChat messagentext10737418230
22BBPD_LA_MESSAGEMessage11MESSAGEMessage Textnvarchar2200
23BBP_WLRA_CLUSTERTable for Data Cluster Definitions in Workload11MESSAGEMessage Textnvarchar2200
24CCGLT_PRTREQ_DETEHS: Print Request Spool Messages8MESSAGEPrinter Spool: Print Request Statusnvarchar2550
25DOCR_LOG_HEADERDBOSC-CR: Log Header11MESSAGEnvarchar2550
26DOCR_LOG_RECORDDBOSC-CR: Log Records13MESSAGEnvarchar2550
27DOCR_TRC_RECORDDBOSC-CR: Trace Records20MESSAGEnvarchar2550
28EHHSSD_CINSP_CNControl Inspection - Note on Control11MESSAGERemark from Control Inspectorntext10737418230
29EPIC_DUM_SIGNEPIC Dummy Bank Signature3MESSAGEntext10737418230
30GHO_ALERTStore Network Alerts13MESSAGEMessage Textnvarchar2200
31IUUC_DD_SYNC_SQLSystem synchronization: SQL-statements to adjust DB object7MESSAGEMessage Textnvarchar2200
32LXE_RLTP_LOGRemote Copy Registration21MESSAGETextntext10737418230
33P01RBM_TRINZfA: Manage PI Receipt of Notification6MESSAGERBM: MQ Messagentext10737418230
34P01ZFA_TRINZfA: Manage PI Receipt of Notification6MESSAGEZfA: MQ Messagentext10737418230
35PATTPCALLInformationen zum letzten tp Aufruf8MESSAGENachrichtentextnvarchar730
36PYC_D_PY_MSGPYC: payroll message37MESSAGELine Contains Messagenvarchar10
37PYC_D_PY_MSG_JOBPYC: payroll message20MESSAGELine Contains Messagenvarchar10
38STODOINFInformationen zu TODO Meldungen15MESSAGEText der TodoMeldungntext10737418230
39T5VF0Altinn Communication Framework - Authentication storage8MESSAGEntext10737418230
40TCY40Control tables for flow control4MESSAGEMessage in the context of a flow controlnvarchar80
41TCY42Actions in flow control6MESSAGEMessage in the context of a flow controlnvarchar80
42TCY43Messages for flow control2MESSAGEMessage in the context of a flow controlnvarchar80
43TCY43TTexts for messages for flow control3MESSAGEMessage in the context of a flow controlnvarchar80
44TMAS_OLA_D_ERResults of failed analyses13MESSAGEStringntext10737418230
45TRF_DOC_ERR_MSGFiori Transfer Stock Document Error Messages7MESSAGEMessage Textnvarchar2200
46ZRDB_DEL_DIR16.09.2009: Delete DIR53MESSAGEMeldungstextnvarchar2200
47ZSWM01Results table for workflow mail demo3MESSAGEText (80 Characters)nvarchar800
48ZTARGET_PARTNERGSystem Landscapes: Header Data17MESSAGEnvarchar1200
49ZXMII_M_PROCMITProcess message texts4MESSAGELong textnvarchar1280
50/BOBF/FRW_ADDONRuntime addons for BOPF interfaces9MESSAGEAddon access (yes/no/configurable)nvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
51DCERRLISTDD: Tabelle für die Speicherung fehlerhafter DD-Objekte7MESSAGENachrichtnvarchar50
TOPAMI Event Management
52EFDT_EXPR004FDT: Expression - No Action7MESSAGEMessage Textnvarchar2200
53EFDT_EXPR004AFDT: Expression - No Action7MESSAGEMessage Textnvarchar2200
54EFDT_EXPR004SFDT: Expression - No Action6MESSAGEMessage Textnvarchar2200
55EFDT_EXPR004TFDT: Expression - No Action6MESSAGEMessage Textnvarchar2200
56TEAMI_EM_EVTMSGMessages for Smart Meter Events12MESSAGEText for translationnvarchar2000
TOPArchiveLink
57TOACBArchiveLink Asynchronous CFBC Responses7MESSAGEChar255nvarchar2550
58TOAR7SAP ArchiveLink: Request table (asynchronous storage)2MESSAGESAP ArchiveLink name of function to be callednvarchar40
59TOA_L03SAP ArchiveLink: Log table8MESSAGEMessage Numbernvarchar30
TOPAuthentication and SSO
60SAML2_ARTIFACTStorage Table for SMAL2 Artifacts8MESSAGEXML Fragmentimage21474836470
61TRACE_MESSAGEContains trace messages8MESSAGEntext10737418230
TOPBackground RFC bgRFC
62BGRFC_IUNIT_HISTHistory of Inbound bgRFC Unit13MESSAGEBackground RFC Messagenvarchar2550
63BGRFC_I_DEST_ERRError Messages for bgRFC Destinations in Inbound Case2MESSAGEBackground RFC Messagenvarchar2550
64BGRFC_OUNIT_HISTHistory of Outbound bgRFC Unit13MESSAGEBackground RFC Messagenvarchar2550
65BGRFC_O_DEST_ERRError Messages for bgRFC Outbound Destinations2MESSAGEBackground RFC Messagenvarchar2550
66QRFC_I_ERR_STATEInbound qRFC: Unit Error State2MESSAGEBackground RFC Messagenvarchar2550
67QRFC_O_ERR_STATEOutbound qRFC: Unit Error State2MESSAGEBackground RFC Messagenvarchar2550
68TRFC_I_ERR_STATEInbound tRFC: Unit Error Status2MESSAGEBackground RFC Messagenvarchar2550
69TRFC_O_ERR_STATEOutbound tRFC: Unit Error State2MESSAGEBackground RFC Messagenvarchar2550
TOPBasic Functions
70TTXUExternal tax interface: Audit file update information14MESSAGEText (80 Characters)nvarchar800
TOPBI Content Analyzer
71RSCONTENTCHECK_EExceptions Table for Content Checks6MESSAGEMessage Number or Comment to explain the exceptionnvarchar500
TOPBusiness Application Support
72CNVWDMCNV watchdog: sent messages4MESSAGEMessage textnvarchar1600
TOPBusiness Planning and Simulation
73UPWB_DEBUG_LOGLog DB for Debugging at Runtime4MESSAGECharacter 100nvarchar1000
TOPChange Transport System
74TPSTATStatus of tp Calls15MESSAGEMessage Textnvarchar730
TOPClaims Management
75ICL_INVSTG_LOGClaim Investigation Messages11MESSAGEClaim Investigation Messagentext10737418230
76ICL_REGREP_LOGRegulatory Reporting Log11MESSAGERegulatory Reporting Response Messagentext10737418230
77TICL039Claims Management - Assignment Activity to Task3MESSAGEActivity Management: Tasknvarchar60
78TICL044Claims Management Activity or Prompting Message2MESSAGETask / Log Entrynvarchar60
79TICL044TClaims Management: Task/ Message Text3MESSAGETask / Log Entrynvarchar60
80TICL085Claims Management Client3MESSAGEResubmission Tasknvarchar60
81TICL950Claim Bundle: Task or Prompting Message3MESSAGEClaim Bundle: Task/Log Entrynvarchar60
82TICL950TClaim Bundle Message Text4MESSAGEClaim Bundle: Task/Log Entrynvarchar60
83TICL952Claim Bundle - Assignment of Task -> Activity4MESSAGEClaim Bundle: Task in the Sense of Activity Managementnvarchar60
TOPClient-System Adapter
84MDMFDBPRKeys and other attributes of feedback messages7MESSAGEMessage Textnvarchar2200
TOPClinical System
85N2COMM_LOGDocuments Received in Temporary Storage20MESSAGEimage21474836470
TOPCollaboration Folders
86CFX_APPL_LOGUsage log6MESSAGECharacter String for Collaboration Foldersntext10737418230
TOPCollectionsDisbursements
87ITAGCYCONTCLERRAgency Collections: Error when Closing Container4MESSAGEnvarchar2200
TOPComplaints Processing
88CMP_VBFS_EXTStatus Messages from Mass Complaints Processing9MESSAGEMessage Textnvarchar2200
TOPContent Activation
89BSANLY_BCACT_LOGActivation Log for Content Bundles10MESSAGEMessage Textnvarchar2200
TOPContract Accounts Receivable and Payable
90ECS_MESG_INDECS Mandate: Maintenance of Customizing messages4MESSAGEECS Mandate: Messagenvarchar500
TOPCross-Application Components
91FRE_UI_MSGF&R CON R/3 - Exception Messages for User Interface9MESSAGEMessage Textnvarchar2200
TOPData Staging
92RSPCCOMMANDLOGSystem Command Execution Logs (Process Chains)5MESSAGELog message from external programnvarchar1280
TOPDatabase Interface, Database Platforms
93DBA_TEST_RESULTSDBA-TST: Test Results10MESSAGEntext10737418230
TOPDB2 for OS39
94DB2CCMO_ERRORDSNACCMO: History of error info with length > 255 CHAR4MESSAGEDSNACCMO: Error informationnvarchar13310
TOPDB2 Universal Database for UNIX NT
95DB6PM_DLKDB6: Table to Store the Output of Detected Deadlocks3MESSAGELog message from external programnvarchar1280
TOPDocument Management Framework
96SKWF_LOGLogging Table7MESSAGE128 characternvarchar1280
TOPeXternal Management Interface Framework
97TXMILOGLog Information on Actions of External Management Tools12MESSAGEXMI logging: Comment on XMI actionnvarchar500
TOPFinancial Supply Chain Management
98BNK_BTCH_STPAYLDBatch status payload4MESSAGEMessage payloadimage21474836470
TOPFinancials Basis
99UBC_TB_INVHMESBill: Messages from Inbound Processing5MESSAGEMessage Textnvarchar2200
100UGMD_MESGFinBasis: Suppression of Repeated Message Displays4MESSAGEObsolete Data Elementnvarchar600
TOPFunds Management
101FUNDMSGFund message maintenance6MESSAGEFund message severitynvarchar10
TOPGoods Receipt Process
102BORGR_PROFILEGoods Receipt Automotive: Profiles23MESSAGESettings for Message Displaynvarchar10
TOPGRC Process Control Plug-in
103/GRCPI/GRIAMSGAM - Execution Message (Temp Storage during execution)7MESSAGEMessage Textnvarchar2200
TOPHR Administrative Services
104T5ASRPROCCHKAssignment of Collision Groupings to Processes6MESSAGEMessage for Collision Check at Process Startnvarchar10
TOPIndustry Solution Catch Weight Management
105CON_FIN_WQ_MSGMessages on the Transactions in the Work Queue11MESSAGEMessage Textnvarchar2200
TOPIntegrated Product and Process Engineering
106PPECIF_LOGOBJiPPE/CIF: Different Objects13MESSAGEMessage Textnvarchar2200
TOPliveCache Applications
107/SAPAPO/LCLOGLOGLogging of liveCache logging7MESSAGEMessagenvarchar30
108LCA_WARNINGSWarnings in the "liveCache Applications" Area14MESSAGEText (80 Characters)nvarchar800
TOPLocalization
109J_1ACI_MSG_RATESAssignment of output messages to Installment rate2MESSAGEOutput Typenvarchar40
110J_1BNFFTXNota Fiscal header message5MESSAGEMessagenvarchar720
TOPMaterial Master
111WGDS_CONF_MSGData pool item confirmation message6MESSAGEMessage IDnvarchar320
112WGDS_LOG_SUBCWGDS Log Subscription5MESSAGESubscription Log Messagenvarchar2500
TOPMicrosoft SQL Server
113MSSDEADLCKDatabase Deadlock Information for MSSQL Server13MESSAGEDeadlock messagenvarchar2550
TOPMobile Applications
114/ISDFPS/EHMSGERRError Messages7MESSAGEMessage Textnvarchar2200
115/ISDFPS/ERR_LISTMBO Message: Errors List17MESSAGEMessage Textnvarchar2200
TOPNorway
116T5VBPAltinn Integration Status Table15MESSAGEText, 255 Charactersnvarchar2550
117T5VTPAltinn authentication response8MESSAGEChar255nvarchar2550
TOPOnline Correction Support Support Package and Add-On Tools
118PAT01Patch Status6MESSAGEMessage when a termination occursnvarchar730
119PAT09Patch History6MESSAGEMessage when a termination occursnvarchar730
120PATCHECK(Application-Specific) Checks in SPAM/SAINT6MESSAGEMessage when a termination occursnvarchar730
121PATSTOPBuffer of Breakpoints During Import with SPAM/SAINT5MESSAGEMessage when a termination occursnvarchar730
TOPPatient Accounting
122NCOP_MESSIS-H: Copayment - Messages for Posting Back with Partial Pyt15MESSAGEMessage Textnvarchar2200
TOPPension fund Netherlands
123T5NK9Kasstroom overzicht - log6MESSAGEMessage-tekstnvarchar1000
TOPPeople Centric UI Framework
124CRMC_ACC_RESULTResults of Automatic Accessibility Checks for PC UI5MESSAGEAccessibility Errornvarchar1500
TOPPerformance Monitors TCC
125GVD_DATAGUARD_STCopy of GV$DATAGUARD_STATUS11MESSAGEOracle monitoring: dataguard messagenvarchar2550
TOPProduct Safety
126CCRCC_SDCONDTABEHS: Condition Table Locked in SD by Notification Check4MESSAGESystem Message If Notification Check Failsnvarchar10
TOPProduction and Revenue Accounting
127OIUPR_API_RFCRFC transmission status14MESSAGEMessage Textnvarchar2200
128OIUT2_INT_MESSGObsolete: Ownership Interface Messages (Application/Tech.)9MESSAGEMessage Textnvarchar2200
129OIUXI_INT_MESSGOwnership Interface Messages (Application/Technical)9MESSAGEMessage Textnvarchar2200
TOPRegulatory reporting for insurance companies
130TISSR_TP_PROTMWVZuordnung Nachrichten zu Mw-Variante für Prot. Kennz.änd.7MESSAGENachrichtennummernvarchar30
TOPSAP Business Workflow
131SWWLOGHISTWorkflow Runtime: History of a Work Item11MESSAGEMessage numbernvarchar30
132SWWWIRETWorkflow Runtime: Return Values of Method Call7MESSAGEMessage numbernvarchar30
133SWZAIRETReturn Values of Method Call of a WQ Line9MESSAGEMessage numbernvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
134NNL_CLASS_MESSMeldung Klassification Nachrichten7MESSAGEMeldungstextnvarchar2200
135NNL_CLASS_MESSLMeldung Klassification Nachrichten Log7MESSAGEMeldungstextnvarchar2200
TOPSAP Multiresource Scheduling
136/MRSS/D_SRVA_MESService Area Text Messages4MESSAGEMessagenvarchar720
TOPSAP NetWeaver Mobile - Use subcomponents
137MEORDERSMobile Engine: Online Offline Demo8MESSAGECharacter 100nvarchar1000
138MISYNMSGMI System News Messages3MESSAGECharacterfield 200 with lowercasenvarchar2000
TOPSpecification 2
139SPCFILESPEC 2000 messages & fields18MESSAGEMessage Textnvarchar730
140SPCMFILESPEC 2000 AEC messages & fields19MESSAGEMessage Textnvarchar730
TOPStandardized Key Mapping
141UKMPI_MESSAGEAssignments of Mapping to Message3MESSAGEMessage Namenvarchar1200
TOPSupply Chain Management
142/SDF/EM_MSGMessages9MESSAGEMessage Textnvarchar2200
TOPSyntax, Compiler, Runtime
143ICONIcons table6MESSAGEIcon suitable for messagenvarchar10
144TPDAPI_TESTTest von Listener / Attach9MESSAGEnvarchar600
TOPTask Resource Management
145LRMSGResources messages5MESSAGELog Linenvarchar2810
TOPTranslation Tools
146LXE_KWT_COMP_LOGTTX copy log8MESSAGE255 Charactersnvarchar2550
147LXE_KWT_COPY_LOGTTX copy log (obsolete)7MESSAGE255 Charactersnvarchar2550
TOPTransport Organizer
148VRSTC_RESULTSSystem Comparison: Results from Comparison of Table Contents11MESSAGEntext10737418230
TOPTravel Expenses
149PTRV_DOC_MESSTransfer Travel -> FI/CO: CO Replacements of TRV Receipt9MESSAGEMessage Textnvarchar2200
150PTRV_RPRPOSTDLog of Posting Program RPRPOSTD9MESSAGEMessage Textnvarchar2200
TOPUI Runtime Environment
151BSPWD_MSG_FLDMessage-Field Mapping4MESSAGEMessage Textnvarchar2200
152BSPWD_MSG_FLD_CMessage-Field Mapping5MESSAGEMessage Textnvarchar2200
TOPUser Administration
153SMUM_ERDECSMUM error description2MESSAGEMessage Textnvarchar2200
TOPUser Interface
154WCF_UST_DRAFTDraft shared Items6MESSAGESharing Messagentext10737418230
155WCF_UST_SHAREShared Items6MESSAGESharing Messagentext10737418230
TOPWeb Dynpro ABAP
156WDG_GEN_LOGWeb Dynpro Generation Log9MESSAGEnvarchar2000
TOPWeb Service and SOAP - ABAP
157SRT_SEQ_HDR_STATsoap_sequence header and state info33MESSAGECharacter field, length 32nvarchar320
158SRT_SEQ_MSG_QUEBuffer message id#s that are queued but not processed4MESSAGECharacter field, length 32nvarchar320
159SRT_SEQ_RTRYCONTsoap_sequence header information9MESSAGECharacter field, length 32nvarchar320
TOPWorkbench Tools Editors, Painters, Modelers
160ADT_EXCEPTIONLOGURI mapping exceptions protocoll6MESSAGEntext10737418230
161MIME_LOGMIME Repository: Logging Table9MESSAGE128 characternvarchar1280