09-11-2007 9:05 AM
Hi Friends,
I want to display Bill-To party of a sales order that is displayed under Partners tab of VA03. The same Bill-To party I found in KNVP table - KUNN2 field. I am selecting KUNN2 field based on KUNNR, VKORG in sales order and PARVW = 'RE'. But for few sales orders, the KUNN2 field in KNVP and the Bill-To party appearing in Sales order (VA03) are different. Please let me know why there are different values at two places.
Thanks and Regards,
Netrey
09-11-2007 9:10 AM
try using table vbpa..use parvw = 'RE'..
SELECT posnr from vbpa into zposnr WHERE vbeln = zvbeln.
select kunnr from vbpa into zkunnr where parvw = 'RE' and vbeln = zvbeln and posnr = zposnr.
endselect.
endselect.
plz reward points if dis helps
Message was edited by:
abapuser
09-11-2007 9:08 AM
Netrey look in VBPA for your answers
Partners are stored per sales order and per line item in VBPA
for header parnters ponsr is '000000'.
09-11-2007 9:10 AM
try using table vbpa..use parvw = 'RE'..
SELECT posnr from vbpa into zposnr WHERE vbeln = zvbeln.
select kunnr from vbpa into zkunnr where parvw = 'RE' and vbeln = zvbeln and posnr = zposnr.
endselect.
endselect.
plz reward points if dis helps
Message was edited by:
abapuser
09-11-2007 9:10 AM
Hi,
Take the info from VBPA table instead of KNVP.Its a sales doc partner function table.The partner can be changes at the document level. From the transactional data, VBPA table gets updated.
Regards,