data filtering in MB26

[dip_kumar]

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????????/

[dip_kumar]

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????????/

[Former Member]

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

[agnihotro_sinha2]

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.

[dip_kumar]

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