SAP ABAP Table SCUS_BOOK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SCUS_BOOK	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	MANDT	☑	S_MANDT	MANDT	CLNT	3	0	Client	T000
2	CARRID	☑	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	SCARR
3	CONNID	☑	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	SPFLI
4	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date	SFLIGHT
5	BOOKID	☑	S_BOOK_ID	S_BOOK_ID	NUMC	8	0	Booking number
6	CUSTOMID	☐	S_CUSTOMER	S_BUSPANUM	NUMC	8	0	Customer Number	SCUSTOM
7	CANCELLED	☐	S_CANCEL	S_CANCEL	CHAR	1	0	Cancelation flag
8	NAME	☐	S_CUSTNAME	S_CUSTNAME	CHAR	25	0	Customer name
9	FORM	☐	S_FORM	S_TEXT15	CHAR	15	0	Form of address
10	CITY	☐	CITY	CITY	CHAR	25	0	City
11	COUNTRY	☐	S_COUNTRY	S_COUNTRY	CHAR	3	0	Country code
12	REGION	☐	S_REGION	S_REGION	CHAR	3	0	Region
13	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
14	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	SGEOCITY
15	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
16	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SCUS_BOOK	CARRID	SCARR	CARRID	KEY	1	CN
2	SCUS_BOOK	CITYFROM	SGEOCITY	CITY	REF	1	CN
3	SCUS_BOOK	CITYTO	SGEOCITY	CITY	REF	1	CN
4	SCUS_BOOK	CONNID	SPFLI	CONNID
5	SCUS_BOOK	COUNTRYFR	SGEOCITY	COUNTRY	REF	1	CN
6	SCUS_BOOK	COUNTRYTO	SGEOCITY	COUNTRY	REF	1	CN
7	SCUS_BOOK	CUSTOMID	SCUSTOM	ID	KEY	1	CN
8	SCUS_BOOK	FLDATE	SFLIGHT	FLDATE	KEY	1	CN
9	SCUS_BOOK	MANDT	T000	MANDT

History

Last changed by/on	SAP	20130604
SAP Release Created in