The CNV_DERIVATION table in SAP ERP or S/4HANA stores Derivation paths of org. units for conversions data. There are total 6 fields in CNV_DERIVATION table. The Derivation paths of org. units for conversions 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 CNV_DERIVATION table. It is in Conversion: Basis functions (CNV_BASIS) ABAP package and is part of the Landscape Transformation (CA-LT) module.
SAP CNV_DERIVATION Table Fields
Following is the list of fields that are available in SAP CNV_DERIVATION table. The primary key fields of the table are MANDT (Client), OBJ1 (Conversion: Organizational unit for delimitation), OBJ2 (Conversion: Organizational unit for delimitation).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| OBJ1 | Conversion: Organizational unit for delimitation | CNV_ORG | CNV_ORG_TAB | CHAR (10) |
| OBJ2 | Conversion: Organizational unit for delimitation | CNV_ORG | CNV_ORG_TAB | CHAR (10) |
| DERIVATION | Derivation route from obj1 to obj2 | CNV_DERIV | CHAR (40) | |
| D_TYPE | Method used for derivation routing (via FM, routines,…) | CNV_DERIV_TYPE | CHAR (1) | |
| NOTATION | Comments on derivation route | CNV_NOTATION | CHAR (120) |
