SAP ABAP Table SACY_BOOK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SACY_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	AGENCYNUM	☑	S_AGNCYNUM	S_BUSPANUM	NUMC	8	0	Travel Agency Number	STRAVELAG
4	NAME	☑	S_AGNCYNAM	S_CUSTNAME	CHAR	25	0	Travel agency name
5	STREET	☑	S_STREET	S_STREET	CHAR	30	0	Street
6	POSTBOX	☑	S_POSTBOX	S_POSTBOX	CHAR	10	0	PO Box
7	POSTCODE	☑	POSTCODE	POSTCODE	CHAR	10	0	Postal Code
8	CITY	☑	CITY	CITY	CHAR	25	0	City
9	COUNTRY	☑	S_COUNTRY	S_COUNTRY	CHAR	3	0	Country code
10	CONNID	☑	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	SPFLI
11	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date	SFLIGHT
12	BOOKID	☑	S_BOOK_ID	S_BOOK_ID	NUMC	8	0	Booking number
13	CLASS	☐	S_CLASS	S_CLASS	CHAR	1	0	Flight Class

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SACY_BOOK	AGENCYNUM	STRAVELAG	AGENCYNUM	REF	1	CN
2	SACY_BOOK	CARRID	SCARR	CARRID	KEY	1	CN
3	SACY_BOOK	CONNID	SPFLI	CONNID
4	SACY_BOOK	FLDATE	SFLIGHT	FLDATE	KEY	1	CN
5	SACY_BOOK	MANDT	T000	MANDT

History

Last changed by/on	SAP	20130604
SAP Release Created in