IDFIVATT_FI_ITM

Country Specific VAT: FI Items | #transactional | Component: Financials Czech Republic
Column Name Description
MANDT Client
DECL_TYPE Declaration Type Show values
TBUKRS FK Dominant Enterprise/Company Code
DECL_CTRY FK Reporting Country/Region
DECL_YEAR Reporting Year of Data Transmission to Authorities
DECL_PER Reporting Period Show values
DECL_RUNID Counter of a Corrected Return
DECL_ITEM Multinational ATR Item ID
Column Name Description
💲 Document Currency (ORIG_CURR):
BASE_AMT Base Amount in Document Currency
TAX_AMT Tax Amount in Document Currency
TAX_DEDUCT Tax Deductible/Payable
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
Column Name Description
VATDATE Tax Reporting Date
Column Name Description
DECL_TYPE Declaration Type Show values
DECL_PER Reporting Period Show values
VATSECTION VAT Ledger Section Show values
VATSECTIONADD Additional VAT Ledger Section Show values
XREVERSAL Specifies Whether Document Is Reversal Doc. or Reversed Doc. Show values
XCPDD Indicator: Address and Bank Data Set Individually Show values
KOART Account type Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
BELNR Document Number of an Accounting Document BELNR
GJAHR Fiscal Year GJAHR
NUMMR Customer/Supplier Account Number KUNNR
STCEG VAT Registration Number STCEG
INVNUMBER Invoice Number IDFIVAT_INVOICE
REFNUMBER Reference Number IDFIVAT_INVOICE
MWSKZ Tax on sales/purchases code MWSKZ
TAXRATE Tax Rate CHAR7
CLASS_CODE Classification Code for Material IDFIVAT_CLASS_CODE
CNCODE Commodity Code STAWN
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZZ Line Item in the Relevant Invoice BUZEI
STBLG Reverse Document Number BELNR
INVNUMBER_ADD Invoice Number IDFIVAT_INVOICE
REFNUMBER_ADD Reference Number IDFIVAT_INVOICE
Master Data Relations Join Conditions
Reporting Country/Region
  • Reporting Country/Region
  • Client
  • IDFIVATT_FI_ITM.DECL_CTRY == T005.LAND1
  • IDFIVATT_FI_ITM.MANDT == T005.MANDT
Dominant Enterprise/Company Code
  • IDFIVATT_FI_ITM.MANDT == T001.MANDT
  • IDFIVATT_FI_ITM.TBUKRS == T001.BUKRS