C_ManageJournalEntryTaxItem

DDL: C_MANAGEJOURNALENTRYTAXITEM Type: view_entity CONSUMPTION
56 Fields 1 Data Sources 3 Associations

Journal Entry Tax Item

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

Data Sources (1)

SourceAliasJoin Type
R_ManageJournalEntryTaxItem R_ManageJournalEntryTaxItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_GlAccountTextInCompanycode _GlAccountText $projection.CompanyCode = _GlAccountText.CompanyCode and $projection.GLAccount = _GlAccountText.GLAccount and _GlAccountText.Language = $session.system_language
[0..1] I_TaxCodeText _TaxCodeText $projection.TaxCode = _TaxCodeText.TaxCode and $projection.TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure and _TaxCodeText.Language = $session.system_language

Annotations (9)

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
UI.headerInfo.typeName Tax view
UI.headerInfo.typeNamePlural Taxes view
VDM.viewType #CONSUMPTION view

Fields (56)

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 Tax Base Amount in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmount TaxAmount Tax Amount in Transaction Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Tax Amount in Company Code Currency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Tax Amount in Company Code Currency
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Tax Amount in Transaction Currency
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Tax Amount in Transaction Currency
CreditAmountInAddlCrcy1 CreditAmountInAddlCrcy1 Credit Tax Amount in Additional Currency 1
DebitAmountInAddlCrcy1 DebitAmountInAddlCrcy1 Debit Tax Amount in Additional Currency 1
CreditAmountInAddlCrcy2 CreditAmountInAddlCrcy2 Credit Tax Amount in Additional Currency 2
DebitAmountInAddlCrcy2 DebitAmountInAddlCrcy2 Debit Tax Amount in Additional Currency 2
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ConditionRecord ConditionRecord Cond.Record No.
DestinationCountry DestinationCountry Dest. Ctry/Reg
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 Tax Amount in Additional Currency 1
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 Tax Amount in Additional Currency 2
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 Tax Base Amount in Additional Currency 1
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 Tax Base Amount in Additional Currency 2
ConditionType ConditionType Condition type
TaxReturnDate TaxReturnDate
TaxReportingDate TaxReportingDate Tax Reporting Date
TaxRate TaxRate Tax Rate
TaxRegisterPercentageUnit
TaxReturnCountry TaxReturnCountry Reporting C/R
TaxAmountInCountryCrcy TaxAmountInCountryCrcy Tax Amount in Reporting Currency
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Tax Base Amount in Reporting Currency
CreditAmountInReportingCrcy CreditAmountInReportingCrcy Credit Tax Amount in Reporting Currency
DebitAmountInReportingCurrency DebitAmountInReportingCurrency Debit Tax Amount in Reporting Currency
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 Debit/Credit Indicator
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxCountry TaxCountry Tax Ctry/Reg.
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TransactionCurrency TransactionCurrency Transaction Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
CountryCurrency CountryCurrency Currency
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
CompanyCodeName _CompanyCode CompanyCodeName Company Name
GLAccountName _GlAccountText GLAccountName Short Text
TaxCodeName _TaxCodeText TaxCodeName Tax Code Name

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_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 C_ManageJournalEntryTaxItem AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  GLAccount,
  TaxItemGroup,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  CreditAmountInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInTransCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInAddlCrcy1,
  DebitAmountInAddlCrcy1,
  CreditAmountInAddlCrcy2,
  DebitAmountInAddlCrcy2,
  TransactionTypeDetermination,
  ConditionRecord,
  DestinationCountry,
  SupplyingCountry,
  TaxJurisdiction,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  ConditionType,
  TaxReturnDate,
  TaxReportingDate,
  TaxRate,
  cast( '%' as txrgpercentageunit ) AS TaxRegisterPercentageUnit,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  CreditAmountInReportingCrcy,
  DebitAmountInReportingCurrency,
  TaxDeterminationDate,
  BusinessPlace,
  LowestLevelTaxJurisdiction,
  TaxJurisdictionLevel,
  TaxItemAcctgDocItemRef,
  TaxResultManualModification,
  DebitCreditCode,
  TaxRateValidityStartDate,
  TaxCountry,
  CompanyCodeCurrency,
  TransactionCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CountryCurrency,
  TaxCalculationProcedure,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _GlAccountText.GLAccountName AS GLAccountName,
  _TaxCodeText.TaxCodeName AS TaxCodeName
FROM R_ManageJournalEntryTaxItem
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GlAccountText ON CompanyCode = _GlAccountText.CompanyCode AND GLAccount = _GlAccountText.GLAccount AND _GlAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode AND TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure AND _TaxCodeText.Language = $session.system_language  -- association [0..1]
;

Learn More