biuan SAP® BUSINESS ONE SDK
API MDR1
MDR1 - Manual Distribution Rule - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OcrCode KEY UNIQUEFactor CodenVarChar
8OMDR
Manual Distribution Rule
PRIMARYYes
PrcCode KEYCenter CodenVarChar
8OPRC
Cost Center
PROF_IDNo
PrcAmountTotal in CenterNum
20
OcrTotalTotal FactorNum
20
DirectDirectVarChar
Y)
N)
1
N
UserSignUser SignatureInt
6OUSR
Users
ValidFromEffective FromDate
19000101)
8
19000101
ValidToEffective ToDate
8
logInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates