|
|
API OEDG
OEDG - Discount Groups Table
OEDG SQL 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 KEY UNIQUE | Object Code | nVarChar | 15 | CODE_TYPE | Yes | |||
| 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 |
Table relationship map
SELECT statement
SELECT
OEDG.AbsEntry AS 'Unique Entry',
OEDG.Type AS 'Type',
OEDG.ObjType AS 'Object Type',
OEDG.ObjCode AS 'Object Code',
OEDG.DiscRel AS 'Disc. Relations',
OEDG.ValidFor AS 'Active',
OEDG.ValidForm AS 'Active From',
OEDG.ValidTo AS 'Active To',
OEDG.DataSource AS 'Data Source',
OEDG.UserSign AS 'User Form',
OEDG.LogInstanc AS 'Log Instance',
OEDG.UserSign2 AS 'Updating User',
OEDG.CreateDate AS 'Creation Date',
OEDG.UpdateDate AS 'Update Date'
FROM OEDG AS OEDG
Related information
OEDG SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
