Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

spfli table

Former Member
0 Kudos

plz send me some data's from spfli table in txt or xls formate i have to load some more data in my table.

4 REPLIES 4

athavanraja
Active Contributor
0 Kudos

run this program to load data into your flight tables.

SAPBC_DATA_GENERATOR

Regards

Raja

Former Member
0 Kudos

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.

Manohar2u
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi

Try to use the trxs with name begining with BC_GLOBAL*

max