regarding fetching data

[Former Member]

Hi all,

I am very new to smart forms.I am developing a smart form for SD module.

In that i need to ftech the data from J_1IEXCDTL(Excise invoice line item details).And to map this table with any of the SD table am not getting Idea.

From J_1IEXCDTL i neeed to fetch data for exbed,cess, rgplaser, rg23aser fileds.

How can I fetch data from this table. and how to link this table with the SD tables.

Regards,

Sammu.

[Former Member · Accepted solution]

What smartform are you doing and what information you want to capture.

Do you want to capture tax values?

Regards

Karthik D

[Former Member · Accepted solution]

HI

I am doing Smart form for Delivery Cum invoice.

In dat i have to capture the fields rgplaser, rg23aser,exbed,cess

I am capturing Excise Duty, education cess and PLA and RG23A Debit No from J_1IEXCDTL.

From VBRK,VBAK,LIKP,LIPS and other SD tables.

How can I link this J_1IEXCDTL table to the above mentioned tables.

Regards.

Edited by: Sameera shaik on Nov 5, 2008 11:12 AM

[Former Member · Accepted solution]

You can check for RDOC1 and RDOC2 in the table J_1IEXCDTL for delivery and billing documents, that way you can link the data with other SD tables.

[Former Member · Accepted solution]

HI Avinash,

Thanks for ur reply.I did what u asked me to do.But I didn't get the RDOC1 and RDOC2 fields in other tables.

In select query for J_1IEXCDTL in where condition to which fields I can map.

and what SD tables I can refer to J_1Iexcdtl.

Plz help me with ur possible inputs.

Ur inputs will be appreciated.

Regards.

[Former Member · Accepted solution]

well, you can use RDOC1 to pick up delivery doc. and match it with VBELN in table LIKP or LIPS. Similarly, RDOC2 carries the billing doc. which can be matched against VBELN of VBRK or VBRP. If you want to get the sales order, you can use any of the above two docs and go to VBFA table and query for the preceding doc (sales order).