FICODIAND_HCM

HCM information for DIAN | #transactional | Component: Financials Colombia
Column Name Description
MANDT Client
COMPANY_CODE FK Company Code
PAYROLL_FISCAL_YEAR Fiscal Year
REPORT_FORMAT FK DIAN Report Format
CONCEPT_CODE FK Report Format Item Type
TAX_NUMBER_TYPE DIAN Type of Document Show values
TAX_NUMBER Tax Number 1
CREATION_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Column Name Description
💲 Currency for DIAN (BASE_AMOUNT_CURRENCY):
BASE_AMOUNT Amount for DIAN
CALC_AMOUNT Amount for DIAN
Column Name Description
Column Name Description
_DATAAGING Data Filter Value for Data Aging
Column Name Description
TAX_NUMBER_TYPE DIAN Type of Document Show values
Column Name Description Domain name
BP_NAME_1 Name 1 TEXT40
BP_NAME_2 Name 2 TEXT40
BP_NAME_3 Name 3 TEXT40
BP_NAME_4 Name 4 TEXT40
ADDRESS Street TEXT60
CREATED_BY ABAP System Field: Name of Current User SYCHAR12
Master Data Relations Join Conditions
Currency for DIAN
  • FICODIAND_HCM.MANDT == TCURC.MANDT
  • FICODIAND_HCM.BASE_AMOUNT_CURRENCY == TCURC.WAERS
Currency for DIAN
  • FICODIAND_HCM.MANDT == TCURC.MANDT
  • FICODIAND_HCM.CALC_AMOUNT_CURRENCY == TCURC.WAERS
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
  • FICODIAND_HCM.COUNTRY == ADRCITY.COUNTRY
  • FICODIAND_HCM.MANDT == ADRCITY.CLIENT
  • FICODIAND_HCM.CITY_CODE == ADRCITY.CITY_CODE
Company Code
  • FICODIAND_HCM.MANDT == T001.MANDT
  • FICODIAND_HCM.COMPANY_CODE == T001.BUKRS
Report Format Item Type
  • Report Format Item Type
  • DIAN Report Format
  • ?
Country/Region Key
  • Country/Region Key
  • Client
  • FICODIAND_HCM.COUNTRY == T005.LAND1
  • FICODIAND_HCM.MANDT == T005.MANDT
DIAN Report Format
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • FICODIAND_HCM.MANDT == T005S.MANDT
  • FICODIAND_HCM.COUNTRY == T005S.LAND1
  • FICODIAND_HCM.STATE == T005S.BLAND