Call upon a additional field for new additional field

[rpinxt]

Dear All,

Please see this code:

Code: Select all

CLEAR RP_INV.
SELECT SINGLE BELNR FROM BKPF
  INTO RP_INV
  WHERE RP_AWKEY = BKPF-AWKEY.

Code RP_AWKEY I already did code in additional field 1 and I thought this was enough in additional field 2.
But the check says that RP_AWKEY is unknown.

How can I use the already created field AWKEY in this coding?
Thanks!

[Gothmog]

There's no field named RP_AWKEY in table BKPF.

Code RP_AWKEY I already did code in additional field 1 and I thought this was enough in additional field 2.

What do you mean by this?

[rpinxt]

Ok let met elaborate.

I made this code for first additional field RP_AWKEY:

Code: Select all

CONCATENATE EKBE-BELNR EKBE-GJAHR INTO RP_AWKEY

.

So this makes the key with which I can get the invoice number from BKPF.

Then I wanted to make second additional field RP_INV with this code:

Code: Select all

CLEAR RP_INV.
SELECT SINGLE BELNR FROM BKPF
  INTO RP_INV
  WHERE RP_AWKEY = BKPF-AWKEY.

So additional field 1 is part of the coding of additional field 2.

But somehow the coding of additional field 2 does not recognize additional field 1.

[Gothmog]

So you're looking for a document number in BKPF for wich the Reference Key (BKPF-AWKEY) has the value you concatenated in you (local to you program) data variable RP_AWKEY?
In this was, your WHERE condition is inverted. Try with:

Code: Select all

SELECT SINGLE BELNR FROM BKPF
  INTO RP_INV
  WHERE AWKEY = RP_AWKEY.

[rpinxt]

damn while I was writing that I saw what was wrong....
I had it backwards.
This would be the correct way:

Code: Select all

CLEAR RP_INV.
SELECT SINGLE BELNR FROM BKPF
  INTO RP_INV
  WHERE AWKEY = RP_AWKEY.

Thanks Gothmog for making me see this.

[rpinxt]

Yes exactly Gothmog....I realised myself already
Thanks for pointing that out.