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

Home | ERP 6.0  | DD02L
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: ABAP Workbench, Java IDE and Infrastructure :: ABAP Dictionary :: Activation Program, Conversion Program, DB Utility, MC, SPDD
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DD02L392SAP TablesActivation Program, Conversion Program, DB Utility, MC, SPDD
SQL:  selectupdate insert create

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

SELECT TABNAME, AS4LOCAL, AS4VERS, TABCLASS, SQLTAB, DATMIN, DATMAX, DATAVG, CLIDEP, BUFFERED, COMPRFLAG, LANGDEP, ACTFLAG, APPLCLASS, AUTHCLASS, AS4USER, AS4DATE, AS4TIME, MASTERLANG, MAINFLAG, CONTFLAG, RESERVETAB, GLOBALFLAG, PROZPUFF, VIEWCLASS, VIEWGRANT, MULTIPLEX, SHLPEXI, PROXYTYPE, EXCLASS, WRONGCL, ALWAYSTRP, ALLDATAINCL, WITH_PARAMETERS, EXVIEW_INCLUDED, KEYMAX_FEATURE, KEYLEN_FEATURE, TABLEN_FEATURE, NONTRP_INCLUDED FROM DD02L
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1TABNAMETable Namenvarchar300CHAR(N' ')NoTABNAME Allow NULL? 
2AS4LOCALActivation Status of a Repository Objectchar10CHAR(N' ')NoAS4LOCAL Allow NULL? 
3AS4VERSVersion of the entry (not used)nvarchar40NUMC(N'0000')NoAS4VERS Allow NULL? 
4TABCLASSTable categorynvarchar80CHAR(N' ')YesTABCLASS Allow NULL? 
5SQLTABName of an SQL table or an appended tablenvarchar300CHAR(N' ')Yes*SQLAPPDTAB Allow NULL? 
6DATMINMinimum no. of entriesnvarchar100NUMC(N'0000000000')YesDATMIN Allow NULL? 
7DATMAXMaximum no. of entriesnvarchar100NUMC(N'0000000000')YesDATMAX Allow NULL? 
8DATAVGAverage number of entriesnvarchar100NUMC(N'0000000000')YesDATAVG Allow NULL? 
9CLIDEPFlag indicating client-specific entrieschar10CHAR(N' ')YesCLIDEP Allow NULL? 
10BUFFEREDBuffering flagchar10CHAR(N' ')YesBUFFERED Allow NULL? 
11COMPRFLAGField compression indicatorchar10CHAR(N' ')YesCOMPREX Allow NULL? 
12LANGDEPLanguage dependencychar10CHAR(N' ')YesLANGDEP Allow NULL? 
13ACTFLAGActivation flagchar10CHAR(N' ')YesACTFLAG Allow NULL? 
14APPLCLASSApplication class for DD objects (not used)nvarchar40CHAR(N' ')Yes*APPLCLASS Allow NULL? 
15AUTHCLASSActivation typenvarchar20NUMC(N'00')YesAUTHCLASS_ Allow NULL? 
16AS4USERLast Changed bynvarchar120CHAR(N' ')YesAS4USER Allow NULL? 
17AS4DATEDate of Last Changenvarchar80DATS(N'00000000')YesAS4DATE Allow NULL? 
18AS4TIMELast changed atnvarchar60TIMS(N'000000')YesAS4TIME Allow NULL? 
19MASTERLANGOriginal Language in Repository objectschar10LANG(N' ')Yes*MASTERLANG Allow NULL? 
20MAINFLAGFlag if Maintenance with Standard Tools is allowedchar10CHAR(N' ')YesMAINTFLAG Allow NULL? 
21CONTFLAGDelivery classchar10CHAR(N' ')YesCONTFLAG Allow NULL? 
22RESERVETABSDIC: Reserve for tablesnvarchar40CHAR(N' ')YesRESERVETAB Allow NULL? 
23GLOBALFLAGFlag for private DD objects (not used)char10CHAR(N' ')YesGLOBALFLAG Allow NULL? 
24PROZPUFFPercentage for buffersnvarchar30NUMC(N'000')YesPROZPUFF Allow NULL? 
25VIEWCLASSView Typechar10CHAR(N' ')YesVIEWCLASS Allow NULL? 
26VIEWGRANTMaintenance status (modif. authorization) for view datachar10CHAR(N' ')YesVIEWGRANT Allow NULL? 
27MULTIPLEXIndicator whether multiplexing is possible for a tablechar10CHAR(N' ')YesMULTIPLEX Allow NULL? 
28SHLPEXISearch help attachment to table existschar10CHAR(N' ')YesSHLPEXI Allow NULL? 
29PROXYTYPEDD: Is a generated proxy objectchar10CHAR(N' ')YesDDPROXYTY Allow NULL? 
30EXCLASSDD: Ranking for include and subtype extensionchar10NUMC(N'0')YesDDRANKING Allow NULL? 
31WRONGCLEnhancement category is incorrectchar10CHAR(N' ')YesDDWRONGCL Allow NULL? 
32ALWAYSTRPTable is always transparent on selective databasechar10CHAR(N' ')YesDDALWAYSTRP Allow NULL? 
33ALLDATAINCLDD: DataAging: Handle data as hot and cold if switched onchar10CHAR(N' ')NoDDALLDATAINCLU Allow NULL? 
34WITH_PARAMETERSDD: Set whenever a view or base view has parameterschar10CHAR(N' ')NoDDWITHPAR Allow NULL? 
35EXVIEW_INCLUDEDDD: Contains at least one external view in the hierarchychar10CHAR(N' ')NoDDEXTVIEW_INCLUDED Allow NULL? 
36KEYMAX_FEATUREDD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Key Fieldschar10CHAR(N' ')NoDDDBKEYMAXFEATURE Allow NULL? 
37KEYLEN_FEATUREDD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Lengthchar10CHAR(N' ')NoDDDBKEYLENFEATURE Allow NULL? 
38TABLEN_FEATUREDD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1char10CHAR(N' ')NoDDDBTABLENFEATURE Allow NULL? 
39NONTRP_INCLUDEDDD: At least one non-transparent one containedchar10CHAR(N' ')NoDDNONTRANSP_INCLUDED Allow NULL? 
NamePrimaryUniqueTypeColumns
DD02L~0YesYesCLUSTEREDAS4VERS, AS4LOCAL, TABNAME
DD02L~1NoNoNONCLUSTEREDAS4LOCAL, SQLTAB

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy