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
I need the Invoice data(VBRK or VBRP) not the sales order data. for caluclations we are taking the actual invoice amount. so how to pick the KONP-KEBTR by passing the customer number or material numbe.
From VBRK table get VBRK - KNUMV based on your requirment (say for customer)
Make sure in your select statement, you should nto select invoice type PROFORMA INVOICE and S1 documents and also F2 invoices which are marked as cancelled
Pass this KNUMV to KONV table and field KNUMV and here you will get the required details
Thanks for ur replay. but i need some clarification, in VBRK, customer(sold to party ) is not the key field so how can i pass the customer number to get the KNUMV,Becuase ABAPer is asking for key field to pass the data. please give some clarity.
I need to use KONP-KBETR condition value in report for some calculations. my ABAPer is asking for to get that KONP-KBETR value in REPORT, he wants some key field so that by passing the key field we can pick the KONP-KBETR value.
we ahve developed such reports and we are getting values from VBRP table and ask ABAPer to delet duplicate entries of Invoice
pass theas einvoice nos to VBRK and delet the invoices which are canceleld, Proforma invoice, and S1 invoices (just make sure you should not celect invoices which are cancelled/reversed/proforma)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.