|
|
API SRA3
SRA3 - Scheduled Report Recipients Table
Scheduled Report Actions OSRA SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ActionCode KEY UNIQUE | Action Code | Int | 11 | OSRA Scheduled Report Actions | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RecipCode | Recipient Code | Int | 11 | |||||
| ObjType | Object Type | nVarChar | 20 | |||||
| ObjCode | Object Code | nVarChar | 50 | |||||
| Name KEY | Name | nVarChar | 127 | USER | No | |||
| SendInter | Send Internally | VarChar | Y) Yes N) No | 1 | N | |||
| SendEmail | Send as E-Mail | VarChar | Y) Yes N) No | 1 | N | |||
| SendSMS | Send as SMS | VarChar | Y) Yes N) No | 1 | N | |||
| E-Mail Address | nVarChar | 100 | ||||||
| Number | Telephone Number | nVarChar | 100 | |||||
| AttachDAG | Attach DAG | VarChar | Y) Yes N) No | 1 | N | |||
| AttachPDF | Attach PDF | VarChar | Y) Yes N) No | 1 | N | |||
| AttachHTML | Attach HTML | VarChar | 1 | N | ||||
| AttachXML | Attach XML | VarChar | Y) Yes N) No | 1 | N | |||
| ShowResult | Results Visible to User | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
