I_SK_CAStRpCtrlStmntCrrtnCube

DDL: I_SK_CASTRPCTRLSTMNTCRRTNCUBE Type: view_entity COMPOSITE Package: FKK_ID_SK_REP
24 Fields 1 Data Sources

SK VAT CS Analytical AddRun - Cube

I_SK_CAStRpCtrlStmntCrrtnCube is a Composite CDS View (Cube) that provides data about "SK VAT CS Analytical AddRun - Cube" in SAP S/4HANA. It reads from 1 data source (P_SK_CAStRpCtrlStmntTaxItemLog) and exposes 24 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, CADocument. Part of development package FKK_ID_SK_REP.

Data Sources (1)

SourceAliasJoin Type
P_SK_CAStRpCtrlStmntTaxItemLog LogItem from

Parameters (1)

NameTypeDefault
P_StatryRptRunID srf_report_run_id

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName ISKCAStRpCtrlStmntCrrtnCube view
EndUserText.label SK VAT CS Analytical AddRun - Cube view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_SK_CAStRpCtrlStmntTaxItemLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_SK_CAStRpCtrlStmntTaxItemLog StatryRptCategory Report ID
KEY StatryRptRunID P_SK_CAStRpCtrlStmntTaxItemLog StatryRptRunID Report Run ID
KEY CompanyCode P_SK_CAStRpCtrlStmntTaxItemLog CompanyCode Receiver Company Code
KEY CADocument P_SK_CAStRpCtrlStmntTaxItemLog CADocumentNumber Document Number
KEY CAGLItemNumber P_SK_CAStRpCtrlStmntTaxItemLog CAGLItemNumber Item
KEY CABPItemNumber P_SK_CAStRpCtrlStmntTaxItemLog CABPItemNumber Item
KEY BillingDocumentItem P_SK_CAStRpCtrlStmntTaxItemLog BillingDocumentItem Item
KEY OriginType P_SK_CAStRpCtrlStmntTaxItemLog OriginType
KEY CAClearedDocument P_SK_CAStRpCtrlStmntTaxItemLog CAClearedDocument
TaxGroupendasfot_atr_tax_groupasTaxGroup
VATRegistrationendasVATRegistration
InvoiceNumberendasInvoiceNumber
TaxReportingDateendasTaxReportingDate
TaxRateendasTaxRate
TaxAmountendasTaxAmountInCoCodeCrcy
CurrencyendasCompanyCodeCurrency
CAControlCodeendasConsumptionTaxCtrlCode
BaseUnitendasBaseUnit
TaxCode P_SK_CAStRpCtrlStmntTaxItemLog TaxCode Tax Code
TransactionTypeDetermination P_SK_CAStRpCtrlStmntTaxItemLog TransactionTypeDetermination Transaction Key
TransactionTaxType T007B stgrp Tax Type
IsReversed P_SK_CAStRpCtrlStmntTaxItemLog IsReversed Reversed?
IsReversal P_SK_CAStRpCtrlStmntTaxItemLog IsReversal Reversal doc.

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_CAStRpCtrlStmntCrrtnCube.
-- 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_StatryRptRunID : srf_report_run_id

CREATE VIEW I_SK_CAStRpCtrlStmntCrrtnCube AS
SELECT
  LogItem.StatryRptgEntity AS StatryRptgEntity,
  LogItem.StatryRptCategory AS StatryRptCategory,
  LogItem.StatryRptRunID AS StatryRptRunID,
  LogItem.CompanyCode AS CompanyCode,
  LogItem.CADocumentNumber AS CADocument,
  LogItem.CAGLItemNumber AS CAGLItemNumber,
  LogItem.CABPItemNumber AS CABPItemNumber,
  LogItem.BillingDocumentItem AS BillingDocumentItem,
  LogItem.OriginType AS OriginType,
  LogItem.CAClearedDocument AS CAClearedDocument,
  cast(case when LogItem.IsReversal = 'X' then '' when PrevLogItem.IsReversal = 'X' then '' when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.TaxGroup else LogItem.TaxGroup end as fot_atr_tax_group) as TaxGroup AS TaxGroupendasfot_atr_tax_groupasTaxGroup,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.VATRegistration else LogItem.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.InvoiceNumber else LogItem.InvoiceNumber end as InvoiceNumber AS InvoiceNumberendasInvoiceNumber,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.TaxReportingDate else LogItem.TaxReportingDate end as TaxReportingDate AS TaxReportingDateendasTaxReportingDate,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.TaxRate else LogItem.TaxRate end as TaxRate AS TaxRateendasTaxRate,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.TaxAmount else LogItem.TaxAmount end as TaxAmountInCoCodeCrcy AS TaxAmountendasTaxAmountInCoCodeCrcy,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.Currency else LogItem.Currency end as CompanyCodeCurrency AS CurrencyendasCompanyCodeCurrency,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.CAControlCode else LogItem.CAControlCode end as ConsumptionTaxCtrlCode AS CAControlCodeendasConsumptionTaxCtrlCode,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.BaseUnit else LogItem.BaseUnit end as BaseUnit AS BaseUnitendasBaseUnit,
  LogItem.TaxCode AS TaxCode,
  LogItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  T007B.stgrp AS TransactionTaxType,
  LogItem.IsReversed AS IsReversed,
  LogItem.IsReversal AS IsReversal
FROM P_SK_CAStRpCtrlStmntTaxItemLog AS LogItem
;

Learn More