C_KZ_VATReturnIncgInvcItemQ

VAT Return Incoming Invoice Item (Query) | view: CKZVATRETININVQ | Extraction: Not supported | Component: Financials Kazakhastan
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
Column Name Description
📏 Purchase Order Unit of Measure (QuantityUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Country/Region Specific Date 1 in the Document
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
KZ_VATReturnSectionType VAT Return Section Type Show values
Activity VAT Activity Identifier Show values
DebitCreditCode Debit/Credit Code Show values
KZ_MaterialSubGroup VAT Material Subgroup Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
TaxCode Tax on sales/purchases code MWSKZ
TransactionTypeDetermination Transaction Key CHAR3
AccountingDocumentType Journal Entry Type BLART
OriginalReferenceDocument Object key AWKEY
ReferenceDocumentType Reference Document Type AWTYP
DocumentReferenceID Document Reference ID XBLNR1
BusinessTransactionType Business Transaction Category FINS_BTTYPE
SenderLogicalSystem Sender Logical System LOGSYS
StatryRptgEntity Reporting Entity SRF_REPORTING_ENTITY
StatryRptCategory Report Category ID SRF_REP_CAT_ID
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
CategoryFlag Supplier Status
TaxNumber1 Supllier RNN CHAR16
TaxNumber3 Supplier BIN CHAR18
InvoiceNumber Country/Region Specific Reference 1 in the Document FAC_GLO_REF1_HD
MaterialName Material Description TEXT40
Supplier Account Number of Supplier LIFNR
BusinessPartnerContract Internal Contract Number ZUONR
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • C_KZ_VATRETURNINCGINVCITEMQ.CUSTOMER == KNA1.KUNNR
  • C_KZ_VATRETURNINCGINVCITEMQ.MANDT == KNA1.MANDT
Material Number
  • Client
  • Material Number
  • C_KZ_VATRETURNINCGINVCITEMQ.MANDT == MARA.MANDT
  • C_KZ_VATRETURNINCGINVCITEMQ.MATERIAL == MARA.MATNR
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_KZ_VATRETURNINCGINVCITEMQ.QUANTITYUNIT == T006.MSEHI
  • C_KZ_VATRETURNINCGINVCITEMQ.MANDT == T006.MANDT