biuan SAP® BUSINESS ONE SDK
SQL Others / Resource Administration
API RADM
RADM - Resource Administration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DevGroupDevelopment GroupnVarChar
3
ResVersion KEY UNIQUEResource VersionnVarChar
5
PRIMARYYes
ReleaseDteRsleade DateDate
8
RelFrzDateGUI Freeze Date for ReleaseDate
8
Sp1DateSP1 DateDate
8
Sp1FrzDateGUI Freeze Date for SP1Date
8
Sp2DateSP2 DateDate
8
Sp2FrzDateGUI Freeze Date for SP2Date
8
DbLockedIs DB Locked for EditInt
0
1) GUI Freeze (Translations)
2) Read Only
3) Full Lock
11
DbVersionResource DB VersionnVarChar
10
CreateDateCreation Date of DBDate
8
CreateTimeCreation Time of DBInt
11
0
CanLoginCan Users LoginVarChar
1
ValidPathValid Path For RunningnVarChar
100
P4PathP4 Version PathnVarChar
100
MDVersionMetadata VersionInt
11
-1
VerScpDateVersion Scope DateDate
8
VerScpTimeVersion Scope TimeInt
11
0
TransVerTranslation VersionnVarChar
10
FlagsResource flagsnVarChar
100
WpFileNameWallpaper File NamenVarChar
100
NotSet

SELECT statement

SELECT RADM.DevGroup AS 'Development Group', RADM.ResVersion AS 'Resource Version', RADM.ReleaseDte AS 'Rsleade Date', RADM.RelFrzDate AS 'GUI Freeze Date for Release', RADM.Sp1Date AS 'SP1 Date', RADM.Sp1FrzDate AS 'GUI Freeze Date for SP1', RADM.Sp2Date AS 'SP2 Date', RADM.Sp2FrzDate AS 'GUI Freeze Date for SP2', RADM.DbLocked AS 'Is DB Locked for Edit', RADM.DbVersion AS 'Resource DB Version', RADM.CreateDate AS 'Creation Date of DB', RADM.CreateTime AS 'Creation Time of DB', RADM.CanLogin AS 'Can Users Login', RADM.ValidPath AS 'Valid Path For Running', RADM.P4Path AS 'P4 Version Path', RADM.MDVersion AS 'Metadata Version', RADM.VerScpDate AS 'Version Scope Date', RADM.VerScpTime AS 'Version Scope Time', RADM.TransVer AS 'Translation Version', RADM.Flags AS 'Resource flags', RADM.WpFileName AS 'Wallpaper File Name' FROM RADM AS RADM

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