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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
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
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse 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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PROFILEName of the options profilenvarchar120CHAR(N' ')NoNETOPTPROF Allow NULL? 
3AUTOADJUSTFlag for activation of automatic alignmentchar10CHAR(N' ')YesNETAUTOADJ Allow NULL? 
4BUTTONPOSToolbox positionchar10CHAR(N' ')YesNETBUTPOS Allow NULL? 
5DISPBGBackground color for display areanvarchar110CHAR(N' ')YesTWCOLNETDISPBG Allow NULL? 
6DUPMODEMode for copying nodeschar10CHAR(N' ')YesNETDUPMODE Allow NULL? 
7HEIGHTNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40CHAR(N' ')YesCHAR4 Allow NULL? 
8HOFFSETOffset for horizontal scrollingnvarchar30NUMC(N'000')YesNETHOFFSET Allow NULL? 
9IGNOREUSERFlag: ingnore user entrieschar10CHAR(N' ')YesNETIGNORE Allow NULL? 
10INODESIZEInitial size of nodes in "insertable nodes" areanvarchar50NUMC(N'00000')YesNETINODESZ Allow NULL? 
11INSMODEMode when inserting nodeschar10CHAR(N' ')YesNETINSMODE Allow NULL? 
12LAYBGBackground color in partitioning windownvarchar110CHAR(N' ')YesTWCOLNETLAYBG Allow NULL? 
13LAYFGLine color in partitioning windownvarchar110CHAR(N' ')YesTWCOLNETLAYFG Allow NULL? 
14LAYORDERSequence of the display, node and navigation areaschar10CHAR(N' ')YesNETLAYORD Allow NULL? 
15LAYSTYLEArea divisionchar10CHAR(N' ')YesNETLAYSTL Allow NULL? 
16LBUTTBGBackground color for symbols in partitioning windownvarchar110CHAR(N' ')YesTWCOLNETLBUTTBG Allow NULL? 
17LBUTTFGLine color in partitioning symbolsnvarchar110CHAR(N' ')YesTWCOLNETLBUTTFG Allow NULL? 
18MARKNODENode/frame marking typechar10CHAR(N' ')YesNETMARKND Allow NULL? 
19MODMODEChange Modechar10CHAR(N' ')YesNETMODMODE Allow NULL? 
20NAVBGBackground color for navigation areanvarchar110CHAR(N' ')YesTWCOLNETNAVBG Allow NULL? 
21NAVFRMCOLColor of frame in navigation areanvarchar110CHAR(N' ')YesTWCOLNETNAVFRM Allow NULL? 
22NODEBGBackground color of node areanvarchar110CHAR(N' ')YesTWCOLNETNODEBG Allow NULL? 
23NODESIZEInitial node size in display areanvarchar50NUMC(N'00000')YesNETNODESZ Allow NULL? 
24OBUTTBGBackground color of symbols in ordering windownvarchar110CHAR(N' ')YesTWCOLNETOBUTTBG Allow NULL? 
25OBUTTFGLine color for ordering symbolsnvarchar110CHAR(N' ')YesTWCOLNETOBUTTFG Allow NULL? 
26ORDBGBackground color in sequence windownvarchar110CHAR(N' ')YesTWCOLNETORDBG Allow NULL? 
27ORDFGForeground color in sequence windownvarchar110CHAR(N' ')YesTWCOLNETORDFG Allow NULL? 
28SELLINECOLColor for link selectionnvarchar110CHAR(N' ')YesTWCOLNETSELLINC Allow NULL? 
29SELOBJMODESelection mode for object typechar10CHAR(N' ')YesNETSELOMOD Allow NULL? 
30SELTYPMODEMode for selection typechar10CHAR(N' ')YesNETSELTMOD Allow NULL? 
31STATBGBackground color for status line (is no longer used)nvarchar110CHAR(N' ')YesTWCOLNETSTATBG Allow NULL? 
32STATFGStatus line foreground color (no longer used)nvarchar110CHAR(N' ')YesTWCOLNETSTATFG Allow NULL? 
33TRCKFRMCOLColor frame tracknvarchar110CHAR(N' ')YesTWCOLNETTRCKFRM Allow NULL? 
34USESAVEFlag: for activating symbol for savingchar10CHAR(N' ')YesNETUSESAVE Allow NULL? 
35VIEW1BGBackground color for view 1nvarchar110CHAR(N' ')YesTWCOLNETVIEW1BG Allow NULL? 
36VIEW2BGBackground color for view 2nvarchar110CHAR(N' ')YesTWCOLNETVIEW2BG Allow NULL? 
37VIEW3BGBackground color for view 3nvarchar110CHAR(N' ')YesTWCOLNETVIEW3BG Allow NULL? 
38VOFFSETVertical offset for scrollingnvarchar30NUMC(N'000')YesNETVOFFSET Allow NULL? 
39WIDTHDummynvarchar40NUMC(N'0000')YesNETNUMC4 Allow NULL? 
40XPERCENTVertical window division in percentnvarchar30NUMC(N'000')YesNETXPERCNT Allow NULL? 
41XPOSDummynvarchar40NUMC(N'0000')YesNETNUMC4 Allow NULL? 
42YPERCENTHorizontal division of are in percentnvarchar30NUMC(N'000')YesNETYPERCNT Allow NULL? 
43YPOSDummynvarchar40NUMC(N'0000')YesNETNUMC4 Allow NULL? 
44ZOOMFACInitial zoom factornvarchar50NUMC(N'00000')YesNETZOOMFAC Allow NULL? 
45MARKLINKLink marking typechar10CHAR(N' ')YesNETMRKLINK Allow NULL? 
46CONMODEMode when linking nodeschar10CHAR(N' ')YesNETCONMODE Allow NULL? 
47CUSMODEFlag: activate saving of options profilechar10CHAR(N' ')YesNETCUSMODE Allow NULL? 
48TIMERTime interval for transferring control to calling programnvarchar60NUMC(N'000000')YesNETTIMER Allow NULL? 
49DBLCLICKFlag: support double-clickchar10CHAR(N' ')YesNETDBCLICK Allow NULL? 
50AUTOPORTMode for unbundling linkschar10CHAR(N' ')YesNETAUTOPRT Allow NULL? 
51UDMMode for layoutchar10CHAR(N' ')YesNETUDMMODE Allow NULL? 
52ROUNDEDFlag: Use rounded corners in graphicschar10CHAR(N' ')YesNETROUNDED Allow NULL? 
53XPOSITIONInitial horizontal position of the graphics windownvarchar30NUMC(N'000')YesNETXPOSIT Allow NULL? 
54YPOSITIONInitial vertical position of the graphics windownvarchar30NUMC(N'000')YesNETYPOSIT Allow NULL? 
55XSIZEWidth of graphics windownvarchar30NUMC(N'000')YesNETXSIZE Allow NULL? 
56YSIZEHeight of graphics windownvarchar30NUMC(N'000')YesNETYSIZE Allow NULL? 
57TRACKOPTPath optimization in network graphicschar10CHAR(N' ')YesNETTRACKOP Allow NULL? 
58CLROWSNumber of Rows in the Cluster Editornvarchar30NUMC(N'000')YesNETCLROWS Allow NULL? 
59CLCOLSNumber of columns in cluster editornvarchar30NUMC(N'000')YesNETCLCOLS Allow NULL? 
60CLRASTERFlag: Display grid in frame editorchar10CHAR(N' ')YesNETRASTER Allow NULL? 
61CLCOLWDWidth of columns in cluster editornvarchar50NUMC(N'00000')YesNETCLCOLWD Allow NULL? 
62MASTERVIEWDrawing mode for the navigation windowchar10CHAR(N' ')YesNETMASTERV Allow NULL? 
63LEGENDPosition of the legend in the networkchar10CHAR(N' ')YesNETLEGEND Allow NULL? 
64SUBCHARTIndicator: Area restriction activechar10CHAR(N' ')YesNETSUBCHRT Allow NULL? 
65SUBINDEXText index for area restrictionnvarchar20NUMC(N'00')YesNETSUBINDX Allow NULL? 
66INFOTEXTSShow/hide info textchar10CHAR(N' ')YesBCINFOTEXT Allow NULL? 
67CONFIRMFlag: activate CONFIRM modechar10CHAR(N' ')YesNETCONFIRM Allow NULL? 
68TITLEBOXPrint/display headerchar10CHAR(N' ')YesNETTITLBOX Allow NULL? 
69PORTSIZELink symbol size in 1/100 mmnvarchar40NUMC(N'0000')YesNETPORTSIZ Allow NULL? 
70AUTO_CLUSTMode for positioning frames during alignmentchar10CHAR(N' ')YesNETAUTOCLS Allow NULL? 
71RANGRank for network layout calculationchar10CHAR(N' ')YesNETRANG Allow NULL? 
72LAYOUTMode for aligning graph in networkchar10CHAR(N' ')YesNETLAYOUT Allow NULL? 
73CLDELSSpace between columns in frame editornvarchar40NUMC(N'0000')YesNETCLDELS Allow NULL? 
74TBXZOOMZoom with arrow keyschar10CHAR(N' ')YesNETTBXZOOM Allow NULL? 
75BREAKCONDeactivate link mode after executing oncechar10CHAR(N' ')YesNETBRKCON Allow NULL? 
76ALIVEInterval for graphic to respondnvarchar40NUMC(N'0000')YesNETALIVE Allow NULL? 
77NODELMSGTime interval for status text displaynvarchar20NUMC(N'00')YesNETNODELMS Allow NULL? 
78INFOTXTNUMText index for info textnvarchar20CHAR(N' ')YesNETINFONUM Allow NULL? 
79AMODALFlag: activate amodal processingchar10CHAR(N' ')YesNETAMODAL Allow NULL? 
80STGAUGEActivate scroll bar displaychar10CHAR(N' ')YesBCSTGAUGE Allow NULL? 
81SHORTLINKFlag: move nodes together as close as possiblechar10CHAR(N' ')YesNETSHORTLK Allow NULL? 
82USRPOPSFlag: activate object-sensitive popupchar10CHAR(N' ')YesNETUSERPOP Allow NULL? 
83LINKINCLUSFlag: Links within a framechar10CHAR(N' ')YesNETLINKINC Allow NULL? 
84NOWARNFlag: Ignore warningschar10CHAR(N' ')YesNETNOWARN Allow NULL? 
85NODELPOPFlag: Suppress confirmation for deletionchar10CHAR(N' ')YesNETNODELPO Allow NULL? 
86NODUPMOVEIndicator: Position boxes/nodes overlappingchar10CHAR(N' ')YesNETNODUPMV Allow NULL? 
87INNERPICKMIndicator: Inner pickmarks at framechar10CHAR(N' ')YesNETINPICKM Allow NULL? 
88NOBOXMOVEFlag: Do not allow box movementchar10CHAR(N' ')YesNETNOBOXMV Allow NULL? 
89COMPACTNODMode for positioning isolated nodeschar10CHAR(N' ')YesNETCOMPACT Allow NULL? 
90COMPCTINODFlag: Align in area "insertable nodes"char10CHAR(N' ')YesNETCOMPIND Allow NULL? 
91OWNLEGENDFlag: Font fieldchar10CHAR(N' ')YesNETOWNLGND Allow NULL? 
92PILEMODEFlag: Automatic scrolling through stackchar10CHAR(N' ')YesNETPILEMOD Allow NULL? 
93LINKOPTIMFlag: Link optimization in Network Graphicschar10CHAR(N' ')YesNETLINKOPT Allow NULL? 
94CUSTOMIZEFlag: Activate customizing modechar10CHAR(N' ')YesBCCUSTOMIZ Allow NULL? 
95TOOLTIPFlag: Activate quick infochar10CHAR(N' ')YesBCTOOLTIP Allow NULL? 
96ROWPOSONLYPositioning only with Y coordinateschar10CHAR(N' ')YesNETRPONLY Allow NULL? 
97INSNODEPOSFlag: Give node positions when insertingchar10CHAR(N' ')YesNETINSNDPO Allow NULL? 
98BMPDISPARName of the graphic symbol for the display areanvarchar120CHAR(N' ')YesTGMFNETBMPDISP Allow NULL? 
99BMPNODEARName of the graphic symbol file for the node areanvarchar120CHAR(N' ')YesTGMFNETBMPNOD Allow NULL? 
100BMPNAVARName of the graphic symbol file for the navigation areanvarchar120CHAR(N' ')YesTGMFNETBMPNAV Allow NULL? 
101UNQLNKSYMSPositioning link symbolschar10NUMC(N'0')YesNETUNQLKSY Allow NULL? 
102MOVEBTMPSMovement of bitmapschar10CHAR(N' ')YesNETMVBTMPS Allow NULL? 
103BREAKLGNDWrap in legendchar10CHAR(N' ')YesNETBRKLGND Allow NULL? 
104DIAGLINESDiagonal links in networkchar10CHAR(N' ')YesNETDIAGLIN Allow NULL? 
105INSATLINKReturn link ID when inserting nodeschar10CHAR(N' ')YesNETINSATLK Allow NULL? 
106NOADJCONFSuppress dialog box when aligningchar10CHAR(N' ')YesNETADJCONF Allow NULL? 
107MENUMARKSelection of graphic objects with right mouse buttonchar10CHAR(N' ')YesBCMENUMRK Allow NULL? 
108NOSELWARNSuppress object reference dialog boxchar10CHAR(N' ')YesNETNOSLWRN Allow NULL? 
109PHANTBANDMovement response of phantoms in networkchar10CHAR(N' ')YesNETPHNTBND Allow NULL? 
110ENJOYLEVELEnjoy levelchar10CHAR(N' ')YesBCENJOY 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