C_HU_StRpTaxItemBoxCube

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_HU_StRpTaxItemBoxCube.
-- 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: CHUSTRPTXTBITM

CREATE VIEW C_HU_StRpTaxItemBoxCube AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  cast(TaxBox as idhu_tax_amount_tb) AS TaxAmountTaxBox,
  TaxReportingDate,
  TaxReportingDate AS ReportingPeriodStartDate,
  TaxReportingDate AS ReportingPeriodEndDate,
  cast( ReportingCurrency as glo_reporting_currency) AS ReportingCurrency,
  TaxAmountInRptgCrcy,
  TaxAmountInRptgCrcy AS US_Level1TaxAmountInRptgCrcy,
  cast('' as stcd1) AS CustomerTaxID1,
  TaxAmountInRptgCrcy AS US_Level2TaxAmountInRptgCrcy,
  cast('' as stcd1) AS CustomerTaxID2,
  TaxAmountInRptgCrcy AS US_Level3TaxAmountInRptgCrcy,
  cast('' as stcd3) AS CustomerTaxID3,
  TaxAmountInRptgCrcy AS US_Level4TaxAmountInRptgCrcy,
  cast('' as stcd4) AS CustomerTaxID4,
  TaxAmountInRptgCrcy AS CalculatedTaxAmountInRptgCrcy,
  TaxBaseAmountInRptgCrcy,
  cast('' as idhu_tax_base_amount_tb) AS TaxBaseAmountTaxBox,
  cast( ReportingCurrency as glo_reporting_currency) AS CompanyCodeCurrency,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  cast( ReportingCurrency as glo_reporting_currency) AS AFDFLocalCurrency,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2,
  DocumentReferenceID,
  _Text.StatryRptgEntity AS StatryRptgEntityName,
  TaxAmountInRptgCrcy AS TaxInvoiceItemNetAmount,
  TaxAmountInRptgCrcy AS TotalGrossAmountInRptgCrcy,
  cast(TaxNumber1 as bptaxnum) AS ReportingVATRegistration,
  cast(TaxNumber1 as bptaxnum) AS NaturalPersonVATRegistration,
  cast(TaxNumber1 as bptaxnum) AS CompanyVATRegistration,
  cast('' as ftvv_partner_address) AS FormattedPostalAddressText,
  TaxBoxName,
  cast('' as fac_awkey) AS OriginalReferenceDocument,
  cast( _AccountingDocument.AccountingDocumentType as fihuvat_invtyp ) AS IsltnCertItmUntaggingType,
  IsReversal,
  IsReversed,
  ReverseDocument,
  cast( ReverseDocumentFiscalYear as fis_stjah_no_conv preserving type ) AS ReverseDocumentFiscalYear,
  IsReversed AS BR_NFIsCanceled,
  TaxNumber1 AS VATRegistration,
  BusinessPartner,
  BusinessPartnerName,
  cast( AccountingDocument as idhu_issued_invoice_id) AS InvoiceNumber,
  cast( AccountingDocument as idhu_issued_invoice_id) AS RU_IncomingInvoiceNumber,
  cast('' as idhu_invoice_nr_tb) AS InvoiceNumberTaxBox,
  cast(DocumentDate as idhu_issued_invoice_date) AS InvoiceIssueDate,
  cast('' as idhu_issued_inv_date_tb) AS InvoiceIssueDateTaxBox,
  cast( _AccountingDocument.AccountingDocumentType as fihuvat_invtyp) AS HU_InvoiceCorrectionType,
  cast('' as idhu_inv_corr_type_tb) AS InvoiceCorrectionTypeTaxBox,
  cast(AccountingDocument as idhu_root_invoice_id) AS OriginalInvoiceNumber,
  cast('' as idhu_root_invoice_tb) AS OriginalInvoiceNumberTaxBox,
  cast(DocumentDate as idhu_fulf_dat) AS InvoiceFulfillmentDate,
  cast('' as idhu_fulf_dat_tb) AS FulfillmentDateTaxBox,
  DocumentDate,
  PostingDate,
  cast('' as idhu_form_key) AS HU_VATReturnPage,
  TaxCountry,
  TaxCode,
  _TaxCodeText.TaxCodeName AS TaxCodeName,
  TaxCalculationProcedure,
  TaxType,
  cast(TaxRate as fiaapt_tax_rate) AS TaxRate,
  TransactionTypeDetermination,
  AccountingDocumentType,
  _ReceivablesPayablesItem.SpecialGLCode AS SpecialGLCode,
  cast('S' as glo_amount_type) AS TaxDeclnAmountType,
  TaxIsNotDeductible,
  cast('' as txz01) AS MaterialDescription,
  cast('' as custom_tariffdsc) AS MaterialDesc,
  cast('' as /sapsll/comco) AS CommodityCode,
  cast('KG' as gewei) AS WeightUnit,
  cast(0 as netweight) AS NetWeight
FROM I_StRpTaxItemLog
LEFT OUTER JOIN I_StRpEntityText AS _Text ON StatryRptgEntity = _Text.StatryRptgEntity  -- association [0..*]
;