P_PL_SAFTMAPTAXCODE

CDS View

SAF-T PL Map Acctg Docs with Tax Code

P_PL_SAFTMAPTAXCODE is a CDS View in S/4HANA. SAF-T PL Map Acctg Docs with Tax Code. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PL_SAFTInvoiceHeaderBasic view inner COMPOSITE SAF-T PL: Invoice Header Basic Data 
@AbapCatalog.sqlViewName: 'PPLSAFTMAPTXCD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PL_SAFTMapTaxCode
  as select from I_JournalEntry            as Entry
    inner join   I_OperationalAcctgDocItem as Item on  Item.CompanyCode          =  Entry.CompanyCode
                                                   and Item.AccountingDocument   =  Entry.AccountingDocument
                                                   and Item.FiscalYear           =  Entry.FiscalYear
                                                   and Item.FinancialAccountType <> 'D'

    inner join   P_PL_SAFTINVOICETAXD       as Tax  on  Tax.CompanyCode        = Item.CompanyCode
                                                   and Tax.AccountingDocument = Item.AccountingDocument
                                                   and Tax.FiscalYear         = Item.FiscalYear
                                                   and Tax.TaxCode            = Item.TaxCode

{
  key Entry.CompanyCode,
  key Entry.AccountingDocument,
  key Entry.FiscalYear,

      sum(AmountInTransactionCurrency) as AmountInTransactionCurrency,
      sum(AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency

//      Tax.PL_SAFTTaxPercentageCode

}
group by
  Entry.CompanyCode,
  Entry.AccountingDocument,
  Entry.FiscalYear
//  Tax.PL_SAFTTaxPercentageCode

Learn More