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  | TCNO
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Basis Components :: Frontend Services - Use subcomponents see SAP Note 1322184 :: Graphic
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCNO1101Network/hierarchy graphics: options profileGraphic
SQL:  selectupdate insert create

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

SELECT MANDT, PROFILE, AUTOADJUST, BUTTONPOS, DISPBG, DUPMODE, HEIGHT, HOFFSET, IGNOREUSER, INODESIZE, INSMODE, LAYBG, LAYFG, LAYORDER, LAYSTYLE, LBUTTBG, LBUTTFG, MARKNODE, MODMODE, NAVBG, NAVFRMCOL, NODEBG, NODESIZE, OBUTTBG, OBUTTFG, ORDBG, ORDFG, SELLINECOL, SELOBJMODE, SELTYPMODE, STATBG, STATFG, TRCKFRMCOL, USESAVE, VIEW1BG, VIEW2BG, VIEW3BG, VOFFSET, WIDTH, XPERCENT, XPOS, YPERCENT, YPOS, ZOOMFAC, MARKLINK, CONMODE, CUSMODE, TIMER, DBLCLICK, AUTOPORT, UDM, ROUNDED, XPOSITION, YPOSITION, XSIZE, YSIZE, TRACKOPT, CLROWS, CLCOLS, CLRASTER, CLCOLWD, MASTERVIEW, LEGEND, SUBCHART, SUBINDEX, INFOTEXTS, CONFIRM, TITLEBOX, PORTSIZE, AUTO_CLUST, RANG, LAYOUT, CLDELS, TBXZOOM, BREAKCON, ALIVE, NODELMSG, INFOTXTNUM, AMODAL, STGAUGE, SHORTLINK, USRPOPS, LINKINCLUS, NOWARN, NODELPOP, NODUPMOVE, INNERPICKM, NOBOXMOVE, COMPACTNOD, COMPCTINOD, OWNLEGEND, PILEMODE, LINKOPTIM, CUSTOMIZE, TOOLTIP, ROWPOSONLY, INSNODEPOS, BMPDISPAR, BMPNODEAR, BMPNAVAR, UNQLNKSYMS, MOVEBTMPS, BREAKLGND, DIAGLINES, INSATLINK, NOADJCONF, MENUMARK, NOSELWARN, PHANTBAND, ENJOYLEVEL FROM TCNO
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PROFILEName of the options profilenvarchar120 Allow NULL? 
3AUTOADJUSTFlag for activation of automatic alignmentchar10 Allow NULL? 
4BUTTONPOSToolbox positionchar10 Allow NULL? 
5DISPBGBackground color for display areanvarchar110 Allow NULL? 
6DUPMODEMode for copying nodeschar10 Allow NULL? 
7HEIGHTNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40 Allow NULL? 
8HOFFSETOffset for horizontal scrollingnvarchar30 Allow NULL? 
9IGNOREUSERFlag: ingnore user entrieschar10 Allow NULL? 
10INODESIZEInitial size of nodes in "insertable nodes" areanvarchar50 Allow NULL? 
11INSMODEMode when inserting nodeschar10 Allow NULL? 
12LAYBGBackground color in partitioning windownvarchar110 Allow NULL? 
13LAYFGLine color in partitioning windownvarchar110 Allow NULL? 
14LAYORDERSequence of the display, node and navigation areaschar10 Allow NULL? 
15LAYSTYLEArea divisionchar10 Allow NULL? 
16LBUTTBGBackground color for symbols in partitioning windownvarchar110 Allow NULL? 
17LBUTTFGLine color in partitioning symbolsnvarchar110 Allow NULL? 
18MARKNODENode/frame marking typechar10 Allow NULL? 
19MODMODEChange Modechar10 Allow NULL? 
20NAVBGBackground color for navigation areanvarchar110 Allow NULL? 
21NAVFRMCOLColor of frame in navigation areanvarchar110 Allow NULL? 
22NODEBGBackground color of node areanvarchar110 Allow NULL? 
23NODESIZEInitial node size in display areanvarchar50 Allow NULL? 
24OBUTTBGBackground color of symbols in ordering windownvarchar110 Allow NULL? 
25OBUTTFGLine color for ordering symbolsnvarchar110 Allow NULL? 
26ORDBGBackground color in sequence windownvarchar110 Allow NULL? 
27ORDFGForeground color in sequence windownvarchar110 Allow NULL? 
28SELLINECOLColor for link selectionnvarchar110 Allow NULL? 
29SELOBJMODESelection mode for object typechar10 Allow NULL? 
30SELTYPMODEMode for selection typechar10 Allow NULL? 
31STATBGBackground color for status line (is no longer used)nvarchar110 Allow NULL? 
32STATFGStatus line foreground color (no longer used)nvarchar110 Allow NULL? 
33TRCKFRMCOLColor frame tracknvarchar110 Allow NULL? 
34USESAVEFlag: for activating symbol for savingchar10 Allow NULL? 
35VIEW1BGBackground color for view 1nvarchar110 Allow NULL? 
36VIEW2BGBackground color for view 2nvarchar110 Allow NULL? 
37VIEW3BGBackground color for view 3nvarchar110 Allow NULL? 
38VOFFSETVertical offset for scrollingnvarchar30 Allow NULL? 
39WIDTHDummynvarchar40 Allow NULL? 
40XPERCENTVertical window division in percentnvarchar30 Allow NULL? 
41XPOSDummynvarchar40 Allow NULL? 
42YPERCENTHorizontal division of are in percentnvarchar30 Allow NULL? 
43YPOSDummynvarchar40 Allow NULL? 
44ZOOMFACInitial zoom factornvarchar50 Allow NULL? 
45MARKLINKLink marking typechar10 Allow NULL? 
46CONMODEMode when linking nodeschar10 Allow NULL? 
47CUSMODEFlag: activate saving of options profilechar10 Allow NULL? 
48TIMERTime interval for transferring control to calling programnvarchar60 Allow NULL? 
49DBLCLICKFlag: support double-clickchar10 Allow NULL? 
50AUTOPORTMode for unbundling linkschar10 Allow NULL? 
51UDMMode for layoutchar10 Allow NULL? 
52ROUNDEDFlag: Use rounded corners in graphicschar10 Allow NULL? 
53XPOSITIONInitial horizontal position of the graphics windownvarchar30 Allow NULL? 
54YPOSITIONInitial vertical position of the graphics windownvarchar30 Allow NULL? 
55XSIZEWidth of graphics windownvarchar30 Allow NULL? 
56YSIZEHeight of graphics windownvarchar30 Allow NULL? 
57TRACKOPTPath optimization in network graphicschar10 Allow NULL? 
58CLROWSNumber of Rows in the Cluster Editornvarchar30 Allow NULL? 
59CLCOLSNumber of columns in cluster editornvarchar30 Allow NULL? 
60CLRASTERFlag: Display grid in frame editorchar10 Allow NULL? 
61CLCOLWDWidth of columns in cluster editornvarchar50 Allow NULL? 
62MASTERVIEWDrawing mode for the navigation windowchar10 Allow NULL? 
63LEGENDPosition of the legend in the networkchar10 Allow NULL? 
64SUBCHARTIndicator: Area restriction activechar10 Allow NULL? 
65SUBINDEXText index for area restrictionnvarchar20 Allow NULL? 
66INFOTEXTSShow/hide info textchar10 Allow NULL? 
67CONFIRMFlag: activate CONFIRM modechar10 Allow NULL? 
68TITLEBOXPrint/display headerchar10 Allow NULL? 
69PORTSIZELink symbol size in 1/100 mmnvarchar40 Allow NULL? 
70AUTO_CLUSTMode for positioning frames during alignmentchar10 Allow NULL? 
71RANGRank for network layout calculationchar10 Allow NULL? 
72LAYOUTMode for aligning graph in networkchar10 Allow NULL? 
73CLDELSSpace between columns in frame editornvarchar40 Allow NULL? 
74TBXZOOMZoom with arrow keyschar10 Allow NULL? 
75BREAKCONDeactivate link mode after executing oncechar10 Allow NULL? 
76ALIVEInterval for graphic to respondnvarchar40 Allow NULL? 
77NODELMSGTime interval for status text displaynvarchar20 Allow NULL? 
78INFOTXTNUMText index for info textnvarchar20 Allow NULL? 
79AMODALFlag: activate amodal processingchar10 Allow NULL? 
80STGAUGEActivate scroll bar displaychar10 Allow NULL? 
81SHORTLINKFlag: move nodes together as close as possiblechar10 Allow NULL? 
82USRPOPSFlag: activate object-sensitive popupchar10 Allow NULL? 
83LINKINCLUSFlag: Links within a framechar10 Allow NULL? 
84NOWARNFlag: Ignore warningschar10 Allow NULL? 
85NODELPOPFlag: Suppress confirmation for deletionchar10 Allow NULL? 
86NODUPMOVEIndicator: Position boxes/nodes overlappingchar10 Allow NULL? 
87INNERPICKMIndicator: Inner pickmarks at framechar10 Allow NULL? 
88NOBOXMOVEFlag: Do not allow box movementchar10 Allow NULL? 
89COMPACTNODMode for positioning isolated nodeschar10 Allow NULL? 
90COMPCTINODFlag: Align in area "insertable nodes"char10 Allow NULL? 
91OWNLEGENDFlag: Font fieldchar10 Allow NULL? 
92PILEMODEFlag: Automatic scrolling through stackchar10 Allow NULL? 
93LINKOPTIMFlag: Link optimization in Network Graphicschar10 Allow NULL? 
94CUSTOMIZEFlag: Activate customizing modechar10 Allow NULL? 
95TOOLTIPFlag: Activate quick infochar10 Allow NULL? 
96ROWPOSONLYPositioning only with Y coordinateschar10 Allow NULL? 
97INSNODEPOSFlag: Give node positions when insertingchar10 Allow NULL? 
98BMPDISPARName of the graphic symbol for the display areanvarchar120 Allow NULL? 
99BMPNODEARName of the graphic symbol file for the node areanvarchar120 Allow NULL? 
100BMPNAVARName of the graphic symbol file for the navigation areanvarchar120 Allow NULL? 
101UNQLNKSYMSPositioning link symbolschar10 Allow NULL? 
102MOVEBTMPSMovement of bitmapschar10 Allow NULL? 
103BREAKLGNDWrap in legendchar10 Allow NULL? 
104DIAGLINESDiagonal links in networkchar10 Allow NULL? 
105INSATLINKReturn link ID when inserting nodeschar10 Allow NULL? 
106NOADJCONFSuppress dialog box when aligningchar10 Allow NULL? 
107MENUMARKSelection of graphic objects with right mouse buttonchar10 Allow NULL? 
108NOSELWARNSuppress object reference dialog boxchar10 Allow NULL? 
109PHANTBANDMovement response of phantoms in networkchar10 Allow NULL? 
110ENJOYLEVELEnjoy levelchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
TCNO~0YesYesCLUSTEREDPROFILE, MANDT

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