P_KZ_VATRetOutDoc

DDL: P_KZ_VATRETOUTDOC SQL: PKZVATRETOUTDOC Type: view COMPOSITE

P_KZ_VATRetOutDoc is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_KZ_BillingMaterialDetails, I_OperationalAcctgDocItem).

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
P_KZ_BillingMaterialDetails BillingMaterial left_outer
I_OperationalAcctgDocItem DocumentItem left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PKZVATRETOUTDOC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view 
@AbapCatalog.sqlViewName: 'PKZVATRETOUTDOC'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE


define view P_KZ_VATRetOutDoc
  as select distinct from    P_KZ_VATReturnSection3      as LogItems

    left outer join I_OperationalAcctgDocItem   as DocumentItem    on  DocumentItem.CompanyCode        =  LogItems.CompanyCode
                                                                   and DocumentItem.AccountingDocument =  LogItems.AccountingDocument
                                                                   and DocumentItem.FiscalYear         =  LogItems.FiscalYear
                                                                   //and DocumentItem.Customer           <> ''

                                                                   and DocumentItem.Material <> ''//BillingMaterial.Material

                                                                   and ( DocumentItem.TaxCode = LogItems.TaxCode or DocumentItem.TaxCode = '')


    left outer join P_KZ_BillingMaterialDetails as BillingMaterial on  BillingMaterial.BillingDocument = LogItems.OriginalReferenceDocument
                                                                   and ( LogItems.ReferenceDocumentType           = 'VBRK'
                                                                      or LogItems.ReferenceDocumentType           = 'CF3PS' )
                                                                   and BillingMaterial.Material = DocumentItem.Material



{
  //P_KZ_VATReturnSection3

  LogItems.CompanyCode,
  LogItems.AccountingDocument,
  LogItems.FiscalYear,
  LogItems.TaxCode,
  TaxRate,
  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( DocumentItem.AmountInCompanyCodeCurrency  as abap.fltp )  / cast( LogItems.TaxBaseAmountInCoCodeCrcy as abap.fltp )

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

//            //* cast( LogItems.TaxAmountInCoCodeCrcy as abap.fltp)

//            * 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,
  IsReversal,
  IsReversed,
  LogItems.OriginalReferenceDocument,
  LogItems.ReferenceDocumentType,
  DocumentReferenceID,
  BusinessTransactionType,
  SenderLogicalSystem,
  AccountingDocumentHeaderText,
  AccountingDocCreatedByUser,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  LogItems.DocumentItemText,
  LogItems.CompanyCodeCurrency,
  Currency,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  LogItems.AccountingDocumentItem,
  KZ_VATReturnSectionType,
  BillingMaterial.Material,
  DocumentItem.PurchasingDocument,
  DocumentItem.PurchasingDocumentItem,

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


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

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

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


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

  BillingMaterial.KZ_MaterialSubGroup,
  BillingMaterial.BaseUnit as AnalyticBaseUnit,
  @Semantics.quantity.unitOfMeasure: 'AnalyticBaseUnit'
  BillingMaterial.BillingQuantity as AnalyticBillingQuantity,
  BillingMaterial.MaterialName as AnalyticMaterialName


}

where
  KZ_VATReturnSectionType = '07'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM",
"P_KZ_BILLINGMATERIALDETAILS",
"P_KZ_VATRETURNSECTION3"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More