How to get brand wise user list in CRM system (which table)?

[Former Member]

I'm working on SAP Netweaver SAP CRM 7.0 / NW7.01

I got request for taking over users list in brand wise.

This info where we will get i mean which table?

Can anyone help me on this.

[Former Member]

Hi Karthik,

Could you please give me some more info regarding to your request?

I do not understand what do you need. Which object are you refering to? SAP Users, Products, etc.

Best regards, Marcelo.

[Former Member]

Hello Rosati,

In my client project there are multiple regions and in every region having multiple brands. so how can i take brandwise users list.

Thanks,

Karthik

[Former Member]

Hi Karthik,

How r u maintaining brands of those regions with regards to the user related information? Can u furthere eloborate your query please?

Regards,

Arun V.

[Former Member]

Karthik,

I still have doubts on the genral requirement but there is an extract from an old post I think could help you:

Transaction u2013 COMM_PCAT_ADM

Menu path u2013 SAP menu --> Master Data --> Product Catalog --> Maintain Product catalog.

For any product catalog the Product catalog area , sub product catalog areas & products

In other words Brands & Brands with price family (note u2013 the above relation is with respect to views & this relation is for all i.e. not related to views).

COMM_PCAT_HDR

Table Name     Field Name     Description

COMM_PCAT_HDR  ( Product Catalog  )     GUID     Product Catalog guid

     ID     Product ID

All the Product Catalogs can be found in this table ( In YORK scenario we have EQUIPMENTS , PARTS & LITERATURE )

COMM_PCAT_CTY

Table Name     Field Name     Description

COMM_PCAT_CTY  (Product Catalog Area )     PARENT_CATALOG     Product Catalog GUID (from comm_pcat_hdr)

     PARENT_CATEGORY     GUID of a Product Catalog Area

Relation between COMM_PCAT_HDR,

          COMM_PCAT_CTY.

GUID ( comm_pcat_hdr ) = PARENT_CATALOG  ( comm_pcat_cty ) .

PARENT_CATEGORY ( comm_pcat_cty )  = 0 ( For initial value )

= GUID ( comm_pcat_cty ) from the previous Product Catalog Area  .

We start with PARENT_CATEGORY = 0 & PRODUCT_CATALOG = guid from comm_pcat_hdr we get the initial Product catalog area or the Brand.

The Guid from the previous Product catalog area when put in Parent category we get the

Sub Product catalog area. When the sub product catalog area ends we find the no of entries to be 0 in this table i.e the  products have reached . we take the last guids & place it in table

COMM_PCAT_ITM u2013 product catalog item field PARENT CATEGORY and also give the Parent Catalog & we get the Object guids which are

Nothing but guid of the products .we place these Object guids in table COMM_PRODUCT

Field GUID and we find the products in this product catalog area with specific brand & price family.

COMM_PCAT_ITM

Table Name     Field Name     Description

COMM_PCAT_ITM  ( Product Catalog  Item )     PARENT_CATALOG     Product Catalog GUID (from comm_pcat_hdr)

     PARENT_CATEGORY     GUID of a Product Catalog Area

Relation between COMM_PCAT_ITM,

          COMM_PCAT_CTY.

PARENT_CATALOG ( comm_pcat_itm ) = GUID  ( comm_pcat_hdr corresponding catalog guid ) .

PARENT_CATEGORY( comm_pcat_itm ) = GUID  ( comm._pcat_cty ).

COMM_PRODUCT

Table Name     Field Name     Description

COMM_PRODUCT  ( Product  )     PRODUCT_GUID     Internal Unique ID of Product

     PRODUCT_ID     Product ID

Relation between COMM_PCAT_ITM,

          COMM_PRODUCT.

OBJECTGUID ( comm_pcat_itm ) = PRODUCT_GUID  ( comm_product ) .

COMM_PRSHTEXT

Table Name     Field Name     Description

COMM_PRSHTEXT  ( Product text )     PRODUCT_GUID     Internal Unique ID of Product

     LANGU     Language

Table :- TFDIR

Table description :-      Function Module   

Field :-          FUNCNAME

Field description :-     Name of Function Module

Field :-          PNAME

Field description :-     Program name

Table :- TNRO

Table description :-      Definition of Number Range Objects

Field :-          OBJECT 

Field description :-     Name of number range object

Table :- NRIV

Table description :-      Number Range Intervals

Field :-          OBJECT 

Field description :-     Name of number range object

Table :- USREFUS

Table description :-      Reference user for internet applications

Field :-          BNAME 

Field description :-     User Name in User Master Record

****_T

Table Name     Field Name     Description

Any table name TABLE **_T

( Description of the table )     PARENT_ CATEGORY     GUID ( from the table of whose description is seeked )

COMM_PCAT_CTV

Table Name     Field Name     Description

COMM_PCAT_CTV  (Product Catalog Area version )     PARENT_ CATEGORY     Product Catalog Area GUID ( from comm_pcat_cty )

     ACTIVE     u2018Xu2019 if the Product Area is ACTIVE

COMM_PCAT_ITV

Table Name     Field Name     Description

COMM_PCAT_ITV  (Product Catalog Item version )     PARENT_ITEM     Product GUID (from comm_product)

     ACTIVE     u2018Xu2019 if the Product is ACTIVE

And check the following link if you need to integrate with ERP:

Best regards, Marcelo.