Icon

SDO P file generation V4

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 fileThe workflow is separated into 3 portions1st portion: flow to convert edrpoh2nd portion: flow to convert edrpod3rd portion: flow to combine edrpoh and edrpod and write the resultInput:1. edrpoh text file2. edrpod text file3. Material master data in SCIC analytic shared pointOutput1. P file2. PO list report3. Missing sales unit reportNOTE : To start using the flow, config all nodes with RED colored descriptionBatch 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 timeThis flow is created by Somie (jerngklinchan.p@pg.com) on 25 Feb 2020 3rd portion: flow to combine edrpoh and edrpod and write the result V driveto get edrpohV driveto get edrpodextract customercodeextract GCAScodefilter outzero qtychange qtyto number1st detailitem, qty, sales unitChange qtyto integerto removedecimal2nd detailGCAS codecombine 1stand 2nd detail linecombine allGCAS of the POfilter onlyP file columnfilter onlyP file columnCombine all POFile path to write P file toconvert to stringNode 365write P filecreate executiondate&timefilter onlyP file columnCombineheader and detailchange qtyto stringadd space to qty fieldNode 373Node 375Node 588readedrpohextract customercodeextract POadd space neededfor PO numberfieldextractsupplier codeextractorder dateextractdelivery dateStrip POnumberextractTimeExtract WeightExtractVolumeNode 632Node 633extract qtystrip the 1st P filestrip the 1st P file List Files(deprecated) List Files(deprecated) String Manipulation String Manipulation Row Filter String To Number(deprecated) String Manipulation Double To Int String Manipulation Concatenate (Optionalin) (deprecated) Loop End(deprecated) Column Filter Column Filter Loop End(deprecated) String Manipulation Date&Time to String Table Row to Variable(deprecated) CSV Writer(deprecated) Create Date&TimeRange Column Filter Concatenate (Optionalin) (deprecated) Number To String(deprecated) String Manipulation Table Row To VariableLoop Start (deprecated) Table Row To VariableLoop Start (deprecated) EDRPOH conversion File Reader(deprecated) String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation ConstantValue Column File Reader String Manipulation String Manipulation String Manipulation 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 fileThe workflow is separated into 3 portions1st portion: flow to convert edrpoh2nd portion: flow to convert edrpod3rd portion: flow to combine edrpoh and edrpod and write the resultInput:1. edrpoh text file2. edrpod text file3. Material master data in SCIC analytic shared pointOutput1. P file2. PO list report3. Missing sales unit reportNOTE : To start using the flow, config all nodes with RED colored descriptionBatch 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 timeThis flow is created by Somie (jerngklinchan.p@pg.com) on 25 Feb 2020 3rd portion: flow to combine edrpoh and edrpod and write the result V driveto get edrpohV driveto get edrpodextract customercodeextract GCAScodefilter outzero qtychange qtyto number1st detailitem, qty, sales unitChange qtyto integerto removedecimal2nd detailGCAS codecombine 1stand 2nd detail linecombine allGCAS of the POfilter onlyP file columnfilter onlyP file columnCombine all POFile path to write P file toconvert to stringNode 365write P filecreate executiondate&timefilter onlyP file columnCombineheader and detailchange qtyto stringadd space to qty fieldNode 373Node 375Node 588readedrpohextract customercodeextract POadd space neededfor PO numberfieldextractsupplier codeextractorder dateextractdelivery dateStrip POnumberextractTimeExtract WeightExtractVolumeNode 632Node 633extract qtystrip the 1st P filestrip the 1st P file List Files(deprecated) List Files(deprecated) String Manipulation String Manipulation Row Filter String To Number(deprecated) String Manipulation Double To Int String Manipulation Concatenate (Optionalin) (deprecated) Loop End(deprecated) Column Filter Column Filter Loop End(deprecated) String Manipulation Date&Time to String Table Row to Variable(deprecated) CSV Writer(deprecated) Create Date&TimeRange Column Filter Concatenate (Optionalin) (deprecated) Number To String(deprecated) String Manipulation Table Row To VariableLoop Start (deprecated) Table Row To VariableLoop Start (deprecated) EDRPOH conversion File Reader(deprecated) String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation ConstantValue Column File Reader String Manipulation String Manipulation String Manipulation

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: jerngklinchan.p
Created at: 2020-02-13
On NodePit since: 2022-08-25
Last update: 2024-05-01
Created with KNIME version: v4.6.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!