FICODIAND_HCM - HCM information for DIAN
HCM information for DIAN information is stored in SAP table FICODIAND_HCM.
It is part of development package GLO_FIN_IS_CO_HCM in software component FI-LOC-FI-CO. This development package consists of objects that can be grouped under "Glob. Financials Inf. System HCM Integration for DIAN".
It is part of development package GLO_FIN_IS_CO_HCM in software component FI-LOC-FI-CO. This development package consists of objects that can be grouped under "Glob. Financials Inf. System HCM Integration for DIAN".
Fields for table FICODIAND_HCM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | X | FICODIAN_S_HCM_PAYROLL_KEY | 0 | |||
| COMPANY_CODE | Company Code | X | BUKRS | CHAR | 8 | T001 |
| PAYROLL_FISCAL_YEAR | Fiscal Year | X | GJAHR | NUMC | 8 | |
| REPORT_FORMAT | DIAN Report Format | X | FICODIAN_REPORT_FORMAT | CHAR | 12 | FICODIANI_FORMAT |
| CONCEPT_CODE | Report Format Item Type | X | FICODIAN_CONCEPT_CODE | NUMC | 8 | FICODIANC_CNCPT |
| TAX_NUMBER_TYPE | DIAN Type of Document | X | FICODIAN_DOC_TYPE | NUMC | 4 | |
| TAX_NUMBER | Tax Number 1 | X | STCD1 | CHAR | 32 | |
| CREATION_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | X | TIMESTAMP | DEC | 8 | |
| .INCLUDE | FICODIAN_S_HCM_PAYROLL_BODY | 0 | ||||
| BP_NAME_1 | Name 1 | AD_NAME1 | CHAR | 80 | ||
| BP_NAME_2 | Name 2 | AD_NAME2 | CHAR | 80 | ||
| BP_NAME_3 | Name 3 | AD_NAME3 | CHAR | 80 | ||
| BP_NAME_4 | Name 4 | AD_NAME4 | CHAR | 80 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | T005 | |
| ADDRESS | Street | AD_STREET | CHAR | 120 | ||
| CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 24 | ADRCITY | |
| STATE | Region (State, Province, County) | REGIO | CHAR | 6 | T005S | |
| BASE_AMOUNT | Amount for DIAN | FICODIAN_AMOUNT | CURR | 12 | ||
| BASE_AMOUNT_CURRENCY | Currency for DIAN | FICODIAN_CURRENCY | CUKY | 10 | TCURC | |
| CALC_AMOUNT | Amount for DIAN | FICODIAN_AMOUNT | CURR | 12 | ||
| CALC_AMOUNT_CURRENCY | Currency for DIAN | FICODIAN_CURRENCY | CUKY | 10 | TCURC | |
| CREATED_BY | ABAP System Field: Name of Current User | SYST_UNAME | CHAR | 24 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |