1st time with CRM - need help...

[aris_hidalgo]

Hello Experts,

I was just given a functional spec that involves CRM. I don't have a clue on what to do.

Here is the step by step process based on the spec:

*This report will be sent to the Total Order Management Group-TOMG(CCare) as

advance information on CRM-ISA not passing through SAP R/3.

Steps for uploading:

1. Provide parameter dates from-to defined as the sales order date. Default

date to system if no parameters entered.

2. CRM SAP will extract and send extracted data via e-mail as an attachment.

3. Set e-mail subject to "Non-replication Notice".

4. Get e-mail recipient(s) from sales personnel master of TOMG rep assigned to sold-to codes.

5. send e-mail to TOMG

Proram Logic:

In CRM:

- Select all records from CRMD_ORDERADM_H where created_at within parameter dates

- For every record in CRM, validate the existence in R/3.

- Select in from VBAK where VBAK-VBELN = CRMDORDERADM.OBJECT.ID

- IF record not found in R/3, execute the program CRMD_ORDER_READ in CRM

with parameter VBAK-VBELN as transaction number.

- Use REF_PARTNER_NO to get TOMG Business Partner number from

KNVP-PERNR where PARVW = 'A1', then get e-mail address from P0105-USRID.

- Send e-mail by TOMG rep.

Hope you can help me out here guys. Thank you and take care!

[stephenjohannes · Accepted solution]

Viraylab,

The only thing that looks funny with your logic is that you are trying to determine if some advances did not go to R/3 from CRM. If that is the case then you can't use VBAK-VBELN as the transaction number, because the record did not exist in CRM.

I would slightly adjust your logic as the following:

- Select all records from CRMD_ORDERADM_H where created_at within parameter dates

- For every record in CRM, validate the existence in R/3. Call an RFC to R/3 and then perform the following code: Select in from VBAK where VBAK-VBELN = CRMD_ORDERADM_H.OBJECT.ID

- IF record not found in R/3, execute the function module CRM_ORDER_READ in CRM with the object-guid found from CRMD_ORDERADM_H in the first step

- Use REF_PARTNER_NO to get TOMG Business Partner number from

KNVP-PERNR where PARVW = 'A1', then get e-mail address from P0105-USRID.

- Send e-mail by TOMG rep.

I might be missing something on your requirements but in general I think things look decent minus the one change.

Take care,

Stephen