I_SK_StRpCtrlStmntTaxGroup2

DDL: I_SK_STRPCTRLSTMNTTAXGROUP2 SQL: ISKSTRPCSTXGRP2 Type: view BASIC Package: GLO_FIN_IS_VAT_SK
8 Fields 3 Data Sources

SK VAT Control Statement Tax Group 2

I_SK_StRpCtrlStmntTaxGroup2 is a Basic CDS View that provides data about "SK VAT Control Statement Tax Group 2" in SAP S/4HANA. It reads from 3 data sources (vgtbs, P_TaxBoxStructureValidTo2, vgtaxgr) and exposes 8 fields with key fields Country, UnifiedTaxBoxStructureType, TaxBoxStrucValidityStartDate, TaxCode, TransactionTypeDetermination. Part of development package GLO_FIN_IS_VAT_SK.

Data Sources (3)

SourceAliasJoin Type
vgtbs TxBoxStruc inner
P_TaxBoxStructureValidTo2 TxBoxStrucValidTo inner
vgtaxgr TxGroup from

Annotations (10)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISKSTRPCSTXGRP2 view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SK VAT Control Statement Tax Group 2 view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Country vgtbs land1 Trip Ctry/Reg
KEY UnifiedTaxBoxStructureType
KEY TaxBoxStrucValidityStartDate vgtbs fdate Valid from
KEY TaxCode vgtaxgr mwskz Tax Code
KEY TransactionTypeDetermination vgtaxgr ktosl Transaction
KEY AccountingDocumentType vgtaxgr blart Rep. rec. doc. type
KEY TaxGroup vgtaxgr acr_tg Tax Group
TaxBoxStrucValidityEndDate P_TaxBoxStructureValidTo2 ValidTo 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 I_SK_StRpCtrlStmntTaxGroup2.
-- 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: ISKSTRPCSTXGRP2

CREATE VIEW I_SK_StRpCtrlStmntTaxGroup2 AS
SELECT
  TxBoxStruc.land1 AS Country,
  cast (TxBoxStruc.tbstype as figen_unified_tbox_struct_type) AS UnifiedTaxBoxStructureType,
  TxBoxStruc.fdate AS TaxBoxStrucValidityStartDate,
  TxGroup.mwskz AS TaxCode,
  TxGroup.ktosl AS TransactionTypeDetermination,
  TxGroup.blart AS AccountingDocumentType,
  TxGroup.acr_tg AS TaxGroup,
  TxBoxStrucValidTo.ValidTo AS TaxBoxStrucValidityEndDate
FROM vgtaxgr AS TxGroup
INNER JOIN vgtbs AS TxBoxStruc ON /* join condition not captured in parsed metadata */
INNER JOIN P_TaxBoxStructureValidTo2 AS TxBoxStrucValidTo ON /* join condition not captured in parsed metadata */
;

Learn More