Scribd
Upload
10 views27 pages

Automated Delivery Process Workflow

The document outlines the automated delivery process flow, including mass delivery receipt (DR) creation, picklist planning, and truck assignment. It details various system settings and target tables involved in these processes, as well as the flow for picklist printing and confirmation. The document serves as a comprehensive guide for understanding the logistics and data management within the delivery automation system.

Uploaded by

Darwin Ramirez Simplicio
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
10 views27 pages

Automated Delivery Process Workflow

The document outlines the automated delivery process flow, including mass delivery receipt (DR) creation, picklist planning, and truck assignment. It details various system settings and target tables involved in these processes, as well as the flow for picklist printing and confirmation. The document serves as a comprehensive guide for understanding the logistics and data management within the delivery automation system.

Uploaded by

Darwin Ramirez Simplicio
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Delivery Process Automation

System Flow
Automated Delivery Process Flow
A

START
Sales Order Batch Update DR

Mass DR Creation DR/GP with


PGI and SI can Shipment Creation
allow to print * If error occurs during
DR Cancellation preparation of
Shipment and printing
DR & Gate pass
Route Delivery Printing
Planning DR
Automated and
GP
Manual Picking Prepare Document
PL Cancellation
for CM
Validate
Truck and Loading DR before loading
Bay Assignment
Assigned Return Stock to
Picklist Warehouse
Pickling Loads Items
Picklist Printing
Preparation
Picklist
Confirmed
Picklist
Picklist Closing
Picklist Confirmation

CLOSE

Distribution Warehouse Audit


Table Definition
Table Name Description
SOHeader Sales Order Header
SODetails Sales Order Details
DRHeader Delivery Receipts Header
DRDetails Delivery Receipts Details
SIHeader Sales Invoice Header
SIDetails Sales Invoice Details
MatBasicData General Material Data
MatDescription Material Description
CustGenData General Data in Customer Master
CustSalesData Customer Master Sales Data
tDeliveryRouteCodes Route Master Data
SysSettings System Settings Table
tblSalesPriceList Customer Price List type
tblSalesPriceListMix Price List grouping
tblwinN_DeliveryReceipts Mass DR Creation Logs
tblDistribution_PicklistHeader Picklist Header
Table Definition
Table Name Description
tblDistribution_PicklistDRDetails Picklist DR Details
tblDistribution_PicklistDetails Picklist Item Details
tblDistribution_PicklistDRs Picklist Confirmed picked quantity for Batched Update
tblDistribution_RouteDeliveryInfo Route Delivery Info
tblDistribution_AccountRule Active Sales Price List Master
tblDistribution_DestinationRate Destination Rate per Truck type
tblDistribution_Truckers General Data in Truck Master
tblDistribution_NestPipeHeader Pipe Nesting Header Master
tblDistribution_NestPipeDetails Pipe Nesting Details Master
tblDistribution_LoadingBayBatch Loading Bay and Batch Master
tblDist_DeliveryRouteSched Route Delivery Schedule Master
tblDistribution_RoutePlanHeader ADS2 Route Plan Header Logs
tblDistribution_RoutePlanDetails ADS Route Plan Details Logs
tblDistribution_SplitDRLogs Route Plan split DR Logs
tblDistribution_GoodsMovement Picklist Goods Movement
Table Definition
Table Name Description
tblSAP_VTTK Shipment Header
tblSAP_VTTP Shipment Item
tblSAP_VBSS Collective Processing: Sales Documents
tblSAP_VBSK Collective Processing for a Sales Document Header
tblSAP_VBFA Sales Document Flow
tblSAP_MARM Units of Measure for Material
tblDistributionReasonForCancellation Setup table for cancellation reason
tblDistribution_LoadingTruckBatch Setup table for truck type allowed in loading bay
tblDistribution_LoadingSchedule Setup table for DU preparation and truck waiting time
Simulated Picklist DR For Picking
tblDistribution_DRForPicking
Picklist Details DR Cancellation Logs
tblDistribution_DRCancellation
DR Details Cancellation Logs
DRDetailsCancellation
Stocked Out Header
tblDistribution_StockOutHeader
Stocked Out Details
tblDistribution_StockOutDetails
Table Definition
Table Name Description
Simulated Picklist Route Plan
tblDistribution_RoutePlan
Truckers Details
tblDistribution_TruckersDetails
Reason for Cancellation
tblDistributionReasonForCancellation
Picklist DR Deleted Detials
tblDistribution_PicklistDRDelDetails
Material Inventory
tblDistribution_MatInventory
Material Sloc Type
tblDistribution_MaterialSlocType
Loading Truck per Batch
tblDistribution_LoadingTruckBatch
Loading Schedule
tblDistribution_LoadingSchedule
Loading Bay
tblDistribution_LoadingBay
Assigned Truck Details
tblDistribution_AssignedTruckDetails
Assigned Sloc Details
tblDistribution_AssignedSlocDetails
DR Printing Logs
tblDRPrintByUser
Picklist Status History
tblDistributionPLStatusHistory
Mass DR Creation Flow
NDESS SAP

