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

45 columns | Print definition?ERP 6.0  | DISABLED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPC_SUS_COLDEFDefinition of Displayable Fields in a Table Item6DISABLEDDisabled HTMLB Fieldnvarchar10
2CNVMBTITEMSCheck items5DISABLEDFlag (X or Blank)nvarchar10
3DOUI_ELEMDBOS Cockpit: Screen Element21DISABLEDDBOSC-CR: Generated ID (30)nvarchar300
4HRHAPCN_FPROPSField Properties12DISABLEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
5T5GPBSH_CHAMapping of Challenge group to disability3DISABLEDHESA: Is disablednvarchar10
6T5UPBS01FAVORITENature of Actions Favorites Tree11DISABLEDFlag (X or Blank)nvarchar10
7T5UPBS01TREEPersonnel Actions Tree11DISABLEDFlag (X or Blank)nvarchar10
8ZSSAUTHCHKTable for auth. check in Crystal Info/Crystal Reports4DISABLEDCHAR01 data element for SYSTnvarchar10
TOPApplication Framework
9USMD0020Data Model: Entity Types24DISABLEDStandard Delivery Statusnvarchar10
10USMD0022Data Model: Attributes of Ent.Types w/Generated Persistence12DISABLEDStandard Delivery Statusnvarchar10
11USMD0023Data Model: Relationships of Entity Types10DISABLEDStandard Delivery Statusnvarchar10
TOPASAP AcceleratedSAP
12SQAKONFCConfiguration Group Contents6DISABLEDFlag: Entry deactivatednvarchar10
13SQAKONFGConfiguration Subgroups5DISABLEDFlag: Entry deactivatednvarchar10
TOPBAPI Tools for BAPIs see Note 813411
14BAPITOOLSTools in the BAPI development environment (Transaction9DISABLEDSelectionnvarchar10
TOPBasis Components
15/CRYSTAL/AUTHCHKAuthorization check entries5DISABLEDCHAR01 data element for SYSTnvarchar10
TOPCCMS Database Monitors for Oracle
16ORAPARTALAnalysed Data for Oracle Partition Engine10DISABLEDnvarchar10
TOPData Basis
17RSCNVMONSTEPSSteps of any operation on a BW Object8DISABLEDSingle-Character Indicatornvarchar10
TOPData Replication Framework
18MDG_BUS_SYS_TECHTechnical information of a Business System10DISABLEDBusiness System Temporarily Disabled for Replicationnvarchar10
TOPEnd User Technology
19RSZTREESTRUCTURETable with Example Description of a Tree Structure9DISABLEDBooleannvarchar10
TOPForce Element
20/ISDFPS/WFCUTREECustomizing Table for Workflow Customizing Tree7DISABLEDFlag (X or Blank)nvarchar10
TOPFront Office
21EWAACTAction Manager: Actions4DISABLEDIndicator: action blockednvarchar10
TOPGeneral Application Functions
22CRMD_PARTNERPartners22DISABLEDNo INBOX Selection for the Partnernvarchar10
TOPIncentive and Commission Management ICM
23TCACS_NDPROCustomizing Table for Tree Profiles16DISABLEDFlag (X or Blank)nvarchar10
TOPMaxDB
24SDBTREEDEFSAP DB: CCMS Navigation Trees - Node Definition6DISABLEDFlag (X or Blank)nvarchar10
TOPMedia Product Sales and Distribution
25TJKSDTOOLBARFUNCIS-M: Toolbar Functions12DISABLEDPushbutton Inactivenvarchar10
TOPMonitoring
26SAPWLTREEGSAP Workload: Nodes for ST03G Tree Controls7DISABLEDFlag (X or Blank)nvarchar10
TOPPatient Management
27NWVIEW_FCDFunction Bar: Function Code Data10DISABLEDnvarchar10
TOPPrice Planning Workbench
28WRFT_PPW_TSHP_CTree Profile Column Attributes9DISABLEDHiddennvarchar10
29WRFT_PPW_TSHP_CDDefault for Tree Profile Column Attributes8DISABLEDHiddennvarchar10
TOPRegulatory reporting for insurance companies
30TISSR_TP_ALVNODEISSR: Einstellung ALV-Tree-Modell Knotenstrukturen13DISABLEDFlag (X oder Blank)nvarchar10
TOPSAP Business Partner
31TBZS3BDT Search Help: Views4DISABLEDCheckboxnvarchar10
TOPSAP Business Workflow
32SWFRPROCTRWorkflow: Process Data (Default Table)15DISABLEDCheckboxnvarchar10
33SWN_SUBSWF Notif: Subscriptions9DISABLEDDeactivatednvarchar10
TOPSpecification 2
34SPCM_DISP_MENUAction table for A&D Displaytool (menu)9DISABLEDFlag indicating function is activenvarchar10
TOPTranslation Tools
35INDTABSShort Text Conversion: Table Attributes9DISABLEDSingle-Character Indicatornvarchar10
TOPUI Configuration Design Layer
36BSP_DLC_DESIGNDesign layer: Design7DISABLEDDisplay Onlynvarchar10
37BSP_DLC_SDESIGNDesign layer: Design6DISABLEDDisplay Onlynvarchar10
TOPUse Subcomponents
38SIN_T_LINKNavigation Area of SAPBPT Workplace7DISABLEDFlag (X or Blank)nvarchar10
TOPWeb Service and SOAP - ABAP
39SDB_CLSYSTEM_VALClassification System Values (Local Cache)8DISABLEDnvarchar50
TOPWeb Service Tools - ABAP
40ERCLASS_LOCALUDDI local system Classifications, client dependent13DISABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
41ERCLASS_NONSAPUDDI Classifications SAP, transportable, client independent17DISABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
42ERCLASS_SAPUDDI Classifications SAP, transportable, client independent17DISABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
43SCGCLASSIFICATONOLD: Consumer group classifications12DISABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
44SCGR_CLASSConsumer group classifications14DISABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPWeb Services Tool
45CRMC_WST_DESIGNOpen Services Tool: Design7DISABLEDDisplay Onlynvarchar10