|
|
API ADG1
ADG1 - Discount Groups Rows Table
Discount Groups OEDG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Unique Entry | Int | 11 | OEDG Discount Groups | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ObjType | Object Type | nVarChar | 52) Item Groups 8) Item Properties 43) Manufacturer 4) Items | 20 | ||||
| ObjKey | Object Key | nVarChar | 20 | |||||
| DiscType | Discount Type | VarChar | D) Discount P) Pay for/Get for Free | 1 | D | |||
| Discount | Discount | Num | 20 | |||||
| PayFor | Paid Qty | Num | 20 | |||||
| ForFree | Free Qty | Num | 20 | |||||
| UpTo | Max. Free Qty | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
SELECT statement
SELECT
ADG1.AbsEntry AS 'Unique Entry',
ADG1.ObjType AS 'Object Type',
ADG1.ObjKey AS 'Object Key',
ADG1.DiscType AS 'Discount Type',
ADG1.Discount AS 'Discount',
ADG1.PayFor AS 'Paid Qty',
ADG1.ForFree AS 'Free Qty',
ADG1.UpTo AS 'Max. Free Qty',
ADG1.LogInstanc AS 'Log Instance'
FROM ADG1 AS ADG1
Related information
Discount Groups OEDG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
