The FMCNAI table in SAP ERP or S/4HANA stores FM Line Items with Active CCN Logic data. There are total 12 fields in FMCNAI table. The FM Line Items with Active CCN Logic 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 FMCNAI table. It is in FIFM: Basis (FMBS) ABAP package and is part of the Funds Management (FI-FM) module.
SAP FMCNAI Table Fields
Following is the list of fields that are available in SAP FMCNAI table. The primary key fields of the table are MANDT (Client), RBELNR (Purchasing Document Number), RBUZEI (Item Number of Purchasing Document), RZEKKN (Sequential Number of Account Assignment), RETENR (Schedule Line Number), RSTUNR (Step Number), RZAEHK (Condition Counter), WRTTP (Value Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| RBELNR | Purchasing Document Number | EBELN | CHAR (10) | |
| RBUZEI | Item Number of Purchasing Document | EBELP | NUMC (5) | |
| RZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC (2) | |
| RETENR | Schedule Line Number | ETENR | NUMC (4) | |
| RSTUNR | Step Number | STUNR | NUMC (3) | |
| RZAEHK | Condition Counter | DZAEHK | NUMC (3) | |
| WRTTP | Value Type | CO_WRTTP | CHAR (2) | |
| CNACT | CCN Functionality Is Active | FM_CNACT | CHAR (1) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| UNAME | User Name | UNAME | CHAR (12) |
