DAAG_SBOOK - Single Flight Booking
Single Flight Booking information is stored in SAP table DAAG_SBOOK.
It is part of development package S_DAAG_SFLIGHT_EXAMPLE in software component BC-CCM-DAG. This development package consists of objects that can be grouped under "Test Object DAAG_SFLIGHT".
It is part of development package S_DAAG_SFLIGHT_EXAMPLE in software component BC-CCM-DAG. This development package consists of objects that can be grouped under "Test Object DAAG_SFLIGHT".
Fields for table DAAG_SBOOK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | S_MANDT | CLNT | 6 | T000 |
| CARRID | Airline Code | X | S_CARR_ID | CHAR | 6 | SCARR |
| CONNID | Flight Connection Number | X | S_CONN_ID | NUMC | 8 | DAAG_SPFLI |
| FLDATE | Flight date | X | S_DATE | DATS | 16 | DAAG_SFLIGHT |
| BOOKID | Booking number | X | S_BOOK_ID | NUMC | 16 | |
| CUSTOMID | Customer Number | S_CUSTOMER | NUMC | 16 | SCUSTOM | |
| CUSTTYPE | Customer type | S_CUSTTYPE | CHAR | 2 | ||
| SMOKER | Smoker | S_SMOKER | CHAR | 2 | ||
| LUGGWEIGHT | Weight of Luggage | S_LUGWEIGH | QUAN | 5 | ||
| WUNIT | Weight Unit | S_WEIUNIT | UNIT | 6 | T006 | |
| INVOICE | Invoice flag | S_INVFLAG | CHAR | 2 | ||
| CLASS | Flight Class | S_CLASS | CHAR | 2 | ||
| FORCURAM | Booking price in foreign currency (dependent on location) | S_F_CUR_PR | CURR | 8 | ||
| FORCURKEY | Payment currency | S_CURR | CUKY | 10 | SCURX | |
| LOCCURAM | Price of booking in local currency of airline | S_L_CUR_PR | CURR | 8 | ||
| LOCCURKEY | Local currency of airline | S_CURRCODE | CUKY | 10 | SCURX | |
| ORDER_DATE | Booking Date | S_BDATE | DATS | 16 | ||
| COUNTER | Number of sales office | S_COUNTNUM | NUMC | 16 | SCOUNTER | |
| AGENCYNUM | Travel Agency Number | S_AGNCYNUM | NUMC | 16 | STRAVELAG | |
| CANCELLED | Cancelation flag | S_CANCEL | CHAR | 2 | ||
| RESERVED | Reservation flag | S_RESERV | CHAR | 2 | ||
| PASSNAME | Name of the Passenger | S_PASSNAME | CHAR | 50 | ||
| PASSFORM | Form of address | S_FORM | CHAR | 30 | ||
| PASSBIRTH | Date of Birth of a Passenger | S_BIRTHDAT | DATS | 16 | * | |
| INVOICE_OPEN | Open Invoice | DAAG_INVOICE_OPEN | CHAR | 2 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |