biuan SAP® BUSINESS ONE SDK
SQL Reports / Reporting Element
API Report Layout Items / Report Layout Item
RITM - Reporting Element Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocCode KEYReportnVarChar
8RDOC
Document		TYPENo
ItemIdItem IDInt
6
ContainerParent TypeInt
6
TypeTypeInt
1) Page Header
2) Start of Report
3) Repetitive Area Header
4) Repetitive Area
5) Repetitive Area Footer
6) End of Report
7) Page Footer
10) Text Field
11) Picture Field
12) User Field
6
VISIBLEVisibleVarChar
Y) Yes
N) No
1
Y
SupZerosSuppress ZerosVarChar
Y) Yes
N) No
1
N
ItemLeftLeft ItemInt
6
ItemTopTopInt
6
WidthWidthInt
6
HeightHeightInt
6
LMarginLeft MarginInt
6
0
RMarginRight MarginInt
6
0
TMarginTop MarginInt
6
0
BMarginBottom MarginInt
6
0
LeftLineLeft Border Line ThicknessInt
6
0
RightLineRight Border Line ThicknessInt
6
0
TopLineTop Border Line ThicknessInt
6
0
BottomLineBottom Border Line ThicknessInt
6
0
ShadowShadow ThicknessInt
6
0
BGRedBackground - RedInt
11
255
BGGreenBackground - GreenInt
11
255
BGBlueBackground - BlueInt
11
255
FGRedText - RedInt
11
0
FGGreenText - GreenInt
11
0
FGBlueText - BlueInt
11
0
MrkrRedBold - RedInt
11
255
MrkrGreenBold - GreenInt
11
255
MrkrBlueBold - BlueInt
11
255
BrdrRedBorder - RedInt
11
0
BrdrGreenBorder - GreenInt
11
0
BrdrBlueBorder - BlueInt
11
0
FromPaneFrom AreaInt
6
0
ToPaneTo AreaInt
6
0
ItemGroupGroup No.Int
6
0
FontNameFont NamenVarChar
50
Arial
FontSizeFont SizeInt
6
12
TextStyleText StyleInt
11
0
JustificHorizontal JustificationInt
1) Right
2) Left
3) Centralized
4) Language-Dependent
6
2
WRAPSegmentInt
0
1) Adjust to Cell
2) Divide into Rows
6
2
PictSizePicture SizeInt
0
1) Fit Field Size Non-Proportionally
2) Fit Field Size Proportionally
3) Fit Field Height
4) Fit Fields Width
6
0
DataSourceData SourceInt
1) Static
2) Variable
3) Data
4) Calculation
6
1
ItemStrStringText
16
VarNumVariable No.Int
6
FileNameFile NamenVarChar
20
FieldNumField No.nVarChar
20
ShowDescrDisplay DescriptionVarChar
Y) Yes
N) No
1
Y
CalcTypeCalculation TypenVarChar
0
1) Page Number
17) Total Pages
2) Date
3) Time
4) Column Total
5) Column Average
6) General Row No.
7) Group Row No.
8) Sort Field Name
9) Sort Field Content
10) Continue
11) Continued on Next Page
12) Generation Message
13) Column Summary for Page
14) Column Average for Page
15) Column Summary for Report
16) Column Average for Report
2
1
ChangFlagsChangeableInt
11
ApplIDItem No.Int
6
CalcColCalculation ColumnInt
6
YJustificVertical AlignmentInt
1) Top
2) Bottom
3) Centralized
6
3
SortLevelSort LevelInt
6
0
RevOrderReverse SortVarChar
Y) Descending
N) Ascending
1
N
SortTypeSort TypeInt
0
1) Numeric
2) Currency
3) Date
6
0
IsUniqueUniqueVarChar
Y) Yes
N) No
1
N
IsGroupSet as GroupVarChar
Y) Yes
N) No
1
N
NewPageNew PageVarChar
Y) Yes
N) No
1
N
BarCodePrint as Bar CodeVarChar
Y) Yes
N) No
1
N
ConditionConditionText
16
LinkToLink to FieldnVarChar
20
Operator1Operator 1Int
6
Operator2Operator 2Int
6
OperationOperationInt
0
(-0) Arithmetic Operations
1) +
2) -
3) x
4) /
5) %
17) Left Part (Characters)
18) Right Part (Mantissa)
19) Round
(-1) String Operations
6) $Concat
7) $Right
8) $Left
9) $Sentence
16) $Length
20) $Currency
21) $Number
(-2) Conditional Operators
10) Less than
11) Less or Equal
12) Equal
13) Not equal
14) Greater or Equal
15) Greater than
(-3) Conditional Operators
(-4) String Operations
6
0
BCStandardBar Code StandardInt
0
1) Code 39
2) Code 128
6
0
SumInWordsDisplay Total as a WordVarChar
Y) Yes
N) No
1
N
ExcFontingBlock Font ChangeVarChar
Y) Yes
N) No
1
N
StrIndexString IndexInt
11
0
ContIndexContainer IndexInt
6
0
ItemIndexItem IndexInt
6
0
StrLengthString LengthInt
6
StrFillerString FillerVarChar
1
RelatedToLink to FieldnVarChar
20
NextSegNext Segment Item NumbernVarChar
20
HightAdjstHeight AdjustmentsVarChar
Y) Yes
N) No
1
N
DupRpttAreDuplicate Repetitive AreaVarChar
Y) Yes
N) No
1
N
LnsRpttAreNo. of Rows in Repetitive AreaInt
11
0
RptDupDistDistance To Rptt Dup. (pixels)Int
11
0
FieldIdUnique IDnVarChar
20
FGEnabledGrid EnabledVarChar
Y) Yes
N) No
1
Y
BGEnabledBackground EnabledVarChar
Y) Yes
N) No
1
Y
MKEnabledHighlight EnabledVarChar
Y) Yes
N) No
1
Y
BDEnabledFrame EnabledVarChar
Y) Yes
N) No
1
Y
HidEmpRpttHide Empty AreaVarChar
Y) Yes
N) No
1
N
RpttFtrAllDisplay Rep. Footer on AllVarChar
Y) Yes
N) No
1
N
GbiDataTypData TypeInt
0
1) C n
2) C.. n
3) I.. n
4) D w.d
6
0
GbiDataLenData LengthnVarChar
6
PageBreakPage BreakInt
0
1) Before Area
2) After Area
6
0
IsLogoIs LogoVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT RITM.DocCode AS 'Report', RITM.ItemId AS 'Item ID', RITM.Container AS 'Parent Type', RITM.Type AS 'Type', RITM.VISIBLE AS 'Visible', RITM.SupZeros AS 'Suppress Zeros', RITM.ItemLeft AS 'Left Item', RITM.ItemTop AS 'Top', RITM.Width AS 'Width', RITM.Height AS 'Height', RITM.LMargin AS 'Left Margin', RITM.RMargin AS 'Right Margin', RITM.TMargin AS 'Top Margin', RITM.BMargin AS 'Bottom Margin', RITM.LeftLine AS 'Left Border Line Thickness', RITM.RightLine AS 'Right Border Line Thickness', RITM.TopLine AS 'Top Border Line Thickness', RITM.BottomLine AS 'Bottom Border Line Thickness', RITM.Shadow AS 'Shadow Thickness', RITM.BGRed AS 'Background - Red', RITM.BGGreen AS 'Background - Green', RITM.BGBlue AS 'Background - Blue', RITM.FGRed AS 'Text - Red', RITM.FGGreen AS 'Text - Green', RITM.FGBlue AS 'Text - Blue', RITM.MrkrRed AS 'Bold - Red', RITM.MrkrGreen AS 'Bold - Green', RITM.MrkrBlue AS 'Bold - Blue', RITM.BrdrRed AS 'Border - Red', RITM.BrdrGreen AS 'Border - Green', RITM.BrdrBlue AS 'Border - Blue', RITM.FromPane AS 'From Area', RITM.ToPane AS 'To Area', RITM.ItemGroup AS 'Group No.', RITM.FontName AS 'Font Name', RITM.FontSize AS 'Font Size', RITM.TextStyle AS 'Text Style', RITM.Justific AS 'Horizontal Justification', RITM.WRAP AS 'Segment', RITM.PictSize AS 'Picture Size', RITM.DataSource AS 'Data Source', RITM.ItemStr AS 'String', RITM.VarNum AS 'Variable No.', RITM.FileName AS 'File Name', RITM.FieldNum AS 'Field No.', RITM.ShowDescr AS 'Display Description', RITM.CalcType AS 'Calculation Type', RITM.ChangFlags AS 'Changeable', RITM.ApplID AS 'Item No.', RITM.CalcCol AS 'Calculation Column', RITM.YJustific AS 'Vertical Alignment', RITM.SortLevel AS 'Sort Level', RITM.RevOrder AS 'Reverse Sort', RITM.SortType AS 'Sort Type', RITM.IsUnique AS 'Unique', RITM.IsGroup AS 'Set as Group', RITM.NewPage AS 'New Page', RITM.BarCode AS 'Print as Bar Code', RITM.Condition AS 'Condition', RITM.LinkTo AS 'Link to Field', RITM.Operator1 AS 'Operator 1', RITM.Operator2 AS 'Operator 2', RITM.Operation AS 'Operation', RITM.BCStandard AS 'Bar Code Standard', RITM.SumInWords AS 'Display Total as a Word', RITM.ExcFonting AS 'Block Font Change', RITM.StrIndex AS 'String Index', RITM.ContIndex AS 'Container Index', RITM.ItemIndex AS 'Item Index', RITM.StrLength AS 'String Length', RITM.StrFiller AS 'String Filler', RITM.RelatedTo AS 'Link to Field', RITM.NextSeg AS 'Next Segment Item Number', RITM.HightAdjst AS 'Height Adjustments', RITM.DupRpttAre AS 'Duplicate Repetitive Area', RITM.LnsRpttAre AS 'No. of Rows in Repetitive Area', RITM.RptDupDist AS 'Distance To Rptt Dup. (pixels)', RITM.FieldId AS 'Unique ID', RITM.FGEnabled AS 'Grid Enabled', RITM.BGEnabled AS 'Background Enabled', RITM.MKEnabled AS 'Highlight Enabled', RITM.BDEnabled AS 'Frame Enabled', RITM.HidEmpRptt AS 'Hide Empty Area', RITM.RpttFtrAll AS 'Display Rep. Footer on All', RITM.GbiDataTyp AS 'Data Type', RITM.GbiDataLen AS 'Data Length', RITM.PageBreak AS 'Page Break', RITM.IsLogo AS 'Is Logo' FROM RITM AS RITM

Related information


Report Layout Item ReportLayoutItem Object· Table: RITM
Represents an element in a PLD report layout. Source table: RITM
   Parent: Report Layout Items ReportLayoutItems Collection
Document RDOC SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates