SAP TRVCC Table in S/4 HANA - Structure for Characteristic TRVCC
TRVCC is a standard SAP Table which is used to store Structure for Characteristic TRVCC data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TRVCC table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: TRVCC
TRVCC table structure field list
Below is the full TRVCC field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
BNAME | User Name in User Master Record | XUBNAME | CHAR | 12(0) | Assigned to domain | XUBNAME | XUS | |||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10(0) | ALPHA | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | |
ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR | 10(0) | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | ||
SO_KEY | SAP-Office key | AD_SO_KEY | CHAR | 10(0) | ALPHA | AD_SO_KEY | ADDRESS | PERSNUMBER | ||
BUILDING_C | Building (number or code) | AD_BLDNG_P | CHAR | 10(0) | TEXT10 | |||||
IH_MAIL | Internal Mail Postal Code | AD_IH_MAIL | CHAR | 10(0) | TEXT10 | |||||
NAMCOUNTRY | Country for Name Format Rule | AD_NAMCTRY | CHAR | 3(0) | T005 | LAND1 | ||||
PERSORIGIN | Personal data source (key) | AD_ORIGINP | CHAR | 4(0) | TSAD6 | AD_ORIGIN | ||||
ADDR_COMP | (not used) | AD_ADDRCOM | CHAR | 10(0) | ADRC | ALPHA | AD_ADDRNUM | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8(0) | ADRCITYPRT | ALPHA | CITYP_CODE | |||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8(0) | ADRREGGRP | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10(0) | CHAR10 | |||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10(0) | CHAR10 | |||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10(0) | CHAR10 | |||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10(0) | CHAR10 | |||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10(0) | CHAR10 | |||||
PO_BOX | PO Box | AD_POBX | CHAR | 10(0) | CHAR10 | |||||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3(0) | T005S | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3(0) | T005 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15(0) | TEXT15 | |||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10(0) | TZONE | ZONE | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
REGION | Region (State, Province, County) | REGIO | CHAR | 3(0) | T005S | REGIO | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4(0) | TSAD6 | AD_ORIGIN | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6(0) | TTZZ | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15(0) | AD_TXJCD | TXJ | ||||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10(0) | ALPHA | AD_ADDR_ID | ||||
PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | CHAR | 4(0) | Assigned to domain | AD_GROUP_P | ||||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4(0) | Assigned to domain | AD_GROUP | ||||
USERG | User Grouping for Travel Planning | EMPLOYEE_GROUP_TP | CHAR | 2(0) | Assigned to domain | FTPD_EMPLOYEE_GROUP | ||||
OFFICE_FIND | Grouping for Sales Office Determination | OFFICE_FIND | CHAR | 2(0) | TA20OFFICE_FIND | OFFICE_FIND | ||||
TRVCC_FIND | Payment Method Groupings | TRVCC_FIND | CHAR | 2(0) | TA23TRVCC_FIND | TRVCC_FIND | ||||
PERNR | Personnel Number | P_PERNR | NUMC | 8(0) | PERNR | |||||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
WERKS | Personnel Area | PERSA | CHAR | 4(0) | T500P | PERSA | PBR | |||
PERSG | Employee Group | PERSG | CHAR | 1(0) | T501 | PERSG | PRG | |||
PERSK | Employee Subgroup | PERSK | CHAR | 2(0) | T503K | PERSK | PKR | |||
VDSK1 | Organizational Key | VDSK1 | CHAR | 14(0) | T527O | VDSK1 | ||||
GSBER | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
BTRTL | Personnel Subarea | BTRTL | CHAR | 4(0) | T001P | BTRTL | PBS | |||
JUPER | Legal Person | JUPER | CHAR | 4(0) | JUPER | |||||
ABKRS | Payroll Area | ABKRS | CHAR | 2(0) | T549A | ABKRS | ABK | |||
ANSVH | Work Contract | ANSVH | CHAR | 2(0) | T542A | ANSVH | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10(0) | CSKS | ALPHA | KOSTL | KOS | ||
ORGEH | Organizational Unit | ORGEH | NUMC | 8(0) | T527X | ORGEH | ||||
PLANS | Position | PLANS | NUMC | 8(0) | T528B | PLANS | ||||
STELL | Job | STELL | NUMC | 8(0) | T513 | STELL | ||||
MSTBR | Supervisor Area | MSTBR | CHAR | 8(0) | MSTBR | |||||
SACHA | Payroll Administrator | SACHA | CHAR | 3(0) | T526 | SACHA | ||||
SACHP | Administrator for HR Master Data | SACHP | CHAR | 3(0) | T526 | SACHA | ||||
SACHZ | Administrator for Time Recording | SACHZ | CHAR | 3(0) | T526 | SACHA | ||||
SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | SMNAM | CHAR | 30(0) | CHAR30 | |||||
ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40(0) | TEXT40 | |||||
OTYPE | Object Type | OTYPE | CHAR | 2(0) | T778O | OTYPE | POT | |||
SBMOD | Administrator Group | SBMOD | CHAR | 4(0) | CHAR4 | SGR | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4(0) | TKA01 | CACCD | CAC | |||
FISTL | Funds Center | FISTL | CHAR | 16(0) | Assigned to domain | FISTL | FIS | |||
GEBER | Fund | BP_GEBER | CHAR | 10(0) | Assigned to domain | BP_GEBER | FIC | |||
FKBER | Functional Area | FKBER | CHAR | 16(0) | Assigned to domain | FKBER | FBE | |||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20(0) | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | GRANT_NUMBER | |
SGMNT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10(0) | Assigned to domain | ALPHA | FB_SEGMENT | |||
BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | CHAR | 10(0) | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | |||
PTZUO | Employee Grouping for Travel Management | PTZUO | CHAR | 3(0) | Assigned to domain | PTZUO |
Search for further information about these or an SAP related objects