|
|
API RTL1
RTL1 - Resource Transaction Log Table
Resource Transaction Log ORTL SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | LogEntry KEY UNIQUE | Log Entry ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| StdCostNum | Resource Standard Cost Number | Int | 11 | |||||
| BaseLogEnt | Base Log Entry ID | Int | 11 | ORTL Resource Transaction Log | -1 | |||
| DocQty | Doc. Quantity | Num | 20 | |||||
| Price | Price | Num | 20 | |||||
| Total | Total | Num | 20 | |||||
| OpenTotal | Open Total | Num | 20 |
SELECT statement
SELECT
RTL1.LogEntry AS 'Log Entry ID',
RTL1.StdCostNum AS 'Resource Standard Cost Number',
RTL1.BaseLogEnt AS 'Base Log Entry ID',
RTL1.DocQty AS 'Doc. Quantity',
RTL1.Price AS 'Price',
RTL1.Total AS 'Total',
RTL1.OpenTotal AS 'Open Total'
FROM RTL1 AS RTL1
Related information
Resource Transaction Log ORTL SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
