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

143 columns | Print definition?ERP 6.0  | NR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1AMC_CHNL_AUTHABAP Messaging Channel Authority definition3NRNatural Numberint100
2BBP_SUS_NEWSSRM-SUS: News Management by Purchaser11NRSort Sequence of Newsnvarchar30
3CNV_20551_DERIV1Object types for Find_Objects - fields and check fields6NRSeq. number (0: actual field; 1,2,3,4 for parameter fields)nvarchar20
4CNV_20551_DERIV2Object types for Find_Objects - parameter fields6NRSeq. number (0: actual field; 1,2,3,4 for parameter fields)nvarchar20
5CNV_20551_KOMBI1Combined check routines - sequence of the object types4NRCounternvarchar20
6FCML_T_EDGEEVENTZML_EDGEEVENT2NRnvarchar30
7FCML_T_EVENTZML_EVENT_TEST - Test table for Events2NRnvarchar30
8FCML_T_OBJEVENTZML_OBJECTEVENT2NRnvarchar30
9TC35ADefinition of period pattern3NRSegment in the period patternnvarchar20
10TCA33Verification / input facility in task lists7NRNumber within verification sequencenvarchar40
11TCMP_TEMPLATE_CTemplate Rows3NRint100
12TKE_TIMER_DETAILCO-PA Runtime Measurements: Details4NRNatural Numberint100
13VGGT1Generically buffered test table2NRMaximum length of pool function partnvarchar50
14VGHT1100% buffered test table2NRMaximum length of pool function partnvarchar50
TOPActivity-Based Costing
15COSRVVariants (characteristics) for LIS performance measures4NRCurrent number of characteristicnvarchar40
TOPALE Integration Technology
16CIMSYNSyntax Description for Extensions3NRSequential Number of Segment in IDoc Typenvarchar40
17IDOCSYNSyntax Description for Basic Types2NRSequential Number of Segment in IDoc Typenvarchar40
18IDXIDOCSYNIDoc Adapter IDoc Syntax Description for each Port4NRSequential Number of Segment in IDoc Typenvarchar40
TOPAnalyzer
19AFWGO_LOGHISTORYHistory of Application Logs in Single Records Procedure4NRSequence numbernvarchar30
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
20COAT_ATTRIBCOAT: Project - Possible Attributes3NRAttribute Numbernvarchar40
21COAT_ATTRIB_TCOAT: Attribute Texts4NRAttribute Numbernvarchar40
22COAT_ATTRIB_VALCOAT: Values of Attributes4NRAttribute Numbernvarchar40
23COAT_CLASSICOAT: Project - Classifications of Individual Objects5NRAttribute Numbernvarchar40
24COAT_CLASSI_HISTCOAT: Project - History of Classifications of Objects5NRAttribute Numbernvarchar40
25COAT_E_DATACOAT: Extract Data6NRAttribute Numbernvarchar40
TOPContract Accounts Receivable and Payable
26DFKKTRACEPFKKTRACE: Item Data9NRMessage Numbernvarchar30
TOPData Collection
27TKEBGGraphic settings for hierarchy graphic4NRNumber of graphic parameternvarchar80
28TMC7K_CHECKDefinition of the Char. Chain f. Checking the Info Structure3NRSequence Numbernvarchar20
TOPData Conversion
29DMC_DISTRCInfo on Structures For Test Type Direct Input 1/Example Type4NRFour-digit numbernvarchar40
TOPDirectory
30LDAPMAP2Mapping SAP Fields to LDAP Attributes - Fields4NRSequence Number for Mapping Parametersnvarchar60
31LDAPMAP3Mapping SAP Fields to LDAP Attributes - Attributes4NRSequence Number for Mapping Parametersnvarchar60
32LDAPMAP4Mapping SAP Fields to LDAP Attributes - Parameters4NRSequence Number for Mapping Parametersnvarchar60
33LDAPPROP2Proposals for Mapping SAP Fields to LDAP Attributes4NRSequence Number for Mapping Parametersnvarchar60
34LDAPPROP3Proposals for Mapping SAP Fields to LDAP Attributes4NRSequence Number for Mapping Parametersnvarchar60
35LDAPPROP4Proposals for Mapping SAP Fields to LDAP Attributes4NRSequence Number for Mapping Parametersnvarchar60
TOPEnhanced Intercompany Data Exchange
36/ISIDEX/EIDPROCCField Comparison Rules for Identification3NRConsecutive Number of Field Comparison Rulesnvarchar30
37/ISIDEX/EIDPROCRReplacement Rules3NRConsecutive No. of Replacement Rules for Synon. Charactersnvarchar30
TOPGermany
38PD3DBANHR-DDU: Address Data Module9NRHouse Numbernvarchar90
TOPIncentive and Commission Management ICM
39CACS00_B_VAR_ACTVariants for Commission Case Activities4NRnvarchar100
40CACS00_B_VAR_BDLVariants for Bundling4NRnvarchar100
41CACS00_B_VAR_CASVariants for Commission Case4NRnvarchar100
42CACS00_B_VAR_INVVariants for Commission Case Participants4NRnvarchar100
43CACS00_B_VAR_LINVariants for Alternative Commission4NRnvarchar100
44CACS00_B_VAR_OBJVariants for Commission Case Object Data4NRnvarchar100
45CACS00_B_VAR_PARVariants for Commission Case Participant4NRnvarchar100
46CACS00_B_VAR_RELVariants for Participant Relations4NRnvarchar100
47TCACS_REGCTCustomizing Table Index2NRItem in a selection conditionnvarchar10
48YCRM01_B_VAR_ACTVariants for Commission Case Activities4NRnvarchar100
49YCRM01_B_VAR_BDLVariants for Bundling4NRnvarchar100
50YCRM01_B_VAR_CASVariants for Commission Case4NRnvarchar100
51YCRM01_B_VAR_INVVariants for Commission Case Participants4NRnvarchar100
52YCRM01_B_VAR_LINVariants for Alternative Commission4NRnvarchar100
53YCRM01_B_VAR_OBJVariants for Commission Case Object Data4NRnvarchar100
54YCRM01_B_VAR_PARVariants for Commission Case Participant4NRnvarchar100
55YCRM01_B_VAR_RELVariants for Participant Relations4NRnvarchar100
56YHITEC_B_VAR_ACTVariants for Commission Case Activities4NRnvarchar100
57YHITEC_B_VAR_BDLVariants for Bundling4NRnvarchar100
58YHITEC_B_VAR_CASVariants for Commission Case4NRnvarchar100
59YHITEC_B_VAR_INVVariants for Commission Case Participants4NRnvarchar100
60YHITEC_B_VAR_LINVariants for Alternative Commission4NRnvarchar100
61YHITEC_B_VAR_OBJVariants for Commission Case Object Data4NRnvarchar100
62YHITEC_B_VAR_PARVariants for Commission Case Participant4NRnvarchar100
63YHITEC_B_VAR_RELVariants for Participant Relations4NRnvarchar100
64YSVMA_B_VAR_ACTVariants for Commission Case Activities4NRnvarchar100
65YSVMA_B_VAR_BDLVariants for Bundling4NRnvarchar100
66YSVMA_B_VAR_CASVariants for Commission Case4NRnvarchar100
67YSVMA_B_VAR_INVVariants for Commission Case Participants4NRnvarchar100
68YSVMA_B_VAR_LINVariants for Alternative Commission4NRnvarchar100
69YSVMA_B_VAR_OBJVariants for Commission Case Object Data4NRnvarchar100
70YSVMA_B_VAR_PARVariants for Commission Case Participant4NRnvarchar100
71YSVMA_B_VAR_RELVariants for Participant Relations4NRnvarchar100
72YTEL01_B_VAR_ACTVariants for Commission Case Activities4NRnvarchar100
73YTEL01_B_VAR_BDLVariants for Bundling4NRnvarchar100
74YTEL01_B_VAR_CASVariants for Commission Case4NRnvarchar100
75YTEL01_B_VAR_INVVariants for Commission Case Participants4NRnvarchar100
76YTEL01_B_VAR_LINVariants for Alternative Commission4NRnvarchar100
77YTEL01_B_VAR_OBJVariants for Commission Case Object Data4NRnvarchar100
78YTEL01_B_VAR_PARVariants for Commission Case Participant4NRnvarchar100
79YTEL01_B_VAR_RELVariants for Participant Relations4NRnvarchar100
80YTEL05_B_VAR_ACTVariants for Commission Case Activities4NRnvarchar100
81YTEL05_B_VAR_BDLVariants for Bundling4NRnvarchar100
82YTEL05_B_VAR_CASVariants for Commission Case4NRnvarchar100
83YTEL05_B_VAR_INVVariants for Commission Case Participants4NRnvarchar100
84YTEL05_B_VAR_LINVariants for Alternative Commission4NRnvarchar100
85YTEL05_B_VAR_OBJVariants for Commission Case Object Data4NRnvarchar100
86YTEL05_B_VAR_PARVariants for Commission Case Participant4NRnvarchar100
87YTEL05_B_VAR_RELVariants for Participant Relations4NRnvarchar100
88ZICMAG_B_VAR_ACTVariants for Commission Case Activities4NRnvarchar100
89ZICMAG_B_VAR_BDLVariants for Bundling4NRnvarchar100
90ZICMAG_B_VAR_CASVariants for Commission Case4NRnvarchar100
91ZICMAG_B_VAR_INVVariants for Commission Case Participants4NRnvarchar100
92ZICMAG_B_VAR_LINVariants for Alternative Commission4NRnvarchar100
93ZICMAG_B_VAR_OBJVariants for Commission Case Object Data4NRnvarchar100
94ZICMAG_B_VAR_PARVariants for Commission Case Participant4NRnvarchar100
95ZICMAG_B_VAR_RELVariants for Participant Relations4NRnvarchar100
TOPIndustry Solution Catch Weight Management
96CON_FIN_CKLOGCosting Applications: Log Texts3NRError Lognvarchar120
TOPIntegration Engine
97SXMSTESTCHECKCheck-Table6NRNatural Numberint100
98SXMS_TCMP_TESTTest Data Event-Driven Message Processing2NRDummy for B20 int1 (Local Everywhere)tinyint30
TOPMobile Applications
99/ISDFPS/ME_NRBuffer Table for Mobile Numbers from Number Ranges6NRChar 20nvarchar200
TOPOverhead Cost Controlling
100PFMSGPeriod-End Partner: Log (Message Handler Information)7NRError Management Numbernvarchar120
TOPPayroll
101T5TPVSTEMPLATEMasters for communication with PVS3NRSequence Numbernvarchar30
TOPProduct Cost Planning
102CKMCSO_LOGMass Costing of Sales Orders: Log Texts2NRError Lognvarchar120
103CMFKStorage Structure for the Error Log Header3NRError Management Numbernvarchar120
104CMFPStorage Structure for Errors Collected3NRError Management Numbernvarchar120
105CMFPARError Management: Additional Parameters for Message3NRError Management Numbernvarchar120
TOPProduction Orders
106TCO62Defining screen sequences for input facility and verificatn.4NRNumber within verification sequencenvarchar40
TOPProfitability Analysis
107TKETRTRSummarization. Levels: Transformation Number <-> Char. Value4NRSequence Numbernvarchar40
TOPProject System
108TCSCRSettings table for tabs in flexible detail display2NRConsecutive number for flexible detail screen keynvarchar80
109TCSCRKKey table for flexible detail display4NRConsecutive number for flexible detail screen keynvarchar80
110TCSCRTLanguage dependent text table for flexible detail display3NRConsecutive number for flexible detail screen keynvarchar80
TOPReport Selection for Product Costing
111TKKR0Hierarchy Summarization (Header)12NRError Management Numbernvarchar120
TOPReporting
112TMC7KDefinition of Characteristic Chain for Standard Analyses2NRSequence Numbernvarchar20
113TMC8Predefined Key Figures per Analysis5NRSequence Numbernvarchar20
114TMC9Standard Drill-Down in Standard Analyses5NRSequence Numbernvarchar20
115TMCEXNon-Displayable Key Figures per Standard Analysis5NRSequence Numbernvarchar20
TOPRouting
116TCA62Defining screen sequences for entry tool4NRNumber within verification sequencenvarchar40
117TCA66Screen sequence definition4NRNumber within verification sequencenvarchar40
118TCA72Task lists: Verification level of the function modules4NRSequence numbernvarchar30
TOPSAP Records Management
119SRMUSPROFARegistry Maintenance - User Profile - Worklist4NRint100
TOPSchedule Manager
120SMMESSAGEMessages Saved for Monitor7NRError Management Numbernvarchar120
TOPSocial Insurance
121P01BM_DBANAddress Data Modules for PPO DEUEV Notifications7NRHouse Numbernvarchar90
122P01D3_DBANDEUEV Confirmation: Address Data Module7NRHouse Numbernvarchar90
123P01DS_DBANData Modules Address of DEUEV Immediate Notifications7NRHouse Numbernvarchar90
124P01EE_DBANData Module DBAN Address7NRHouse Numbernvarchar90
125P01EL_DBANData Module Address of ELENA Notifications7NRHouse Numbernvarchar90
TOPStatements
126P01W_DBANData Module: Address11NRHouse Numbernvarchar90
TOPSyntax, Compiler, Runtime
127SLIN_CHCKDescription of SLIN Subchecks2NRNumbering of SLIN Subchecks (Order of Display)nvarchar20
128VER03984_STRINGTabelle für Veri 03984 - Strings im SHM und auf der DB1NRint100
TOPTransaction Manager
129MIGTS_CVCLS_FMFunction Modules for Conversion Customziing Gen. Val. Class1NRNumc3, internal usenvarchar30
130TPMB_DERIV_CATDefine Derivation Methods2NRSequence Number of Derivation Method per Pos. Mgmt Cat.nvarchar30
131TRGTS_INIT_FUNCTFunction Modules for Maintaining Pos. Values for Parallel VA2NRSequence Number of Derivation Method per Pos. Mgmt Cat.nvarchar30
TOPTransfer to Financial Accounting
132TRLTS_DERIV_CATTreasury: Asst of Derivation Method to Pos. Management Cat.2NRSequence Number of Derivation Method per Pos. Mgmt Cat.nvarchar30
133TRLT_INITSTEP3Function Modules of Treasury Ledger Initialization Step 31NRSequence Number of Derivation Method per Pos. Mgmt Cat.nvarchar30
TOPTranslation Tools
134LXE_TAMO_ERRORConfiguration Table for Trados Analysis Errors1NRtinyint30
135TRMABBAbbreviations Table of Proposal Pool6NRNumeric, 2-digit; Proposal Poolnvarchar20
136TRMCOMRemark Table for the Proposal Pool10NRNumeric, 3-digit; Proposal Poolnvarchar30
137TRMINTLink Table of Proposal Pool7NRNumeric, 3-digit; Proposal Poolnvarchar30
138TRMTRALink Table of Proposal Pool7NRNumeric, 2-digit; Proposal Poolnvarchar20
TOPUpgrade Tools
139DDCNVTIMESDD: Exclusion times for conversion4NR2 byte integer (signed)smallint50
TOPWaste Management
140EWA_EL_SPRATEXTGlobal Table for Language-Dependent Texts3NRCharacter field of length 40nvarchar400
141EWA_WA_WEIGHOFFLOffline Weighing2NROffline Weighing Transaction Numbernvarchar200
TOPWeb Service and SOAP - ABAP
142SRT_REG_CONFIGSRT Registry: Web Service Configuration Runtime4NRnvarchar100
TOPWorkforce Planning
143TCYMPP_PERIODSPeriod Split for Workforce Planning3NRLine numbers for period splitsnvarchar20