topic Re: Account description in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/account-description/m-p/3213546#M766142 <HTML><HEAD></HEAD><BODY><P>The account Description can be found in the following table.</P><P>&lt;b&gt;CSKU&lt;/b&gt; - Cost Element Texts.</P><P></P><P>Here the &lt;b&gt;HKONT&lt;/b&gt; General Ledger Account which is represented as &lt;b&gt;KSTAR&lt;/b&gt; - Cost element.</P><P>The Const element description is &lt;b&gt;KTEXT&lt;/b&gt; (General Name) and &lt;b&gt;LTEXT&lt;/b&gt; (Description).</P><P></P><P>The following is the code i have used in my program.</P><P>**********Selection screen field for General Ledger Account HKONT ***************</P><P>SELECT-OPTIONS : HKONT FOR BSEG-HKONT.</P><P></P><P>***********Internal Table forGeneral Ledger Account for F4 Help *******</P><P>DATA: BEGIN OF IT_HKONT OCCURS 0,</P><P> KSTAR LIKE CSKU-KSTAR,</P><P> KTEXT LIKE CSKU-KTEXT,</P><P> END OF IT_HKONT.</P><P></P><P>******<STRONG>for F4 Help on HKONT</STRONG>*********</P><P>AT SELECTION-SCREEN ON VALUE-REQUEST FOR HKONT-LOW.</P><P> SELECT KSTAR KTEXT INTO TABLE IT_HKONT FROM CSKU WHERE SPRAS EQ 'EN'.</P><P> SORT IT_HKONT BY KSTAR.</P><P> CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'</P><P> EXPORTING</P><P> RETFIELD = 'KSTAR'</P><P> VALUE_ORG = 'S'</P><P> TABLES</P><P> VALUE_TAB = IT_HKONT</P><P> RETURN_TAB = IT_RETURN.</P><P> IF SY-SUBRC = 0.</P><P> READ TABLE IT_RETURN INDEX 1.</P><P> MOVE IT_RETURN-FIELDVAL TO HKONT-LOW.</P><P> ENDIF.</P><P></P><P>AT SELECTION-SCREEN ON VALUE-REQUEST FOR HKONT-HIGH.</P><P> SELECT KSTAR KTEXT INTO TABLE IT_HKONT FROM CSKU WHERE SPRAS EQ 'EN'.</P><P> SORT IT_HKONT BY KSTAR.</P><P> CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'</P><P> EXPORTING</P><P> RETFIELD = 'KSTAR'</P><P> VALUE_ORG = 'S'</P><P> TABLES</P><P> VALUE_TAB = IT_HKONT</P><P> RETURN_TAB = IT_RETURN.</P><P> IF SY-SUBRC = 0.</P><P> READ TABLE IT_RETURN INDEX 1.</P><P> MOVE IT_RETURN-FIELDVAL TO HKONT-HIGH.</P><P> ENDIF.</P><P></P><P></P><P>Reward Points if useful.</P></BODY></HTML> Wed, 12 Dec 2007 06:04:59 GMT Former Member 2007-12-12T06:04:59Z Account description https://community.sap.com/t5/application-development-and-automation-discussions/account-description/m-p/3213544#M766140 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>Am using the account number field i,e:BSEG-HKONT in one of my reports now i need to give the acount number descripotion please tell me what is the field in BSEG or BSIS table (or any other table) that gives the account number description</P><P></P><P></P><P></P><P>Vijay</P></BODY></HTML> Tue, 11 Dec 2007 04:57:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/account-description/m-p/3213544#M766140 Former Member 2007-12-11T04:57:03Z Re: Account description https://community.sap.com/t5/application-development-and-automation-discussions/account-description/m-p/3213545#M766141 <HTML><HEAD></HEAD><BODY><P>j</P></BODY></HTML> Wed, 12 Dec 2007 05:09:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/account-description/m-p/3213545#M766141 Former Member 2007-12-12T05:09:21Z Re: Account description https://community.sap.com/t5/application-development-and-automation-discussions/account-description/m-p/3213546#M766142 <HTML><HEAD></HEAD><BODY><P>The account Description can be found in the following table.</P><P>&lt;b&gt;CSKU&lt;/b&gt; - Cost Element Texts.</P><P></P><P>Here the &lt;b&gt;HKONT&lt;/b&gt; General Ledger Account which is represented as &lt;b&gt;KSTAR&lt;/b&gt; - Cost element.</P><P>The Const element description is &lt;b&gt;KTEXT&lt;/b&gt; (General Name) and &lt;b&gt;LTEXT&lt;/b&gt; (Description).</P><P></P><P>The following is the code i have used in my program.</P><P>**********Selection screen field for General Ledger Account HKONT ***************</P><P>SELECT-OPTIONS : HKONT FOR BSEG-HKONT.</P><P></P><P>***********Internal Table forGeneral Ledger Account for F4 Help *******</P><P>DATA: BEGIN OF IT_HKONT OCCURS 0,</P><P> KSTAR LIKE CSKU-KSTAR,</P><P> KTEXT LIKE CSKU-KTEXT,</P><P> END OF IT_HKONT.</P><P></P><P>******<STRONG>for F4 Help on HKONT</STRONG>*********</P><P>AT SELECTION-SCREEN ON VALUE-REQUEST FOR HKONT-LOW.</P><P> SELECT KSTAR KTEXT INTO TABLE IT_HKONT FROM CSKU WHERE SPRAS EQ 'EN'.</P><P> SORT IT_HKONT BY KSTAR.</P><P> CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'</P><P> EXPORTING</P><P> RETFIELD = 'KSTAR'</P><P> VALUE_ORG = 'S'</P><P> TABLES</P><P> VALUE_TAB = IT_HKONT</P><P> RETURN_TAB = IT_RETURN.</P><P> IF SY-SUBRC = 0.</P><P> READ TABLE IT_RETURN INDEX 1.</P><P> MOVE IT_RETURN-FIELDVAL TO HKONT-LOW.</P><P> ENDIF.</P><P></P><P>AT SELECTION-SCREEN ON VALUE-REQUEST FOR HKONT-HIGH.</P><P> SELECT KSTAR KTEXT INTO TABLE IT_HKONT FROM CSKU WHERE SPRAS EQ 'EN'.</P><P> SORT IT_HKONT BY KSTAR.</P><P> CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'</P><P> EXPORTING</P><P> RETFIELD = 'KSTAR'</P><P> VALUE_ORG = 'S'</P><P> TABLES</P><P> VALUE_TAB = IT_HKONT</P><P> RETURN_TAB = IT_RETURN.</P><P> IF SY-SUBRC = 0.</P><P> READ TABLE IT_RETURN INDEX 1.</P><P> MOVE IT_RETURN-FIELDVAL TO HKONT-HIGH.</P><P> ENDIF.</P><P></P><P></P><P>Reward Points if useful.</P></BODY></HTML> Wed, 12 Dec 2007 06:04:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/account-description/m-p/3213546#M766142 Former Member 2007-12-12T06:04:59Z