ERP Realm

ERP Realm is an online consulting company specilized in providing SAP solutions to meet your business requirements.
Contact Us
Material XXXX <Plant> <Sloc> does not exist
SAP

M7 006 - Material XXXX <Plant>  <Sloc>  does not exist

Error Message

Read more

Tag M7 006

Storage location XXXX for material XXXXXXXX plant XXXX valuation type XXXX does not exist
SAP

M7 238 (Warning)

Storage location XXXX for material XXXXXXXX plant XXXX valuation type XXXX does not exist

Read more

Tag M7 238

Material Reservation for Projects
SAP

Material Reservations for projects planned at network activity level can be automatically (with network as account assignment) created based on system configuration. But for Project structure at WBS level  generally materials are purchased as project stock and issued to project without reservation. This blog explains the process / limitations in case reservations are to be created.

Read more

Tag Reservation , Project Reservation , MB21

Default Storage Location in Inbound Delivery using enhancement
SAP

Shipment documents for inbound processing of shipments are created with reference to inbound delivery. Inbound delivery is created either manually or automatically in the background against PO / PO Line items / Vendor.

Most of the case when shipments are handled using LE module , have EXW as inco term and the goods supplier needs to be paid once items are picked by Freight forwarder.

In SAP for paying the Goods Supplier , GRN needs to be posted. GRN can be posted either directly against PO or from inbound delivery or from shipment document stages.

Storage location is a mandatory field for posting GRN , which can be entered in purchase order manually. The other option is to default the location using enhancements.

This document explains the enhancement step required for defaulting storage location in Inbound delivery document.

Read more

Tag VOFM , Default Sloc , Inbound Delivery

Adhoc Shipment cost document flow report
SAP

SAP Logistics execution module is a specialized SAP module for managing inbound and outbound logistics activities. This module interfaces with Material management module for inbound processing and Sales/Distribution for outbound process.Since multiple modules are interfaced few reports are generally not available as a standard report but can be generated using query reports.

Read more

Tag Shipment cost report , VTFA , VBFA

Rejection lines displayed in VF04
SAP

Reason for rejection key in sales documents are actually configurable key and business transactions are controlled based on the setup. Some times items rejected in sales documents may be visible in reports like billing due list. This is not a system error because the behavior is controlled by configuration.

Read more

Tag VF04

Reason for Rejection in Sales documents
SAP

Reason for rejection in sales documents are being used to identify items that are to be processed separately. Behavior of items marked with reason for rejection as processed differently in sales module which is controlled by configuration. 

Read more

Tag Reason for Rejection ,VF04 , DP91

Defaulting Profit center in Sales Documents
SAP

Assignment of profit center in sales document is mandatory if the revenue analysis is based on profit centers. There are multiple ways by which profit center can be defaulted in sales order line items. This blog explains how profit center can be defaulted in sales documents (Quotation , Sales order ) based on substitution.

 

Read more

Tag Default Profit center , OKEL , OKEM

IRR Calculation using Python Code
Python

IRR is an important gauging factor for comparing periodic investment return. IRR is difficult to calculate manually. This blog provides a sample code for calculating IRR using Python.

Read more

Tag IRR calcuation

Transport Organizer Tools and details
SAP

SE01 / SE10 /  SCC1  are frequently used t codes used for organizing transport request and performing copy of transports within clients. Most of the time consultants get into difficult times finding specific transport requests. Transport organizer tools help is searching transport requests effectively and easily.

Read more

Tag Transport Organizer , SE01,SCC1

Understanding IRR Calculation Logic
Equity

Undertanding returns on any investment is a key skill required by any investor. There are many mathematical formula available for calculating the returns. But do we use it correctly and wisely ? 

AAGR , IRR , NAR , XIRR..

Read more

Tag XIRR , IRR , MF Return

External Numbering of Batch Master
SAP

Batch generated using Goods movement transactions can be assigned to a internal number or an external number  or entered manually during document creation.

Internal and external numbering is controlled by configuration. Separate number ranges can be maintained for internal and external numbering.

Read more

Tag Batch Master Numbering , External Numbering

MYSQL DB dump from Web Hosting Sites
My_SQL

Read more

Tag mysqldump , pythonanywhere , SSH Tunnel , Putty , AWS

Option for defaulting delivery address in purchasing Documents
SAP

