Skip to main content

Posts

Fetch partner details based on the EWM delivery

Below is the logic to fetch partner details based on the EWM delivery order Pass delivery document number into table Delivery header ( /SCDL/DB_PROCH_O) and fetch document ID Pass the document ID ( DOCID) into table (SCDL/DB_BPLOC) and fetch the partner number ( Party No) Pass the party number into KUNNR of KNA1 and fetch the customer details ***************************************************************************** Pass PARTNERTO_ID of table Delivery header ( /SCDL/DB_PROCH_O)  and pass it into CVI_CUST_LINK and fetch customer number Pass Customer number into table BUT020 to fetch the ADDRNUMBER Pass ADDRNUMBER into table ADRC to fetch address details  *******************************************************************************

Logic to fetch supply chain unit address

 Below is the logic to fetch the supply chain unit (SCU) address : Pass the warehouse ID ( Location ID) from the /SCDL/DB_PROCH_O ( Delivery header ) into table /SCWM/T300_MD (Assignments: Warehouse Number/Business Partner) and fetch SCU  Pass the SCU into table BUT020 and fetch the ADDRNUMBER Pass the  ADDRNUMBER into table ADRC to fetch the address 

EWM commonly used tables and FM's

 /SCDL/DB_DLVH_O - Outbound Delivery Header  /SCDL/DB_DLVI_O - Outbound Delivery Item /SCDL/DB_PROCH_O - Outbound Delivery Order Header /SCDL/DB_PROCI_O - Outbound Delivery Order Item /SCDL/DB_REFDOC - Reference /SCDL/DB_BPLOC - Partner/Location /SCDL/DB_PROCH_P - Production Material  Request  Header /SCDL/DB_PROCH_I -  Inbound Delivery: Header /SCDL/DB_PROCI_I -  Inbound Delivery: Item /SCWM/ORDIM_O - Warehouse Tasks Open /SCWM/ORDIM_C - Warehouse Tasks Confirmed /SCWM/DB_ITEMWT - Warehouse Tasks for Delivery Item PPFTTRIGG - PPF: Actions /SCWM/HUHDR - Handling unit header /SCWM/GMHUITM  - Handling Unit Item /SCWM/TU_DLV - Assignment of Deliveries and HUs to Transportation Units T307 - Storage Unit Types Below are the commonly used FM's /SCWM/PACK_UNPACK /SCWM/HUHDR_CREATE - Create HU Header /SCWM/DIFF_HUITM_CHANGE - LOCAL: Change HUs on Difference Analyzer /SCWM/PPF_POST_GM - Post PPF Goods Movement in BACKGROUND TASK