Hi,Structure query:

[Former Member]

Hi,

SELECT SINGLE adrnr FROM vbpa INTO lw_adrnr

WHERE parvw = 'WE' " lc_pfunction

AND kunnr = kuagv-kunnr. "SDPARTNERLIST-PARTNER

IF sy-subrc NE 0.

ENDIF.

in the last select statement if compare kunnr with kuagv-kunnr the value is populating in the structure.

But if i use the structure sdpartnerlist it is giving error that sdpartnerlist-partner is not defined by the data statement.

My question both are structure. for kuagv it is accepting but with sdpartnerlist it is not accepting.

Please can anyone give me solution.

regards

paveee...

[Former Member]

Hi,

In your program you might have given the statement

TABLES kuagv.

Thats why it is recognizing it as work area of type kuagv.

Reward points if useful.

Regards,

Atish

[Former Member]

Hi Atish Sarda ,

I am writing this code in the user exit userexit_save_document.

I have not given any statement like tables for kuagv.

My requirement is to get the adrnr number of customer (ship to party) for the line item in the va01 transaction.if i compare with kunagv-kunnr(soldto-party) it is not giving error.but with ship to party it is giving error.

can u please solve this issue....

advance thanks.

regards

paveee.

[Former Member]

please see the data type of this in se11 <b>SDPARTNERLIST</b>-PARTNER

PARTNER is fields is having dataelement of <b>PARTNER_VB</b> , which is having <b>Domain of CHAR25 </b> ........ <b>for this field length is 25</b>

but whereas <b>kuagv-kunnr</b> in se11 there kunnr field is having dataelement of <b> KUNAG</b> , which is having <b>domain of KUNNR</b> .. <b>this fields length is 10</b>

reward points if it is usefull ...

girish

[Former Member]

Hi Girish,

Agree with ur answer .yes it is correct...

But i want to the value partner in sdpartnerlist to be compare with kunner of vbpa table to get the correct details .

please can u help me in getting that value.

i will reward full points.

regards

pavee.

[Former Member]

Hi Praveen,

Then just define a local variable of type Char 10, and assign the value from sdpartnerlist to this variable, and use it in your select query.

Regards,

Atish

[Former Member]

Hi Atish ,

i checked with following code.but it is giving the same error.

data : lv_partner(10) type c.

lv_partner = SDPARTNERLIST-PARTNER.

can u please help me.

regards

pave....

[Former Member]

Hi Praveen,

Try changing query as

data : lv_partner type kunnr.

lv_partner = SDPARTNERLIST-PARTNER(10).

Reward points to all useful answers.

Regards,

Atish