Inventory Stock & Transit Position
Dokumentasi spesifikasi teknis dan fungsional Sheet 2: Inventory Stock pada Story SAP Analytics Cloud (SAC) Marketing PT Jhonlin Group.
1. Ringkasan & Ruang Lingkup Sheet
Sheet Inventory Stock & Transit Position difokuskan untuk manajemen rantai pasok dan pemantauan persediaan fisik batubara (Supply Chain & Stockpile Monitoring). Halaman ini menyajikan visibilitas stok batubara mentah (Raw Coal) dan batubara olahan (Crushed Coal) pada terminal pelabuhan PT Dua Samudera Perkasa (DSP), serta memantau posisi persediaan yang sedang dalam perjalanan muat tongkang menuju kapal induk/vessel (Inventory in Transit).
Ruang Lingkup Fasilitas Stockpile DSP:
- Port of Loading:
DS02,DS03,DS06,DS07,DS09. - Storage Location Raw Coal (CO-RC):
DS02/R006s/dDS02/R010,DS03/R012s/dDS03/R015,DS06/R016s/dDS06/R017,DS07/R018s/dDS07/R023,DS09/R024. - Storage Location Crushed Coal (CO-CC / CO-LC):
SP CC GROGOT 1,SP CC BUNATI 1-3,SP CC SRNGA 1-2,SP CC B.AMPAR 1-2.

2. Filter Global Halaman
| Parameter / Dimensi | Sumber Referensi Data | Tipe Tampilan | Sifat Seleksi | Nilai Standar / Keterangan |
|---|---|---|---|---|
| Posting Date | JG_M_S4HLV_ZCSDXX002 - End of Fiscal Period |
Page Filter | Range Date (Opsional) | Cut-off periode pembukuan stok persediaan |
| Material Description | JG_M_S4HLV_ZCSDXX002 - Stock Material |
Page Filter | Multi Selection (Opsional) | Filter jenis batubara (Raw Coal CO-RC, Crushed Coal CO-CC, Loaded Coal CO-LC) |
| Sales Order ID | JG_M_S4HLV_ZCSDXX002 - Sales Order |
Page Filter | Multi Selection (Opsional) | Filter pesanan penjualan terkait alokasi persediaan |
| Ship To Party | JG_M_S4HLV_ZCSDXX002 - Customer |
Page Filter | Multi Selection (Opsional) | Pelanggan penerima kargo batubara |
3. Spesifikasi Rinci Komponen (6 Widget)
3.1 Total Raw Coal DSP - Numeric Point
- Nomor Widget: 1
- Tipe Visualisasi: Numeric Point (KPI Card)
- Measure:
Stock Quantity (Metric Ton) - Filter Port of Loading:
DS02,DS03,DS06,DS07,DS09 - Filter Storage Location:
DS02/R006–DS02/R010,DS03/R012–DS03/R015,DS06/R016–DS06/R017,DS07/R018–DS07/R023,DS09/R024 - Filter Stock Material:
Raw Coal (CO-RC)
3.2 Total Crushed Coal DSP - Numeric Point
- Nomor Widget: 2
- Tipe Visualisasi: Numeric Point (KPI Card)
- Measure:
Stock Quantity (Metric Ton) - Filter Port of Loading:
DS02,DS03,DS06,DS07,DS09 - Filter Storage Location: Stockpile Crusher Grogot 1, Bunati 1-3, Sarangga 1-2, Batu Ampar 1-2
- Filter Stock Material:
Loaded Coal Cargo (CO-LC)&Crushed Coal (CO-CC)
3.3 Distribusi Stok per Lokasi Stockpile (Bar Charts)
Widget 3: Total Raw Coal by Location Stockpile
- Tipe: Bar / Column Chart
- Measure:
Stock Quantity (MT) - Dimensi: Lokasi Stockpile Raw Coal DSP
Widget 4: Total Crushed Coal by Location
- Tipe: Bar / Column Chart
- Measure:
Stock Quantity (MT) - Dimensi: Lokasi Stockpile Crushed Coal DSP
3.4 Monitoring Persediaan Transit (In-Transit by Port of Loading)
Widget 5: Stock Quantity - Table (In-Cell Chart)
- Tujuan: Mengetahui sisa kuantitas batubara yang sedang berada dalam proses alih muat (transshipment) tongkang.
- Formula Calculated Measure: $$\text{Remaining Qty} = \text{Qty Loading Tongkang} - \text{Delivered Qty Vessel}$$
- Logika Pergerakan Barang (SAP Movement Type 309): Dihitung berdasarkan kuantitas transfer material (Movement Type 309) pada plant JG02 dan JG03. Helper didefinisikan per pasangan plant.
Widget 6: Stock Percentage - Table (In-Cell Chart)
- Formula Persentase Sisa Kargo:
$$
% Remaining Qty = (Remaining Qty / Total Qty) × 100%$$ - Formula Total Kargo: $$\text{Total} = \text{Qty Loading Tongkang} + \text{Delivered Qty Vessel} + \text{Remaining Qty}$$
- Formula Persentase Sisa Kargo:
$$
4. Panduan Rekonsiliasi dengan SAP ERP (MM / SD)
- Stok Fisik Gudang/Stockpile: Bandingkan angka pada Widget 1 dan 2 dengan transaksi
MB52(Warehouse Stock) atauMMBE(Stock Overview) pada Storage Location DSP terkait. - Transfer Movement Type 309: Validasi mutasi batubara antar-spesifikasi/status di transaksi
MB51(Material Document List) dengan memfilter Movement Type309pada PlantJG02danJG03.