P_KZ_VATRetInDoc

DDL: P_KZ_VATRETINDOC SQL: PKZVATRETINDOC Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_KZ_RETURN

Selection for incoming documents

P_KZ_VATRetInDoc is a Consumption CDS View that provides data about "Selection for incoming documents" in SAP S/4HANA. It reads from 2 data sources (P_KZ_JournalEntryItemLdngLdgr, P_KZ_PurMaterialDetails) and exposes 46 fields. Part of development package GLO_FIN_IS_VAT_KZ_RETURN.

2 data source(s) 46 fields

Data Sources (2)

SourceAliasJoin Type
P_KZ_JournalEntryItemLdngLdgr DocumentItem left_outer
P_KZ_PurMaterialDetails PurchasingDocument left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PKZVATRETINDOC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.compiler.compareFilter true view

Fields (46)

KeyFieldSource TableSource FieldDescription
CompanyCode LogItems CompanyCode
AccountingDocument LogItems AccountingDocument
FiscalYear LogItems FiscalYear
TaxCode LogItems TaxCode
TaxRate LogItems TaxRate
AmountSign LogItems AmountSign
NegativeSign NegativeSign
AmountInCompanyCodeCurrency P_KZ_JournalEntryItemLdngLdgr AmountInCompanyCodeCurrency
TaxBaseAmountInCoCodeCrcy LogItems TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy LogItems TaxAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcyABS
AmountInCompanyCodeCurrencyABS
TaxBaseAmountInCoCodeCrcyTot LogItems TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcyTot LogItems TaxAmountInCoCodeCrcy
TransactionTypeDetermination LogItems TransactionTypeDetermination
PostingDate LogItems PostingDate
TaxReportingDate TaxReportingDate
AccountingDocumentType LogItems AccountingDocumentType
IsReversal LogItems IsReversal
IsReversed LogItems IsReversed
OriginalReferenceDocument LogItems OriginalReferenceDocument
ReferenceDocumentType LogItems ReferenceDocumentType
DocumentReferenceID DocumentReferenceID
BusinessTransactionType LogItems BusinessTransactionType
SenderLogicalSystem LogItems SenderLogicalSystem
AccountingDocumentHeaderText LogItems AccountingDocumentHeaderText
AccountingDocCreatedByUser LogItems AccountingDocCreatedByUser
Reference1InDocumentHeader LogItems Reference1InDocumentHeader
Reference2InDocumentHeader LogItems Reference2InDocumentHeader
DocumentItemText LogItems DocumentItemText
CompanyCodeCurrency LogItems CompanyCodeCurrency
Currency Currency
StatryRptgEntity StatryRptgEntity
StatryRptCategory StatryRptCategory
StatryRptRunID StatryRptRunID
AccountingDocumentItem LogItems AccountingDocumentItem
KZ_VATReturnSectionType KZ_VATReturnSectionType
Material P_KZ_JournalEntryItemLdngLdgr Material
PurchasingDocument P_KZ_JournalEntryItemLdngLdgr PurchasingDocument
PurchasingDocumentItem P_KZ_JournalEntryItemLdngLdgr PurchasingDocumentItem
MaterialNameelseendasMaterialName
ActivityendasActivity
KZ_MaterialSubGroup P_KZ_PurMaterialDetails KZ_MaterialSubGroup
AnalyticQuantityUnit P_KZ_PurMaterialDetails QuantityUnit
AnalyticQuantity P_KZ_PurMaterialDetails Quantity
AnalyticMaterialName P_KZ_PurMaterialDetails MaterialName 
@AbapCatalog.sqlViewName: 'PKZVATRETINDOC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter:true
define view P_KZ_VATRetInDoc
  as select distinct from P_KZ_VATReturnSection3        as LogItems

    left outer join       P_KZ_PurMaterialDetails       as PurchasingDocument on  PurchasingDocument.PurchasingDocument         = LogItems.OriginalReferenceDocNum
                                                                              and PurchasingDocument.InvoiceReferenceFiscalYear = LogItems.OriginalReferenceDocYear
                                                                              and (
                                                                                 ReferenceDocumentType                          = 'RMRP'
                                                                                 or ReferenceDocumentType                       = 'CF3PM'
                                                                               )
                                                                              and (
                                                                                 PurchasingDocument.TaxCode                     = LogItems.TaxCode
                                                                                 or PurchasingDocument.TaxCode                  = ''
                                                                               )


    left outer join       P_KZ_JournalEntryItemLdngLdgr as DocumentItem       on  DocumentItem.CompanyCode        = LogItems.CompanyCode
                                                                              and DocumentItem.AccountingDocument = LogItems.AccountingDocument
                                                                              and DocumentItem.FiscalYear         = LogItems.FiscalYear
                                                                              and DocumentItem.Material           = PurchasingDocument.Material
                                                                              and (
                                                                                 DocumentItem.TaxCode             = LogItems.TaxCode
                                                                                 or DocumentItem.TaxCode          = ''
                                                                               )


