biuan SAP® BUSINESS ONE SDK
API ITMR
ITMR - ITMR Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocCodeReportnVarChar
8
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
1) Yes
0
1
1
SupZerosSuppress ZerosVarChar
1) Yes
0
1
0
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
65535
BGGreenBackground - GreenInt
11
65535
BGBlueBackground - BlueInt
11
65535
FGRedText - RedInt
11
0
FGGreenText - GreenInt
11
0
FGBlueText - BlueInt
11
0
MrkrRedBold - RedInt
11
65535
MrkrGreenBold - GreenInt
11
65535
MrkrBlueBold - BlueInt
11
65535
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
JustificHorizontal JustificationVarChar
1) Right
2) Left
3) Center
4) Language Dependent
1
2
WRAPSegmentVarChar
0
1) Fit to cell
2) Devide to lines
1
1
PictSizePicture SizeVarChar
0
1) Size of box
2) Adjust to box
3) Adjust to box height
4) Adjust to box width
1
1
DataSourceData SourceVarChar
1) Static
2) Var
3) Data
4) Calculation
1
1
ItemStrStringText
16
VarNumVariable No.Int
6
FileNameFile NamenVarChar
20
FieldNumField No.nVarChar
10
ShowDescrDisplay DescriptionVarChar
1) Yes
0
1
0
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
-1) [new formula String]
2
1
ChangFlagsChangeableInt
11
ApplIDItem No.Int
6
CalcColCalculation ColumnInt
6
YJustificVertical AlignmentVarChar
1) Top
2) Bottom
3) Center
1
3
SortLevelSort LevelInt
6
0
RevOrderReverse SortVarChar
1) Descending
0
1
0
SortTypeSort TypeVarChar
0
1) Numeric
2) Money
3) Date
1
0
IsUniqueUniqueVarChar
1) Yes
0
1
0
IsGroupSet as GroupVarChar
1) Yes
0
1
0
NewPageNew PageVarChar
1) Yes
0
1
0
BarCodePrint as BarcodeVarChar
1) Yes
0
1
0
ConditionConditionText
16
LinkToLink to ItemInt
6
0
Operator1Operator 1Int
6
Operator2Operator 2Int
6
OperationOperationInt
0
(-0) Aritmathic operation
1) +
2) -
3) x
4) /
5) %
17) Left
18) Right
19) Round
(-1) String operation
6) $Concat
7) $Right
8) $Left
9) $Sentence
16) $Len
20) $Currency
21) $Number
(-2) Condition operation
10) Less
11) LessEq
12) Equally
13) Not eq
14) GrEq
15) Greater
6
0
BCStandardBarcode StandardInt
0
1) Code 39
2) Code 128
6
0
SumInWordsDisplay Total as a WordVarChar
1) Yes
0
1
0
ExcFontingBlock Font ChangeVarChar
1) Yes
0
1
0
StrIndexString IndexInt
11
0
ContIndexContainer IndexInt
6
0
ItemIndexItem IndexInt
6
0
StrLengthString LengthInt
6
StrFillerString FillerVarChar
1
RelatedToRelated to ItemInt
6
0
NextSegNext Segment Item NumInt
6
0
HightAdjstHeight AdjustmentsVarChar
Y) Yes
N) No
1
N
DupRpttAreDuplicate Repeatative AreaVarChar
Y) Yes
N) No
1
N
LnsRpttAreNum Lines In Repeatative AreaInt
11
0
RptDupDistDistanse To Rptt Dup (pixels)Int
11
0
ItemDescItem DescriptionnVarChar
50
ExportXmlExport to xmlVarChar
Y) Yes
N) No
1
Y
DocType KEYDocument TypenVarChar
4
TYPENo
LocalLocalizationnVarChar
2
NumeratorNumeratorInt
6
LanguageLanguageInt
6
CreatedCreation DateDate
8
UpdatedUpdated DateDate
8
UsrSgnStrUser Sign For Strings ChangeInt
11
-1
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
IsRefIs the item refered by anotherVarChar
Y) Yes
N) No
1
N
FieldIdField IdentifiernVarChar
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
VarDefNameVariable Definition NamenVarChar
50
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
11
-1

SELECT statement

