I do have an extract excel file generated from oracle program coming to my BODS Job Server location.
The requirement is to migrate data to SAP ECC based on mapping and validation requirement provided in a sheet.
Most of the validations say “validation against SAP table ABC. If the attribute is not valid, write to log and stop the job” etc.
I really need the best practices way to design such a job.
Please advise better option.
I do have BPFDM jobs SAP Market place. The job has map, validation and enrich process in each flows. The validation has look-ups, mandatory and format sections.
I hope these validations are as per the customers requrements
As per SAP AIO jobs we have mapping data flow Where we are building the business rules , Validation data flow where we apply the validation like mandatory , format and look up. Here lookup we are checking against SAP check tables only. Next data flow enrichment means cross reference values implementation. It is also based on SAP values. Here one thing is missing after enrichment we are doing validation against SAP values . If you want you can keep validation against SAP in one data flow after enrichment dataflow. Here why SAP didn’t provide validation after enrichment because we are using migration services and we know SAP values in the migration services and we can map there for the all SAP values . Normal case we miss most of the legacy values while preparing the x refs . We need to capture the missing one using validation.