The CACS_FFLTIT table in SAP ERP or S/4HANA stores Fulfillment Level Item data. There are total 18 fields in CACS_FFLTIT table. The Fulfillment Level Item 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 CACS_FFLTIT table. It is in ICM: Basis for Trigger-Based Release (CACS2A) ABAP package and is part of the Incentive and Commission Management (ICM) (ICM) module.
SAP CACS_FFLTIT Table Fields
Following is the list of fields that are available in SAP CACS_FFLTIT table. The primary key fields of Fulfillment Level Item table in SAP are MANDT (Client), FFL_IT_YEAR (Year of Creation of Fulfillment Level Header), FFL_IT_ID (Fulfillment Level Item ID), SEQ_ID (Fulfillment Level Sequence ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| FFL_IT_YEAR | Year of Creation of Fulfillment Level Header | CACSFFLITYEAR | NUMC (4) | |
| FFL_IT_ID | Fulfillment Level Item ID | CACSFFLITID | NUMC (12) | |
| SEQ_ID | Fulfillment Level Sequence ID | CACSFFLSEQID | NUMC (4) | |
| FFL_HD_YEAR | Year of Creation of Fulfillment Level Header | CACSFFLHDYEAR | CACS_FFLTHD | NUMC (4) |
| FFL_HD_ID | Fulfillment Level Header ID | CACSFFLHDID | CACS_FFLTHD | NUMC (12) |
| RECEIVE_DATE | Date | DATUM | DATS (8) | |
| RECEIVE_TIME | Time | UZEIT | TIMS (6) | |
| IB_TYP_ID | Inbound Type | CACSIBTYPID | * | CHAR (1) |
| OTC | Object Type Class (OTC) for Logical Service | CACS_LOS_OTC | CHAR (2) | |
| TOOL | Tools for Logical Service | CACS_LOS_TOOL | CHAR (32) | |
| BUSOBJ_TYPE | Business Object Category that Triggers Commission | CACSBUSOBJTYP | * | CHAR (3) |
| BUSOBJ_ID | Identification of Triggering Business Object | CACSBUSOBJID | CHAR (30) | |
| TRI_OBJ_TYPE | Triggering Subobject Type | CACSTRIOBJ | * | CHAR (5) |
| TRI_OBJ_ID_EXT | External Identification of Triggering Subobject | CACSTRIOBJIDEXT | CHAR (36) | |
| FFL_FROM | From | CACSFROM | DATS (8) | |
| FFL_TO | To | CACSTO | DATS (8) | |
| FFL | Fulfillment Level | CACSFFL | DEC (6) |
