The CFIN_AIF_PCA_SIM table in SAP ERP or S/4HANA stores Central Finance: AIF Message Key Fields data. There are total 37 fields in CFIN_AIF_PCA_SIM table. The Central Finance: AIF Message Key Fields 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_AIF_PCA_SIM table. It is in Central Finance – Profit Center Accounting (FINS_CFIN_PCA) ABAP package and is part of the Replication: EC-PCA internal postings (FI-CF-PCA) module.
SAP CFIN_AIF_PCA_SIM Table Fields
Following is the list of fields that are available in SAP CFIN_AIF_PCA_SIM table. The primary key fields of the table are MANDT (Client), MSGGUID (GUID in ‘CHAR’ Format in Uppercase).
| 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) |
| NSRECIP | Namespace | /AIF/NS | * | CHAR (6) |
| RECIPIENT | Alert Management Recipient | /AIF/ALRT_REC | * | CHAR (30) |
| STATUS | Processing Status | /AIF/PROC_STATUS | CHAR (1) | |
| SUB_STATUS | Sub status for ‘In Process’ status | /AIF/PROC_SUB_STATUS | CHAR (1) | |
| AIF_LOCATION | Message Location | /AIF/MESSAGE_LOCATION | CHAR (1) | |
| LOGNUMBER | Application log: log number | BALOGNR | * | CHAR (20) |
| TRACE_LEVEL | AIF Trace Level | /AIF/TRACE_LEVEL | CHAR (1) | |
| TL_EXP_DATE | Expiration Date | /AIF/EXP_DATE | DATS (8) | |
| TL_EXP_TIME | Expiration Time | /AIF/EXP_TIME | TIMS (6) | |
| CREATE_USER | Create User | /AIF/CREATE_USER | CHAR (12) | |
| CREATE_DATE | Creation Date | /AIF/CREATE_DATE | DATS (8) | |
| CREATE_TIME | Creation Time | /AIF/CREATE_TIME | TIMS (6) | |
| LAST_USER | Last User | /AIF/LAST_USER | CHAR (12) | |
| LAST_DATE | Last Date | /AIF/LAST_DATE | DATS (8) | |
| LAST_TIME | Last Time | /AIF/LAST_TIME | TIMS (6) | |
| END_USER | End User | /AIF/END_USER | CHAR (12) | |
| END_DATE | End Date | /AIF/END_DATE | DATS (8) | |
| END_TIME | End Time | /AIF/END_TIME | TIMS (6) | |
| AIF_ALERT_ID | External ID for an Alert | SALRTEXTID | NUMC (5) | |
| AIF_VARIANT_NS | Variant Namespace | /AIF/VARIANT_NS | CHAR (6) | |
| AIF_VARIANT_NAME | Name of Interface Variant | /AIF/VARIANT_NAME | CHAR (20) | |
| EXTERNAL_MESSAGE | Indicates source of message: internal or extenal (e.g CPI) | /AIF/EXTERNAL_MESSAGE | NUMC (2) | |
| TIME_ZONE | Time Zone | TZNZONE | * | CHAR (6) |
| PROCESSING_END_TSTMP | Message Processing Timestamp in UTC Timezone | /AIF/PROCESSING_TSTMP | DEC (15) | |
| PID | Integration Engine: Pipeline ID | SXMSPID | CHAR (40) | |
| AWTYP | Reference procedure | AWTYP | CHAR (5) | |
| AWREF | Reference document number | AWREF | CHAR (10) | |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) | |
| AWSYS | Logical system of source document | AWSYS | CHAR (10) | |
| TRANSACTION_TYPE | Data transfer to Central Finance: Transaction type | FIN_CFIN_TRANSACTION_TYPE | CHAR (1) | |
| TIMESTAMP | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | TZNTSTMPL | DEC (21) | |
| USNAM | Actual Operator | FINS_CFIN_OPERATOR | CHAR (12) |
