on 05-06-2015 1:15 PM
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 🙂
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.