CIN: How to check the material document posted without excise invoice

[pakornpholpong]

Hi Guru,

Please advise how to check the material document posted without excise invoice.

I have tried tcode J1I7 but it seems start to collect the excise invoice first and then material document.

But my case is to find the material document WITHOUT excise invoice for internal tracking purpose.

At the moment we start from tcode MB51 to get the list of material document and check in J_1IEXCHDR / J_1IEXCDTL

Best regards,

Pakorn

[binoy_vargis1]

Hi,

Try creating a Query in Tcode SQVI by combining tables MKPF and J_1IEXCHDR/J_1IEXCDTL for your requirement.

Check these threads how to create Query.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6018c1ae-8c44-2d10-6ea9-c3fad2c82...

http://ptgmedia.pearsoncmg.com/images/9780672329029/samplechapter/0672329026_CH03.pdf

Regards

Binoy

[Former Member]

check once if J1IGR fulfills....