Skip to content

samirsaci/sap-automation-po

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Orders Creation Automation with SAP for Retail Using VB 🏪

Automatically creating Purchase Order(s) based on information stored in an Excel spreadsheet.

What is a Purchase Order (PO)?

In SAP Retail, a purchase order is a commercial document indicating types, quantities, agreed prices and delivery information (locations, time) for products or services.

Youtube Video

Find in the link below a short animated explained video to understand the concept behind this solution

Explainer Video Link

Scenario

You want to order 10 Pcs of an article (SAP Code: 145654789 ) at the agreed price of 200$ to be delivered 20.09.2020 in WH01 by Supplier XXX (Vendor Code: 15487). You are working in a purchase organization (Code: PORG ) of Retail Company (Code: RTCP) and you’re part of the purchase group (Code: PRGP).

How to do PO Creation in SAP?

ME21N transaction can be used to operate PO Creation

Article

In this Article, we will build a VBA script to automate PO creation in SAP.

Code

This repository code you will find all the code used to explain the concepts presented in the article.

About me 🤓

Senior Supply Chain and Data Science consultant with international experience working on Logistics and Transportation operations.
For consulting or advising on analytics and sustainable supply chain transformation, feel free to contact me via Logigreen Consulting. \

Please have a look at my personal blog: Personal Website