C_NL_StRpAcceptedTaxItemCube

DDL: C_NL_STRPACCEPTEDTAXITEMCUBE SQL: CNLSRACCTAXITMC Type: view CONSUMPTION
40 Fields 2 Data Sources

[Obsolete] NL VAT - Reported Tax Items

C_NL_StRpAcceptedTaxItemCube is a Consumption CDS View (Cube) that provides data about "[Obsolete] NL VAT - Reported Tax Items" in SAP S/4HANA. It reads from 2 data sources (I_StRpJournalEntryLog, I_StRpTaxItemBoxCube) and exposes 40 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, AccountingDocument, CompanyCode.

Data Sources (2)

SourceAliasJoin Type
I_StRpJournalEntryLog I_StRpJournalEntryLog inner
I_StRpTaxItemBoxCube I_StRpTaxItemBoxCube inner

Annotations (12)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
AbapCatalog.sqlViewName CNLSRACCTAXITMC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label [Obsolete] NL VAT - Reported Tax Items view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_StRpRepRun StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpRepRun StatryRptCategory Report ID
KEY StatryRptRunID I_StRpRepRun StatryRptRunID Report Run ID
KEY AccountingDocument I_StRpJournalEntryLog AccountingDocument Journal Entry
KEY CompanyCode I_StRpJournalEntryLog CompanyCode Receiver Company Code
KEY FiscalYear I_StRpJournalEntryLog FiscalYear G/L Fiscal Year
KEY TaxCode TaxCode Tax Code
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY TaxBox TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY TaxItemGroupingVersion TaxItemGroupingVersion Tax Grping Ver.
TaxItem I_StRpTaxItemBoxCube TaxItem Tax Item
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
TaxReportingDate TaxReportingDate Tax Reporting Date
ReportingDate ReportingDate
FiscalPeriod FiscalPeriod Tax period
AccountingDocumentType AccountingDocumentType Journal Entry Type
DocumentReferenceID DocumentReferenceID Reference
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry Reporting C/R
ExchangeRate ExchangeRate Exchange rate
TaxRate TaxRate Tax Rate
GLAccount GLAccount General Ledger
BusinessPlace BusinessPlace Business place
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
TaxType TaxType Tax Type
TargetTaxCode TargetTaxCode
ReportingCurrency ReportingCurrency Currency
DocumentCurrency DocumentCurrency Document Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3

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_NL_StRpAcceptedTaxItemCube.
-- 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: CNLSRACCTAXITMC

CREATE VIEW C_NL_StRpAcceptedTaxItemCube AS
SELECT
  I_StRpRepRun.StatryRptgEntity AS StatryRptgEntity,
  I_StRpRepRun.StatryRptCategory AS StatryRptCategory,
  I_StRpRepRun.StatryRptRunID AS StatryRptRunID,
  I_StRpJournalEntryLog.AccountingDocument AS AccountingDocument,
  I_StRpJournalEntryLog.CompanyCode AS CompanyCode,
  I_StRpJournalEntryLog.FiscalYear AS FiscalYear,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  ReportingDate,
  FiscalPeriod,
  AccountingDocumentType,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  ExchangeRate,
  TaxRate,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxType,
  TargetTaxCode,
  ReportingCurrency,
  DocumentCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2
INNER JOIN I_StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
INNER JOIN I_StRpTaxItemBoxCube ON /* join condition not captured in parsed metadata */
;

Learn More