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

109 columns | Print definition?ERP 6.0  | ERROR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_STOPrsadrini table to stop index pool if error happen2ERRORGeneral Flagnvarchar10
2CNV_20100_CHECKResults of check programs3ERRORError descriptions for CoA check programsnvarchar100
3DMC_COMPARE_DIFTable for keys of rows with differences7ERRORnvarchar10
4EHPRCC_EXCHKCP: Specify checks for export categories5ERRORAccept Check Result with Errorsnvarchar10
5GRFNMWRTARCHHISTMSMP Archiving History10ERRORFlag (X or Blank)nvarchar10
6P2B2_FEHLERHCM Declustering B2 - Messages (Table FEHLER)10ERRORNumber of Message Typenvarchar20
7PAYR_XBANC_HRTemporary Storage in FI for Cashed HR Checks14ERRORUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
8T5F99FEForms: Error code list6ERRORAnomalynvarchar100
9T5F99FETForms: Error code list TEXT7ERRORAnomalynvarchar100
10TACO1Table for activating DD objects8ERRORFlag (X or Blank)nvarchar10
11TACOBTable for activating DD objects8ERRORFlag (X or Blank)nvarchar10
12TERMBAuthorizations for Transaction TERM4ERRORFlag for transaction TERMnvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
13CRMCHKRESAResult Attributes17ERRORYes/No Indicatornvarchar10
14CRMCHKRESLFindings (Display LoaD)20ERRORYes/No Indicatornvarchar10
TOPBackground Processing
15BTCDELAYDirectory of delayed system log messages for batch scheduler2ERRORProblem cause that triggers a system log messagenvarchar320
TOPBudget Management
16HRPMSIMSimulated Payroll Results for HR Funds and Position Mgt9ERROR'Error During Simulation' Flagnvarchar10
TOPBusiness Application Support
17CNVMESSAGEConversion: package-related control of message output5ERRORConversion: Upper limit for number of messagesint100
TOPBusiness Consolidation
18UCST001SEM-BCS: Performance Statistics28ERRORSEM-BCS: Statistic Errornvarchar10
TOPBW Service API
19RORQSTPRMSProtokolltable Request5ERRORReturn Codeint100
TOPConfirmations
20AFWDDeliveries for Confirmation Goods Movements in EWM7ERRORConfirmation Errors for Itemnvarchar10
TOPConsolidation
21TF261CG/CU: Detail Status of Tasks - Data Monitor9ERRORNumber of errorsnvarchar40
22TF271CG/CU: Detail Status of Tasks - Consolidation Monitor9ERRORNumber of errorsnvarchar40
TOPConstruction Industry
23T5DB9Construction Pay Evaluation Records for Social Fund Proc.14ERRORError Status for Evaluation Records SFP Constructionnvarchar40
TOPCross-Application Components
24/OPT/VIM_LOAD_LGLog of data load12ERRORChar 80nvarchar800
25TASUVAR1ASU Variants: Fieldinformations for reports with variant10ERRORSingle-Character Indicatornvarchar10
TOPData Staging
26RSCOPY_RUNCopy Process (Run for Copy Tool)13ERRORBooleannvarchar10
27RSERRORHEADIncorrect Records (Header Table)7ERRORBooleannvarchar10
28RSMIGRATEPRSTAMigration: Edited Objects8ERRORBooleannvarchar10
29RSMONJUDGEMonitor: Evaluating a Request2ERRORBooleannvarchar10
30RSMONRQTABMonitor table for request IDocs6ERRORSingle-Character Indicatornvarchar10
TOPDevelopment Workbench
31WCF_CONF_SWITCHSwitch Info10ERRORWCF Switch Info Bindingnvarchar2550
TOPEnvironment, Health and Safety
32/TDAG/CPC_EXCHKCP: Specify checks for export categories5ERRORAccept Check Result with Errorsnvarchar10
33/TDAG/CPC_GENCHKCP: Specify checks for generation variants5ERRORAccept Check Result with Errorsnvarchar10
TOPFast Search Infrastructure
34SFSRFW_IDX_RTReplication Framework Inital Load Status6ERRORReplication Framework Error Flagnvarchar10
35SFSRFW_JDX_RTReplication Framework Inital Load Status4ERRORReplication Framework Error Flagnvarchar10
TOPFSCM In-House Cash
36IHC_DB_PNSource Document for Incoming Payment Orders8ERRORError in Processingnvarchar10
TOPFunds Management
37FMCHA1Work List for Reassignment Tool47ERRORError numbernvarchar30
38FMRC07Results List Documents Bank/Clearing Account Matching FM-FI6ERRORError numbernvarchar30
39FMRC07_WO_BUNDLEResults List Documents Bank/Clearing Account Matching FM-FI6ERRORError numbernvarchar30
40FMRC_RC_PAYResults List: Documents: Bank/Clearing Acct Matching FM-FI10ERRORError numbernvarchar30
TOPGeneral Ledger Accounting
41FAGL_MIG_FICHA1Worklist for FI Reassignment Tool30ERRORSystem Message Numbernvarchar30
TOPHandling of Inflation
42J_1APROLOGLog table for Inflation Adjustment Programs9ERRORErrors in execution of the Programnvarchar10
TOPIntegration Engine
43SXMSBLKAGGXMB: Aggregated Data for Package Statistics18ERRORNatural Numberint100
44SXMSBLKRAWXMB: Raw Data for Package Statistics11ERRORXMB: Single-Digit Figuredecimal10
TOPJob Scheduling and Monitoring
45/JCS/FCC_ACTIONSFCc: Notification actions to perform12ERRORName of Remote Tasknvarchar800
TOPJust-In-Time Processing
46JITIMPCalls for the signal monitor5ERRORError Occurred with Inbound IDocnvarchar10
TOPKnowledge Warehouse
47KWD_RETROFIT1Retrofit for IWBHELP: Initial Folders and Results13ERRORMessage Numbernvarchar30
48KWD_RETROFIT2Retrofit for IWBTRAIN & XML_TRAIN: Initial Folders & Results13ERRORMessage Numbernvarchar30
49KWD_RETROFIT3Retrofit for XML_DOCU: Initial Folders and Results13ERRORMessage Numbernvarchar30
50KWD_RETROFIT4<> IWBHELP/TRAIN, XML_DOCU/TRAIN: Initial Folders & Results13ERRORMessage Numbernvarchar30
TOPLease Accounting
51FIEH_STATUSObject Status for Restart Exception Handling11ERRORStatus "error"nvarchar10
TOPLocal Currency Changeover
52EWUCLERREMU Cnv: Table for Faulty/Unconverted Entries8ERRORText Fieldnvarchar500
TOPLocalization
53REXC_IN_ERR_CONFREFX - India Localization: Error configuration3ERRORREFX- India Localization: Data element for Error config.nvarchar10
TOPMaintenance Processing
54ALM_ME_DEBUG_SETDebugging Settings7ERRORWrite Error in Return Tablenvarchar10
TOPMedia Product Sales and Distribution
55JKSDUNSOLDIS-M: Header Data on Unsold Copies37ERRORCheckboxnvarchar10
TOPNetWeaver Demonstration
56SDEMO_DGRUNProtocol Table for Data Generator Runs5ERRORBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
57SNWD_DG_RESULTSEPM: Data Generator Results5ERRORBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPOLAP Technology
58RSDDTREXHPAFAILError Recording for Queries on HPA1ERRORSingle-Character Indicatornvarchar10
59RSDDTREXSNAPSHOTList of BIA Data Snapshots4ERRORStatus of a BWA Data Snapshotnvarchar10
TOPOperational Data Provisioning ODP
60RODPSLOADHEADODP Activation (Header)13ERRORODP Contains Errorsnvarchar10
61RODPSODPEHEADODP Activation (Header)11ERRORODP Contains Errorsnvarchar10
TOPPayroll
62T5TELDPHR Cluster 26ERRORnvarchar10
63T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP5ERRORnvarchar10
64T5TPSDPRESHR Cluster 16ERRORnvarchar10
65T5TREGHR Cluster 26ERRORnvarchar10
66T5TREGSIHRCZ - insured register6ERRORnvarchar10
67T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP5ERRORnvarchar10
TOPPerformance Assessment Workbench
68SLS_BLOGPAW - logging table for BAPIs10ERRORSingle-Character Indicatornvarchar10
69SLS_LOGPAW - Logging Table (remake)11ERRORSingle-Character Indicatornvarchar10
70SLS_LOG2PAW - Logging Table (remake)11ERRORSingle-Character Indicatornvarchar10
71SLS_PETPAW - Person/Event/Test Relationship Table18ERRORPAW - 'Error' Flag - as checkbox ('X' = yes)nvarchar10
TOPPerformance Monitors TCC
72GVD_BGPROCESSOracle monitoring: Copy of GV$BGPROCESS6ERROROracle monitorig: Error encountereddecimal220
TOPPersonnel Administration
73PAD_SE_DELTA_LOGLog table for employee regarding distribution scenarios6ERRORData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
74RPUCTEXXResults of the TODO Report RPUCTEXX10ERRORnvarchar600
TOPPersonnel Time Management
75T555ETime Evaluation Messages4ERRORNumber of Message Typenvarchar20
76T555FTime Evaluation Error Texts5ERRORNumber of Message Typenvarchar20
77T705BPDC Processing Statuses8ERRORNumber of Message Typenvarchar20
78T705EReaction to Error Transaction4ERRORNumber of Message Typenvarchar20
79T7TIM_BSB_MESSGAssignment of Business Subject to a Message4ERRORNumber of Message Typenvarchar20
TOPProcess Monitoring Infrastructure
80SSPIBMSTPMI: Benchmark Test Statistics7ERRORGlobal SPI: Boolean Valuetinyint30
81SSPICSPRHDSPI: Assembled Process Instances7ERRORSPI: Error Status for Processvarbinary10
82SSPICSPRSTSPI: Steps of Assembled Process Instances22ERRORSPI: Error Status for Processvarbinary10
83SSPICSTRHEADSPI: Central Store Tracking Records Header18ERRORSPI: Error Status for Processvarbinary10
84SSPIRGOVPRSPI Cumulation at Process Level7ERRORSPI: Error Status for Processvarbinary10
TOPProduct Data Management
85CONV_FILEClipboard for Objects to Convert6ERRORError while convertingnvarchar10
TOPProduct Safety
86CCRCC_MISDATACNDEHS: Condition Table: Behavior If Data Missing4ERRORError If Data Missingnvarchar10
TOPProfitability Analysis
87TKEVA03Costing Key16ERRORFlag - Error message if no cost estimate foundnvarchar10
TOPRecipe Development
88/PLMI/LBL_MIGRATMigration Administration (mapping of EhP4 to PLMWUI)12ERRORLabeling Migration: Error Indicatornvarchar10
89/PLMI/RCP_MIGRATMigration Administration (mapping of RM to RD)17ERRORRecipe Migration: Error Indicatornvarchar10
TOPRisk Analysis
90JBRMSGSELRM: Indicators that control the Filter for Messages2ERROROutput Field as Checkboxnvarchar10
TOPSAP Business Workflow
91SWELOGTable for entries of the event log7ERROREvent Trace: Error Numbernvarchar40
92SWFREVTLOGEvent Log12ERROREvent Trace: Error Numbernvarchar40
TOPSAP NetWeaver Mobile - Use subcomponents
93MEMON_TECH_CONAGS Monitoring: Resource Consumtion Monitor9ERRORME: AGS - Final Status ( Error / Finished )nvarchar200
TOPShipping
94WSUBST_WORKLSTWorklist Substitution Proposals23ERRORError Indicatornvarchar10
TOPSwitch Framework Tools
95SFW_INST_XPRA_EXIndustry Installation XPRAs Activation Time4ERRORSingle-Character Indicatornvarchar10
TOPTime Sheet
96CABAREFCATS: Transfer from CATS II to PS, PM, and CO9ERRORGeneral Flagnvarchar10
TOPTransport Management System
97CMSALOGARCMS Action Log6ERRORCMS Errornvarchar800
98CMSALOGTCMS Action Log6ERRORCMS Errornvarchar800
99TMSALOGTMS Alert: Logging Table9ERRORCI: errornvarchar300
100TMSALOGARTMS: Archived ALOG9ERRORCI: errornvarchar300
TOPTreasury
101VTBDFLGDatafeed: Log file9ERRORDatafeed: Error messagenvarchar800
102VTB_MARKETDatafeed: Market data14ERRORDatafeed: Error messagenvarchar800
103VTB_MARKET_TDatafeed: Temporary market data copy for workflow14ERRORDatafeed: Error messagenvarchar800
TOPUpgrade Tools
104CRRRTITCRR runtime information5ERRORGeneral Flagnvarchar10
TOPWaste Management
105EWA_VALDEFValue Set Threshold Values for Tare Weight Validity Category6ERRORThreshold Value Error Message for Tare Weight Validity Cat.nvarchar100
TOPWorkforce Management Application
106WFAC_ALRT_MGRAlert Profile Configuration for MS WFD5ERRORError Alertnvarchar10
107WFAC_ALRT_PROFAlert Profile Configuration for MS WFD5ERRORError Alertnvarchar10
TOPWorkforce Management Core
108WFMC_ALRT_MGRAlert Profile Configuration for MS WFD5ERRORError Alertnvarchar10
109WFMC_ALRT_PROFAlert Profile Configuration for MS WFD5ERRORError Alertnvarchar10