cancel
Showing results for 
Search instead for 
Did you mean: 

ECC-DBM tables for segmentation in CRM

former_member184510
Active Participant
0 Kudos

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 🙂

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

former_member184510
Active Participant
0 Kudos

Thanks Jack!

I am a little confused here.

Step 1: will be to create the info set with the ECC tables.

Step 2: Is to create the data source using the ECC infoset.

At what stage do I use this FM using CRMM_BUT_CUSTNO ?


Also I assume I assign the FM while creating the data source. Kindly let me know if you feel otherwise.

Regards,

Aneesh

0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

former_member184510
Active Participant
0 Kudos

Hi Apoorv,

I tried with this FM as well but could not get anything coming up in filters.

Is there anything missing at this level?

Regards,

Aneesh