SAPSCRIPT program: need source code to trigger a data from a structure and display in a form

[former_member1123677]

Hello experts,

first of all, i'm not abaper but a saw several program so, i'm trying...

i'd like to trigger the value of structure QALS_D02 fields VNAME and assign it to a variable V_USER:

this is my program in sapscript:

/ : DEFINE &V_USER& = &QALS_D02-VNAME&

/ : READ QALS_D02 WITH INDEX

/ : SELECT VNAME FROM QALS_D02 INTO V_USER WHERE

QALS_D02-LS_VBELN EQ VBDPL-BSTKD

<B>User ID : &*V_USER& </>

(note that VBDPL-BSTKD is the delivery number that we are processing)

thanks in advance for you king help

Koubra

[former_member259807]

Hi,

What is the value of V_USER after your DEFINE?
What is the value of V_USER after the select?
Why are you using *V_USER for output instead of V_USER?

What is the output anyways, just 'User ID:'?

(https://answers.sap.com/questions/4183558/how-to-debug-sap-script.html)

[former_member1123677]

Hello B. Wallagh,

thanks for your replay.

V_USER is defined to receive a SAP login of the user who validated the usage decision in QA33.

the login of the user in the structure QALS_D02 is in field VNAME.

i put *V_USER because in the existing sapscript form, some value of variables are called like that... as i'm not good in abap, so i put * too. ==> if it is not necessary i will remve the star.

Thanks again for your answer

[Sandra_Rossi]

If you're not ABAPer, and not SAPscripter, you can't achieve your goal easily.

I could find the following information by searching the forum:

• QALS_D02 is a structure supporting the display of columns in transaction QA32, it doesn't contain anything. So you cannot do SELECT ... FROM qals_d02 !
• If you need to use SELECT to read database tables, you can start with the actual tables behind transaction QA32, which are QALS, QAMB, QAVE, QDPS, QMAT, QINF, QDQL. So you first have to search where the data you are looking for is stored.
• Eduardo has already answered to you what you have to do in your SAPscript to execute ABAP code.

[Jelena_Perfiljeva]

We do not write ABAP code in SAPscript forms. SAPscript allows only for some basic control commands.

There should be a program that calls the form and that's where the coding needs to be done. The program fills in the variables and then the variables are inserted in the form. The variable name must match between the form and program.

[eduardo_hinojosa]

Hi

You can`t do SELECT inside the lines editor in SAPscript. You need to do it in other program with calls from lines editor type

PERFORM subroutine IN PROGRAM zreport

USING &v1&

CHANGING &value&

ENDPERFORM

In this report you do de SELECT on SAP tables

where VALUE comes from DEFINE

I hope it helps you

Regards

Eduardo

[former_member1123677]

Hi,

thank to all for your helpful answer.

in fact:

- VBDPL-BSTKD corresponds to field LS_VBELN in the structure QALS_D02

- with this field, i want to trigger th value in field VNAME in QALS_D02

- assign the VNAME value in my variable V_USER.

how can i build the code ?

thanks a lot for your help

[former_member1123677]

Hi,

thank to all for your helpful answer.

in fact:

- VBDPL-BSTKD corresponds to field LS_VBELN in the structure QALS_D02

- with this field, i want to trigger th value in field VNAME in QALS_D02

- assign the VNAME value in my variable V_USER.

how can i build the code ?

thanks a lot for your help

[former_member1123677]

Hi,

thank to all for your helpful answer.

in fact:

- VBDPL-BSTKD corresponds to field LS_VBELN in the structure QALS_D02

- with this field, i want to trigger th value in field VNAME in QALS_D02

- assign the VNAME value in my variable V_USER.

how can i build the code ?

can someone help me please to build the source code.

thanks in advance