biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Master Data / Items - Multiple Preferred Vendors
API Items / Items Preferred Vendors
ITM2 - Items - Multiple Preferred Vendors Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
VendorCodeVendor CodenVarChar
15OCRD
Business Partner
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
4

Table relationship map

SELECT statement

SELECT ITM2.ItemCode AS 'Item No.', ITM2.VendorCode AS 'Vendor Code', ITM2.LogInstanc AS 'Log Instance', ITM2.ObjType AS 'Object' FROM ITM2 AS ITM2

Related information


Items Preferred Vendors Items_PreferredVendors Object· Table: ITM2
Items_PreferredVendors is a child object of the Items object that represents the preferred vendor for the item. Source table: ITM2
   Parent: Items Items Object· Table: OITM
Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Business Partner OCRD 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