SAP ABAP Table SXIDEMO_SBOOK (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | SXIDEMO_SBOOK | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | S_MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | CARRID | S_CARR_ID | S_CARR_ID | CHAR | 3 | 0 | Airline Code | ||
3 | CARRNAME | S_CARRNAME | S_NAME20 | CHAR | 20 | 0 | Airline name | ||
4 | BOOKID | S_BOOK_ID | S_BOOK_ID | NUMC | 8 | 0 | Booking number | ||
5 | CONNID | S_CONN_ID | S_CONN_ID | NUMC | 4 | 0 | Flight Connection Number | SPFLI | |
6 | FLDATE | S_DATE | S_DATE | DATS | 8 | 0 | Flight date | SFLIGHT | |
7 | CLASS | S_CLASS | S_CLASS | CHAR | 1 | 0 | Flight Class | ||
8 | ORDER_DATE | S_BDATE | S_BDATE | DATS | 8 | 0 | Booking Date | ||
9 | AGENCYNUM | S_AGNCYNUM | S_BUSPANUM | NUMC | 8 | 0 | Travel Agency Number | STRAVELAG | |
10 | CANCELLED | S_CANCEL | S_CANCEL | CHAR | 1 | 0 | Cancelation flag | ||
11 | PASSNAME | S_PASSNAME | S_CUSTNAME | CHAR | 25 | 0 | Name of the Passenger | ||
12 | PASSBIRTH | S_BIRTHDAT | S_DATE | DATS | 8 | 0 | Date of Birth of a Passenger |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SXIDEMO_SBOOK | AGENCYNUM | STRAVELAG | AGENCYNUM | REF | 1 | CN |
2 | SXIDEMO_SBOOK | CLIENT | T000 | MANDT | KEY | 1 | CN |
3 | SXIDEMO_SBOOK | CONNID | SPFLI | CONNID | |||
4 | SXIDEMO_SBOOK | FLDATE | SFLIGHT | FLDATE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |