AnsweredAssumed Answered

How to map flat file with multiple record types on one long line?

Question asked by venkatesh.rupanagudi080702 on Nov 13, 2016
Latest reply on Nov 16, 2016 by venkatesh.rupanagudi080702

Hello,

 

I have a Flat file , it is PO number from Customer . I have attached the file. Basically the file has to be mapped into IDOC in the output to SAP. The Input file has following types of multiple record type formats. Record Type A , Record Type B ,Record Type D.  Record Type A is header , Record Type B has PO info and Record Type D is details.  Now 

for each PO , there will be 1 Record Type A Header , one Record Type B's (PO number )  and each Record Type B will have one  1 Record Type D. I need to split the file into multiple files with Record Type A , B and D. In some cases there are Record Type A and Record Type B and Record Type D repeated many times. In this case I just need to split Record Type B and Record Type D into multiple files. Because most of the mapping information is in Record Type B and Record Type D and don't need Record Type A.  After splitting into multiple files, I need map to SAP IDOC each PO  and post into SAP using BAPI. Thanks a lot for your help Boomi Gurus.

 

 

 

A0116091212050816091288756000853860008538600012800000300000
B010188756000101 160912450283 0450283LCÁÕ³ºÞ¸TC 01011 160913062349000007871-424 11:37 09121205 001011062349
D0101 4949268304979Êß¿ºÝ»Ìßײ DTK-1301/K0 0000400848300000000000( 4) T 107871424450283
A0116091213354416091288756000853860008538600012800000300000
B010188756000409 160912248294 0248294LCÁÕ³ºÞ¸TC 01011 160913062349000007864-7054 13:18 09121335 004091062349
D0101 4949268304993Êß¿ºÝ»Ìßײ CTL-490/W0 0000100072250000000000( 1) T 107864705248294
A0116091213500416091288756000853860008538600012800000300000
B010188756011887 160912509591 0509591LC·Ý·TC 13011 160915062349000007871-4243 13:43 09121350 118874062349
D0101 4949268305013Êß¿ºÝ»Ìßײ CTH-490/K0 0000100100300000000000( 1) T 107871424509591
A0116091214350716091288756000853860008538600012800000300000
B010188756001921 160912186512 0186512LC·³¼³TC 01031 160913062349000001921-582 14:13 09121435 019211062349
D0101 4949268305082Êß¿ºÝ»Ìßײ CTH-690/K1 0000100151300000000000( 1) T 101921582186512
A0116091215354916091288756000853860008538600012800000900000
B010188756000101 160912296541 0296541LCÁÕ³ºÞ¸TC 01011 160913062349000007864-7054 15:16 09121535 001011062349
D0101 4949268403252Êß¿ºÝ»Ìßײ LP-180-0S 0000100018750000000000( 1) T 107864705296541
B010188756010511 160912552379 0552379LC·Ý·TC 13011 160913062349000007866-5134 15:17 09121535 105114062349
D0101 4949268305044Êß¿ºÝ»Ìßײ CTH-490/B1 0000100100300000000000( 1) T 107866513552379
B010188756010591 160912556248 0556248LC·Ý·TC 13011 160913062349000007866-5134 15:17 09121535 105914062349
D0101 4949268304993Êß¿ºÝ»Ìßײ CTL-490/W0 0000100072250000000000( 1) T 107866513556248
B010188756011804 160912558137 0558137LC·Ý·TC 13011 160913062349000007866-5134 15:17 09121535 118044062349
D0101 4949268304993Êß¿ºÝ»Ìßײ CTL-490/W0 0000100072250000000000( 1) T 107866513558137
A0116091219354416091288756000853860008538600012800000700000
B010188756004172 160912303714 0303714LCÁ³ÌÞ¥TC 04922 160913062349000007865-6244 19:16 09121935 041722062349
D0101 4949268304757Êß¿ºÝ»Ìßײ PTH-651/K1 0000100253300000000000( 1) T 107865624303714
B010188756004188 160912307699 0307699LCÁ³ÌÞ¥TC 04922 160913062349000007865-6244 19:16 09121935 041882062349
D0101 4949268305037Êß¿ºÝ»Ìßײ CTH-490/K1 0000100100300000000000( 1) T 107865624307699
B010188756020129 160912940885 0940885LC¶Ý»²TC 20131 160913062349000027005-0214 19:08 09121935 201297062349
D0101 4949268305099Êß¿ºÝ»Ìßײ CTH-690/B1 0000100151300000000000( 1) T 127005021940885

Outcomes