SAP ABAP Table V_ALV_EDIT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_ALV_EDIT	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
5	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
6	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	SCURX
7	PLANETYPE	☐	S_PLANETYE	S_PLANE	CHAR	10	0	Aircraft Type	SAPLANE
8	SEATSMAX	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
9	SEATSOCC	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class
10	PAYMENTSUM	☐	S_SUM	S_SUM	CURR	17	2	Total of current bookings
11	SEATSMAX_B	☐	S_SMAX_B	S_SEATS	INT4	10	0	Maximum capacity in business class
12	SEATSOCC_B	☐	S_SOCC_B	S_SEATS	INT4	10	0	Occupied seats in business class
13	SEATSMAX_F	☐	S_SMAX_F	S_SEATS	INT4	10	0	Maximum capacity in first class
14	SEATSOCC_F	☐	S_SOCC_F	S_SEATS	INT4	10	0	Occupied seats in first class
15	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
16	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	SGEOCITY
17	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	SAIRPORT
18	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
19	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY
20	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	SAIRPORT
21	FLTIME	☐	S_FLTIME	S_DURA	INT4	10	0	Flight time
22	DEPTIME	☐	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
23	ARRTIME	☐	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
24	DISTANCE	☐	S_DISTANCE	S_DISTANCE	QUAN	9	4	Distance
25	DISTID	☐	S_DISTID	MEINS	UNIT	3	0	Mass unit of distance (kms, miles)
26	FLTYPE	☐	S_FLTYPE	S_FLTYPE	CHAR	1	0	Flight type
27	PERIOD	☐	S_PERIOD	INT1	INT1	3	0	Arrival n day(s) later

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_ALV_EDIT	AIRPFROM	SAIRPORT	ID	REF	1	CN
2	V_ALV_EDIT	AIRPTO	SAIRPORT	ID	REF	1	CN
3	V_ALV_EDIT	CARRID	SCARR	CARRID
4	V_ALV_EDIT	CITYFROM	SGEOCITY	CITY	REF	1	CN
5	V_ALV_EDIT	CITYTO	SGEOCITY	CITY	REF	1	CN
6	V_ALV_EDIT	CONNID	SPFLI	CONNID	KEY	1	CN
7	V_ALV_EDIT	COUNTRYFR	SGEOCITY	COUNTRY	REF	1	CN
8	V_ALV_EDIT	COUNTRYTO	SGEOCITY	COUNTRY	REF	1	CN
9	V_ALV_EDIT	CURRENCY	SCURX	CURRKEY	REF	1	N
10	V_ALV_EDIT	MANDT	T000	MANDT	KEY	1	CN
11	V_ALV_EDIT	PLANETYPE	SAPLANE	PLANETYPE	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in