START

Sales Order
Creation

SO Release

Validate Sales
Selected SO Mass DR Creation
Cut-off

Saved created DR to
NDESS Created DR

Display
Created DR

END

Sales CCD Distribution


Mass DR Creation Target Tables per Process
Process Source Affected NDESS Tables
Execute FM: ZRFC_SD_VL10A Nothing
SAP Table: VBAK, VBAP, VBPA

Background FM: SAP Table: VBAK, LIKP, LIPS


ZRFC_SHP_VL10_DELIVERY_CREATE
NDESS Table: DRHeader, DRDetails,
tblwinN_DeliveryReceipts

Display Output FM: Nothing


ZRFC_SHP_VL10_DELIVERY_CREATE
Struc. Table: t_CreatedDR
Automated Picklist Planning Flow
NDESS SAP

START A

Validate Sales If PL Selected TranID


w/ or w/o Route Save Picklist
Data Retrieval Creation
Plan

Validate ADS
Set Planning Rule Created PL
Process

Validate Planning
Rule PL Status if w/
Loading Bay &
Batch: Assigned, if
w/o Created
Start Processing

Saved Picklist

Display
A
Picklist

END

Distribution
Manual Picklist Planning Flow
NDESS SAP

START A

If w/o
Validate Sales
Route
Data Retrieval
Plan

Validate ADS Display


Selected DR Created Picklist
Process Picklist

Validate Planning PL Status Created PL


Rule Created

Start Processing Saved Picklist

END

Distribution
System Settings
Code Description
ADS CURRENT USER ADS Process Current User
ADS PROCESSING N Y/N ADS Processing Status
ADS START PROCESSING N Y/N Activate Simulation
ADS2 POST ALL W/ ROUTE PLAN Y Y/N Activate Posting of All W/ Route Plan
ADS2 POST W/O ROUTE PLAN Y Y/N Activate Posting of ADS2 W/O Route Plan
ADS2 REGION FOR MANUAL PICK Set of Region for Manual Picking
(NCR,PCKUP,R1,R2,R3,R4,R5)
ADS2 SAP SYNC ISACTIVE N Y/N Active SAP Sync before processing
ADS2-2ND-PASS-ACTIVE N Y/N ACTIVATES 2ND PASS FOR LOADING SIMULATION
ADS2-BY-DR-AGE N Y/N RETRIEVE CUSTOMERS BY DRDATE
ADS2-BY-SO-AGE N Y/N RETRIEVE CUSTOMERS BY SODATE
ADS2-DEL6W-BY-VALUE 0 ADS2-%-6W-DELIVER-BY-VALUE
ADS2-DELIVER-BY-VALUE 80 ADS2-%-TO-DELIVER-BY-VALUE
ADS2-OS-75% 1 AUTOPICK OS WITH CBM >= 75%
ADS2-R4/R5-TRUCKBYVALUE 0 R4/R5: USE 1X40 IF TRUCK VAL > 500K
System Settings
Code Description
RETRIEVE INVENTORY SITUATION N Y/N Switch to determine if retrieving is ongoing. N means
not retrieving, Y means retrieving is ongoing
SALES RETRIEVAL N Y/N Value to determine if Sales retrieval is ongoing
SAP SYNC CURRENT USER SAP Sync Current User
Automated Delivery Planning Target Tables per Process
Process Source Affected NDESS Tables
Process Stored Procedure: tblDistribution_DRForPicking
spDistribution_DRforPickingV2 & tblDistribution_RoutePlan
spReportDailyActualSalesV5 TBLSIMULATION

NDESS Table:
DRHeader, DRDetails, SOHeader, SODetails,
MatBasicData, MatDescription,
tDeliveryRouteCodes, CustSalesData,
CustGenData, tblSAP_VBSS, tblSAP_VBSK,
tblSAP_MARM, SysSettings,
tblDistribution_PicklistHeader,
tblDistribution_PicklistDRDetails,
tblDistribution_RouteDeliveryInfo,
tblDistribution_AccountRule,
tblDistribution_DestinationRate,
tblDistribution_Truckers,
tblDistribution_NestPipeHeader,
tblDistribution_NestPipeDetails,
tblDistribution_LoadingBayBatch,
tblDist_DeliveryRouteSched,
tblSalesPriceList, tblSalesPriceListMix
Automated Delivery Planning Target Tables per Process
Process Source Affected NDESS Tables
Refresh Stored Procedure:
Display Summary spDistribution_DRforPicking = 15
NDESS Table
tblDistribution_DRForPicking,
tblDistribution_RoutePlan,
tDeliveryRouteCodes, tblSalesPriceList

