I_SK_CAStRpCtrlStmntCube

DDL: I_SK_CASTRPCTRLSTMNTCUBE Type: view_entity COMPOSITE Package: FKK_ID_SK_REP
30 Fields 1 Data Sources

SK VAT CS Analytical - Cube

I_SK_CAStRpCtrlStmntCube is a Composite CDS View (Cube) that provides data about "SK VAT CS Analytical - Cube" in SAP S/4HANA. It reads from 1 data source (P_SK_CAStRpCtrlStmntTaxItemLog) and exposes 30 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

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName ISKCAStRpCtrlStmntCube view
EndUserText.label SK VAT CS Analytical - 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 (30)

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 TaxGroup P_SK_CAStRpCtrlStmntTaxItemLog TaxGroup Tax Group
KEY OriginType P_SK_CAStRpCtrlStmntTaxItemLog OriginType
KEY CAClearedDocument P_SK_CAStRpCtrlStmntTaxItemLog CAClearedDocument
VATRegistration P_SK_CAStRpCtrlStmntTaxItemLog VATRegistration VAT Registration No.
InvoiceNumber P_SK_CAStRpCtrlStmntTaxItemLog InvoiceNumber Invoice Number
OriginalInvoiceNumber P_SK_CAStRpCtrlStmntTaxItemLog OriginalInvoiceNumber
TaxReportingDate P_SK_CAStRpCtrlStmntTaxItemLog TaxReportingDate Tax Reporting Date
TaxFulfillmentDate P_SK_CAStRpCtrlStmntTaxItemLog TaxFulfillmentDate Tax Settlement Date
TaxRate P_SK_CAStRpCtrlStmntTaxItemLog TaxRate Tax Rate
TaxBaseAmountInCoCodeCrcy P_SK_CAStRpCtrlStmntTaxItemLog TaxBaseAmount TaxBaseAmtInRptgCrcy
TaxAmountInCoCodeCrcy P_SK_CAStRpCtrlStmntTaxItemLog TaxAmount Tax Amt in Rptg Crcy
DeductTaxAmountInCCCrcy P_SK_CAStRpCtrlStmntTaxItemLog DeductibleInputTaxAmount
CompanyCodeCurrency P_SK_CAStRpCtrlStmntTaxItemLog Currency Valuation Crcy
ConsumptionTaxCtrlCode P_SK_CAStRpCtrlStmntTaxItemLog CAControlCode Control Code
BillingQuantityInBaseUnit P_SK_CAStRpCtrlStmntTaxItemLog BillingQuantity Invoiced Qty
BaseUnit P_SK_CAStRpCtrlStmntTaxItemLog BaseUnit Unit of Measure
SK_CtrlStmntUnitOfMeasure P_SK_CAStRpCtrlStmntTaxItemLog SK_CtrlStmntUnitOfMeasure
TaxCode P_SK_CAStRpCtrlStmntTaxItemLog TaxCode Tax Code
TransactionTypeDetermination P_SK_CAStRpCtrlStmntTaxItemLog TransactionTypeDetermination Transaction Key
TransactionTaxType T007B stgrp Tax Type
IsReversal P_SK_CAStRpCtrlStmntTaxItemLog IsReversal Reversal doc.
IsReversed P_SK_CAStRpCtrlStmntTaxItemLog IsReversed Reversed?

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_CAStRpCtrlStmntCube.
-- 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.

CREATE VIEW I_SK_CAStRpCtrlStmntCube 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.TaxGroup AS TaxGroup,
  LogItem.OriginType AS OriginType,
  LogItem.CAClearedDocument AS CAClearedDocument,
  LogItem.VATRegistration AS VATRegistration,
  LogItem.InvoiceNumber AS InvoiceNumber,
  LogItem.OriginalInvoiceNumber AS OriginalInvoiceNumber,
  LogItem.TaxReportingDate AS TaxReportingDate,
  LogItem.TaxFulfillmentDate AS TaxFulfillmentDate,
  LogItem.TaxRate AS TaxRate,
  LogItem.TaxBaseAmount AS TaxBaseAmountInCoCodeCrcy,
  LogItem.TaxAmount AS TaxAmountInCoCodeCrcy,
  LogItem.DeductibleInputTaxAmount AS DeductTaxAmountInCCCrcy,
  LogItem.Currency AS CompanyCodeCurrency,
  LogItem.CAControlCode AS ConsumptionTaxCtrlCode,
  LogItem.BillingQuantity AS BillingQuantityInBaseUnit,
  LogItem.BaseUnit AS BaseUnit,
  LogItem.SK_CtrlStmntUnitOfMeasure AS SK_CtrlStmntUnitOfMeasure,
  LogItem.TaxCode AS TaxCode,
  LogItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  T007B.stgrp AS TransactionTaxType,
  LogItem.IsReversal AS IsReversal,
  LogItem.IsReversed AS IsReversed
FROM P_SK_CAStRpCtrlStmntTaxItemLog AS LogItem
;

Learn More