topic structure in tables in Application Development and Automation Discussions

structure in tables

Former Member — Thu, 07 Jun 2007 11:15:30 GMT

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.

Re: structure in tables

Former Member — Thu, 07 Jun 2007 11:21:19 GMT

Refer the following link to find the table name

Re: structure in tables

Former Member — Thu, 07 Jun 2007 11:22:59 GMT

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.

Re: structure in tables

Former Member — Thu, 07 Jun 2007 11:24:06 GMT

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'

Re: structure in tables

Former Member — Thu, 07 Jun 2007 11:30:25 GMT

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

Re: structure in tables

Former Member — Thu, 07 Jun 2007 11:31:58 GMT

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

Re: structure in tables

manubhutani — Thu, 07 Jun 2007 11:34:49 GMT

open the structure.

go to utilitites, then where used list

check whatever u want to see.and press ok.

Re: structure in tables

Former Member — Thu, 07 Jun 2007 11:38:58 GMT

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

Re: structure in tables

Former Member — Thu, 07 Jun 2007 12:20:12 GMT

HI,

Its because no tables exist for the structures.

Regards,

Pritha.

Re: structure in tables

Former Member — Fri, 08 Jun 2007 05:44:35 GMT

hi srinivas,

try this data base tables for partner functions,

edpar,

knvv,

knvp.

reward points if hlepful,

regards,

seshu.

Re: structure in tables

Former Member — Fri, 08 Jun 2007 05:45:11 GMT

hi srinivas,

try this data base tables for partner functions,

edpar,

knvv,

knvp.

reward points if hlepful,

regards,

seshu.

Re: structure in tables

Former Member — Fri, 08 Jun 2007 05:46:26 GMT

hi srinivas,

try this data base tables for partner functions,

edpar,

knvv,

knvp.

reward points if hlepful,

regards,

seshu.