P_BSET

@AbapCatalog.sqlViewName: 'PFIBSET'
//@EndUserText.label: 'Basic Tax Item'

@AccessControl.authorizationCheck: #NOT_REQUIRED
//@Analytics: { dataCategory: #FACT, dataExtraction.enabled: false }

@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true

////////////////////////////////////////////////////////////////////

// This privat view is intended to select data from bset only     //

// For other enriched usages I_Taxitem is available               //

////////////////////////////////////////////////////////////////////


////////////////////////////////////////////////////////////////////

// ########## REMARK ##########################################   //

// The sing determination of the signs on the Amoun fields,       //

// corresponds to the behavior on SAP GUI of fb03 - tax data.     //

//         case shkzg                                             //

//         when 'S' then  XYZ                                     //

//         when 'H' then -XYZ                                     //

// ########## REMARK ##########################################   //

////////////////////////////////////////////////////////////////////



define view P_Bset
  as select from bset

{
  key bukrs as CompanyCode,
  key belnr as AccountingDocument,
  key gjahr as FiscalYear, 
  key cast(buzei as taxitem preserving type) as TaxItem,

      mwskz as TaxCode,
      hkont as GLAccount,
      txgrp as TaxItemGroup,

      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  hwbas
        when 'H' then -hwbas   // see REMARK on top

      end   as TaxBaseAmountInCoCodeCrcy,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  fwbas
        when 'H' then -fwbas   // see REMARK on top

      end   as TaxBaseAmountInTransCrcy,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  hwste
        when 'H' then -hwste   // see REMARK on top

      end   as TaxAmountInCoCodeCrcy,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  fwste
        when 'H' then -fwste   // see REMARK on top

      end   as TaxAmount,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  h2ste
        when 'H' then -h2ste   // see REMARK on top

      end   as TaxAmountInAdditionalCurrency1,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  h3ste
        when 'H' then -h3ste   // see REMARK on top

      end   as TaxAmountInAdditionalCurrency2,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  h2bas
        when 'H' then -h2bas   // see REMARK on top

      end   as TaxBaseAmtInAdditionalCrcy1,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  h3bas
        when 'H' then -h3bas   // see REMARK on top

      end   as TaxBaseAmtInAdditionalCrcy2,


      ktosl as TransactionTypeDetermination,
      knumh as ConditionRecord,
      stceg as VATRegistration,
      egbld as DestinationCountry,
      eglld as SupplyingCountry,
      txjcd as TaxJurisdiction,

      kschl as ConditionType,
      stmdt as TaxReturnDate,
      stmti as TaxReturnExecutionTime ,   // !!! New global field name!

      mlddt as TaxReportingDate,
      kbetr as TaxRate,
      //STBKZ as PostingIndicator,   // !!! New global field name!

      lstml as TaxReturnCountry,

      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  lwste
        when 'H' then -lwste   // see REMARK on top

      end   as TaxAmountInCountryCrcy,
      @DefaultAggregation:#SUM
      case shkzg
        when 'S' then  lwbas
        when 'H' then -lwbas   // see REMARK on top

      end   as TaxBaseAmountInCountryCrcy,
      txdat as TaxDeterminationDate,
      bupla as BusinessPlace,
      txjdp as LowestLevelTaxJurisdiction,
      txjlv as TaxJurisdictionLevel,
      taxps as TaxItemAcctgDocItemRef,
      txmod as TaxResultManualModification,
      shkzg as DebitCreditCode,
      txdat_from as TaxRateValidityStartDate,
      tax_country as TaxCountry

};   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BSET"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/