Generating Idoc for Singapore
SDO IDOC P file generation
This workflow is to
1. Replace STAR access tool in converting SDO order text file edrpoh (header) and edrpod (detail) into IDOC file (P file).
2. Mass convertion of edrpoh and edrpod into single IDOC file
The workflow is separated into 3 portions
1st portion: flow to convert edrpoh
2nd portion: flow to convert edrpod
3rd portion: flow to combine edrpoh and edrpod and write the result
Input:
1. edrpoh text file
2. edrpod text file
3. Material master data in SCIC analytic shared point
Output
1. P file
2. PO list report
3. Missing sales unit report
NOTE :
To start using the flow, config all nodes with RED colored description
Batch job to pickup PO and send to SAP will run every 15 mins of every hours, XX:15, XX30, XX:45, XX:60. Please run flow around 5 mins before batchjob run time
This flow is created by Somie (jerngklinchan.p@pg.com) on 25 Feb 2020
Nodes
- String Manipulation35 ×
- GroupBy16 ×
- Concatenate (Optional in)8 ×
- Column Filter3 ×
- Loop End2 ×
- Show all 24 nodes
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Data Generation
- FeatureKNIME Javasnippet
- FeatureLhasa public plugin