|
|
SQL Administration / Message Sent
DTW Others / Choose From List
API Message Header / Sent Date
OAOB - Message Sent Table
Sent Date SentDate Property· Table: OAOB
Parent: Message Header MessageHeader Object
Message Header MessageHeader Object Parent: Message Headers MessageHeaders Collection
Alerts OALR SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AlertCode KEY UNIQUE | Alert Code | Int | 11 | OALR Alerts | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| SendDate | Date | Date | 8 | |||||
| SendTime | Time | Int | 6 | |||||
| WasSent | Sent | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign KEY | User Signature | Int | 6 | OUSR Users | USER | No |
Table relationship map
SELECT statement
SELECT
OAOB.AlertCode AS 'Alert Code',
OAOB.SendDate AS 'Date',
OAOB.SendTime AS 'Time',
OAOB.WasSent AS 'Sent',
OAOB.UserSign AS 'User Signature'
FROM OAOB AS OAOB
Related information
Sent Date SentDate Property· Table: OAOB
Returns the sent date (see OAOB table).Field name: SendDate.
Parent: Message Header MessageHeader ObjectMessage Header MessageHeader Object
MessageHeader is a data structure related to the MessagesService. The data is stored temporarily in the memory in a virtual table (at a later stage, the data is stored in the OAOB and OAIB tables).
Source tables:
OAOB (Message Sent).
OAIB...
Parent: Message Headers MessageHeaders CollectionAlerts OALR SQL Table
Users OUSR SQL Table
MessageHeader
Property
SentDate
Method
Property
Code
DB
Read
DB
Received
DB
ReceivedDate
DB
ReceivedTime
DB
SentDate
DB
SentTime
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates