Skip to Content
avatar image
Former Member

spfli table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 28, 2006 at 11:33 AM

    run this program to load data into your flight tables.

    SAPBC_DATA_GENERATOR

    Regards

    Raja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2006 at 11:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2006 at 11:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2006 at 11:55 AM

    Hi

    Try to use the trxs with name begining with BC_GLOBAL*

    max

    Add comment
    10|10000 characters needed characters exceeded