SAP table TA20OFFICE (Reservation System-Specific Sales Offices)

SAP table TA20OFFICE has 3 primary key fields being MANDT,GDS,OFFICE.

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
GDS Reservation System CHAR 3 0 TA21P RESERVATION_SYSTEM
OFFICE Sales Office CHAR 12 0 OFFICE
LAND Country/Region Key CHAR 3 0 T005 LAND1
VIRTUAL Indicator: Virtual Sales Office CHAR 1 0 VIRTUAL
Real Sales Office
X Virtual Sales Office
SET_TKTL Ticket Element Flag: Create TKTL CHAR 1 0 SET_TKTL_FLAG
BOOKING_SOURCE Identification for booking/reservations CHAR 40 0 BOOKING_SOURCE
ON_HOLD_ALLOWED On-Hold Booking Allowed for Sales Office (Indicator) CHAR 1 0 ON_HOLD_ALLOWED
CREDENTIAL Access ID CHAR 30 0 CREDENTIAL
PROFILE_PASSWORD Access ID for Profile Synchronization CHAR 30 0 PROFILE_CREDENTIAL

TA20OFFICE foreign key relationships

Table Field Check Table Check Field
0 TA20OFFICE GDS TA21P Travel Service Providers MANDT
0 TA20OFFICE GDS TA21P Travel Service Providers CATEGORY
0 TA20OFFICE GDS TA21P Travel Service Providers PROVIDER
1 TA20OFFICE LAND T005 Countries MANDT
1 TA20OFFICE LAND T005 Countries LAND1