Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

want to add a field to standard report j2i9.

Former Member

‎2010 Aug 05 12:41 PM

0 Kudos
69

hi everyone,

i need to add the sgtxt field values of rbkp table to the standard report of j2i9.

but there is no common fields between exicse table(j_1iexchdr and j_1iexcdtl) and invoice table(rbkp and rseg).

can anyone help me with the same.

regards

karthe

Edited by: KARTHE on Aug 5, 2010 1:43 PM

1 REPLY 1

Former Member

‎2010 Aug 06 11:31 AM

0 Kudos
31

Hi Karthe,

Your excise document (Tables - j_1iexchdr and j_1iexcdtl) can be linked with the Incoming invoice (RSEG & RBKP) using the goods receipt documents (MKPF & MSEG).

You will get the material document number in any one of the below fields

j_1iexcdtl-RDOC1/RDOC2/RDOC3

j_1iexcdtl-RITEM1/RITEM2/RITEM3

Using this material document number & the docuemnt flow, get the invoice number and get the sgtxt value.

sometimes, you will get the invoice number also in any one of teh above fields. It is all depends up on the copy control.

Regards,

Selva K.