The CIAP_D_CRED_FACT table in SAP ERP or S/4HANA stores CIAP Credit Factor Table data. There are total 10 fields in CIAP_D_CRED_FACT table. The CIAP Credit Factor Table 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 CIAP_D_CRED_FACT table. It is in TMF Integration Features: CIAP (INT_TMF_CIAP) ABAP package and is part of the Tax Management Framework Integration (LO-INT-TMF) module.
SAP CIAP_D_CRED_FACT Table Fields
Following is the list of fields that are available in SAP CIAP_D_CRED_FACT table. The primary key fields of the table are MANDT (Client), COMPANY_CODE (Company Code), BUSINESS_PLACE (Business Place), PERIOD (Period (Month/Year)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR (4) |
| BUSINESS_PLACE | Business Place | J_1BBRANC_ | J_1BBRANCH | CHAR (4) |
| PERIOD | Period (Month/Year) | CIAP_PERIOD | NUMC (6) | |
| LAST_CHANGED_BY | Last Changed By | CIAP_USERNAME | CHAR (12) | |
| LAST_CHANGE_DATE | Last Changed On | CIAP_CHANGING_DATE | DATS (8) | |
| LAST_CHANGE_TIME | Last Changed At | CIAP_CHANGING_TIME | TIMS (6) | |
| CREDITED | Credited Period | CIAP_CREDITED_FLAG | CHAR (1) | |
| TOTAL_VAL_TAXABLE_SALES | Total Value of Taxable Sales | CIAP_TOTAL_VAL_TAXABLE_SALES | DEC (14) | |
| TOTAL_VAL_SALES | Total Value of Sales | CIAP_TOTAL_VAL_SALES | DEC (14) |
