I_KZ_VATRETURNCUSTOMIZING

CDS View

VAT Return Kazahstan Customizing

I_KZ_VATRETURNCUSTOMIZING is a CDS View in S/4HANA. VAT Return Kazahstan Customizing. It contains 5 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 5 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_KZ_DSVATRetDeduct view inner COMPOSITE Data selection for section 9
P_KZ_DSVATRetDoc view inner COMPOSITE Data selection view for section 0,1,2,4,6
P_KZ_DSVATRetForiegnDoc view inner COMPOSITE Data selection for Section 5
P_KZ_DSVATRetInDoc1 view inner COMPOSITE Data sselection for paper customer invoices
P_KZ_DSVATRetOutDoc1 view inner COMPOSITE Data selction for ssection 7

Fields (5)

KeyField CDS FieldsUsed in Views
KEY KZ_VATLineItem LineItem 5
KEY KZ_VATOperationCode OperationCode 5
KEY KZ_VATReturnSection SectionNum 4
KEY KZ_VATReturnSectionColumn ColumnNum 5
KEY KZ_VATReturnSectionType SectionNum 1 
@AbapCatalog.sqlViewName: 'IKZVATRETCUST'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@EndUserText.label: 'VAT Return Kazahstan Customizing'
define view I_KZ_VATReturnCustomizing
  as select from P_KZ_VATRETURNITEM1 as Item 
  
  
  

//    join P_KZ_VATRETURNSELCRITERIA as VATReturnSelectionCriteria on  VATReturnSelectionCriteria.KZ_VATReturnVersion = VATReturnSection.KZ_VATReturnVersion

//                                                               and VATReturnSelectionCriteria.KZ_VATReturnSection = VATReturnSection.KZ_VATReturnSection

//    

    join         P_KZ_VATRETURNSECTIONCust     as VATReturnSection on  Item.KZ_VATReturnVersion = VATReturnSection.KZ_VATReturnVersion
                                                               and Item.KZ_VATReturnSection = VATReturnSection.KZ_VATReturnSection

   left outer to many join P_KZ_VATRETURNSELCRITERIA as VATReturnSelectionCriteria on  Item.KZ_VATReturnVersion = VATReturnSelectionCriteria.KZ_VATReturnVersion
                                                                             and Item.KZ_VATReturnSection = VATReturnSelectionCriteria.KZ_VATReturnSection
                                                             and Item.KZ_LineItem         = VATReturnSelectionCriteria.KZ_LineItem
                                                             and Item.OperationCode       = VATReturnSelectionCriteria.OperationCode
{
      //I_KZ_VATReturnSelCriteria

  key Item.KZ_VATReturnVersion,
  key Item.KZ_VATReturnSection,
  key Item.KZ_LineItem as KZ_VATLineItem,
  key Item.OperationCode as KZ_VATOperationCode,
  key KZ_VATReturnSectionColumn,
  key ConditionNumber as KZ_VATConditionNumber,
      VATReturnSection.KZ_VATReturnSectionType,
      TaxCode,
      AccountingDocumentType,
      DebitCreditCode,
      TaxDeclnAmountType,
      HasNegativeSign,
      TransactionTypeDetermination,
      KZ_TaxTurnoverCode,
      Item.KZ_TaxNormCode as KZ_TaxNormID,
      Item.KZ_TotalLine as TotalNumberIsCondition,
      Item._Text[ 1: Language = $session.system_language ].VATReturnItemDescription

}

Learn More