SAP Table TA20B

Control Variant for Travel Planning

TA20B (Control Variant for Travel Planning) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TA20B to other SAP tables.

TA20B table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
USERG Grouping: Travel Planning Control Variant TP_CONTROL_TRVUS CHAR 2 0
RFCDEST Logical RFC Destination to API RFCDEST_API RFCDES CHAR 32 0
SUBSCRIPTION GDS Identification SUBSCRIPTION_ID TA20A CHAR 30 0
CORPORATE Corporate Identification CORPORATE_ID TA20A CHAR 30 0
UNAME_FLAG Indicator: Use SAP User Name as GDS User User UNAME_FLAG CHAR 1 0
NULL Not Selected
X Selected
USERID User Identification USER_ID CHAR 30 0
FDISPLAY Display strategy of flight availability FLIGHT_DISPLAY_METHOD CHAR 1 0
NULL Neutral
M Profile view with all priorities
S Profile view with highest priority only
FFARE_STRAT Rebooking according to travel profile only FFARE_STRATEGY CHAR 1 0
NULL Not Selected
X Selected
FFARE_TYPES Lowest Fare Search FFARE_TYPES CHAR 1 0
NULL Inactive
1 Active, Without Travel Profile Check
2 Active, with Travel Profile Check
3 Active, with Settings for Fare-Driven Availability Query
4 Active, with Settings for Profile-Controlled Filter
5 Standard, Without Travel Profile Check
6 Standard, with Travel Profile Check
7 Standard, with Settings for Fare-Driven Availability Query
8 Mandatory, Without Travel Profile Check
9 Mandatory, with Travel Profile Check
A Mandatory, with Settings for Fare-Driven Availability Query
HDISPLAY Display strategy for hotel availability HOTEL_DISPLAY_METHOD CHAR 1 0
NULL Neutral
M Profile view with all priorities
S Profile view with highest priority only
HDISPLAY_ROOM Room list display method ROOMLIST_DISPLAY_METHOD CHAR 1 0
NULL Not Selected
X Selected
HFARE_STRAT Apply negotiated hotel rates HFARE_STRATEGY CHAR 1 0
NULL Not Selected
X Selected
HCTG_ACTIVE Hotel catalog active HOTEL_CATALOGUE_ACTIVE CHAR 1 0
NULL Not Selected
X Selected
HCTG_DISPLAY Hotel catalog display method HOTEL_CATALOGUE_DISPLAY_METHOD CHAR 1 0
NULL Neutral
M Profile view with all priorities
S Profile view with highest priority only
HCTG_DISP_ROOM Hotel catalog room list display method HOTEL_CTG_ROOM_DISPLAY_METHOD CHAR 1 0
NULL Not Selected
X Selected
HCTG_NEGO_STRAT Negotiated hotel rates from hotel catalog HOTEL_CATALOGUE_NEGO CHAR 1 0
NULL Not Selected
X Selected
HCTG_NEGO_CHECK Ind.: Availability check for negotiated rates HOTEL_CATALOGUE_NEGO_CHECK CHAR 1 0
NULL Not Selected
X Selected
CDISPLAY Display strategy for car rental availability CAR_DISPLAY_METHOD CHAR 1 0
NULL Neutral
M Profile view with all priorities
S Profile view with highest priority only
CFARE_STRAT Negotiated car rental rates only (if available) CFARE_STRATEGY CHAR 1 0
NULL Not Selected
X Selected
CDISPLAY_CAR Display meth. car rental list CARLIST_DISPLAY_METHOD CHAR 1 0
NULL Not Selected
X Selected
CDISPLAY_MIX Provider list with best-price vehicle CAR_DISPLAY_MIX CHAR 1 0
NULL Not Selected
X Selected
FRT_STRATEGY Strategy for Round Trip ROUNDTRIP_STRATEGY CHAR 1 0
NULL Neutral
A Same provider round trip
B Same operating airline
C Same cabin class
D Same provider and cabin
E Same operating airline and cabin
HOTEL_OPTIONS Hotel: Optional Parameter Entry HOTEL_OPTIONS CHAR 1 0
NULL Not Selected
X Selected
CAR_OPTIONS Rental Car: Extended Search Possible CAR_OPTIONS CHAR 1 0
NULL Not Selected
X Selected
AUTO_PRICING Setting: Automatic Airfare Determination FLIGHT_AUTO_PRICING CHAR 1 0
NULL Inactive
P After flight selection
B After flight selection with 'Best Price'
R Query at booking
HOTEL_FILTER_CAT Hotel Availability Query: Catalog before Hotel Chain Limits HOTEL_FILTER_CAT CHAR 1 0
X TRUE
NULL FALSE
RT_DISPLAY_STRAT Display Strategy for Round Trip RT_DISPLAY_STRAT CHAR 1 0
L All Return Flights, Check After Selecting
M All Return Flights, Classified
H Suitable Return Flights Only
F_LOWFARE_LIST Display Type Fare-driven Flight Availability FLIGHT_LF_LIST CHAR 1 0
C Classic; by Flight Recommendations
G By Price Groups
M Matrix and Classic, by Flight Recommendations
N Matrix and by Price Groups
FLIGHT_RAIL_LIST Combined Display of Flight and Rail FLIGHT_RAIL_LIST CHAR 1 0
NULL Display Not Combined
U User-controlled Combined Display
R Rule-controlled Combined Display
X User- and Rule-controlled Combined Display

TA20B foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TA20B CORPORATE TA20B CORPORATE TA20A API Server Access Parameters CORPORATE
TA20B CORPORATE TA20B MANDT TA20A API Server Access Parameters MANDT
TA20B CORPORATE TA20B SUBSCRIPTION TA20A API Server Access Parameters SUBSCRIPTION
TA20B RFCDEST TA20B RFCDEST RFCDES Destination table for Remote Function Call RFCDEST
TA20B SUBSCRIPTION TA20B MANDT TA20A API Server Access Parameters MANDT
TA20B SUBSCRIPTION TA20B SUBSCRIPTION TA20A API Server Access Parameters SUBSCRIPTION
TA20B SUBSCRIPTION * TA20A API Server Access Parameters CORPORATE