SAP ALV_T_T2 Test Data for ALV Table

Overview

ALV_T_T2 is a standard SAP S/4HANA table that stores Test Data for ALV data. There are total 33 fields in the ALV_T_T2 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ALV_T_T2 belongs to SAP List Viewer (BC-SRV-ALV) module and is located in the package Generic list types (SLIS).

In addition, following links provide an overview of foreign key relationships, if any, that link ALV_T_T2 to other SAP tables and standard CDS views available based on ALV_T_T2 table in S/4HANA 2020.

Techincal Settings of ALV_T_T2

Below are technical details of the table ALV_T_T2

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ALV_T_T2 Fields

The following table gives you an overview of the fields available in ALV_T_T2

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientS_MANDTT000CLNT3
CARRIDAirline CodeS_CARRID_ALVALV_TABCHAR3
CONNIDFlight Connection NumberS_CONN_IDALV_CHCKNUMC4
FLDATEData Element for Field FLDATE of Table ALV_T_T2S_FL_DATE*DATS8
CARRNAMEAirline nameS_CARRNAMECHAR20
CARRID_CONVAirline CodeS_CARRID_CONV*CHAR3
PRICEAirfareS_PRICECURR15
CURRENCYLocal currency of airlineS_CURRCODEALV_CURCUKY5
PLANETYPEAircraft TypeS_PLANETYE*CHAR10
SEATSMAXMaximum capacity in economy classS_SEATSMAXINT410
SEATSOCCOccupied seats in economy classS_SEATSOCCINT410
PAYMENTSUMTotal of current bookingsS_SUMCURR17
COUNTRYFRCountry/Region KeyLAND1*CHAR3
AIRPFROMDeparture airportS_FROMAIRP*CHAR3
COUNTRYTOCountry/Region KeyLAND1*CHAR3
AIRPTODestination airportS_TOAIRP*CHAR3
FLTIMEFlight timeS_FLTIMEINT410
DEPTIMEDeparture timeS_DEP_TIMETIMS6
ARRTIMEArrival timeS_ARR_TIMETIMS6
DISTANCEDistanceS_DISTANCEQUAN9
DISTIDData Element for Field DISTID of Table ALV_T_T2S_DIST_IDT006UNIT3
PERIODArrival n day(s) laterS_PERIODINT13
FLOAT_FITest Field of Type FLOATLVC_S_FTFFLTP16
STRING_FTest Field of Type STRINGLVC_S_STFSTRG
XSTRINGTest Field of Type XSTRINGLVC_S_XSTFRSTR
INT_FIELTest Field of Type INTEGERLVC_S_ITFINT410
HEX_FIELTest Field of Type HEXLVC_S_HTFRAW2
DROPDOWN4 Byte Signed IntegerINT4INT410
TAB_INDEX4 Byte Signed IntegerINT4INT410
TIMESTAMP_SUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC15
TIMESTAMP_LUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)TZNTSTMPLDEC21
TIMEField of type TIMSTIMSTIMS6
CONV_INTS_CONV_INTS_CONV_INTINT13

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ALV_T_T2

Table NameFieldCardinalityCheck Table
ALV_T_T2CARRID:ALV_TAB
ALV_T_T2CONNID:ALV_CHCK
ALV_T_T2CURRENCY:ALV_CUR
ALV_T_T2DISTID:T006
ALV_T_T2MANDT:T000

Other References