End to End Data load flow for POS data loading in DSiM
In order to proceed further on POS data loading in DSiM , we need to look at the configuration settings required for POS data loading, I am giving step by step procedure to make it easy.
1 ) Make configuration settings for POS data load, here we need to think about source of data and it could be either BODS or Flat files, if you want to load data from BODS source , then configuration settings would be different compare to flat file source
In DSiM external data will come from Retailers in flat files and Internal data maintained by manufacturer in his ECC system, we need to map internal data with external data in Harmonization stage in DSiM
In SPRO, Demand data foundation , in data upload, we need to make sure settings are correct for the following.
General settings: Here normally , we configure Data upload jobs ( I.e control job, etc
Data Delivery agreement
General settings: We normally follows RDS documents (Matrix excel sheet )
Data Delivery Agreement (DDAR) : We need to create seperate Data delivery agreements for each scenario ( I.e POS data load)
File path : In order to initiate data load from flat files, first we need to upload CSV files into application server and user should have read and write access to these files. Here, we need to maintain folders as Inbound, Process & Archive , follow same case sensitive you maintained in General settings in SPRO.
Initially , we paste files to Inbound folder and while processing files will be moved to Process folder, then it will moved Archived once process is completed.
In SPRO, we need to assign physical path of files ( where these files are exists), such that system can read from that folder while processing.
Note : Your physical path ( maintained using Tcode : FILE) and your AL11 path should be in same case.
I am planing to upload document with detailed steps on POS data loading , please refer to PDF document which will be available in few days.