cancel
Showing results for 
Search instead for 
Did you mean: 

postpone and write off quantity for any project with personal Number

IMSYadav
Active Participant
0 Kudos
175

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

Stephen_Ward
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Sunil,

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

Best Regards,
Stephen

Accepted Solutions (1)

Accepted Solutions (1)

Hardeep_Tulsi
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Answers (1)

Answers (1)

Hardeep_Tulsi
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

  • 3 CDS Views for PBE ( I_ProjectBillingElement , I_ProjectBillingElementEntry , I_ProjectBillingElementEntrFlw ) are available for the first page in Manage Project Billing Fiori app.
  • 2 CDS Views for PBR (I_ProjectBillingRequest and I_ProjectBillingRequestItem ) (2nd screen in Manage Project Billing Fiori app - "Prepare Billing", object) in which the different values to be written offs/postponed values are stored)
  • 2 CDS Views, which store Keys:
  • I_PrjBlgElmEntrJrnlEntrLink, which links ACDOCA entry with Project Billing Entry table
  • I_PrjBlgElmEntrBillgPlnLink, which links Billing plan and billing plan item with PBE Entry table

You can learn more with documentation on the available CDS Views for Project Billing in Professional services

https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/cfef6e3111c843f796cd60f7...

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

IMSYadav
Active Participant
0 Kudos

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