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

38 columns | Print definition?ERP 6.0  | ANAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPC_CMS_CONFIGBBP-CMS: Configdata table2ANAMEApplication Namenvarchar30
2BBPC_CMS_XML_STRBBP-CMS: XML String table for IBF metadata3ANAMEApplication Namenvarchar30
3BBPD_CMS_APLNApplication that will use the xml files2ANAMEApplication Namenvarchar30
4BBPD_CMS_APLN_TApplication text table using xml files3ANAMEApplication Namenvarchar30
5BBPD_CMS_DIDDataID table2ANAMEApplication Namenvarchar30
6BBPD_CMS_DID_TDataID text table3ANAMEApplication Namenvarchar30
7CNVCMIS_A_1_BADIExit: Implementation side: Attributes9ANAMELast changed bynvarchar120
8T5F99CLASSReference classes7ANAMEAttribute Namenvarchar300
9TCY40KDefinition of control4ANAMECreator of flow controlnvarchar120
10ZIDES_USR02Logon data of certain users11ANAMECreator of the User Master Recordnvarchar120
11ZUSR02Users and passwords11ANAMECreator of the User Master Recordnvarchar120
TOPAuthentication and SSO
12USR02Logon Data (Kernel-Side Use)11ANAMECreator of the User Master Recordnvarchar120
TOPCharacteristics
13CABNCharacteristic39ANAMEName of Person who Created the Objectnvarchar120
14CABNNEWCharacteristic39ANAMEName of Person who Created the Objectnvarchar120
TOPClasses
15KLAHClass Header Data10ANAMEName of Person who Created the Objectnvarchar120
TOPConstruction Industry
16T5DB9Construction Pay Evaluation Records for Social Fund Proc.22ANAMEEdited Name (Sortable)nvarchar200
TOPCustomer Enhancements
17SXC_ATTRExit: Implementation side: Attributes5ANAMELast changed bynvarchar120
TOPData Collection
18TKCOUSAP-EIS: Key description for object class3ANAMEField Namenvarchar300
TOPEnvironment
19LCABNCharacteristic39ANAMEName of Person who Created the Objectnvarchar120
20LKLAHClass Header (Special Objects)10ANAMEName of Person who Created the Objectnvarchar120
TOPMigration
21TEMFIRMAIS-U mig.: company11ANAMEUser Namenvarchar120
22TEMUSIS-U Mig.: Managmnt25ANAMEUser Namenvarchar120
TOPProduct Catalog
23TWIC8000Online store: Profile for product presentation5ANAMEDisplay material descriptionnvarchar10
TOPProduct Safety
24TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions14ANAMEName of Person who Created the Objectnvarchar120
TOPProduction Optimization Interface POI
25TCBP_MODContains all supply chain planning models5ANAMEPerson responsible for creation and maintenance of modelnvarchar120
TOPSales Plan
26LISAKTBackground Planning Activities7ANAMEMacro namenvarchar100
TOPSamples and SPC
27QASHQuality control chart40ANAMEName of Person Who Changed Objectnvarchar120
28QASTControl chart track22ANAMEName of Person Who Changed Objectnvarchar120
29QPSHControl chart types15ANAMEName of Person Who Changed Objectnvarchar120
30QPSHTTexts for control chart types5ANAMEName of Person Who Changed Objectnvarchar120
31QPSPSPC criterion6ANAMEName of Person Who Changed Objectnvarchar120
32QPSPTTexts for SPC criteria5ANAMEName of Person Who Changed Objectnvarchar120
33QPSTControl chart track13ANAMEName of Person Who Changed Objectnvarchar120
34QPSTTTexts for control chart tracks7ANAMEName of Person Who Changed Objectnvarchar120
TOPUSA
35PA0566HR Master Record: Infotype 056638ANAMEQDRO Attorney Namenvarchar400
TOPUser and Authorization Management
36USR06Additional Data per User8ANAMEChargeable Usernvarchar120
37USR06SYSSystem-Specific User Classification (License-Related)9ANAMEChargeable Usernvarchar120
TOPVariant Configuration
38KRIFRichie Riffle9ANAMEName of Person who Created the Objectnvarchar120