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

43 columns | Print definition?ERP 6.0  | SUBAREA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T7PIQ_DE_AR2SGRPMapping Subject Area to Subject Grouping3SUBAREASubject Areanvarchar30
2T7PIQ_DE_GSUBARTSubject Area4SUBAREASubject Areanvarchar30
3T7PIQ_DE_SUB2ARMapping Subject Government Level to Subject Area4SUBAREASubject Areanvarchar30
4T7PIQ_DE_SUBARSubject Area3SUBAREASubject Areanvarchar30
5T7PIQ_DE_SUBARTText Table for Subject Area4SUBAREASubject Areanvarchar30
TOPCross-Application Components
6CACNSC_SUBAREAProjectMarket: Subarea2SUBAREAProjectMarket: Areanvarchar40
7CACNSC_SUBAREATProjectMarket: Subarea Texts3SUBAREAProjectMarket: Areanvarchar40
8CACNS_PM_PROJEasyProjectMarket26SUBAREAProjectMarket: Areanvarchar40
TOPE-Recruiting
9HRP5125DB Table for Infotype 512537SUBAREASubarea of E-Recruitingnvarchar30
10HRP5133DB Table for Infotype 513323SUBAREASubarea of E-Recruitingnvarchar30
11HRP5135DB Table for Infotype 513529SUBAREASubarea of E-Recruitingnvarchar30
12HRP5136DB Table for Infotype 513629SUBAREASubarea of E-Recruitingnvarchar30
13HRP5137DB Table for Infotype 513729SUBAREASubarea of E-Recruitingnvarchar30
14HRP5138DB Table for Infotype 513829SUBAREASubarea of E-Recruitingnvarchar30
15HRP5139DB Table for Infotype 513929SUBAREASubarea of E-Recruitingnvarchar30
16HRP5140DB Table for Infotype 514029SUBAREASubarea of E-Recruitingnvarchar30
17HRP5141DB Table for Infotype 514129SUBAREASubarea of E-Recruitingnvarchar30
18HRP5142DB Table for Infotype 514229SUBAREASubarea of E-Recruitingnvarchar30
19HRP5143Database Table for Infotype 514329SUBAREASubarea of E-Recruitingnvarchar30
20HRP5144Database Table for Infotype 514429SUBAREASubarea of E-Recruitingnvarchar30
21HRP5145Database Table for Infotype 514529SUBAREASubarea of E-Recruitingnvarchar30
22T77RCF_ACT2PROCAssignment of Activity Types to Processes2SUBAREASubarea of E-Recruitingnvarchar30
23T77RCF_ACTTY2RPAssignment of Activities to Process Templates8SUBAREASubarea of E-Recruitingnvarchar30
24T77RCF_LOG_APPLApplications in E-Recruiting7SUBAREASubarea of E-Recruitingnvarchar30
25T77RCF_PROC2SUBAssignment of Processes to Subarea of E-Recruiting2SUBAREASubarea of E-Recruitingnvarchar30
26T77RCF_RCD2STATAssignment of Status Reason to Status2SUBAREASubarea of E-Recruitingnvarchar30
27T77RCF_ROLE2SUBAssignment of Roles in E-Recruiting to Subarea2SUBAREASubarea of E-Recruitingnvarchar30
28T77RCF_RP_ACTProcess Templates8SUBAREASubarea of E-Recruitingnvarchar30
29T77RCF_SP_IDDefinition of Start Pages (Standard)5SUBAREASubarea of E-Recruitingnvarchar30
30T77RCF_SP_IDCDefinition of Start Pages6SUBAREASubarea of E-Recruitingnvarchar30
TOPeCATT Extended Computer Aided Test Tool
31ECCUSTeCATT Customizing2SUBAREAeCATT Customizing Subareanvarchar300
TOPEmployee Self-Service
32T7XSSSERARArea Definition: Grouping of Subareas3SUBAREASubarea Keynvarchar400
33T7XSSSERARCXSS: Area definition: Grouping of subareas customer3SUBAREASubarea Keynvarchar400
34T7XSSSERSARSubarea Definition: Grouping of Services2SUBAREASubarea Keynvarchar400
35T7XSSSERSARBBasic Subarea Definition2SUBAREASubarea Keynvarchar400
36T7XSSSERSARBCXSS: Basic Subarea definition customer2SUBAREASubarea Keynvarchar400
37T7XSSSERSARBCTXSS: Basic Subarea definition text customer3SUBAREASubarea Keynvarchar400
38T7XSSSERSARBTBasic Subarea Definition Text3SUBAREASubarea Keynvarchar400
39T7XSSSERSARCXSS: Subarea definition: Grouping of services customer2SUBAREASubarea Keynvarchar400
TOPKnowledge Warehouse
40IWBENTRY_MIWB: Info Object Browser defaults2SUBAREAFunction Codenvarchar700
41IWBENTRY_SKEn: Info Object Browser Defaults2SUBAREAFunction Codenvarchar700
42IWBENTRY_UKEn: Info Object Browser Defaults2SUBAREAFunction Codenvarchar700
43IWBENTRY_VKEn: Info Object Browser Defaults2SUBAREAFunction Codenvarchar700