R_ManageJournalEntryTaxItem

DDL: R_MANAGEJOURNALENTRYTAXITEM Type: view_entity COMPOSITE
65 Fields 1 Data Sources 1 Associations

Journal Entry Tax Item

R_ManageJournalEntryTaxItem is a Composite CDS View that provides data about "Journal Entry Tax Item" in SAP S/4HANA. It reads from 1 data source (P_ManageJournalEntryTaxItem) and exposes 65 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ManageJournalEntryTaxItem P_ManageJournalEntryTaxItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Country _Country $projection.Country = _Country.Country

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Journal Entry Tax Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem Tax Item
TaxCode TaxCode Tax Code
GLAccount GLAccount General Ledger
TaxItemGroup TaxItemGroup Tax doc. item number
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ConditionRecord ConditionRecord Cond.Record No.
VATRegistration VATRegistration VAT Registration No.
DestinationCountry DestinationCountry Dest. Ctry/Reg
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
ConditionType ConditionType Condition type
TaxReturnDate TaxReturnDate
TaxReturnExecutionTime TaxReturnExecutionTime
TaxReportingDate TaxReportingDate Tax Reporting Date
TaxRate TaxRate Tax Rate
TaxReturnCountry TaxReturnCountry Reporting C/R
TaxAmountInCountryCrcy TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmountInCountryCrcy
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
BusinessPlace BusinessPlace Business place
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
TaxJurisdictionLevel TaxJurisdictionLevel Jurisdiction level
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef Tax doc. item number
TaxResultManualModification TaxResultManualModification Tax Modified
DebitCreditCode DebitCreditCode Single-Character Flag
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxCountry TaxCountry Tax Ctry/Reg.
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
TransactionCurrency TransactionCurrency Transaction Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
CountryCurrency CountryCurrency Currency
Country Country Venue: Ctry/Reg
TaxCalculationProcedure _Country TaxCalculationProcedure Tax Procedure
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInAddlCrcy1 CreditAmountInAddlCrcy1 Amount in Additional Currency 1
DebitAmountInAddlCrcy1 DebitAmountInAddlCrcy1 Amount in Additional Currency 1
CreditAmountInAddlCrcy2 CreditAmountInAddlCrcy2 Amount in Additional Currency 2
DebitAmountInAddlCrcy2 DebitAmountInAddlCrcy2 Amount in Additional Currency 2
CreditAmountInReportingCrcy CreditAmountInReportingCrcy
DebitAmountInReportingCurrency DebitAmountInReportingCurrency
_CompanyCodeCountry _CompanyCodeCountry
_CompanyCodeCurrency _CompanyCodeCurrency
_Currency _Currency
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem
_GLAccount _GLAccount
_JournalEntry _JournalEntry
_ReceivablesPayablesItem _ReceivablesPayablesItem
_TaxJurisdiction _TaxJurisdiction
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem

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 R_ManageJournalEntryTaxItem.
-- 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 R_ManageJournalEntryTaxItem AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  GLAccount,
  TaxItemGroup,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  TransactionTypeDetermination,
  ConditionRecord,
  VATRegistration,
  DestinationCountry,
  SupplyingCountry,
  TaxJurisdiction,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  ConditionType,
  TaxReturnDate,
  TaxReturnExecutionTime,
  TaxReportingDate,
  TaxRate,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  abs( TaxBaseAmountInCountryCrcy ) AS TaxBaseAmountInCountryCrcy,
  TaxDeterminationDate,
  BusinessPlace,
  LowestLevelTaxJurisdiction,
  TaxJurisdictionLevel,
  TaxItemAcctgDocItemRef,
  TaxResultManualModification,
  DebitCreditCode,
  TaxRateValidityStartDate,
  TaxCountry,
  CompanyCodeCurrency,
  CompanyCodeCountry,
  TransactionCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CountryCurrency,
  Country,
  _Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  CreditAmountInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInTransCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInAddlCrcy1,
  DebitAmountInAddlCrcy1,
  CreditAmountInAddlCrcy2,
  DebitAmountInAddlCrcy2,
  CreditAmountInReportingCrcy,
  DebitAmountInReportingCurrency
FROM P_ManageJournalEntryTaxItem
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
;

Learn More