Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL Query for automatic creation of Item Code

Hi - A contact of mine is asking this question about SQL Query which is out of my knowledge. Please can anyone help?

Hi,thanks for the help,i've one more problem.i have made a query for automatically creation of item code in item name field but it didn't work.can u help me that it is right or wrong.query that i've made is below.

SELECT       substring ((MAX(T0.ItemCode)), 0,4)cast ((Substring ((MAX(T0.ItemCode)),4,4)1) AS varchar(20))


WHERET0.ItmsGrpCod = $[OITM.ItmsGrpCod]

whenever i execute this query i get an error like this:-  1). [SQL Native Client][SQL Server]Incorrect syntax near the keyword 'SELECT'. 2). [SQL Native Client][SQL Server]Incorrect syntax near 'OITM.ItmsGrpCod'. 3). [SQL Native Client][SQL Server]Statement 'Service Contracts' (OCTR) (s) could not be how could i genrate item code automatically and what is the solution of above error,plz tell me asap.i'll wait for ur reply

Former Member
Not what you were looking for? View more on this topic or Ask a question