Which tables does C_StRpTaxItemBoxLogQuery use?

C_StRpTaxItemBoxLogQuery reads from 1 data source(s): I_StRpTaxReturnBoxCube.

How many fields does C_StRpTaxItemBoxLogQuery have?

C_StRpTaxItemBoxLogQuery has 81 fields. Key fields: CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

C_StRpTaxItemBoxLogQuery

DDL: C_STRPTAXITEMBOXLOGQUERY SQL: CSRTXITMBOXLGQ Type: view CONSUMPTION

Analytical Query for Box Reporting With Rptd Item Log Data

C_StRpTaxItemBoxLogQuery is a Consumption CDS View that provides data about "Analytical Query for Box Reporting With Rptd Item Log Data" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxReturnBoxCube) and exposes 81 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (1)

Source	Alias	Join Type
I_StRpTaxReturnBoxCube	I_StRpTaxReturnBoxCube	from

Parameters (4)

Name	Type	Default
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id
P_ReportingCountry	land1

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CSRTXITMBOXLGQ	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_ALLOWED	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Analytics.query	true	view
EndUserText.label	Analytical Query for Box Reporting With Rptd Item Log Data	view

Fields (81)

Key	Field	Source Field
KEY	CompanyCode	CompanyCode
KEY	AccountingDocument	AccountingDocument
KEY	FiscalYear	FiscalYear
KEY	TaxItem	TaxItem
KEY	TaxCode	TaxCode
KEY	TransactionTypeDetermination	TransactionTypeDetermination
KEY	TaxBox	TaxBox
KEY	TaxDeclnAmountType	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	TaxItemGroupingVersion
KEY	StatryRptgEntity	StatryRptgEntity
KEY	StatryRptCategory	StatryRptCategory
KEY	StatryRptRunID	StatryRptRunID
KEY	TaxGroup	TaxGroup
KEY	TaxBoxStructure	TaxBoxStructure
	TaxRateValidityStartDate	TaxRateValidityStartDate
	DebitCreditCode	DebitCreditCode
	TaxRate	TaxRate
	GLAccount	GLAccount
	TaxItemGroup	TaxItemGroup
	BusinessPlace	BusinessPlace
	TaxJurisdiction	TaxJurisdiction
	LowestLevelTaxJurisdiction	LowestLevelTaxJurisdiction
	AccountingDocumentType	AccountingDocumentType
	ReferenceDocumentType	ReferenceDocumentType
	ReverseDocument	ReverseDocument
	ReverseDocumentFiscalYear	ReverseDocumentFiscalYear
	DocumentReferenceID	DocumentReferenceID
	Ledger	Ledger
	LedgerGroup	LedgerGroup
	DocumentDate	DocumentDate
	TaxReportingDate	TaxReportingDate
	FiscalPeriod	FiscalPeriod
	ExchangeRate	ExchangeRate
	IsReversal	IsReversal
	IsReversed	IsReversed
	AccountingDocumentHeaderText	AccountingDocumentHeaderText
	CompanyCodeCountry	CompanyCodeCountry
	ReportingCountry	ReportingCountry
	TaxReturnCountry	TaxReturnCountry
	ReportingDate	ReportingDate
	TaxReportingDocumentDate	TaxReportingDocumentDate
	PostingDate	PostingDate
	CompanyCodeCurrency	CompanyCodeCurrency
	CountryCurrency	CountryCurrency
	DocumentCurrency	DocumentCurrency
	ReportingCurrency	ReportingCurrency
	AdditionalCurrency1	AdditionalCurrency1
	AdditionalCurrency2	AdditionalCurrency2
	AmountInReportingCurrency	AmountInReportingCurrency
	AmountInTransactionCurrency	AmountInTransactionCurrency
	AmountInAdditionalCurrency1	AmountInAdditionalCurrency1
	AmountInAdditionalCurrency2	AmountInAdditionalCurrency2
	TaxBaseAmountInRptgCrcy	TaxBaseAmountInRptgCrcy
	CalculatedTxBaseAmtInTransCrcy	CalculatedTxBaseAmtInTransCrcy
	TaxAmountInRptgCrcy	TaxAmountInRptgCrcy
	CalculatedTaxAmountInTransCrcy	CalculatedTaxAmountInTransCrcy
	TaxBaseAmountInCoCodeCrcy	TaxBaseAmountInCoCodeCrcy
	TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy
	TaxBaseAmountInTransCrcy	TaxBaseAmountInTransCrcy
	TaxAmount	TaxAmount
	TaxBaseAmountInCountryCrcy	TaxBaseAmountInCountryCrcy
	TaxAmountInCountryCrcy	TaxAmountInCountryCrcy
	TaxBaseAmtInAdditionalCrcy1	TaxBaseAmtInAdditionalCrcy1
	TaxBaseAmtInAdditionalCrcy2	TaxBaseAmtInAdditionalCrcy2
	TaxAmountInAdditionalCurrency1	TaxAmountInAdditionalCurrency1
	TaxAmountInAdditionalCurrency2	TaxAmountInAdditionalCurrency2
	TaxType	TaxType
	TaxCalculationProcedure	TaxCalculationProcedure
	TargetTaxCode	TargetTaxCode
	ConditionType	ConditionType
	TaxNumber1	TaxNumber1
	TaxNumber2	TaxNumber2
	TaxNumber3	TaxNumber3
	BusinessPartner	BusinessPartner
	BusinessPartnerCountry	BusinessPartnerCountry
	BusinessPartnerName	BusinessPartnerName
	CustomerSupplierAddress	CustomerSupplierAddress
	TaxIsNotDeductible	TaxIsNotDeductible
	SenderCompanyCode	SenderCompanyCode
	SenderAccountingDocument	SenderAccountingDocument
	SenderFiscalYear	SenderFiscalYear

