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