biuan SAP® BUSINESS ONE SDK
SQL Reports / Scheduled Report Run Output
API SRA2
SRA2 - Scheduled Report Run Output Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ActionCode KEYAction CodeInt
11
ACTIONCODENo
DateDate of RunDate
8
TimeTime of RunInt
11
StatusStatusVarChar
S) Successful
E) In progress
F) Failure
T) Results to Be Distributed
0
1) Report Scheduled
1
0
ReturnCodeReturn CodeInt
11
ReturnStrReturn StringnVarChar
127
ResDagResult in DAG formatText
16
ResPdfResult in PDF formatText
16
ResHtmlResult in HTML formatText
16
ResXmlResult in XML formatText
16
ResultsResult AvailabilitynVarChar
10
NNNN
ResLogReport Creation LogText
16
ErrScreenError ScreenshotText
16

SELECT statement

SELECT SRA2.ActionCode AS 'Action Code', SRA2.Date AS 'Date of Run', SRA2.Time AS 'Time of Run', SRA2.Status AS 'Status', SRA2.ReturnCode AS 'Return Code', SRA2.ReturnStr AS 'Return String', SRA2.ResDag AS 'Result in DAG format', SRA2.ResPdf AS 'Result in PDF format', SRA2.ResHtml AS 'Result in HTML format', SRA2.ResXml AS 'Result in XML format', SRA2.Results AS 'Result Availability', SRA2.ResLog AS 'Report Creation Log', SRA2.ErrScreen AS 'Error Screenshot' FROM SRA2 AS SRA2

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