@AbapCatalog.sqlViewName: 'CSRTXITMBOXLGQ'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
--@AccessControl.authorizationCheck: #NOT_ALLOWED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics.query:true

@EndUserText.label: 'Analytical Query for Box Reporting With Rptd Item Log Data'
define view C_StRpTaxItemBoxLogQuery  with parameters

    P_StatryRptgEntity      : srf_reporting_entity,
    P_StatryRptCategory     : srf_rep_cat_id,
    P_StatryRptRunID        : srf_report_run_id,
    P_ReportingCountry      : land1
    

as select from I_StRpTaxReturnBoxCube          (                              
                                                   P_TaxIsDeferredRelevant : 'N',
                                                   P_TaxIsMossRelevant     : 'N',
                                                   P_StatryRptgEntity      : :P_StatryRptgEntity ,
                                                   P_StatryRptCategory     : :P_StatryRptCategory,
                                                   P_StatryRptRunID        : :P_StatryRptRunID,
                                                   P_ReportingCountry      : :P_ReportingCountry,
                                                   P_TaxBoxConfiguration   : '3'
                                                )   

{

      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key CompanyCode,
      @Consumption.filter : { selectionType: #SINGLE , multipleSelections : true}
  key AccountingDocument,
      @Consumption.filter : { selectionType: #SINGLE , multipleSelections : true}
  key FiscalYear,
  key TaxItem,
  key TaxCode,
  key TransactionTypeDetermination,
  key TaxBox,
      @Consumption.filter : { selectionType: #SINGLE , multipleSelections : true}
  key TaxDeclnAmountType,
      @Consumption.filter : { selectionType: #SINGLE , multipleSelections : true}
  key TaxItemGroupingVersion,
  key StatryRptgEntity,
  key StatryRptCategory,
  key StatryRptRunID,
  key TaxGroup,
  @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key TaxBoxStructure,

      TaxRateValidityStartDate,
      DebitCreditCode,
      
      @DefaultAggregation:#MIN
      TaxRate,
      GLAccount,
      TaxItemGroup,
      BusinessPlace,
      TaxJurisdiction,
      LowestLevelTaxJurisdiction,
      AccountingDocumentType,
      ReferenceDocumentType,
      ReverseDocument,
      ReverseDocumentFiscalYear,
      DocumentReferenceID,
      Ledger,
      LedgerGroup,

      DocumentDate,
      TaxReportingDate,
      FiscalPeriod,


      @DefaultAggregation:#MIN
      ExchangeRate,
      IsReversal,
      IsReversed,
      AccountingDocumentHeaderText,
      CompanyCodeCountry,
      ReportingCountry,
      TaxReturnCountry,
     @Consumption.filter : { selectionType: #RANGE , multipleSelections : true}
      ReportingDate,
      TaxReportingDocumentDate,


      @Consumption.filter : { selectionType: #RANGE , multipleSelections : true}
      PostingDate,
      @Semantics.currencyCode:true
      CompanyCodeCurrency,
      @Semantics.currencyCode:true
      CountryCurrency,
      @Semantics.currencyCode:true
      DocumentCurrency,
      @Semantics.currencyCode:true
      ReportingCurrency,
      @Semantics.currencyCode: true
      AdditionalCurrency1,
      @Semantics.currencyCode: true
      AdditionalCurrency2,



      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      AmountInReportingCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      AmountInTransactionCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      AmountInAdditionalCurrency1,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      AmountInAdditionalCurrency2,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      TaxBaseAmountInRptgCrcy,

      @DefaultAggregation:#FORMULA
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      CalculatedTxBaseAmtInTransCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      TaxAmountInRptgCrcy,

      @DefaultAggregation:#FORMULA
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      CalculatedTaxAmountInTransCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      TaxBaseAmountInCoCodeCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      TaxAmountInCoCodeCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TaxBaseAmountInTransCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TaxAmount,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CountryCurrency'
      TaxBaseAmountInCountryCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CountryCurrency'
      TaxAmountInCountryCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      TaxBaseAmtInAdditionalCrcy1,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      TaxBaseAmtInAdditionalCrcy2,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      TaxAmountInAdditionalCurrency1,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      TaxAmountInAdditionalCurrency2,


      TaxType,
      TaxCalculationProcedure,
      TargetTaxCode,
      ConditionType,
      //EUTaxClassification,

      TaxNumber1,
      TaxNumber2,
      TaxNumber3,
      BusinessPartner,
      BusinessPartnerCountry,
      BusinessPartnerName,
      CustomerSupplierAddress,
      TaxIsNotDeductible,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      SenderCompanyCode,
      SenderAccountingDocument,
      SenderFiscalYear
      //TaxBoxConfiguration

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

Depth:

C_StRpTaxItemBoxLogQuery view

I_StRpTaxReturnBoxCube view