DIAN_A_1005_07 SAP table for – Cached Data of DIAN Format 1005 version 07

Here we would like to draw your attention to DIAN_A_1005_07 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_1005_07 is a SAP standard transp table used for storing Cached Data of DIAN Format 1005 version 07 related data in SAP. It comes under the package ID-DIAN-CO.

SAP DIAN_A_1005_07 table

Table DIAN_A_1005_07 technical data

TableDIAN_A_1005_07
Data storingCached Data of DIAN Format 1005 version 07
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-DIAN-CO
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP DIAN_A_1005_07 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_1005_07 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RUN_ID : Globally Unique Identifier
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • LINE_ID : Globally Unique Identifier
    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
  • DOCUMENT_TYPE : DIAN Identification Type
    Its data type is CHAR (Character String) with field length 2
  • IDENTIFICATION_NUMBER : DIAN Identification number
    Its data type is CHAR (Character String) with field length 20
  • VERIFICATION_DIGIT : DIAN Verification Digit
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • LAST_NAME : Last Name
    Its data type is CHAR (Character String) with field length 40
  • MIDDLE_NAME : DIAN Middle Name
    Its data type is CHAR (Character String) with field length 40
  • NAME : DIAN Name
    Its data type is CHAR (Character String) with field length 40
  • OTHER_NAMES : Other Name
    Its data type is CHAR (Character String) with field length 40
  • RAZ : Corporate Name
    Its data type is CHAR (Character String) with field length 40
  • VIMP : VAT Amount
    Its data type is CURR (Currency Field) with field length 22
  • IVADE : VAT Correction
    Its data type is CURR (Currency Field) with field length 22
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5