SAP APO TABLE FOR PRODUCT ABOUT SELECTION ID'S

[Former Member]

Hello SAP Gurus, I was trying to google find about a requirement. I wanted to know the table to know about a product saved in what all the selection id's. Please help me about the table name or any other way to find the same...Thanq

[rajkj · Accepted solution]

Hi Santosh,

The following tables might be helpful to you to build the query.

/SAPAPO/TS_SELKO - Header and stores the association between planning book, data view, and selection id.

/SAPAPO/TS_SELPO - Selection ids and characteristics values

Pl. verify the view /SAPAPO/TS_SEL for details.

Use planning area, data view, and IOBJNM as 9AMATNR as selection criteria.

Thanks,

Rajesh

[Former Member · Accepted solution]

Hi Rajesh,

Thanq for the input... However i'm not looking at the charecter level, Im looking at the charecter value level. To be clear, suppose we have a product Lux with few combinations saved in different selection ID's. I would like to know that in what all selection ID's charecterstic value LUX is saved. Hope i'm clear with my query.

Thanq in Advance.

[rajkj · Accepted solution]

Hi

/SAPAPO/TA_SELPO table stores the characteristic values i.e. LUX. The product characteristic name is 9AMATNR.

Thx

[Former Member · Accepted solution]

Thanq Rajesh... I just overlooked... You were right...

/SAPAPO/TA_SELPO  thats what I was looking for... Thq for the help