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

30 columns | Print definition?ERP 6.0  | KEYID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/KORA/KEYM_Tkr: Key mit AOID2KEYIDkr:SAP Object IDnvarchar400
2/XLSO/KEYWORDSMaintain Keywords and tags2KEYIDKey ID for productnvarchar80
3CNVCMISBACKUP_EXBackup Functionality - Runtime Information2KEYIDKey IDnvarchar220
4CNVCMIS_BACKUPBackup Functionality - Overview Table5KEYIDKey IDnvarchar220
5REMOB_T_LOGVisit History2KEYIDCharacter field with length 27nvarchar270
6STODOINFInformationen zu TODO Meldungen5KEYIDIdschlüssel einer Todomeldungnvarchar40
TOPBusiness Planning and Simulation
7UPC_NEVALPlanning Functions: New Values5KEYIDField for Any Characteristic Valuenvarchar600
TOPData Collection
8KCVARSAP-EIS: data slice variables4KEYIDCharacteristic valuenvarchar500
9T241BDescription of Characteristic Values4KEYIDCharacteristic valuenvarchar180
10T242BCharacteristic values per characteristic3KEYIDCharacteristic valuenvarchar180
11T242DData transfer control4KEYIDCharacteristic valuenvarchar500
12TKCHNSAP-EIS Hierarchy nodes5KEYIDSAP-EIS: Nodes which cannot be posted tonvarchar500
13TKCHNTSAP-EIS: Hierarchy node texts6KEYIDSAP-EIS: Nodes which cannot be posted tonvarchar500
14TKCOMSAP-EIS: Method table5KEYIDText (100 characters)nvarchar1000
15TKEC1Comment management for characteristic attributes4KEYIDCharacteristic valuenvarchar500
TOPData Transfer
16KCDRSData Transfer Rules: Selection Criteria of Sender Fields4KEYIDCharacteristic value in recipient fieldnvarchar500
17KCDVARData transfer: variables7KEYIDCharacteristic value in recipient fieldnvarchar500
TOPFramework
18CRMC_IC_CUST_TXTLanguage dependent texts used in Customizing XML profiles3KEYIDKey for Translatable Text Used in Customizing XML Profilesnvarchar300
TOPIncentive and Commission Management ICM
19CACSFA_DOCFA_PDSettlement to FI-CA: Reference Document Line Items8KEYIDKeyID for FI-CA integrationnvarchar40
TOPLocalization
20IDGT_CONF_LCGTI China: Tax Invoice table2KEYIDTax Invoice Keynvarchar40
21IDGT_CONF_LC_TGTI China: Tax Invoice Text table3KEYIDTax Invoice Keynvarchar40
22J_2IEXTRCTData Extract table for Excise Registers6KEYIDKey ID qualifier for extract linesnvarchar140
23J_2IUTZDATUtilization dates4KEYIDKey ID qualifier for extract linesnvarchar140
TOPMonitoring
24ALPFAUTOREPORTList of PerfDB Report to Be Executed Automatically1KEYIDNatural Numberint100
TOPProfitability Analysis
25CEFORMVCO: Variables for row/column structure18KEYIDCharacteristic valuenvarchar500
26TKESVGlobal variables14KEYIDFixed valuenvarchar320
TOPReporting
27TMCTXLIS: Characteristic Texts (external data and R/2)4KEYIDCharacteristic valuenvarchar180
TOPSAP Records Management
28SRMKCDATASearch Table for Keywords: Keyword and Description2KEYIDKeyword ID in Hierarchical Listnvarchar320
29SRMKCNAMESSearch Table for Keywords3KEYIDKeyword ID in Hierarchical Listnvarchar320
TOPSupply Chain Management
30/SDF/WS_MONSystem Table INDX2KEYIDnvarchar110