Skip to Content
0

Table for the Data source 1CL_OMAT003 and 1CL_OMAT006 in SAP BW R3 system

May 18, 2017 at 12:25 PM

291

avatar image

hello Experts,

Can you please tell me tables for the Data source 1CL_OMAT003 and 1CL_OMAT006 in SAP BW R3 system.

Thanks,

Ipsita

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Ipsita Kundu May 18, 2017 at 12:41 PM
0

Hello experts,

Anyone can help me out by telling the program name to update data from MARA table to the data sources 1CL_OMAT003 and 1CL_OMAT006.

Thanks,

Ipsita

Share
10 |10000 characters needed characters left characters exceeded
Frédéric Cincet May 18, 2017 at 01:06 PM
0

Hello Ipsita,

Thus dataSources extract data from the classification. They are created with transaction CTBW on the ECC side. There, you define wich class type on which object you want to extract.

There is quite a lot of tables involved in classification. The main one is the AUSP table where you assign a characteristic value (ex : a color) to an object (ex : a material).

Regards,

Frederic

Share
10 |10000 characters needed characters left characters exceeded
Ricardo Inácio May 18, 2017 at 01:23 PM
0

Hi;

These are classification datasources:

https://blogs.sap.com/2012/05/21/creation-of-a-classification-datasource-and-its-related-dataflow/

You will not find that data in MARA.

Go to MM03 and tab Classification.

Hope it helps;

Regards

Share
10 |10000 characters needed characters left characters exceeded
Ipsita Kundu May 18, 2017 at 02:08 PM
0

Hello Experts,

When I am loading data from 1CL_OMAT003 and 1CL_OMAT006, no data is loading as there is 0 number of data in RSA3 for these data source.

How can I fill these data sources??

Thanks,

Ipsita

Show 6 Share
10 |10000 characters needed characters left characters exceeded

They are automatically filled. If there is no value, you should have an issue with the customizing of this dataSource (transaction CTBW).

Regards,

Frederic

0

Hello Frederic,

In CTBW transaction these 2 data source the main stat is "R".Please check the screenshot attached herewith.capture.png

Is it the reason for which data is not coming??

Thanks,

Ipsita

capture.png (41.1 kB)
0

Hi Ipsita,

Status R is normal. Can you check if the client (115 hereunder) is the good one ?

Regards,

Frederic

capture.png (11.3 kB)
0

Hello Frederic,

I have checked the client.

For that DS, client is not same as the system.Client is 200 and the system which i have opened is 220.

And the Info-package in the BW side ,the source is also mentioned as 220.

Can it be the problem??

Thanks,

Ipsita

0

Yes, the client has to be the client from which data is extracted.

0

Hello Frederic,

I have changed the client and loaded it.But still it is loading 0 number of data.

After changing the client should I activate it ??

There is no option for activation I just changed it and saved it,Will it work??

Thanks,

Ipsita

0
Ipsita Kundu May 23, 2017 at 08:09 AM
0

Hello Experts,

When I am loading data from 1CL_OMAT003 and 1CL_OMAT006, no data is loading as there is 0 number of data in RSA3 for these data source.

These 2 Data sources are using the FM “CTBW_GET_CLASSIFY_DATA" . The table AUSP, 0MATERIAL_ATTR , MARA all have data.

How can I identify why these 2 data sources 1CL_OMAT003 and 1CL_OMAT006 are loading 0 number of data

Thanks,

Ipsita

Share
10 |10000 characters needed characters left characters exceeded