SAP ABAP Table TARCHBOOK (Archiving Example: Flight Bookings)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-FS-ARE (Application Component) Archiving Engine
     ⤷ ARFA_ARCHIVING_TEST (Package) Test Application

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TARCHBOOK	Table Relationship Diagram
Short Description	Archiving Example: Flight Bookings

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	S_MANDT	MANDT	CLNT	3	0	Client	*
2	CARRID	☑	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	*
3	CONNID	☑	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	*
4	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date	*
5	BOOKID	☑	S_BOOK_ID	S_BOOK_ID	NUMC	8	0	Booking number
6	CUSTOMID	☐	S_CUSTOMER	S_BUSPANUM	NUMC	8	0	Customer Number	*
7	CUSTTYPE	☐	S_CUSTTYPE	S_CUSTTYPE	CHAR	1	0	Customer type
8	SMOKER	☐	S_SMOKER	S_SMOKER	CHAR	1	0	Smoker
9	LUGGWEIGHT	☐	S_LUGWEIGH	S_LUGWEIGH	QUAN	8	4	Weight of Luggage
10	WUNIT	☐	S_WEIUNIT	MEINS	UNIT	3	0	Weight Unit	*
11	INVOICE	☐	S_INVFLAG	S_FLAG	CHAR	1	0	Invoice flag
12	CLASS	☐	S_CLASS	S_CLASS	CHAR	1	0	Flight Class
13	FORCURAM	☐	S_F_CUR_PR	S_PRICE	CURR	15	2	Booking price in foreign currency (dependent on location)
14	FORCURKEY	☐	S_CURR	S_CURR	CUKY	5	0	Payment currency	*
15	LOCCURAM	☐	S_L_CUR_PR	S_PRICE	CURR	15	2	Price of booking in local currency of airline
16	LOCCURKEY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	*
17	ORDER_DATE	☐	S_BDATE	S_BDATE	DATS	8	0	Booking Date
18	COUNTER	☐	S_COUNTNUM	S_COUNTNUM	NUMC	8	0	Number of sales office	*
19	AGENCYNUM	☐	S_AGNCYNUM	S_BUSPANUM	NUMC	8	0	Travel Agency Number	*
20	CANCELLED	☐	S_CANCEL	S_CANCEL	CHAR	1	0	Cancelation flag
21	RESERVED	☐	S_RESERV	S_RESERV	CHAR	1	0	Reservation flag
22	PASSNAME	☐	S_PASSNAME	S_CUSTNAME	CHAR	25	0	Name of the Passenger
23	PASSFORM	☐	S_FORM	S_TEXT15	CHAR	15	0	Form of address
24	PASSBIRTH	☐	S_BIRTHDAT	S_DATE	DATS	8	0	Date of Birth of a Passenger	*

History

Last changed by/on	SAP	20130604
SAP Release Created in	40