I_SK_StRpCtrlStmntCrrtnCube

DDL: I_SK_STRPCTRLSTMNTCRRTNCUBE SQL: ISKSTRPCSCC Type: view COMPOSITE
23 Fields 3 Data Sources

SK VAT Control Statement Corrections

I_SK_StRpCtrlStmntCrrtnCube is a Composite CDS View (Cube) that provides data about "SK VAT Control Statement Corrections" in SAP S/4HANA. It reads from 3 data sources (P_SK_StRpCtrlStmntTxItm, I_SK_StRpCtrlStmntTaxItem, P_T007B_GLO) and exposes 23 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument.

Data Sources (3)

SourceAliasJoin Type
P_SK_StRpCtrlStmntTxItm LogItem from
I_SK_StRpCtrlStmntTaxItem PrevLogItem left_outer
P_T007B_GLO T007B left_outer

Parameters (1)

NameTypeDefault
P_StatryRptRunID srf_report_run_id

Annotations (13)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ISKSTRPCSCC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SK VAT Control Statement Corrections view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_SK_StRpCtrlStmntTxItm StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_SK_StRpCtrlStmntTxItm StatryRptCategory Report ID
KEY StatryRptRunID P_SK_StRpCtrlStmntTxItm StatryRptRunID Report Run ID
KEY CompanyCode P_SK_StRpCtrlStmntTxItm CompanyCode Receiver Company Code
KEY AccountingDocument P_SK_StRpCtrlStmntTxItm AccountingDocument Journal Entry
KEY FiscalYear P_SK_StRpCtrlStmntTxItm FiscalYear G/L Fiscal Year
KEY TaxItem P_SK_StRpCtrlStmntTxItm TaxItem Tax Item
KEY BillingDocumentItem P_SK_StRpCtrlStmntTxItm BillingDocumentItem Item
TaxGroupendasfot_atr_tax_groupasTaxGroup
VATRegistrationendasVATRegistration
InvoiceNumberendasInvoiceNumber
TaxReportingDateendasTaxReportingDate
TaxRateendasTaxRate
ReportingCurrencyendasReportingCurrency
BaseUnitendasBaseUnit
AccountingDocumentType P_SK_StRpCtrlStmntTxItm AccountingDocumentType Journal Entry Type
TaxCode P_SK_StRpCtrlStmntTxItm TaxCode Tax Code
TransactionTypeDetermination P_SK_StRpCtrlStmntTxItm TransactionTypeDetermination Transaction Key
TaxType P_SK_StRpCtrlStmntTxItm TaxType Tax Type
TransactionTaxType P_T007B_GLO stgrp Tax Type
DownPaymentStatusendasDownPaymentStatus
IsReversed P_SK_StRpCtrlStmntTxItm IsReversed Reversed?
IsReversal P_SK_StRpCtrlStmntTxItm 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_StRpCtrlStmntCrrtnCube.
-- 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: ISKSTRPCSCC
-- Parameters: P_StatryRptRunID : srf_report_run_id

CREATE VIEW I_SK_StRpCtrlStmntCrrtnCube AS
SELECT
  LogItem.StatryRptgEntity AS StatryRptgEntity,
  LogItem.StatryRptCategory AS StatryRptCategory,
  LogItem.StatryRptRunID AS StatryRptRunID,
  LogItem.CompanyCode AS CompanyCode,
  LogItem.AccountingDocument AS AccountingDocument,
  LogItem.FiscalYear AS FiscalYear,
  LogItem.TaxItem AS TaxItem,
  LogItem.BillingDocumentItem AS BillingDocumentItem,
  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.ReportingCurrency else LogItem.ReportingCurrency end as ReportingCurrency AS ReportingCurrencyendasReportingCurrency,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.BaseUnit else LogItem.BaseUnit end as BaseUnit AS BaseUnitendasBaseUnit,
  LogItem.AccountingDocumentType AS AccountingDocumentType,
  LogItem.TaxCode AS TaxCode,
  LogItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  LogItem.TaxType AS TaxType,
  T007B.stgrp AS TransactionTaxType,
  case when LogItem.IsReversed = 'X' and PrevLogItem.IsReversed = '' then PrevLogItem.DownPaymentStatus else LogItem.DownPaymentStatus end as DownPaymentStatus AS DownPaymentStatusendasDownPaymentStatus,
  LogItem.IsReversed AS IsReversed,
  LogItem.IsReversal AS IsReversal
FROM P_SK_StRpCtrlStmntTxItm AS LogItem
LEFT OUTER JOIN I_SK_StRpCtrlStmntTaxItem AS PrevLogItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_T007B_GLO AS T007B ON /* join condition not captured in parsed metadata */
;

Learn More