SAP ByD- Technical field name for columns with description in a report

[chindhu]

Dear Experts, 

How do we obtain the technical IDs for columns that display descriptions. I have attached a report generated from SAP ByD, which was intended to extract technical names, however, the fields corresponding to descriptions appears blank. 

For example: Cost centre ID has technical name as COST_CTR_UUID, but the description next to it is blank 

Any suggestions are highly appreciated. 

Thanks,

chindhu

[HarshalVakil]

Hello,

If your intention is to find the technical name / IDs of the fields in the report, this can be done by
Business analytics - Design reports - Search for report
Click on Build OData query.
in the Attributes tab, you can find the EDM IDs and Attribute ID.

For example :  G/L Accounts - Line Items reprot

Here you will find cost center as one of the attribute in report,

when you are looking at the build odata query screen,

you will find that Cost center ID as well as Description both has the same attribute ID : COST_CTR_UUID, however EDM IDs are diferent
CCOST_CTR_UUID for ID
TCOST_CTR_UUID for Description

general naming convention in EDM is
C****** = ID
T****** = Name / Description
K****** = Key Figure
F****** = Formatted Key figure
R****** = Currency Code
U****** = Unit associated with the key figure ( only if key figure is quantiity based)

hope this helps.

Thanks,
Harshal