SAP CNVFIELDREF Table – Assignment of fields to organizational units

The CNVFIELDREF table in SAP ERP or S/4HANA stores Assignment of fields to organizational units data. There are total 9 fields in CNVFIELDREF table. The Assignment of fields to organizational units table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CNVFIELDREF table. It is in Conversion: Basis functions (CNV_BASIS) ABAP package and is part of the Landscape Transformation (CA-LT) module.

SAP CNVFIELDREF Table Fields

Following is the list of fields that are available in SAP CNVFIELDREF table. The primary key fields of the table are MANDT (Client), TABNAME (Table Name), FIELDNAME (Field Name), DERIVATIONTYPE (Conversion: Organizational unit for delimitation).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT (3)
TABNAME Table Name TABNAME DD02L CHAR (30)
FIELDNAME Field Name FIELDNAME DD03L CHAR (30)
DERIVATIONTYPE Conversion: Organizational unit for delimitation CNV_ORG CNV_ORG_TAB CHAR (10)
STATE Entry status CNV_STATUS CHAR (1)
DOMNAME Domain name DOMNAME CNVDOMS CHAR (30)
SELECTIONTYPE Conversion: Organizational unit for delimitation CNV_ORG CNV_ORG_TAB CHAR (10)
SELECTIONMODE Conversion: Control for the selection CNV_SEL_MODE CHAR (1)
SELECTION Conversion: Selection via field / routine / module CNV_SELECTION CHAR (30)