What is C_FR_DueDeferredTaxItemQuery in SAP S/4HANA?

C_FR_DueDeferredTaxItemQuery is a consumption CDS view in SAP S/4HANA. Deferred Tax Item Query It contains 31 fields.

Which tables does C_FR_DueDeferredTaxItemQuery read from?

C_FR_DueDeferredTaxItemQuery reads data from: I_FR_DueDeferredTaxItemCube.

What VDM layer is C_FR_DueDeferredTaxItemQuery?

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

C_FR_DueDeferredTaxItemQuery

DDL: C_FR_DUEDEFERREDTAXITEMQUERY SQL: CSRFRDEFTXCITMQ Type: view CONSUMPTION

31 Fields 1 Data Sources

Deferred Tax Item Query

C_FR_DueDeferredTaxItemQuery is a Consumption CDS View that provides data about "Deferred Tax Item Query" in SAP S/4HANA. It reads from 1 data source (I_FR_DueDeferredTaxItemCube) and exposes 31 fields with key fields CompanyCode, FiscalYear, AccountingDocument, TaxItem, TaxCode.

Data Sources (1)

Source	Alias	Join Type
I_FR_DueDeferredTaxItemCube	I_FR_DueDeferredTaxItemCube	from

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CSRFRDEFTXCITMQ	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
AccessControl.authorizationCheck	#NOT_ALLOWED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Deferred Tax Item Query	view
AbapCatalog.preserveKey	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_FR_VATTAXITEMQUERY	view

Fields (31)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	TaxItem	TaxItem	Tax Item
KEY	TaxCode	TaxCode	Tax Code
KEY	TaxBox	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	TaxItemGroupingVersion	Tax Grping Ver.
KEY	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
KEY	TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
	DocumentDate	DocumentDate	Journal Entry Date
	PostingDate	PostingDate	Posting Date for GR
	StatryRptgEntity	StatryRptgEntity	Reporting Entity
	StatryRptCategory	StatryRptCategory	Report ID
	StatryRptRunID	StatryRptRunID	Report Run ID
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	DocumentCurrency	DocumentCurrency	Document Currency
	DocumentReferenceID	DocumentReferenceID	Reference
	GLAccount	GLAccount	General Ledger
	Country	Country	Venue: Ctry/Reg
	TaxInvoiceNumber	TaxInvoiceNumber
	TargetTaxCode	TargetTaxCode
	TaxRate	TaxRate	Tax Rate
	TaxBoxByTaxAuthority	TaxBoxByTaxAuthority
	TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInCoCodeCrcy	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxBaseAmountInTransCrcy	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	TaxAmount	Tax Amt in Rptg Crcy
	CalcdTxBaseAmtInCoCodeCrcy	CalcdTxBaseAmtInCoCodeCrcy
	CalculatedTxAmtInCoCodeCrcy	CalculatedTxAmtInCoCodeCrcy
	AccmltdBalAmtInCoCodeCrcy	AccmltdBalAmtInCoCodeCrcy

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_DueDeferredTaxItemQuery.
-- 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: CSRFRDEFTXCITMQ

CREATE VIEW C_FR_DueDeferredTaxItemQuery AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  TaxItem,
  TaxCode,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  AccountingDocumentType,
  TransactionTypeDetermination,
  DocumentDate,
  PostingDate,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCodeCurrency,
  DocumentCurrency,
  DocumentReferenceID,
  GLAccount,
  Country,
  TaxInvoiceNumber,
  TargetTaxCode,
  TaxRate,
  TaxBoxByTaxAuthority,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  CalcdTxBaseAmtInCoCodeCrcy,
  CalculatedTxAmtInCoCodeCrcy,
  AccmltdBalAmtInCoCodeCrcy
FROM I_FR_DueDeferredTaxItemCube
;

Depth:

C_FR_DueDeferredTaxItemQuery view

I_FR_DueDeferredTaxItemCube view