Read category in /SAPSLL/PR_PRCON_03

[Former Member]

Hi colleagues,

I need to read the Category field from transaction /SAPSLL/PR_PRCON_03.

Could you please tell me in which table is stored and how can I link in to the product number?

Thank you and kind regards,

Mihai

[former_member215181 · Accepted solution]

Hi Mihai,

The data is held in table /SAPSLL/CTSNUM (field CCNGN).  The link to the Product is through table /SAPSLL/PRCTS and /SAPSLL/PNTPR using field GUID_PR.

In your code, make sure to use the indexes correctly when making the join.  You will also need to consider the validity dates.

Regards,

Dave

[Former Member · Accepted solution]

Hi Dave,

Thank you very much! Your answer is very helpful for me. Regarding validity dates, for which of the tables should I consider them?

Kind regards,

Mihai

[former_member215181 · Accepted solution]

Hi Mihai,

Mostly for /SAPSLL/PRCTS.  It's possible to have several entries for the same Product & Numbering Scheme, but the validities should not overlap.  In other words, the classification depends on the date, so the business should be asking (and your code will answer); "which classification does this Product have for this Numbering Scheme on this Date?"

Good luck,

Dave