GTS How to get commodity code from material master ? function/ table

[Former Member]

Hello,

I have to write a "simple" program in GTS system. (In SD Commodity code is field MARC-STAWN )

The customer wants to enter material numbers ( from x to y )

and the program should display:

Material--

---

Material text--Commodity code

---

validity from--

---

validity to

4711--

---

Maschine_A--123456789

---

05.08.2006--

---

31.12.2008

-

---

124587444--

---

01.01.2009--

---

31.12.9999

4712--

---

Maschine_B--56565689

---

01.12.2007--

---

31.12.2009

(The customer wants to have a look if all Commodity codes in GTS are maintained)

Can someone give me the name of the tables where it is stored in GTS?

Or are there any function calls to get material data?

best regards and many thanks

Norbert

Edited by: Norbert Zanders on Jan 1, 2009 5:08 PM

[Former Member · Accepted solution]

You have to consider the following tables:

/SAPSLL/PNTPR --> product number and GUID

/SAPSLL/PRCTS --> product GUID and GUID of commodity code

/SAPSLL/CTSNUM or /SAPSLL/CTSNUMC--> commodity code (general or country specific)

/SAPSLL/CTSNUMT --> commodity code description

/SAPSLL/PRT --> material description

[Former Member · Accepted solution]

Dear Melanie,

thank you very much for your help.

It works.

I wish you a happy new year

Norbert