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
BNAMEUser Name in User Master RecordXUBNAMECHAR12(0) Assigned to domainXUBNAMEXUS
PERSNUMBERPerson numberAD_PERSNUMCHAR10(0) ALPHAAD_PERSNUMCDTADDRESSPERSNUMBER
ADDRNUMBERAddress NumberAD_ADDRNUMCHAR10(0) Assigned to domainALPHAAD_ADDRNUMADR
SO_KEYSAP-Office keyAD_SO_KEYCHAR10(0) ALPHAAD_SO_KEYADDRESSPERSNUMBER
BUILDING_CBuilding (number or code)AD_BLDNG_PCHAR10(0) TEXT10
IH_MAILInternal Mail Postal CodeAD_IH_MAILCHAR10(0) TEXT10
NAMCOUNTRYCountry for Name Format RuleAD_NAMCTRYCHAR3(0) T005LAND1
PERSORIGINPersonal data source (key)AD_ORIGINPCHAR4(0) TSAD6AD_ORIGIN
ADDR_COMP(not used)AD_ADDRCOMCHAR10(0) ADRCALPHAAD_ADDRNUM
CITY_CODECity code for city/street fileAD_CITYNUMCHAR12(0) ADRCITYALPHACITY_CODE
CITYP_CODEDistrict code for City and Street fileAD_CITYPNMCHAR8(0) ADRCITYPRTALPHACITYP_CODE
CITYH_CODEDifferent city for city/street fileAD_CITYHNMCHAR12(0) ADRCITYALPHACITY_CODE
REGIOGROUPRegional structure groupingREGIOGROUPCHAR8(0) ADRREGGRPREGIOGROUP
POST_CODE1City postal codeAD_PSTCD1CHAR10(0) CHAR10
POST_CODE2PO Box Postal CodeAD_PSTCD2CHAR10(0) CHAR10
POST_CODE3Company Postal Code (for Large Customers)AD_PSTCD3CHAR10(0) CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 CodeAD_PST1XTCHAR10(0) CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code ExtensionAD_PST2XTCHAR10(0) CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code ExtensionAD_PST3XTCHAR10(0) CHAR10
PO_BOXPO BoxAD_POBXCHAR10(0) CHAR10
CITY_CODE2City PO box code (City file)AD_CIT2NUMCHAR12(0) ADRCITYALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...)AD_POBXREGCHAR3(0) T005SREGIO
PO_BOX_CTYPO box countryAD_POBXCTYCHAR3(0) T005LAND1
POSTALAREA(Not Supported) Post Delivery DistrictAD_PSTLARCHAR15(0) TEXT15
TRANSPZONETransportation zone to or from which the goods are deliveredLZONECHAR10(0) TZONEZONE
COUNTRYCountry KeyLAND1CHAR3(0) T005LAND1LND
REGIONRegion (State, Province, County)REGIOCHAR3(0) T005SREGIO
ADDRORIGIN(Not Supported) Address Data Source (Key)AD_ORIGINACHAR4(0) TSAD6AD_ORIGIN
TIME_ZONEAddress time zoneAD_TZONECHAR6(0) TTZZTZNZONE
TAXJURCODETax JurisdictionAD_TXJCDCHAR15(0) AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address IDAD_ADDR_IDCHAR10(0) ALPHAAD_ADDR_ID
PERS_GROUPPerson Group (Key) (Business Address Services)AD_GROUP_PCHAR4(0) Assigned to domainAD_GROUP_P
ADDR_GROUPAddress Group (Key) (Business Address Services)AD_GROUPCHAR4(0) Assigned to domainAD_GROUP
USERGUser Grouping for Travel PlanningEMPLOYEE_GROUP_TPCHAR2(0) Assigned to domainFTPD_EMPLOYEE_GROUP
OFFICE_FINDGrouping for Sales Office DeterminationOFFICE_FINDCHAR2(0) TA20OFFICE_FINDOFFICE_FIND
TRVCC_FINDPayment Method GroupingsTRVCC_FINDCHAR2(0) TA23TRVCC_FINDTRVCC_FIND
PERNRPersonnel NumberP_PERNRNUMC8(0) PERNR
BUKRSCompany CodeBUKRSCHAR4(0) T001BUKRSBUKC_T001BUKRS
WERKSPersonnel AreaPERSACHAR4(0) T500PPERSAPBR
PERSGEmployee GroupPERSGCHAR1(0) T501PERSGPRG
PERSKEmployee SubgroupPERSKCHAR2(0) T503KPERSKPKR
VDSK1Organizational KeyVDSK1CHAR14(0) T527OVDSK1
GSBERBusiness AreaGSBERCHAR4(0) TGSBGSBERGSB
BTRTLPersonnel SubareaBTRTLCHAR4(0) T001PBTRTLPBS
JUPERLegal PersonJUPERCHAR4(0) JUPER
ABKRSPayroll AreaABKRSCHAR2(0) T549AABKRSABK
ANSVHWork ContractANSVHCHAR2(0) T542AANSVH
KOSTLCost CenterKOSTLCHAR10(0) CSKSALPHAKOSTLKOS
ORGEHOrganizational UnitORGEHNUMC8(0) T527XORGEH
PLANSPositionPLANSNUMC8(0) T528BPLANS
STELLJobSTELLNUMC8(0) T513STELL
MSTBRSupervisor AreaMSTBRCHAR8(0) MSTBR
SACHAPayroll AdministratorSACHACHAR3(0) T526SACHA
SACHPAdministrator for HR Master DataSACHPCHAR3(0) T526SACHA
SACHZAdministrator for Time RecordingSACHZCHAR3(0) T526SACHA
SNAMEEmployee's Name (Sortable by LAST NAME FIRST NAME)SMNAMCHAR30(0) CHAR30
ENAMEFormatted Name of Employee or ApplicantEMNAMCHAR40(0) TEXT40
OTYPEObject TypeOTYPECHAR2(0) T778OOTYPEPOT
SBMODAdministrator GroupSBMODCHAR4(0) CHAR4SGR
KOKRSControlling AreaKOKRSCHAR4(0) TKA01CACCDCAC
FISTLFunds CenterFISTLCHAR16(0) Assigned to domainFISTLFIS
GEBERFundBP_GEBERCHAR10(0) Assigned to domainBP_GEBERFIC
FKBERFunctional AreaFKBERCHAR16(0) Assigned to domainFKBERFBE
GRANT_NBRGrantGM_GRANT_NBRCHAR20(0) ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERICGRANT_NUMBER
SGMNTSegment for Segmental ReportingFB_SEGMENTCHAR10(0) Assigned to domainALPHAFB_SEGMENT
BUDGET_PDBudget PeriodFM_BUDGET_PERIODCHAR10(0) Assigned to domainFM_BUDGET_PERIODBUDPER
PTZUOEmployee Grouping for Travel ManagementPTZUOCHAR3(0) Assigned to domainPTZUO




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!