C_ManageJournalEntryTaxItem

DDL: C_MANAGEJOURNALENTRYTAXITEM Type: view_entity CONSUMPTION

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. It is exposed through 1 OData service (UI_JOURNALENTRY_MANAGE). It is used in 1 Fiori application: Manage Journal Entries - New Version.

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_JOURNALENTRY_MANAGE UI_JOURNALENTRY_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F0717A Manage Journal Entries - New Version Transactional With this app you can analyze journal entries, create reversals or make adjustments.

Manage Journal Entries - New Version

Business Role: General Ledger Accountant

With this app, you can manage and analyze journal entries. You can find, filter, sort, and group journal entries according to the requirements of your business. The app is your entry point for many important journal entry management functions, allowing you to create, copy, verify, edit, and reverse entries. Additionally, you can initiate correspondence, analyze change and reversal logs, and display entries in t-account views or document flows. You navigate to the details of individual journal entries to display more information, such as transaction data, line items, associated journal entries, and other related documents.

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY TaxItem TaxItem
TaxCode TaxCode
GLAccount GLAccount
TaxItemGroup TaxItemGroup
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
ConditionRecord ConditionRecord
DestinationCountry DestinationCountry
SupplyingCountry SupplyingCountry
TaxJurisdiction TaxJurisdiction
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
TaxReturnDate TaxReturnDate
TaxReportingDate TaxReportingDate
TaxRate TaxRate Tax Rate
TaxRegisterPercentageUnit
TaxReturnCountry TaxReturnCountry
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
BusinessPlace BusinessPlace
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction
TaxJurisdictionLevel TaxJurisdictionLevel
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef
TaxResultManualModification TaxResultManualModification
DebitCreditCode DebitCreditCode Debit/Credit Indicator
TaxRateValidityStartDate TaxRateValidityStartDate
TaxCountry TaxCountry
CompanyCodeCurrency CompanyCodeCurrency
TransactionCurrency TransactionCurrency
AdditionalCurrency1 AdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
CountryCurrency CountryCurrency
TaxCalculationProcedure TaxCalculationProcedure
CompanyCodeName _CompanyCode CompanyCodeName
GLAccountName _GlAccountText GLAccountName
TaxCodeName _TaxCodeText TaxCodeName
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Journal Entry Tax Item'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MIXED
}

@UI.headerInfo: {
  typeName: 'Tax',
  typeNamePlural: 'Taxes'
}

@UI.presentationVariant: [{
    sortOrder: [{
      by: 'AccountingDocument',
      direction: #ASC
    }]
}]

@VDM.viewType: #CONSUMPTION

define view entity C_ManageJournalEntryTaxItem
  as select from R_ManageJournalEntryTaxItem
  association [0..1] to I_CompanyCode                as _CompanyCode   on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_GlAccountTextInCompanycode as _GlAccountText on  $projection.CompanyCode = _GlAccountText.CompanyCode
                                                                       and $projection.GLAccount   = _GlAccountText.GLAccount
                                                                       and _GlAccountText.Language = $session.system_language
  association [0..1] to I_TaxCodeText                as _TaxCodeText   on  $projection.TaxCode                 = _TaxCodeText.TaxCode
                                                                       and $projection.TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure
                                                                       and _TaxCodeText.Language               = $session.system_language

