The CIAP_D_RECORD table in SAP ERP or S/4HANA stores CIAP Record data. There are total 80 fields in CIAP_D_RECORD table. The CIAP Record 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_RECORD 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_RECORD Table Fields
Following is the list of fields that are available in SAP CIAP_D_RECORD table. The primary key fields of the table are MANDT (Client), ID (CIAP Record Unique ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| ID | CIAP Record Unique ID | CIAP_RECORD_ID | RAW (16) | |
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR (4) |
| BRANCH | Business Place | J_1BBRANC_ | J_1BBRANCH | CHAR (4) |
| MATERIAL_NUMBER | Material Number | MATNR | MARA | CHAR (40) |
| CREATION_DATE | Creation Date | CIAP_CREATION_DATE | DATS (8) | |
| STATUS | CIAP Record Status | CIAP_RECORD_STATUS | CHAR (2) | |
| QUOTAS_QUANTITY | Quota Number | CIAP_QUOTA_NUMBER | NUMC (4) | |
| LAST_DETERMINATION | Period (Month/Year) | CIAP_PERIOD | NUMC (6) | |
| WBS | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC (8) |
| INTERNAL_ORDER | Order Number | AUFNR | AUFK | CHAR (12) |
| FINAL_ASSET | Finalized Asset | CIAP_FINAL_ASSET | CHAR (1) | |
| ASSET_ID | Main Asset Number | ANLN1 | IFIMASTFIXASSET | CHAR (12) |
| ASSET_SUBNUMBER | Asset Subnumber | ANLN2 | IFIXASSET | CHAR (4) |
| GOODS_VALUE | Goods Value | CIAP_GOODS_VALUE | DEC (22) | |
| ICMS_BASE | ICMS Base | CIAP_ICMS_BASE | DEC (22) | |
| ICMS_VALUE | ICMS Value | CIAP_ICMS_VALUE | DEC (22) | |
| ICMS_SUB_TRIB | Substituição Tributária Value | CIAP_SUB_TRIB_VALUE | DEC (22) | |
| ICMS_DIFAL | DIFAL Value | CIAP_DIFAL_VALUE | DEC (22) | |
| ICMS_FREIGHT_VALUE | Freight ICMS Value | CIAP_FREIGHT_ICMS_VALUE | DEC (22) | |
| ICMS_FREIGHT_SUB_TRIB | Substituição Tributária Value | CIAP_SUB_TRIB_VALUE | DEC (22) | |
| ICMS_FREIGHT_DIFAL | DIFAL Value | CIAP_DIFAL_VALUE | DEC (22) | |
| ICMS_TOTAL | ICMS Total Value | CIAP_ICMS_TOTAL_VALUE | DEC (22) | |
| ICMS_TO_CREDIT | ICMS to Credit Value | CIAP_ICMS_TO_CREDIT | DEC (22) | |
| ICMS_NOT_CREDITED | ICMS not Credited | CIAP_ICMS_NOT_CREDITED | DEC (22) | |
| ICMS_CREDITED | ICMS Credited Value | CIAP_ICMS_CREDITED | DEC (22) | |
| CURRENCY | Currency | CIAP_CURRENCY | TCURC | CUKY (5) |
| CREATED_BY | Created By | CIAP_CREATED_BY_USERNAME | CHAR (12) | |
| LAST_CHANGED_BY | Last Changed By | CIAP_CHANGED_BY_USERNAME | CHAR (12) | |
| LAST_CHANGE_DATE | Last Changed On | CIAP_CHANGING_DATE | DATS (8) | |
| RETIREMENT_DATE | Retirement Date | CIAP_RETIREMENT_DATE | DATS (8) | |
| MANUAL | CIAP Manual Record | CIAP_RECORD_MANUAL | CHAR (1) | |
| LEGACY_QUOTAS_QUANTITY | Credited Legacy Quotas | CIAP_QUOTA_LEGACY_NUMBER | NUMC (4) | |
| QUANTITY | Quantity | J_1BNETQTY | QUAN (13) | |
| UNIT_MEASURE | Base unit of measure | J_1BNETUNT | UNIT (3) | |
| IN_TRANSIT | Record in Transit | CIAP_IN_TRANSIT | CHAR (1) | |
| GLACCOUNT | G/L Account Number | SAKNR | SKA1 | CHAR (10) |
| RETIREMENT_OPERATION | Retirement Operation | CIAP_RETIREMENT_OPERATION | CHAR (2) | |
| EXTEMPORANEOUS_TYPE | Late Submission | CIAP_EXTEMPORANEOUS | CHAR (1) | |
| JVA | CIAP JVA Record | CIAP_RECORD_JVA | CHAR (1) | |
| MATERIAL_USAGE | Usage of the material | J_1BMATUSE | CHAR (1) | |
| INVESTMENT_STOCK | Investment Stock | CIAP_INVESTMENT_STOCK | CHAR (1) | |
| MAT_DOCUMENT | Material Document Number | CIAP_MAT_DOCUMENT | MKPF | CHAR (10) |
| MAT_DOCUMENT_YEAR | Material Document Year | MJAHR | NUMC (4) | |
| MAT_DOCUMENT_ITEM | Item in Material Document | MBLPO | NUMC (4) | |
| CREATION_TYPE | Record Creation Type | CIAP_CREATION_TYPE | CHAR (1) | |
| MANUAL_SUSP | Manual Suspension | CIAP_MANUAL_SUSP | CHAR (1) | |
| CREDITING_PERIOD_LIMIT | Crediting Period Limit | CIAP_CREDITING_PERIOD_LIMIT | CHAR (1) | |
| DIFAL_POSTPONED | Postponed DIFAL | CIAP_DIFAL_POSTPONED | CHAR (1) | |
| BAPI | Created via BAPI | CIAP_BAPI | CHAR (1) | |
| ACCOUNT_ASSIG_CATEGORY | Account Assignment Category | KNTTP | T163K | CHAR (1) |
| IMMEDIATE_CREDIT | Immediate Credit Indicator | CIAP_IMMEDIATE_CREDIT | CHAR (1) | |
| COMPONENT_AS_ASSET | Component Treated as Asset | CIAP_COMPONENT_AS_ASSET | CHAR (1) | |
| MAIN_WBS | Main WBS | CIAP_MAIN_WBS | PRPS | NUMC (8) |
| STOCK_AS_ASSET | Stock as Asset | CIAP_STOCK_AS_ASSET | CHAR (1) | |
| NETWORK_NUMBER | Network Number for Account Assignment | NPLNR | CHAR (12) | |
| ACTIVITY_NUMBER | Operation/Activity Number | VORNR | CHAR (4) | |
| ICMS_RETURNED | ICMS Returned | CIAP_ICMS_RETURNED | DEC (22) | |
| ICMS_NOT_ALLOWED | ICMS Not Allowed | CIAP_ICMS_NOT_ALLOWED | DEC (22) | |
| PENDING_ACCOUNTING | Pending Accounting | CIAP_PENDING_ACCOUNTING | CHAR (1) | |
| COD_IND_BEM | Asset/Component Code | CIAP_EFD_COD_IND_BEM | CHAR (60) | |
| FUNC | Asset Function Description | CIAP_EFD_FUNC | CHAR (255) | |
| DESCR_ITEM | Asset or Component Description | CIAP_EFD_DESCR_ITEM | CHAR (255) | |
| COD_PRNC | Main Asset Code | CIAP_EFD_COD_PRNC | CHAR (60) | |
| COD_CTA | G/L Account Number | CIAP_EFD_COD_CTA | CHAR (60) | |
| COD_CCUS | Cost Center Code | CIAP_EFD_COD_CCUS | CHAR (60) | |
| CCUS | Cost Center Description | CIAP_EFD_DESCR_CCUS | CHAR (60) | |
| VIDA_UTIL | Useful Life (Months) | CIAP_EFD_VIDA_UTIL | NUMC (3) | |
| ORIGINAL_QUANTITY | Quantity | J_1BNETQTY | QUAN (13) | |
| PARENT_ID | CIAP Record Unique ID | CIAP_RECORD_ID | RAW (16) | |
| TOTAL_VALUE | Total Value | CIAP_TOTAL_VALUE | DEC (22) | |
| ICMS_FREIGHT_BASE | Freight ICMS Base | CIAP_FREIGHT_ICMS_BASE | DEC (22) | |
| VERSION | CIAP Version | CIAP_VERSION | CHAR (20) | |
| PLANT | Plant | WERKS_D | CHAR (4) | |
| SHORT_TERM | ICMS Short Term Value | CIAP_SHORT_TERM_VALUE | DEC (22) | |
| LONG_TERM | ICMS Long Term Value | CIAP_LONG_TERM_VALUE | DEC (22) | |
| START_CREDIT_LIMIT_DATE | Start of Crediting Period | CIAP_START_CREDIT_LIMIT_DATE | DATS (8) | |
| END_CREDIT_LIMIT_DATE | End of Crediting Period | CIAP_END_CREDIT_LIMIT_DATE | DATS (8) | |
| FIRST_ACCOUNTABLE_PERIOD | First Accountable Period | CIAP_FIRST_ACCOUNTABLE_PERIOD | NUMC (6) | |
| LEGACY_VALUE | Legacy Value | CIAP_LEGACY_VALUE | DEC (22) |
