Material description in APO

[Former Member]

hello all,

i would like to know how can material description can be copied to APO DP, we are trying to load a sales history in a cube then create CVC and load the history in planning area, so my question is how does material description gets copied to APO.

[satish_waghmare3 · Accepted solution]

Hello Ganesh

You need to follow following steps -

1. Load data into Infoobjects for attributes and texts. Text is basically description.  Using Tcode: RSA1, you will be able to see these infobjects and what data in contains.

It is important to load data for both attribute and text in Infoobjects used in APO-DP. Otherwise descriptions will not be visible in APO-DP.

2. Load SO History into Infocube (DataSource -> Infopackage -> PSA -> Data Transformation and DTP -> DSO -> Data Transformation and DTP-> Infocube)

3. Create CVCs in MPOS (tcode: /SAPAPO/MC62)

4. Load SO History into DP Planning Area (tcode: /SAPAPO/TSCUBE)

The description in the CVC is fetched using "Text" loaded in the infoobject.  This applies to Material as well.

Hope this answers.

Thank you

Satish Waghmare

[Former Member · Accepted solution]

Thanks satish, when you are talking about attribute your talking about characteristics not nav attribute.

[satish_waghmare3 · Accepted solution]

Hello Ganesh,

While Loading data into your Characteristic Infoobjects such as Material and Customer etc.  You need to use DataSource of type "Master Data" to load the actual data values and also use DataSource of type "Texts" to load the Texts (Short/Medium/Long descriptions)

If there are limited and fixed values then you can manually update the description in the infoobject.

Let us say you have characteristic - "Region" infooject having only five possible values. So it is better to maintain these entries manually into the Infoobject. To do that Right click on the infoobject -> Select "Maintain master data"

Region Code     Region Description

010                     East

020                     West

030                     North

040                     South

050                     Central

For every infoobject, you will see two tables like below

/BIC/TZREGION -- Text Table

/BIC/PZREGION ---Master Data Table

You should consult your local BI consultant for all such questions, it would help in getting quicker and better understanding.

Hope this answers.

Thank you

Satish Waghmare

[former_member182607]

ganesh,

I am sure you have a BI resource on the project. thiese are all standard tranactions between ECC/APO?BI. You should be able to load the description into table /BIC/T*, which is the text table for the object.

Thanks,

Subash