C_TR_StRpInputTaxItemLogCube

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 C_TR_StRpInputTaxItemLogCube.
-- 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: CTRINPTXITMLGC

CREATE VIEW C_TR_StRpInputTaxItemLogCube AS
SELECT
  Log.CompanyCode AS CompanyCode,
  Log.AccountingDocument AS AccountingDocument,
  Log.FiscalYear AS FiscalYear,
  Log._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  Log._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  Log._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  Log.TaxType AS TaxType,
  Log.DocumentDate AS DocumentDate,
  Log.PostingDate AS PostingDate,
  Log.ReportingDate AS ReportingDate,
  Log.FiscalPeriod AS FiscalPeriod,
  Log.DocumentReferenceID AS DocumentReferenceID,
  Log.ReferenceDocumentType AS ReferenceDocumentType,
  Log.Supplier AS Supplier,
  Log.BusinessPartnerCountry AS BusinessPartnerCountry,
  Log.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  Log.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  Log.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  Log.DebitCreditCode AS DebitCreditCode,
  Log.CompanyCodeCurrency AS CompanyCodeCurrency,
  Log.CountryCurrency AS CountryCurrency,
  DocAttrib.Quantity AS Quantity,
  DocAttrib.MaterialName AS MaterialName,
  Log.TaxNumber1 AS TaxNumber1,
  Log.BPSupplierName AS BPSupplierName,
  Log.BPSupplierFullName AS BPSupplierFullName,
  Log.BusinessPartnerName AS BusinessPartnerName,
  DocAttrib.SerialNumber AS SerialNumber,
  DocAttrib.SequenceNumber AS SequenceNumber
FROM P_TR_StRpInputTaxItemLog AS Log
INNER JOIN P_TR_InputVatAggrgDocAttrib ON /* join condition not captured in parsed metadata */
;