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".

  • No labels