P_ID_StRpTaxItemBoxCube

DDL: P_ID_STRPTAXITEMBOXCUBE Type: view COMPOSITE Package: GLO_FIN_IS_VAT_ID

ID Tax Item Box Cube

P_ID_StRpTaxItemBoxCube is a Composite CDS View that provides data about "ID Tax Item Box Cube" in SAP S/4HANA. It reads from 2 data sources (P_ID_StRpTaxItemBoxCube0, I_TaxItem) and exposes 30 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode. It has 3 associations to related views. Part of development package GLO_FIN_IS_VAT_ID.

2 data source(s) 30 fields

Data Sources (2)

SourceAliasJoin Type
P_ID_StRpTaxItemBoxCube0 I_StRpTaxItem from
I_TaxItem I_TaxItem inner

Parameters (2)

NameTypeDefault
P_CompanyCode fis_bukrs
P_FiscalYear gjahr

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_CUSTOMERVENDORLINEITEM1 _CustomerSupplierLineItem _CustomerSupplierLineItem.CompanyCode = I_StRpTaxItem.CompanyCode and _CustomerSupplierLineItem.FiscalYear = I_StRpTaxItem.FiscalYear and I_StRpTaxItem.AccountingDocument = _CustomerSupplierLineItem.AccountingDocument
[0..1] I_OperationalAcctgDocItem _OperationalAcctgDocItem _OperationalAcctgDocItem.CompanyCode = I_StRpTaxItem.CompanyCode and _OperationalAcctgDocItem.FiscalYear = I_StRpTaxItem.FiscalYear and _OperationalAcctgDocItem.AccountingDocument = I_StRpTaxItem.AccountingDocument and ( _OperationalAcctgDocItem.FinancialAccountType = 'D' or _OperationalAcctgDocItem.FinancialAccountType = 'K' )
[0..*] I_JournalEntryItemOneTimeData _OneTimeAccountBP $projection.CompanyCode = _OneTimeAccountBP.CompanyCode and $projection.AccountingDocument = _OneTimeAccountBP.AccountingDocument and $projection.FiscalYear = _OneTimeAccountBP.FiscalYear

