DSXchange

The file will be scp'd to the DataStage Server from an outside vendor. DataStage is on a Unix server. I don't think the split command would work for me because it would split invoice header lines from there line items.

There is a limitation of 999 line items while loading data in SAP for invoices and journal entries. This is a SAP limitation. We are asked to split an invoice after we reach 950 lines to avoid the 999 line limit in SAP. I have two source files: 1. Invoice Header File 2. Line Items File Keys to join ...

That worked! :D

Thanks

Hi, We have an input file in the format: Col1 Col2 Col3 A B aaa A B bbb A B ccc A B ddd A B eee C D fff E F ggg E F hhh E F iii E F jjj We have to split the records into 2 files when the number of records based on the key (Col1, Col2) is greater than or equal to 3. So, the requirement is to have 2 o...

Would I use the ABAP extract stage to build the lookup locally to my job?

I'm working with a test version of the R/3 PACKs and I'm trying to load some data into SAP using an IDOC. One of the fields that are required to load the IDOC is not available from the source but the field is required for the load of the IDoc. The field I need is available on the target SAP system. ...

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 fr...