How to Design a job
Posted: Thu Oct 04, 2007 7:32 am
I'm new to DataStage and have a how to question. I need to post some Invoice information to SAP using IDOCs. I have two sequential files. One with Invoice header information and the other with Invoice line items, freight items and tax items for an invoice. I need to determine if the Invoice has a freight item or a tax item to determine how to value a field.
Is there a way to read all the line items for a particular invoice first to determine if that invoice has a tax record or a freight record? Can this be accomplished using stage variable?
Is there a way to read all the line items for a particular invoice first to determine if that invoice has a tax record or a freight record? Can this be accomplished using stage variable?