Skip to Content
avatar image
Former Member

Table name

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 26, 2011 at 10:25 AM

    For the partner functions - KNVP

    For the excise details of customer - J_1IMOCUST

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 26, 2011 at 10:26 AM

    > 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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 26, 2011 at 05:20 PM

    Hi,

    For the customer master related partners check: KNVP

    For the sales document related partners check: VBPA

    Regards,

    Jan Pel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2011 at 08:00 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded