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

48 columns | Print definition?ERP 6.0  | APPL_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/SRM_CAN10CAN: Classification and Navigation5APPL_TYPECAN: Application Typenvarchar30
2/XFT/UG_001User Groups3APPL_TYPEApplication Typenvarchar30
3CTS_APPLIDENTSeCTS: Reserved Application Identifiers1APPL_TYPEeCTS: Application IDnvarchar300
4CTS_APPLIDENTSTeCTS: Texts for Reserved Application Identifiers1APPL_TYPEeCTS: Application IDnvarchar300
5GRACAPPLTYPEApplication type2APPL_TYPEApplication Typenvarchar100
6GRACSODREPDUMPSOD Reporting Framework content2APPL_TYPEApplication type for reportingnvarchar50
TOPAnalysis Process Designer
7RSANT_PR_APPLApplication Hierarchy for Processes in Table RSANT_PROCESS6APPL_TYPERestriction of the Range of Functions for Model Maintenancenvarchar160
8RSANT_PR_APPLCApplication Folders (User-Defined)6APPL_TYPERestriction of the Range of Functions for Model Maintenancenvarchar160
9RSANT_WB_TYPEApplication Types for Analysis Process Modeling1APPL_TYPERestriction of the Range of Functions for Model Maintenancenvarchar160
10RSANT_WB_TYPECApplication Types for Analysis Process Modeling1APPL_TYPERestriction of the Range of Functions for Model Maintenancenvarchar160
TOPArchiveLink
11TOADDSAP ArchiveLink check table DOK_type3APPL_TYPEApplicationnvarchar700
TOPBasis Technology R3
12/ISDFPS/SYS_LSCPSystem Landscape for the Distribution of Users3APPL_TYPESystem Typenvarchar30
TOPBusiness Analytics
13UAAPPLTYPEApplication Types Costing2APPL_TYPEApplication Type Costingnvarchar40
14UAAPPLTYPETText Table for UAAPPLTYPE2APPL_TYPEApplication Type Costingnvarchar40
TOPBusiness Planning and Simulation
15UPWB_CLASSESTable of Class Descriptors2APPL_TYPEApplicationnvarchar80
16UPWB_CLASSESTTable of Class Descriptors2APPL_TYPEApplicationnvarchar80
17UPWB_HIERARCHYTable of Class Hierarchy2APPL_TYPEApplicationnvarchar80
TOPCommon Functions
18INM_NAV_CTXINM Navigation Context2APPL_TYPEApplication Typenvarchar30
19INM_NAV_CTX_WINM Navigation Context Workcenter2APPL_TYPEApplication Typenvarchar30
TOPCustomer Interaction Center
20CRMC_CIC_ASP_AIC WinClient: ASP, application3APPL_TYPEIC WinClient: ASP, Application Typenvarchar150
21CRMC_CIC_ASP_TPIC WinClient: ASP, application type1APPL_TYPEIC WinClient: ASP, Application Typenvarchar150
22CRMC_CIC_ASP_TPTIC WinClient: ASP, application type (text)2APPL_TYPEIC WinClient: ASP, Application Typenvarchar150
TOPDistributed System Landscape
23/ISDFPS/ALE_SYSDFPS System Landscape: Connection Parameters and Flags23APPL_TYPESystem Typenvarchar30
24/ISDFPS/DIST_AGRUser Distribution Additional Roles2APPL_TYPESystem Typenvarchar30
25/ISDFPS/USR_FILTUser Distribution -> User Filter Settings2APPL_TYPESystem Typenvarchar30
TOPHelp Infrastructure for ABAP
26SAPGUIHC_FAQSHelp Center: FAQs3APPL_TYPEObject Typenvarchar40
27SAPGUIHC_LINKSHelp Center: Documents2APPL_TYPEObject Typenvarchar40
28SAPGUIHC_NOTESHelp Center: 'My Notes'2APPL_TYPEObject Typenvarchar40
29SAPHC_FAQS_APPLHelp Center Documents: Assignment to Applications3APPL_TYPEObject Typenvarchar40
30SAPHC_LINKS_APPLHelp Center Documents: Assignment to Applications3APPL_TYPEObject Typenvarchar40
31SAPHC_NOTESHelp Center Notes3APPL_TYPEObject Typenvarchar40
TOPHR Administrative Services
32T5SSCTRACKXSSSelf-Services: Tracking3APPL_TYPEType of Self-Service Applicationnvarchar160
TOPMobile Applications
33/ISDFPS/ME_ALSYSCopy of ALE_SYS Table4APPL_TYPESystem Typenvarchar30
TOPOverhead Cost Controlling
34KCR_T_APPLAllowed Data Types for Application Type2APPL_TYPEIdentifier for Application Typenvarchar30
35KCR_T_APPL_TEXTAllowed Data Types for Application Type: Text3APPL_TYPEIdentifier for Application Typenvarchar30
TOPPackage Tools
36AKB_EXCEPTObsolete: Usage Exceptions of Basis Objects by Application5APPL_TYPEObject Typenvarchar40
37AKB_EXCEPT2Obsolete: Shadow Table for AKB_EXCEPT5APPL_TYPEObject Typenvarchar40
38AKB_EXCEPTIONSObsolete: Usage Exceptions of Basis Objects by Application5APPL_TYPEObject Typenvarchar40
39AKB_EXCEPTIONS2Obsolete: Usage Exceptions of Basis Objects by Application5APPL_TYPEObject Typenvarchar40
40AKB_EXCEPT_TESTObsolete: Usage Exceptions of Basis Objects by Application5APPL_TYPEObject Typenvarchar40
41AKB_EXPT_TO_SENDObsolete: Usage Exceptions of Basis Objects by Application5APPL_TYPEObject Typenvarchar40
TOPPeople Centric UI Framework Customizing
42CRMC_BL_APPLApplication Scenario6APPL_TYPEApplication Typenvarchar10
TOPSession Manager
43BIW_PREFSPreferences for Business Information Warehouse3APPL_TYPEAttributes of the menunvarchar100
TOPTransport Organizer
44CTS_APPLTYPECTS: Supported values for application types2APPL_TYPEeCTS: Application IDnvarchar300
45CTS_APPLTYPETCTS: Text for supported application types (CTS_APPLTYPE)2APPL_TYPEeCTS: Application IDnvarchar300
46CTS_SY_DETAILSCTS: System details for handling of application types3APPL_TYPEeCTS: Application IDnvarchar300
TOPWeb Dynpro ALV for ABAP
47SALV_CSQ_TR_HEADTrace heads6APPL_TYPEApplication typenvarchar100
TOPWeb Services Tool
48CRMOST_EXCEPTUsage Exceptions of Basis Objects by Application5APPL_TYPEObject Typenvarchar40