plz tell the field name?

[Former Member]

Hi i want to know ship to party and sold to party field name in the table?

thnks,

reagards,

gowri

[Former Member]

KNA1.

based on the type of partnr

SP-Sold to party

SH-Ship to Party .

Regards

Prabhu

[Former Member]

Hi Gowri,

The partner functions data element PARVW and the crresponding table is TPAR.

If u want check the table and the corresponding field we have to follow the steps.

Other wise functional people will give all the field and the corresponding table.

We have to wirte the coding for our requirement.

**********rewords some points if it is helpful.

Rgds,

P.Naganjana Reddy

[Former Member]

In the customer master table : KNA1,

Customer : KUNNR is

'sold to party' - if the customer account group(KTOKD) = '0001'

'ship to party' - if the customer account group(KTOKD)= '0002'

'Payer' - if the customer account group(KTOKD)= '0003'

'Bill to party' -if the customer account group(KTOKD)= '0004'

So you can select the bill to party, sold to party etc based on KTOKD.

Hope this helps you.

[Former Member]

If you are looking for just customer partners, you will find them in KNVP where PARVW will differentiate between Ship-to(WE internal, SH external format) and Sold-To (AG internal and SP external format).

If you are talking about sales order partners, then you will find them in VBPA.

[Former Member]

Hai Gowri sankar Balasurbramanyam,

Sold to party related data be had by KUNNR Field,This Field is available in so many tables as below:

Table Name Filed Filed Name

E1FINBU KUNNR

E1FKNA1 KUNNR

E1FMARA KUNNR

E1FVBAK KUNNR

E1FVBP0 KUNNR

E1FVBPA KUNNR

E1MARAF KUNNR

E1VBAKF KUNNR

E1VBP0F KUNNR

<b> Ship-To Party </b>

Table: SHP_MA_DELGIMG_G

Field:GOOD_RECS

Hope this helps you.

Regds,

Rama.Pammi

[Former Member]

Hi Sankar,

Try out this

LIKP-KUNNR for Ship to party

VBAK-KUNNR for sold to party

Regards,

Vara Prasad.

[Former Member]

Hi Gowri,

Sold-to party -

---

>LIKP-KUNAG

Ship-to party------>LIKP-KUNNR.

Table:LIKP (SD Document: Delivery Header Data)

Thanks & Regards,

Nelson.