Skip to Content

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

Query Required

Hi,

My customer uses batch transaction they get the same material from different vendors. to keep track of vendor wise items they are using batch in every transaction.

They need prefix for batch number should start based on vendor code.

i.e If they purchase material from vendor ABC in batch number ABC should come automatically and they will enter some suffix.

I think this is possible through FMS. Can any one tell me the query for the above mentioned scenario?

Thanks in Advance

Shashi

Former Member
Former Member replied

shashi,

Test this query

SELECT LEFT(T0.CardName,3) FROM OPDN T0
WHERE T0.CardCode = $[$4.0.0]

Jeyakanthan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question