Add CHANNEL_CODE and CHANNEL_NAME on the SALE_FACTS then modify the query and add table CSHSCM and field CSANBR. Also create new KTR to get the CHANNEL_NAME from the reference table from the server 172.16.11.119. Test and check the data from SALE_FACTS if the extraction was success