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
Without Description :: Without Description :: BI Content Analyzer
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0RSCONTIOBCHECK324Reference table check incompatible changes of InfoObjectsBI Content Analyzer
SQL:  selectupdate insert create

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

SELECT IOBJNM, OBJVERS, VERSION, CHECKCAT, IOBJTP, OBJTYP, CONTTIMESTMP, ATTRIBUT_NR, REFERNCE_IOBJ, COMPOUNDING, CHA_DATATP, CHA_INTLEN, RSDKYF_KYFTP, RSDKYF_DATATP, RSDKYF_UNINM, RSDKYF_AGGREGEN, TXTTABFL, NOLANGU, TXTTIMFL, LOWERCASE, IOBJ_DELETED, INCOMPATIBLE, IOBJ_CHECKED, NOTE_NR, CHECK_TEXT, CHECK_DATE, CHECKED_BY, MSGV2, MSGV3, TIMESTAMP, OWNER, CONTREL FROM RSCONTIOBCHECK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1IOBJNMInfoObjectnvarchar300CHAR(N' ')NoRSDIOBJNM Allow NULL? 
2OBJVERSObject versionchar10CHAR(N' ')NoRSOBJVERS Allow NULL? 
3VERSIONVersionnvarchar30NUMC(N'000')NoRSBCT_VERSION Allow NULL? 
4CHECKCATCategories for BI Content Checksnvarchar30CHAR(N' ')NoRSBCT_CHECKCAT Allow NULL? 
5IOBJTPType of an InfoObjectnvarchar30CHAR(N' ')YesRSIOBJTP Allow NULL? 
6OBJTYPBW: Object Type (TLOGO)nvarchar40CHAR(N' ')YesRSTLOGO Allow NULL? 
7CONTTIMESTMPContent time stamp: Last modification to the object by SAPdecimal150DEC((0))YesRSCONTTIMESTMP
8ATTRIBUT_NRCounternvarchar30NUMC(N'000')YesRSBCT_COUNTER Allow NULL? 
9REFERNCE_IOBJReference characteristicnvarchar300CHAR(N' ')YesRSCHABASNM Allow NULL? 
10COMPOUNDINGCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
11CHA_DATATPData Type in ABAP Dictionarynvarchar40CHAR(N' ')YesDATATYPE_D Allow NULL? 
12CHA_INTLENInternal Length of InfoObjects in BW - see Docunvarchar60NUMC(N'000000')YesRSDINTLEN Allow NULL? 
13RSDKYF_KYFTPKey figure typenvarchar30CHAR(N' ')YesRSKYFTP Allow NULL? 
14RSDKYF_DATATPData Type in ABAP Dictionarynvarchar40CHAR(N' ')YesDATATYPE_D Allow NULL? 
15RSDKYF_UNINMUnit InfoObject (currency/unit)nvarchar300CHAR(N' ')YesRSUNINM Allow NULL? 
16RSDKYF_AGGREGENUsual Aggregationnvarchar30CHAR(N' ')YesRSDAGGRGEN Allow NULL? 
17TXTTABFLText Table Existschar10CHAR(N' ')YesRSDTXTTABFL Allow NULL? 
18NOLANGUMaster data texts are language independent (flag)char10CHAR(N' ')YesRSNOLANGU Allow NULL? 
19TXTTIMFLTexts are time-dep.char10CHAR(N' ')YesRSDTXTTIMFL Allow NULL? 
20LOWERCASELowercase letters allowed/not allowedchar10CHAR(N' ')YesLOWERCASE Allow NULL? 
21IOBJ_DELETEDCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
22INCOMPATIBLECheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
23IOBJ_CHECKEDIndicator for confirmation incompatible changeschar10CHAR(N' ')YesRSBCT_OBJ_CHECKED Allow NULL? 
24NOTE_NRNote numbernvarchar100CHAR(N' ')YesRSBCT_NOTE Allow NULL? 
25CHECK_TEXTMessage Number or Comment to explain the exceptionnvarchar500CHAR(N' ')YesRSBCTMESSAGE Allow NULL? 
26CHECK_DATESystem Datenvarchar80DATS(N'00000000')YesSYDATUM Allow NULL? 
27CHECKED_BYPerson Responsible for a Repository Objectnvarchar120CHAR(N' ')YesRESPONSIBL Allow NULL? 
28MSGV2Message Variablenvarchar500CHAR(N' ')YesSYMSGV Allow NULL? 
29MSGV3Message Variablenvarchar500CHAR(N' ')YesSYMSGV Allow NULL? 
30TIMESTAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217DEC((0))YesTIMESTAMPL
31OWNEROwner (Person Responsible)nvarchar120CHAR(N' ')Yes*RSOWNER Allow NULL? 
32CONTRELContent releasenvarchar60CHAR(N' ')YesRSCONTREL Allow NULL? 
NamePrimaryUniqueTypeColumns
RSCONTIOBCHECK~0YesYesCLUSTEREDCHECKCAT, VERSION, OBJVERS, IOBJNM
RSCONTIOBCHECK~IX1NoNoNONCLUSTEREDIOBJNM, CHECKCAT, OBJVERS
RSCONTIOBCHECK~IX2NoNoNONCLUSTEREDOBJTYP, IOBJTP, VERSION, IOBJNM
RSCONTIOBCHECK~IX3NoNoNONCLUSTEREDOBJVERS, CHECKCAT, IOBJ_CHECKED