C_EngmntProjBillgAndRblsQry

Purpose
This CDS view provides the prerequisites for answering the following business questions: Which are the billing plans that have not been processed in my projects? What are the upcoming billing plans in projects that I manage? What is the total amount that can be invoiced? What is the total receivable amount from customers? By how many days are receivable amounts overdue? What is the total amount written off from invoices?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restriction types must be set to read access: Service Organization Project Type Project Category These restriction types are edited in the Maintain Business Roles app. Note To view the details of projects that involve blocked customers or business partners, you must have the additional authorization of an external auditor.

Structure
Object types This view is built on the following object types: Engagement Project Sales Order Debit Memo Request Billing Document Main CDS parameters and filters The main CDS parameters are: Number of Days , used to fetch results based on the number of days by which debit memo requests and receivables are overdue. Engagement Project can be used to filter results using project IDs. Project Stage can be used to filter results based on the following project stages: P003 (In Execution) P004 (Completed) P005 (Closed) Sales Order can be used to filter results based on sales order IDs. Company Code can be used to filter results based on the company code of projects. The results display projects from all service organizations belonging to a company code. Note The values in the input help are not dependent on the authorizations in your business role. However, the search results are. Service Organization can be used to filter results based on the service organization assigned to projects. Profit Center can be used to filter results based on the profit center assigned to projects. Cost Center can be used to filter results based on the cost center assigned to projects. Customer can be used to filter results based on the customer assigned to a project. The main filters are: My Projects This field can be used to filter projects based on the user's assignment to any of the project roles. Enter X to retrieve only the user's projects or enter ' ' to retrieve projects that the user is authorized to access. Tip To experience optimal performance in filtering and displaying results, it is recommended that you use this parameter in combination with other parameters. Project Stage Measures and attributes Some important measures and attributes are: Field Description EngagementProject Customer project ProjectVisibility Indicates whether a project is confidential. Customer Customer for whom a project is being executed. SalesOrderNetAmount Net value of the sales order. DebitMemoRequestNetAmount Net value of a sales order item. BilledAmountInProjectCurrency Amount that has already been billed. RemainingContractBillingAmt Remaining amount to be billed against a sales order item. The value of this field is calculated as follows: Net value of the sales order - Net value of sales order item BillingPlanBillingDate The date on which a billing plan item is scheduled. BillingPlanAmount The amount that is to be billed as per the billing plan. BillingReqTimeIntervalInDays Number of days by which creation of billing request is overdue. OpenBillingRequestAmount Amount corresponding to billing requests that are scheduled but not yet created. BillingRequestOverdueAmount Amount corresponding to billing requests that have been created but not invoiced. WriteOffAmount Amount written off before invoicing. TotalReceivablesAmount Receivable amount pending from customers. Note The displayed amount is not adjusted for partial payments received against an invoice. ReceivablesTimeIntervalInDays Number of days by which customer payments are overdue.

Cons