C_CN_TaxDeductionItemQuery

China Input VAT Deduction | view: CCNTXIDEDUCTIONQ | Extraction: Not supported | Component: Financials China
Tables used: TXI_HDR, TXI_IPT_VAT_CAT, TXI_IPT_VAT_CATT, TXI_TYP, TXI_TYPT, TXI_TYP_ATTR
Column Name Description
CN_TaxInvcUUID China Tax Invoice UUID
CategoryDescription China Tax Input VAT Category Description
CN_TaxInvcCode China Tax Invoice Code
CN_TaxInvcNmbr China Tax Invoice Number
Column Name Description
💲 Currency Key (CN_TaxInvcCrcy):
CN_TaxInvcNetAmtInInvcCrcy China Tax Invoice Net Amount in Invoice Currency
CN_TaxInvcTaxAmtInInvcCrcy China Tax Invoice Tax Amount in Invoice Currency
CN_TaxInvcDeductAmtInInvcCrcy China Tax Invoice Deductive Tax Amount in Invoice Currency
TaxAmount China Tax Invoice Tax Amount in Invoice Currency
Column Name Description
Column Name Description
CN_TaxInvcDate China Tax Invoice Date
Column Name Description
CN_TaxInvcInptProcgSts China Tax Invoice Incoming Invoice Processing Status Show values
Column Name Description Domain name
DisplayTaxRate China Tax Rate CHAR18
CN_TaxInvcTypeTxt China Tax Invoice Type Description FICNTAXINVC_TYPE_TXT
DocumentStatusDesc China Tax Invoice Incoming Invoice Processing Status Desc. DDTEXT
CN_TaxInvcTotAmtInInvcCrcy null
CN_TaxDeclnYear China Tax Declaration Year NUM4
CN_TaxDeclnMonth China Tax Declaration Month NUM2
Master Data Relations Join Conditions
Reference to tax invoice type table
  • Client
  • China Tax Invoice Type
  • C_CN_TAXDEDUCTIONITEMQUERY.MANDT == TXI_TYP.MANDT
  • C_CN_TAXDEDUCTIONITEMQUERY.CN_TAXINVCTYPE == TXI_TYP.INVC_TYPE
Company Code
  • Client
  • Company Code
  • C_CN_TAXDEDUCTIONITEMQUERY.MANDT == T001.MANDT
  • C_CN_TAXDEDUCTIONITEMQUERY.COMPANYCODE == T001.BUKRS
China Tax Input VAT Category
  • Client
  • China Tax Input VAT Category