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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

18 columns | Print definition?ERP 6.0  | FLAVOR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERS/ACTIVEPersonas: active flavor for a user4FLAVORPersonas: Flavor IDnvarchar400
2/PERS/ASSGNMNTSPersonas: Assignments of flavors to users3FLAVORPersonas: Flavor IDnvarchar400
3/PERS/FLAVORSPersonas: Flavors3FLAVORPersonas: Flavor IDnvarchar400
4/PERS/FLAVORS_TPersonas: Text table for Flavors3FLAVORPersonas: Flavor IDnvarchar400
5/PERS/SETTINGSPersonas: Settings stored globally, for user or for flavor4FLAVORPersonas: Flavor IDnvarchar400
6PRSNAS_ACTIVEPersonas: Active Flavor for a User4FLAVORPersonas: Flavor IDnvarchar400
7PRSNAS_ASSGNMNTSPersonas: Assignments of Flavors to Users3FLAVORPersonas: Flavor IDnvarchar400
8PRSNAS_FLAVORSPersonas: Flavors3FLAVORPersonas: Flavor IDnvarchar400
9PRSNAS_FLAVORS_TPersonas: Text Table for PRSNAS_FLAVORS3FLAVORPersonas: Flavor IDnvarchar400
10PRSNAS_SETTINGSPersonas: Settings Stored Globally for User or for Flavor4FLAVORPersonas: Flavor IDnvarchar400
11SATC_WL_HEAD"Worklist": Header (transactional data)2FLAVORFlavornvarchar10
12SRT_SR_URLServices Registry : URL table4FLAVORServices Registry: Flavornvarchar200
TOPASAP AcceleratedSAP
13SFLAVORIA: Roadmap Flavor1FLAVORIA: Flavor keynvarchar30
14SFLAVORTIA: Texttable for flavor of roadmap2FLAVORIA: Flavor keynvarchar30
15SROADMAPIA: Roadmap With Type and Flavor3FLAVORIA: Flavor keynvarchar30
TOPPrint and Output Management
16TFRT_INFOTypeface Repo - Font Info22FLAVORTypeface Repo - OpenType Flavor (TrueType/CompactFileFormat)nvarchar10
17TFRT_SRCH_KEYTypeface Repo - Table of Font key for search19FLAVORTypeface Repo - OpenType Flavor (TrueType/CompactFileFormat)nvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
18WBOBJECT_DATAData Table for Workbench Object10FLAVORnvarchar300