biuan SAP® BUSINESS ONE SDK
API SRA3
SRA3 - Scheduled Report Recipients Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ActionCode KEY UNIQUEAction CodeInt
11OSRA
Scheduled Report Actions
PRIMARYYes
RecipCodeRecipient CodeInt
11
ObjTypeObject TypenVarChar
20
ObjCodeObject CodenVarChar
50
Name KEYNamenVarChar
127
USERNo
SendInterSend InternallyVarChar
Y) Yes
N) No
1
N
SendEmailSend as E-MailVarChar
Y) Yes
N) No
1
N
SendSMSSend as SMSVarChar
Y) Yes
N) No
1
N
EmailE-Mail AddressnVarChar
100
NumberTelephone NumbernVarChar
100
AttachDAGAttach DAGVarChar
Y) Yes
N) No
1
N
AttachPDFAttach PDFVarChar
Y) Yes
N) No
1
N
AttachHTMLAttach HTMLVarChar
1
N
AttachXMLAttach XMLVarChar
Y) Yes
N) No
1
N
ShowResultResults Visible to UserVarChar
Y) Yes
N) No
1
Y

SELECT statement

SELECT SRA3.ActionCode AS 'Action Code', SRA3.RecipCode AS 'Recipient Code', SRA3.ObjType AS 'Object Type', SRA3.ObjCode AS 'Object Code', SRA3.Name AS 'Name', SRA3.SendInter AS 'Send Internally', SRA3.SendEmail AS 'Send as E-Mail', SRA3.SendSMS AS 'Send as SMS', SRA3.Email AS 'E-Mail Address', SRA3.Number AS 'Telephone Number', SRA3.AttachDAG AS 'Attach DAG', SRA3.AttachPDF AS 'Attach PDF', SRA3.AttachHTML AS 'Attach HTML', SRA3.AttachXML AS 'Attach XML', SRA3.ShowResult AS 'Results Visible to User' FROM SRA3 AS SRA3

Related information


Scheduled Report Actions OSRA SQL Table



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