5 Replies Latest reply: Mar 25, 2012 12:16 PM by Reetu Varma RSS

how to view CRM material master data

Dheeraj Singh
Currently Being Moderated

i am new in CRM, i wanted to know where we can see Material master data (If any TCode) in CRM if ECC is a source for material

  • Re: how to view CRM material master data
    Anand P
    Currently Being Moderated

    Hi Dheeraj,

    You can find the Product data in Tcode :COMMPR01.

    COMM_PRODUCT is the table where all the Material Master Data will be stored.



  • Re: how to view CRM material master data
    Manfred Feger
    Currently Being Moderated



    Venkat is right.

    ECC Material is called Product in CRM.

    You can search and open products also in CRM Webclient UI, e.g. with role Salespro in the workcenter "Accounts & Products".


    Kind regards


    • Re: how to view CRM material master data
      Dheeraj Singh
      Currently Being Moderated



      Thanks, may i know what all settings we have to do as a prerequisite for middleware connection between CRM & ECC


      • Re: how to view CRM material master data
        Upinder Kaur
        Currently Being Moderated

        Hi Dheeraj

        PFB the Pre-requisite for Middleware connection between CRM & ECC along with the process for Mapping/ downloading Organization Model , products & Business partner.

        Step 1 - Define Logical systems (CRM)

        • In the SAP CRM IMG menu, goto Customer Relationship Management -> CRM Middleware and Related Components -> Communication Setup -> Set Up Logical Systems -> Define Logical System and then New Entries (F5).
        • Save your entries.
        • Now follow the above steps to create a logical system for your ECC system

          Step 2 – Assign logical system to a client (CRM) 

        • Goto tcode SCC4. Alternate path: IMG -> Customer Relationship Managment -> CRM Middleware and Related Components -> Communication Setup -> Set Up Logical Systems -> Assign Logical System to Client.
        • Save your entries.

          Step 3 – Define Logical system (ECC) 

        • In the SAP ERP IMG menu, goto SAP NetWeaver -> Application Server -> IDoc Interface/Application Link Enabling (ALE) -> Basic Settings -> Logical Systems -> Define Logical Systems.
        • Save your entries.

          Step 4 – Assign logical system to a client (ECC)-Tcode –SCC4  

        Step5 - Creating RFC destinations (CRM & ECC).- Tcode- SM59
        Step6 – Maintaining CRM connectivity config tables (ECC)

        • Table CRMCONSUM
        • Table CRMRFCPAR
        • Table CRMPAROLTP
        • Table TBE11 – Activating Event control

        In this table, set the application NDI (New Dimension Integration) to status Active by selecting the check box in the A column.

        Step7 - Select your industry.
        Step 8 - Generate industry specific objects
        Here Select your Industry, & then Select your Application.

        Step9- Generate R/3 Adaptor- Tcode- GNRWB, then Execute Tcode- SMOGTOTAL

        Step10- Start  Queue Demon Tcode- SMOHQUEUE
        Step 11 - Creating Sites, Publications and Subscriptions.
        Tcode- SMOEAC

        Step 12 - Registration of RFC destination. Tcode- SMQS

        Step 13 - Registering the queues.
        In tcode SMQR all the CSA and R3A queues must be registered i.e. Type = R, for the bdocs to flow.

        Step 14- Then comes Mapping , Download & Monitoring

        For Organization Model, you can download orga Model with Tcode- CRMC_R3_ORG_GENERATE

        For Product, you first need to download Product Hierarchy in case no product hierarchy available in CRM. So mapping required for downloading hierarchy.

        This Mapping is first done in ERP & then CRM.

        In ERP check

        1. Material Length (T-code- OMSL)
        2. No of Levels & Characters @each level (Tcode- SE16)

        Now Maintain the same in CRM

        1. To Map Material length got to  path – IMG> Cross Application components>sap product> basic settings >define output format & storage format
        2. To Map no of level & characters go to path- IMG>Cross application Components>Sap product>Define category Numbering schema

        For Business  partner


        1. In ERP Identify A/c group & No range (Tcode- OVT0 & Tcode –OVZC)
        2. Maintain the same in CRM through groupings & Number range.
        3. In ERP Mapping is done through (t-code- PIDE)
        4. In ERP Maintain reference customer (Tcode- VD07)
        5. Maintain & map reference customer in CRM

        Step 15 - Start initial load- Tcode- R3AS
        Step 16 – Object Monitoring- Tcode- R3AM1
        The same can also be done through Middleware Monitoring Cockpit, tcode SMWP.

        Step 17- Queues Monitoring- Tcode- SMQ1 / SMQ2

        Step 18- Bdoc Monitoring- SMW01

        Hope this is helpful.


        Upinder kaur

  • Re: how to view CRM material master data
    Reetu Varma
    Currently Being Moderated

    Hi, you can check in tcode - commpr01 in GUI

    or in web ui u can check but

    material should be downloaded first either by intial load (once i think have done)

    and delta load ( automatic replication once created in ECC --->CRM).


    if your issue like u created material in ECC but you r not able to find out in CRM then

    check your ques first ( ecc-- outbound queue and CRM---inbound queue)  if OK not locked

    then check bdoc in smw01 , if no error

    then go in commpr01 and check it would be there.

    use name or no here in search