Set Filter on Info Sets

[Former Member]

Hello,

I successfully created an Info Set in our CRM system, which is been used in the Segmentation Builder and delivers ALL partners of a business transaction. (Herefore, I joined the tables CRMD_ORDERADM_H -> CRMD_LINK -> CRMD_PARTNER).

My question is: How can I set a filter on a specific partner fuction, so that only partners of a specific partner function (e.g. Sold-To Party) are returned.

Any help is appreciated.

Thanks in advance,

Gustavo

[Former Member]

In the infoset you can always pass "00000001" as partner function to read only Sold-to's.

[Former Member]

Hello Sekhar,

thank you for your reply, but can you please be more specific.

I want to set a fixed filter, so that only business partners of a specific partner function are shown.

Where do I do your described settings?

Kind regards,

Thorsten

[Former Member]

Hi Thorsten,

In Infoset select CRMD_PARTNER table and click on "Extras". Here you can write your own code to restrict the selection.

Hope this helps!!!

[Former Member]

Hello Sekhar,

thanks again for your reply, but I still need a more specific advice here - or do you even have some example coding?

I was able to set a breakpoint (please see coding below), but I can only put my coding betwen "Start Satzverarbeitung" and "Ende Satzverarbeitung". How do I set the coding, so that just partners of a certain partner function are selected?

One more issue I have is that the relevant filter field "crmd_partner-partner_func" is not available, yet.

Do I have to do another select or how can I get the partner fucntion?

This is the coding from the automatically created selection report:

select CGPL_PROJECT_{GUID CRMD_BRELVONAE}OBJGUID_A_SEL CRMD_BRELVONAE_{OBJGUID_B_SEL CRMD_ORDERADM_H}GUID

CRMD_ORDERADM_H_{PROCESS_TYPE CRM_JEST}OBJNR CRMD_LINK_{GUID_HI CRMD_LINK}GUID_SET CRMD_PARTNER_{GUID CRMD_PARTNER}PARTNER_NO

into (CGPL_PROJECT-GUID , CRMD_BRELVONAE-OBJGUID_A_SEL , CRMD_BRELVONAE-OBJGUID_B_SEL , CRMD_ORDERADM_H-GUID

, CRMD_ORDERADM_H-PROCESS_TYPE , CRM_JEST-OBJNR , CRMD_LINK-GUID_HI , CRMD_LINK-GUID_SET , CRMD_PARTNER-GUID

, CRMD_PARTNER-PARTNER_NO )

from ( CGPL_PROJECT

inner join CRMD_BRELVONAE

on CRMD_BRELVONAE_{OBJGUID_A_SEL = CGPL_PROJECT}GUID

inner join CRMD_ORDERADM_H

on CRMD_ORDERADM_H_{GUID = CRMD_BRELVONAE}OBJGUID_B_SEL

inner join CRM_JEST

on CRM_JEST_{OBJNR = CRMD_BRELVONAE}OBJGUID_B_SEL

inner join CRMD_LINK

on CRMD_LINK_{GUID_HI = CRMD_BRELVONAE}OBJGUID_B_SEL

inner join CRMD_PARTNER

on CRMD_PARTNER_{GUID = CRMD_LINK}GUID_SET )

where CRMD_ORDERADM_H~PROCESS_TYPE in SP$00001.

%dbacc = %dbacc - 1.

if %dbacc = 0.

stop.

endif.

check SP$00001.

• Start Satzverarbeitung

break-point.

• Ende Satzverarbeitung

add 1 to %count-CGPL_PROJECT.

%linr-CGPL_PROJECT = '01'.

extract %fg01.

endselect.

Thanks in advance,

Gustavo