I_StRpTaxItemGrpg

DDL: I_STRPTAXITEMGRPG SQL: ISRTAXITEMGRPG Type: view COMPOSITE Package: GLO_FIN_IS_VAT_GEN
47 Fields 2 Data Sources 3 Associations

Tax Item Grouping For Statutory Reporting

I_StRpTaxItemGrpg is a Composite CDS View that provides data about "Tax Item Grouping For Statutory Reporting" in SAP S/4HANA. It reads from 2 data sources (I_StRpCompatibleTxBoxStructure, P_StRpTaxItemVersionGrpg) and exposes 47 fields with key fields Country, TaxItemGroupingVersion, TaxCode, TransactionTypeDetermination, DebitCreditCode. It has 3 associations to related views. Part of development package GLO_FIN_IS_VAT_GEN.

Data Sources (2)

SourceAliasJoin Type
I_StRpCompatibleTxBoxStructure I_StRpCompatibleTxBoxStructure from
P_StRpTaxItemVersionGrpg P_StRpTaxItemVersionGrpg union_all

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_TaxDeclnAmountType _TaxDeclnAmountType $projection.TaxDeclnAmountType = _TaxDeclnAmountType.TaxDeclnAmountType
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..*] I_TaxCode _TaxCode $projection.TaxCode = _TaxCode.TaxCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISRTAXITEMGRPG view
EndUserText.label Tax Item Grouping For Statutory Reporting view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY Country I_StRpCompatibleTxBoxStructure Country Venue: Ctry/Reg
KEY TaxItemGroupingVersion Tax Grping Ver.
KEY TaxCode I_StRpCompatibleTxBoxStructure TaxCode Tax Code
KEY TransactionTypeDetermination I_StRpCompatibleTxBoxStructure TransactionTypeDetermination Transaction Key
KEY DebitCreditCode I_StRpCompatibleTxBoxStructure DebitCreditCode Single-Character Flag
KEY TaxBox I_StRpCompatibleTxBoxStructure TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType I_StRpCompatibleTxBoxStructure TaxDeclnAmountType
KEY ValidFrom I_StRpCompatibleTxBoxStructure ValidFrom Vers.Valid From
KEY TaxBoxStructureType I_StRpCompatibleTxBoxStructure TaxBoxStructureType
KEY TaxGroup I_StRpCompatibleTxBoxStructure TaxGroup Tax Group
KEY AccountingDocumentType I_StRpCompatibleTxBoxStructure AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup I_StRpCompatibleTxBoxStructure SupplierAccountGroup Account group
KEY SpecialGLCode I_StRpCompatibleTxBoxStructure SpecialGLCode Special G/L Ind
TaxBoxStructure I_StRpCompatibleTxBoxStructure TaxBoxStructure
TaxBoxStructureName I_StRpCompatibleTxBoxStructure TaxBoxStructureName
TaxBoxName I_StRpCompatibleTxBoxStructure TaxBoxName
TaxBoxCondition I_StRpCompatibleTxBoxStructure TaxBoxCondition
TaxRate I_StRpCompatibleTxBoxStructure TaxRate Tax Rate
TaxGroupOperation I_StRpCompatibleTxBoxStructure TaxGroupOperation
TaxBoxAggregationOperation I_StRpCompatibleTxBoxStructure TaxBoxAggregationOperation
TaxBoxConfiguration
_Country _Country
_TaxDeclnAmountType _TaxDeclnAmountType
Country Venue: Ctry/Reg
KEY TaxItemGroupingVersion P_StRpTaxItemVersionGrpg TaxItemGroupingVersion Tax Grping Ver.
KEY TaxCode P_StRpTaxItemVersionGrpg TaxCode Tax Code
KEY TransactionTypeDetermination P_StRpTaxItemVersionGrpg TransactionTypeDetermination Transaction Key
KEY DebitCreditCode P_StRpTaxItemVersionGrpg DebitCreditCode Single-Character Flag
KEY TaxBox P_StRpTaxItemVersionGrpg TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType P_StRpTaxItemVersionGrpg TaxDeclnAmountType
KEY ValidFrom Vers.Valid From
KEY TaxBoxStructureType
KEY TaxGroup Tax Group
KEY AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup Account group
KEY SpecialGLCode Special G/L Ind
TaxBoxStructure
TaxBoxStructureName
TaxBoxName
TaxBoxCondition
TaxRate 0 Tax Rate
TaxGroupOperation
TaxBoxAggregationOperation
TaxBoxConfiguration
_Country _Country
_TaxDeclnAmountType _TaxDeclnAmountType
_TaxCode _TaxCode

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_StRpTaxItemGrpg.
-- 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: ISRTAXITEMGRPG

CREATE VIEW I_StRpTaxItemGrpg AS
SELECT
  I_StRpCompatibleTxBoxStructure.Country AS Country,
  cast('' as verstax) AS TaxItemGroupingVersion,
  I_StRpCompatibleTxBoxStructure.TaxCode AS TaxCode,
  I_StRpCompatibleTxBoxStructure.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpCompatibleTxBoxStructure.DebitCreditCode AS DebitCreditCode,
  I_StRpCompatibleTxBoxStructure.TaxBox AS TaxBox,
  I_StRpCompatibleTxBoxStructure.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpCompatibleTxBoxStructure.ValidFrom AS ValidFrom,
  I_StRpCompatibleTxBoxStructure.TaxBoxStructureType AS TaxBoxStructureType,
  I_StRpCompatibleTxBoxStructure.TaxGroup AS TaxGroup,
  I_StRpCompatibleTxBoxStructure.AccountingDocumentType AS AccountingDocumentType,
  I_StRpCompatibleTxBoxStructure.SupplierAccountGroup AS SupplierAccountGroup,
  I_StRpCompatibleTxBoxStructure.SpecialGLCode AS SpecialGLCode,
  I_StRpCompatibleTxBoxStructure.TaxBoxStructure AS TaxBoxStructure,
  I_StRpCompatibleTxBoxStructure.TaxBoxStructureName AS TaxBoxStructureName,
  I_StRpCompatibleTxBoxStructure.TaxBoxName AS TaxBoxName,
  I_StRpCompatibleTxBoxStructure.TaxBoxCondition AS TaxBoxCondition,
  I_StRpCompatibleTxBoxStructure.TaxRate AS TaxRate,
  I_StRpCompatibleTxBoxStructure.TaxGroupOperation AS TaxGroupOperation,
  I_StRpCompatibleTxBoxStructure.TaxBoxAggregationOperation AS TaxBoxAggregationOperation,
  '2' AS TaxBoxConfiguration
FROM I_StRpCompatibleTxBoxStructure
LEFT OUTER JOIN I_TaxDeclnAmountType AS _TaxDeclnAmountType ON TaxDeclnAmountType = _TaxDeclnAmountType.TaxDeclnAmountType  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode  -- association [0..*]
-- UNION ALL with additional select branch(es): P_StRpTaxItemVersionGrpg
;

Learn More