Refresh Stored Procedure:


Display Routes spDistribution_DRforPicking = 16
NDESS Table
tblDistribution_DRForPicking,
tblDistribution_RoutePlan,
tDeliveryRouteCodes, tblSalesPriceList

Refresh Stored Procedure:


Display Deliveries spDistribution_DRforPicking = 34
NDESS Table
tblDistribution_DRForPicking,
tblDistribution_RoutePlan, CustGenData,
tDeliveryRouteCodes, tblSalesPriceList
Automated Delivery Planning Target Tables per Process
Process Source Affected NDESS Tables
Refresh Stored Procedure:
Display Ship-To spDistribution_DRforPicking = 8
NDESS Table
tblDistribution_DRforPicking,
CustGenData

Truck Rate Stored Procedure:


Display spDistribution_TruckMaintenance = 1
NDESS Table
tblDistribution_DestinationRate
tblDistribution_Truckers
tDeliveryRouteCodes

Truck Rate Stored Procedure:


Save spDistribution_TruckMaintenance = 2
NDESS Table
tblDistribution_DestinationRate
tblDistribution_DestinationRateLogs
Automated Delivery Planning Target Tables per Process
Process Source Affected NDESS Tables
Material Nesting Stored Procedure:
Display spDistribution_NestingMatData = 1 to 4
NDESS Table
MatDescription
tblDistribution_NestPipeHeader
tblDistribution_NestPipeDetails

Material Nesting Stored Procedure:


Save spDistribution_NestingMatData = 5 & 6
NDESS Table
tblDistribution_NestPipeHeader
tblDistribution_NestPipeDetails

Save Picklist Stored Procedure: Function Module: ZRFC_SPLITDELIVERY


Split DR spDistribution_DRforPicking = 40, 41
and 43 SAP Table: LIKP & LIPS
NDESS Table: Stored Procedure:
tblDistribution_DRForPicking, spDistribution_DRforPicking = 42
tblDistribution_RoutePlan
NDESS Table: DRHeader & DRDetails
Automated Delivery Planning Target Tables per Process
Process Source Affected NDESS Tables
Create Picklist Stored Procedure: Function Module:
spDistribution_DRforPicking = 11 ZRFC_CREATE_PICKLIST
NDESS Table: SAP Table: VBSK & VBSS
tblDistribution_DRForPicking,
tblDistribution_RoutePlan Stored Procedure:
spDistribution_CreatePicklistV2 = 1 & 2
NDESS Table:
tblDistribution_PicklistHeader,
tblDistribution_PicklistDRDetails,
tblDistribution_AssignedSlocDetails,
tblDistribution_SplitDRLogs,
tblDistribution_RoutePlanHeader,
tblDistribution_RoutePlanDetails,
tblSAP_VBSK, tblSAP_VBSS
Truck and Loading Bay Assignment Flow
NDESS SAP
Display START
Picklist

Batch, Loading Bay *PL Status Tag as


Is Assigned
A B C and Date A
Assigned
Assignment

Is w/ Assigned Truck B
Truck

Is Truck
Confirm Truck C
Arrived

*PL Status tag as


Is PL
Picklist Cancellation D Cancelled
Cancel

Validate Picklist, Download SI, GP


Picklist Closing
DR, SI and GP And Material Doc.

Send Email DR, SI and GP


D Depart Trucks
Notification Logs

*PL Status Tag as


END Closed

Distribution
Truck and Loading Bay Assignment Target Tables per Process
Process Source Affected NDESS Tables
Display Picklist Stored Procedure:
Documents spDistributionPicklistProcess = 1
NDESS Table
tblDistribution_PicklistHeader,
tblDistribution_PicklistDRDetails
tblSAP_VBSS, tblSAP_VBSK

Assign Loading Stored Procedure: Stored Procedure:


Bay, Batch and spDistributionPicklistProcess = 10 spDistributionPicklistProcess = 5
Date
NDESS table NDESS Table
tblDistribution_LoadingSchedule tblDistribution_PicklistHeader
tblDistribution_PicklistDetails
tblDistribution_AssignedSlocDetails

Truck Assignment Stored Procedure: Stored Procedure:


