Elias Stassinos

List of internal videos related to Material Master:

Every customer can be assigned a text in the texts for the Sales Area: This text is automatically copied in the Sales Order Header Note 1 text, which then is printed in the Notes section of the invoice. Watch the short video for its use (click to enlarge):

Customer Classification: TRADE NAME The TRADE NAME classification is added to 2 reports, ZHGI_CUSTOMERS_LIST, ZSD_BILLING_REPORT. If you use a layout and you cant find the filed add it. Screenshots: ZHGI_CUSTOMERS_LIST ZSD_BILLING_REPORT

In order to assign a categorization (classification) in a customer follow these steps: Open the customer in BP Select the FI/SD dropdown Goto menu Extras->Classification Add ZHGI_CUSTOMERS in class and press enter Select the value you want in the window below where the categories are. Go Back (F3) Save. Watch the steps in this sort video:

For Return Sales Orders of type ZREU, ZRE and ZRER we need to add a reason for the return The field is called ORDER REASON and some of you already use it. The list of reasons is the following: 901 Financial Reasons 902 Quality (curstomer claim) 903 Packaging Destroyed 904 Wrong Customer Order (Our responsibility) 905 Barcode Issue 907 Wrong Customer Order (Customer responsibility) If a reason is NOT defined the system will notify you upon pressing SAVE: ***IMPORTANT!!!*** If you press save the system will save the Order but you will NOT BE ABLE TO MAKE A BILLING. So you need to fill the order reason for all orders.

The process applies only to the intercompany scenario. All sales towards customers remain as-is. We have two distinct cases. 1. Buying company pays for transportation When the buying company pays for transportation we must NOT create a shipment cost document. To ensure this we will use a new shipment document type Z002 This shipment document does not generate shipment cost document (even if you try you will get an error). In order to inform the accounting department about the shipment cost we need to maintain the following text in the shipment. If Z002 is selected no charge will be present on the invoice. 2. Selling company pays for transportation I case the selling company pays for transportation we follow the as is process (shipment document type Z001 + shipment cost) Charge will appear on invoice as normal.

TCODE: ZFI_TCMD Purpose: Detailed view of Tax Codes and their settings Additional info: https://blogs.sap.com/2020/03/03/analysis-of-tax-codes-master-data/

Purpose: We need to have a total overview of costing for one material and one period. Transaction: CKM3N CKM3N is the central point where we can get costing information for a specific item at a specific period. The following selection provides info about item 50805-MCT6 for June 2020: We can observe that the previous unit cost was 0,54 BGN / PIECE and that during this costing run the piece cost raised to 0,81 BGN / PIECE.: In the section Receipts the system shows the production data for this item: In this example we can see that we run costing 3 times , because we can see 2 reversals of settlements. These are the settlements that system creates in order to have the actual costs for the material in our books. The components that exist in the Bill of Materials are shown on top. These are the items that were consumed at this phase. The work orders can be also found in the receipts (production) lines. We can also view the cost components and their contribution in the unit cost by pressing "Cost Components for Price" button: For example we can observe that Depreciations are accounted for 0,20 of the total 0,81 BGN / Piece

Purpose: We need to get the history of the weighted average for a material. Transaction SE16N - General Purpose database table viewer SE16N is a general program that can output any system table from the system. The table that holds the weighted average history is MBEW. The following selection outputs the data for product 50805-MCT6: The output is: In the example we observe that this item was uploaded from JDE with piece cost of 0,38 BGN/ Piece (MBEWH is always in local currency). Then production in May 2019 upped the price cost to 0,54 BGN / Piece and then production in June 2020 moved the unit cost to 0,81 BGN / Piece.

Purpose: In order to allocate production expenses to work orders, the system uses 2 activity types. ACT01 - MACHINE HOURS and ACT02 - PRODUCTION QUANTITY. During costing the system calculates these activity prices. Transaction: KSBT The following selection will request the activity prices for December 2020 for both activity types, for New Glass: The output is as follows: ACT01 Machine hours is used only for the Forming Lines production phase, so only the relative cost centers are shown For example Line 2.1 has been calculated to have 253,05 EUR per Machine Hour. This is the rate that the system will use to cost the Work Orders according to the confirmed hours that the orders have.

Purpose: To view the daily entries of machine production operation including speeds, downtimes e.t.c Transaction: ZHGI_PRD_REP The report displays the daily entries for production in the system. The entries are related to the Forming Lines phase of production. In this phase the outcome is NOT the final product , it is the bulk product. Meaning that w will need the material code of the bulk or the work order of the bulk (Type ZP02). The following example requests one specific work order that produces the bulk 50805U: The output of the report gives the details: JCT: Job Change Time columns WT: Working Time (in minutes) DT: Down Time (in minutes) WT Gobs: The speed of the product for the working time. Net/ Gross weight/PC: The actual net and gross weight per piece. Ratios: in the final columns all the ratios are printed.

