What is C_TR_PurSlsTaxItemLogQuery in SAP S/4HANA?

C_TR_PurSlsTaxItemLogQuery is a consumption CDS view in SAP S/4HANA. Analytical Query displaying Turkey Purchase Sales Tax Items It contains 68 fields.

Which tables does C_TR_PurSlsTaxItemLogQuery read from?

C_TR_PurSlsTaxItemLogQuery reads data from: C_TR_PurSlsTaxItemLogCube.

What VDM layer is C_TR_PurSlsTaxItemLogQuery?

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

C_TR_PurSlsTaxItemLogQuery

DDL: C_TR_PURSLSTAXITEMLOGQUERY SQL: CTRPRSLSTXITMLGQ Type: view CONSUMPTION

68 Fields 1 Data Sources

Analytical Query displaying Turkey Purchase Sales Tax Items

C_TR_PurSlsTaxItemLogQuery is a Consumption CDS View that provides data about "Analytical Query displaying Turkey Purchase Sales Tax Items" in SAP S/4HANA. It reads from 1 data source (C_TR_PurSlsTaxItemLogCube) and exposes 68 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, StatryRptgEntity.

Data Sources (1)

Source	Alias	Join Type
C_TR_PurSlsTaxItemLogCube	C_TR_PurSlsTaxItemLogCube	from

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CTRPRSLSTXITMLGQ	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Analytics.query	true	view
EndUserText.label	Analytical Query displaying Turkey Purchase Sales Tax Items	view

Fields (68)

Key	Field	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	StatryRptgEntity	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	StatryRptCategory	Report ID
KEY	StatryRptRunID	StatryRptRunID	Report Run ID
KEY	TaxCode	TaxCode	Tax Code
KEY	TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
	PostingDate	PostingDate	Posting Date for GR
	DocumentDate	DocumentDate	Journal Entry Date
	TaxReportingDate	TaxReportingDate	Tax Reporting Date
	TaxItemGroup	TaxItemGroup	Tax doc. item number
	FiscalPeriod	FiscalPeriod	Tax period
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	AccountingDocumentHeaderText	AccountingDocumentHeaderText	Doc.Header Text
	DocumentReferenceID	DocumentReferenceID	Reference
	FinancialAccountType	FinancialAccountType	Fin. Account Type
	CompanyCodeCountry	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	ReportingCountry
	TaxReturnCountry	TaxReturnCountry	Reporting C/R
	MiniOneStopShopTxRptgCntry	MiniOneStopShopTxRptgCntry
	ReportingDate	ReportingDate
	ExchangeRate	ExchangeRate	Exchange rate
	TaxRate	TaxRate	Tax Rate
	GLAccount	GLAccount	General Ledger
	BusinessPlace	BusinessPlace	Business place
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	LowestLevelTaxJurisdiction	Jurisdict. Code
	TaxCalculationProcedure	TaxCalculationProcedure	Tax Procedure
	TargetTaxCode	TargetTaxCode
	TaxNumber1	TaxNumber1	VAT Reg. No.
	TaxNumber2	TaxNumber2	Tax Number 2
	TaxNumber3	TaxNumber3
	BusinessPartner	BusinessPartner	Issuing Authority
	BusinessPartnerName	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	CustomerSupplierAddress
	ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
	ReverseDocument	ReverseDocument	Reversed With
	ReverseDocumentFiscalYear	ReverseDocumentFiscalYear	Year
	CountryAlternativeCode	CountryAlternativeCode
	Ledger	Ledger	Ledger
	LedgerGroup	LedgerGroup	Ledger Group
	IsReversal	IsReversal	Reversal doc.
	IsReversed	IsReversed	Reversed?
	ConditionType	ConditionType	Condition type
	EUTaxClassification	EUTaxClassification
	TaxType	TaxType	Tax Type
	TaxIsNotDeductible	TaxIsNotDeductible	Non-Deductible
	ReportingCurrency	ReportingCurrency	Currency
	CountryCurrency	CountryCurrency	Currency
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	DocumentCurrency	DocumentCurrency	Document Currency
	AdditionalCurrency1	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCountryCrcy	TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy	TaxAmountInCountryCrcy	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
	TaxBaseAmtInAdditionalCrcy1	TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxAmountInAdditionalCurrency1	TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxBaseAmtInAdditionalCrcy2	TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency2	TaxAmountInAdditionalCurrency2	LC 3 Tax
	TotalNumberOfAcctgDocs	1

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_TR_PurSlsTaxItemLogQuery.
-- 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: CTRPRSLSTXITMLGQ

CREATE VIEW C_TR_PurSlsTaxItemLogQuery AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  TransactionTypeDetermination,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxItemGroup,
  FiscalPeriod,
  AccountingDocumentType,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  FinancialAccountType,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  MiniOneStopShopTxRptgCntry,
  ReportingDate,
  ExchangeRate,
  TaxRate,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxCalculationProcedure,
  TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  CountryAlternativeCode,
  Ledger,
  LedgerGroup,
  IsReversal,
  IsReversed,
  ConditionType,
  EUTaxClassification,
  TaxType,
  TaxIsNotDeductible,
  ReportingCurrency,
  CountryCurrency,
  CompanyCodeCurrency,
  DocumentCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2,
  1 AS TotalNumberOfAcctgDocs
FROM C_TR_PurSlsTaxItemLogCube
;

Depth:

C_TR_PurSlsTaxItemLogQuery view

C_TR_PurSlsTaxItemLogCube view