|
|
API MDR1
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 | Center Code | nVarChar | 8 | OPRC Cost Center | PROF_ID | No | ||
| PrcAmount | Total in Center | Num | 20 | |||||
| OcrTotal | Total Factor | Num | 20 | |||||
| Direct | Direct | VarChar | Y) N) | 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
MDR1.OcrCode AS 'Factor Code',
MDR1.PrcCode AS 'Center Code',
MDR1.PrcAmount AS 'Total in Center',
MDR1.OcrTotal AS 'Total Factor',
MDR1.Direct AS 'Direct',
MDR1.UserSign AS 'User Signature',
MDR1.ValidFrom AS 'Effective From',
MDR1.ValidTo AS 'Effective To',
MDR1.logInstanc AS 'Log Instance',
MDR1.UserSign2 AS 'Updating User',
MDR1.updateDate AS 'Date of Update'
FROM MDR1 AS MDR1
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