find serial no in excise

[jayakummar]

hai experts,

i have report which is contains meterial document and referance document and date etc.

Requirement is to find the Excise serial no for the document which is contains in J_1IPART2 table i need the link between mseg of mkpf with excise table can any one give a suggestions...

i tried with sqvi for finding the like but i dont get suitable link for my requirement....

reward avail for helpful answer......

thanks in advance...

jai.m

[Former Member · Accepted solution]

i think you have to use J_1IPART1 table instead of J_1IPART2.

if your requirement is for linking J_1IPART2 with mseg here is rhe procedure.

first link mseg with J_1IPART1 on key

mseg-mblnr = J_1IPART1 -mblnr

mseg-mjahr = J_1IPART1-mjahr

mseg-zeile = J_1IPART1-zeile

then join J_1IPART1 and J_1IPART2 on

exgrp/rgtypsyear/serialno

reward if useful.

amit singla

[jayakummar]

MY QUST ANSWERED