05-28-2006 12:29 PM
plz send me some data's from spfli table in txt or xls formate i have to load some more data in my table.
05-28-2006 12:33 PM
run this program to load data into your flight tables.
SAPBC_DATA_GENERATOR
Regards
Raja
05-28-2006 12:34 PM
Hi,
Use transaction BC_DATA_GEN and it will generate all the data you want into all the flight tables.
Regards,
Ravi
Note :Please mark all the helpful answers and close the thread if your issue is resolved.
05-28-2006 12:36 PM
Here is the data you need.
-
MANDT | CARRID | CONNID | COUNTRYFR | CITYFROM | AIRPFROM | COUNTRYTO | CITYTO | AIRPTO | FLTIME | DEPTIME | ARRTIME | DISTANCE | DISTID | FLTYPE | PERIOD |
-
800 | AA | 0017 | US | NEW YORK | JFK | US | SAN FRANCISCO | SFO | 361 | 11:00:00 | 14:01:00 | 2.572,0000 | MI | 0 | ||
800 | AA | 0064 | US | SAN FRANCISCO | SFO | US | NEW YORK | JFK | 321 | 09:00:00 | 17:21:00 | 2.572,0000 | MI | 0 | ||
800 | AA | 6002 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 444 | 16:36:00 | 05:06:40 | 6.162,0000 | KM | 0 | ||
800 | AB | 5005 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 444 | 12:36:00 | 01:06:40 | 6.162,0000 | KM | 0 | ||
800 | AF | 5004 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 444 | 08:44:40 | 21:08:40 | 6.162,0000 | KM | 0 | ||
800 | AZ | 0555 | IT | ROME | FCO | DE | FRANKFURT | FRA | 125 | 19:00:00 | 21:05:00 | 845,0000 | MI | 0 | ||
800 | AZ | 0788 | IT | ROME | FCO | JP | TOKYO | TYO | 775 | 12:00:00 | 08:55:00 | 6.130,0000 | MI | 1 | ||
800 | AZ | 0789 | JP | TOKYO | TYO | IT | ROME | FCO | 940 | 11:45:00 | 19:25:00 | 6.130,0000 | MI | 0 | ||
800 | AZ | 0790 | IT | ROME | FCO | JP | OSAKA | KIX | 815 | 10:35:00 | 08:10:00 | 6.030,0000 | MI | X | 1 | |
800 | BA | 5003 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 444 | 19:01:20 | 18:45:20 | 6.162,0000 | KM | 0 | ||
800 | BA | 6003 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 444 | 10:36:00 | 23:06:40 | 6.162,0000 | KM | 0 | ||
800 | DL | 0106 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 475 | 19:35:00 | 09:30:00 | 3.851,0000 | MI | 1 | ||
800 | DL | 1699 | US | NEW YORK | JFK | US | SAN FRANCISCO | SFO | 382 | 17:15:00 | 20:37:00 | 2.572,0000 | MI | 0 | ||
800 | DL | 1984 | US | SAN FRANCISCO | SFO | US | NEW YORK | JFK | 325 | 10:00:00 | 18:25:00 | 2.572,0000 | MI | 0 | ||
800 | JL | 0407 | JP | TOKYO | NRT | DE | FRANKFURT | FRA | 725 | 13:30:00 | 17:35:00 | 9.100,0000 | KM | 0 | ||
800 | JL | 0408 | DE | FRANKFURT | FRA | JP | TOKYO | NRT | 675 | 20:25:00 | 15:40:00 | 9.100,0000 | KM | X | 1 | |
800 | LH | 0400 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 444 | 10:10:00 | 11:34:00 | 6.162,0000 | KM | 0 | ||
800 | LH | 0401 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 435 | 18:30:00 | 07:45:00 | 6.162,0000 | KM | 1 | ||
800 | LH | 0402 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 455 | 13:30:00 | 15:05:00 | 6.162,0000 | KM | X | 0 | |
800 | LH | 2402 | DE | FRANKFURT | FRA | DE | BERLIN | SXF | 65 | 10:30:00 | 11:35:00 | 555,0000 | KM | 0 | ||
800 | LH | 2407 | DE | BERLIN | TXL | DE | FRANKFURT | FRA | 65 | 07:10:00 | 08:15:00 | 555,0000 | KM | 0 | ||
800 | LH | 5002 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 444 | 12:31:20 | 01:02:00 | 6.162,0000 | KM | 0 | ||
800 | LH | 6002 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 475 | 23:35:00 | 13:30:00 | 3.851,0000 | MI | 1 | ||
800 | QF | 0005 | SG | SINGAPORE | SIN | DE | FRANKFURT | FRA | 825 | 22:50:00 | 05:35:00 | 10000,0000 | KM | 1 | ||
800 | QF | 0006 | DE | FRANKFURT | FRA | SG | SINGAPORE | SIN | 670 | 20:55:00 | 15:05:00 | 10000,0000 | KM | 1 | ||
800 | SQ | 0002 | SG | SINGAPORE | SIN | US | SAN FRANCISCO | SFO | 1.105 | 17:00:00 | 19:25:00 | 8.452,0000 | MI | 0 | ||
800 | SQ | 0015 | US | SAN FRANCISCO | SFO | SG | SINGAPORE | SIN | 1.125 | 16:00:00 | 02:45:00 | 8.452,0000 | MI | 2 | ||
800 | SQ | 0158 | SG | SINGAPORE | SIN | ID | JAKARTA | JKT | 95 | 15:25:00 | 16:00:00 | 560,0000 | MI | 0 | ||
800 | SQ | 0988 | SG | SINGAPORE | SIN | JP | TOKYO | TYO | 400 | 16:35:00 | 00:15:00 | 3.125,0000 | MI | 1 | ||
800 | SR | 5000 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 444 | 16:38:00 | 05:08:40 | 6.162,0000 | KM | 0 | ||
800 | SR | 6000 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 475 | 15:35:00 | 05:30:00 | 3.851,0000 | MI | 1 | ||
800 | UA | 0941 | DE | FRANKFURT | FRA | US | SAN FRANCISCO | SFO | 696 | 14:30:00 | 17:06:00 | 5.685,0000 | MI | 0 | ||
800 | UA | 3504 | US | SAN FRANCISCO | SFO | DE | FRANKFURT | FRA | 630 | 15:00:00 | 10:30:00 | 5.685,0000 | MI | 1 | ||
800 | UA | 3516 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 445 | 16:20:00 | 05:45:00 | 6.162,0000 | KM | 1 | ||
800 | UA | 3517 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 495 | 10:40:00 | 12:55:00 | 6.162,0000 | KM | 0 | ||
800 | UA | 5001 | DE | FRANKFURT | FRA | US | NEW YORK | JFK | 444 | 10:38:00 | 23:08:40 | 6.162,0000 | KM | 0 | ||
800 | UA | 6000 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 444 | 08:36:00 | 21:06:40 | 6.162,0000 | KM | 0 | ||
800 | UA | 6001 | US | NEW YORK | JFK | DE | FRANKFURT | FRA | 444 | 14:36:00 | 03:06:40 | 6.162,0000 | KM | 0 |
-
Regds
Manohar
05-28-2006 12:55 PM