Information on Creating Infoset

[Former Member]

Hi Gurus,

Please let me know, if any one has standard procedure to be followed for creating Infoset, which are used for creating Target Group.

Thanks,

Bhushan

[Former Member · Accepted solution]

hi madhu

In my scenario, i have to create Infoset for creation DATE of BP from table BUT000

i was able to make as per ur guidence, selectingthe fields from BUT000-CRDAT, then we created DATA SOURCE and ATTRIBUTE LIST

But when we created Target Group and select the todays date as value in filter , but we get no BPs assinged to it as per date given.Although BPs are avaible in BUT000 for the specified date.

Thanks,

Bhushan

[Former Member · Accepted solution]

Hi Bhushan,

As I understand, You have to compare the system date with the BP creation date.

You can achieve this by adding the additional field in infoset by inserting the code into the additional field which gives the difference between todays date and BP creation date.

I hope above fulfils your requirement

Let me know if need more details

Reward points if it helps

Regards,

Madhu

[Former Member · Accepted solution]

Hi Madhu,

In our scenario we dont have to compare/difference the BP dates

but as per the filters created it should select the BP.

We have dont like this..

A new infoset is created,which is from table BUT000.

so we want to select the BP which is greater than some date(like 20.01.2008).

All the BP created on or greater than this date should be picked.

I guess some function module is needed during creation of data source,its will be a great if u could suggest something.

I hope i was able to make my issue clear.

Thanks,

SA

[Former Member · Accepted solution]

Hi,

If you want to create a filter with a particular date it will be pretty straight forward.

Create filter for the attribute BUT000-CRDAT and give the criterion as Greater than or equal to and give the particular date from which you want to get the BPs.

I hope it solves your issue.

Reward points if it helps

Regards,

Madhu

[Former Member · Accepted solution]

Hi Madhu,

Well this i have alredy tryed..but during data source creation

when i give the name of the infoset and in bussiness partner as BUT000-CRDAT..its giving me a warning and that is becoz of the function module...

i dont know tht to pass in the function module

I gave CRM_MKTTG_PF_CONV_ID_TO_GUID but i am getting error while creating the filter and Target group as business partner 2008721 does not exist

which i feel is saying for the date,which it is considering as BP.

Pls provide ur valuable guidance..

Thanks,

SA

[Former Member · Accepted solution]

Hi,

You need to select the BP GUID in business partner field of the datasource i.e, BUT000-PARTNER_GUID

I hope you have created infoset using the direct read of table BUT000

It will resolve your issue

Let me know if need any more help

Do reward points if it helps

Regards,

Madhu

[Former Member]

Hi Mahu,

Thanks for the reply...the problem is resolved

Thanks,

Bhushan

[Former Member]

Hi,

You can create the infoset by using the transaction SQ02.

For more information on how to create the info set see the below link.

http://help.sap.com/saphelp_crm60/helpdata/en/e2/74c1ec206711d6b1d500508b6b8b11/frameset.htm

Regards

Srinu

[Former Member]

Hi Bushan,

Follow the below steps for creating infosets

1. Goto the transaction code SQ02

2. Give the Z infoset Name in the infoset field and click on create button

3. Give the name of the infoset in the pop up screen

4. Select any one the methods

a. table join using basis table

b. direct read of table

c. logical database

d. data retrival program

5. Give the selection values for the datasource ( for example BUT000 for direct read of table)

6. Give the field selection

7. Generate the infoset

8. Save the infoset

The above saved infoset can be seen in the create datasource screen.

Hope it gives you the clarity

Reward points if it helps

Regards,

Madhu