DIAN_A_EXTRACT SAP table for – Cached Extraction of DIAN Report

Here we would like to draw your attention to DIAN_A_EXTRACT 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_A_EXTRACT is a SAP standard transp table used for storing Cached Extraction of DIAN Report related data in SAP. It comes under the package ID-DIAN-CO.

SAP DIAN_A_EXTRACT table

Table DIAN_A_EXTRACT technical data

TableDIAN_A_EXTRACT
Data storingCached Extraction of DIAN Report
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-DIAN-CO
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP DIAN_A_EXTRACT 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_A_EXTRACT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DIAN_YEAR : Fiscal 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
  • COMPANY_CODE : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • LINE_ID : Globally Unique Identifier
    Its a key field. Its data type is RAW (Byte string) with field length 16