how to change Length of G/L Account Number in custom CDS view

[annapurna_vunnam2]

Customer has adopted 8-digit Length of G/L account and in custom CDS view level, the length of G/L account is 10 Digits. I_GLAccountInCompanyCode shows the length is 10. how to change the length of G/L account so it can flow in the integration to show the length as 8 digits.

Thank You.

Regards,

Annapurna

[pmankala1 · Accepted solution]

Extend the view and adjust the GLAccount field length in your extended view.

Either use Cast or ltrim or by using a custom data element.