SAP Table TA20OFFICE

Reservation System-Specific Sales Offices

TA20OFFICE (Reservation System-Specific Sales Offices) 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 TA20OFFICE to other SAP tables.

Source: TA20OFFICE (Reservation System-Specific Sales Offices)

TA20OFFICE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
GDS Reservation System RESERVATION_SYSTEM TA21P CHAR 3 0
OFFICE Sales Office OFFICE CHAR 12 0
LAND Country Key LAND1 T005 CHAR 3 0
VIRTUAL Indicator: Virtual Sales Office VIRTUAL CHAR 1 0
NULL Real Sales Office
X Virtual Sales Office
SET_TKTL Ticket Element Flag: Create TKTL SET_TKTL_FLAG CHAR 1 0
NULL Not Selected
X Selected
BOOKING_SOURCE Identification for booking/reservations BOOKING_SOURCE CHAR 40 0
ON_HOLD_ALLOWED On-Hold Booking Allowed for Sales Office (Indicator) ON_HOLD_ALLOWED CHAR 1 0
CREDENTIAL Access ID CREDENTIAL CHAR 30 0
PROFILE_PASSWORD Access ID for Profile Synchronization PROFILE_CREDENTIAL CHAR 30 0

TA20OFFICE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TA20OFFICE GDS TA20OFFICE MANDT TA21P Travel Service Providers MANDT
TA20OFFICE GDS 'R' TA21P Travel Service Providers CATEGORY
TA20OFFICE GDS TA20OFFICE GDS TA21P Travel Service Providers PROVIDER
TA20OFFICE LAND TA20OFFICE MANDT T005 Countries MANDT
TA20OFFICE LAND TA20OFFICE LAND T005 Countries LAND1