P_KZ_VATReturnSection1

Selection for main ssections 0,1,2,4,6(1) | view: PKZVATRETDOC1 | Extraction: Not supported | Component: Financials Kazakhastan
Tables used: FIKZD_ACCT_RPITM, BKPF, BSEG, BSET, T001, TKA02, T005, T001, T014, FIKZD_VATITEM, FIKZD_VATITEMT, FIKZD_VATSEC, FIKZD_VATSEL
Column Name Description
Column Name Description
AmountInCompanyCodeCurrency null
AmountInTransactionCurrency null
TaxBaseAmountInTransCrcy null
TaxAmount null
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
Column Name Description
Column Name Description
JrnlEntryCntrySpecificDate1 Country/Region Specific Date 1 in the Document
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
Column Name Description
DebitCreditCode Debit/Credit Indicator 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
TaxRate Tax Rate
TransactionTypeDetermination Transaction Key CHAR3
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
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_KZ_VATRETURNSECTION1.MANDT == T003.MANDT
  • P_KZ_VATRETURNSECTION1.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • P_KZ_VATRETURNSECTION1.COMPANYCODE == T001.BUKRS
  • P_KZ_VATRETURNSECTION1.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_KZ_VATRETURNSECTION1.MANDT == TCURC.MANDT
  • P_KZ_VATRETURNSECTION1.CURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • P_KZ_VATRETURNSECTION1.MANDT == KNA1.MANDT
  • P_KZ_VATRETURNSECTION1.CUSTOMER == KNA1.KUNNR
Section of VAT Return
  • Client
  • VAT Return Version
  • Section of VAT Return
  • P_KZ_VATRETURNSECTION1.MANDT == FIKZD_VATSEC.MANDT
  • P_KZ_VATRETURNSECTION1.KZ_VATRETURNVERSION == FIKZD_VATSEC.VERSION
  • P_KZ_VATRETURNSECTION1.KZ_VATRETURNSECTION == FIKZD_VATSEC.SECT
VAT Return Version
  • Client
  • VAT Return Version
Supplier
  • Supplier
  • Client
  • P_KZ_VATRETURNSECTION1.SUPPLIER == LFA1.LIFNR
  • P_KZ_VATRETURNSECTION1.MANDT == LFA1.MANDT
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • P_KZ_VATRETURNSECTION1.[column in domain "KALSM_D"] == T007A.KALSM
  • P_KZ_VATRETURNSECTION1.MANDT == T007A.MANDT
  • P_KZ_VATRETURNSECTION1.TAXCODE == T007A.MWSKZ