on 05-15-2023 9:00 AM
Hello All,
We need to identify writeoff and postpone quantity for any project to verify in case by mistake some timesheet is written off or postponed.
to identify this we have CDS I_ProjectBillingElementEntry, but here we have quantity only till BDR is created. after BDR we are not able to track the line item.
anyone has worked on this then please let us know and guide us how to do this.
thanks
Sunil
Hello Sunil . To get the already written off amounts, best would be to check the flow view I_ProjectBillingElementEntrFlw.
Post BDR creation, ToBeWrittenOffQuantity and ToBePostponedQuantity will be set to 0
To get the current open amount(irrespective of the PBR changes by user) : Original amt - written off(from flow) - (billed+billing requested from flow) can be used.
You can raise the service ticket to get you the additional help for specific scenario.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sunil. Project Billing Element.is the lowest project billing structure entity in which billing can take place. Revenues for the project can be posted in the project billing elements
CDS View Name I_ProjectBillingElementEntrFlw give you the WrittenOff Quantity
You can use the field DocumentBillingStatus to have the BDR status which indicate whether created, rejected, invoiced. PrecedingDocument give you the Permanent ID for PBR, generated once BDR is created
For more information , I have given you the explaination on available project billing CDS views that can be used for your analytics need.
You can learn more with documentation on the available CDS Views for Project Billing in Professional services
For overall understanding on Project Billing for Customer Projects in SAP S/4HANA Cloud, you can refer to the blog
https://blogs.sap.com/2020/08/11/project-billing-for-customer-projects-in-sap-s-4hana-cloud/
Hope this helps !
Thanks
Kind Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Hardeep,
these are CDS which has data but as per specific requirements for customer where customer want to check where BDR is created and user said we should have more entries or less entries or quantity in bill. so to verify this we will extract time records and check for write off and postpone quantities. this is not getting when we join any or CDS. We tried the same for below CDS as well:
I_ProjectBillingElementEntrFlw
I_BillingDocExtdItemBasic
I_PrjBlgElmEntrJrnlEntrLink
I_GLAccountLineItem
I_WorkPackageWorkItem
I_PersonWorkAgreement_1
I_TimeSheetRecord
We know data is there but we might be missing some correct combination or wrong joining condition but not getting correct data as required.
thanks
Sunil
User | Count |
---|---|
94 | |
9 | |
8 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.