Table of contents 

• Table of contents 
• 1. Objective and Scope
  • 1.1. Objective of this Operation
  • 1.2. Scope
• 2. Definitions
• 3. Procedure

1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to provide instructions for the Sales by Product (Prodcom) for company code 6068.

1.2. Scope

This document provides information on how to prepare the Sales by Product (Prodcom) to company code 6068.

2. Definitions

See Finance Glossary:

• ...

3. Procedure

3.1. Go to transaction KE30 and Report ZZZ-SOLV00

Deselect all and choose Qty invoice and Market Product Sales

Click on Period column

Choose only Year

Export the data to Excel

3.2. Save as Excel file

Adjust the file:

• Duplicate the tab to have raw data and adjusted data tabs
• Filter in columns Qty Invoice and Market Product Sales 0.00 and delete those lines (where on both columuns are 0.00)

Copy the data in the Spreadsheet file tab KE30, copy only:

Column A (Product)

Column B (Product description)

Column C (Sales Qty KG)

Column D (Sales GBP)

3.3. Go to transaction MB51

Variant: 7771 PROD COMM

             6068 PROD COMM

In KE30 you can check all the plant codes, make sure that you add them in the list (and update the variant).

Update the Posting date

Save to excel - MB51_XXXX

Raw data tab name "by material raw data"

Copy the data into another tab "by material" - Leave only summed lines (delete lines with no color filling)

Double check measures by base unit of measure

Check total amounts

To get the Unit of measures table for specific materials

SQ00

JWMARM

Copy all the material numbers