DIAN_A_1001_08 SAP table for – Cached Data of DIAN Format 1001 version 08

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

SAP DIAN_A_1001_08 table

Table DIAN_A_1001_08 technical data

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

SAP DIAN_A_1001_08 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_1001_08 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
  • CONCEPT : DIAN Concept
    Its data type is NUMC (Character String with Digits Only) 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
  • DIR : DIAN Adress
    Its data type is CHAR (Character String) with field length 200
  • DEPARTMENT_CODE : DIAN Departament Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CITY_CODE : DIAN City Code
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • COUNTRY : DIAN Residence number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PAYMENT_DEDUCTIBLE : Credit or debit posting deductible
    Its data type is CURR (Currency Field) with field length 22
  • PAYMENT_NON_DEDUCTIBLE : Credit or debit posting non deductible
    Its data type is CURR (Currency Field) with field length 22
  • HIGHER_DEDUCTIBLE_TAX_VALUE : VAT on purchase deductible
    Its data type is CURR (Currency Field) with field length 22
  • HIGHER_NO_DEDUCTIBLE_TAX_VALUE : VAT on purchase non deductible
    Its data type is CURR (Currency Field) with field length 22
  • RETP : Withholding source income actual
    Its data type is CURR (Currency Field) with field length 22
  • RETA : Withholding source income assumed
    Its data type is CURR (Currency Field) with field length 22
  • COMUN : VAT Withholding common regime actual
    Its data type is CURR (Currency Field) with field length 22
  • SIMP : VAT Withholding Simple Regime Assumed
    Its data type is CURR (Currency Field) with field length 22
  • NDOM : VAT Withholding Non-domiciled Actual
    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