Delivery address in purchase orders are defaulted form Plant / Storage location or Plant address if storage location data is not available. But business requirement may be such that items are delivered to different delivery address. Various standard and enhancement options will be discussed in this document.

Read more

Tag Default Delivery address , Delivery address in PO

Classification during GRN using Batch Mgmt
SAP

Read more

Tag Batch Mgmt , MIGO , Classification

Profit Center in Billing Document
SAP

This documentation briefly explains how profit centers are determined / defaulted in sales billing document. Profit centers in billing documents are generally derived from the sales documents , but as per business requirements the determination process can be altered.

Read more

Tag VF01 , Profit Center , Default

Version 0 is blocked for fiscal year XXXX
SAP

Message Area : GP 

Number           : 626

Read more

Tag Version locked , OKEQ

Default Account Assignment in Purchasing Documents
SAP

Account Assignment :  Cost element and Cost Object is a mandatory entry in purchasing documents for non stock items. Eventhough its a manual entry standard SAP provides few options for defaulting account assignment based on business rules.

This blog explains the various options available for defaulting account assignment in purchasing documents.

Read more

Tag Default Cost Center , Default Order,OKB9

Status Profile assignment - SAP PS
SAP

Status Profile are additional status control which can be assigned to PS objects like Project definition , WBS , Networks. These additional user status provide better control in addition to standard controls.

Eg : A particular WBS should be released but no procurement document should be created against the WBS. In such cases status profiles become handy.

The option for changing the status can be additional controlled used authorization object assigned for the status..

Read more

Tag Status Profile

PO Items can be deleted after invoice
SAP

Deletion indicator can be set manually in the Purchase order even after invoice is posted. This may look stage as per the business process but read more to understand SAP's thought process.

Read more

Tag PO Deletion Flag , LOEKZ

Backup and Restore MySQL DB
My_SQL

Database backup and restore is one of the main database mangement operations. With advent of various tools online and automatic backup provided by different hosting companies , the need for manually running a back is obviated. 

Nevertheless there might me some times when we need to backup and restore a database. This process is also useful when a copy of the database is required (with Data and Schema).

mysqldump is a standard tool available with mysql which can do this for us in a jiffy.

Read more

Tag mysqldump , Backup , Restore

Automatic GRN from Inbound Shipment Document
SAP

Shipment documents for inbound processing of shipments are created with reference to inbound delivery. Inbound delivery is created either manually or automatically in the background against PO / PO Line items / Vendor.

Most of the case when shipments are handled using LE module , have EXW as inco term and the goods supplier needs to be paid once items are picked by Freight forwardered.

In SAP for paying the Goods Supplier , GRN needs to be posted. GRN can be posted either directly against PO or from inbound delivery or from shipment document stages.

The most optimized process would be to post the GRN automatically when shipment document is created and we can control the stage in which GRN to be posted.

This document explains various settings required for posting GRN directly from shipment document once planning stage is completed.

Read more

Tag Auto GRN , Inbound Delivery Processing

Default PR price as PO price
SAP

Business scenario's may warrant defaulting Purchase requisition price in the purchase order. Since this is a very common business requirement , SAP has provided various standard solution. But caution should be exercised when such configuration changes are implemented. This blog explains the various standard and enhancement options available to achieve this requirement. 

Read more

Tag Copy PR price to PO, PO price derivation

Configuring Invoicing List for billing documents
SAP

Invoice list is for generating single invoice document for multiple billing document. This is most common scenario when the customer may request for a consolidated single invoice rather than separate invoices and in addition there may contractual agreement to provide discounts if the sales volume target is reached. In such cases Invoice list is the easy way out.

Read more

Tag Invoice List

Invoice Splitting in Billing Document and Collective Billing
SAP

Invoice split is a process by which  Sales billing documents are split based on some predefined criteria.  This blog explains the basics of Invoice document splitting.

 

Read more

Tag Invoice Split , Billing Document , VBRK

Relative and Absolute import for beginners
Django

Python beginners would have noticied the first line in the python script page or *.py . Its always a Import or From.

Though we would have just copied it from templates or sample codes and started using in our programs , the reality hits us when there is a error message. Most of the time we would get a module not found error. The issue would become more complicated when multiple imports are used.

This document will help you understand the system logic at a higher level which can help you solve the problems. For detailed documentation refer to our reference session for links.

Read more

Tag Import , Relative , Absolute