P_BaseAmtForNegativeCharge

DDL: P_BASEAMTFORNEGATIVECHARGE SQL: PBASEAMTNEGCHARE Type: view COMPOSITE Package: GLO_FIN_IS_VAT_GEN

Private view to return Base Amount for Neg Charge

P_BaseAmtForNegativeCharge is a Composite CDS View that provides data about "Private view to return Base Amount for Neg Charge" in SAP S/4HANA. It reads from 1 data source (I_TaxItem) and exposes 8 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem. Part of development package GLO_FIN_IS_VAT_GEN.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_TaxItem I_TaxItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PBASEAMTNEGCHARE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY TaxItem TaxItem
TaxRate
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy 
@AbapCatalog.sqlViewName: 'PBASEAMTNEGCHARE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
//@EndUserText.label: 'Private view to return Base Amount for Neg Charge'


define view P_BaseAmtForNegativeCharge
  as select from I_TaxItem
{

  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
  key TaxItem,
      Division(TaxRate,10,2)                              as TaxRate,
      
      cast (
         case DATS_IS_VALID(I_TaxItem.TaxReportingDate)
             when 1 then
             I_TaxItem.TaxReportingDate
             else
             _JournalEntry.PostingDate
      end as glo_reporting_date )                         as ReportingDate,
      
      TaxBaseAmountInCoCodeCrcy,
      TaxBaseAmountInTransCrcy,
      TaxBaseAmountInCountryCrcy

}
where
  TransactionTypeDetermination = 'ESA'

Learn More