P_LU_SAFTZEROTAXLINE

CDS View

P_LU_SAFTZEROTAXLINE is a CDS View in S/4HANA. It contains 16 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 16 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LU_SAFTAdditionalZeroLine view from COMPOSITE SAFT LU Additional VAT Zero Line
P_LU_SAFTGENLDGRZEROTAXADDLINE view from COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
_CompanyCodeCurrency _CompanyCodeCurrency 2
AccountingDocumentItemType AccountingDocumentItemType 2
AccountingDocumentType JournalEntryType 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
CompanyCodeCurrency CompanyCodeCurrency 2
DebitCreditCode DebitCreditCode 2
DocumentItemText DocumentItemText 2
FinancialAccountType FinancialAccountType 2
Ledger Ledger 2
PostingDate PostingDate 2
TaxCalculationProcedure TaxCalculationProcedure 2
TaxCode TaxCode 2
TransactionCurrency TransactionCurrency 2 
@AbapCatalog.sqlViewName: 'PLUSAFTZEROTAX'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking : #NOT_REQUIRED
define view P_LU_SAFTZeroTaxLine
  as select from I_LU_SAFTJournalEntry as JournalLine
    inner join   I_TaxItem             as TaxItem on  JournalLine.AccountingDocument = TaxItem.AccountingDocument
                                                  and JournalLine.CompanyCode        = TaxItem.CompanyCode
                                                  and JournalLine.FiscalYear         = TaxItem.FiscalYear
                                                  and JournalLine.TaxCode            = TaxItem.TaxCode
{

  key JournalLine.CompanyCode                    as CompanyCode,
  key JournalLine.FiscalYear                     as FiscalYear,
  key JournalLine.AccountingDocument             as AccountingDocument,
  key JournalLine.LedgerGLLineItem               as LedgerGLLineItem,
  key JournalLine.Ledger                         as Ledger,

      JournalLine.PostingDate,
      JournalLine.AccountingDocumentType,
      JournalLine.TaxCalculationProcedure,
      JournalLine.TaxCode,
      JournalLine.DebitCreditCode,
      JournalLine.DocumentItemText,
      JournalLine.AccountingDocumentItemType,
      JournalLine.AlternativeGLAccount,
      JournalLine.FinancialAccountType,
      JournalLine.TransactionCurrency,
      TaxItem.TaxItem,
      TaxItem.GLAccount                          as ActiveGLAccount,

      @Semantics.currencyCode:true
      JournalLine.CompanyCodeCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      coalesce(TaxItem.TaxAmountInCoCodeCrcy, 0) as TaxAmount,

      JournalLine.AmountInCompanyCodeCurrency,

      JournalLine._CompanyCodeCurrency

}
where
      JournalLine.AccountingDocumentItemType <> 'T'
  and JournalLine.FinancialAccountType       =  'S'
  and JournalLine.TaxCode                    <> ''
  and JournalLine.TransactionTypeDetermination = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LU_SAFTJOURNALENTRY",
"I_TAXITEM"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[
"I_LU_SAFTJOURNALENTRY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More