This website is not affiliated with, sponsored by, or approved by SAP AG.

Logical DB DDF and Sales partner

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Logical DB DDF and Sales partner

Postby rpinxt » Tue Mar 10, 2015 4:51 am

For Logical database DDF I want to include sales partner from the billing document.
Therefore I want field PARVW and KUNNR from table VBPA.

I linked it to table BSID from LDB DDF based on the billing number and hardcoded PARVW 'BP' like this :
Code: Select all
CLEAR RP_BPCUST.
SELECT SINGLE KUNNR FROM VBPA
  INTO RP_BPCUST
  WHERE VBELN = BSID-VBELN AND PARVW = 'BP'.


However I only get the main line, well actually I get an empty cell when I use 'BP' but when I leave out 'BP' I get only the main 'SP' value.
But for the specific billing I know for sure there is a different bill-to party than the sold-to party.

Why do I only get the 'SP' value and not the 'BP' value??
Thanks
rpinxt
 
Posts: 146
Joined: Mon Jul 23, 2012 8:02 am

Re: Logical DB DDF and Sales partner

Postby Gothmog » Tue Mar 10, 2015 7:34 am

You must use the internal code for the partner function, not the display (language-dependant) one.
Have a look at table TPAUM for the internal/display code translation.
For Bill-to Party, the internal code is 'RE'.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: Logical DB DDF and Sales partner

Postby rpinxt » Tue Mar 10, 2015 10:01 am

woop woop! :D

Thanks Gothmog!
Good to learn about this TPAUM table and that you need to use internal code and not a language dependant one! (sound logical actually...)

It works like a charm.
Thanks a bunch!
rpinxt
 
Posts: 146
Joined: Mon Jul 23, 2012 8:02 am


Return to ABAP

Who is online

Users browsing this forum: No registered users and 4 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.