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

69 columns | Print definition?ERP 6.0  | APPLID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_AD_PWLDefault POWL Application for Advanced Search3APPLIDApplication IDnvarchar300
2/UI2/POWL_APPLIDRegistration of POWL APPLID for POWL OData service1APPLIDApplication IDnvarchar300
3/UI2/POWL_QUERYAssignment of POWL query to APPLID for POWL OData service1APPLIDApplication IDnvarchar300
4/UI2/POWL_QUERYKAssignment of POWL query key for POWL OData service1APPLIDApplication IDnvarchar300
5CNV_20100_REPPARTable is obsolete4APPLIDApplication ID for reporting treesnvarchar40
6RSBPCW_UPD_LOGBPC Work Status - Locks Update Log Table2APPLIDBPC: Application IDnvarchar200
7TPDASESSIONWPTPDA: Debug Sessions - BPs1APPLIDTPDA: ID des Debugger Framework Verwendersnvarchar200
TOPCross-Application Components
8CMPERSAPPLPersonalization: Application Hierarchy1APPLIDPersonalization Application Namenvarchar300
9CMPERSINDXPersonalization: Field Catalog3APPLIDPersonalization Application Namenvarchar300
10CMPERSPARMPersonalization: User Settings4APPLIDPersonalization Application Namenvarchar300
11WPPERSAPPLPersonalization: Application Hierarchy1APPLIDPersonalization Application Namenvarchar300
12WPPERSINDXPersonalization: Field Catalog3APPLIDPersonalization Application Namenvarchar300
13WPPERSPARMPersonalization: User Settings4APPLIDPersonalization Application Namenvarchar300
TOPForms
14T7XSS_GRT_IFR_DCustomizing table for Iframe in the GRT based applications2APPLIDESS rep.framework: Application ID of front-end applicationnvarchar300
15T7XSS_SER_RFWESS rep.framwork: Mapping of Application id to abap class1APPLIDESS rep.framework: Application ID of front-end applicationnvarchar300
TOPHelp Infrastructure for ABAP
16HCSKW_APPLApplication (for Assignment to KW Documents)2APPLIDID of Applicationint100
17HCSKW_APPLASSKW Document: Assignment to Applications3APPLIDID of Applicationint100
TOPInformation System
18COCF_MD_ADM_MULDTable for Multidimensional analysis for manufacturing dash b2APPLIDApplication ID for Manufacturing Dashboardnvarchar140
19COCF_MD_ADM_SYSTMandash System Status Customization table2APPLIDApplication ID for Manufacturing Dashboardnvarchar140
20COCF_MD_APL_TEXTMaintain Application ID for Manufacturing DashBoard Text tab3APPLIDApplication ID for Manufacturing Dashboardnvarchar140
21COCF_MD_APPL_TXTMaintain Application ID for Manufacturing Dash Board2APPLIDApplication ID for Manufacturing Dashboardnvarchar140
22COCF_MD_REF_TIMETable for minimum refresh time2APPLIDApplication ID for Manufacturing Dashboardnvarchar140
23COCF_MD_TIM_BUKTTime bucket customization2APPLIDApplication ID for Manufacturing Dashboardnvarchar140
24COCF_MD_TMBUKTXTtime bucket desc3APPLIDApplication ID for Manufacturing Dashboardnvarchar140
25COCF_MD_VRNT_GRPCOCF MANDASH Overall/Group Variant Table2APPLIDApplication ID for Manufacturing Dashboardnvarchar140
TOPMaster Recipe
26KALCMaterial Quantity Calculation - Formulas2APPLIDApplication of material quantity calculationnvarchar20
27KALTMaterial Quantity Calculation: Header2APPLIDApplication of material quantity calculationnvarchar20
TOPMusing Tools
28WDKQAPPLIDMapping of InfoSet Query POWL Types to APPLID's2APPLIDApplication IDnvarchar300
TOPOverhead Cost Controlling
29REPPAPPLReporting CO-OM : Applications for use of user settings2APPLIDUser settings for CO-OM reporting: Application IDnvarchar40
30REPPARMSReporting CO-OM : User settings3APPLIDApplication ID for reporting treesnvarchar40
31REPPINDXCO-OM Reporting: Field Catalog for Screens for User Settings4APPLIDUser settings for CO-OM reporting: Application IDnvarchar40
TOPPersonal Object Worklist
32POWL_ACT_QUERYquery activation data3APPLIDApplication IDnvarchar300
33POWL_CATEGORYCategory definition5APPLIDApplication IDnvarchar300
34POWL_CHIP_CONFIGMaintain POWL Chips2APPLIDParent Application IDnvarchar300
35POWL_QUERY_ROLQuery - Role assignment2APPLIDApplication IDnvarchar300
36POWL_QUERY_USRQuery - User assignment by admin2APPLIDApplication IDnvarchar300
37POWL_TYPE_ROLType - Role assignment2APPLIDApplication IDnvarchar300
38POWL_TYPE_USRType - User assignment2APPLIDApplication IDnvarchar300
TOPPersonalization Framework
39FPB_PERSAPPLPersonalization: Application Hierarchy1APPLIDPersonalization Application Namenvarchar300
40FPB_PERSAPPLFLDPersonalization: Characteristics of Application Hierarchy1APPLIDPersonalization Application Namenvarchar300
41FPB_PERSAPPLTPersonalization: Application Hierarchy Texts1APPLIDPersonalization Application Namenvarchar300
42FPB_PERSDIALOGPersonalization: Dialogs and Application Hierarchy2APPLIDPersonalization Application Namenvarchar300
43FPB_PERSPARMPersonalization: User Settings4APPLIDPersonalization Application Namenvarchar300
TOPPortal Content
44ISTNLMOBNObject-Based Navigation - Definition of Activities2APPLIDIS-T: Application IDnvarchar300
45ISTNLMOBNFLObject-Based Navigation - Field Names Definition With Links2APPLIDIS-T: Application IDnvarchar300
46ISTNLMOBNFLPARParameter for Object-Based Navigation (Fields/Links)2APPLIDIS-T: Application IDnvarchar300
47ISTNLMOBNPARIS-T Parameter for Object-Based Navigation (Activities)2APPLIDIS-T: Application IDnvarchar300
48ISTNLMOBNTIS-T Definition of Object-Based Navigation3APPLIDIS-T: Application IDnvarchar300
TOPPosition Budgeting and Control
49T77HRFPMFTEREOC0Groupings for Activating the Reassignment Lock2APPLIDApplication Category for Financing Rules Checknvarchar40
50T77HRFPMFTEREOC1Groupings for Activating the Reassignment Lock3APPLIDApplication Category for Financing Rules Checknvarchar40
51T77HRFPMFTEREOCAPeriods for Activation of Reassignment Lock2APPLIDApplication Category for Financing Rules Checknvarchar40
52T77HRFPMFTEREOCDProposal Value for Validity End Date of Reassignment Lock2APPLIDApplication Category for Financing Rules Checknvarchar40
53T77HRFPM_FTE_WB0Groupings for Activating the Reassignment Lock2APPLIDApplication Category for Financing Rules Checknvarchar40
54T77HRFPM_FTE_WB1Groupings for Activating the Reassignment Lock3APPLIDApplication Category for Financing Rules Checknvarchar40
55T77HRFPM_FTE_WBAPeriods for Activation of Reassignment Lock2APPLIDApplication Category for Financing Rules Checknvarchar40
TOPSyntax, Compiler, Runtime
56TPDAOPTIONSTPDA: Optionen1APPLIDTPDA: ID des Debugger Framework Verwendersnvarchar200
57TPDAPRESUITPDA: Default Settings - tpdasubsc/tpdasubscarea Additions1APPLIDTPDA: ID of the Debugger Framework Usernvarchar200
58TPDASESSIONBP1APPLIDTPDA: ID of the Debugger Framework Usernvarchar200
59TPDASESSIONSTPDA: Debug Sessions1APPLIDTPDA: ID des Debugger Framework Verwendersnvarchar200
60TPDASESSIONSSETTTPDA: Debug Sessions - Einstellungen1APPLIDTPDA: ID des Debugger Framework Verwendersnvarchar200
61TPDASESSIONSTTPDA: Debug Sessions Text1APPLIDTPDA: ID des Debugger Framework Verwendersnvarchar200
62TPDASUBSCTPDA: Subscreens for Subscreen Tree1APPLIDTPDA: ID of the Debugger Framework Usernvarchar200
63TPDASUBSCAREATPDA: Subscreen Tree - Areas (Occupation)1APPLIDTPDA: ID of the Debugger Framework Usernvarchar200
64TPDATABTEXTTPDA: Voreistellungen -Texte der Desktops1APPLIDTPDA: ID des Debugger Framework Verwendersnvarchar200
TOPVehicle Management System
65DPVMSC_APPLIDOVMS DP : Determine Powerlist3APPLIDApplication IDnvarchar300
TOPWeb Service and SOAP - ABAP
66SRT_UTIL_ERRLOGSRT Utilities: Error Log Data24APPLIDnvarchar320
67SRT_UTIL_LOGSRT Utilities: Error Log Data22APPLIDnvarchar320
68SRT_UTIL_PERFSRT Utilities: Performance Trace Data2APPLIDnvarchar320
69SRT_UTIL_TRCPERFSRT Utilities: Performance Trace Data16APPLIDnvarchar320