You are using the characteristic Billing Party from the Customer Invoice Header Volume data source (CRMCIVHB). The Billing Party characteristic returns not just the ID but also an additional number. You expect that the Billing Party only returns the ID in the respective report.
This can be seen in reports such as Invoice Volume, Accounts Receivables - Open Items report, among others.
SAP Business ByDesign
Reproducing the Issue
We will use the report Inovice Volume as an example:
- Go to the Customer Invoicing work center.
- Select the Reports - List view.
- Search for and open the report Invoice Volume.
- Click on the Go button.
- Click on the Add Fields button.
- Expand the Dimension: Customer Invoice.
- Expand Invoice
- Select the Billing Party and activate the Display in Report checkbox.
- Click OK
- Expand the Not Currently Shown grouping on the left-hand side of the screen.
- Drag the Billing Party (Invoice) to the Rows grouping.
You can see that .200 is appended to the ID of Billing Party in some cases.
A Bill-From Party can be either a Business Partner or an Org Unit. The Billing Organisation characteristic does not return correct values for Bill-From Parties which are Business Partners rather than Org Units. To allow the possibility to view both cases in a single characteristic, we have added the new Billing Party characteristic.
As the Bill-From Party can be a Business Partner or Org Unit, it's possible that the same ID would be present twice, once for a Business Partner and once for an Org Unit. In such a case, the system would display the ID and append a full stop followed by the relevant type code (147 for Business Partner, 200 for Org Unit) in the report for the Billing Party ID. This is to ensure uniqueness of the characteristic. It is currently not technically possible to prevent this from being shown on the UI (User Interface) for the Billing Party.
This is the current system behaviour.
Bill-From; Billing Party; .200; Billing Organisation; Characteristic; Invoice Volume; , KBA , AP-CI-CI , Customer Invoice , Problem