topic Re: data filtering in MB26 in Application Development and Automation Discussions

data filtering in MB26

dip_kumar — Thu, 13 May 2010 11:18:43 GMT

while entering plant and storage location for Tcode MB26 (associated with table RESB) only filtered data is displayed ....but with tcode se16 for table RESB after entering plant and storage location all the possible data is displayed ...

Can u tell me at which point the data is filtered????????/

Re: data filtering in MB26

Former Member — Thu, 13 May 2010 11:28:40 GMT

Hi,

In this report, so many filtering conditions are used to filter data from RESB.

resb~bdart ne 'BB' and
resb~xloek eq space and
not resb~xwaok eq space and
resb~dbskz eq space and
resb~dumps eq space and
resb~rgekz eq space and
resb~kzear eq space and
resb~schgt eq space and
resb~kzkup eq space and
resb~erfmg > 0 and
resb~splkz ne '1'.

Regards

Vinod

Re: data filtering in MB26

agnihotro_sinha2 — Thu, 13 May 2010 11:35:29 GMT

from SE93 -> MB26 -> you can find the name of the program it is associated with.

It is PP_PICK_LIST.

Goto SE38 and analyse this program PP_PICK_LIST.

As pointed out by Vinod, there are a lot of filtering conditions which are applied in this Program.

RESB:


RESB contains order dependant requirements of materials. 
for e.g if you have a sales order then to manufacture this order, you need components. The list of components with qty is in this table. The key of this table is reservation which may be tied to planned order. Inturn planned order is created for a sales order.

ags.

Re: data filtering in MB26

dip_kumar — Thu, 13 May 2010 12:30:17 GMT

Vinod thanks for the reply ..but still the data is not completely filtered in tcode MB26 ....So can u tell me is there any other options left for filtering