I_ID_StRpTaxItemCube

DDL: I_ID_STRPTAXITEMCUBE SQL: IIDSRTAXITEMCUBE Type: view COMPOSITE
65 Fields 3 Data Sources

Tax Item Statutory Reporting for ID

I_ID_StRpTaxItemCube is a Composite CDS View (Cube) that provides data about "Tax Item Statutory Reporting for ID" in SAP S/4HANA. It reads from 3 data sources (I_ReceivablesPayablesItem, I_StRpJournalEntryLog, P_ID_StRpAssignment) and exposes 65 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (3)

SourceAliasJoin Type
I_ReceivablesPayablesItem I_ReceivablesPayablesItem left_outer
I_StRpJournalEntryLog I_StRpJournalEntryLog left_outer
P_ID_StRpAssignment P_ID_StRpAssignment left_outer

Parameters (8)

NameTypeDefault
P_CompanyCode fis_bukrs
P_FiscalYear gjahr
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_TaxBoxConfiguration figen_tdt_taxbox_config
P_Language sylangu

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IIDSRTAXITEMCUBE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Tax Item Statutory Reporting for ID view
Metadata.allowExtensions true view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxItem CompanyCode Receiver Company Code
KEY AccountingDocument TaxItem AccountingDocument Journal Entry
KEY FiscalYear TaxItem FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem TaxItem Tax Item
KEY TaxCode TaxItem TaxCode Tax Code
KEY TransactionTypeDetermination TaxItem TransactionTypeDetermination Transaction Key
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY TaxBoxStrucValidityStartDate TaxItem TaxBoxStrucValidityStartDate
KEY UnifiedTaxBoxStructureType TaxItem UnifiedTaxBoxStructureType
KEY TaxRateValidityStartDate TaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
TaxBoxStrucValidityEndDate TaxItem TaxBoxStrucValidityEndDate
ValidFrom TaxItem ValidFrom Vers.Valid From
ValidTo TaxItem ValidTo Vers.Valid To
PostingDate TaxItem PostingDate Posting Date for GR
DocumentDate TaxItem DocumentDate Journal Entry Date
TaxReportingDate TaxReportingDate Tax Reporting Date
ReportingDate TaxItem ReportingDate
TaxItemGroup TaxItem TaxItemGroup Tax doc. item number
FiscalPeriod TaxItem FiscalPeriod Tax period
AccountingDocumentType TaxItem AccountingDocumentType Journal Entry Type
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AssignmentReference I_ReceivablesPayablesItem AssignmentReference Assignment Reference
DocumentReferenceID DocumentReferenceID Reference
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
TaxReturnCountry TaxReturnCountry Reporting C/R
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
ExchangeRate ExchangeRate Exchange rate
TaxRate Tax Rate
GLAccount TaxItem GLAccount General Ledger
BusinessPlace TaxItem BusinessPlace Business place
TaxJurisdiction TaxItem TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
TargetTaxCode TargetTaxCode
TaxNumber1 VAT Reg. No.
TaxNumber2 Tax Number 2
TaxNumber3
BusinessPartner Issuing Authority
BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
TaxType TaxItem TaxType Tax Type
CompanyCodeCurrency TaxItem CompanyCodeCurrency Local Currency
CountryCurrency CountryCurrency Currency
DocumentCurrency DocumentCurrency Document Currency
ReportingCurrency ReportingCurrency Currency
AdditionalCurrency1 TaxItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 TaxItem AdditionalCurrency2 Local curr. 3
AmountInReportingCurrency AmountInReportingCurrency
AmountInTransactionCurrency TaxItem AmountInTransactionCurrency Pt Crcy Amt
TaxBaseAmountInTransCrcy TaxItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount TaxItem TaxAmount Tax Amt in Rptg Crcy
GrossAmountInCoCodeCurrency
AmountInAdditionalCurrency1 TaxItem AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 TaxItem AmountInAdditionalCurrency2 LC2 Amount
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxIsNotDeductible TaxIsNotDeductible Non-Deductible
TaxTypeName
TaxCodeName

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_ID_StRpTaxItemCube.
-- 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: IIDSRTAXITEMCUBE
-- Parameters: P_CompanyCode : fis_bukrs, P_FiscalYear : gjahr, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_TaxBoxConfiguration : figen_tdt_taxbox_config, P_Language : sylangu

CREATE VIEW I_ID_StRpTaxItemCube AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxDeclnAmountType,
  TaxItem.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  TaxItem.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  TaxItem.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  TaxItem.ValidFrom AS ValidFrom,
  TaxItem.ValidTo AS ValidTo,
  TaxItem.PostingDate AS PostingDate,
  TaxItem.DocumentDate AS DocumentDate,
  TaxReportingDate,
  TaxItem.ReportingDate AS ReportingDate,
  TaxItem.TaxItemGroup AS TaxItemGroup,
  TaxItem.FiscalPeriod AS FiscalPeriod,
  TaxItem.AccountingDocumentType AS AccountingDocumentType,
  AccountingDocumentHeaderText,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  IsReversal,
  IsReversed,
  I_ReceivablesPayablesItem.AssignmentReference AS AssignmentReference,
  DocumentReferenceID,
  CompanyCodeCountry,
  TaxReturnCountry,
  BusinessPartnerCountry,
  ExchangeRate,
  cast( TaxRate as btaux ) AS TaxRate,
  TaxItem.GLAccount AS GLAccount,
  TaxItem.BusinessPlace AS BusinessPlace,
  TaxItem.TaxJurisdiction AS TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxCalculationProcedure,
  TargetTaxCode,
  cast(TaxNumber1 as stcd1) AS TaxNumber1,
  cast(TaxNumber2 as stcd2) AS TaxNumber2,
  cast(TaxNumber3 as stcd3) AS TaxNumber3,
  cast(BusinessPartner as abi_bprtnr) AS BusinessPartner,
  cast(BusinessPartnerName as glo_partner) AS BusinessPartnerName,
  CustomerSupplierAddress,
  TaxItem.TaxType AS TaxType,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  TaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  TaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  AmountInReportingCurrency,
  TaxItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  TaxItem.TaxAmount AS TaxAmount,
  cast((case when TaxDeclnAmountType = 'B' then TaxItem.TaxBaseAmountInCoCodeCrcy when TaxDeclnAmountType = 'T' then TaxItem.TaxAmountInCoCodeCrcy else 0 end) as fiid_grossamt) AS GrossAmountInCoCodeCurrency,
  TaxItem.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  TaxItem.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxIsNotDeductible,
  cast ( _TaxTypeText[1:Language = $parameters.P_Language].TaxTypeName as fis_mwart ) AS TaxTypeName,
  _TaxCodeText[1:Language = $parameters.P_Language].TaxCodeName AS TaxCodeName
LEFT OUTER JOIN P_ID_StRpAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReceivablesPayablesItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;

Learn More