Hi, I have loaded table BSEG, however when I run AP analysis, the values only sum for posting key 31 as that is what the invoice is based on . However, for validation purposes I need to total across all the posting keys in BSEG. How can I structure a query to do this ?
Thanks
Geoff
Page 1 / 1
Hi Geoff,
which Celonis Verson are you using? And where exactly do you validate the data - in the analysis or directly on database basis?
In our AP standard script, we filter on positions with posting key 31. You can extend that filter in the TMP BKPF BSEG Table and Case Table.
Best regards,
Viana
which Celonis Verson are you using? And where exactly do you validate the data - in the analysis or directly on database basis?
In our AP standard script, we filter on positions with posting key 31. You can extend that filter in the TMP BKPF BSEG Table and Case Table.
Best regards,
Viana
v.kalversberg:Viana
Thanks Viana,
now I can do all my validation reporting on BKPF and BSEG without affecting the activies
Regards
Geoff
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.