I_SK_StRpCtrlStmntCube

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_StRpCtrlStmntCube.
-- 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: ISKSTRPCSC

CREATE VIEW I_SK_StRpCtrlStmntCube 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.IsReversed = 'X' then '' when LogItem.IsReversal = 'X' then '' else LogItem.TaxGroup end as fot_atr_tax_group) as TaxGroup AS TaxGroupendasfot_atr_tax_groupasTaxGroup,
  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.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  LogItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  LogItem.DeductibleInputTaxAmount AS DeductibleInputTaxAmount,
  LogItem.ReportingCurrency AS ReportingCurrency,
  LogItem.ConsumptionTaxCtrlCode AS ConsumptionTaxCtrlCode,
  LogItem.BillingQuantityInBaseUnit AS BillingQuantityInBaseUnit,
  LogItem.BaseUnit AS BaseUnit,
  LogItem.SK_CtrlStmntUnitOfMeasure AS SK_CtrlStmntUnitOfMeasure,
  LogItem.SK_CtrlStmntDocIsBadDebtRelief AS SK_CtrlStmntDocIsBadDebtRelief,
  LogItem.AccountingDocumentType AS AccountingDocumentType,
  LogItem.TaxCode AS TaxCode,
  LogItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  T007B.stgrp AS TransactionTaxType,
  cast('' as fisk_corr_code) AS SK_CtrlStmntCorrectionCode,
  LogItem.DownPaymentStatus AS DownPaymentStatus,
  LogItem.IsReversal AS IsReversal,
  LogItem.IsReversed AS IsReversed
FROM P_SK_StRpCtrlStmntTxItm AS LogItem
LEFT OUTER JOIN P_T007B_GLO AS T007B ON /* join condition not captured in parsed metadata */
;