Extract information from SAP

[pgalvezt]

Hello! I have a Sap report and I would like to know how extract just 2 values and left them in another columns, like Col1 Col2. I put an Excel Example.

Just I need to extract the first value within the date (In yellow).

Thanks!

[pgalvezt]

Any Help?

[pgalvezt]

Anyone?

Thanks!

[pgalvezt]

Anyone?

Thanks!

[mkirchhofer]

Hi, is the report a SAP standard transaction?

So that I can rebuild it?

regards

Mario

[pgalvezt]

Yes, if you can look my example is an Excel with the data standar report from SAP.

[mkirchhofer]

So please give me the name of transaction, like MB11 or what else!

[pgalvezt]

ME2N

[mkirchhofer · Accepted solution]

Hi,

you can try this reload source code.

Directory;
Temp:
LOAD
 Left(@1,10) as Order,
 Right(@1,10) as Order_Date,
 If(Alt(Right(@1,10),date#(Right(@1,10),'DD.MM.YYYY' ),0 ) <> 0,'X','') as Header_Flag 
FROM
[..\EX1.xls]
(biff, no labels, header is 4 lines, table is [ME2N CR ENE12$]);
Orders:
LOAD
 Order,
 Order_Date
Resident Temp
Where Header_Flag = 'X';
DROP Table Temp;

kind regards

Mario

[mkirchhofer]

Hi,

did the code solve your problem?

regards

Mario