C_HU_EVATTaxItemCube

DDL: C_HU_EVATTAXITEMCUBE Type: view_entity CONSUMPTION
37 Fields 4 Data Sources

HU eVAT Tax Item Analytical Cube

C_HU_EVATTaxItemCube is a Consumption CDS View (Cube) that provides data about "HU eVAT Tax Item Analytical Cube" in SAP S/4HANA. It reads from 4 data sources (P_HU_EVAT_DownPayments, I_StRpJournalEntryHeaderLog, P_HU_EVAT_Mapping, I_StRpTaxItem) and exposes 37 fields with key fields CompanyCode, FiscalYear, AccountingDocument, StatryRptgEntity, StatryRptCategory.

Data Sources (4)

SourceAliasJoin Type
P_HU_EVAT_DownPayments GLIndicator inner
I_StRpJournalEntryHeaderLog Log from
P_HU_EVAT_Mapping Mapping inner
I_StRpTaxItem TaxItem inner

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label HU eVAT Tax Item Analytical Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItem CompanyCode Receiver Company Code
KEY FiscalYear I_StRpTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_StRpTaxItem AccountingDocument Journal Entry
KEY StatryRptgEntity I_StRpJournalEntryHeaderLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryHeaderLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryHeaderLog StatryRptRunID Report Run ID
TaxReportingDate I_StRpTaxItem TaxReportingDate Tax Reporting Date
ReportingPeriodStartDate I_StRpTaxItem TaxReportingDate Reporting Period Start
ReportingPeriodEndDate I_StRpTaxItem TaxReportingDate Reporting Period End
ReportingCurrency
TaxAmountInRptgCrcy I_StRpTaxItem TaxAmountInRptgCrcy Tax Box Amount in Rptg Crcy
CalculatedTaxAmountInRptgCrcy Tax Amount in Rptg Crcy
TaxBaseAmountInRptgCrcy I_StRpTaxItem TaxBaseAmountInRptgCrcy Base Amount
DocumentReferenceID I_StRpTaxItem DocumentReferenceID Reference
GLAccount I_StRpTaxItem GLAccount General Ledger
TaxInvoiceItemNetAmount
TotalGrossAmountInRptgCrcy I_StRpTaxItem TaxAmountInRptgCrcy Tax Rept. Crcy
ReportingVATRegistration Reporting Entity Tax Number
NaturalPersonVATRegistration BP Group Tax Number
CompanyVATRegistration BP VAT ID
GroupMemberVATRegistration BP Group Member VAT ID
BusinessPartner I_StRpTaxItem BusinessPartner Issuing Authority
BusinessPartnerName I_StRpTaxItem BusinessPartnerName BP Name
BusinessPartnerCountry I_StRpTaxItem BusinessPartnerCountry BP Ctry/Reg.
CityNameendasBusinessPartnerCityName
PostalCodeendasBusinessPartnerPostalCode
DocumentDate I_StRpTaxItem DocumentDate Document Date
PostingDate I_StRpTaxItem PostingDate Posting Date
DocumentReferenceIDendasInvoiceNumber
DocumentDateendasInvoiceDate
TransactionTypeDetermination I_StRpTaxItem TransactionTypeDetermination Transaction Key
TaxCountry I_StRpTaxItem TaxCountry Tax Ctry/Reg.
TaxCode I_StRpTaxItem TaxCode Tax Code
TaxCalculationProcedure I_StRpTaxItem TaxCalculationProcedure Tax Procedure
TaxType I_StRpTaxItem TaxType Tax Type
HU_StandardTaxCode P_HU_EVAT_Mapping stdtaxcode
IsNaturalPerson

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_EVATTaxItemCube.
-- 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 C_HU_EVATTaxItemCube AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.AccountingDocument AS AccountingDocument,
  Log.StatryRptgEntity AS StatryRptgEntity,
  Log.StatryRptCategory AS StatryRptCategory,
  Log.StatryRptRunID AS StatryRptRunID,
  TaxItem.TaxReportingDate AS TaxReportingDate,
  TaxItem.TaxReportingDate AS ReportingPeriodStartDate,
  TaxItem.TaxReportingDate AS ReportingPeriodEndDate,
  cast( TaxItem.ReportingCurrency as glo_reporting_currency) AS ReportingCurrency,
  TaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  abs(TaxItem.TaxAmountInRptgCrcy) AS CalculatedTaxAmountInRptgCrcy,
  TaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  TaxItem.DocumentReferenceID AS DocumentReferenceID,
  TaxItem.GLAccount AS GLAccount,
  abs(TaxItem.TaxBaseAmountInRptgCrcy) AS TaxInvoiceItemNetAmount,
  TaxItem.TaxAmountInRptgCrcy AS TotalGrossAmountInRptgCrcy,
  cast(TaxItem.TaxNumber1 as bptaxnum) AS ReportingVATRegistration,
  cast(TaxItem.TaxNumber1 as bptaxnum) AS NaturalPersonVATRegistration,
  cast(TaxItem.TaxNumber1 as bptaxnum) AS CompanyVATRegistration,
  cast(substring(TaxItem.TaxNumber3, 1, 8 ) as bptaxnum ) AS GroupMemberVATRegistration,
  TaxItem.BusinessPartner AS BusinessPartner,
  TaxItem.BusinessPartnerName AS BusinessPartnerName,
  TaxItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  case when TaxItem._CustomerSupplierLineItem._Customer.Customer <> '' then coalesce( TaxItem._CustomerSupplierLineItem._OneTimeAccountBP.CityName, TaxItem._CustomerSupplierLineItem._Customer._AddressRepresentation.CityName ) when TaxItem._CustomerSupplierLineItem._Supplier.Supplier <> '' then coalesce( TaxItem._CustomerSupplierLineItem._OneTimeAccountBP.CityName, TaxItem._CustomerSupplierLineItem._Supplier._AddressRepresentation.CityName ) end as BusinessPartnerCityName AS CityNameendasBusinessPartnerCityName,
  case when TaxItem._CustomerSupplierLineItem._Customer.Customer <> '' then coalesce( TaxItem._CustomerSupplierLineItem._OneTimeAccountBP.PostalCode, TaxItem._CustomerSupplierLineItem._Customer._AddressRepresentation.PostalCode ) when TaxItem._CustomerSupplierLineItem._Supplier.Supplier <> '' then coalesce( TaxItem._CustomerSupplierLineItem._OneTimeAccountBP.PostalCode, TaxItem._CustomerSupplierLineItem._Supplier._AddressRepresentation.PostalCode ) end as BusinessPartnerPostalCode AS PostalCodeendasBusinessPartnerPostalCode,
  TaxItem.DocumentDate AS DocumentDate,
  TaxItem.PostingDate AS PostingDate,
  case when TaxItem._JournalEntry.JrnlEntryCntrySpecificRef4 is not initial then TaxItem._JournalEntry.JrnlEntryCntrySpecificRef4 else TaxItem._JournalEntry.DocumentReferenceID end as InvoiceNumber AS DocumentReferenceIDendasInvoiceNumber,
  case when TaxItem._JournalEntry.JrnlEntryCntrySpecificDate4 is not initial then TaxItem._JournalEntry.JrnlEntryCntrySpecificDate4 else TaxItem._JournalEntry.DocumentDate end as InvoiceDate AS DocumentDateendasInvoiceDate,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.TaxCountry AS TaxCountry,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxItem.TaxType AS TaxType,
  Mapping.stdtaxcode AS HU_StandardTaxCode,
  TaxItem._CustomerSupplierLineItem._Supplier.IsNaturalPerson AS IsNaturalPerson
FROM I_StRpJournalEntryHeaderLog AS Log
INNER JOIN I_StRpTaxItem AS TaxItem ON /* join condition not captured in parsed metadata */
INNER JOIN P_HU_EVAT_DownPayments AS GLIndicator ON /* join condition not captured in parsed metadata */
INNER JOIN P_HU_EVAT_Mapping AS Mapping ON /* join condition not captured in parsed metadata */
;

Learn More