I have a flat file that includes the header and the details in the same row with only a field indicating the number of rows.
Each row contains a complete transaction in one row. I have to load it into structured RFC
TransID, TransDate&Time, <header details>, No_of_products, Procuct1, Qtt1, price1, Product2, Qtt2, price2, .......
It can contain 1 - 15 products.
Is there a simple way of mapping it into a structured data type of header and details ?