Deprecated
This CDS view is deprecated in S/4HANA. Use I_StRpTaxReturnCube instead. View all deprecated CDS views →

I_StRpAdvncRetForSlsAndPurTxC

DDL: I_STRPADVNCRETFORSLSANDPURTXC SQL: ISRADVRTSLSPRTXC Type: view COMPOSITE
97 Fields 4 Data Sources

Cube View which returns Sales and Purchases tax items

I_StRpAdvncRetForSlsAndPurTxC is a Composite CDS View (Cube) that provides data about "Cube View which returns Sales and Purchases tax items" in SAP S/4HANA. It reads from 4 data sources (I_BillingDocument, P_CompanyTaxDetails, P_ConditionsItem, P_CountCountry) and exposes 97 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (4)

SourceAliasJoin Type
I_BillingDocument I_BillingDocument left_outer
P_CompanyTaxDetails P_CompanyTaxDetails left_outer
P_ConditionsItem P_ConditionsItem left_outer
P_CountCountry P_CountCountry left_outer

Parameters (2)

NameTypeDefault
P_IsParameter char1
P_ConditionIsMandatory char1

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ISRADVRTSLSPRTXC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cube View which returns Sales and Purchases tax items view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_StRpTaxReturnCube view
AccessControl.blocking #BLOCKED_DATA_INCLUDED view

Fields (97)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_StRpAdvncRetForSlsAndPurTx CompanyCode Receiver Company Code
KEY AccountingDocument P_StRpAdvncRetForSlsAndPurTx AccountingDocument Journal Entry
KEY FiscalYear P_StRpAdvncRetForSlsAndPurTx FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem Tax Item
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.
KEY ValidFrom ValidFrom Vers.Valid From
KEY TaxBoxStructureType TaxBoxStructureType
DebitCreditCode DebitCreditCode Single-Character Flag
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
TaxRate TaxRate Tax Rate
dec112aschar16endasIPITaxRate Tax Rate
AdditionalTax1Rate TaxRate Tax Rate
ConditionAmount P_ConditionsItem ConditionAmount Condition Value
PayerPartyendasCustomer
GLAccount GLAccount General Ledger
TaxItemGroup TaxItemGroup Tax doc. item number
BusinessPlace BusinessPlace Business place
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
AccountingDocumentType AccountingDocumentType Journal Entry Type
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
ConditionRecord P_StRpAdvncRetForSlsAndPurTx ConditionRecord Cond.Record No.
RoundingDecimalPlaces RoundingDecimalPlaces
DocumentReferenceID P_StRpAdvncRetForSlsAndPurTx DocumentReferenceID Reference
Ledger Ledger Ledger
LedgerGroup LedgerGroup Ledger Group
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
TaxReportingDate TaxReportingDate Tax Reporting Date
ReportingDate P_StRpAdvncRetForSlsAndPurTx ReportingDate
FiscalPeriod P_StRpAdvncRetForSlsAndPurTx FiscalPeriod Tax period
ExchangeRate ExchangeRate Exchange rate
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry Reporting C/R
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CountryCurrency CountryCurrency Currency
DocumentCurrency DocumentCurrency Document Currency
ReportingCurrency ReportingCurrency Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount P_StRpAdvncRetForSlsAndPurTx TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
DifferenceTaxAmtInCoCodeCrcy
DiffTaxBaseAmountInCoCodeCrcy
TaxType TaxType Tax Type
TargetTaxCode TargetTaxCode
TaxNumber2 TaxNumber2 Tax Number 2
ActiveTaxType ActiveTaxType
TaxNumber3 TaxNumber3
CalculatedTxAmtInCoCodeCrcy CalculatedTxAmtInCoCodeCrcy
CalculatedTaxAmountInTransCrcy CalculatedTaxAmountInTransCrcy
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
TaxIsNotDeductible TaxIsNotDeductible Non-Deductible
TaxBoxStructure TaxBoxStructure
TaxBoxStructureName TaxBoxStructureName
TaxBoxName TaxBoxName
TaxBoxCondition TaxBoxCondition
TaxGroup TaxGroup Tax Group
SupplierAccountGroup SupplierAccountGroup Account group
TaxBoxAggregationOperation TaxBoxAggregationOperation
TaxGroupOperation TaxGroupOperation
TaxCountry TaxCountry Tax Ctry/Reg.
_ReportingCurrency _ReportingCurrency
_AccountingDocument P_StRpAdvncRetForSlsAndPurTx _AccountingDocument
_GLAccount _GLAccount
_TaxJurisdiction _TaxJurisdiction
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem
_ReceivablesPayablesItem _ReceivablesPayablesItem
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem
_TaxTypeText _TaxTypeText
_TaxCodeText _TaxCodeText
_ReportedItemsLog _ReportedItemsLog
StatryRptgEntity _ReportedItemsLog StatryRptgEntity Reporting Entity
StatryRptCategory _ReportedItemsLog StatryRptCategory Report ID
StatryRptRunID _ReportedItemsLog StatryRptRunID Report Run ID

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_StRpAdvncRetForSlsAndPurTxC.
-- 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: ISRADVRTSLSPRTXC
-- Parameters: P_IsParameter : char1, P_ConditionIsMandatory : char1

