|
|
API LIVI1
LIVI1 - IVI Log Array File Table
IVI Log File LIVI SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | LogEntry KEY UNIQUE | Internal Number | Int | 11 | LIVI IVI Log File | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CalcNum | Partial Sequence Number | Int | 11 | |||||
| CreateDate | Create Date | Date | 8 | |||||
| UserToDate | User To Date | Date | 8 | |||||
| ActuToDate | Actual To Date | Date | 8 | |||||
| LastMsgID | Last Calculated OILM Message | Int | 11 | |||||
| Result | Result of Calculation | VarChar | F) Failure S) Success A) Archived | 1 | F | |||
| ResultStr | Result String of Calculation | nVarChar | 127 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| IgnFail | Ignore Previous Failure | VarChar | Y) Yes N) No | 1 | N | |||
| ReorderFrm | Reorder 8.8 Messages: From Date | Date | 8 | |||||
| ReorderTo | Reorder 8.8 Messages: To Date | Date | 8 | |||||
| StopDate | Stop Date | Date | 8 | |||||
| StopTime | Stop Time | Int | 6 |
Table relationship map
SELECT statement
SELECT
LIVI1.LogEntry AS 'Internal Number',
LIVI1.CalcNum AS 'Partial Sequence Number',
LIVI1.CreateDate AS 'Create Date',
LIVI1.UserToDate AS 'User To Date',
LIVI1.ActuToDate AS 'Actual To Date',
LIVI1.LastMsgID AS 'Last Calculated OILM Message',
LIVI1.Result AS 'Result of Calculation',
LIVI1.ResultStr AS 'Result String of Calculation',
LIVI1.UserSign AS 'User Signature',
LIVI1.IgnFail AS 'Ignore Previous Failure',
LIVI1.ReorderFrm AS 'Reorder 8.8 Messages: From Date',
LIVI1.ReorderTo AS 'Reorder 8.8 Messages: To Date',
LIVI1.StopDate AS 'Stop Date',
LIVI1.StopTime AS 'Stop Time'
FROM LIVI1 AS LIVI1
Related information
IVI Log File LIVI SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
