SAP table TA20B (Control Variant for Travel Planning)

SAP table TA20B has 2 primary key fields being MANDT,USERG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
USERG Grouping: Travel Planning Control Variant CHAR 2 0 TP_CONTROL_TRVUS
RFCDEST Logical RFC Destination to API CHAR 32 0 RFCDES RFCDEST_API
SUBSCRIPTION GDS Identification CHAR 30 0 TA20A SUBSCRIPTION_ID
CORPORATE Corporate Identification CHAR 30 0 TA20A CORPORATE_ID
UNAME_FLAG Indicator: Use SAP User Name as GDS User User CHAR 1 0 UNAME_FLAG
USERID User Identification CHAR 30 0 USER_ID
FDISPLAY Display strategy of flight availability CHAR 1 0 FLIGHT_DISPLAY_METHOD
FFARE_STRAT Rebooking according to travel profile only CHAR 1 0 FFARE_STRATEGY
FFARE_TYPES Lowest Fare Search CHAR 1 0 FFARE_TYPES
HDISPLAY Display strategy for hotel availability CHAR 1 0 HOTEL_DISPLAY_METHOD
HDISPLAY_ROOM Room list display method CHAR 1 0 ROOMLIST_DISPLAY_METHOD
HFARE_STRAT Apply negotiated hotel rates CHAR 1 0 HFARE_STRATEGY
HCTG_ACTIVE Hotel catalog active CHAR 1 0 HOTEL_CATALOGUE_ACTIVE
HCTG_DISPLAY Hotel catalog display method CHAR 1 0 HOTEL_CATALOGUE_DISPLAY_METHOD
HCTG_DISP_ROOM Hotel catalog room list display method CHAR 1 0 HOTEL_CTG_ROOM_DISPLAY_METHOD
HCTG_NEGO_STRAT Negotiated hotel rates from hotel catalog CHAR 1 0 HOTEL_CATALOGUE_NEGO
HCTG_NEGO_CHECK Ind.: Availability check for negotiated rates CHAR 1 0 HOTEL_CATALOGUE_NEGO_CHECK
CDISPLAY Display strategy for car rental availability CHAR 1 0 CAR_DISPLAY_METHOD
CFARE_STRAT Negotiated car rental rates only (if available) CHAR 1 0 CFARE_STRATEGY
CDISPLAY_CAR Display meth. car rental list CHAR 1 0 CARLIST_DISPLAY_METHOD
CDISPLAY_MIX Provider list with best-price vehicle CHAR 1 0 CAR_DISPLAY_MIX
FRT_STRATEGY Strategy for Round Trip CHAR 1 0 ROUNDTRIP_STRATEGY
HOTEL_OPTIONS Hotel: Optional Parameter Entry CHAR 1 0 HOTEL_OPTIONS
CAR_OPTIONS Rental Car: Extended Search Possible CHAR 1 0 CAR_OPTIONS
AUTO_PRICING Setting: Automatic Airfare Determination CHAR 1 0 FLIGHT_AUTO_PRICING
HOTEL_FILTER_CAT Hotel Availability Query: Catalog before Hotel Chain Limits CHAR 1 0 HOTEL_FILTER_CAT
RT_DISPLAY_STRAT Display Strategy for Round Trip CHAR 1 0 RT_DISPLAY_STRAT
H Suitable Return Flights Only
L All Return Flights, Check After Selecting
M All Return Flights, Classified
F_LOWFARE_LIST Display Type Fare-driven Flight Availability CHAR 1 0 FLIGHT_LF_LIST
FLIGHT_RAIL_LIST Combined Display of Flight and Rail CHAR 1 0 FLIGHT_RAIL_LIST

TA20B foreign key relationships

Table Field Check Table Check Field
0 TA20B CORPORATE TA20A API Server Access Parameters MANDT
0 TA20B CORPORATE TA20A API Server Access Parameters SUBSCRIPTION
0 TA20B CORPORATE TA20A API Server Access Parameters CORPORATE
1 TA20B SUBSCRIPTION TA20A API Server Access Parameters MANDT
1 TA20B SUBSCRIPTION TA20A API Server Access Parameters SUBSCRIPTION
1 TA20B SUBSCRIPTION TA20A API Server Access Parameters CORPORATE