|
|
API OAT3
OAT3 - Item Details: Activity Table
Activities OCLG SQL Table
Blanket Agreement OOAT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AgrNo KEY UNIQUE | Agreement No. | Int | 11 | OOAT Blanket Agreement | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AgrLnNum | Agreement Line Number | Int | 11 | |||||
| AgrEfctNum | Line Number | Int | 11 | |||||
| ActivityID | Activity ID | Int | 11 | OCLG Activities | ||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
OAT3.AgrNo AS 'Agreement No.',
OAT3.AgrLnNum AS 'Agreement Line Number',
OAT3.AgrEfctNum AS 'Line Number',
OAT3.ActivityID AS 'Activity ID',
OAT3.LogInstanc AS 'Log Instance'
FROM OAT3 AS OAT3
Related information
Activities OCLG SQL Table
Blanket Agreement OOAT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
