biuan SAP® BUSINESS ONE SDK
DTW Inventory / Inventory Transactions / Inventory Posting
API MAP1
MAP1 - Input and Output of Mapping Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MapID KEY UNIQUEMapping IDInt
11OMAP
Mapping Elements
PRIMARYYes
CodeCodeInt
11
TypeTypenVarChar
CRYSTAL) Crystal Report
XML) XML File
NA) Not Avalible
TXT) Text File
CSV) CSV File
10
NA
RuleTypeRule TypenVarChar
XSLT) XSLT Rule
NA) Not Avalible
REGEX) Reguler expression
10
NA
RuleRefRule Reference IDnVarChar
50
RefIDReference IDnVarChar
50
RuleVerRule VersionnVarChar
5
IsFinalIs Final ResultVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT MAP1.MapID AS 'Mapping ID', MAP1.Code AS 'Code', MAP1.Type AS 'Type', MAP1.RuleType AS 'Rule Type', MAP1.RuleRef AS 'Rule Reference ID', MAP1.RefID AS 'Reference ID', MAP1.RuleVer AS 'Rule Version', MAP1.IsFinal AS 'Is Final Result' FROM MAP1 AS MAP1

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