foreign payments indicator

[Former Member]

Hello gurus!

I need to create one simple report from BKPF table which shows only accounting documents related to foreign payments.

Which filed in this or some other connected table contains some kind of indicator for foreign/domestic payments.

PS: I'm working for Croatian company so temporary I can do this by the currency (HRK = domestic / EUR = foreign) but ... this is only temporary solution until we get to EU

Thanks in advance

T.

[Former Member]

Hi

It depends what foreign payments you mean for you:

- U means foreign currency?

If it's so u should check which currency is assigned to the company code (T001-WAERS), and so get all payments with a foreign currency (BKPF-WAERS <> T001-WAERS)

- U means foreign customer/vendor

If it's so u should check which country is assigned to the company code (T001-LAND1), and so get all payments with foreign partner (having a different country in the master data, KNA1-LAND1 <> T001-LAND1 or LFA1-LAND1 <> T001-LAND1);

Just last thing: rember that:

BKPF-WAERS is document currency

BKPF-HWAER is company code currency

So the foreign payment should be a document where those fields are a different value,

Max

Edited by: max bianchi on May 27, 2008 3:22 PM

[Former Member]

Hi

It depends what foreign payments you mean for you:

- U means foreign currency?

If it's so u should check which currency is assigned to the company code (T001-WAERS), and so get all payments with a foreign currency (BKPF-WAERS <> T001-WAERS)

- U means foreign customer/vendor

If it's so u should check which country is assigned to the company code (T001-LAND1), and so get all payments with foreign partner (having a different country in the master data, KNA1-LAND1 <> T001-LAND1 or LFA1-LAND1 <> T001-LAND1);

Just last thing: rember that:

BKPF-WAERS is document currency

BKPF-HWAER is company code currency

So the foreign payment should be a document where those fields are a different value,

Max

Edited by: max bianchi on May 27, 2008 3:22 PM

[Former Member]

I ask you about this second option - foreign customer/vendor

Jeah ... I will take the vendors/customers country code ... but I think that these master datas are not quite correct in the system

Because of that I was looking for some other indicator.

Anybody else!???