SELECT ITMR.DocCode AS 'Report', ITMR.ItemId AS 'Item ID', ITMR.Container AS 'Parent Type', ITMR.Type AS 'Type', ITMR.VISIBLE AS 'Visible', ITMR.SupZeros AS 'Suppress Zeros', ITMR.ItemLeft AS 'Left Item', ITMR.ItemTop AS 'Top', ITMR.Width AS 'Width', ITMR.Height AS 'Height', ITMR.LMargin AS 'Left Margin', ITMR.RMargin AS 'Right Margin', ITMR.TMargin AS 'Top Margin', ITMR.BMargin AS 'Bottom Margin', ITMR.LeftLine AS 'Left Border Line Thickness', ITMR.RightLine AS 'Right Border Line Thickness', ITMR.TopLine AS 'Top Border Line Thickness', ITMR.BottomLine AS 'Bottom Border Line Thickness', ITMR.Shadow AS 'Shadow Thickness', ITMR.BGRed AS 'Background - Red', ITMR.BGGreen AS 'Background - Green', ITMR.BGBlue AS 'Background - Blue', ITMR.FGRed AS 'Text - Red', ITMR.FGGreen AS 'Text - Green', ITMR.FGBlue AS 'Text - Blue', ITMR.MrkrRed AS 'Bold - Red', ITMR.MrkrGreen AS 'Bold - Green', ITMR.MrkrBlue AS 'Bold - Blue', ITMR.BrdrRed AS 'Border - Red', ITMR.BrdrGreen AS 'Border - Green', ITMR.BrdrBlue AS 'Border - Blue', ITMR.FromPane AS 'From Area', ITMR.ToPane AS 'To Area', ITMR.ItemGroup AS 'Group No.', ITMR.FontName AS 'Font Name', ITMR.FontSize AS 'Font Size', ITMR.TextStyle AS 'Text Style', ITMR.Justific AS 'Horizontal Justification', ITMR.WRAP AS 'Segment', ITMR.PictSize AS 'Picture Size', ITMR.DataSource AS 'Data Source', ITMR.ItemStr AS 'String', ITMR.VarNum AS 'Variable No.', ITMR.FileName AS 'File Name', ITMR.FieldNum AS 'Field No.', ITMR.ShowDescr AS 'Display Description', ITMR.CalcType AS 'Calculation Type', ITMR.ChangFlags AS 'Changeable', ITMR.ApplID AS 'Item No.', ITMR.CalcCol AS 'Calculation Column', ITMR.YJustific AS 'Vertical Alignment', ITMR.SortLevel AS 'Sort Level', ITMR.RevOrder AS 'Reverse Sort', ITMR.SortType AS 'Sort Type', ITMR.IsUnique AS 'Unique', ITMR.IsGroup AS 'Set as Group', ITMR.NewPage AS 'New Page', ITMR.BarCode AS 'Print as Barcode', ITMR.Condition AS 'Condition', ITMR.LinkTo AS 'Link to Item', ITMR.Operator1 AS 'Operator 1', ITMR.Operator2 AS 'Operator 2', ITMR.Operation AS 'Operation', ITMR.BCStandard AS 'Barcode Standard', ITMR.SumInWords AS 'Display Total as a Word', ITMR.ExcFonting AS 'Block Font Change', ITMR.StrIndex AS 'String Index', ITMR.ContIndex AS 'Container Index', ITMR.ItemIndex AS 'Item Index', ITMR.StrLength AS 'String Length', ITMR.StrFiller AS 'String Filler', ITMR.RelatedTo AS 'Related to Item', ITMR.NextSeg AS 'Next Segment Item Num', ITMR.HightAdjst AS 'Height Adjustments', ITMR.DupRpttAre AS 'Duplicate Repeatative Area', ITMR.LnsRpttAre AS 'Num Lines In Repeatative Area', ITMR.RptDupDist AS 'Distanse To Rptt Dup (pixels)', ITMR.ItemDesc AS 'Item Description', ITMR.ExportXml AS 'Export to xml', ITMR.DocType AS 'Document Type', ITMR.Local AS 'Localization', ITMR.Numerator AS 'Numerator', ITMR.Language AS 'Language', ITMR.Created AS 'Creation Date', ITMR.Updated AS 'Updated Date', ITMR.UsrSgnStr AS 'User Sign For Strings Change', ITMR.UsrSgnAttr AS 'User Sign For Attribs Change', ITMR.IsRef AS 'Is the item refered by another', ITMR.FieldId AS 'Field Identifier', ITMR.FGEnabled AS 'Grid Enabled', ITMR.BGEnabled AS 'Background Enabled', ITMR.MKEnabled AS 'Highlight Enabled', ITMR.BDEnabled AS 'Frame Enabled', ITMR.HidEmpRptt AS 'Hide Empty Area', ITMR.RpttFtrAll AS 'Display Rep. Footer on All', ITMR.GbiDataTyp AS 'Data Type', ITMR.GbiDataLen AS 'Data Length', ITMR.PageBreak AS 'Page Break', ITMR.IsLogo AS 'Is Logo', ITMR.VarDefName AS 'Variable Definition Name', ITMR.ResCode AS 'Resource Code from RSBD', ITMR.RevCode AS 'Revision Code' FROM ITMR AS ITMR

Related information




SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates