biuan SAP® BUSINESS ONE SDK
DTW Sales / Return
API OPRO
OPRO - Property Object Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEProperty IDInt
11
PRIMARYYes
MapID KEY UNIQUEMapping IDInt
11OMAP
Mapping Elements
CODE_NAMEYes
CodeInput/Output CodeInt
11
TypeProperty TypenVarChar
Strin) String
XML) XML
String)
6
Strin
NameProperty NamenVarChar
50
IsBlobIs BLOB TypeVarChar
Y)
N)
1
TValueText ValuenVarChar
127
BValueBLOB ValueText
16
EncodingEncodingnVarChar
base64)
20

SELECT statement

SELECT OPRO.AbsEntry AS 'Property ID', OPRO.MapID AS 'Mapping ID', OPRO.Code AS 'Input/Output Code', OPRO.Type AS 'Property Type', OPRO.Name AS 'Property Name', OPRO.IsBlob AS 'Is BLOB Type', OPRO.TValue AS 'Text Value', OPRO.BValue AS 'BLOB Value', OPRO.Encoding AS 'Encoding' FROM OPRO AS OPRO

Related information


Mapping Elements OMAP SQL Table



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