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

43 columns | Print definition?ERP 6.0  | MODUS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPABAP Authorization and Role Management
1PRGN_CORRCorrection Table for Modif. Transaction Codes in Area Menus6MODUSSingle-Character Indicatornvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
2UTCMPVerification Table for Decider in DD_DECIDE6MODUSExec mode for compare programnvarchar10
TOPAnalyzer
3AFWBM_CALC_PROTAdministration of Authorization for Benchmarks6MODUSMode of Benchmark Runnvarchar10
4AFWGO_LOADADMINManagement of Single Records Procedures per Date14MODUSMode for Single Records Procedurenvarchar20
5AFWGO_LOGHISTORYHistory of Application Logs in Single Records Procedure5MODUSMode of Run that Wrote the Application Lognvarchar20
TOPApplication Framework
6MDG_GN_TMODUSConfiguration of the Generator Mode3MODUSMode of Generatornvarchar10
7MDG_TR_CCMAdministration Client Copy4MODUSMode for client transportnvarchar10
TOPBasic Data
8TNFASIS-H: Department Status for Basic Medical Documentation3MODUSIS-H: Event for Department Statusnvarchar10
9TNKRSIS-H: Number Ranges4MODUSIS-H: Operat. Mode of IS-H Transaction (Normal/Stand-Alone)nvarchar10
TOPBusiness Package for Manager Self-Service FI
10FCOM_SMPHIERCCustomizing for Hierarchies5MODUSHierarchy Modenvarchar10
TOPBusiness Partner
11TPR2Partner-Obj. Relationship: Assignment Cat. - Application Cat4MODUSPartner-Object Relationship: Processing Modenvarchar10
TOPClient Copy
12CCC_CHECKClient dummy2MODUSMode for client transportnvarchar10
TOPCurrency Customizing and Handling for Euro
13EWCMPROTLog of Customizing currency settings for euro6MODUSnvarchar20
TOPDefault Risk and Limit System
14KLPARAMCredit Limit: Tab for Controlling Ext. Default Risk Rates3MODUSCredit Limit: Mode for External Transactionsnvarchar10
15KLSDCPARAMCredit Limit: Controlling External Default Risk Rates (NEW)4MODUSCredit Limit: Mode for External Transactionsnvarchar10
TOPeCATT Extended Computer Aided Test Tool
16ECET_SECURETable for Security Aspects with External Tool3MODUSnvarchar10
TOPF1 Help
17THELPSAP User Settings for the Help Processor2MODUSHelp processor modenvarchar10
TOPFinancials Basis
18FINB_GN_TMODUSConfiguration of the Generator Mode3MODUSMode of Generatornvarchar10
19FINB_TR_CCMAdministration Client Copy4MODUSMode for client transportnvarchar10
TOPIncentive and Commission Management ICM
20TCACS_UPD_MODECustomizing Table for Update Mode of Totals Tables4MODUSUpdate Mode for Totals Tablenvarchar10
21TCACS_UPD_MODUSCustomizing Table for Update Mode of Totals Tables2MODUSUpdate Mode for Totals Tablenvarchar10
TOPInformation System
22VTIS_FIELDSTIS: Renaming of Fields2MODUSField renaming modenvarchar10
TOPIntegration Engine
23SXMSHELPHelp Assistant6MODUSnvarchar40
TOPLanguage Transport
24TLANIMPLanguage Transport: Import Action14MODUSLanguage Transport Modenvarchar10
TOPPatient Accounting
25NFAKIS-H: Header information for CASE selection billing4MODUSIS-H: Mode of Billing Run (Active only for Rel. 2.24!!)nvarchar10
TOPPatient Management
26NGEBIS-H: Birth Data of Newborns16MODUSIS-H: Birth Procedurenvarchar10
27TN15EIS-H: Birth Procedures2MODUSIS-H: Birth Procedurenvarchar10
28TN15VIS-H: Birth procedure texts3MODUSIS-H: Birth Procedurenvarchar10
TOPPayroll General Parts
29T513JRPDSYS00 - Default Values3MODUSSingle-Character Indicatornvarchar10
TOPPersonnel Administration
30T578ZControl Table for Internal Medical Service8MODUSStorage of examination areanvarchar10
TOPPersonnel Time Management
31TPTREQ_TEAMAssignment of Rule Group to View Group/Grouping ID3MODUSMode of Web Applicationnvarchar10
TOPProduction Planning
32TCPFS3External planning tool: lock table5MODUSWork mode of the external planning systemnvarchar10
TOPQuality Management
33TQ01QM basis table for transaction-screen control2MODUSProcessing Modenvarchar10
TOPRemaining Beverage - Obsolete Objects
34/BEV1/RBWEItemized Proof Rebate Settlement55MODUSModenvarchar10
35/BEV3/CHASTEUERControl Data for Each Message10MODUSProcessing modenvarchar10
TOPResults Recording
36TQ78Status-dependent processing table for insp. characteristics3MODUSCharacteristic Filter (Processing Mode) for Inspection Charsnvarchar40
37TQ78TTexts for the status-specific proc. table for insp. char.3MODUSCharacteristic Filter (Processing Mode) for Inspection Charsnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
38TNWAT_NKRS_NEWIS-H AT: neue Nummernkreise für jährliche Umstellung via Job4MODUSIS-H: Betriebsart einer IS-H-Transaktion (Normal/Standalone)nvarchar10
TOPSession Manager
39SSM_STAT_HStatus Table for the Session Manager6MODUSCustomized ('C') or standard menu ('S') flagnvarchar10
TOPSocial Services and Social Security
40PSSCC_MSG_FILTERInformation about Filtering of Messages5MODUSMode (Allow or Block)nvarchar10
TOPSwitzerland
41PA0980HR Master Record Infotype 098024MODUSSubtypenvarchar40
TOPSystem Administration Assistant
42SAAHELPHelp Assistant6MODUSnvarchar40
TOPTranslation Tools
43TRMFDIRTRM Table for Storing the Directory for Reorganization, etc.4MODUSPurpose of tracus runnvarchar100