Deprecated
This CDS view is deprecated in S/4HANA. Use I_TaxBaseBalancesGroup instead. View all deprecated CDS views →

I_TaxBasisBalancesGrp

DDL: I_TAXBASISBALANCESGRP SQL: ITAXBASISBALGRP Type: view BASIC
8 Fields 1 Data Sources

Grouping Numbers of Tax Base Balances

I_TaxBasisBalancesGrp is a Basic CDS View that provides data about "Grouping Numbers of Tax Base Balances" in SAP S/4HANA. It reads from 1 data source (t007k) and exposes 8 fields with key fields Country, TaxItemGroupingVersion, TaxCode, TransactionTypeDetermination, DebitCreditCode.

Data Sources (1)

SourceAliasJoin Type
t007k t007k from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ITAXBASISBALGRP view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Grouping Numbers of Tax Base Balances view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_TaxBaseBalancesGroup view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Country
KEY TaxItemGroupingVersion t007k version XML Vers.
KEY TaxCode
KEY TransactionTypeDetermination
KEY DebitCreditCode
KEY TaxBasisBalancesGrp
TaxGroupOperation
char1endasHasNegativeSign

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 I_TaxBasisBalancesGrp.
-- 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: ITAXBASISBALGRP

CREATE VIEW I_TaxBasisBalancesGrp AS
SELECT
  cast(t007k.land1 as land1_gp) AS Country,
  t007k.version AS TaxItemGroupingVersion,
  cast(t007k.mwskz as fis_mwskz) AS TaxCode,
  cast(t007k.ktosl as fac_ktosl) AS TransactionTypeDetermination,
  cast(t007k.shkzg_umsv as fis_shkzg) AS DebitCreditCode,
  cast(t007k.basgruno as fis_taxbasbalgrp) AS TaxBasisBalancesGrp,
  cast(t007k.opera as txgrpgopera) AS TaxGroupOperation,
  case opera when '-' then cast('X' as abap.char(1)) else cast('' as abap.char(1)) end as HasNegativeSign AS char1endasHasNegativeSign
FROM t007k
;

Learn More