SAP FICODIAN_S_HCM_PAYROLL_DATA table - HCM payroll data aggregated for DIAN details in SAP

Description: Company Code
Field Name: COMPANY_CODE
Data Element: BUKRS
Data Type: CHAR
length (Dec): 4(0)
Check table: T001
Conversion Routine:
Domain Name: BUKRS
MemoryID: BUK
AppClass: FB
SHLP: C_T001
SHLP Field: BUKRS
ConvExit:

See all SAP tables containing field COMPANY_CODE

Description: Fiscal Year
Field Name: PAYROLL_FISCAL_YEAR
Data Element: GJAHR
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine: GJAHR
Domain Name: GJAHR
MemoryID: GJR
AppClass: SAP
SHLP:
SHLP Field:
ConvExit: GJAHR

See all SAP tables containing field PAYROLL_FISCAL_YEAR

Description: DIAN Report Format
Field Name: REPORT_FORMAT
Data Element: FICODIAN_REPORT_FORMAT
Data Type: CHAR
length (Dec): 6(0)
Check table: FICODIANI_FORMAT
Conversion Routine:
Domain Name: FICODIAN_REPORT_FORMAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REPORT_FORMAT

Description: Report Format Item Type
Field Name: CONCEPT_CODE
Data Element: FICODIAN_CONCEPT_CODE
Data Type: NUMC
length (Dec): 4(0)
Check table: FICODIANC_CNCPT
Conversion Routine:
Domain Name: FICODIAN_CONCEPT_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONCEPT_CODE

Description: DIAN Type of Document
Field Name: TAX_NUMBER_TYPE
Data Element: FICODIAN_DOC_TYPE
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: FICODIAN_DOC_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAX_NUMBER_TYPE

Description: Tax Number 1
Field Name: TAX_NUMBER
Data Element: STCD1
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: STCD1
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAX_NUMBER

Description: Name 1
Field Name: BP_NAME_1
Data Element: AD_NAME1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BP_NAME_1

Description: Name 2
Field Name: BP_NAME_2
Data Element: AD_NAME2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BP_NAME_2

Description: Name 3
Field Name: BP_NAME_3
Data Element: AD_NAME3
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BP_NAME_3

Description: Name 4
Field Name: BP_NAME_4
Data Element: AD_NAME4
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BP_NAME_4

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

Description: Street
Field Name: ADDRESS
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field ADDRESS

Description: City code for city/street file
Field Name: CITY_CODE
Data Element: AD_CITYNUM
Data Type: CHAR
length (Dec): 12(0)
Check table: ADRCITY
Conversion Routine: ALPHA
Domain Name: CITY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CITY_CODE

Description: Region (State, Province, County)
Field Name: STATE
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATE

Description: Amount for DIAN
Field Name: BASE_AMOUNT
Data Element: FICODIAN_AMOUNT
Data Type: CURR
length (Dec): 23(2)
Check table:
Conversion Routine:
Domain Name: WERTV12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BASE_AMOUNT

Description: Currency for DIAN
Field Name: BASE_AMOUNT_CURRENCY
Data Element: FICODIAN_CURRENCY
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BASE_AMOUNT_CURRENCY

Description: Amount for DIAN
Field Name: CALC_AMOUNT
Data Element: FICODIAN_AMOUNT
Data Type: CURR
length (Dec): 23(2)
Check table:
Conversion Routine:
Domain Name: WERTV12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CALC_AMOUNT

Description: Currency for DIAN
Field Name: CALC_AMOUNT_CURRENCY
Data Element: FICODIAN_CURRENCY
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CALC_AMOUNT_CURRENCY

Description: ABAP System Field: Name of Current User
Field Name: CREATED_BY
Data Element: SYST_UNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: SYCHAR12
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_BY