C_VE_StRpSlsAndWhldgTxItmC

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_VE_StRpSlsAndWhldgTxItmC.
-- 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: CVESLSTAXITEMC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_VE_StRpSlsAndWhldgTxItmC AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TransactionTypeDetermination,
  TaxCode,
  TaxItem,
  AccountingDocumentItem,
  AccountingDocumentType,
  TaxRate,
  cast(cast(TaxRate as abap.curr(11,2)) as char16) AS IPITaxRate,
  DocumentDate,
  PostingDate,
  ReportingDate,
  case _Customer.IsOneTimeAccount when '' then case when _Customer.TaxNumber1 is null then _Customer.TaxNumber2 else _Customer.TaxNumber1 end else case when _OneTimeAccountBP.TaxID1 is null then _OneTimeAccountBP.TaxID2 else _OneTimeAccountBP.TaxID1 end end as TaxNumber1 AS TaxID1endendasTaxNumber1,
  TaxBaseAmountInCoCodeCrcy * -1 AS TaxBaseAmountInCoCodeCrcy,
  -TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  WhldgTaxAmtInCoCodeCrcy,
  -TotalAmountInDisplayCrcy AS TotalAmountInDisplayCrcy,
  CompanyCodeCurrency,
  DocumentCurrency,
  Supplier,
  Customer,
  _Customer.Country AS BusinessPartnerCountry,
  Country,
  OriginalReferenceDocument,
  DocumentReferenceID,
  DocumentType,
  TransactionTypeCategory,
  ReferenceDocumentType,
  TargetSalesDocumentType,
  PrecedingDocumentCategory,
  DefaultDebitCreditCode,
  DebitCreditCode,
  ReferenceDocumentNumber,
  PrecedingDocument,
  AmendmentTaxInvoiceNumber,
  NFOverviewInvoiceNumber,
  CancelledBillingDocument,
  NFInvoiceNumber,
  AccountingDocumentHeaderText,
  UtilsInvcgDocReversalRsn,
  ReverseDocument,
  ReversedDocument,
  ReferenceAcctgDocumentType,
  InvoiceReference,
  ReversalReason,
  CADocumentType,
  ReverseDocumentFiscalYear,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument
FROM I_VE_StRpBPAndWhldgTaxItem
;