Skip to Content
avatar image
Former Member

Pick the Data from KONP-KBETR

Hi all

I need to pick the value KONP-KBETR based on the input customer number. actualy conditionrecord is maintained on the bases of customer number, material pricing group.so i have to pick the value KBETR but in the table KONP only Condition record number and Sequential number of the condition are key fields. pls give me some logic to fitch the data from KONP. Pls Help me

Thanks in advance

Regards,

Nagesh N

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 18, 2010 at 10:18 AM

    HI

    you can get the value of KBETR

    From VBAK or VBAP table get the value of KNUMH/KNUMV and pass this VBAK-KNUMh or VBAP-KNUMV into table

    KONV then you can get the KBETR for the required KSCHL condition type.

    regards

    Prashanth

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2010 at 10:15 AM

    Hello,

    the link between Sales Document and table KONP is the key-field "NoCondRec.Batch" (KNUMH): you have this field available on table VBAP for instance.

    Hope to be useful.

    Best regards,

    Andrea

    Add comment
    10|10000 characters needed characters exceeded