CDS Limitation | The association cannot be used locally in the view (see long text)

In this session, I have discussed the limitation of CDS that Association can't be accessed locally and their solution.
Join this channel to get access to perks:
/ @pankajkumaram

[@namderbachelor]

Thank you from Vietnam! Kudo !

[@peachyava439]

Very eloquent explanation of the error raised. Two thumbs up!

[@Sachinartani]

This was beautifully explained and my only hope during the practical explanation was that you should not delete existing code and write new instead comment old one and write new one. And you met the expectations. Thank you.

[@Sahilbsharma]

Great

[@rb080768]

Thank you ;-)

[@wakeupdin]

Thank you 🙏

[@user-cr2oz8qs8i]

Another limitation which I came across is alias field also cannot be used locally inside a CDS. You have to create a wrapper CDS and then use that. Is there anyway to overcome this limitation apart from creating a wrapper ?

[@srimansrikanth]

Nice tutorial. You told about wrapper class instead of changing order. Possible to give me that piece of code??

[@user-gf2fh1xw4s]

can master tell me how to delete the leading 0 of the account code, when i use ltrim to deletet the 0, the fields associated with account code in a parent and child will lose connection, and when i expose to excel, the text in the child node will not disappear