CREATE VIEW I_StRpAdvncRetForSlsAndPurTxC AS
SELECT
  P_StRpAdvncRetForSlsAndPurTx.CompanyCode AS CompanyCode,
  P_StRpAdvncRetForSlsAndPurTx.AccountingDocument AS AccountingDocument,
  P_StRpAdvncRetForSlsAndPurTx.FiscalYear AS FiscalYear,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  DebitCreditCode,
  TaxCalculationProcedure,
  TaxRate,
  case when TransactionTypeDetermination = 'ESE' then cast(cast(-_NegCharge.TaxRate as abap.dec(11,2)) as char16) when TransactionTypeDetermination = 'ESA' then cast(cast(-TaxRate as abap.dec(11,2)) as char16) else cast(cast(TaxRate as abap.dec(11,2)) as char16) end as IPITaxRate AS dec112aschar16endasIPITaxRate,
  TaxRate AS AdditionalTax1Rate,
  P_ConditionsItem.ConditionAmount AS ConditionAmount,
  case when P_StRpAdvncRetForSlsAndPurTx.Customer is null or P_StRpAdvncRetForSlsAndPurTx.Customer = ' ' then I_BillingDocument.PayerParty end as Customer AS PayerPartyendasCustomer,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  P_StRpAdvncRetForSlsAndPurTx.ConditionRecord AS ConditionRecord,
  RoundingDecimalPlaces,
  P_StRpAdvncRetForSlsAndPurTx.DocumentReferenceID AS DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  P_StRpAdvncRetForSlsAndPurTx.ReportingDate AS ReportingDate,
  P_StRpAdvncRetForSlsAndPurTx.FiscalPeriod AS FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  P_StRpAdvncRetForSlsAndPurTx.TaxAmount AS TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  CalculatedTxAmtInCoCodeCrcy - P_StRpAdvncRetForSlsAndPurTx.TaxAmountInCoCodeCrcy AS DifferenceTaxAmtInCoCodeCrcy,
  CalcdTxBaseAmtInCoCodeCrcy - TaxBaseAmountInCoCodeCrcy AS DiffTaxBaseAmountInCoCodeCrcy,
  TaxType,
  TargetTaxCode,
  TaxNumber2,
  ActiveTaxType,
  TaxNumber3,
  CalculatedTxAmtInCoCodeCrcy,
  CalculatedTaxAmountInTransCrcy,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxIsNotDeductible,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  TaxGroup,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation,
  TaxCountry,
  P_StRpAdvncRetForSlsAndPurTx._AccountingDocument AS _AccountingDocument,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID
LEFT OUTER JOIN P_ConditionsItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CountCountry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CompanyTaxDetails ON /* join condition not captured in parsed metadata */
;

Learn More