Purpose: View Work Order data (costs and goods movements) Transaction: CO03 Provide the Work Order in the transaction, and press Enter: In order to view the warehouse transactions for the order (Goods Movements) we navigate to GOTO -> DOCUMENTED GOODS MOVEMENTS: We will be presented with a list of all the warehouse transactions for the order. Movement Type Column: 101/102: Production/Cancellation of Production 261/262: Consumption/Cancellation of Consumption 531/532: Cullet Production In order to view the cost analysis for the order we navigate to GOTO -> COSTS -> ANALYSIS The list is presenting the basic cost related transactions for the Work Order: Goods Issues: The materials that were consumed in the order. cullet is defined as negative consumption. This is how production of cullet is recorded. Confirmations: Depending on the Work Order type , this line outputs the total confirmation activities for the Order. If it is an order for forming lines (ZP02) the activity type is MACHINE HOURS. In the example it shows that this order has 93,917 HR (Hours) of Operation. Goods Receipt: The production output for the order. Settlement: The amount that SAP Costing settled in the period end closing. The system calculated the variations from standard cost and settles the difference in order to calculate the actual cost for the work order. We can also view the Bill of Material for the Work Order by visiting the COMPONENTS screen:

There are more than one ways to find when an item has been produced and the work orders with which it was produced. Option #1: From ACMON Barcode data Transaction: ZHGI_PP_ACMON The above selections will provide all the lines (one line = one label = one pallet) for the material for plant 3000 NEW GLASS. Option #2: From general ledger for materials. Transaction: MB51 The following selection will output all the production movements (101,102) for one material This view provides more basic information like Date of production and Work Order number:

A webex recording session, showing the procedure of MM reception of products from New Glass company 3000 to Uniglass Ukraine company 5300. At the end of the video you can find explanation of the Excel Template we use for creation of new customers.

We need to flag for deletion the specific level we need to:

Transaction: MB5B Purpose: To show the stock in quantity and value at a given date. The standard report MB5B has been converted to normal ALV, in order to be able to export it to Excel. The report will give one line per item showing the basic figures: Starting Balance Quantity / Value for the first date of the period we put Receipt Quanity / Value for the period we choose. Receipt means ANY incoming movement (Purchase, Surplus e.t.c) Issue Quantity / Value for the period we choose. Issue means ANY outgoing movement (consumption, sales, shortage e.t.c) Closing Balance Quantity / Value for the period end we choose. Demonstration to get the Spare Parts Stock at 30/09/2020.

Transaction: ZHGI_CONSCOST Purpose: Shows the cost of consumptions for a given period. Filters available are : Company, Posting Date , Material Type and Movement Type. It also includes Basic Information about which movements are valid. Find below an example on how to get the Spare Parts consumption cost for New Glass, for the period 01/01/2020 - 27/10/2020

Purpose: Every work order should have production and consumption during the month. Work Orders that have either only production or only consumption need to be checked for possible mistakes: Transaction: ZHGI_WO_CHECK Selection screen. We need to put the company (if BLANK then all companies will be checked), the year and the month The system will then show the orders that miss either consumptions or production. Clicking on the work order , will open the CO03 for further check of the order

Apart from Glass Flow , we have some situations in production postings where we don't have any packed items but we have production of melted that becomes cullet. In these cases we need to: Calculate the amount of melted that we need to make cullet. Production of Cullet 531 to the work order of melted. After we calculate the melted = culllet we have to produce , we need to make a MIGO transaction with the following characteristics: Then you need to put the correct date and description. Also you need to delete the lines that the system brings automatically. These come from the BOM of Melted: Create a new line for cullet item And then put the necessary data: Item: R-2400302009 Quantity Plant Storage Location Order The final picture should be something like that: If all data are correct, then you only have to make a CHECK and then POST.

If we want to fix also sale order quantity, then we fix also sales order quantity. In this step we can continue with sales order process. Next Step is to fix Warehouse. --Warehouse steps-- After the good issue from sales then in warehouse must have the following picture: In storage 916 and in delivery number storage BIN, we must have only the pallets that did not loaded. We must return from dummy BIN and PCs to normal Warehouse BIN with previous SU’s. When we complete the above values, we press Enter to go to next screen. This step must be per pallet. And a Transfer order have been created. If have not been confirmed. Then we confirmed it. We check the SU where have been gone. And we can move it with RF from BIN to BIN.

There are cases where we need to link products to external files. That could be desings , images (for web or any other usage). In order to be able to manage and automate processes the following rules must apply. NON-DECORATED: For files that refer to the piece of product the link will be the "Mould Code" that we have in SAP which is the first 5 digits of the code. Item: 23068-R66-FN00-SC01 Mould Code: 23068 For Files that need to refer to the final packaged code, we will use the whole SAP Code. Examples DECORATED: For decorated tableware products we will use the mould code plus the decoration code NON DECORATED TABLEWARE: For non decorated tableware we will use the 5 digit code of the mould. ***Important Note*** Any report/system/procedure that we will create will look at the rules above and assume that if a produt has an image , it will follow the above rules and at least will have the xxxxxxx-1.xxx as the first file.

Transaction: ZHGI_MIS_PRDCOST Description: Produces directly from SAP the production cost page of MIS report. It reflects the actual costs that have been allocated to the production cost run. It can be run for 1 or more periods for the same year. Selections: Currently the following layouts have been created: The list can be exported and worked on excel. Find below a sample for one of the reports:

In cases of Repack and Resort we may have some pieces of products that remain to storage locations 11xx and we need to send them for destruction. We must send them to Storage Location 0060 by using MIGO transaction. We run MIGO and use movement 311.