Question Re: 2LIS_02_ITM: INVOICE RECEIPT DATA PROBLEM in Technology Q&A

2LIS_02_ITM: INVOICE RECEIPT DATA PROBLEM

Former Member — Fri, 17 Mar 2006 11:37:16 GMT

I have activated 2LIS_02_ITM, done the Logistics cockpit setup, filled the tables and done RSA3 to browse my extracted data. My problem is this: I have 1 purchase order with 1 invoice receipt line. The RSA3 data shows me 2 lines for the 1 invoice receipt line...1 line with RO_CANCEL = 'X' and 1 line with RO_CANCEL = ' '. I don't understand this as this will result in a 0 entry value when passed to BW. What should the relationship be between the EKBE (PO history table containing the 1 invoice receipt line) and the RSA3 table values be? 1 to 1 surely?

Re: 2LIS_02_ITM: INVOICE RECEIPT DATA PROBLEM

Former Member — Fri, 17 Mar 2006 12:36:38 GMT

Hi James,

look at this thread

It is about a similar issue. Your invoice was created and then propably cancelled. So you get a before image (without indicator) the creation and a after imate (with indicator) the cancellation of the invoice.

Siggi

Re: 2LIS_02_ITM: INVOICE RECEIPT DATA PROBLEM

Former Member — Sun, 19 Mar 2006 06:09:40 GMT

I created this PO from scratch. It has one line item of quantity 1 and amount 8000.

I did 1 goods receipt on it for qty = 1 and full amount.

RSA3 extractor created 2 records for the Goods receipt (1 with ro_cancel = 'x' and one with ro_cancel = ' '.).

For the invoice receipt, RSA3 does the same.

My question is: This PO has 4 entries in EKBE (the PO history table). 1 is for the Goods receipt and 3 for the Invoice receipt (the first invoice, 1 cancellation of the first invoice and 1 for the real invoice).

Should there be a one to one relationship between each entry in EKBE and each entry in the RSA3 extractor?

Re: 2LIS_02_ITM: INVOICE RECEIPT DATA PROBLEM

Former Member — Mon, 20 Mar 2006 08:19:32 GMT

Hi James,

there must not neccessarily be a 1:1 relation, but if I got you right, you created a po. Then you created a invoice, cancelled the invoice and created an invoice again. And now, the extractor will only provide the 1st creation and the cancellation and not the 2nd creation. So my question is, a) did you run a new setup? b) did you already do a init load? c) if you already did a init, did you run your v3 job in order to get the new record into the queue?

Siggi