Tabel Netwearver 2004

Untuk belajar abaper dari netweaver 2004 maka kita harus mengenal beberapa tabel yang ada di aplikasi netweaver 2004 yaitu Flight (Penerbangan) pada sesi ini saya hanya mengenalkan pada anda beberapa tabel yang dipakai oleh Netweaver 2004 berikut ini detailnya

Tabel Scarr (Nama Penerbangan)
Field DataElemet Data Type length decimal Description
MANDT S_MANDT CLNT 3 0 Client
CARRID S_CARR_ID CHAR 3 0 Airline Code
CARRNAME S_CARRNAME CHAR 20 0 Airline name
CURRCODE S_CURRCODE CUKY 5 0 Local currency of airline
URL S_CARRURL CHAR 255 0 Airline URL

Tabel Spfli ( Jadwal /rencana Penerbangan)
MANDT S_MANDT CLNT 3 0 Client
CARRID S_CARR_ID CHAR 3 0 Airline Code
CONNID S_CONN_ID NUMC 4 0 Flight Connection Number
COUNTRYFR LAND1 CHAR 3 0 Country Key
CITYFROM S_FROM_CIT CHAR 20 0 Departure city
AIRPFROM S_FROMAIRP CHAR 3 0 Departure airport
COUNTRYTO LAND1 CHAR 3 0 Country Key
CITYTO S_TO_CITY CHAR 20 0 Arrival city
AIRPTO S_TOAIRP CHAR 3 0 Destination airport
FLTIME S_FLTIME INT4 10 0 Flight time
DEPTIME S_DEP_TIME TIMS 6 0 Departure time
ARRTIME S_ARR_TIME TIMS 6 0 Arrival time
DISTANCE S_DISTANCE QUAN 9 4 Distance
DISTID S_DISTID UNIT 3 0 Mass unit of distance (kms, miles)
FLTYPE S_FLTYPE CHAR 1 0 Flight type
PERIOD S_PERIOD INT1 3 0 Arrival n day(s) later

Tabel sflight (actual penerbangan)
MANDT S_MANDT CLNT 3 0 Client
CARRID S_CARR_ID CHAR 3 0 Airline Code
CONNID S_CONN_ID NUMC 4 0 Flight Connection Number
FLDATE S_DATE DATS 8 0 Flight date
PRICE S_PRICE CURR 15 2 Airfare
CURRENCY S_CURRCODE CUKY 5 0 Local currency of airline
PLANETYPE S_PLANETYE CHAR 10 0 Aircraft Type
SEATSMAX S_SEATSMAX INT4 10 0 Maximum capacity in economy class
SEATSOCC S_SEATSOCC INT4 10 0 Occupied seats in economy class
PAYMENTSUM S_SUM CURR 17 2 Total of current bookings
SEATSMAX_B S_SMAX_B INT4 10 0 Maximum capacity in business class
SEATSOCC_B S_SOCC_B INT4 10 0 Occupied seats in business class
SEATSMAX_F S_SMAX_F INT4 10 0 Maximum capacity in first class
SEATSOCC_F S_SOCC_F INT4 10 0 Occupied seats in first class

Table sbook (Daftar /list yang melakukan booking untuk penerbangan)
MANDT S_MANDT CLNT 3 0 Client
CARRID S_CARR_ID CHAR 3 0 Airline Code
CONNID S_CONN_ID NUMC 4 0 Flight Connection Number
FLDATE S_DATE DATS 8 0 Flight date
BOOKID S_BOOK_ID NUMC 8 0 Booking number
CUSTOMID S_CUSTOMER NUMC 8 0 Customer Number
CUSTTYPE S_CUSTTYPE CHAR 1 0 Customer type
SMOKER S_SMOKER CHAR 1 0 Smoker
LUGGWEIGHT S_LUGWEIGH QUAN 8 4 Weight of Luggage
WUNIT S_WEIUNIT UNIT 3 0 Weight Unit
INVOICE S_INVFLAG CHAR 1 0 Invoice flag
CLASS S_CLASS CHAR 1 0 Flight Class
FORCURAM S_F_CUR_PR CURR 15 2 Booking price in foreign currency (dependent on location)
FORCURKEY S_CURR CUKY 5 0 Payment currency
LOCCURAM S_L_CUR_PR CURR 15 2 Price of booking in local currency of airline
LOCCURKEY S_CURRCODE CUKY 5 0 Local currency of airline
ORDER_DATE S_BDATE DATS 8 0 Booking Date
COUNTER S_COUNTNUM NUMC 8 0 Number of sales office
AGENCYNUM S_AGNCYNUM NUMC 8 0 Travel Agency Number

