topic Re: Format field output in SAPScript in Application Development and Automation Discussions

Format field output in SAPScript

Former Member — Fri, 07 Jun 2013 11:46:47 GMT

Hello,

I want to mask all but the last 4 digits of a bank account that is output to SAPscript. The bank account number is populated through &REGUH-ZBNKN&. The bank account number length can vary, so it is not possible to set a constant offset like &REGUH-ZBNKN+4&. The SAPscripty itself is called by a standard SAP program therefore do not want to make any chnages in teh SAP program itself.

Can you advise if there is any way within the SAPscript itself to ensure only the last 4 digits contained in &REGUH-ZBNKN& are output? If this has to be done by the PERFORM statement, can I design a new own Z program (independent of the SAP calling program) and dynamically call that from within the SAPscript to output the last 4 digits?

Can you advise the general approcah please?

Thanks for any ideas

Mik

Re: Format field output in SAPScript

Former Member — Fri, 07 Jun 2013 12:06:41 GMT

hi Michael,

Try &REGUH-ZBNKN(4)& hopefully it will work out your requirement.

Re: Format field output in SAPScript

Former Member — Fri, 07 Jun 2013 12:12:07 GMT

You can always call an external perform from inside the SAPScript.

Neal

Re: Format field output in SAPScript

Former Member — Fri, 07 Jun 2013 12:24:37 GMT

Perform statement needs to be used which will call subroutine of your custom program.

Here is SAP Help and wiki article with example.

Re: Format field output in SAPScript

Former Member — Fri, 07 Jun 2013 12:31:13 GMT

Unfortunatley Sai this will only pick the 1st 4 digits of the field, not sure if there is anyway to pick teh last 4 digits of the field. Note the field can have contents which vary in length, so saying &REGUH-ZBNKN+6& etc is not possible

Re: Format field output in SAPScript

Former Member — Fri, 07 Jun 2013 13:48:59 GMT

Hi Michael,

Create a Sub Routine Pool Program with a form in SE38. Call the same in your SAPScript Window where you want to do play with values. The structure out_tab and in_tab have values.

Eg :-

and,

form F140_LOGO TABLES p_in_tab STRUCTURE itcsy

p_out_tab STRUCTURE itcsy.

*-- <logic>

Endform.

BR,

Ankit.