P_KZ_VATRETURNFOREIGN1

Selection for main ssections 0,1,2,4,6(1) | view: PKZVATRETFOR1 | Extraction: Not supported | Component: Financials Kazakhastan
Tables used: FIKZD_ACCT_RPITM, BKPF, BSEG, T001, T014, FIKZD_VATITEM, FIKZD_VATITEMT, FIKZD_VATSEC, FIKZD_VATSEL
Column Name Description
Column Name Description
TaxBaseAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
Column Name Description
DebitCreditCode Debit/Credit Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
KZ_VATReturnSectionColumn Number of VAT Return Section Column Show values
KZ_VATReturnSectionType VAT Return Section Type Show values
KZ_AmountType Amount Type Show values
NegativeSign Negative Sign Show values
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
TaxAmountInCoCodeCrcy null
JrnlEntryCntrySpecificRef1 Country/Region Specific Reference 1 in the Document FAC_GLO_REF1_HD
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
KZ_LineItem Line Item Number of VAT Return CHAR10
OperationCode Operation Code of VAT Return CHAR20
ConditionNumber Condition Number
KZ_TaxNormCode Tax Norm Code
Description VAT Return Item Description TEXT255
ClearingAccountingDocument Clearing Journal Entry BELNR
OriginalReferenceDocNum null
OriginalReferenceDocYear null
DocRef null
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_KZ_VATRETURNFOREIGN1.MANDT == T003.MANDT
  • P_KZ_VATRETURNFOREIGN1.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • P_KZ_VATRETURNFOREIGN1.COMPANYCODE == T001.BUKRS
  • P_KZ_VATRETURNFOREIGN1.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_KZ_VATRETURNFOREIGN1.MANDT == TCURC.MANDT
  • P_KZ_VATRETURNFOREIGN1.CURRENCY == TCURC.WAERS
VAT Tax Turnover Code
  • Client
  • VAT Tax Turnover Code
Section of VAT Return
  • Client
  • Section of VAT Return
  • VAT Return Version
  • P_KZ_VATRETURNFOREIGN1.MANDT == FIKZD_VATSEC.MANDT
  • P_KZ_VATRETURNFOREIGN1.KZ_VATRETURNSECTION == FIKZD_VATSEC.SECT
  • P_KZ_VATRETURNFOREIGN1.KZ_VATRETURNVERSION == FIKZD_VATSEC.VERSION
VAT Return Version
  • Client
  • VAT Return Version
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • P_KZ_VATRETURNFOREIGN1.MANDT == T007A.MANDT
  • P_KZ_VATRETURNFOREIGN1.TAXCODE == T007A.MWSKZ
  • P_KZ_VATRETURNFOREIGN1.[column in domain "KALSM_D"] == T007A.KALSM