topic Re: code for add the cost center description in sapscript ? in Application Development and Automation Discussions

code for add the cost center description in sapscript ?

Former Member — Thu, 22 Feb 2018 10:50:34 GMT

Hi every body

I wrote this program for read the cost center description from CSKT Table:

REPORT ZRED_RES_COSTCENTER.
FORM get_coster TABLES IN_PAR STRUCTURE ITCSY
OUT_PAR STRUCTURE ITCSY.
DATA: Coster TYPE CSKT-LTEXT .
READ TABLE IN_PAR WITH KEY NAME = 'MSEG-KOSTL'.
IF SY-SUBRC IS INITIAL.
READ TABLE OUT_PAR WITH KEY NAME = 'COSTERNAME'.
IF SY-SUBRC IS INITIAL.
SELECT SINGLE LTEXT INTO coster FROM CSKT WHERE KOSTL EQ IN_PAR-VALUE .
OUT_PAR-VALUE = Coster .
MODIFY OUT_PAR INDEX SY-TABIX.
ENDIF.
ENDIF.

ENDFORM.

but when I use this program in the sapscript , it dosen't work.

cost center in CSKT table like this:

in MSEG table :

can u help me please?

Re: code for add the cost center description in sapscript ?

mmcisme1 — Thu, 22 Feb 2018 18:52:07 GMT

You may get a better answer for you. Because what I suggest could be time consuming. I try to never write my code in a SapScript. I copy the SAP program that call the SAPScript and then make the changes there. If your SAPscript has the same fields as your program, it always works. If it doesn't work it's very easy to debug.

Re: code for add the cost center description in sapscript ?

Former Member — Fri, 23 Feb 2018 05:18:37 GMT

can you please explain a little more? how can I add the cost center description to sapscript from material document (mseg table ) ?

Re: code for add the cost center description in sapscript ?

Former Member — Fri, 23 Feb 2018 05:44:17 GMT

in the MB51 cost center format different with the tables:

here cost center XXXXX but in the CSKT like this 00000XXXXX

when the program read the cost center number which format comes?maybe problem is it. can anyone guide me?

Re: code for add the cost center description in sapscript ?

hedvig_rohonyi — Fri, 23 Feb 2018 11:31:39 GMT

Hi,

I checked your code and if I understand it correctly the description is stored in field &costername&.

But instead it the field &costcenter& is displayed in the form. Is it right?

Best regards,

Hedvig

Re: code for add the cost center description in sapscript ?

mmcisme1 — Fri, 23 Feb 2018 13:09:31 GMT

What happens when the SAPScript runs? Does it give you a short dump?

It looks like:

perform get_coster in program zreadres_costcenter using &mseg-kostl&
                                                   changing &costername&.

Doesn't match your parameters in the form:

FORM get_coster TABLES IN_PAR STRUCTURE ITCSYOUT_PAR STRUCTURE ITCSY
                       OUT_PAR STRUCTURE ITCSY.

So when the code runs is there a short dump? Look at your perform

perform get_coster in program zreadres_costcenter TABLES IN_PAR STRUCTURE ITCSYOUT_PAR STRUCTURE ITCSY
                                                         OUT_PAR STRUCTURE ITCSY.

That should work - I think. Also look at Hedvig's answer.

Re: code for add the cost center description in sapscript ?

Former Member — Sat, 24 Feb 2018 07:21:41 GMT

no it dosen't display anything

Re: code for add the cost center description in sapscript ?

Former Member — Sat, 24 Feb 2018 07:37:24 GMT

when I used the MSEG-KOSTL directly in the main window of form , cost center displayed like this : XXXXX

zeros dose not display.but CSKT-LTEXT format is 00000XXXXX

I don't know when the read this section of the program "

SELECT SINGLE LTEXT INTO coster FROM CSKT WHERE KOSTL EQ IN_PAR-VALUE .
OUT_PAR-VALUE = Coster ."

it's true or not?

Re: code for add the cost center description in sapscript ?

Sandra_Rossi — Sat, 24 Feb 2018 09:14:51 GMT

I don't understand if you're talking about the description of the cost center or about its number.

As far as I understand, your question is answered (solved for the description), and you should mark Hedvig's answer as correct.

Now your question is about the cost center number? Although it's a continuation for you, it should be posted as a new question in the forum.

Re: code for add the cost center description in sapscript ?

Former Member — Sat, 24 Feb 2018 19:41:09 GMT

My question about the cost center description. I give you more information for solve the my problem. In the sapcript form there is the cost center number. I want to display cost center description. I told you maybe formt of cost center number that com from MSEG table diffrent with CSKT then program dosen't work maybe. I didn't say my question about descrption is solved.

Re: code for add the cost center description in sapscript ?

Sandra_Rossi — Sat, 24 Feb 2018 19:56:52 GMT

Thanks. I understand now. The values of the cost center number are stored with leading zeroes in the database (stored in so-called internal values), but output without these zeroes (external values). So, you should better debug your code to make sure what's going on (in debug you always see the internal value, i.e. with leading zeroes).

Re: code for add the cost center description in sapscript ?

Former Member — Mon, 12 Mar 2018 11:46:52 GMT

result of debug: it doesn't display anything.

Re: code for add the cost center description in sapscript ?

Sandra_Rossi — Mon, 12 Mar 2018 12:16:02 GMT

But what is the value of MSEG-KOSTL, and did you debug the subroutine GET_COSTER? You'll find out what's going on, for sure.

Re: code for add the cost center description in sapscript ?

Former Member — Mon, 12 Mar 2018 12:36:40 GMT

how can i see the MSEG-KOSTL vlaues ?

Re: code for add the cost center description in sapscript ?

Sandra_Rossi — Mon, 12 Mar 2018 15:38:05 GMT

The same way as you did for *MKPF-CPUDT

Re: code for add the cost center description in sapscript ?

Sandra_Rossi — Mon, 12 Mar 2018 15:39:42 GMT

By the way, I see a trailing dot in the line PERFORM, it shouldn't be there. Maybe the PERFORM fails.

Re: code for add the cost center description in sapscript ?

Jelena_Perfiljeva — Mon, 12 Mar 2018 18:51:06 GMT

SELECT SINGLE LTEXT INTO coster FROM CSKT WHERE KOSTL EQ IN_PAR-VALUE .

Don't use the parameter (here IN_PAR-VALUE) like that in the SAPScript routines, it's a straight path to failure. Declare another variable with the same type as CSKT-KOSTL and use that. Don't forget to call the conversion routine to make sure leading zeroes are added.

Also SPRAS and KOKRS should be in SELECT since they're key fields, otherwise you'll be in for an unpleasant surprise down the line.

And +1 to Sandra's comments.

Re: code for add the cost center description in sapscript ?

Former Member — Tue, 13 Mar 2018 04:59:53 GMT

as you said maybe this path is failure.

look at table CSKT : there are two value for cost center description (language EN and FA)

Re: code for add the cost center description in sapscript ?

Jelena_Perfiljeva — Tue, 13 Mar 2018 18:58:27 GMT

This was not mentioned before. Obviously, with this data you must use language as well.

And this screenshot also clearly shows leading zeroes in the cost center, so that's clearly a problem here. (Thought we've established that already though.)