biuan SAP® BUSINESS ONE SDK
SQL Administration / Password Administration
DTW Purchasing / Blanket Agreement
API OPPA
OPPA - Password Administration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11
1PRIMARYYes
SecLevelSecurity LevelnVarChar
Low) Low
Medium) Medium
High) High
Custom) Custom
20
Low
PwdExpPassword ExpirationInt
11
90
PwdMinLenPassword Minimum LengthInt
11
4
MinUppersPassword Min. Uppercase Chars.Int
11
0
MinLowCasePassword Min. Lowercase Chars.Int
11
0
MinDigitsPassword Minimum DigitsInt
11
0
MinNonAlphPassword Min. Non-alphanumeric Char.Int
11
0
NumPrevPwdPwd does not match pwd rulesInt
11
0
NumAuthLocNo. of Authentications Before Acct is LoInt
11
100
PwdExamplePassword ExamplenVarChar
10
abcd

SELECT statement

SELECT OPPA.AbsEntry AS 'Internal ID', OPPA.SecLevel AS 'Security Level', OPPA.PwdExp AS 'Password Expiration', OPPA.PwdMinLen AS 'Password Minimum Length', OPPA.MinUppers AS 'Password Min. Uppercase Chars.', OPPA.MinLowCase AS 'Password Min. Lowercase Chars.', OPPA.MinDigits AS 'Password Minimum Digits', OPPA.MinNonAlph AS 'Password Min. Non-alphanumeric Char.', OPPA.NumPrevPwd AS 'Pwd does not match pwd rules', OPPA.NumAuthLoc AS 'No. of Authentications Before Acct is Lo', OPPA.PwdExample AS 'Password Example' FROM OPPA AS OPPA

Related information
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