Posts

Aplikasi Web Inventory Management

Image
Pada   postingan ini saya akan share aplikasi Inventory Management berbasi web ( php - MySQL ). Pada aplikasi ini terdapat 4 kelompok Menu yaitu Master Data, Transaction, Reports, dan Settings. Menu Master Data pada menu master data ini terdapat 4 sub menu seperti berikut : Menu Transaction pada menu transaction terdapat 9 sub menu seperti dibawah ini : Menu Reports menu reports terdapat sub menu seperti berikut : Menu Settings menu setting terdiri dari sub menu berikut : Penjelasan dari setiap Menu : pertama saya akan memberikan penjelasan melalui menu settings, karena sebelum menggunakan aplikasi ini harus dilakukan beberapa pengaturan agar bisa digunakan : Settings 1. Menu Data User menu ini untuk menyimpan data user login user. 2. Role menu role ini digunakan untuk membuat data Role, dimana didalam role ini akan diisikan menu-menu apa saja yang bisa diakses serta activity-nya (Read, Insert, Update, Delete), dan role ini akan diberikan ke user tertentu yang artinya user yang men...

SAP ABAP - CDS View Sales Order Characteristic

 @AbapCatalog.sqlViewName: 'ZVIBINCHAR' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #CHECK @ClientHandling.type: #CLIENT_DEPENDENT @EndUserText.label: 'Sales Order Characteristic From IBIN' define view ZCDS_IBINVAL as select from ibin     left outer join vbap on ibin.instance = vbap.cuobj     left outer join ibinvalues on ibin.in_recno = ibinvalues.in_recno and ibin.mandt = ibinvalues.mandt     left outer join ibsymbol on ibinvalues.symbol_id = ibsymbol.symbol_id and ibsymbol.mandt = ibinvalues.mandt     left outer join cabn on ibsymbol.atinn = cabn.atinn and cabn.mandt = ibsymbol.mandt     left outer join cawn on cawn.atinn  = ibsymbol.atinn and cawn.atwrt = ibsymbol.atwrt     left outer join cawnt on cawn.atinn = cawnt.atinn and cawn.atzhl = cawnt.atzhl     left outer join cabnt on cabn.atinn = cabnt.atinn and cabnt.spras = $session.system_lan...

SAP ABAP - CDS View Batch Characteristic Value

Image
  @AbapCatalog.sqlViewName: 'ZVBATCHCHAR' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'CDS View Batch Characteristic Value' define view ZCDS_BATCH_CHAR_VALUE as select from inob as a inner join ausp as b  on a.cuobj = b.objek left outer join cabnt as c on c.atinn = b.atinn left outer join cawnt as d on b.atinn = d.atinn and b.atzhl = right(d.atzhl, 3) {     b.objek as auspObjek,     a.objek as obj,     a.obtab,     b.klart,     substring(a.objek, 1, 40) as Material,     substring(a.objek, 41, 50) as Batch,     b.atinn,     c.atbez,     b.atzhl,     b.atwrt,     d.atwtb,     b.atflv,     b.date_from,     b.dec_value_from } where a.obtab = 'MCH1' and a.klart = '023' and c.spras = 'E'

SAP ABAP - Custom MRP Report

Image
Main Program *&---------------------------------------------------------------------* *& Report ZRPP003 *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT  zrpp003 . TABLES  :  marc ,  mara ,  mdlv . INCLUDE  zrpp003_01 .  "Structure & Selection INCLUDE  zrpp003_02 .  "Logic INCLUDE  zrpp003_03 .  "Alv START-OF-SELECTION .    IF  p_toper < p_bulan .      MESSAGE  'Invalid period'  TYPE  'I'  DISPLAY  LIKE  'E' .      EXIT .    ENDIF .    PERFORM  setfieldcat .    PERFORM  generate_structure .    PERFORM  get_data2 .    PERFORM  to_alv_slis_event_exit . Include ZRPP003_01 *&----------------------------------------...