biuan SAP® BUSINESS ONE SDK
SQL Administration / Subtable of OTRN
API TRN1
TRN1 - Subtable of OTRN Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TrnAbsEntr KEY UNIQUEOTRN Abs EntryInt
11
UniqueIdxYes
LineNumLine Number of TableInt
11
ItemCodeItem CodenVarChar
127
ItemTypeItem TypenVarChar
8
SlimTypeSlim TypenVarChar
8
MaxLengthMax. LengthInt
11
SourceTextSource TextText
16
MemoMemoText
16

SELECT statement

SELECT TRN1.TrnAbsEntr AS 'OTRN Abs Entry', TRN1.LineNum AS 'Line Number of Table', TRN1.ItemCode AS 'Item Code', TRN1.ItemType AS 'Item Type', TRN1.SlimType AS 'Slim Type', TRN1.MaxLength AS 'Max. Length', TRN1.SourceText AS 'Source Text', TRN1.Memo AS 'Memo' FROM TRN1 AS TRN1

Related information
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