|
|
API AMDR1
AMDR1 - Manual Distribution Rule - Rows Table
Manual Distribution Rule OMDR SQL Table
Cost Center OPRC SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | OcrCode KEY UNIQUE | Factor Code | nVarChar | 8 | OMDR Manual Distribution Rule | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PrcCode KEY | Cost Center Code | nVarChar | 8 | OPRC Cost Center | PROF_ID | No | ||
| PrcAmount | Total in Cost Center | Num | 20 | |||||
| OcrTotal | Total Factor | Num | 20 | |||||
| Direct | Direct | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| ValidFrom | Effective from | Date | 19000101) | 8 | 19000101 | |||
| ValidTo | Effective to | Date | 8 | |||||
| logInstanc | Log Instance | Int | 11 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| updateDate | Date of Update | Date | 8 |
Table relationship map
SELECT statement
SELECT
AMDR1.OcrCode AS 'Factor Code',
AMDR1.PrcCode AS 'Cost Center Code',
AMDR1.PrcAmount AS 'Total in Cost Center',
AMDR1.OcrTotal AS 'Total Factor',
AMDR1.Direct AS 'Direct',
AMDR1.UserSign AS 'User Signature',
AMDR1.ValidFrom AS 'Effective from',
AMDR1.ValidTo AS 'Effective to',
AMDR1.logInstanc AS 'Log Instance',
AMDR1.UserSign2 AS 'Updating User',
AMDR1.updateDate AS 'Date of Update'
FROM AMDR1 AS AMDR1
Related information
Manual Distribution Rule OMDR SQL Table
Cost Center OPRC 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
