TRVTC SAP (Structure for Feature TRVOF) Structure details
Description: Structure for Feature TRVOF
Structure field list including key, data, relationships and ABAP select examples
TRVTC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for Feature TRVOF" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_TRVTC TYPE TRVTC.
The TRVTC table consists of various fields, each holding specific information or linking keys about Structure for Feature TRVOF data available in SAP. These include BNAME (User Name in User Master Record), PERSNUMBER (Person number), ADDRNUMBER (Address number), SO_KEY (SAP-Office key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TRVTC structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
BNAME | User Name in User Master Record | XUBNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
SO_KEY | SAP-Office key | AD_SO_KEY | CHAR | 10 | ALPHA | AD_SO_KEY | ADDRESS | ||
BUILDING_C | Building (number or code) | AD_BLDNG_P | CHAR | 10 | TEXT10 | ||||
IH_MAIL | Int. mail postal code | AD_IH_MAIL | CHAR | 10 | TEXT10 | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | T005 | LAND1 | |||
PERSORIGIN | Personal data source (key) | AD_ORIGINP | CHAR | 4 | TSAD6 | AD_ORIGIN | |||
ADDR_COMP | (not used) | AD_ADDRCOM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ADRCITYPRT | ALPHA | CITYP_CODE | ||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | ADRREGGRP | REGIOGROUP | |||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | T005S | REGIO | |||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | T005 | LAND1 | |||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | TZONE | ZONE | |||
COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | TSAD6 | AD_ORIGIN | |||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TTZZ | TZNZONE | |||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | CHAR | 4 | Assigned to domain | AD_GROUP_P | |||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4 | Assigned to domain | AD_GROUP | |||
USERG | User Grouping for Travel Planning | EMPLOYEE_GROUP_TP | CHAR | 2 | Assigned to domain | FTPD_EMPLOYEE_GROUP | |||
OFFICE_FIND | Grouping for Sales Office Determination | OFFICE_FIND | CHAR | 2 | TA20OFFICE_FIND | OFFICE_FIND | |||
PERNR | Personnel Number | P_PERNR | NUMC | 8 | PERNR | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
WERKS | Personnel Area | PERSA | CHAR | 4 | T500P | PERSA | PBR | ||
PERSG | Employee Group | PERSG | CHAR | 1 | T501 | PERSG | PRG | ||
PERSK | Employee Subgroup | PERSK | CHAR | 2 | T503K | PERSK | PKR | ||
VDSK1 | Organizational Key | VDSK1 | CHAR | 14 | T527O | VDSK1 | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
BTRTL | Personnel Subarea | BTRTL | CHAR | 4 | T001P | BTRTL | PBS | ||
JUPER | Legal Person | JUPER | CHAR | 4 | JUPER | ||||
ABKRS | Payroll Area | ABKRS | CHAR | 2 | T549A | ABKRS | ABK | ||
ANSVH | Work Contract | ANSVH | CHAR | 2 | T542A | ANSVH | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
ORGEH | Organizational Unit | ORGEH | NUMC | 8 | T527X | ORGEH | |||
PLANS | Position | PLANS | NUMC | 8 | T528B | PLANS | |||
STELL | Job | STELL | NUMC | 8 | T513 | STELL | |||
MSTBR | Supervisor Area | MSTBR | CHAR | 8 | MSTBR | ||||
SACHA | Payroll Administrator | SACHA | CHAR | 3 | T526 | SACHA | |||
SACHP | Administrator for HR Master Data | SACHP | CHAR | 3 | T526 | SACHA | |||
SACHZ | Administrator for Time Recording | SACHZ | CHAR | 3 | T526 | SACHA | |||
SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | SMNAM | CHAR | 30 | CHAR30 | ||||
ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40 | TEXT40 | ||||
OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
SBMOD | Administrator Group | SBMOD | CHAR | 4 | CHAR4 | SGR | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
SGMNT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
PTZUO | Employee Grouping for Travel Management | PTZUO | CHAR | 3 | Assigned to domain | PTZUO | |||
TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
PROFILE_NAME | Amadeus Profile | CUSTOMER_PROFILE_NAME | CHAR | 20 | TA23CT | FTPD_CUSTOMER_PROFILE_NAME |
Key field | Non-key field |
How do I retrieve data from SAP structure TRVTC using ABAP code?
As TRVTC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TRVTC as there is no data to select.How to access SAP table TRVTC
Within an ECC or HANA version of SAP you can also view further information about TRVTC and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects