P_ARLineItem_Base_Bset_Debit1

DDL: P_ARLINEITEM_BASE_BSET_DEBIT1 SQL: PARLITBASEBSETD1 Type: view BASIC Package: FINS_FIS_APAR_APPS

AR Line Item Base Tax Amount Debit 1

P_ARLineItem_Base_Bset_Debit1 is a Basic CDS View that provides data about "AR Line Item Base Tax Amount Debit 1" in SAP S/4HANA. It reads from 1 data source (P_Bset) and exposes 5 fields. Part of development package FINS_FIS_APAR_APPS.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_Bset P_Bset from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PARLITBASEBSETD1 view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
AccountingDocument AccountingDocument
FiscalYear FiscalYear
TaxCode TaxCode
TaxJurisdictionLevelDebit 
@AbapCatalog.sqlViewName: 'PARLITBASEBSETD1'
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ARLineItem_Base_Bset_Debit1
  as select from P_Bset
{
  CompanyCode                     as CompanyCode,
  AccountingDocument              as AccountingDocument,
  FiscalYear                      as FiscalYear,
  TaxCode,

// for US and CDN restrict to top-most jurisdiction level as the lower ones will refer to the same base amount,

// i.e., aggregation would be invalid (where TXJLV = '1' will fail in case levels begin with '2')

  min(TaxJurisdictionLevel)       as TaxJurisdictionLevelDebit
}

where
       TaxBaseAmountInCoCodeCrcy > 0

group by
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxCode

Learn More