spDistributionPicklistProcess = 2 spDistributionPicklistProcess = 3
NDESS Table NDESS Table
tblDistribution_TruckersDetails tblDistribution_PicklistHeader
tblDistribution_AssignedSlocDetails
Truck and Loading Bay Assignment Target Tables per Process
Process Source Affected NDESS Tables
Confirm Truck Stored Procedure: Stored Procedure:
spDistributionPicklistProcess = 1 spDistributionPicklistProcess = 17
NDESS Table NDESS Table
tblDistribution_PicklistHeader, tblDistribution_PicklistHeader,
tblDistribution_PicklistDRDetails
tblSAP_VBSS, tblSAP_VBSK

Truck Stored Procedure:


Maintenance spDistributionPicklistProcess = 16
tblDistribution_TruckDetails
tblwinN_auditTrail

Cancel Picklist Stored Procedure: Stored Procedure:


spDistributionPicklistProcess = 18 If PL is Created or Assigned
spDistributionPicklistProcess = 19
NDESS Table
tblDistribution_PicklistHeader NDESS Table
tblDistribution_PicklistHeader
Truck and Loading Bay Assignment Target Tables per Process
Process Source Affected NDESS Tables
Cancel/Close Stored Procedure: Stored Procedure:
Picklist spDistributionPicklistProcess = 18 If PL is Picking, Transfer or Loading
spDistributionPicklistProcess = 20 - 22
NDESS Table
tblDistribution_PicklistHeader Function Module
ZGET_MATERIAL_INVENTORY
NDESS Table
tblDistribution_PicklistHeader
tblDistribution_MatInventory

Truck Depart Stored Procedure: Stored Procedure:


spDistributionPicklistProcess = 18 spDistributionPicklistProcess = 23

NDESS Table Function Module


tblDistribution_PicklistHeader ZRFC_LOGS_DOWNLOADER
NDESS Table
tblDistribution_PicklistHeader,
tblSAP_VBFA, tblSAP_VTTK,
tblSAP_VTTP
Picklist Printing and Confirmation Flow
NDESS SAP

START
With
A Picked Qty Stocks

Display Assigned
Picklist Picklist

Transfer Posting

Print Picklist

Mat. Document
Return Message
Picklist with
Picking Confirm truck
Preparation

Blocked Stock

Picklist Confirmation Transfer

A END

Warehouse
Picklist Printing and Confirmation Target Tables per Process
Process Source Affected NDESS Tables
Refresh Stored Procedure:
Picklist Printing spWarehousePrintingConfirm = 6, 7 & 8
NDESS Table
tblDistribution_PicklistHeader
tblDistribution_LoadingBay
tblDistribution_PicklistDetails

Print Picklist Stored Procedure: Stored Procedure:


spWarehousePrintingConfirm = 11 spWarehousePrintingConfirm = 11
NDESS Table NDESS Table
tblDistribution_PicklistHeader tblDistribution_PicklistHeader
tblDistribution_PicklistDetails tblDistribution_PicklistDetails
tlbDistribution_LoadingBay
tblStorLoc, tblSAP_VBSK

Refresh Stored Procedure:


Picklist spWarehousePrintingConfirm =9,10 12
Confirmation
NDESS Table
tblDistribution_PicklistHeader
tblDistribution_PicklistDetails
tlbDistribution_LoadingBay
tblStorLoc, tblSAP_VBSK
Picklist Printing and Confirmation Target Tables per Process
Process Source Affected NDESS Tables
Picklist Function Module:
Confirmation ZRFC_Transfer_Posting_V2
Stored Procedure:
spMIGO_TransferMovements = 5
spWarehousePrintingConfirm = 15

NDESS Table
tblMIGO_MaterialMovement
tblDistribution_PicklistDRS
tblDistribution_PicklistHeader
tblDistribution_PicklistDetails
Batch Update DRs Flow
NDESS SAP

START

Display PL
Status
Loading

Confirm Pick Qty per DR pick qty and


Post to SAP DR Changed
DR SLoc

If
Material Return Message
Blocked

END

Distribution
Batch Update DRs Target Tables per Process
Process Source Affected NDESS Tables
Display PL Status Stored Procedure:
Loading spWarehousePrintingConfirmation = 16,
17 & 22

NDESS Table:
tblDistribution_PicklistHeader
tblDistribution_PicklistDetails
tblDistribution_PicklistDRDetails
tblDistribution_LoadingBay
tblDistribution_GoodsMovement
tblDistribution_PicklistDRs
tblSAP_VBSK, CustGenData

Confirm Picked Stored Procedure: NDESS Table


Quantity spWarehousePrintingConfirmation = 22 tblDistribution_PicklistDRs
Post to SAP Function Module: ZRFC_DRBatchUpdate NDESS Table
tblDistribution_PicklistHeader
tblDistribution_PicklistDRs
The End.

You might also like