Scope



ERP



Frequency



References



Forms



Attachments

1. Objective and Scope
     

     1.1. Objective of this Operation


The purpose of this procedure is to explain how to recalculate and activate transfer prices in the TRSA table on a monthly basis.


2. Definitions


See:

3. Tasks description


  • Execute new Unit TP calculation for Cost Plus transactions.
  • Execute HUSP table and activate sales prices for the period to do the price less calculation.
  • Execute new Unit TP calculation for Price Less transactions.

     3.1. I execute new Unit TP calculation for C+ Transactions


WP1: TPs are calculated based on the Standard price of the products in the Delivering entity. The
Standard prices are released on day 1 of each month. Therefore, this task should be processed in WP1 on
D+3 of each month, so we could guarantee that no prices modifications are going to be made, due the
closing period.

PF1: TPs are calculated based on the actual prices of the products in the Delivering entity. The actual
moving price is released usually on D+2 (after Material ledger closing). Therefore, this task should be
processed in PF1 on D+4 of each month.

          3.1.1. I access TP table ZFI_TP_REPORT in WP1 and PF1


Go to transaction ZFI_TP_REPORT

  • Select variant "NEW-C+TT"

Filters on variant

Transaction type: TOLLING, OTHER_C+, FLOW_THRU, CON/MANUF, C+MANUF, COST_MANUF.

Status: 2 to 5

Requested Valid From Date: First day of the current month.

Execute the transaction.

The prices will be available for activation with status "3-To be activated" in the TSRA table, section "Review record and monitor the status".

     3.2. I execute HUSP table and activate Sales prices


This data for Historical Sales price comes from BW P&L of each entity. Therefore, the task should be
processed after D+3 of each month, so we could guarantee that no prices modifications are going to be
made, due the closing period.

  • WP1: There is an automatic job for WP1 which loads BW data to the HUSP table when sales is closed (usually after D+2).
  • PF1: Before proceeding with task 3.2.1, execute the transaction with variant 'ECO_HUSP' (Upload Sale price from BW file). Then the Sales
    price from BW data will be available in HUSP for activation.

          3.2.1. Go to transaction ZFI_TP_REPORT and select HUSP table


Click on "Review record and monitor the status"

Selection table: HUSP

Month and Fiscal Year: 0MM.YEAR (current period)

Status: 1

Select all data and click on Change item Status for 2.

The sales prices will be active for the period, therefore the New Unit TP calculation for the Price-Less transactions can be executed.

     3.3. I execute new Unit TP calculation for Price Less Transactions


          3.3.1. I access TP table ZFI_TP_REPORT in WP1 and PF1


Go to transaction ZFI_TP_REPORT

  • Select variant "NEW-DIST-TT"

Filters on variant:

Transaction Type: DIST/MANUF, DIST/TOLL, OTH_C+_PL

Status: 2 to 5

Requested Valid From Date: First day of the current month.

Execute the transaction.

The prices will be available for activation with status "3-To be activated" in the TSRA table, section "Review record and monitor the status".