on 02-27-2019 4:44 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.