Annotations (7)

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

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_ID_StRpTaxItemBoxCube0 CompanyCode
KEY AccountingDocument P_ID_StRpTaxItemBoxCube0 AccountingDocument
KEY FiscalYear P_ID_StRpTaxItemBoxCube0 FiscalYear
KEY TaxItem P_ID_StRpTaxItemBoxCube0 TaxItem
KEY TaxCode P_ID_StRpTaxItemBoxCube0 TaxCode
KEY TransactionTypeDetermination P_ID_StRpTaxItemBoxCube0 TransactionTypeDetermination
DocumentReferenceID P_ID_StRpTaxItemBoxCube0 DocumentReferenceID
SenderLogicalSystem SenderLogicalSystem
OriginalReferenceDocument OriginalReferenceDocument
PostingDate PostingDate
DocumentDate DocumentDate
ReportingCountry ReportingCountry
DebitCreditCode I_TaxItem DebitCreditCode
AccountingDocumentType AccountingDocumentType
SupplierAccountGroup
IsNegativePosting _OperationalAcctgDocItem IsNegativePosting
BusinessPartnerCountry
TaxRate P_ID_StRpTaxItemBoxCube0 TaxRate
TaxRateValidityStartDate P_ID_StRpTaxItemBoxCube0 TaxRateValidityStartDate
Ledger P_ID_StRpTaxItemBoxCube0 Ledger
TaxReportingDate
BusinessPlace P_ID_StRpTaxItemBoxCube0 BusinessPlace
Customer _CustomerSupplierLineItem Customer
DocumentCurrency P_ID_StRpTaxItemBoxCube0 DocumentCurrency
TaxBaseAmountInTransCrcy P_ID_StRpTaxItemBoxCube0 TaxBaseAmountInTransCrcy
TaxAmountInTransCrcy P_ID_StRpTaxItemBoxCube0 TaxAmountInTransCrcy
CompanyCodeCurrency P_ID_StRpTaxItemBoxCube0 CompanyCodeCurrency
TaxBaseAmountInCoCodeCrcy P_ID_StRpTaxItemBoxCube0 TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy P_ID_StRpTaxItemBoxCube0 TaxAmountInCoCodeCrcy
_OperationalAcctgDocItem _OperationalAcctgDocItem 
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@AbapCatalog: {sqlViewName: 'PIDSTRPTAXITMBC', preserveKey: true, compiler.compareFilter: true}
@VDM: {private: true, viewType: #COMPOSITE}
@ClientHandling: {algorithm: #SESSION_VARIABLE}
define view P_ID_StRpTaxItemBoxCube
  with parameters
    @EndUserText.label: 'Company Code'
    P_CompanyCode : fis_bukrs,
    P_FiscalYear  : gjahr
  as select from           P_ID_StRpTaxItemBoxCube0  as I_StRpTaxItem
    inner join   I_TaxItem on  I_TaxItem.CompanyCode        = $parameters.P_CompanyCode
                           and I_TaxItem.FiscalYear         = $parameters.P_FiscalYear
                           and I_StRpTaxItem.AccountingDocument = I_TaxItem.AccountingDocument
                           and I_StRpTaxItem.TaxItem            = I_TaxItem.TaxItem
  association [0..1] to P_CUSTOMERVENDORLINEITEM1 as _CustomerSupplierLineItem on  _CustomerSupplierLineItem.CompanyCode = I_StRpTaxItem.CompanyCode
                                                                               and _CustomerSupplierLineItem.FiscalYear  = I_StRpTaxItem.FiscalYear
                                                                               and I_StRpTaxItem.AccountingDocument      = _CustomerSupplierLineItem.AccountingDocument

  association [0..1] to I_OperationalAcctgDocItem as _OperationalAcctgDocItem  on  _OperationalAcctgDocItem.CompanyCode            = I_StRpTaxItem.CompanyCode
                                                                               and _OperationalAcctgDocItem.FiscalYear             = I_StRpTaxItem.FiscalYear
                                                                               and _OperationalAcctgDocItem.AccountingDocument     = I_StRpTaxItem.AccountingDocument
                                                                               and (
                                                                                  _OperationalAcctgDocItem.FinancialAccountType    = 'D'
                                                                                  or _OperationalAcctgDocItem.FinancialAccountType = 'K'
                                                                                )
  association [0..*] to I_JournalEntryItemOneTimeData as _OneTimeAccountBP on  $projection.CompanyCode        = _OneTimeAccountBP.CompanyCode
                                                                              and $projection.AccountingDocument = _OneTimeAccountBP.AccountingDocument
                                                                              and $projection.FiscalYear         = _OneTimeAccountBP.FiscalYear
{

  key I_StRpTaxItem.CompanyCode,
  key I_StRpTaxItem.AccountingDocument,
  key I_StRpTaxItem.FiscalYear,
  key I_StRpTaxItem.TaxItem,
  key I_StRpTaxItem.TaxCode,
  key I_StRpTaxItem.TransactionTypeDetermination,
      I_StRpTaxItem.DocumentReferenceID,
      SenderLogicalSystem,
      OriginalReferenceDocument,
      PostingDate,
      DocumentDate,
      ReportingCountry,

      I_TaxItem.DebitCreditCode,

      //I_StRpTaxItem.DebitCreditCodeCalc                                                                                                                                       as DebitCreditCode,

      AccountingDocumentType,
      _OperationalAcctgDocItem._Supplier.SupplierAccountGroup,
      _OperationalAcctgDocItem.IsNegativePosting,

      coalesce( _OneTimeAccountBP.Country , coalesce( _CustomerSupplierLineItem._Supplier.Country , _CustomerSupplierLineItem._Customer.Country ) ) as BusinessPartnerCountry,

      I_StRpTaxItem.TaxRate,
      I_StRpTaxItem.TaxRateValidityStartDate,
      I_StRpTaxItem.Ledger,
      case when ( I_StRpTaxItem.TaxReportingDate = '00000000' ) then PostingDate else I_StRpTaxItem.TaxReportingDate end                                                        as TaxReportingDate,
      I_StRpTaxItem.BusinessPlace,
      _CustomerSupplierLineItem.Customer,
      I_StRpTaxItem.DocumentCurrency,
      I_StRpTaxItem.TaxBaseAmountInTransCrcy,
      I_StRpTaxItem.TaxAmountInTransCrcy,
      //I_StRpTaxItem.TaxAmount                                                                                                                                                 as TaxAmountInTransCrcy,

      I_StRpTaxItem.CompanyCodeCurrency,
      I_StRpTaxItem.TaxBaseAmountInCoCodeCrcy,
      I_StRpTaxItem.TaxAmountInCoCodeCrcy,
      //_OneTimeAccountBP,

      _OperationalAcctgDocItem
}
where
      I_StRpTaxItem.CompanyCode = $parameters.P_CompanyCode
  and I_StRpTaxItem.FiscalYear  = $parameters.P_FiscalYear

Learn More