C_TW_FixedAssetTaxQuery

DDL: C_TW_FIXEDASSETTAXQUERY SQL: CTWFATAXQUERY Type: view CONSUMPTION
32 Fields 1 Data Sources

Analytical Query of Fixed Asset Tax Item

C_TW_FixedAssetTaxQuery is a Consumption CDS View that provides data about "Analytical Query of Fixed Asset Tax Item" in SAP S/4HANA. It reads from 1 data source (I_TW_FixedAssetTaxCube) and exposes 32 fields with key fields AccountingDocument, CompanyCode, FiscalYear, TaxItemGroup, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_TW_FixedAssetTaxCube I_TW_FixedAssetTaxCube from

Parameters (4)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_StatryRptRunType srf_report_run_type

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CTWFATAXQUERY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Analytical Query of Fixed Asset Tax Item view
Analytics.query true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument AccountingDocument Journal Entry
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY TaxItemGroup TaxItemGroup Tax doc. item number
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY TaxGroup TaxGroup Tax Group
TaiwaneseCalendarYear TaiwaneseCalendarYear
FiscalPeriod FiscalPeriod Tax period
DistrictTaxOffice DistrictTaxOffice
SupplierTaxID1 SupplierTaxID1
SupplierTaxID2 SupplierTaxID2
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
ReportingDate ReportingDate
DisplayDocumentDate DisplayDocumentDate
DocumentReferenceID DocumentReferenceID Reference
FixedAssetDescription FixedAssetDescription Description
Quantity Quantity Value
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
AssetAdditionalDescription AssetAdditionalDescription
TaxAmount TaxAmount Tax Amt in Rptg Crcy
BusinessPlace BusinessPlace Business place
Supplier Supplier Supplier
SupplierCountry SupplierCountry
Customer Customer Sold-to Party
CustomerCountry CustomerCountry
AccountingDocumentClass AccountingDocumentClass
TaxCode TaxCode Tax Code
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxRate TaxRate Tax Rate

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_TW_FixedAssetTaxQuery.
-- 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: CTWFATAXQUERY
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_StatryRptRunType : srf_report_run_type

CREATE VIEW C_TW_FixedAssetTaxQuery AS
SELECT
  AccountingDocument,
  CompanyCode,
  FiscalYear,
  TaxItemGroup,
  AccountingDocumentItem,
  TaxGroup,
  TaiwaneseCalendarYear,
  FiscalPeriod,
  DistrictTaxOffice,
  SupplierTaxID1,
  SupplierTaxID2,
  DocumentDate,
  PostingDate,
  ReportingDate,
  DisplayDocumentDate,
  DocumentReferenceID,
  FixedAssetDescription,
  Quantity,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TaxAmountInCoCodeCrcy,
  AssetAdditionalDescription,
  TaxAmount,
  BusinessPlace,
  Supplier,
  SupplierCountry,
  Customer,
  CustomerCountry,
  AccountingDocumentClass,
  TaxCode,
  TaxRateValidityStartDate,
  TaxRate
FROM I_TW_FixedAssetTaxCube
;

Learn More