DIAN_C_FORMATS SAP table for – Maintain DIAN formats configuration

Here we would like to draw your attention to DIAN_C_FORMATS 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). DIAN_C_FORMATS is a SAP standard transp table used for storing Maintain DIAN formats configuration related data in SAP. It comes under the package ID-DIAN-CO.

SAP DIAN_C_FORMATS table

Table DIAN_C_FORMATS technical data

TableDIAN_C_FORMATS
Data storingMaintain DIAN formats configuration
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-DIAN-CO
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_FIN
Table CategoryTRANSP

SAP DIAN_C_FORMATS 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 DIAN_C_FORMATS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DIAN_YEAR : Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DIAN_FORMAT : DIAN Format
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • VERSION : DIAN Format Version
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • EXCHANGE_RATE_TYPE : Exchange Rate Type
    Its data type is CHAR (Character String) with field length 4
  • DIAN_ID_TYPE : DIAN ID Type for minimum Amount
    Its data type is CHAR (Character String) with field length 2
  • MIN_AMOUNT : DIAN minimum amount
    Its data type is CURR (Currency Field) with field length 22
  • NIT_MIN_ACCOUNT : NIT Minimun Account
    Its data type is CHAR (Character String) with field length 20
  • NAME_MIN_AMOUNT : Name Minimum Amount
    Its data type is CHAR (Character String) with field length 60
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5