Table name

[Former Member]

dear all,

what is the table name of SHIP TO PARTY,BILL TO PARTY,SOLD TO PARTY,PAYER ?Is it KNA1 or differenet for all.

what is the table for

1.tin no,ecc no,cst regd no

[Former Member · Accepted solution]

For the partner functions - KNVP

For the excise details of customer - J_1IMOCUST

Thanks

[madhu_vadlamani]

Hi Ranjan,

To get the table names directly click on f1 on that and check the technical settings. Tables for your requirement is knvp,J_1IMOCUST.Close the thread if it is posted.

Regards,

Madhu.

[Former Member]

Hi,

For the customer master related partners check: KNVP

For the sales document related partners check: VBPA

Regards,

Jan Pel

[Former Member]

> 1.tin no,ecc no,cst regd no

Hi

For partner functions check in the table KNVP

If you can pass the partner function like KNVP-PARVW =SH then you can get the ship to party.

all partner functions are stored in this table KNVP

and for ecc no you can check in J_1IMOCUST

J_1IMOCUST-J_1IEXCD is ECC no

J_1IMOCUST-J_1IPANNO tin number check where the same as maintaind in CIN details tab

J_1IMOCUST-J_1ICSTNO for CST number

regards

Prashanth