The CFIN_EX_AIFCLRIT table in SAP ERP or S/4HANA stores Generated table:CFIN_EX_AIFCLRIT data. There are total 14 fields in CFIN_EX_AIFCLRIT table. The Generated table:CFIN_EX_AIFCLRIT 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 CFIN_EX_AIFCLRIT table. It is in Central Finance – External Interface (3rd Party) (FINS_CFIN_EX_INTERFACE) ABAP package and is part of the Central Finance-External Interface non-SAP systems (FI-CF-EX) module.
SAP CFIN_EX_AIFCLRIT Table Fields
Following is the list of fields that are available in SAP CFIN_EX_AIFCLRIT table. The primary key fields of the table are MANDT (Client), MSGGUID (GUID in ‘CHAR’ Format in Uppercase), NS (Namespace), IFNAME (Interface Name), IFVER (Interface Version).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| MSGGUID | GUID in ‘CHAR’ Format in Uppercase | GUID_32 | CHAR (32) | |
| NS | Namespace | /AIF/NS | /AIF/T_NS | CHAR (6) |
| IFNAME | Interface Name | /AIF/IFNAME | /AIF/T_FINF | CHAR (10) |
| IFVER | Interface Version | /AIF/IFVERSION | /AIF/T_FINF | CHAR (5) |
| UNIQUE_ID | Unique ID | FINS_CFIN_EX_UNIQUE_DOC_ID | CHAR (32) | |
| LINE_NUMBER | Line number | FINS_CFIN_EX_LINE_NUMBER | NUMC (10) | |
| ITEMNO_ACC | Accounting Document Line Item Number | POSNR_ACC | NUMC (10) | |
| DOC_LINE_NO | Item Number Within Accounting Document in Sender System | BUZEI_SENDER | NUMC (3) | |
| OPEN_ITEM_DOC_NO | Document Number of an Accounting Document in Sender System | BELNR_SENDER | CHAR (10) | |
| OPEN_ITEM_FISCAL | Fiscal Year of an Accounting Document in the Sender System | GJAHR_SENDER | NUMC (4) | |
| OPEN_ITEM_ITEMNO | Original Item Number of Open Item | FINS_CFIN_OPEN_ITEM_POSNR_ACC | NUMC (10) | |
| OPEN_ITEM_DOC_LI | Item Number Within Accounting Document in Sender System | BUZEI_SENDER | NUMC (3) | |
| SPECIAL_LEDGER_I | Special G/L Indicator | UMSKZ | CHAR (1) |
