Skip to Content

ECC-DBM tables for segmentation in CRM

Hi Experts,

I have a requirement where I have to fetch records from ECC-DBM.

Details:

To fetch customers who were invoiced in a date range (say monthly) from a particular service station.

Now i was able to find the tables in ECC-DBM:

invoice: VBRK

service order: /DBM/VBAK_DB

document flow:/DBM/ORDER03 - this may not be necessary

I used the t code sq02 to create infoset joining the first two tables as shown below:

Now I have to extract "customer" from "invoices" created within a "date range" from a particular "service station"

The fields I have identified here are: sold to party for customer; billing document for invoices ; billing date for billing index and print out for date range and plant for service station

I saved the infoset (with package as local object) and generated the infoset.

Later in CRM I created attribute list with the above infoset.

On using it for segmentation I am not able to see any count hitting in the segmentation profiles.I have a feeling something is not right in infoset creation/design.

I would really appreciate if some one can have a look and suggest me a way out :-)

Seg1.PNG (26.1 kB)
seg2.PNG (57.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on May 07, 2015 at 08:50 AM

    Hi Aneesh,

    Since they are tables from ECC side, So definitely there is no field to get the BP ID or GUID.

    However CRM datasource only can recognize the BP ID or GUID.

    You have to write a post converting function module to convert the customer number to BP ID from the mapping in table CRMM_BUT_CUSTNO.

    Regards,

    Jack Yu

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Aneesh,

      Yes the FM should be assigned while creating the datasource, See the screenshot below:

      There are standard FMs for example to convert the BP ID to BP GUID. In your case you need to develop your own FM to convert the customer number to BP GUID by reading the mapping table

      CRMM_BUT_CUSTNO.

      Hope my answer helps.

      regards,

      Jack Yu

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2015 at 07:55 AM

    Hi Aneesh,

    Use the option contains ID and the field which has the BP id in the tables you have used and then standard FM: CRM_MKTTG_PF_CONV_ID_TO_GUID or CRM_MKTTG_PF_BP_TAB_TO_GUID to convert BP id to GUID.

    Thank

    Apoorv Dhawan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.