Skip to Content
0
Sep 13, 2023 at 06:20 PM

FICO substitution prerequisite query

48 Views

Hi all,

I have a substitution query with the below conditions. can you help build the query please:

  1. Business Partner (BP = BSEG-LIFNR) number prefix digit is 4
  2. If Business Partner number prefix digit is 1 and the document currency is not equal to EUR, then the payment method should be V
  3. Posting line item position 001 (BSEG-BUZEI) = vendor account

I have written something like this but its not working:

(BSEG-LIFNR :1-1: = '4' OR (BSEG-LIFNR :1-1: = '1' AND
BSEG-H_WAERS <> 'EUR')) AND BSEG-BUZEI = '001'