1. SAP Tutorial
  2. FI Module

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

    • CIAP_D_RECORD related tables

    • CIAP_D_QUOTA : CIAP record quota
    • CIAP_D_RECORD : CIAP Record
    • CIAP_C_ACCOUNT : Identify the accounting of expenses and ICMS to be paid
    • CIAP_D_NF : CIAP Nota Fiscal/Record relationship
    • CIAP_C_NO_QUO_ST : Table for customizing of quotas quantity by Country/State
    • CIAP_C_NO_QUO_BP : Table for customizing of quotas quantity by CCode / B Place
    • CIAP_D_CRED_FACT : CIAP Credit Factor Table
    • CIAP_C_CFOP : Valid combination of CFOP/Version/Item Category for CIAP

    CIAP_D_RECORD related transaction codes under SAP package INT_TMF_CIAP

    • CIAP_ASSETFIN : Asset Conclusion Report
    • CIAP_REPORT : List all the CIAP Records
    • CIAP_DETERMINATION : Execute the CIAP Determination

    Related References

    Related Tutorials

    CIAP_D_QUOTA SAP table for – CIAP record quota

    CIAP_D_QUOTA table in SAP FI (Localization in FI) module. This table is used for storing data of CIAP record quota....

    CIAP_D_NF SAP table for – CIAP Nota Fiscal/Record relationship

    CIAP_D_NF table in SAP FI (Localization in FI) module. This table is used for storing data of CIAP Nota Fiscal/Record...

    J_1B_CIAP_FACTOR SAP table for – CIAP Factor

    J_1B_CIAP_FACTOR table in SAP FI (Localization in FI) module. This table is used for storing data of CIAP Factor. See...

    CIAP_C_CFOP SAP table for – Valid combination of CFOP/Version/Item Category for CIAP

    CIAP_C_CFOP table in SAP FI (Localization in FI) module. This table is used for storing data of Valid combination of...

    CIAP_D_CRED_FACT SAP table for – CIAP Credit Factor Table

    CIAP_D_CRED_FACT table in SAP FI (Localization in FI) module. This table is used for storing data of CIAP Credit Factor...

    CIAP_DETERMINATION SAP tcode for – Execute the CIAP Determination

    CIAP_DETERMINATION tcode in SAP FI (Localization in FI) module. This transaction code is used for Execute the CIAP Determination. See...

    CIAP_REPORT SAP tcode for – List all the CIAP Records

    CIAP_REPORT tcode in SAP FI (Localization in FI) module. This transaction code is used for List all the CIAP Records....

    «
    »