Sunday, May 31, 2020

Why I should manage master data? (part1)

Because it is used by multiple applications, an error in master data can cause errors in all the applications that used it. For examples, an incorrect address in customer master data might mean orders, bills and marketing literature are all sent to wrong address. Similarly, an incorrect account bank number in account vendor master data the money can sent to other vendor. a career-limiting move for the person who made the mistake.

Even in master data has no error, a challenge to reconcile master data is pretty much confusing, especially from legacy system which customer master, vendor master and material number are separate and manage by different department in one organizations. a few organizations and company have just one set of master data, Items material master can be even harder to reconcile if equivalents parts are purchased with different vendors with different vendors number.

Merging master list can be very difficult, the same spare parts may have different name in database
for example, Seal might appears as Mechanical Seal, Mech-Seal and Mech Seal. Normal database joins and searches will not be able to find these differences. A very sophisticated tool that understand nickname and errors spelling will be required.
And also we have big issue in material master, New parts can be harder to identify for the specification and type if coming with a new equipment that Maintenance cannot be see inside the equipment but They need a spare parts in warehouse. Alternate way is based on brochure specification from the vendor that only mention the Parts number or Serial number. 

For all these reasons, maintaining high-quality, consistent set of master data of your organizations a rapidly becoming a necessity. The systems and process required to maintain this data are known as Master Data Management.



Thursday, May 28, 2020

IT inventory Bea Cukai report integrated with SAP

The requirement applies to Indonesian local government regulation. Incoming goods from outside to Indonesia and outgoing goods deliveries from Indonesia to another country than Indonesia are concerned.

This Report is made under SAP environment without interfacing to the 3rd party software.
And this solution was validated by the customs institution with grade A

Hereby the screenshot of interface report, there are 8 report as mandatory from government that every company should have. refer to regulation PER-09BC_2014


example
#Report 1: Incoming Raw Material (Laporan Pemasukan bahan baku)

#Report 5: Outgoing Finished Product (Laporan Pengeluaran Hasil Product)

#Report 6: Movement Raw Material (Mutasi bahan baku)

Thank You for reading


Monday, November 26, 2018

How to use LSMW (for upload Big data in SAP)

LSMW were used by Masterdata team to upload big data in SAP for time efficiency

It consist many step, Check it out  ..

Step 1: Create Project name
             Setup project name, subproject and object

Step 2: Configuration object atribute
             To define Object type and Import Method
              

Step3: Configuration Source Structures
            Make structure name, let say MATERIAL01
           
 
 Step4: Configuration Source Fields
              Under Structures name, fields name should be define. what mandatory fields name should 
              be fill in the transaction.



Step5: Configuration Structure Relations
             To make relationship between defined source fields with REC

Step6:





































Tuesday, October 16, 2018

How To Create Selection Variant with SE38

Posting kali mengenai penggunaan selection variant untuk Transaksi Code ME55

Ya.. ME55 adalah Collective release untuk approval PR
Permasalahan yang timbul adalah ketika ada beberapa orang yang berhak melakukan aproval
maka SAP menyedikan fitur Selection varian untuk menghindari benturan pada saat melakukan aproval PR

Berikut ini adalah ikon yang akan kita modifikasi

dimana jika kita klik maka akan muncul nama orang yang berhak melakukan release

SE38 for Change or Display selection variant



Friday, September 7, 2018

Cara Vlookup beda sheet



Hal-hal yang kecil seperti ini terkadang Suka lupa hehehe..

step1: buat kolom baru di sheet 1
step2: masukan data diinginkan pada sheet 2
step3: buat rumus di kolom baru pada sheet1 sbb:

=VLOOKUP(A3,Sheet2!$A$3:$B$6437,2)

Terima kasih


Wednesday, September 5, 2018

How to make report design with SQVI



Terkadang kita mendapat tugas dari user atau dari auditor untuk menampilkan report yang belum tersedia di SAP.
Pada materi saya akan memberikan langkah-langkah bagaimana cara membuat query secara cepat dengan menggunakan TCode SQVI

How to Manage user & Role with SUIM

Transaction code SUIM digunakan untuk menampilkan data user yang telah diregistrasi 
Kita bisa melihat Last login pada setiap user, role dan tcode apa saja yang diberikan




Tuesday, August 28, 2018

Panduan Lengkap Tabel Pada Modul SAP MM




How to activated MRP in Purchasing Process




Pada Slide ini menunjukan bahwa PR bisa terbentuk dari beberapa transaksi

Why I should manage master data? (part1)

Because it is used by multiple applications, an error in master data can cause errors in all the applications that used it. For examples, an...