biuan SAP® BUSINESS ONE SDK
SQL Reports / Scheduled Report Parameters
API SRA1
SRA1 - Scheduled Report Parameters Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ActionCode KEY UNIQUEAction CodeInt
11
SECONDARYYes
ParamCodeParameter CodeInt
11
KeyStringParameter Key StringnVarChar
32
KeyNumberParameter Key NumeratorInt
11
ValStringParameter Value StringText
16
ValNumberParameter Value NumberInt
11
ValMoneyParameter Value MoneyNum
20

SELECT statement

SELECT SRA1.ActionCode AS 'Action Code', SRA1.ParamCode AS 'Parameter Code', SRA1.KeyString AS 'Parameter Key String', SRA1.KeyNumber AS 'Parameter Key Numerator', SRA1.ValString AS 'Parameter Value String', SRA1.ValNumber AS 'Parameter Value Number', SRA1.ValMoney AS 'Parameter Value Money' FROM SRA1 AS SRA1

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