{
      @ObjectModel.text.element:  [ 'CompanyCodeName' ]
      @UI.textArrangement: #TEXT_LAST
  key CompanyCode,
      @Consumption.semanticObject: 'AccountingDocument'
  key AccountingDocument,
  key FiscalYear,
  key TaxItem,
      @UI: {
        lineItem: [{ position: 10 }]
      }
      @ObjectModel.text.element:  [ 'TaxCodeName' ]
      @UI.textArrangement: #TEXT_LAST
      TaxCode,
      @UI: {
        lineItem: [{ position: 20 }]
      }
      @ObjectModel.text.element:  [ 'GLAccountName' ]
      @UI.textArrangement: #TEXT_LAST
      GLAccount,
      TaxItemGroup,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @EndUserText.label: 'Tax Base Amount in Company Code Currency'
      TaxBaseAmountInCoCodeCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @EndUserText.label: 'Tax Base Amount in Transaction Currency'
      TaxBaseAmountInTransCrcy,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @EndUserText.label: 'Tax Amount in Company Code Currency'
      @UI.hidden: true
      TaxAmountInCoCodeCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @EndUserText.label: 'Tax Amount in Transaction Currency'
      @UI.hidden: true
      TaxAmount,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      @EndUserText.label: 'Credit Tax Amount in Company Code Currency'
      CreditAmountInCoCodeCrcy,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      @EndUserText.label: 'Debit Tax Amount in Company Code Currency'
      DebitAmountInCoCodeCrcy,

      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      @EndUserText.label: 'Credit Tax Amount in Transaction Currency'
      CreditAmountInTransCrcy,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      @EndUserText.label: 'Debit Tax Amount in Transaction Currency'
      DebitAmountInTransCrcy,
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      @EndUserText.label: 'Credit Tax Amount in Additional Currency 1' 
      CreditAmountInAddlCrcy1,
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      @EndUserText.label: 'Debit Tax Amount in Additional Currency 1'  
      DebitAmountInAddlCrcy1,
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      @EndUserText.label: 'Credit Tax Amount in Additional Currency 2'
      CreditAmountInAddlCrcy2,
      @EndUserText.label: 'Debit Tax Amount in Additional Currency 2' 
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      DebitAmountInAddlCrcy2,
            
      TransactionTypeDetermination,
      ConditionRecord,
      DestinationCountry,
      SupplyingCountry,
      TaxJurisdiction,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      @EndUserText.label: 'Tax Amount in Additional Currency 1'
      @UI.hidden: true
      TaxAmountInAdditionalCurrency1,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      @EndUserText.label: 'Tax Amount in Additional Currency 2'
      @UI.hidden: true
      TaxAmountInAdditionalCurrency2,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      @EndUserText.label: 'Tax Base Amount in Additional Currency 1'
      TaxBaseAmtInAdditionalCrcy1,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      @EndUserText.label: 'Tax Base Amount in Additional Currency 2'
      TaxBaseAmtInAdditionalCrcy2,
      ConditionType,
      TaxReturnDate,
      TaxReportingDate,
      @UI: {
        lineItem: [{ position: 60 }]
      }
      @ObjectModel.text.element:  [ 'TaxRegisterPercentageUnit' ]
      @UI.textArrangement: #TEXT_LAST
      @EndUserText.label: 'Tax Rate'  
      TaxRate,
      @UI.hidden: true
      cast( '%' as txrgpercentageunit ) as TaxRegisterPercentageUnit,
      TaxReturnCountry,
      @Semantics.amount.currencyCode: 'CountryCurrency'
      @EndUserText.label: 'Tax Amount in Reporting Currency' 
      @UI.hidden: true     
      TaxAmountInCountryCrcy,    
      @Semantics.amount.currencyCode: 'CountryCurrency'
      @EndUserText.label: 'Tax Base Amount in Reporting Currency'        
      TaxBaseAmountInCountryCrcy,
      @Semantics: { amount : {currencyCode: 'CountryCurrency'} }
      @EndUserText.label: 'Credit Tax Amount in Reporting Currency'
      CreditAmountInReportingCrcy,  
      @Semantics: { amount : {currencyCode: 'CountryCurrency'} }
      @EndUserText.label: 'Debit Tax Amount in Reporting Currency'
      DebitAmountInReportingCurrency,        
      TaxDeterminationDate,
      BusinessPlace,
      LowestLevelTaxJurisdiction,
      TaxJurisdictionLevel,
      TaxItemAcctgDocItemRef,
      TaxResultManualModification,
      @EndUserText.label: 'Debit/Credit Indicator'
      DebitCreditCode,
      TaxRateValidityStartDate,
      TaxCountry,
      CompanyCodeCurrency,
      TransactionCurrency,
      AdditionalCurrency1,
      AdditionalCurrency2,
      CountryCurrency,
      TaxCalculationProcedure,
      @Semantics.text: true
      @UI.hidden: true
      _CompanyCode.CompanyCodeName,
      @Semantics.text: true
      @UI.hidden: true
      _GlAccountText.GLAccountName,
      @Semantics.text: true
      @UI.hidden: true
      _TaxCodeText.TaxCodeName
}