I have a tricky problem and I think someone might be able to help with this. I have a file with 49,755 records and I want to post files. But SAP journal allows a max of 999 lines to load, so I will have to split this one file into many files. Following are the requirements to load the journal:
The files should be split by Fiscal period (FIS_Period column and we have 1 to 3 periods).
In each Fiscal period, we have many records, so these will split further based on 998 lines in each file.
We should have the last line entry which makes the total to 0. e.g if the SUM of all [Amount] Column in one file is 10,000 then we should have the last line as below. The reason is that the total of the journal should be 0.
How you are posting the data to SAP ? Is it manual or Automation ?
Here multiple tables are dynamic, number of tables depends on Period and number of records.
As per my knowledge we can’t create tables dynamically, The only way we can create multiple tables in one shot is selecting from Data Source.
I’ve created a column Files, you can create multiple tables MANUALLY by coping the query and apply filter on this filed.
Thank you so much for taking time to provide this solution. Yes, it would be manual load and this solution seems perfectly fine to me. I will try with team to upload journal and hopefully will not face any issue.
