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 ×
- RowID2 ×
- Sorter2 ×
- CSV Writer1 ×
- Constant Value Column1 ×
- Counter Generation1 ×
- Create Date&Time Range1 ×
- Date&Time to String1 ×
- Double To Int1 ×
- File Reader1 ×
- File Reader1 ×
- List Files1 ×
- List Files/Folders1 ×
- Number To String1 ×
- Remove Empty Rows1 ×
- Row Filter1 ×
- String To Number1 ×
- Table Row to Variable Loop Start1 ×
- Table Row To Variable Loop Start1 ×
- Table Row to Variable1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Data Generation
- FeatureKNIME Javasnippet
- FeatureLhasa public plugin