C_KZ_VATRetForeignItemQuery

VAT Retrun Foreign documents: Query View | view: CKZVATFOREIGNQ | 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
PaymentRequestAmountInPaytCrcy VAT To Be Paid
PaidAmountInPaytCurrency Paid VAT amount
Column Name Description
Column Name Description
TaxReportingDate Tax Reporting Date
ExternalContractDate Contract Date
PostingDate Posting Date
DocumentDate Journal Entry Date
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
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
KZ_VATLineItem Line Item Number of VAT Return CHAR10
SupplierName Name of Supplier TEXT80
TaxNumber1 Tax Number STCD1
ExternalContractNumber External Contract Number J_3RF_EXTCNTNUM
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
Country Country ISO Code LAND1
CountryThreeDigitISOCode ISO Country/Region Code Numeric 3-Characters NUM03
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
VATReturnItemDescription VAT Return Item Description
CostCenter Cost Center KOSTL
Segment Segment for Segmental Reporting FB_SEGMENT
FiscalPeriod Fiscal Period POPER
AssetClass Asset Class ANLKL
AssignmentReference Assignment Reference ZUONR
FunctionalArea Functional Area FKBER
StatryRptgEntity Reporting Entity SRF_REPORTING_ENTITY
StatryRptCategory Report Category ID SRF_REP_CAT_ID
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == T003.MANDT
  • C_KZ_VATRETFOREIGNITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Business Area
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.BUSINESSAREA == TGSB.GSBER
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == TKA01.MANDT
  • C_KZ_VATRETFOREIGNITEMQUERY.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Currency Key
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.CURRENCY == TCURC.WAERS
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.CUSTOMER == KNA1.KUNNR
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == KNA1.MANDT
Valuation Type
  • Valuation Type
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == T149D.MANDT
VAT Tax Turnover Code
  • Client
  • VAT Tax Turnover Code
VAT Return Version
  • VAT Return Version
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.KZ_VATRETURNVERSION == FIKZD_VATVERS.VERSION
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == FIKZD_VATVERS.MANDT
Material Number
  • Material Number
  • Product Number
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.MATERIAL == MARA.MATNR
  • C_KZ_VATRETFOREIGNITEMQUERY.PRODUCT == MARA.MATNR
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.PLANT == T001W.WERKS
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == T001W.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.MATERIAL == MARA.MATNR
  • C_KZ_VATRETFOREIGNITEMQUERY.PRODUCT == MARA.MATNR
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == MARA.MANDT
Supplier
  • Supplier
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.SUPPLIER == LFA1.LIFNR
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == LFA1.MANDT
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == T007A.MANDT
  • C_KZ_VATRETFOREIGNITEMQUERY.TAXCODE == T007A.MWSKZ
  • C_KZ_VATRETFOREIGNITEMQUERY.[column in domain "KALSM_D"] == T007A.KALSM
Valuation area
  • Valuation area
  • Client
  • C_KZ_VATRETFOREIGNITEMQUERY.VALUATIONAREA == T001K.BWKEY
  • C_KZ_VATRETFOREIGNITEMQUERY.MANDT == T001K.MANDT