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

62 columns | Print definition?ERP 6.0  | APPL_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_CFG_OBJTable to store the document types of ICC applications2APPL_NAMEApplication Namenvarchar200
2/OPT/VIM_CFG_VERTable to store ICC Configuration data versions2APPL_NAMEApplication Namenvarchar200
3/OPT/VIM_ICC_CFGTable to store ICC Configuration data2APPL_NAMEApplication Namenvarchar200
4/OPT/X045Table to store ICC Configuration data versions2APPL_NAMEApplication Namenvarchar200
5/OPT/X052Table to store ICC Configuration data2APPL_NAMEApplication Namenvarchar200
6/OPT/Y045Table to store ICC Configuration data versions2APPL_NAMEApplication Namenvarchar200
7/OPT/Y052Table to store ICC Configuration data2APPL_NAMEApplication Namenvarchar200
8/OPT/Z045Table to store ICC Configuration data versions2APPL_NAMEApplication Namenvarchar200
9/OPT/Z052Table to store ICC Configuration data2APPL_NAMEApplication Namenvarchar200
10/UI5/TREP_FILESUI5 mapping table for property files with text entries3APPL_NAME30 Charactersnvarchar300
11BUTEOPAPPDefine / Store Application Names for EOP check.2APPL_NAMEApplication Namenvarchar200
12BUTEOPAPP_TText table for BUTEOPAPP3APPL_NAMEApplication Namenvarchar200
13BUTEOPARCH_CHECKApplication Function Modules register for Archiving Check2APPL_NAMEApplication Namenvarchar200
14BUTEOPARVDefine / Store Application Rule Variants for EOP Check2APPL_NAMEApplication Namenvarchar200
15BUTEOPARV_TText Table for BUTEOPARV2APPL_NAMEApplication Namenvarchar200
16BUTEOPFMApplication Function Modules registered for EOP Check2APPL_NAMEApplication Namenvarchar200
17BUTEOPFM_UNBLKApplication Function Modules registered for Unblock Check2APPL_NAMEApplication Namenvarchar200
18BUTEOPPRIORITYPriority table for Function Modules registered for EOP check2APPL_NAMEApplication Namenvarchar200
19BUTSORTSORT Details of Business Partners for each Application4APPL_NAMEApplication Namenvarchar200
20CVP_EOPAPPDefine / Store Application Names for EoP check3APPL_NAMEApplication Namenvarchar200
21CVP_EOPAPPTDefine / Store Application Name descriptions for EoP check3APPL_NAMEApplication Namenvarchar200
22CVP_EOPARVDefine / Store Application Rule Variants for EoP Check3APPL_NAMEApplication Namenvarchar200
23CVP_EOPARVTDefine / Store Application Rule Variants for EoP3APPL_NAMEApplication Namenvarchar200
24CVP_EOPCLASSApplication Classes Registered for EoP Check3APPL_NAMEApplication Namenvarchar200
25CVP_EOPCLASSPApplication Classes Registered for EoP Check-Priorities3APPL_NAMEApplication Namenvarchar200
26CVP_EORTEoRT Details of Customer/Vendor/Contact for each application7APPL_NAMEApplication Namenvarchar200
27CVP_SORTSoRT Details of Customer/Vendor/Contact for each application7APPL_NAMEApplication Namenvarchar200
28FDT_BRS_CC_0001BRS Managed System: Generated classes + XML17APPL_NAMEFDT: Namenvarchar300
29IRW_LTCDETables for CDE Extraction3APPL_NAMEApplication Namenvarchar60
30N1WD_PROFILEData of User Profile3APPL_NAMEApplication Namenvarchar300
31SAIS_LOGLog for Usage of Audit Log4APPL_NAMECheck Application Namenvarchar300
32SRAL_CONFIG_WDRAL: Configuration for Web Dynpro ABAP4APPL_NAMEWeb Dynpro: Application Namenvarchar300
33SRAL_FIELDS_WDRAL: Channel specific fields4APPL_NAMEWeb Dynpro: Application Namenvarchar300
34T7PIQAPPStudent Self Service Adobe Applications3APPL_NAMEApplication Namenvarchar800
TOPAppointment Calendar
35TSCTFGROUPAssignment of Application to Time Period Rule1APPL_NAMEApplication ID for Assignment to This Time Periodnvarchar100
36TSCTFGRTApplication-Dependent Texts for Time Period Description2APPL_NAMEApplication ID for Assignment to This Time Periodnvarchar100
TOPBasic Data
37NCEVNTHNDL_ORDEREvent Handler: Appl., Context for Obj. & Event -> Sequence2APPL_NAMEApplication Namenvarchar300
TOPBRFplus - ABAP-Based Business Rules
38FDT_ADMN_0201FDT: GTABKEY - APPL Name + UUID Registration2APPL_NAMEFDT: Namenvarchar300
39FDT_ADMN_0202FDT: GTABKEY - FNCT Name + UUID Registration2APPL_NAMEFDT: Namenvarchar300
TOPClinical System
40N2CLIO_TESTDATAClinical Overview: Test Data3APPL_NAME30 Charactersnvarchar300
TOPData Retention Tool
41TXX_APPLValue Table: Applications2APPL_NAMEName of Application (FI, CO, ... )nvarchar60
42TXX_APPLTValue Table: Applications3APPL_NAMEName of Application (FI, CO, ... )nvarchar60
43TXX_ARCH_OBJArchiving Object Assignment ILM3APPL_NAMEName of Application (FI, CO, ... )nvarchar60
TOPEmployee Self-Service for Concurrent Employment
44T7XSSCESTATFLTRStatus validity filtering for an assignment6APPL_NAMEApplication Namenvarchar2550
45T7XSSCE_GRPGroup definition settings for ESS CE applications5APPL_NAMEApplication Namenvarchar2550
TOPHelp Infrastructure for ABAP
46SAPGUIHC_FAQSHelp Center: FAQs4APPL_NAMEObject Name in Object Directorynvarchar400
47SAPGUIHC_LINKSHelp Center: Documents3APPL_NAMEObject Name in Object Directorynvarchar400
48SAPGUIHC_NOTESHelp Center: 'My Notes'3APPL_NAMEObject Name in Object Directorynvarchar400
49SAPHC_FAQS_APPLHelp Center Documents: Assignment to Applications4APPL_NAMEObject Name in Object Directorynvarchar400
50SAPHC_LINKS_APPLHelp Center Documents: Assignment to Applications4APPL_NAMEObject Name in Object Directorynvarchar400
51SAPHC_NOTESHelp Center Notes4APPL_NAMEObject Name in Object Directorynvarchar400
TOPHR Administrative Services
52T5SSCTRACKXSSSelf-Services: Tracking5APPL_NAMEName of Self-Service Applicationnvarchar2550
TOPPackage Tools
53AKB_EXCEPTObsolete: Usage Exceptions of Basis Objects by Application6APPL_NAMEObject Name in Object Directorynvarchar400
54AKB_EXCEPT2Obsolete: Shadow Table for AKB_EXCEPT6APPL_NAMEObject Name in Object Directorynvarchar400
55AKB_EXCEPTIONSObsolete: Usage Exceptions of Basis Objects by Application6APPL_NAMEObject Name in Object Directorynvarchar400
56AKB_EXCEPTIONS2Obsolete: Usage Exceptions of Basis Objects by Application6APPL_NAMEObject Name in Object Directorynvarchar400
57AKB_EXCEPT_TESTObsolete: Usage Exceptions of Basis Objects by Application6APPL_NAMEObject Name in Object Directorynvarchar400
58AKB_EXPT_TO_SENDObsolete: Usage Exceptions of Basis Objects by Application6APPL_NAMEObject Name in Object Directorynvarchar400
TOPPublic Sector Contract Accounts Receivable and Payable
59TFMCA_FPF_BRFPAPFPF: determination of BRF+ application and function4APPL_NAMEBRFplus Application namenvarchar300
TOPUser Administration
60SMUM_BSAPPBusiness Service ID mapping to BADi2APPL_NAMEBusiness Service application identifiernvarchar150
TOPWeb Service and SOAP - ABAP
61SRT_SYST_APPLApplication Directory4APPL_NAMESRT Application Namenvarchar1200
TOPWeb Services Tool
62CRMOST_EXCEPTUsage Exceptions of Basis Objects by Application6APPL_NAMEObject Name in Object Directorynvarchar400