Exchange rate not pulling for exchange rate type ZCEG OB08

[Former Member]

Dear Experts,

My client need different exchange rate type specially for EXPORT accordingly we have created the ERT : ZCEG also assigned to customer master , Exchange rate is maintained in OB08.

Please Note: client need exchange rate should be determine on current  date and accordingly i have assigned the  in Copy control to VTFL as below.

PricingExchRate type : E

Data VBRK/VBRP      : 001 (Inv.split (sample)

Please suggest what is do be done now.

Regards,

Geeta Singh

[Lakshmipathi · Accepted solution]

Take the inputs from the following note

• Note 22781 - Exchange rate in accounting, exchange rate type

and do the coding accordingly

G. Lakshmipathi

[Former Member · Accepted solution]

Thanks you Lakshmipathi,

with reference to note 22781, i have created routine and assigned it copy control VTFL. now the exchange rate is fetching correctly at header as well as at item level.

But the problem is it is splitting my invoice fist invoice with correct exchange rate maintained with ERT ZCEG at both header as well as at item level and the another invoice with value Zero with item category YB99 with different exchange rate at header as well as at item level.

Please help me to resolve this issue as it impact in excise posting.

Regards,

Geeta Singh

Message was edited by: G Lakshmipathi Please dont add your personal mail id

[ivano_raimondi · Accepted solution]

Hello,

the routine suggested by SAP note 27881 should maintained in customizing copy control at header level.

Best regards,

Ivano.

[nandeesh_kumar · Accepted solution]

Hi,

I maintained the routine at the item level of the copy control. its working fine .

Regards,

Nandeesh kumar.L

[Former Member · Accepted solution]

Dear Nandeesh,

In my case invoice is splitting, we wrote below code in routine and assigned at item level in VTFL.

FORM daten_kopieren_905.
   break cspl.
   DATA: BEGIN OF ZUK,
           MODUL(3) VALUE '001',
           VTWEG LIKE VBAK-VTWEG,
           SPART LIKE VBAK-SPART,
         END OF ZUK.
   ZUK-SPART = VBAK-SPART.
   ZUK-VTWEG = VBAK-VTWEG.
   VBRK-ZUKRI = ZUK.

SELECT SINGLE * FROM T001 WHERE BUKRS = VBRK-BUKRS.

DATA : it_tcurr TYPE TABLE OF tcurr WITH HEADER LINE.

   data  : BEGIN OF it_tcurr1 OCCURS 0,
             date type sy-datum ,
             ukurs TYPE tcurr-ukurs,
           END OF it_tcurr1.
   DATA: date_normal TYPE sy-datum.
   FIELD-SYMBOLS <tcurr_wa> TYPE tcurr.

   SELECT * FROM tcurr
       INTO TABLE it_tcurr
       WHERE kurst IN ('ZCIG' , 'ZCEG')
         and fcurr = vbak-WAERK
         and tcurr = 'INR'.

LOOP AT it_tcurr ASSIGNING <tcurr_wa>.

     CONVERT INVERTED-DATE <tcurr_wa>-gdatu
     INTO DATE it_tcurr1-date.  "you need to move that to normal date field
     it_tcurr1-ukurs = <tcurr_wa>-ukurs.
     append it_tcurr1.
   ENDLOOP.
   SORT it_tcurr1 by date DESCENDING.
   READ TABLE it_tcurr1 INDEX 1.
   vbrk-kurrf = it_tcurr1-ukurs.

DATA: KURSTYP LIKE VBRK-KURST.
KURSTYP = VBRK-KURST.
IF KURSTYP IS INITIAL.
KURSTYP = 'ZCEG'.
ENDIF.
VBRP-KURSK_DAT = VBRK-FKDAT.
CALL FUNCTION 'READ_EXCHANGE_RATE'
EXPORTING
DATE = VBRK-FKDAT
FOREIGN_CURRENCY = VBRK-WAERK
LOCAL_CURRENCY = T001-WAERS
TYPE_OF_RATE = KURSTYP
IMPORTING EXCHANGE_RATE = VBRP-KURSK
EXCEPTIONS NO_RATE_FOUND = 1.
IF SY-SUBRC NE 0.
VBRP-KURSK = VBRK-KURRF.
ENDIF.



ENDFORM.

Please update............!

[nandeesh_kumar · Accepted solution]

Hi,

Please do invoice split analysis in vf02. you will find out why invoice is splitting.

the possible reasons might be like the new exchange rate type is maintained in other sales areas of the customer master (mostly division).

The order might have more than one item category. for only one item category new routine is maintained in copy control. etc..

Regards,

Nandeesh kumar.L

[Former Member · Accepted solution]

Thanks a lot Nandeesh,

There is Batch split active in my business scenario and the invoice was getting split with different exchange rate and even the item category was for YB99 that Batch Sub Item level.

Assigned the customized routine to YB99 also and my issue is resolved.

Again thanks a lot.

But still at item level invoice is fetching exchange rate from ERT : "M".

[Former Member]

hi JMVB.prasad.. this is jagadesh..how r u..

[Former Member]

is there any update please

[Former Member]

dear geeta,

For exchange determined on current date please use

Data VBRK/VBRP

011  Bill. date= Today

  in item details.

Regards,

JMVB.Prasad.

[Former Member]

Dear JMVB,

My question different, actually i have created one exchange rate type ZCEG and maintained the exchange rate for the same in OB08 also i have assigned the ERT to customer master ( payer ) and in copy control VTFL assigned routine 001 that is split invoice but still SAP system is not fetching the exchange rate maintained ERT: ZCEG instead it is fetching for type 'M'.

Please suggest.

Please Note: Also i have create routine called  905 where system will update ZCEG exchange rate while posting to FI but in this case system is splitting the invoice and batch split is activated in client.

Regards,

Geeta Singh

[Former Member]

Dear geeta ,

in Copy control to VT FL u have to mention exchange rate type A instead of E .and also in Data VBRK/VBRP you have to mention as 011 instead of 001 and try..

Regards,

JMVB.Prasad

[Former Member]

I have already maintained.