Skip to Content

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

hello Experts,

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

Thanks,

Ipsita

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • May 18, 2017 at 12:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 18, 2017 at 01:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2017 at 01:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 18, 2017 at 02:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • May 23, 2017 at 08:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded