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

41 columns | Print definition?ERP 6.0  | CODEPAGE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FINFInterface definition33CODEPAGECode Pagenvarchar200
2/AIF/T_LFA_CONFLean File Adapter Configuration8CODEPAGECode Pagenvarchar720
3FIN_AR_QRY_CACHEFIN-AR: Cache for CPU-Intensive Database Queries7CODEPAGESAP Character Set IDnvarchar40
4IDXLOGIDoc Adapter RFC Logging10CODEPAGESAP Character Set IDnvarchar40
TOPALE Integration Technology
5EDI_CPINB_MDMPCode Pages for Various Languages in MDMP Inbox4CODEPAGECharacter set for connection using CPI-C portnvarchar40
6EDI_CPOUT_MDMPCode Pages for Various Languages4CODEPAGECharacter set for connection using CPI-C portnvarchar40
TOPAnti-Virus Protection
7VSCAN_SERVERVirus Scan Provider Definition7CODEPAGECode Page for the Virus Scan Providernvarchar40
TOPArchive Development Kit
8ARCH_CPCode Page for Displaying Archived Data3CODEPAGESAP Character Set IDnvarchar40
TOPBank Accounting
9REGUTTemSe - Administration Data32CODEPAGESAP Character Set IDnvarchar40
10TFPM042FFCPayment medium formats: Customer format parameters4CODEPAGESAP Character Set IDnvarchar40
TOPBasic Data
11NC301BIS-H: EDI - Agreements with Data Collection Points8CODEPAGESAP Character Set IDnvarchar40
12TN02SIS-H: Systems and System Attributes9CODEPAGESAP Character Set IDnvarchar40
TOPBasis Components
13/SSF/DHEADService Software Framework: Analysis/download control header11CODEPAGEnvarchar40
TOPCommunication Services Mail, Fax, SMS, Telephony
14SXCPDEFSAPconnect: Default Codepage for Each Send Type3CODEPAGESAP Character Set IDnvarchar40
15SXCPRECVSAPconnect: Language for Code Page2CODEPAGESAP Character Set IDnvarchar40
16SXCPSENDSAPconnect: Code Page for Language3CODEPAGESAP Character Set IDnvarchar40
17SXNODESSAPconnect: Communication nodes22CODEPAGESAP Character Set IDnvarchar40
TOPContract Accounts Receivable and Payable
18TFK042FPayment medium formats11CODEPAGESAP Character Set IDnvarchar40
TOPData Basis
19RSBFILEOpen Hub Destinations: Files11CODEPAGESAP Character Set IDnvarchar40
TOPData Retention Tool
20TXW_DIR2Data file log45CODEPAGECodepagenvarchar40
TOPDigital Signature
21TC71Digital Signature15CODEPAGESAP Character Set IDnvarchar40
TOPDirectory
22LDAPGATEWLDAP Connector12CODEPAGECode Page for the LDAP Connectornvarchar40
TOPElectronic Bank Statement
23FEB_IMP_SOURCEInformation about Import for Electronic Bank Statement6CODEPAGESAP Character Set IDnvarchar40
TOPI18N Unicode
24UM4SEPCPCodepages used generating entries in UMGSEP and UMGCOMCHAR1CODEPAGEnvarchar40
25UMGRTCPCache for Codepages which can be used as Default or Fallback1CODEPAGESAP Character Set IDnvarchar40
26UMGSEPCPCodepages used generating entries in UMGSEP and UMGCOMCHAR1CODEPAGESAP Character Set IDnvarchar40
27UMGTWININDXLog for INDX changes6CODEPAGESAP Character Set IDnvarchar40
TOPLocalization
28IDMX_DI_PSEPROFpse-file and parameter (entities)3CODEPAGESAP Character Set IDnvarchar40
TOPMigration
29TEMJOBIS-U Migration: Definition of Import Job10CODEPAGECode Page of Legacy Systemnvarchar40
TOPMonitoring
30CSMNUDATACSM CEN CCMS Data to be Processed7CODEPAGENot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPPeople Centric UI Framework Customizing
31CRMC_APPL_VIEWCharacteristics of BLVIEW4CODEPAGESAP Character Set IDnvarchar40
32CRMC_APPL_VIEWCCharacteristics of BLVIEW5CODEPAGESAP Character Set IDnvarchar40
TOPPeriodical Sales and Distribution
33TJKW0IS-M/SD: WBZ, Computer Center3CODEPAGESAP Character Set IDnvarchar40
TOPRFC
34RFCGORFC stub generation - generation of user parameters23CODEPAGECode page (character set) of a font familynvarchar40
TOPService Data Download
35/BDL/CONTABContent description for following data transmission14CODEPAGESAP Character Set IDnvarchar40
36/SDF/DB6PMCDDB2 Universal Database: Configuration Database62CODEPAGEsmallint50
37BDLCONTABContent description for following data transmission14CODEPAGESAP Character Set IDnvarchar40
38BDLDATCOLData container for download data15CODEPAGESAP Character Set IDnvarchar40
39BDLDTOCRFC download -- Data cluster table of contents14CODEPAGESAP Character Set IDnvarchar40
TOPTable History
40PRV_LOG_CPTable Logging: Codepages and Migration Times3CODEPAGESAP Character Set IDnvarchar40
TOPTransaction Manager
41TCORIC_FILETreasury; Messaging Interface: Configuration of File Adapter10CODEPAGECodepage of the channelnvarchar40