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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

187 columns | Print definition?ERP 6.0  | MSGNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPSP_TIL Localization Cash-Statistic Docs' Errors-Incoming Payment8MSGNRBatch input message numbernvarchar30
2/MRSS/C_BUND_MSGOverride Message Type for Bundling Messages3MSGNRMessage number for Bundlingnvarchar30
3/OPT/DT_BP_MSGBest Practice Framework - Messages4MSGNRMessage numbernvarchar30
4/OPT/VIM_MSG_TTable to store messages7MSGNRBatch input message numbernvarchar30
5/OPT/VIM_Y_LOGDYear End log details13MSGNRBatch input message numbernvarchar30
6/OPT/WI_Y_LOGDWorkflow Message Table7MSGNRMessage Numbernvarchar30
7/OPT/X015BDC Success Message Configuration5MSGNRMessage numbernvarchar30
8/OPT/X151OPENTEXT: Approval Diagnostic Log Data13MSGNRBatch input message numbernvarchar30
9/OPT/X178Message Code for each transaction that carries the object3MSGNRBatch input message numbernvarchar30
10/OPT/Y015BDC Success Message Configuration5MSGNRMessage numbernvarchar30
11/OPT/Y151OPENTEXT: Approval Diagnostic Log Data13MSGNRBatch input message numbernvarchar30
12/OPT/Y178Message Code for each transaction that carries the object3MSGNRBatch input message numbernvarchar30
13/OPT/Z015BDC Success Message Configuration5MSGNRMessage numbernvarchar30
14/OPT/Z151OPENTEXT: Approval Diagnostic Log Data13MSGNRBatch input message numbernvarchar30
15/OPT/Z178Message Code for each transaction that carries the object3MSGNRBatch input message numbernvarchar30
16/ORS/DIAG_LOGSOPENTEXT: Approval Diagnostic Log Data13MSGNRBatch input message numbernvarchar30
17/PTGWFI/M_YEND_LYear end program log for optura po inv year end process15MSGNRBatch input message numbernvarchar30
18/SAPF15/TRMICONF15 Rückmeldung Symbole6MSGNRNachrichtennummernvarchar30
19/SAPF15/_HKR4_FCF15-Schnittstelle: Texte zu HKR4-Fehlercodes5MSGNRNachrichtennummernvarchar30
20/SOMO/JOBMON04Job Metric definition table19MSGNRMessage numbernvarchar30
21BBPC_EVENT_MESSCustomizing Table for Assignment of Events to Messages3MSGNRMessage numbernvarchar30
22BBPC_E_HIGHLIGHTC Table for Assignment of Errors to Structure & Fields3MSGNRMessage numbernvarchar30
23BBPC_PDMSGBBP: Customizeable Messages2MSGNRMessage numbernvarchar30
24BBPC_PDMSG_CUSBBP: Settings for Customizeable Messages3MSGNRMessage numbernvarchar30
25BBPC_PDMSG_XMLBBP: Settings for XML Message Control3MSGNRMessage numbernvarchar30
26CNVA_MD_CHK_MAPTable for module - check class mapping8MSGNRMessage numbernvarchar30
27CNVCMIS_A_1_MESSMessages6MSGNRMessage numbernvarchar30
28MHNEXException List for Dunning Run9MSGNRMessage numbernvarchar30
29NWS_EXT_PROTNMessage Log, R/3 Extractor12MSGNRMessage numbernvarchar30
30PATTPIMPLOGtp Importprotokollzeilen8MSGNRNachrichtennummernvarchar30
31PYC_D_TXT_MESSAGPYC: TEXT FROM MESSAGE CLASS5MSGNRMessage numbernvarchar30
32PYD_D_ALPayroll Data Source Framework: Action Log21MSGNRMessage numbernvarchar30
33PYD_D_ALIPayroll Data Source Framework: Action Log Item13MSGNRMessage numbernvarchar30
34T100CMessage Control by User3MSGNRMessage numbernvarchar30
35T100SConfigurable system messages2MSGNRMessage numbernvarchar30
36T439FHandling of planning flag at abnormal termination2MSGNRMessage numbernvarchar30
37T440FException messages for the forecast2MSGNRMessage numbernvarchar30
38T440ZAllocate error -> error class in the forecast2MSGNRMessage numbernvarchar30
39T5UPBSTC21Certificate: Renewal Code Table3MSGNRMessage Number for Certificate Renewal Codenvarchar30
40T77WWW_CLERRSTRTable to Store Error Information4MSGNRMessage Numbernvarchar30
41T77WWW_TEAERMessages (Success, Error, Warning)5MSGNRMessage Numbernvarchar30
42TCA10Task lists: Messages depending on the task list type5MSGNRMessage numbernvarchar30
43TVGMSView Control: Error Messages2MSGNRMessage numbernvarchar30
44HRT1749Table Section for Infotype 17495MSGNRNumber of Message in Message Classnvarchar30
45T7PIQHSATTRStatus Attributes6MSGNRMessage numbernvarchar30
46T7PIQHSCHECKAssignment of Status Indicators to Callup Points8MSGNRMessage numbernvarchar30
47T7PIQPP_ERR_CONFPost Processing : Error Categorization3MSGNRMessage numbernvarchar30
48T7PIQSYSCHECKTPSystem Status to Callup Point and Activity Assignments6MSGNRMessage numbernvarchar30
49T7PIQT100SOverridable Messages with Associated Message Class2MSGNRMessage numbernvarchar30
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
50CRMRDT100Texts of Messages from T100 (OBSOLETE)5MSGNRMessage numbernvarchar30
51CRM_CATMCATT: Log for model and function data25MSGNRCATT: Message Numbernvarchar30
52CRM_CATT_MSGCATT Messages (prepared for Conversion in CHECKMAN)10MSGNRBatch input message numbernvarchar30
53CRM_ECATT_MSGeCATT Messages (Prepared for Conversion in CHECKMAN)9MSGNRBatch input message numbernvarchar30
TOPAccounting Interface
54GLE_ECS_MSG_ERRECS: Assignment of Error Category to RWIN Messages3MSGNRMessage numbernvarchar30
55GLE_ERR_MSGECS: RWIN Messages3MSGNRMessage numbernvarchar30
TOPAccounts Payable
56/PTGWFI/F_SMIMSGMessage Code for each transaction that carries the object3MSGNRBatch input message numbernvarchar30
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
57CD0F4TESTTabelle mit Feldern mit verschiedenen Eingabehilfen16MSGNRNachrichtennummernvarchar30
58DBDCGENTBDD: Persisting Activating Ojects in Mass Activation15MSGNRMessage numbernvarchar30
59DD08LR/3 DD: relationship definitions13MSGNRMessage numbernvarchar30
60T100Messages3MSGNRMessage numbernvarchar30
61T100ULast person to change messages2MSGNRMessage numbernvarchar30
62T100XError Messages: Supplements2MSGNRMessage numbernvarchar30
TOPAllocation
63T160ATMessage Control Allocation Table4MSGNRMessage numbernvarchar30
TOPApplication Framework
64MDG_TMSGAPPL01Deviating Message Type (Desired Error Severity) for Appl.4MSGNRMessage numbernvarchar30
65MDG_TMSGAPPL0SMessage Type per Message Handler Application3MSGNRMessage numbernvarchar30
TOPArchiveLink
66TOACBArchiveLink Asynchronous CFBC Responses9MSGNRMessage Numbernvarchar30
67TOACRAsynchronous ArchiveLink Requests22MSGNRMessage Numbernvarchar30
TOPAssortment Maintenance
68TWPDOAssignment of retail message to PD org. object3MSGNRMessage numbernvarchar30
69TWSZSubsequent processing for errors in material discontinuation2MSGNRMessage numbernvarchar30
TOPBasic Data
70NC301EIS-HCM: EDI Error Messages6MSGNRMessage numbernvarchar30
71NC301FIS-H: Obsolete!! (Error Table for EDI Error Messages)14MSGNRMessage numbernvarchar30
72NC301IIS-H: Error Table for EDI Error Messages to be Reported11MSGNRMessage numbernvarchar30
73TNC301GCIS-H EDI Procedure Checks3MSGNRMessage numbernvarchar30
TOPBasic Functions
74T084Incorrect assets8MSGNRMessage numbernvarchar30
75WTMIGMESSMessages Logged for Withholding Tax Changeover7MSGNRMessage numbernvarchar30
76WTMIGMESSEXCWithholding Tax Changeover: Alternative Message Types3MSGNRMessage numbernvarchar30
TOPBatches
77T160MVALMessage category restriction for T160M2MSGNRMessage numbernvarchar30
TOPBusiness Configuration Tools Runtime
78SC2_AP_IDE_POCOLCheck and Activation Log Repository8MSGNRMessage numbernvarchar30
79SC2_IDE_PROTOCOLCheck and Activation Log Repository8MSGNRMessage numbernvarchar30
TOPBusiness Object Builder
80SWOTDQVerb Parameters, Exceptions18MSGNRMessage numbernvarchar30
81SWOTLQRuntime Table Parameters, Exceptions10MSGNRMessage numbernvarchar30
TOPCATT Computer Aided Test Tool
82CATDBCATT - Test object transaction data6MSGNRCATT: Message Numbernvarchar30
83CATMCATT: Log for model and function data24MSGNRCATT: Message Numbernvarchar30
TOPClient Copy
84CCSELTABParallel Client Copy Worklist: Objects15MSGNRMessage numbernvarchar30
TOPClientServer Technology
85VBERRORUpdate error information7MSGNRMessage numbernvarchar30
TOPCollectionsDisbursements
86VVKKERRIncorrect Structure and Related Error Message(s)9MSGNRMessage numbernvarchar30
TOPConditions
87B032Application Area: Output Number5MSGNRMessage numbernvarchar30
TOPConfirmations
88TAFWDCORU: Messages that are not interpreted as errors3MSGNRMessage numbernvarchar30
TOPConsumption-Based Planning See Also PP-MRP
89DBPROFForecast Error with MRP Areas6MSGNRMessage numbernvarchar30
TOPContract Billing
90BREBI_BILLP_T001Error Code Table4MSGNRMessage numbernvarchar30
91BREBI_BILLP_T005Auto-Patch Configuration3MSGNRMessage numbernvarchar30
TOPCost Center Accounting
92T811MESSAllocations: Message Control4MSGNRMessage numbernvarchar30
TOPCross-Application Components
93/OPT/CP_T905BDC Success Message Configuration5MSGNRMessage numbernvarchar30
94/PTGWFI/F_YEND_LYear end program log for optura non po year end process15MSGNRBatch input message numbernvarchar30
95FRE_UI_MSGF&R CON R/3 - Exception Messages for User Interface8MSGNRSystem Message Numbernvarchar30
TOPCross-Application Mass Maintenance
96MASSMSGCFGUser-Specific Message Configuration4MSGNRMessage numbernvarchar30
TOPCustomer Interaction Center
97COMAPOnline BDC output mapping from message table to container10MSGNRBatch input message numbernvarchar30
TOPDangerous Goods Management
98THM095DG: Determination of Response for Mixed Loading Checks5MSGNRMessage numbernvarchar30
TOPData Collection
99T242PWindow management7MSGNRMessage numbernvarchar30
TOPData Quality
100MDG_SDQ_MSG_UIDecision table for Third Party WD component implementations3MSGNRMessage numbernvarchar30
TOPData Transfer
101KCD_PMDELExternal data transfer: delete log messages3MSGNRMessage numbernvarchar30
TOPeCATT Extended Computer Aided Test Tool
102ECLOG_FAIL_MSGGeneral Message Parts in FAILURE Object9MSGNRMessage Number such as BDC_MNR Char 3nvarchar30
103ECLOG_SPOCCustom Table to Display Spool Requests from the Log2MSGNRMessage numbernvarchar30
104ECMSG_COLLCollecting Messages for eCATT SAPGUI9MSGNRBatch input message numbernvarchar30
105ECVO_BUS_MSGeCATT Table for Validation Object Business Messages5MSGNRMessage numbernvarchar30
TOPElectronic Data Interchange
106WFMCMSGENQSpecial Handling for System Messages4MSGNRMessage numbernvarchar30
TOPEnd User Technology
107RSZWMDPARAMCONSRBW Web Metadata: Parameter constraints15MSGNRMessage numbernvarchar30
TOPFinancial Accounting
108/OPT/VIM_1BDCLOGBDC Log13MSGNRBatch input message numbernvarchar30
TOPForecast
109PROFForecast Errors6MSGNRMessage numbernvarchar30
TOPFunds Management
110FMLGD_H_MSGNRMessage Control7MSGNRSystem Message Numbernvarchar30
TOPGeneral Application Functions
111SDMONICHARKey Figures for SD Application Monitor4MSGNRMessage numbernvarchar30
TOPGeneral Ledger Accounting
112FAGL_VAL_LOGValidation of Document Splitting: Log7MSGNRMessage Numbernvarchar30
TOPIncentive and Commission Management ICM
113CACS_ARCHDENYReasons for Rejecting Archiving6MSGNRMessage Numbernvarchar30
114CACS_PPO_ERRCATAssignment of error category4MSGNRMessage Numbernvarchar30
115CRD_PPO_ERRCATAssign Messages for Error Category from PPO4MSGNRMessage Numbernvarchar30
TOPInformation System
116VTIS_FIELDSTIS: Renaming of Fields9MSGNRMessage numbernvarchar30
TOPIntegration Customer Relationship Management
117ECRM_REPL_DLAYTMessage Table for Delayed Restart in IS-U Error Monitor3MSGNRMessage numbernvarchar30
TOPInventory Management
118T159FMMIM: Error Messages Resulting From Blocked Objects2MSGNRMessage numbernvarchar30
TOPKANBAN
119PKECError Log for Kanban Calculation6MSGNRMessage numbernvarchar30
120PKEKError Log for Kanban (Event-Driven KANBAN)9MSGNRMessage numbernvarchar30
121PKERError Log of the Kanban Containers8MSGNRMessage numbernvarchar30
122TPKALAlerts in Kanban4MSGNRNachrichtennummernvarchar30
123TPKERAlternative Error Handling in the Kanban Process5MSGNRMessage numbernvarchar30
TOPLease Accounting
124FIEH_STATUSObject Status for Restart Exception Handling10MSGNRMessage numbernvarchar30
125TFIEH_GF_001Handling Methods5MSGNRMessage numbernvarchar30
TOPLocalization
126J_1IMESGMessage Control3MSGNRMessage numbernvarchar30
127J_3RTSETMESSMessage type setting3MSGNRMessage numbernvarchar30
TOPMaintenance Orders
128/MRSS/C_ALERTSAssignment of Alert Types and Messages4MSGNRMessage numbernvarchar30
129/MRSS/C_OPT_MSGCustomizing for individual error level of optimizer messages3MSGNRMessage numbernvarchar30
130/MRSS/C_SGE_CDCollision definition9MSGNRMessage numbernvarchar30
131/MRSS/D_ALERTSAlerts4MSGNRMessage Numbernvarchar30
TOPMaster Data
132MDKPHeader Data for MRP Document56MSGNRMessage numbernvarchar30
133MDKPDBHeader Data for MRP Document57MSGNRMessage numbernvarchar30
TOPMaterial Master
134WRF_DISCONT_ERRError Log and Valuation Levels - Seas. Proc. Discontinuation20MSGNRMessage numbernvarchar30
TOPMaterials Management
135BBPD_CTR_IDOCREFReference of contract number for Create Idocs8MSGNRMessage numbernvarchar30
TOPMDG for Financials
136USMDZ7MSGCTRLCControl of Message Number for Validation4MSGNRMessage numbernvarchar30
137USMDZ7MTYCTRLCControl of Message Type for Check Level for Validation3MSGNRMessage numbernvarchar30
TOPMedia Product Sales and Distribution
138TJKSDORDERSTMSGIS-M: Set Status3MSGNRMessage numbernvarchar30
139TJKSDRETURNMSGIS-M: Set Alert Category for Messages3MSGNRMessage numbernvarchar30
TOPMenu Painter
140RSMPCHECKGUI test classifications4MSGNRMessage numbernvarchar30
TOPMobile Applications
141/ISDFPS/EHCUSMSGCustomer Settings for Mobile Error Messages3MSGNRMessage Numbernvarchar30
TOPMonitoring
142SCSM_CHECK_LOGLog for Consistency Check7MSGNRMessage numbernvarchar30
TOPMonitors for Automotive
143ESDGRPDI 3.0 ESD Maintain Message Groups4MSGNRMessage numbernvarchar30
TOPMusing Tools
144WDKTOOLMSGRESMessage Resolving2MSGNRMessage numbernvarchar30
TOPOnline Correction Support Support Package and Add-On Tools
145PATLOGLogging Table for Transaction SPAM/SAINT8MSGNRMessage numbernvarchar30
146PATLOG3New Logging Table for TA SPAM/SAINT11MSGNRMessage numbernvarchar30
TOPOrganizational Management
147T7791Assignment to SAP Organizational Object Type10MSGNRMessage numbernvarchar30
TOPPatient Accounting
148NBDTEIS-H: BDT cases - status items7MSGNRMessage numbernvarchar30
149TN21MIS-H: Customer-Specific Message Control5MSGNRMessage numbernvarchar30
TOPPatient Management
150TN21LIS-H: SAP Message Control3MSGNRMessage numbernvarchar30
TOPPegging, Grouping, and Distribution
151DIS_RUNPROFMSGDistribution: Distribution run profile messages4MSGNRMessage numbernvarchar30
152GPD_TARCH_CUST_MGPD Archiving Customizing - Messages2MSGNRMessage numbernvarchar30
153PEG_RUNPROFMSGPegging: Pegging run profile messages4MSGNRMessage numbernvarchar30
TOPPeriodical Sales and Distribution
154TJ181IS-M: GUI Status Control for Function Code Exclusion7MSGNRMessage Numbernvarchar30
155TJY21IS-M/SD: Output (Notes) for a Function4MSGNRMessage numbernvarchar30
TOPPOS Interface
156WPLSTPOS interface: processing log4MSGNRMessage numbernvarchar30
TOPProduct Cost Planning
157CMFPStorage Structure for Errors Collected7MSGNRMessage numbernvarchar30
158TCK18Deactivating Functions in Screen Sequence Control6MSGNRMessage numbernvarchar30
159TCMF1Assignment: Area of Responsibility <-> Message3MSGNRMessage numbernvarchar30
160TCMF7Breakpoints4MSGNRMessage numbernvarchar30
161TCMF9Minimum Message Type (SAP)3MSGNRMessage numbernvarchar30
162TCMFAUser-Defined Messages5MSGNRMessage numbernvarchar30
TOPProfitability Analysis
163TKEBO_PROT_MSGPCM Model Log Messages4MSGNRCount parametersnvarchar40
TOPPurchasing
164T160MMessage Control: Purchasing (System Messages)4MSGNRMessage numbernvarchar30
TOPReal Estate Management
165VIAK12Acct settlement error log11MSGNRMessage numbernvarchar80
TOPRecycling Administration Core Functions
166J_7LBDCMSGREA Conditions: Error Messages BDC Condition Adjustment33MSGNRBatch input message numbernvarchar30
TOPRemaining Beverage - Obsolete Objects
167/BEV1/RBPAIntermediate Table (Material-Specific Contrib. Margin Acc.)30MSGNRBatch input message numbernvarchar30
TOPRisk Analysis
168JBRSVGAPERRRM Gap: Error for Saved Gap Evaluation Results9MSGNRMessage numbernvarchar30
TOPSAP Business Workflow
169AKTIVITEMActivities After Receipt of Work Item from Message2MSGNRMessage numbernvarchar30
170SWFSLSDEADLTRCDeadline Service: Deadline Trace4MSGNRMessage numbernvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
171NWCH80IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise9MSGNRIS-H CH: numero messaggio dell'assicurazionenvarchar350
172NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)138MSGNRNumero messaggionvarchar30
173TNNC3IS-H NL: Kostenübernahme von leistungen16MSGNRMeldingsnummernvarchar30
TOPSAP System Log
174SLGSMSystem Log Statistics by Message2MSGNRSystem log message Identifiernvarchar30
TOPService Station Retailing
175OIRC_APR_STATUSSSR Pricing - Active checks - Status7MSGNRMessage numbernvarchar30
176OIRC_PR_CHECKSSSR Pricing - Check codes3MSGNRMessage numbernvarchar30
TOPServices
177FINB_TMSGAPPL01Deviating Message Type (Required Error Weight) for Appl.4MSGNRMessage numbernvarchar30
178FINB_TMSGAPPL0SMessage Type (Minimum Message Weight) per Application3MSGNRMessage numbernvarchar30
TOPSwitzerland
179T5C23Further Calculation Formulas for Cumulation Wage Types9MSGNRMessage numbernvarchar30
180T5CARMessage for Employee Attribute Combination12MSGNRMessage numbernvarchar30
TOPValue Adjustment
181/IBS/CRB_BA_SRTRBD: Obsolete3MSGNRMessage numbernvarchar30
TOPWarranty Claim Processing
182CWTY07MS2Determination of Popup Messages3MSGNRMessage numbernvarchar30
183CWTYR06Connection Message - Decision - Processing Mode3MSGNRMessage numbernvarchar30
TOPWorkbench Tools Editors, Painters, Modelers
184COVLOGCoverage Analyzer Log Entry8MSGNRMessage numbernvarchar30
185T100OAssignment of message to object2MSGNRMessage numbernvarchar30
186T100VAssignment of messages to tables/views2MSGNRMessage numbernvarchar30
187T100WAssign Messages to Workflow3MSGNRMessage numbernvarchar30