What is C_CA_StRpGSTTaxAmtDivisionC in SAP S/4HANA?

C_CA_StRpGSTTaxAmtDivisionC is a consumption CDS view in SAP S/4HANA. View to bifurcate TaxBaseamt It contains 80 fields.

Which tables does C_CA_StRpGSTTaxAmtDivisionC read from?

C_CA_StRpGSTTaxAmtDivisionC reads data from: C_CA_StRpGSTItemCube.

What VDM layer is C_CA_StRpGSTTaxAmtDivisionC?

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

C_CA_StRpGSTTaxAmtDivisionC

DDL: C_CA_STRPGSTTAXAMTDIVISIONC SQL: CCASRGSTAMTDIVC Type: view CONSUMPTION

80 Fields 1 Data Sources

View to bifurcate TaxBaseamt

C_CA_StRpGSTTaxAmtDivisionC is a Consumption CDS View (Cube) that provides data about "View to bifurcate TaxBaseamt" in SAP S/4HANA. It reads from 1 data source (C_CA_StRpGSTItemCube) and exposes 80 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (1)

Source	Alias	Join Type
C_CA_StRpGSTItemCube	C_CA_StRpGSTItemCube	from

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CCASRGSTAMTDIVC	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	View to bifurcate TaxBaseamt	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.allowExtensions	true	view
AccessControl.blocking	#BLOCKED_DATA_INCLUDED	view

Fields (80)

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	TaxCode	TaxCode	Tax Code
KEY	TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
KEY	TaxBox	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TaxBoxStrucValidityStartDate	ValidFrom	Vers.Valid From
	VarblDataValidFromDate
KEY	TaxGroup	TaxGroup	Tax Group
KEY	TaxBoxStructureType	TaxBoxStructureType
KEY	StatryRptCategory	StatryRptCategory	Report ID
KEY	StatryRptgEntity	StatryRptgEntity	Reporting Entity
KEY	StatryRptRunID	StatryRptRunID	Report Run ID
	StatryRptRun	StatryRptRun
	TxJxIsFedGvmntTaxRelevant	TxJxIsFedGvmntTaxRelevant
	DebitCreditCode	DebitCreditCode	Single-Character Flag
	TaxRate	TaxRate	Tax Rate
	GLAccount	GLAccount	General Ledger
	TaxItemGroup	TaxItemGroup	Tax doc. item number
	BusinessPlace	BusinessPlace	Business place
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	LowestLevelTaxJurisdiction	Jurisdict. Code
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
	ReverseDocument	ReverseDocument	Reversed With
	ReverseDocumentFiscalYear	ReverseDocumentFiscalYear	Year
	DocumentReferenceID	DocumentReferenceID	Reference
	Ledger	Ledger	Ledger
	LedgerGroup		Ledger Group
	PostingDate	PostingDate	Posting Date for GR
	DocumentDate	DocumentDate	Journal Entry Date
	TaxReportingDate	TaxReportingDate	Tax Reporting Date
	FiscalPeriod	FiscalPeriod	Tax period
	ExchangeRate		Exchange rate
	IsReversal	IsReversal	Reversal doc.
	IsReversed	IsReversed	Reversed?
	AccountingDocumentHeaderText	AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	ReportingCountry
	TaxReturnCountry	TaxReturnCountry	Reporting C/R
	ReportingDate	ReportingDate
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	CountryCurrency	CountryCurrency	Currency
	DocumentCurrency	DocumentCurrency	Document Currency
	ReportingCurrency	ReportingCurrency	Currency
	AdditionalCurrency1	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	TaxAmountInRptgCrcy	Tax Rept. Crcy
	CalculatedTaxBaseAmtInRptgCrcy	CalculatedTaxBaseAmtInRptgCrcy
	TaxBaseAmountInCoCodeCrcy	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	TaxAmount	Tax Amt in Rptg Crcy
	CAReconciliationKey	CAReconciliationKey	Reconcil. Key
	TaxType	TaxType	Tax Type
	TaxCalculationProcedure	TaxCalculationProcedure	Tax Procedure
	TargetTaxCode	TargetTaxCode
	ConditionType	ConditionType	Condition type
	EUTaxClassification	EUTaxClassification
	TaxNumber1	TaxNumber1	VAT Reg. No.
	TaxNumber2	TaxNumber2	Tax Number 2
	TaxNumber3	TaxNumber3
	BusinessPartner	BusinessPartner	Issuing Authority
	BusinessPartnerName	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress
	TaxIsNotDeductible	TaxIsNotDeductible	Non-Deductible
	MiniOneStopShopTxRptgCntry	MiniOneStopShopTxRptgCntry
	Supplier	Supplier	Supplier
	Customer	Customer	Sold-to Party
	TaxBoxStructure	TaxBoxStructure
	TaxBoxStructureName	TaxBoxStructureName
	TaxBoxName	TaxBoxName
	TaxBoxCondition	TaxBoxCondition
	SupplierAccountGroup	SupplierAccountGroup	Account group
	TaxBoxAggregationOperation	TaxBoxAggregationOperation
	TaxGroupOperation	TaxGroupOperation

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_CA_StRpGSTTaxAmtDivisionC.
-- 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: CCASRGSTAMTDIVC

CREATE VIEW C_CA_StRpGSTTaxAmtDivisionC AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom AS TaxBoxStrucValidityStartDate,
  TaxGroup,
  TaxBoxStructureType,
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  StatryRptRun,
  TxJxIsFedGvmntTaxRelevant,
  DebitCreditCode,
  TaxRate,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  cast(LedgerGroup as fagl_ldgrp) AS LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  cast(ExchangeRate as fis_absolute_exchangerate preserving type) AS ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  ReportingDate,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  CalculatedTaxBaseAmtInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  CAReconciliationKey,
  TaxType,
  TaxCalculationProcedure,
  TargetTaxCode,
  ConditionType,
  EUTaxClassification,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  cast(CustomerSupplierAddress as adrnr) AS CustomerSupplierAddress,
  TaxIsNotDeductible,
  MiniOneStopShopTxRptgCntry,
  Supplier,
  Customer,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation
FROM C_CA_StRpGSTItemCube
;

Depth:

C_CA_StRpGSTTaxAmtDivisionC view

C_CA_StRpGSTItemCube view

C_CA_StRpGSTItemQuery view