TS - MM - PO Enhancements Update Bill of Exchange Rate

Financial Doc Status
Technical Design
Enhancements in PO
Update Bill of Exchange Rate
and
Customs Exchange Rate
Last Updated On: 25 Oct 2014 Page 1 of 9 Version: 1


Document Information
Enhancements in Purchase Order – Update Bill of Exchange Rate and

Deliverable Name
Customs Exchange Rate
Author Surbhi Garg
SAP Module/Team MM
FS Rahul Jain
Priority High
Complexity Level Medium
Program Type Enhancement
Version V1.0
Status Completed
Revision History
Version
Date Author Revision Description
No.
V1.0 27/10/2014 Surbhi Garg
Other Related Documents
<Please insert links to related Documents (issues, data entities, etc.).>
Related Document Comment

Contents
1. Development Overview............................................................................................................................... 4
1.1 Requirements Summary..................................................................................................................... 4
1.2 Dependencies / Constraints................................................................................................................ 4
1.3 Selection Screen Details..................................................................................................................... 4
1.4 Detailed Design................................................................................................................................... 4
1.4.1 SAP Objects & ABAP Development................................................................................................4

1. Development Overview
1.1 Requirements Summary

The scope of this enhancement is to allow the business user for entering the required exchange rate and
value.in Me22n for the given below business scenario.
Scenario
Import Po is created with approximate quantity and rate, thereafter we get the bill of lading date and the actual
accessible value.
So, on the basis of bill of lading date the exchange rate should be entered not on the basis of when PO was
created in system.
For the above requirement the given below parameters are taken into consideration:-.
1. Purchase Order Number

2. Exchange Rate
3. Currency
4. Release indicator
Assumptions
All PO will be changed using ME22N Transaction Code.

I.e. No PO will be changed using ME21N, ME29N
1.2 Dependencies / Constraints

NA
1.3 Selection Screen Details
Name Table field/Check Select-option(S) Comments Default

Box/Radio or Parameter(P) Value
Button
PO Table Field P NA NA
Number
PO Line Table Field P NA NA
Item
1.4 Detailed Design
1.4.1 SAP Objects & ABAP Development
SAP Objects
Flow:
<<List the program name, function module, transactions, etc. created for this development (e.g.,
workflow, business object, and standard task).>>

Name Type Description

Program Report To update PO exchange rate and PO line item detail

also and It will also create treasurery exposure.
Include ZMM_PO_UPDATE_F01 INCLUDE for table control

data (gen.)
Transaction ZMM_EXCH_RATE Update Exchange Rate
Table ZPO_RATE Custom table to store PO Exchange Rate

Project
User Exit
BADI Implementation
Function module
SAP Script
Adobe Form
Message Class
BOR Object
Workflow Template
Table Structure :
ABAP Development
Fetch Data
1. Fetch all the data from custom table ZPO_RATE based on the PO number and line item enter entered
on the selection screen into internal table IT_USER_ROLE.
2. If IT_USER_ROLE is not initial, then fetch the Document cond. From table EKKO and Quantity from
table EKPO.
3. Fetch all the data from table KONV based on the document cond. Type.
Call Screen 2000
1. Create Table wizard based on the custom table ZPO_RATE.
User Command: - UPDATE
2. The User will enter the Customs Exchange Rate and will have an option to update the assessable PO
in respective line item condition type. (Condition Type: ZEAS) using ME22N transaction code.

a) Fetch the selected row from internal table UT_USER_ROLE.

