topic Re: Hi,Structure query: in Application Development and Automation Discussions

Hi,Structure query:

Former Member — Wed, 23 May 2007 06:17:07 GMT

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...

Re: Hi,Structure query:

Former Member — Wed, 23 May 2007 06:20:53 GMT

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

Re: Hi,Structure query:

Former Member — Wed, 23 May 2007 06:33:38 GMT

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.

Re: Hi,Structure query:

Former Member — Wed, 23 May 2007 06:33:52 GMT

please see the data type of this in se11 SDPARTNERLIST-PARTNER

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

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

reward points if it is usefull ...

girish

Re: Hi,Structure query:

Former Member — Wed, 23 May 2007 06:38:09 GMT

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.

Re: Hi,Structure query:

Former Member — Wed, 23 May 2007 06:43:14 GMT

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

Re: Hi,Structure query:

Former Member — Wed, 23 May 2007 07:26:03 GMT

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....

Re: Hi,Structure query:

Former Member — Wed, 23 May 2007 07:39:50 GMT

Hi Praveen,

Try changing query as

data : lv_partner type kunnr.

lv_partner = SDPARTNERLIST-PARTNER(10).

Reward points to all useful answers.

Regards,

Atish