What is C_FR_TaxReturnBoxCube in SAP S/4HANA?

C_FR_TaxReturnBoxCube is a consumption CDS view in SAP S/4HANA. ATR enabled Tax Items for France Cube It contains 65 fields.

Which tables does C_FR_TaxReturnBoxCube read from?

C_FR_TaxReturnBoxCube reads data from: I_StRpTaxReturnBoxCube.

What VDM layer is C_FR_TaxReturnBoxCube?

C_FR_TaxReturnBoxCube is classified as a Consumption view optimized for specific business scenarios and reporting.

C_FR_TaxReturnBoxCube

DDL: C_FR_TAXRETURNBOXCUBE SQL: CFRTAXRETURNBOXC Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_FR

65 Fields 1 Data Sources

ATR enabled Tax Items for France Cube

C_FR_TaxReturnBoxCube is a Consumption CDS View (Cube) that provides data about "ATR enabled Tax Items for France Cube" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxReturnBoxCube) and exposes 65 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination. Part of development package GLO_FIN_IS_VAT_FR.

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 (14)

Name	Value	Level
AbapCatalog.sqlViewName	CFRTAXRETURNBOXC	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	ATR enabled Tax Items for France Cube	view
VDM.viewType	#CONSUMPTION	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.allowExtensions	true	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (65)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	TaxItem		TaxItem	Tax Item
KEY	TransactionTypeDetermination		TransactionTypeDetermination	Transaction Key
KEY	TaxBox		TaxBox	Tax.Bs.Gp.No.
KEY	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
KEY	SupplierAccountGroup		SupplierAccountGroup	Account group
KEY	DebitCreditCode		DebitCreditCode	Single-Character Flag
KEY	TaxDeclnAmountType		TaxDeclnAmountType
KEY	ValidityStartDate		TaxBoxStrucValidityStartDate
KEY	TaxGroup		TaxGroup	Tax Group
KEY	TaxItemGrpgDebitCreditCode		TaxItemGrpgDebitCreditCode
KEY	TaxItemGrpgAcctgDocumentType		TaxItemGrpgAcctgDocumentType
KEY	TaxItemGrpgSupplierAcctGroup		TaxItemGrpgSupplierAcctGroup
KEY	TaxItemGrpgSpecialGLCode		TaxItemGrpgSpecialGLCode
KEY	StatryRptgEntity		StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory		StatryRptCategory	Report ID
KEY	StatryRptRunID		StatryRptRunID	Report Run ID
	TaxCode		TaxCode	Tax Code
	Country	I_StRpTaxReturnBoxCube	Country	Venue: Ctry/Reg
	ValidityEndDate		TaxBoxStrucValidityEndDate
	TaxBoxName		TaxBoxName
	TaxItemGroupingVersion	I_StRpTaxReturnBoxCube	TaxItemGroupingVersion	Tax Grping Ver.
	TaxBoxStructureType		TaxBoxStructureType
	TaxBoxStructure		TaxBoxStructure
	TaxBoxStructureName		TaxBoxStructureName
	TaxBoxCondition		TaxBoxCondition
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	TaxCalculationProcedure		TaxCalculationProcedure	Tax Procedure
	TaxRate		TaxRate	Tax Rate
	TaxRateValidityStartDate		TaxRateValidityStartDate	Tax Rate Validity Start Date
	GLAccount		GLAccount	General Ledger
	TaxItemGroup		TaxItemGroup	Tax doc. item number
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	ReportingDate		ReportingDate
	TaxType		TaxType	Tax Type
	FiscalPeriod		FiscalPeriod	Tax period
	ExchangeRate		ExchangeRate	Exchange rate
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry		ReportingCountry
	TaxReturnCountry		TaxReturnCountry	Reporting C/R
	TaxTypeName		TaxTypeName
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	DocumentCurrency		DocumentCurrency	Document Currency
	ReportingCurrency		ReportingCurrency	Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	AmountInReportingCurrency		AmountInReportingCurrency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	TaxBaseAmountInRptgCrcy		TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy		TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCoCodeCrcy		TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy		TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount		TaxAmount	Tax Amt in Rptg Crcy
	NonDeductibleInputTaxAmount		NonDeductibleInputTaxAmount	Non-deductible
	TargetTaxCode		TargetTaxCode
	CAReconciliationKey		CAReconciliationKey	Reconcil. Key
	StatryRptRun		StatryRptRun
	TaxIsNotDeductible		TaxIsNotDeductible	Non-Deductible
	_TaxTypeText		_TaxTypeText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FR_TaxReturnBoxCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFRTAXRETURNBOXC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW C_FR_TaxReturnBoxCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TransactionTypeDetermination,
  TaxBox,
  AccountingDocumentType,
  SupplierAccountGroup,
  DebitCreditCode,
  TaxDeclnAmountType,
  TaxBoxStrucValidityStartDate AS ValidityStartDate,
  TaxGroup,
  TaxItemGrpgDebitCreditCode,
  TaxItemGrpgAcctgDocumentType,
  TaxItemGrpgSupplierAcctGroup,
  TaxItemGrpgSpecialGLCode,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  I_StRpTaxReturnBoxCube.Country AS Country,
  TaxBoxStrucValidityEndDate AS ValidityEndDate,
  TaxBoxName,
  I_StRpTaxReturnBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxBoxStructureType,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxCondition,
  TaxCountry,
  TaxCalculationProcedure,
  TaxRate,
  TaxRateValidityStartDate,
  GLAccount,
  TaxItemGroup,
  ReferenceDocumentType,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  ReportingDate,
  TaxType,
  FiscalPeriod,
  ExchangeRate,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  TaxTypeName,
  CompanyCodeCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  AmountInReportingCurrency,
  AmountInTransactionCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  NonDeductibleInputTaxAmount,
  TargetTaxCode,
  CAReconciliationKey,
  StatryRptRun,
  TaxIsNotDeductible
FROM I_StRpTaxReturnBoxCube
;

Depth:

C_FR_TaxReturnBoxCube view

I_StRpTaxReturnBoxCube view

C_FR_TaxReturnBoxQuery view