Infopackage selection

[Former Member]

Dear friends,

I have to load the data from SAP R/3 source system using an infopackage where 0MATERIAL = 'null'(blank).How I can do this in infopackage?.

could you pls help me with the solution.

Thanks in advance.

Regards

Soujanya

[Former Member · Accepted solution]

Hi,

You can filter values in Infopackage for this you need to write code for specific infoobject in infopackage.

code as follows:

data: l_idx like sy-tabix.

read table l_t_range with key

fieldname = '0MATERIAL'.

l_idx = sy-tabix.

l_t_range-IOBJNM = '0MATERIAL'.

l_t_range-FIELDNAME = '0MATERIAL'.

l_t_range-SIGN = 'I'.

l_t_range-OPTION = 'EQ'.

l_t_range-LOW = ' '.

if l_idx <> 0.

modify l_t_range index l_idx.

else.

append l_t_range.

endif.

p_subrc = 0.

This routine as to write in infopackage for respective Infoobject.

I think this will work.

If Helpful assign points.

Regards,

Rajanikanth Reddy.

[Former Member · Accepted solution]

Thanks a lot Rajani.It worked after applying a small correction.

Assigned points to you.

thanks

Soujanya

[Former Member · Accepted solution]

Soujanya,

Could you please let me know what is the correction you have made to the above mentioned logic by Rajini to pick up the data where the field is having blank value?

It would be very helpful for me in one of the requirement.

Regards,

Yokesh Kumar.

[Former Member]

Now Iam getting the following error message in RSMO.

Error message:

For Sel.Filed 'MATNR' No selection with SIGN = 'I';option E Allowed.

Pls help

Thanks

Ganesh

[Former Member]

we can't assign space with Sign I.

you have 2 options... 2 options...

1. In the User Exit delete records with material Numer ne space.sort E_t_data by /bio/material.

Delete E_t_data where /bio/material ne space.

Or

2. same thing you can write in start routine as well.

sort <data_package> by /bio/material.

Delete <data_package> where /bio/material ne space.

I will try IP routine tomorrow and let you know.

Nagesh Ganisetti.

[Former Member]

Soujanya,

I'm not sure.. how far it will help you...give a try and let me know...

data: l_idx like sy-tabix.
read table l_t_range with key
     fieldname = <b><provide the field Name>.</b>
l_idx = sy-tabix.
l_t_range-low = space.
l_t_range-option = ' EQ'.
l_t_sign = 'I'.
modify l_t_range index l_idx.

p_subrc = 0.

o if this won't work...you want to load the always... you can delete the data in SAP R/3 User Exit.

I guess above code should work.

all the best.

Nagesh Ganisetti.

• Assign points if it helps.

Message was edited by:

Nagesh Ganisetti

[Former Member]

Thanks Nagesh.

I have included this routine.Iam getting the following error message.

E:Field "L_T_SIGN" is unknown. It is neither in one of the specified

tables nor defined by a "DATA" statement. "DATA" statement. "DATA"

statement.

Could you pls help..

Thanks

Soujanya

[Former Member]

I have change it to

L_T_RANGE-SIGN

Now theres no error message

Thanks

Soujanya

Message was edited by:

Soujanya

[Former Member]

Thanks for quick response.

Could you pls help me with the sample code for this?..

Thanks again

Regards

Soujanya

[Former Member]

Hi Sounjanya,

Write a routine in the infopack and load.

Best Regards,

SG