C_KZ_VATRetDeductDocCube

Section 9 Cube Veiw | view: CKZVATRETDECDOCC | TRAN | Extraction: Not supported | Component: Financials Kazakhastan
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
TaxCode FK Tax on sales/purchases code
KZ_VATLineItem Line Item Number of VAT Return
KZ_VATOperationCode Operation Code of VAT Return
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
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
DebitCreditCode Debit/Credit Indicator Show values
KZ_VATReturnSectionType VAT Return Section Type Show values
KZ_VATReturnSectionColumn Number of VAT Return Section Column Show values
Column Name Description Domain name
TransactionTypeDetermination Transaction Key CHAR3
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
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
KZ_TaxNormID Tax Norm Code
VATReturnItemDescription VAT Return Item Description TEXT255
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
  • Journal Entry Type
  • Client
  • C_KZ_VATRETDEDUCTDOCCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_KZ_VATRETDEDUCTDOCCUBE.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • C_KZ_VATRETDEDUCTDOCCUBE.MANDT == T001.MANDT
  • C_KZ_VATRETDEDUCTDOCCUBE.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_KZ_VATRETDEDUCTDOCCUBE.MANDT == TCURC.MANDT
  • C_KZ_VATRETDEDUCTDOCCUBE.CURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • C_KZ_VATRETDEDUCTDOCCUBE.MANDT == KNA1.MANDT
  • C_KZ_VATRETDEDUCTDOCCUBE.CUSTOMER == KNA1.KUNNR
Supplier
  • Client
  • Supplier
  • C_KZ_VATRETDEDUCTDOCCUBE.MANDT == LFA1.MANDT
  • C_KZ_VATRETDEDUCTDOCCUBE.SUPPLIER == LFA1.LIFNR
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • ?
  • C_KZ_VATRETDEDUCTDOCCUBE.TAXCODE == T007A.MWSKZ
  • C_KZ_VATRETDEDUCTDOCCUBE.MANDT == T007A.MANDT
  • C_KZ_VATRETDEDUCTDOCCUBE.[column in domain "KALSM_D"] == T007A.KALSM