T7CO01

Additional data of the company | #masterdata | Component: Colombia
Column Name Description
MANDT Client
BUKRS Company Code
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
TYPID Identification type Show values
CLACO Defines the contributor type Show values
BUKTY Company type Show values
BUPER Person type Show values
PRESE Presentation form Show values
PCEPS Period of contribution to health plans Show values
PCAFP Period of contribution to pension Show values
TPAGP Pension payer type Show values
TYPAP Contributor type Show values
ECREE Contributor exempt of parafiscal contribution payment Show values
NEW_TYPAP Contributor type Show values
CSCON Company special condition Show values
Column Name Description Domain name
BUTXT Company code name TEXT50
REPLE Name of legal representative
REPPY Payroll person responsible TEXT40
TELNR Payroll telephone number CHAR20
FAXNR Fax number, payroll CHAR20
ADRES Address TEXT50
NITNR Real NIT code CHAR12
DIGNR Check digit NUMC01
PATNR Employer registration number CHAR15
PORIM Interest on arrears percentage DEC7_4
EMAIL E-mail TEXT60
PCFIA Magnetic media, Integrated Electronic Form LOCALFILE
Master Data Relations Join Conditions
Absence type - Leave
  • Absence type - Leave
  • Client
  • ?
  • ?
  • T7CO01.AWART == T554S.SUBTY
  • T7CO01.MANDT == T554S.MANDT
  • T7CO01.[column in domain "MOABW"] == T554S.MOABW
  • T7CO01.[column in domain "ENDDA"] == T554S.ENDDA
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T7CO01.MANDT == T005S.MANDT
  • T7CO01.LAND1 == T005S.LAND1
  • T7CO01.BLAND == T005S.BLAND
Social Insurance branch
  • Company Code
  • Client
  • Social Insurance branch
City ID
  • City ID
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • T7CO01.CITYC == T005P.FPRCD
  • T7CO01.MANDT == T005P.MANDT
  • T7CO01.LAND1 == T005P.LAND1
  • T7CO01.BLAND == T005P.BLAND
ESAP entity ID
  • T7CO01.MANDT == LFA1.MANDT
  • T7CO01.EESAP == LFA1.LIFNR
ICBF entity ID
  • T7CO01.MANDT == LFA1.MANDT
  • T7CO01.EICBF == LFA1.LIFNR
Ministry of Education ID
  • T7CO01.MANDT == LFA1.MANDT
  • T7CO01.EMEDU == LFA1.LIFNR
Administrating entity ID of occupational risks
  • T7CO01.MANDT == LFA1.MANDT
  • T7CO01.ENARP == LFA1.LIFNR
SENA entity ID
  • T7CO01.MANDT == LFA1.MANDT
  • T7CO01.ESENA == LFA1.LIFNR
Information operator
Country/Region Key
  • Country/Region Key
  • Client
  • T7CO01.LAND1 == T005.LAND1
  • T7CO01.MANDT == T005.MANDT