The FINACITFXA table in SAP ERP or S/4HANA stores Line Item in Asset Journal data. There are total 42 fields in FINACITFXA table. The Line Item in Asset Journal 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 FINACITFXA table. It is in Structue of Accounting Document (FINB_ACC_DOCUMENT) ABAP package and is part of the Accounting Engine (FIN-BAC-AE) module.
SAP FINACITFXA Table Fields
Following is the list of fields that are available in SAP FINACITFXA table. The primary key fields of the table are CLIENT (Client), FIN_TECHDOCNO (Technical Identifier of a Document), FIN_ITEMNO (Line Item Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| FIN_TECHDOCNO | Technical Identifier of a Document | FIN_TECHDOCNO | CHAR (22) | |
| FIN_ITEMNO | Line Item Number | FIN_ITEMNO | NUMC (6) | |
| FIN_GLITEMNO | Item Number of General Ledger Document | FIN_GLITEMNO | NUMC (6) | |
| FIN_DRCRIND | Debit/Credit Indicator | FIN_DRCRIND | CHAR (1) | |
| FIN_GLACCT | G/L Account | FIN_GLACCT | * | CHAR (10) |
| FIN_GLIND | Relevant for General Ledger | FIN_GLIND | CHAR (1) | |
| FIN_ITEMTEXT | Document Item Text | FIN_ITEMTEXT | CHAR (50) | |
| FIN_SEGMENT | Segment | FIN_SEGMENT | CHAR (22) | |
| FIN_PROFITCTR | Profit Center | FIN_PROFITCTR | * | CHAR (22) |
| FIN_FUNCAREA | Functional Area | FIN_FUNCAREA | * | CHAR (16) |
| FIN_SEGMENT_P | Partner Segment | FIN_SEGMENT_P | CHAR (22) | |
| FIN_PROFITCTR_P | Partner Profit Center | FIN_PROFITCTR_P | * | CHAR (22) |
| FIN_FUNCAREA_P | Partner Functional Area | FIN_FUNCAREA_P | * | CHAR (16) |
| FIN_AMTTRA | Amount in Transaction Currency | FIN_AMTTRA | CURR (23) | |
| FIN_CURRTRA | Transaction Currency | FIN_CURRTRA | * | CUKY (5) |
| FIN_AMTCOMP | Amount in Local Currency | FIN_AMTCOMP | CURR (23) | |
| FIN_CURRCOMP | Local Currency | FIN_CURRCOMP | * | CUKY (5) |
| FIN_AMTACCSYS | Amount in Accounting System Currency | FIN_AMTACCSYS | CURR (23) | |
| FIN_CURRACCSYS | Accounting System Currency | FIN_CURRACCSYS | * | CUKY (5) |
| FIN_AMTHARD | Amount in Hard Currency | FIN_AMTHARD | CURR (23) | |
| FIN_CURRHARD | Hard Currency | FIN_CURRHARD | * | CUKY (5) |
| FIN_AMTINDEX | Amount in Index-Based Currency | FIN_AMTINDEX | CURR (23) | |
| FIN_CURRINDEX | Index-Based Currency | FIN_CURRINDEX | * | CUKY (5) |
| FIN_AMTCOMPGLOB | Amount in Global Company Currency | FIN_AMTCOMPGLOB | CURR (23) | |
| FIN_CURRCOMPGLOB | Global Company Currency | FIN_CURRCOMPGLOB | * | CUKY (5) |
| FIN_EEW_AMTAMT | Extension Include for Additional Currencies | FIN_EEW_AMT | CHAR (1) | |
| FIN_QTYGL | Quantity in General Ledger | FIN_QTYGL | QUAN (23) | |
| FIN_UOMGL | Unit of Measure for General Ledger | FIN_UOMGL | * | UNIT (3) |
| FIN_ITEMSIGN | +/- Sign for a Line Item | FIN_ITEMSIGN | CHAR (1) | |
| FIN_POSTYPE | Item Category | FIN_POSTYPE | * | CHAR (5) |
| FIN_JOURNAL | Journal | FIN_JOURNAL | * | CHAR (8) |
| FIN_GLTRATYPE | Transaction Type for General Ledger | FIN_GLTRATYPE | * | CHAR (5) |
| FIN_EEW_ACIT | Extension Point for Item of ACC Document | FIN_EEW_ACIT | CHAR (1) | |
| FOBJ_TYPE_NAME | Name of an Object Type | FOBJ_TYPE_NAME | CHAR (10) | |
| FOBJ_OBJECT_ID | Object ID | FOBJ_OBJECT_ID | RAW (16) | |
| FOBJ_TYPE_NAME_P | Name of Partner Object Type | FOBJ_TYPE_NAME_P | CHAR (10) | |
| FOBJ_OBJECT_ID_P | Partner Object ID | FOBJ_OBJECT_ID_P | RAW (16) | |
| FIN_QTYVAL | Valuation Quantity | FIN_QTYVAL | QUAN (23) | |
| FIN_UOMVAL | Valuation Unit of Measure | FIN_UOMVAL | * | UNIT (3) |
| FIN_EEW_ACITFXA | Extension Point for LI in Asset Journal | FIN_EEW_ACITFXA | CHAR (1) | |
| FIN_EEW_ACITFXAR | Extension Point for Reporting in Asset Journal | FIN_EEW_ACITFXAR | CHAR (1) |
