Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQ02-Getting vendor partner of outbound Delivery

ratana_pouy
Participant
0 Kudos

Dear All,

I am using ABAP code in SQ02 to getting Vendor partner from outbound delivery. i created a new field "Forwarding Agent" and adding Code below:

++++++++++++++++++

Clear ZLIFNR.

Select LIFNR from VBPA into ZLIFNR where VBELN = LIKP-VBELN

and POSNR = ''

and PARVW = 'CR'.

endselect.

+++++++++++++++++++

There's no error during generating Query, then i go to SQ01 to generate report, column field "Forwarding Agent" is blank.

i wonder, i go to check vendor partner of outbound delivery is exist, why it doesn't fetch data from table VBPA into report?

please help...

Regards,

Rtn

1 ACCEPTED SOLUTION

pranay570708
Active Contributor
0 Kudos

Hi,

Please check below code. You have to do conversion on PARVW.

DATA: L_PARVW TYPE VBPA-PARVW.

L_PARVW = 'CR'.

CALL FUNCTION 'CONVERSION_EXIT_PARVW_INPUT'

   EXPORTING

     INPUT  = L_PARVW

   IMPORTING

     OUTPUT = L_PARVW.

SELECT SINGLE LIFNR FROM VBPA INTO ZLIFNR WHERE VBELN = LIKP-VBELN

AND POSNR = ''

AND PARVW = L_PARVW.

8 REPLIES 8

SimoneMilesi
Active Contributor
0 Kudos

Hi Ratana,

you forgot the conversion exit/routine for PARVW data element

Former Member
0 Kudos

Hi Ratana,

Try this,

Clear ZLIFNR.

Select single LIFNR from VBPA into ZLIFNR where VBELN = LIKP-VBELN

and POSNR = '000000'

and PARVW = 'CR'.


Check for partners are stored in header or position

Check table VBPA in SE16N.


Regards,

0 Kudos

hi Pau Gavino Martinez

the result is still the same. There is no data.

Thanks & regards,
Rtn

0 Kudos

Conversion exit for PARVW: it doesn't exist CR as value in VBPA table

0 Kudos

Hi,

In SE16 table VBFA for VBELN = LIKP-VBELN there are results ?

0 Kudos

Hello, 

In table TPAUM have input/output conversion for PARVW .

Try with values in this table for CR.

Regards,

pranay570708
Active Contributor
0 Kudos

Hi,

Please check below code. You have to do conversion on PARVW.

DATA: L_PARVW TYPE VBPA-PARVW.

L_PARVW = 'CR'.

CALL FUNCTION 'CONVERSION_EXIT_PARVW_INPUT'

   EXPORTING

     INPUT  = L_PARVW

   IMPORTING

     OUTPUT = L_PARVW.

SELECT SINGLE LIFNR FROM VBPA INTO ZLIFNR WHERE VBELN = LIKP-VBELN

AND POSNR = ''

AND PARVW = L_PARVW.

0 Kudos

Thanks Pranay Patel

problem is solved