b) Read all the condition types before ZEAS from internal table IT_KONV.
STEP1: Get the KNTYP equal to ‘H’, ‘KONV-KRECH’ = C and ‘KONV-KINAK’ equal to Blank.
New Value = (KONV-KBETR X EKPO-MENGE) X ‘Customs Exchange Rate’.
STEP2: If the next condition type if of the type ‘KONV-KRECH’ equal to ‘A’ – Percentage then
read the percentage value from KONV-KBETR divide it by 10. Calculate the value on the basis of
new value in STEP1, and if its KBETR is with negative sign, then deduct it from Step1 (New
Value) and if it’s Positive add it to STEP 1, new value.
STEP3: If the next condition type if of the type ‘KONV-KRECH’ equal to ‘B’ – Fixed Amount then
read the value from KONV-KBETR and MULTIPLY it by CUSTOM Exchange Rate and add to the
STEP1+STEP2.
STEP4: If the next condition type if of the type ‘KONV-KRECH’ equal to ‘C’ – Quantity and
KNTYP other than ‘H’ then read the value from KONV-KBETR and MULTIPLY it by EKPO-
MENGE and then by CUSTOM Exchange Rate and add to the STEP1+STEP2+STEP3.
STEP5: If the next condition type is ‘KONV-KSCHL’ is equal to ‘ZEAS’. Then multiply the
calculated at STEP 4 X 1.01 and update the KONV-KBETR.
System should calculate the Duties such as Basic Excise Duty, CVD, etc.
c) Use BAPI ‘BAPI_PO_CHNAGE’ to update the pricing conditions and item net price value as per
the Custom exchange rate which is maintained by user.
d) If user wants to create the Treasury exposure also, then get the PO details with the help of BAPI
‘BAPI_PO_GETDETAIL1’.
e) Pass all the required parameters in the structure of BAPI ‘BAPI_TEX_EXPOSURE_CHANGE’ to

change Raw Exposure.
f) If exposure lines are not exist, then create the exposure line by using FM
'BAPI_TEX_EXPOSURE_CREATE'.
User Command: - REFRESH

Refresh all the custom table data.
User Command: - PODETAILS

Call transaction ME22N with the entered PO number in change mode.
User Command: - PODETAILS

Call transaction ME23N with the entered PO number in display mode.
Selection Screen


TS - MM - PO Enhancements Update Bill of Exchange Rate

Uploaded by

Copyright:

Available Formats

TS - MM - PO Enhancements Update Bill of Exchange Rate

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

TS - MM - PO Enhancements Update Bill of Exchange Rate

Uploaded by

Copyright:

Available Formats

Financial Doc Status

Last Updated On: 25 Oct 2014 Page 1 of 9 Version: 1

Last Updated On: 25 Oct 2014 Page 2 of 9 Version: 1

Enhancements in Purchase Order – Update Bill of Exchange Rate and

Other Related Documents

<Please insert links to related Documents (issues, data entities, etc.).>

Related Document Comment

Last Updated On: 25 Oct 2014 Page 3 of 9 Version: 1

Last Updated On: 25 Oct 2014 Page 4 of 9 Version: 1

1.1 Requirements Summary

1. Purchase Order Number

All PO will be changed using ME22N Transaction Code.

1.2 Dependencies / Constraints

1.3 Selection Screen Details

Name Table field/Check Select-option(S) Comments Default

1.4 Detailed Design

1.4.1 SAP Objects & ABAP Development

Last Updated On: 25 Oct 2014 Page 5 of 9 Version: 1

Name Type Description

Last Updated On: 25 Oct 2014 Page 6 of 9 Version: 1

Program Report To update PO exchange rate and PO line item detail

Include ZMM_PO_UPDATE_F01 INCLUDE for table control

Transaction ZMM_EXCH_RATE Update Exchange Rate

Table ZPO_RATE Custom table to store PO Exchange Rate

Call Screen 2000

1. Create Table wizard based on the custom table ZPO_RATE.

User Command: - UPDATE

Last Updated On: 25 Oct 2014 Page 7 of 9 Version: 1

a) Fetch the selected row from internal table UT_USER_ROLE.

e) Pass all the required parameters in the structure of BAPI ‘BAPI_TEX_EXPOSURE_CHANGE’ to

User Command: - REFRESH

User Command: - PODETAILS

User Command: - PODETAILS

Last Updated On: 25 Oct 2014 Page 8 of 9 Version: 1

Last Updated On: 25 Oct 2014 Page 9 of 9 Version: 1

You might also like