cancel
Showing results for 
Search instead for 
Did you mean: 

In 2LIS_13_VDITM found 2 different bill date for same invoice?

RameshHangargi
Participant
0 Kudos

Hi Experts,

Good Morning!

I'm New to BW. Kindly help me out

In 2LIS_13_VDITM Data source I'm facing 2 different bill dates for the same invoice number at PSA Level. But i Cross checked in ECC side, there i found only one bill date is maintained.

So Bill_date is a part of my key field in DSO. so it will consider as new record for the same invoice.Due to this in report i'm getting same invoice are repeating.

Its urgent kindly help me out.

Thanks in Advance

Best Regards,

Ramesh

Accepted Solutions (1)

Accepted Solutions (1)

bhavinvyas
Active Contributor
0 Kudos

Check if bill date has been changed in ECC. Take help of functional if required.

It must have changed so it will have two bill dates for changed record and original record.

Regarding DSO key, Billing document and Billing item should be in key for DSO. Not Bill Date.

Thanks,

Bhavin Vyas

RameshHangargi
Participant
0 Kudos

Hi Bhavin,

Thank you for your valuable time.

I've discussed with functional and checked both changed on date & original record date are same. But i'm wondering why it has 2 bill date for same invoice.and in DSO Key Fields are Bill num, bill item and created on.

Note : created on object is mapped with bill_date in transformation.

Please tell me what steps i need to take further..

Regards,

Ramesh

RameshHangargi
Participant
0 Kudos

Hi Bhavin,

I took with the help of functional and we found change log for the invoices in VF03. we found invoices has been changed. My Question is in VBRK and VBRP table it holds the updated record right and the changes made in ecc on same day. and next day in PSA it should pick from Updated record right.why it has picked both old-value bill_date and new-value bill_date log history. Kindly please clarify my doubt.

Thanks in Advance

Regards,

Ramesh

Answers (0)