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

45 columns | Print definition?ERP 6.0  | SEQUENCE_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CMCBC_ROLL_TEMPRolling template3SEQUENCE_NOnvarchar30
2CNVMBTSELRANKSPossible Reduction groups6SEQUENCE_NOSequence numbernvarchar30
3CNVMBTSHELLDBSIZShell Creation: DB Size of SND and Shell Systems4SEQUENCE_NOCounternvarchar30
4CNVTDMSBW_SELGRPSelection groups of all objects6SEQUENCE_NOSequence numbernvarchar30
5CNVTDMS_03_GROUPPossible Reduction groups6SEQUENCE_NOSequence numbernvarchar30
6CNVTDMS_13_DBSIZTDMS dbsize for shell creation4SEQUENCE_NOCounternvarchar30
7POC_D_EVTQ_CNTXTContext data Queue for an Event4SEQUENCE_NOSequence Numbernvarchar30
8T5ASRFSCNBOLCFGConfigurations4SEQUENCE_NOSequence Numbernvarchar30
9T5ASRFSCNBOLCONFObsolete: Configurations(donot use)9SEQUENCE_NOSequence Numbernvarchar30
10T5ASRFSCNFPMCONFFPM Configurations Data for Form Scenario6SEQUENCE_NOTwo digit numbernvarchar20
11T7CNRMP_RPTGRPGrouping Dimension for Report4SEQUENCE_NOSequence Numbertinyint30
12T7CNRMP_RPTSTAStatistical Dimension for Report4SEQUENCE_NOSequence Numbertinyint30
13T7CNRMP_SUMITMSummary Structure Item4SEQUENCE_NOSequence Numbertinyint30
14T7CNRMP_VALUEITMValue Item of Statistical Item with Value Reading Type5SEQUENCE_NOSequence Numbertinyint30
TOPAccounting Engine
15/EACC/JRNL_DERIVDerivation Configuration for the Journal8SEQUENCE_NONumc3, internal usenvarchar30
16/EACC/VIEW_DERIVDerivation Configuration Requirements in a View14SEQUENCE_NONumc3, internal usenvarchar30
TOPAuto-ID Infrastructure
17/AIN/TDOD1_NRRANDOD Tag Data Construct #1 Number Range5SEQUENCE_NOSequence Numbernvarchar100
18/AIN/TGIAI_NRRANGIAI Number Range5SEQUENCE_NOSequence Numbernvarchar100
19/AIN/TGRAI_NRRANGRAI Number Range5SEQUENCE_NOSequence Numbernvarchar100
20/AIN/TGTIN_NRRANGTIN Number Range5SEQUENCE_NOSequence Numbernvarchar100
21/AIN/TID_SCHEMAID Schema4SEQUENCE_NOSequence Numbernvarchar100
22/AIN/TID_URNURN Format of IDs4SEQUENCE_NOSequence Numbernvarchar100
23/AIN/TSSCC_NRRANSSCC Number Range5SEQUENCE_NOSequence Numbernvarchar100
TOPBasic Functions
24PAYSP_HLPayment Service Provider Data4SEQUENCE_NOTransaction Sequence Numbernvarchar40
TOPCollaborative Cross Applications
25/POA/D_CLM_MD02Metadata File - Content Record Type Relationship4SEQUENCE_NONumber in Sequenceint100
TOPCorporate Performance Monitor
26UMV_TR211Value Driver Tree: Measure Dependencies6SEQUENCE_NOCount parametersnvarchar40
TOPFinancials Basis
27ACC_TERMINATIONClasses to be called up when Acc. entities are deleted2SEQUENCE_NOCount parametersnvarchar40
TOPInformation Retention Manager
28SILM_VIEW_JOINView Definition: Join Conditions7SEQUENCE_NOSequence Numbernvarchar30
29SILM_VIEW_KEYView Definition: Unique Key for Result Structure5SEQUENCE_NOSequence Numbernvarchar30
30SILM_VIEW_TABView Definition: Tables (Data Source)5SEQUENCE_NOSequence Numbernvarchar30
TOPMaintenance Orders
31/MRSS/C_CHNG_FRMClasses for handling the Change Framework2SEQUENCE_NOSequence Number for Executionsmallint50
TOPOccupational Health
32T7EHS00_PREGANATable for Comment Field: Protocol_Regulation-analysis_text5SEQUENCE_NOInternal Number for Statutory Regulationnvarchar30
33T7EHS00_PREGDESTable for Comment Field: Protocol_Regulation-description5SEQUENCE_NOInternal Number for Statutory Regulationnvarchar30
34T7EHS00_PREGFOLTable for Comment Field: Protocol_Regulation-follow_up5SEQUENCE_NOInternal Number for Statutory Regulationnvarchar30
35T7EHS00_PREGPROTable for Comment Field: Protocol_Regulation-procedure_text5SEQUENCE_NOInternal Number for Statutory Regulationnvarchar30
TOPPurchasing
36EKDFDocument Flow for Logistics Differential Invoice15SEQUENCE_NODifferential Invoicing - Sequence Numbernvarchar40
TOPRecipe Development
37/PLMB/RCP_MDL_RLRecipe Model Table for Rules16SEQUENCE_NOSequence Number for Simulation Rule in Modelint100
TOPReusable Components of Business Suite Foundation
38/BOFU/CTXC_ACDETAssociation definition3SEQUENCE_NOSequence Numbertinyint30
39/BOFU/C_TXCACTASAssignment of Access to Access Sequence and Configuration4SEQUENCE_NOSequence Numbertinyint30
TOPRoyalty Reporting
40OIUREP_2014_REPMMS-2014 - Supplemental Reports From Report Executions6SEQUENCE_NOMMS-2014: Sequence Numbernvarchar20
41OIUREP_SUPL_REPMMS-2014 - Supplemental Reports3SEQUENCE_NOMMS-2014: Sequence Numbernvarchar20
42OIUREP_SUPL_REPTMMS-2014 - Supplemental Reports Description4SEQUENCE_NOMMS-2014: Sequence Numbernvarchar20
TOPSupply Chain Management
43/SDF/EM_STEPException Management - Process Step Table7SEQUENCE_NOSequencesmallint50
44/SDF/EM_UNITException Management - Unit Table8SEQUENCE_NOSequencesmallint50
TOPWeb Dynpro ABAP
45WDY_CFG_CMP_WULWhere-Used List for Component Configurations4SEQUENCE_NO2 byte integer (signed)smallint50