Table/Structure Field list used by SAP ABAP Program /SAPQUERY/MODEL_DATA_GENERATOR (Query Project - Test Data Generation)
SAP ABAP Program 
/SAPQUERY/MODEL_DATA_GENERATOR (Query Project - Test Data Generation) is using
-
Table/Structure Field (174)
-
Function Module (4)
-
Message Class (1)
-
Message Number (1)
-
Program (4)
-
Table (20)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
/SAPQUERY/T000 - AIRPFROM | Departure airport | |
| 2 | Table/Structure Field |
/SAPQUERY/T000 - AIRPTO | Destination airport | |
| 3 | Table/Structure Field |
/SAPQUERY/T000 - ARRTIME | Arrival time | |
| 4 | Table/Structure Field |
/SAPQUERY/T000 - CARRID | Airline Code | |
| 5 | Table/Structure Field |
/SAPQUERY/T000 - CITYFROM | City | |
| 6 | Table/Structure Field |
/SAPQUERY/T000 - CITYTO | Arrival city | |
| 7 | Table/Structure Field |
/SAPQUERY/T000 - CONNID | Flight Connection Number | |
| 8 | Table/Structure Field |
/SAPQUERY/T000 - COUNTRYFR | Country Key | |
| 9 | Table/Structure Field |
/SAPQUERY/T000 - COUNTRYTO | Country Key | |
| 10 | Table/Structure Field |
/SAPQUERY/T000 - DEPTIME | Departure time | |
| 11 | Table/Structure Field |
/SAPQUERY/T000 - DISTANCE | Distance | |
| 12 | Table/Structure Field |
/SAPQUERY/T000 - DISTID | Mass unit of distance (kms, miles) | |
| 13 | Table/Structure Field |
/SAPQUERY/T000 - FLTIME | Flight time | |
| 14 | Table/Structure Field |
/SAPQUERY/T000 - FLTYPE | Flight type | |
| 15 | Table/Structure Field |
/SAPQUERY/T000 - MANDT | Client | |
| 16 | Table/Structure Field |
/SAPQUERY/T000 - PERIOD | Arrival n day(s) later | |
| 17 | Table/Structure Field |
/SAPQUERY/T100 - CARRID | Airline Code | |
| 18 | Table/Structure Field |
/SAPQUERY/T100 - CONNID | Flight Connection Number | |
| 19 | Table/Structure Field |
/SAPQUERY/T100 - CURRENCY | Local currency of airline | |
| 20 | Table/Structure Field |
/SAPQUERY/T100 - FLDATE | Flight date | |
| 21 | Table/Structure Field |
/SAPQUERY/T100 - MANDT | Client | |
| 22 | Table/Structure Field |
/SAPQUERY/T100 - PAYMENTSUM | Total of current bookings | |
| 23 | Table/Structure Field |
/SAPQUERY/T100 - PLANETYPE | Aircraft Type | |
| 24 | Table/Structure Field |
/SAPQUERY/T100 - PRICE | Airfare | |
| 25 | Table/Structure Field |
/SAPQUERY/T100 - SEATSMAX | Maximum capacity in economy class | |
| 26 | Table/Structure Field |
/SAPQUERY/T100 - SEATSMAX_B | Maximum capacity in business class | |
| 27 | Table/Structure Field |
/SAPQUERY/T100 - SEATSMAX_F | Maximum capacity in first class | |
| 28 | Table/Structure Field |
/SAPQUERY/T100 - SEATSOCC | Occupied seats in economy class | |
| 29 | Table/Structure Field |
/SAPQUERY/T100 - SEATSOCC_B | Occupied seats in business class | |
| 30 | Table/Structure Field |
/SAPQUERY/T100 - SEATSOCC_F | Occupied seats in first class | |
| 31 | Table/Structure Field |
/SAPQUERY/T101 - BOXLMAX | Maximum capacity for large container | |
| 32 | Table/Structure Field |
/SAPQUERY/T101 - BOXLOCC | Occupied large containers | |
| 33 | Table/Structure Field |
/SAPQUERY/T101 - BOXSMAX | Maximum capacity for small container | |
| 34 | Table/Structure Field |
/SAPQUERY/T101 - BOXSOCC | Occupied small containers | |
| 35 | Table/Structure Field |
/SAPQUERY/T101 - CARRID | Airline Code | |
| 36 | Table/Structure Field |
/SAPQUERY/T101 - CONNID | Flight Connection Number | |
| 37 | Table/Structure Field |
/SAPQUERY/T101 - CURRENCY | Local currency of airline | |
| 38 | Table/Structure Field |
/SAPQUERY/T101 - FLDATE | Flight date | |
| 39 | Table/Structure Field |
/SAPQUERY/T101 - MANDT | Client | |
| 40 | Table/Structure Field |
/SAPQUERY/T101 - PAYMENTSUM | Total of current bookings | |
| 41 | Table/Structure Field |
/SAPQUERY/T101 - PLANETYPE | Aircraft Type | |
| 42 | Table/Structure Field |
/SAPQUERY/T101 - PRICE | Airfare | |
| 43 | Table/Structure Field |
/SAPQUERY/T102 - CARRID | Airline Code | |
| 44 | Table/Structure Field |
/SAPQUERY/T102 - CARRNAME | Airline name | |
| 45 | Table/Structure Field |
/SAPQUERY/T102 - CURRCODE | Local currency of airline | |
| 46 | Table/Structure Field |
/SAPQUERY/T102 - MANDT | Client | |
| 47 | Table/Structure Field |
/SAPQUERY/T102 - URL | Airline URL | |
| 48 | Table/Structure Field |
/SAPQUERY/T200 - AGENCYNUM | Travel Agency Number | |
| 49 | Table/Structure Field |
/SAPQUERY/T200 - BOOKID | Booking number | |
| 50 | Table/Structure Field |
/SAPQUERY/T200 - CANCELLED | Cancelation flag | |
| 51 | Table/Structure Field |
/SAPQUERY/T200 - CARRID | Airline Code | |
| 52 | Table/Structure Field |
/SAPQUERY/T200 - CLASS | Flight Class | |
| 53 | Table/Structure Field |
/SAPQUERY/T200 - CONNID | Flight Connection Number | |
| 54 | Table/Structure Field |
/SAPQUERY/T200 - COUNTER | Number of sales office | |
| 55 | Table/Structure Field |
/SAPQUERY/T200 - CUSTOMID | Customer Number | |
| 56 | Table/Structure Field |
/SAPQUERY/T200 - CUSTTYPE | Customer type | |
| 57 | Table/Structure Field |
/SAPQUERY/T200 - FLDATE | Flight date | |
| 58 | Table/Structure Field |
/SAPQUERY/T200 - FORCURAM | Booking price in foreign currency (dependent on location) | |
| 59 | Table/Structure Field |
/SAPQUERY/T200 - FORCURKEY | Payment currency | |
| 60 | Table/Structure Field |
/SAPQUERY/T200 - INVOICE | Invoice flag | |
| 61 | Table/Structure Field |
/SAPQUERY/T200 - LOCCURAM | Price of booking in local currency of airline | |
| 62 | Table/Structure Field |
/SAPQUERY/T200 - LOCCURKEY | Local currency of airline | |
| 63 | Table/Structure Field |
/SAPQUERY/T200 - LUGGWEIGHT | Weight of Luggage | |
| 64 | Table/Structure Field |
/SAPQUERY/T200 - MANDT | Client | |
| 65 | Table/Structure Field |
/SAPQUERY/T200 - ORDER_DATE | Booking Date | |
| 66 | Table/Structure Field |
/SAPQUERY/T200 - SMOKER | Smoker | |
| 67 | Table/Structure Field |
/SAPQUERY/T200 - WUNIT | Weight Unit | |
| 68 | Table/Structure Field |
/SAPQUERY/T211 - AGENCYNUM | Travel Agency Number | |
| 69 | Table/Structure Field |
/SAPQUERY/T211 - BOOKID | Booking number | |
| 70 | Table/Structure Field |
/SAPQUERY/T211 - CANCELLED | Cancelation flag | |
| 71 | Table/Structure Field |
/SAPQUERY/T211 - CARRID | Airline Code | |
| 72 | Table/Structure Field |
/SAPQUERY/T211 - CONNID | Flight Connection Number | |
| 73 | Table/Structure Field |
/SAPQUERY/T211 - CONTAINER | Container Size | |
| 74 | Table/Structure Field |
/SAPQUERY/T211 - COUNTER | Number of sales office | |
| 75 | Table/Structure Field |
/SAPQUERY/T211 - CUSTOMID | Customer Number | |
| 76 | Table/Structure Field |
/SAPQUERY/T211 - CUSTTYPE | Customer type | |
| 77 | Table/Structure Field |
/SAPQUERY/T211 - FLDATE | Flight date | |
| 78 | Table/Structure Field |
/SAPQUERY/T211 - FORCURAM | Booking price in foreign currency (dependent on location) | |
| 79 | Table/Structure Field |
/SAPQUERY/T211 - FORCURKEY | Payment currency | |
| 80 | Table/Structure Field |
/SAPQUERY/T211 - INVOICE | Invoice flag | |
| 81 | Table/Structure Field |
/SAPQUERY/T211 - LOCCURAM | Price of booking in local currency of airline | |
| 82 | Table/Structure Field |
/SAPQUERY/T211 - LOCCURKEY | Local currency of airline | |
| 83 | Table/Structure Field |
/SAPQUERY/T211 - LUGGWEIGHT | Weight of Luggage | |
| 84 | Table/Structure Field |
/SAPQUERY/T211 - MANDT | Client | |
| 85 | Table/Structure Field |
/SAPQUERY/T211 - MATERIAL | Material number | |
| 86 | Table/Structure Field |
/SAPQUERY/T211 - ORDER_DATE | Booking Date | |
| 87 | Table/Structure Field |
/SAPQUERY/T211 - WUNIT | Weight Unit | |
| 88 | Table/Structure Field |
/SAPQUERY/TA00 - CARRID | Airline Code | |
| 89 | Table/Structure Field |
/SAPQUERY/TA00 - CARRNAME | Airline name | |
| 90 | Table/Structure Field |
/SAPQUERY/TA00 - CURRCODE | Local currency of airline | |
| 91 | Table/Structure Field |
/SAPQUERY/TA00 - URL | Airline URL | |
| 92 | Table/Structure Field |
/SAPQUERY/TA01 - ID | Airport Code | |
| 93 | Table/Structure Field |
/SAPQUERY/TA01 - NAME | Airport name | |
| 94 | Table/Structure Field |
/SAPQUERY/TA01 - TIME_ZONE | Airport time zone | |
| 95 | Table/Structure Field |
/SAPQUERY/TA02 - CITY | City | |
| 96 | Table/Structure Field |
/SAPQUERY/TA02 - COUNTRY | Country code | |
| 97 | Table/Structure Field |
/SAPQUERY/TA02 - CUSTTYPE | Customer type | |
| 98 | Table/Structure Field |
/SAPQUERY/TA02 - DISCOUNT | Discount rate | |
| 99 | Table/Structure Field |
/SAPQUERY/TA02 - EMAIL | Customer e-mail address | |
| 100 | Table/Structure Field |
/SAPQUERY/TA02 - FORM | Form of address | |
| 101 | Table/Structure Field |
/SAPQUERY/TA02 - ID | Customer Number | |
| 102 | Table/Structure Field |
/SAPQUERY/TA02 - LANGU | Language Key | |
| 103 | Table/Structure Field |
/SAPQUERY/TA02 - MANDT | Client | |
| 104 | Table/Structure Field |
/SAPQUERY/TA02 - NAME | Customer name | |
| 105 | Table/Structure Field |
/SAPQUERY/TA02 - POSTBOX | PO Box | |
| 106 | Table/Structure Field |
/SAPQUERY/TA02 - POSTCODE | Postal Code | |
| 107 | Table/Structure Field |
/SAPQUERY/TA02 - REGION | Region | |
| 108 | Table/Structure Field |
/SAPQUERY/TA02 - STREET | Street | |
| 109 | Table/Structure Field |
/SAPQUERY/TA02 - TELEPHONE | Telephone number of flight customer | |
| 110 | Table/Structure Field |
/SAPQUERY/TA02 - WEBUSER | Web user name for customer | |
| 111 | Table/Structure Field |
/SAPQUERY/TA03 - CITY | City | |
| 112 | Table/Structure Field |
/SAPQUERY/TA03 - COUNTRY | Country Key | |
| 113 | Table/Structure Field |
/SAPQUERY/TA03 - LATITUDE | Latitude | |
| 114 | Table/Structure Field |
/SAPQUERY/TA03 - LONGITUDE | Longitude | |
| 115 | Table/Structure Field |
/SAPQUERY/TA04 - CAP_UNIT | Mass unit | |
| 116 | Table/Structure Field |
/SAPQUERY/TA04 - CONSUM | Average consumption | |
| 117 | Table/Structure Field |
/SAPQUERY/TA04 - CON_UNIT | Unit of fuel consumption | |
| 118 | Table/Structure Field |
/SAPQUERY/TA04 - LENG | Length of plane | |
| 119 | Table/Structure Field |
/SAPQUERY/TA04 - LENG_UNIT | Length unit | |
| 120 | Table/Structure Field |
/SAPQUERY/TA04 - OP_SPEED | Speed | |
| 121 | Table/Structure Field |
/SAPQUERY/TA04 - PLANETYPE | Aircraft Type | |
| 122 | Table/Structure Field |
/SAPQUERY/TA04 - PRODUCER | Plane manufacturer | |
| 123 | Table/Structure Field |
/SAPQUERY/TA04 - SEATSMAX | Maximum capacity in economy class | |
| 124 | Table/Structure Field |
/SAPQUERY/TA04 - SEATSMAX_B | Maximum capacity in business class | |
| 125 | Table/Structure Field |
/SAPQUERY/TA04 - SEATSMAX_F | Maximum capacity in first class | |
| 126 | Table/Structure Field |
/SAPQUERY/TA04 - SPAN | Span | |
| 127 | Table/Structure Field |
/SAPQUERY/TA04 - SPAN_UNIT | Length unit | |
| 128 | Table/Structure Field |
/SAPQUERY/TA04 - SPEED_UNIT | Length unit | |
| 129 | Table/Structure Field |
/SAPQUERY/TA04 - TANKCAP | Maximum fuel capacity | |
| 130 | Table/Structure Field |
/SAPQUERY/TA04 - WEIGHT | Weight of plane | |
| 131 | Table/Structure Field |
/SAPQUERY/TA04 - WEI_UNIT | Weight Unit | |
| 132 | Table/Structure Field |
/SAPQUERY/TA05 - BUSPARTNUM | Flight Partner Number | |
| 133 | Table/Structure Field |
/SAPQUERY/TA05 - BUSPATYP | Business partner ID number | |
| 134 | Table/Structure Field |
/SAPQUERY/TA05 - CONTACT | Contact person | |
| 135 | Table/Structure Field |
/SAPQUERY/TA05 - CONTPHONO | Telephone number of flight customer | |
| 136 | Table/Structure Field |
/SAPQUERY/TA06 - AIRPORT | Airport Code | |
| 137 | Table/Structure Field |
/SAPQUERY/TA06 - CARRID | Airline Code | |
| 138 | Table/Structure Field |
/SAPQUERY/TA06 - COUNTNUM | Number of sales office | |
| 139 | Table/Structure Field |
/SAPQUERY/TA07 - CURRDEC | Number of decimal places | |
| 140 | Table/Structure Field |
/SAPQUERY/TA07 - CURRKEY | Local currency of airline | |
| 141 | Table/Structure Field |
BFUSER_TYP - OBJNAME | Object name | |
| 142 | Table/Structure Field |
DD02D - TABNAME | Table Name | |
| 143 | Table/Structure Field |
SCARPLAN - CARRID | Airline Code | |
| 144 | Table/Structure Field |
SCARPLAN - MANDT | Client | |
| 145 | Table/Structure Field |
SCARPLAN - PLANETYPE | Aircraft Type | |
| 146 | Table/Structure Field |
SCARPLAN - SNUMBER | Number of flights | |
| 147 | Table/Structure Field |
SCITAIRP - AIRPORT | Airport Code | |
| 148 | Table/Structure Field |
SCITAIRP - CITY | City | |
| 149 | Table/Structure Field |
SCITAIRP - COUNTRY | Country Key | |
| 150 | Table/Structure Field |
SCITAIRP - MASTERCITY | City | |
| 151 | Table/Structure Field |
SCURR - FCURR | From currency | |
| 152 | Table/Structure Field |
SCURR - FFACT | Ratio for the "from" currency units | |
| 153 | Table/Structure Field |
SCURR - GDATU | Date As of Which the Exchange Rate Is Effective | |
| 154 | Table/Structure Field |
SCURR - KURST | Exchange rate type | |
| 155 | Table/Structure Field |
SCURR - TCURR | To-currency | |
| 156 | Table/Structure Field |
SCURR - TFACT | Ratio for the "to" currency units | |
| 157 | Table/Structure Field |
SCURR - UKURS | Exchange Rate | |
| 158 | Table/Structure Field |
STRAVELAG - AGENCYNUM | Travel Agency Number | |
| 159 | Table/Structure Field |
STRAVELAG - CITY | City | |
| 160 | Table/Structure Field |
STRAVELAG - COUNTRY | Country code | |
| 161 | Table/Structure Field |
STRAVELAG - LANGU | Language Key | |
| 162 | Table/Structure Field |
STRAVELAG - NAME | Travel agency name | |
| 163 | Table/Structure Field |
STRAVELAG - POSTBOX | PO Box | |
| 164 | Table/Structure Field |
STRAVELAG - POSTCODE | Postal Code | |
| 165 | Table/Structure Field |
STRAVELAG - REGION | Region | |
| 166 | Table/Structure Field |
STRAVELAG - STREET | Street | |
| 167 | Table/Structure Field |
STRAVELAG - TELEPHONE | Telephone number of flight customer | |
| 168 | Table/Structure Field |
STRAVELAG - URL | Travel agency homepage URL | |
| 169 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 170 | Table/Structure Field |
SYST - INDEX | ABAP System Field: Loop Index | |
| 171 | Table/Structure Field |
SYST - MANDT | ABAP System Field: Client ID of Current User | |
| 172 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables | |
| 173 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server | |
| 174 | Table/Structure Field |
SYST - VLINE | ABAP System Field: Vertical Line for List |
