|
|
DTW Inventory / Item Master Data / Items - Multiple Preferred Vendors
API Items / Items Preferred Vendors
ITM2 - Items - Multiple Preferred Vendors Table
Items Preferred Vendors Items_PreferredVendors Object· Table: ITM2
Parent: Items Items Object· Table: OITM
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Business Partner OCRD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item No. | nVarChar | 20 | OITM Items | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| VendorCode | Vendor Code | nVarChar | 15 | OCRD Business Partner | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object | nVarChar | 20 | ADP1 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
