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
Financials :: Financials Basis
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0UGMD2150501FIN Master Data: Active (Role-Indep.) Definition of FieldsFinancials Basis
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, FIELDNAME, TIMESTMP, TYPE, BASE_FLD, UNIT_FNAME, HAS_TEXTTABLE, HAS_CHECKTABLE, HAS_FIXVAL, HAS_HIERARCHY, INTLEN, INTTYPE, DECIMALS, DATATYPE, LENG, ROLLNAME, OUTPUTLEN, ORIGIN, ATRONLYFL, CONVEXIT, HAS_TXTSH, HAS_TXTMI, HAS_TXTLG, TIMDEPFL, HAS_TEXTTAB, HAS_CHECKTAB, CHNTAB, CHTTAB, TXTTAB, TEXT_TIMEDEP, LOWERCASE, NOLANGU, FIXCUKY, FIXUNIT, AGGRGEN, AGGREXC, AGGRCHA, KYFTP, UNIQUE_INDEPFLD, ONLY_ONE_HRYNAME, ONLY_ONE_ROOT, DEPENDENT_HRYNM, EDGE_VERSION_DEP, EDGE_TIME_DEP, LINKED_FIELD, IMPLEDGE_ATTR, IS_DOC_ATTR, CHATP, TIMESTAMP, UNAME FROM UGMD2150
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2FIELDNAMEFIN Master Data: Field Namenvarchar300CHAR(N' ')No*UG_FIELDNAME Allow NULL? 
3TIMESTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
4TYPEFIN Master Data: Field Type: Characteristic or Key Figurechar10CHAR(N' ')YesUG_FIELDTYPE Allow NULL? 
5BASE_FLDFIN Master Data: Field Namenvarchar300CHAR(N' ')Yes*UG_FIELDNAME Allow NULL? 
6UNIT_FNAMEFIN Master Data: Field Namenvarchar300CHAR(N' ')Yes*UG_FIELDNAME Allow NULL? 
7HAS_TEXTTABLEFIN Master Data: Text Table Exists (ind.)char10CHAR(N' ')YesUG_TXTTAB_FL Allow NULL? 
8HAS_CHECKTABLEFIN Master Data: Check Table Exists (indicator)char10CHAR(N' ')YesUG_CHKTAB_FL Allow NULL? 
9HAS_FIXVALFIN Master Data: Domain Values Exist (indicator)char10CHAR(N' ')YesUG_FIXVAL_FL Allow NULL? 
10HAS_HIERARCHYFIN Master Data: With Hierarchies (indicator)char10CHAR(N' ')YesUG_HRY_EXIST_FL Allow NULL? 
11INTLENInternal Length in Bytesnvarchar60NUMC(N'000000')YesINTLEN Allow NULL? 
12INTTYPEABAP data type (C,D,N,...)char10CHAR(N' ')YesINTTYPE Allow NULL? 
13DECIMALSNumber of Decimal Placesnvarchar60NUMC(N'000000')YesDECIMALS Allow NULL? 
14DATATYPEData Type in ABAP Dictionarynvarchar40CHAR(N' ')YesDATATYPE_D Allow NULL? 
15LENGLength (No. of Characters)nvarchar60NUMC(N'000000')YesDDLENG Allow NULL? 
16ROLLNAMEData element (semantic domain)nvarchar300CHAR(N' ')Yes*ROLLNAME Allow NULL? 
17OUTPUTLENOutput Lengthnvarchar60NUMC(N'000000')YesOUTPUTLEN Allow NULL? 
18ORIGINFIN Master Data: Storage Location of a Characteristictinyint30INT1((0))YesUG_ORIGIN
19ATRONLYFLFIN Master Data: Characteristic Is an Attribute Only (ind.)char10CHAR(N' ')YesUG_ATRONLY_FL Allow NULL? 
20CONVEXITConversion Routinenvarchar50CHAR(N' ')YesCONVEXIT Allow NULL? 
21HAS_TXTSHFIN Master Data: Short Text Exists (ind.)char10CHAR(N' ')YesUG_TXTSH_FL Allow NULL? 
22HAS_TXTMIFIN Master Data: Medium Text Exists (ind.)char10CHAR(N' ')YesUG_TXTMI_FL Allow NULL? 
23HAS_TXTLGFIN Master Data: Long Text Exists (ind.)char10CHAR(N' ')YesUG_TXTLG_FL Allow NULL? 
24TIMDEPFLFlag: Master data is time-dependentchar10CHAR(N' ')YesRSTIMDEPFL Allow NULL? 
25HAS_TEXTTABFIN Master Data: Text Table Exists (ind.)char10CHAR(N' ')YesUG_TXTTAB_FL Allow NULL? 
26HAS_CHECKTABFIN Master Data: Check Table Exists (indicator)char10CHAR(N' ')YesUG_CHKTAB_FL Allow NULL? 
27CHNTABTable Namenvarchar300CHAR(N' ')Yes*TABNAME Allow NULL? 
28CHTTABTable Namenvarchar300CHAR(N' ')Yes*TABNAME Allow NULL? 
29TXTTABTable Namenvarchar300CHAR(N' ')Yes*TABNAME Allow NULL? 
30TEXT_TIMEDEPFIN Master Data: Texts Are Time-dependent (ind.)char10CHAR(N' ')YesUG_TXTTIM_FL Allow NULL? 
31LOWERCASELowercase letters allowed/not allowedchar10CHAR(N' ')YesLOWERCASE Allow NULL? 
32NOLANGUFIN Master Data: Texts are Language-independent (ind.)char10CHAR(N' ')YesUG_NOLANGU_FL Allow NULL? 
33FIXCUKYFixed currencynvarchar50CUKY(N' ')Yes*RSFIXCUKY Allow NULL? 
34FIXUNITFixed Unit of Measurenvarchar30UNIT(N' ')Yes*RSFIXUNIT Allow NULL? 
35AGGRGENUsual aggregationnvarchar30CHAR(N' ')YesRSAGGRGEN Allow NULL? 
36AGGREXCException aggregationnvarchar30CHAR(N' ')YesRSAGGREXC Allow NULL? 
37AGGRCHAReference characteristic for exception aggregationnvarchar300CHAR(N' ')YesRSAGGRCHA Allow NULL? 
38KYFTPKey figure typenvarchar30CHAR(N' ')YesRSKYFTP Allow NULL? 
39UNIQUE_INDEPFLDFIN Master Data: Independent Field is Fixed in Hier. (ind.)char10CHAR(N' ')YesUG_UNIQINDEP_FL Allow NULL? 
40ONLY_ONE_HRYNAMEFIN Master Data: Only One Hierarchy is Permitted (ind.)char10CHAR(N' ')YesUG_ONLYONEHRY_FL Allow NULL? 
41ONLY_ONE_ROOTFIN Master Data: Only One Rootnode Permitted in Hier. (ind.)char10CHAR(N' ')YesUG_ONLYONEROOT_FL Allow NULL? 
42DEPENDENT_HRYNMFIN Master Data: Hierarchy Name is Compounded (indicator)char10CHAR(N' ')YesUG_DEPHRYNM_FL Allow NULL? 
43EDGE_VERSION_DEPFIN Master Data: Hierarchy Structure Version-dependent (ind)char10CHAR(N' ')YesUG_EDGEVERSDEP_FL Allow NULL? 
44EDGE_TIME_DEPFIN Master Data: Hierarchy Structure is Time-dependent (ind)char10CHAR(N' ')YesUG_EDGETIMEDEP_FL Allow NULL? 
45LINKED_FIELDFIN Master Data: Field Namenvarchar300CHAR(N' ')Yes*UG_FIELDNAME Allow NULL? 
46IMPLEDGE_ATTRFIN Master Data: w/Attributes at Implicit Edges (indicator)char10CHAR(N' ')YesUG_IMPLEDGEATTR_FL Allow NULL? 
47IS_DOC_ATTRFI Master Data: Characteristic as Document Attribute Allowedchar10CHAR(N' ')YesUG_DOC_FL Allow NULL? 
48CHATPCharacteristic Typenvarchar30CHAR(N' ')YesUG_CHATP Allow NULL? 
49TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
50UNAMEUser Namenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
NamePrimaryUniqueTypeColumns
UGMD2150~0YesYesCLUSTEREDMANDT, FIELDNAME