|
|
API AEDG
AEDG - Discount Groups Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Unique Entry | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Type | Type | VarChar | A) All BPs C) Customer Group V) Vendor Group S) Specific BP | 1 | ||||
| ObjType | Object Type | nVarChar | -1) 10) Card Payment Groups 2) Cards | 20 | -1 | |||
| ObjCode | Object Code | nVarChar | 15 | |||||
| DiscRel | Disc. Relations | VarChar | L) Lowest Discount H) Highest Discount A) Average S) Total M) Discount Multiples | 1 | L | |||
| ValidFor | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| ValidForm | Active From | Date | 8 | |||||
| ValidTo | Active To | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Form | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Update Date | Date | 8 |
SELECT statement
SELECT
AEDG.AbsEntry AS 'Unique Entry',
AEDG.Type AS 'Type',
AEDG.ObjType AS 'Object Type',
AEDG.ObjCode AS 'Object Code',
AEDG.DiscRel AS 'Disc. Relations',
AEDG.ValidFor AS 'Active',
AEDG.ValidForm AS 'Active From',
AEDG.ValidTo AS 'Active To',
AEDG.DataSource AS 'Data Source',
AEDG.UserSign AS 'User Form',
AEDG.LogInstanc AS 'Log Instance',
AEDG.UserSign2 AS 'Updating User',
AEDG.CreateDate AS 'Creation Date',
AEDG.UpdateDate AS 'Update Date'
FROM AEDG AS AEDG
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
