MBLB Report functional spec

[Former Member]

Dear Friends,

Client Required MBLB Report his own format that is.

Vendor Name : XXXXXXXX ADDERS: XXXXXX City: XXXXXX

Material Name , Material description, Plant, Batch, Unrestricted Qty, In quality inspection, Restricted use, BUN, DCNO, PONO.

Client required above format so i have to give functional spec to ABAP Consultant.

So please tell me from which tables and fields i have to pickup data.

Client Required DC wise Report Relating to particular Vendor.

I tried But i didnot get.

It is urgent help me.

Regards,

Basha.

[Former Member]

Thanks for your reply,

Client required DC wise Out standing material balance Qty at subcontractor. ( issue - received )

we got DC NOs from J_1IEXCDTL Table.

Now how to get DC Wise Material Received ? MIGO

How to get DC Wise Issuing material If issuing material is reversed?

Regards,

Basha.

[madhu_vadlamani]

Hi Basha,

Have you seen mkpf and mseg tables.

Regards,

Madhu.

[Former Member]

I want link table MIGO to DC.

When issuing doc reversed then PO No is not displayed in MSEG tables for Reverse documents so how to find po NO for reversing document.

I saw mseg table and MKPF Table but there is no link to DC wise.

Regards,

Basha.

[Former Member]

Any one can help me

[madhu_vadlamani]

Hi Basha,

This is the report behind this RM07MLBB. If you go through the report you will get all the tables .Check this and post if need help.

Sit with your abapper and make a doc.

Regards,

Madhu.

[Former Member]

hi

you can use details

MBLB RM07MLBB Stocks at Subcontractor MBNK .

ObjectDepend OITM1 RAMODWRD

User name for user field 1 OITM10 RAMODWRD

Regards

sangita