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  | TRKB1U
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
Enterprise Controlling :: Executive Information System :: Data Collection
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TRKB1U361Table with "Customizing settings" for drilldown reportingData Collection
SQL:  selectupdate insert create

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

SELECT APPLCLASS, TABNAME, CUANM, M_CUANM, RNAMEI, APPL, CLAS, NACHLESEN, SEL_VER, LDBNAME, NO_SCREEN, TABKZ, USER_EXIT, PERIOKZ, POPUP_EXEC, SEL_DF, FB_DATA, EXPTIME, FB_WAERS, FB_H_INFO, FB_GENER, FB_ADD_INSIGHT, REDUCE_SEL, ADDSELKZ, WAERS_OK, WAERS_DY, OK_CODE, CONFIRMS, PERI_CHECK, CUALEVEL, EXTERN, RKB1UEXIT, ENQUEUE, SELECT_OPTION, BBSVAR_ADDSEL, FB_H_KNOTEN FROM TRKB1U
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1APPLCLASSApplication class for drilldown reportingnvarchar40CHAR(N' ')No*CFAPPLCLAS Allow NULL? 
2TABNAMETable Namenvarchar300CHAR(N' ')No*TABNAME Allow NULL? 
3CUANMName of control program for drill-down reportingnvarchar400CHAR(N' ')Yes*RKE_CUANM Allow NULL? 
4M_CUANMProgram RKCDUMON for data mining reportsnvarchar80CHAR(N' ')YesCFMCUANM Allow NULL? 
5RNAMEIABAP/4 report program for selection exitsnvarchar400CHAR(N' ')Yes*CFRNAMEI Allow NULL? 
6APPLApplicationchar10CHAR(N' ')Yes*RDIR_APPL Allow NULL? 
7CLASProgram classnvarchar60CHAR(N' ')Yes*CFCLASS Allow NULL? 
8NACHLESENApplication uses the function "read"char10CHAR(N' ')YesCFNEWSELECT Allow NULL? 
9SEL_VERSelection screen versionnvarchar30CHAR(N' ')YesRDIR_TYPE Allow NULL? 
10LDBNAMELDB namenvarchar200CHAR(N' ')YesLDBNAM Allow NULL? 
11NO_SCREENNo selection screen, if no variables are availablechar10CHAR(N' ')YesCFNOSCREEN Allow NULL? 
12TABKZSeveral tables in an application?char10CHAR(N' ')YesCFTABKZ Allow NULL? 
13USER_EXITNumber for user-exit in drilldown reportingnvarchar30NUMC(N'000')YesCFUEBEGIN Allow NULL? 
14PERIOKZFlag for creating PERIO from PERDEchar10CHAR(N' ')YesCFPERIOKZ Allow NULL? 
15POPUP_EXECDialog box when calling up a reportchar10CHAR(N' ')YesCFPOPUP Allow NULL? 
16SEL_DFDefault for selection when executing a reportchar10CHAR(N' ')YesCFSEL_DF Allow NULL? 
17FB_DATAFM for data selectionnvarchar300CHAR(N' ')Yes*CFFBDATA Allow NULL? 
18EXPTIMESelection FM contains export parameters for selection timechar10CHAR(N' ')YesCFEXPTIME Allow NULL? 
19FB_WAERSFM for determining currenciesnvarchar300CHAR(N' ')Yes*CFFBWAERS Allow NULL? 
20FB_H_INFOFM for hierarchy informationnvarchar300CHAR(N' ')Yes*CFFBHINFO Allow NULL? 
21FB_GENERName of the generating module for data reading (Drill-Down)nvarchar300CHAR(N' ')Yes*CFFBGENER Allow NULL? 
22FB_ADD_INSIGHTFunction module for transfer of ADD_SEL to inSightnvarchar300CHAR(N' ')Yes*CFFB_ADDSEL_TO_INSIGHT Allow NULL? 
23REDUCE_SELSEL_TAB should be reduced by the drilldown reporting tool.char10CHAR(N' ')YesCFREDU_SEL Allow NULL? 
24ADDSELKZAdditional selections on report selection screen?char10CHAR(N' ')YesCFADDSEL Allow NULL? 
25WAERS_OKData has decimal places for currencychar10CHAR(N' ')YesCFWAERS_OK Allow NULL? 
26WAERS_DYCurrency does not have to be known until report execution?char10CHAR(N' ')YesCFWAERS_DY Allow NULL? 
27OK_CODEDefault OK code for report-report interfacenvarchar40CHAR(N' ')YesCFBBSDEFAU Allow NULL? 
28CONFIRMSConfirm for data saving when leaving reportchar10CHAR(N' ')YesCFSAVE Allow NULL? 
29PERI_CHECKPeriod validation for special ranges is activechar10CHAR(N' ')YesCFPERICHK Allow NULL? 
30CUALEVELScope of functions when executing drilldown reportchar10CHAR(N' ')YesCFFUNCT Allow NULL? 
31EXTERNRFC connection of PC toolschar10CHAR(N' ')YesCFRFC Allow NULL? 
32RKB1UEXITExit for "complicated" RKB1U entriesnvarchar300CHAR(N' ')Yes*CFRKB1UEX Allow NULL? 
33ENQUEUEReport execution locked?char10CHAR(N' ')YesCFENQUEUE Allow NULL? 
34SELECT_OPTIONParameter or select optionchar10CHAR(N' ')YesCFVPARSEL Allow NULL? 
35BBSVAR_ADDSELIs Callup with Variant via Report/Report Interface Allowed?char10CHAR(N' ')YesCFBBSVAR_ADDSEL Allow NULL? 
36FB_H_KNOTENFM for Determining Hierarchy Nodes when Postreadingnvarchar300CHAR(N' ')Yes*CFFBHNACH Allow NULL? 
NamePrimaryUniqueTypeColumns
TRKB1U~0YesYesCLUSTEREDAPPLCLASS, TABNAME

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