structure in tables

[Former Member]

i want to reteive data for sold-to-party&ship-to-party for an invoice smartform.sold-to-party is coming from kuagv-kunnr&ship-to-party is coming from kuwev-kunnr in VA02 tcode ,but kuwev&kuagv are structures.how to find out in which tables these structures are included.plz help.

[Former Member]

i want to reteive data for sold-to-party&ship-to-party for an invoice smartform.sold-to-party is coming from kuagv-kunnr&ship-to-party is coming from kuwev-kunnr in VA02 tcode ,but kuwev&kuagv are structures.how to find out in which tables these structures are included.plz help.

[Former Member]

Refer the following link to find the table name

[Former Member]

Hi,

U can do this,

goto se11, in data types ,write structure's name,

click on utilitites, goto where used list n get the tables if any..

reward if helpful,

Pritha.

[Former Member]

i tried as per ur info.but it's displaying 'no database tables found'.

[Former Member]

HI,

Its because no tables exist for the structures.

Regards,

Pritha.

[Former Member]

hi srinivas,

try this data base tables for partner functions,

edpar,

knvv,

knvp.

reward points if hlepful,

regards,

seshu.

[Former Member]

hi srinivas,

try this data base tables for partner functions,

edpar,

knvv,

knvp.

reward points if hlepful,

regards,

seshu.

[Former Member]

hi srinivas,

try this data base tables for partner functions,

edpar,

knvv,

knvp.

reward points if hlepful,

regards,

seshu.

[Former Member]

It is sales order ,so get the data from VBPA Table based on ur condition.

VBPA is the Sales prtner table

Sold to party

get kunnr from vbpa if vbeln = ur sales order

parvw = 'SP'

Ship_to_party

get kunnr from vbpa if vbelm = ur sales order

parvw = 'SH'

[Former Member]

thanku for ur reply.why did u give partner function, parvw = SH&SP.plz clarify

[Former Member]

Hi Srinivas,

Based on PARVW ( Partner function ) - system knows who is sold to party,or ship-to-party,bill-to-party or payer

Partner functions are :

Sold-to-party

ship_to-party

bill_to-party

payer

when you see in VBPA Table we have only kunnr field,so system will decide who is sold to party and so on

I am not at system,

goto se11->vbpa->display->table contents->selection -> see the parvw ->f4 on this field -> you get field values SP,SH,BP

Reward Points if it is helpful

Thanks

Seshu

[manubhutani]

open the structure.

go to utilitites, then where used list

check whatever u want to see.and press ok.