Find the details of the UDT(user defined Tables) in ivend after integration from SAP.
Product Version:
iVend 6.5 update 6 with SAP B1 Version 9.3
Problem Statement:
To find the details of the UDT(user defined Tables) in iVend once integrated from SAP.
Proposed Solution:
To find the details of UDT in iVend which are integrated in iVend one can refer to the below path in iVend MC:
Reports > Designer/Label > Query Builder
Refer to the attached screenshot.
This information can also be found from SQL server as well. In CXSRetail DB you can find the information of UDT from below query:
select * from CfgUserDefinedTable
Now to find the ROW detail of each user-defined table, one can directly search the table name that was created in SAP in the iVend database and from the iVend query builder as well. Refer to the attached screenshots.
Related Articles
General Settings in SAP Business One
Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...SAP Business One - iVend Retail Integration Points
Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"
*****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...