{
  //P_KZ_VATReturnSection3

  LogItems.CompanyCode,
  LogItems.AccountingDocument,
  LogItems.FiscalYear,
  LogItems.TaxCode,
  LogItems.TaxRate,
  LogItems.AmountSign,
  NegativeSign,
  DocumentItem.AmountInCompanyCodeCurrency,

  //  case when DocumentItem.AmountInCompanyCodeCurrency is null

  //     then LogItems.TaxBaseAmountInCoCodeCrcy

  //     else DocumentItem.AmountInCompanyCodeCurrency

  //   end  as TaxBaseAmountInCoCodeCrcy,


  //   case when  DocumentItem.AmountInCompanyCodeCurrency is null

  //     then LogItems.TaxAmountInCoCodeCrcy

  //     else

  //

  //         cast ( DIVISION( DocumentItem.AmountInCompanyCodeCurrency, LogItems.TaxBaseAmountInCoCodeCrcy, 2) as abap.dec( 3, 2 ) )

  //                 * LogItems.TaxAmountInCoCodeCrcy

  //

  //

  //   end  as TaxAmountInCoCodeCrcy,


  LogItems.TaxBaseAmountInCoCodeCrcy,
  LogItems.TaxAmountInCoCodeCrcy,


  abs( LogItems.TaxBaseAmountInCoCodeCrcy )       as TaxBaseAmountInCoCodeCrcyABS,
  abs( DocumentItem.AmountInCompanyCodeCurrency ) as AmountInCompanyCodeCurrencyABS,





  LogItems.TaxBaseAmountInCoCodeCrcy              as TaxBaseAmountInCoCodeCrcyTot,

  LogItems.TaxAmountInCoCodeCrcy                  as TaxAmountInCoCodeCrcyTot,


  LogItems.TransactionTypeDetermination,
  LogItems.PostingDate,
  TaxReportingDate,

  case JrnlEntryCntrySpecificDate1
    when '' then LogItems.DocumentDate
    else JrnlEntryCntrySpecificDate1
    end                                           as DocumentDate,

  LogItems.AccountingDocumentType,
  LogItems.IsReversal,
  LogItems.IsReversed,
  LogItems.OriginalReferenceDocument,
  LogItems.ReferenceDocumentType,
  DocumentReferenceID,
  LogItems.BusinessTransactionType,
  LogItems.SenderLogicalSystem,
  LogItems.AccountingDocumentHeaderText,
  LogItems.AccountingDocCreatedByUser,
  LogItems.Reference1InDocumentHeader,
  LogItems.Reference2InDocumentHeader,
  LogItems.DocumentItemText,
  LogItems.CompanyCodeCurrency,
  Currency,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  LogItems.AccountingDocumentItem,
  KZ_VATReturnSectionType,
  DocumentItem.Material,
  DocumentItem.PurchasingDocument,
  DocumentItem.PurchasingDocumentItem,


  case JrnlEntryCntrySpecificRef1
    when ''
        then case DocumentReferenceID when ''
            then LogItems.AccountingDocument
        else DocumentReferenceID
        end
   else JrnlEntryCntrySpecificRef1
   end                                            as InvoiceNumber,

  //  PurchasingDocument.QuantityUnit,

  //  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'

  //  PurchasingDocument.Quantity,



  case PurchasingDocument.KZ_MaterialSubGroup
  when 'MIN'
  then PurchasingDocument.QuantityUnit
  else cast( '' as meins)
  end                                             as QuantityUnit,
  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'

  case PurchasingDocument.KZ_MaterialSubGroup
  when 'MIN'
  then PurchasingDocument.Quantity
  else cast ( 0 as fkimg )
  end                                             as Quantity,

  case PurchasingDocument.KZ_MaterialSubGroup
  when 'MIN'
  then  PurchasingDocument.MaterialName
  else ''
  end                                             as MaterialName,

  case PurchasingDocument.Activity
    when '' then '1'
    else PurchasingDocument.Activity
  end                                             as Activity,

  PurchasingDocument.KZ_MaterialSubGroup,
  PurchasingDocument.QuantityUnit                 as AnalyticQuantityUnit,
  @Semantics.quantity.unitOfMeasure: 'AnalyticQuantityUnit'
  PurchasingDocument.Quantity                     as AnalyticQuantity,
  PurchasingDocument.MaterialName                 as AnalyticMaterialName
}

where
  KZ_VATReturnSectionType = '08'

Learn More