|
|
DTW Inventory / Price Lists / Special Prices / Discount Groups
API EDG1
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
EDG1.AbsEntry AS 'Unique Entry',
EDG1.ObjType AS 'Object Type',
EDG1.ObjKey AS 'Object Key',
EDG1.DiscType AS 'Discount Type',
EDG1.Discount AS 'Discount',
EDG1.PayFor AS 'Paid Qty',
EDG1.ForFree AS 'Free Qty',
EDG1.UpTo AS 'Max. Free Qty',
EDG1.LogInstanc AS 'Log Instance'
FROM EDG1 AS EDG1
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