Table scustom (Data Kustomer)
MANDT S_MANDT CLNT 3 0 Client
ID S_CUSTOMER NUMC 8 0 Customer Number
NAME S_CUSTNAME CHAR 25 0 Customer name
FORM S_FORM CHAR 15 0 Form of address
STREET S_STREET CHAR 30 0 Street
POSTBOX S_POSTBOX CHAR 10 0 PO Box
POSTCODE POSTCODE CHAR 10 0 Postal Code
CITY CITY CHAR 25 0 City
COUNTRY S_COUNTRY CHAR 3 0 Country code
REGION S_REGION CHAR 3 0 Region
TELEPHONE S_PHONENO CHAR 30 0 Telephone number of flight customer
CUSTTYPE S_CUSTTYPE CHAR 1 0 Customer type
DISCOUNT S_DISCOUNT NUMC 3 0 Discount rate
LANGU SPRAS LANG 1 0 Language Key
EMAIL S_EMAIL CHAR 40 0 Customer e-mail address
WEBUSER S_WEBNAME CHAR 25 0 Web user name for customer

Table Scurr (Data Konversi currency)
MANDT MANDT CLNT 3 0 Client
KURST KURST_CURR CHAR 4 0 Exchange rate type
FCURR FCURR_CURR CUKY 5 0 From currency
TCURR TCURR_CURR CUKY 5 0 To-currency
GDATU GDATU_INV CHAR 8 0 Date As of Which the Exchange Rate Is Effective
UKURS UKURS_CURR DEC 9 5 Exchange Rate
FFACT FFACT_CURR DEC 9 0 Ratio for the "from" currency units
TFACT TFACT_CURR DEC 9 0 Ratio for the "to" currency units

Tabel Stravelag (table agen penjualan tiket pesawat)
MANDT S_MANDT CLNT 3 0 Client
AGENCYNUM S_AGNCYNUM NUMC 8 0 Travel Agency Number
NAME S_AGNCYNAM CHAR 25 0 Travel agency name
STREET S_STREET CHAR 30 0 Street
POSTBOX S_POSTBOX CHAR 10 0 PO Box
POSTCODE POSTCODE CHAR 10 0 Postal Code
CITY CITY CHAR 25 0 City
COUNTRY S_COUNTRY CHAR 3 0 Country code
REGION S_REGION CHAR 3 0 Region
TELEPHONE S_PHONENO CHAR 30 0 Telephone number of flight customer
URL S_URL CHAR 255 0 Travel agency homepage URL
LANGU SPRAS LANG 1 0 Language Key
CURRENCY S_CURR_AG CUKY 5 0 Travel agency local
currency


Tabel Sbuspart (beberapa transportasi bus)
MANDANT S_MANDT CLNT 3 0 Client
BUSPARTNUM S_BUSPANUM NUMC 8 0 Flight Partner Number
CONTACT S_CONTACT CHAR 25 0 Contact person for Workbench training model BC_Travel
CONTPHONO S_CPHONENO CHAR 30 0 Telephone number of contact person
BUSPATYP S_BUSPATYP CHAR 2 0 Business partner ID number for training data model BC_Travel

Table sgeocity
MANDT S_MANDT CLNT 3 0 Client
CITY S_CITY CHAR 20 0 City
COUNTRY LAND1 CHAR 3 0 Country Key
LATITUDE S_LATI FLTP 16 16 Latitude
LONGITUDE S_LONG FLTP 16 16 Longitude


Table sairport
MANDT S_MANDT CLNT 3 0 Client
ID S_AIRPORT CHAR 3 0 Airport Code
NAME S_AIRPNAME CHAR 25 0 Airport name
TIME_ZONE S_TZONE CHAR 6 0 Airport time zone