CIAP_D_RECORD SAP table for – CIAP Record

Here we would like to draw your attention to CIAP_D_RECORD table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). CIAP_D_RECORD is a SAP standard transp table used for storing CIAP Record related data in SAP. It comes under the package INT_TMF_CIAP.

SAP CIAP_D_RECORD table

Table CIAP_D_RECORD technical data

TableCIAP_D_RECORD
Data storingCIAP Record
ModuleFI
Sub ModuleFI-LOC
SAP PackageINT_TMF_CIAP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_APPL
Table CategoryTRANSP

SAP CIAP_D_RECORD Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CIAP_D_RECORD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ID : CIAP Record Unique ID
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • COMPANY_CODE : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BRANCH : Business Place
    Its data type is CHAR (Character String) with field length 4
  • MATERIAL_NUMBER : Material Number
    Its data type is CHAR (Character String) with field length 18
  • CREATION_DATE : CIAP Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STATUS : CIAP record status
    Its data type is CHAR (Character String) with field length 2
  • QUOTAS_QUANTITY : CIAP quota number
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • LAST_DETERMINATION : Period (month/year) in which the record was created
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • WBS : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • INTERNAL_ORDER : Order Number
    Its data type is CHAR (Character String) with field length 12
  • FINAL_ASSET : General Flag
    Its data type is CHAR (Character String) with field length 1
  • ASSET_ID : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ASSET_SUBNUMBER : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • GOODS_VALUE : CIAP goods value
    Its data type is CURR (Currency Field) with field length 22
  • CREDIT_FACTOR : CIAP Credit Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ICMS_BASE : CIAP ICMS tax base
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_VALUE : CIAP ICMS Value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_SUB_TRIB : CIAP “Substituição Tributária” Value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_DIFAL : CIAP DIFAL Value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_FREIGHT_VALUE : CIAP Freight ICMS Value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_FREIGHT_SUB_TRIB : CIAP “Substituição Tributária” Value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_FREIGHT_DIFAL : CIAP DIFAL Value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_TOTAL : CIAP ICMS Total Value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_TO_CREDIT : CIAP ICMS to credit value
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_NOT_CREDITED : CIAP ICMS Not Credited
    Its data type is CURR (Currency Field) with field length 22
  • ICMS_CREDITED : CIAP ICMS credited value
    Its data type is CURR (Currency Field) with field length 22
  • CURRENCY : Currency used in CIAP.
    Its data type is CUKY (Currency key for a currency field) with field length 5