Multiple and different Internal WBS number

[former_member133249]

For reporting purposes, we are trying to match the CDS views of Debit Memo Request[DMR]and WBS.

We are using CDS view, I_DebitMemoRequestItem (Basic), I_WBSElementBasicData (Basic). We are having some issues matching the internal WBS element.

The CDS view  I_DebitMemoRequestItem (Basic) uses the following field.

<d:WBSElement>000000000000000004000101</d:WBSElement>

We can are not able to relate this to the  cds view: I_WBSElementBasicData (Basic)

 <d:WBSElementInternalID>00003378</d:WBSElementInternalID>                 <d:WBSElementExternalID>D0040DTS001.0.1</d:WBSElementExternalID>                 <d:WBSElement>D0040DTS001.0.1</d:WBSElement>

Does some know how we can use these CDS views or know a different CDS view which we can relate? 

Best regards,

Dick

[Feras_Al-Basha · Accepted solution]

Hi dkrielen ,

I cannot comment on the joins you are trying to accomplish with the custom report you are creating.

Having said, based off the description of the report you working on, I suggest considering the below CDS view:

I_EngmntProjBillgAndRblsCube

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2008.500/en-US/64c9dddc4c014c0e93f0ef85...

Hope this helps.

Feras