https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/10653972#M1866532 <HTML><HEAD></HEAD><BODY><P>Hi! everyone,</P><P></P><P>Kindly need your help,</P><P>there is a field named Distribution_Channel which is represent with</P><P></P><P>10 </P><P>20 </P><P>21 </P><P></P><P>just now, the alv report just print the Distribution code,</P><P>how i can modify my program so that it will print together the description/name of Distribution channel</P><P></P><P>for example:</P><P></P><TABLE border="1" class="jiveBorder" height="79" style="border: 1px solid rgb(0, 0, 0); width: 152px; height: 77px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Distribution Channel</STRONG></TH></TR><TR><TD style="padding: 2px;">10- Local</TD></TR><TR><TD style="padding: 2px;">20 - export</TD></TR><TR><TD style="padding: 2px;">21 - export Singapore</TD></TR></TBODY></TABLE><P></P><P>Thanks, regards,</P><P>Liyana.</P></BODY></HTML> Wed, 29 Oct 2014 02:16:00 GMT Former Member 2014-10-29T02:16:00Z https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/10653972#M1866532 <HTML><HEAD></HEAD><BODY><P>Hi! everyone,</P><P></P><P>Kindly need your help,</P><P>there is a field named Distribution_Channel which is represent with</P><P></P><P>10 </P><P>20 </P><P>21 </P><P></P><P>just now, the alv report just print the Distribution code,</P><P>how i can modify my program so that it will print together the description/name of Distribution channel</P><P></P><P>for example:</P><P></P><TABLE border="1" class="jiveBorder" height="79" style="border: 1px solid rgb(0, 0, 0); width: 152px; height: 77px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Distribution Channel</STRONG></TH></TR><TR><TD style="padding: 2px;">10- Local</TD></TR><TR><TD style="padding: 2px;">20 - export</TD></TR><TR><TD style="padding: 2px;">21 - export Singapore</TD></TR></TBODY></TABLE><P></P><P>Thanks, regards,</P><P>Liyana.</P></BODY></HTML> Wed, 29 Oct 2014 02:16:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/10653972#M1866532 Former Member 2014-10-29T02:16:00Z https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/10653973#M1866533 <HTML><HEAD></HEAD><BODY><P>fetch the texts from TVTWT table</P></BODY></HTML> Wed, 29 Oct 2014 02:57:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/10653973#M1866533 Former Member 2014-10-29T02:57:07Z https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/10653974#M1866534 <HTML><HEAD></HEAD><BODY><P>I agree with Kartik in fetching the texts. But as to your output, you may try to concatenate both the distribution code and the text separate it with '-' and put it to a new field.</P><P></P><P></P><P>Best Regards,</P><P>Charlie </P></BODY></HTML> Wed, 29 Oct 2014 03:12:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/10653974#M1866534 Former Member 2014-10-29T03:12:31Z