P_StRpTaxItemGrpgWithDocType

DDL: P_STRPTAXITEMGRPGWITHDOCTYPE Type: view_entity COMPOSITE
12 Fields 2 Data Sources

P_StRpTaxItemGrpgWithDocType is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_AccountingDocumentType, I_StRpTaxItemGrouping) and exposes 12 fields with key fields country, TaxBox, TaxCode, TransactionTypeDetermination, TaxDeclnAmountType.

Data Sources (2)

SourceAliasJoin Type
I_AccountingDocumentType doctype inner
I_StRpTaxItemGrouping I_StRpTaxItemGrouping from

Parameters (1)

NameTypeDefault
P_Country land1_gp

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY country taxitem Country Venue: Ctry/Reg
KEY TaxBox taxitem TaxBox Tax.Bs.Gp.No.
KEY TaxCode taxitem TaxCode Tax Code
KEY TransactionTypeDetermination taxitem TransactionTypeDetermination Transaction Key
KEY TaxDeclnAmountType taxitem TaxDeclnAmountType
KEY AccountingDocumentType I_AccountingDocumentType AccountingDocumentType Journal Entry Type
KEY TaxItemGroupingVersion taxitem TaxItemGroupingVersion Tax Grping Ver.
TaxBoxConfiguration taxitem TaxBoxConfiguration
TaxGroupOperation taxitem TaxGroupOperation
TaxGroupFreeClassification taxitem TaxGroupFreeClassification
TaxBoxStrucValidityStartDate taxitem TaxBoxStrucValidityStartDate Vers.Valid From
TaxBoxStrucValidityEndDate taxitem TaxBoxStrucValidityEndDate Vers.Valid To

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 P_StRpTaxItemGrpgWithDocType.
-- 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.
-- Parameters: P_Country : land1_gp

CREATE VIEW P_StRpTaxItemGrpgWithDocType AS
SELECT
  taxitem.Country AS country,
  taxitem.TaxBox AS TaxBox,
  taxitem.TaxCode AS TaxCode,
  taxitem.TransactionTypeDetermination AS TransactionTypeDetermination,
  taxitem.TaxDeclnAmountType AS TaxDeclnAmountType,
  doctype.AccountingDocumentType AS AccountingDocumentType,
  taxitem.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  taxitem.TaxBoxConfiguration AS TaxBoxConfiguration,
  taxitem.TaxGroupOperation AS TaxGroupOperation,
  taxitem.TaxGroupFreeClassification AS TaxGroupFreeClassification,
  taxitem.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  taxitem.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate
FROM I_StRpTaxItemGrouping
INNER JOIN I_AccountingDocumentType AS doctype ON /* join condition not captured in parsed metadata */
;

Learn More