Urgent: Plzz help me out

[Former Member]

Hi,

I am making a report in which i have to make a relationship between the Excise invoice No..OR Bill No..(Present in MIGO) and the tables which have the data whether these vendors are paid or not i.e. BSIK n BSAK ?

plzz help me out as it is really urgent to me and help will be deinfately rewarded.

Edited by: abaper2008 on May 20, 2008 8:21 AM

[Former Member]

Hi

give ur correct requirement.

thanks

sitaram

[Former Member]

Dear friend,

this is realy a good question.

For this you must have to take the excise table of TC : j1id.

that is chaper id mantanance.

j_1iexchdr : the table responsible.

Fields:

exnum : excise invoice no.

exdat : is excise invoice date

rdoc : is billing invoice no.

now u can easily make the link between these fields,

u can use the billing table also like vbrp.

if still proble is there.

pls contact me.

rewards are expected.

vivek

[Former Member]

Hi

Relationship between biling no and excise invoice no table is J_1IEXCHDR

feilds is exnum-excise invioce no

rdoc -billing doc no

see the items table J-1IEXCDTL

rdoc1-billing doc

rdoc2-delivery

rdoc3-purchase document

Account document stored in J_1IPART2 table

thanks

sitaram

[Former Member]

Hi,

My requierment is this i have to make relationship of the Bill No.. or the excise no.. with the 2 tables i.e.:-

BSAK(It shows the cleared items) and the BSIK(shows open items)

and i have to display that the items of these vendors are being paid or not?

I had checked the XBLNR (Bill no or Excise no) in MIGO in these tables , this field is present but when i check data in them corresponding to the data in MIGO ,it shows no data exist.

plzz help me out as it is really urgent to me .