hi
I need help for the following scenario :
PI will be receivng text files where the number of line items will be of the order say 2800 line items per file.
Each file is a document posting(IDOC) , but the condition is that in SAP FI the number of records that can be posted are only 999 , so the fix is that after every 998 records read by SAP PI a dummy record is to be inserted and an IDOC is posted and for the next IDOC(next 998 records) the first line item is again a dummy record which is the reversal of the last line item inserted to balance the credit and debits.
a) How can PI read the file in such a way that the first 998 line items can be posted as one idoc and the remaining line items in the next idoc etc
b)Also the file to be read, has to be first sorted on date ,ie each line item with the same date field have to be clubbed and then the 998 split has to be applied.
Kindly help in suggesting the approach , if it requires a UDF ,,can some body please provide the code for the same ?
thanks
Rohan