Which CDS Views use R_MANAGEJOURNALENTRYTP?

R_MANAGEJOURNALENTRYTP is used by 1 CDS view(s), including: C_ManageJournalEntryTP.
R_MANAGEJOURNALENTRYTP

CDS View
Journal Entry
R_MANAGEJOURNALENTRYTP is a CDS View in S/4HANA. Journal Entry. 1 CDS views read from this table.
CDS Views using this table (1)

View	Type	Join	VDM	Description
C_ManageJournalEntryTP	view_entity	projection	CONSUMPTION	Journal Entry
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: ['_CreatedByContactCard', '_ParkedByUserContactCard']
@EndUserText.label: 'Journal Entry'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@ObjectModel.sapObjectNodeType.name: 'JournalEntry'

define root view entity R_ManageJournalEntryTP
  as select
  from R_ManageJournalEntry  as _JournalEntry

  composition [0..*] of R_ManageJournalEntryItemTP as _ItemEntryView

//  association [0..1] to P_MngJrnlEntrAcctgPrinciple as _AccountingPrinciple

//    on _JournalEntry.LedgerGroup = _AccountingPrinciple.LedgerGroup


  association [0..1] to I_AccountingDocumentTypeText as _AccountingDocumentTypeText
    on _JournalEntry.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType
    and _AccountingDocumentTypeText.Language = $session.system_language

  association [0..1] to I_LedgerGroupText as _LedgerGroupText
    on _JournalEntry.LedgerGroup = _LedgerGroupText.LedgerGroup
    and _LedgerGroupText.Language = $session.system_language

// This is probably not needed as header does not have Ledger

//  association [0..1] to I_LedgerGroupAssignment as _LedgerGroupAssignment

//    on _JournalEntry.LedgerGroup = _LedgerGroupAssignment.LedgerGroup

//    and _LedgerGroupAssignment.IsRepresentativeLedger = 'X'


//  association [0..1] to I_Ledger as _LeadingLedger

//    on _LeadingLedger.IsLeadingLedger = 'X'

//


  association [0..1] to I_ReversalReasonText as _ReversalReasonText
    on _JournalEntry.ReversalReason = _ReversalReasonText.ReversalReason
    and _ReversalReasonText.Language = $session.system_language

  association [0..1] to I_ReferenceDocumentTypeText as _ReferenceDocumentTypeText
    on _JournalEntry.ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType
    and _ReferenceDocumentTypeText.Language = $session.system_language


  association [0..1] to I_UserContactCard  as _CreatedByContactCard             on  $projection.AccountingDocCreatedByUser = _CreatedByContactCard.ContactCardID

  association [0..1] to I_UserContactCard  as _ParkedByUserContactCard          on  $projection.ParkedByUser = _ParkedByUserContactCard.ContactCardID

  association [0..1] to I_AccountingDocumentCategoryT as _AccountingDocumentCategoryT
    on _JournalEntry.AccountingDocumentCategory = _AccountingDocumentCategoryT.AccountingDocumentCategory
    and _AccountingDocumentCategoryT.Language = $session.system_language

  association [0..1] to I_CurrencyRoleText as _CurrencyRoleText_AddCurr1
    on _JournalEntry.AdditionalCurrency1Role = _CurrencyRoleText_AddCurr1.CurrencyRole
    and _CurrencyRoleText_AddCurr1.Language = $session.system_language

//  association [0..1] to zpaetI_CurrencyRoleText as _CurrencyRoleDomText_AddCurr1

//    on _JournalEntry.AdditionalCurrency1Role = _CurrencyRoleDomText_AddCurr1.CurrencyRole


  association [0..1] to I_CurrencyRoleText as _CurrencyRoleText_AddCurr2
    on _JournalEntry.AdditionalCurrency2Role = _CurrencyRoleText_AddCurr2.CurrencyRole
    and _CurrencyRoleText_AddCurr2.Language = $session.system_language

//  association [0..1] to zpaetI_CurrencyRoleText as _CurrencyRoleDomText_AddCurr2

//    on _JournalEntry.AdditionalCurrency2Role = _CurrencyRoleDomText_AddCurr2.CurrencyRole


//  association [0..1] to zpaetI_ReversalText as _ReversalText

//    on _JournalEntry.ReversalFunction = _ReversalText.ReversalFunction


  association [0..1] to I_CompanyCode as _CompanyCode
    on _JournalEntry.CompanyCode = _CompanyCode.CompanyCode

  association [0..1] to R_ManageJournalEntryAmount as _AmountFilter
    on _JournalEntry.CompanyCode = _AmountFilter.CompanyCode
    and _JournalEntry.FiscalYear = _AmountFilter.FiscalYear
    and _JournalEntry.AccountingDocument = _AmountFilter.AccountingDocument

  association [0..1] to I_MngJrnlEntrTaxCalcTypeText      as _MngJrnlEntrTaxCalcTypeText    on $projection.TaxCalculationType = _MngJrnlEntrTaxCalcTypeText.TaxCalculationType
                                                                                            and _MngJrnlEntrTaxCalcTypeText.Language = $session.system_language

  association [0..1] to I_MngJrnlEntrTxBaseAmtOrignTxt    as _MngJrnlEntrTxBaseAmtOrignTxt  on $projection.TaxBaseAmountOrigin = _MngJrnlEntrTxBaseAmtOrignTxt.TaxBaseAmountOrigin
                                                                                            and _MngJrnlEntrTxBaseAmtOrignTxt.Language = $session.system_language

  association [0..1] to I_MngJrnlEntrDocWrkflwStsText     as _DocumentWorkflowStatus        on  _JournalEntry.AcctgDocumentWorkflowStatus = _DocumentWorkflowStatus.AcctgDocumentWorkflowStatus
                                                                                            and _DocumentWorkflowStatus.Language = $session.system_language

  association [0..1] to I_CountryText                     as _TaxCountryText                on  $projection.TaxCountry = _TaxCountryText.Country
                                                                                            and _TaxCountryText.Language = $session.system_language
{
  key _JournalEntry.CompanyCode,
  key _JournalEntry.FiscalYear,
  key _JournalEntry.AccountingDocument,

//  @UI: {

//    lineItem: [{ position: 10 }],

//    selectionField: [{ position: 10 }]

//  }

//  // Why is there IF lr_header->rfccur IS INITIAL. (?)

//  case

//    when _JournalEntry.Ledger is not initial then _JournalEntry.Ledger

//    when _LedgerGroupAssignment.Ledger is not initial then _LedgerGroupAssignment.Ledger

//    else _LeadingLedger.Ledger

//  end as Ledger, // RLDNR


  _JournalEntry.Ledger,

//

//  @UI.hidden: true

//  _JournalEntry.TechnicalLedger,

//


  _JournalEntry.AccountingDocumentCategory,
  _JournalEntry.AccountingDocumentHeaderText,
  _JournalEntry.SenderAccountingDocument,
  _JournalEntry.AccountingDocumentType,

//  NOT IN I_JournalEntry

//  case

//    when _JournalEntry.LedgerGroup is initial then _JournalEntry.AccountingPrinciple

//    else _AccountingPrinciple.AccountingPrinciple

//  end as AccountingPrinciple,


  _JournalEntry.AdditionalCurrency1,
//  NOT IN I_JournalEntry

//  cast(_JournalEntry.AdditionalCrcy1ExchangeRate as zpaet_kurs2) as AdditionalCrcy1ExchangeRate,


  _JournalEntry.AdditionalCurrency1Role,
//  case

//    when _CurrencyRoleText_AddCurr1.CurrencyRoleName is null then _CurrencyRoleDomText_AddCurr1.CurrencyRoleName

//    else _CurrencyRoleText_AddCurr1.CurrencyRoleName

//  end as AdditionalCrcy1RoleName, // CURT2_TXT

  _JournalEntry.AdditionalCurrency2,
//  NOT IN I_JournalEntry

//  cast(_JournalEntry.AdditionalCrcy2ExchangeRate as zpaet_kurs3) as AdditionalCrcy2ExchangeRate,


  _JournalEntry.AdditionalCurrency2Role,
//  case

//    when _CurrencyRoleText_AddCurr2.CurrencyRoleName is null then _CurrencyRoleDomText_AddCurr2.CurrencyRoleName

//    else _CurrencyRoleText_AddCurr2.CurrencyRoleName

//  end as AdditionalCrcy2RoleName, // CURT3_TXT


  cast(_JournalEntry.AlternativeReferenceDocument as fis_xblnr_alt_wo_exit) as AlternativeReferenceDocument,


//  NOT IN I_JournalEntry

//  _JournalEntry.AuthorizationCheckLedger,

//  NOT IN I_JournalEntry

//  _JournalEntry.AuthorizationGroupDocumentType,

  _JournalEntry.Branch,
  _JournalEntry.BusinessTransactionType,
  _JournalEntry.CompanyCodeCurrency,
  _JournalEntry.SenderCompanyCode,
//  NOT IN I_JournalEntry

//  _JournalEntry.ControllingDocumentSender,

  _JournalEntry.AccountingDocCreatedByUser,
  _JournalEntry.AccountingDocumentCreationDate,
  _JournalEntry.CreationTime,
  _JournalEntry.CreationDateTime,
//  NOT IN I_JournalEntry

//  _JournalEntry.LocalCreationDate,

  _JournalEntry.DocumentDate,
  _JournalEntry.DocumentReferenceID,
//  //  EnteredDateTime // CPUDTTM


  _JournalEntry.AbsoluteExchangeRate,
  _JournalEntry.ExchangeRateDate,
  _JournalEntry.TaxAbsoluteExchangeRate,
  _JournalEntry.CtryCrcyTxAbsoluteExchangeRate,
  _JournalEntry.MarketDataAbsoluteExchangeRate,
  _JournalEntry.TaxCountry,
  _JournalEntry.ExchangeRateType,
  _JournalEntry.FiscalPeriod,
  _JournalEntry.FiscalYearPeriod,
  _JournalEntry.SenderFiscalYear,

//  NOT IN I_JournalEntry

//  _JournalEntry.GroupCurrency,

  _JournalEntry.IntercompanyTransaction,
  _JournalEntry.InvoiceReceiptDate,
  _JournalEntry.LastManualChangeDate,
  _JournalEntry.LastAutomaticChangeDate,
  _JournalEntry.LedgerGroup,
  _JournalEntry.SenderLogicalSystem,
//  NOT IN I_JournalEntry

//  _JournalEntry.MarketDataExchangeRate,

  _JournalEntry.NmbrOfPages,

  _JournalEntry.OriginalReferenceDocument,
  _JournalEntry.ReferenceDocumentLogicalSystem,
  _JournalEntry.ParkingTime,
  _JournalEntry.ParkedByUser,

//  //  ParkedDateTime // PPDTTM

  _JournalEntry.ParkingDate,
  _JournalEntry.ParkingDateTime,
//  NOT IN I_JournalEntry

//  _JournalEntry.LocalParkedDate,

//  NOT IN I_JournalEntry

//  _JournalEntry.ParkTransaction,

  _JournalEntry.PostingDate,
//  NOT IN I_JournalEntry

//  _JournalEntry.RecrrgAccDocTemplCompanyCode,

//  NOT IN I_JournalEntry

//  _JournalEntry.RecurringAccDocTemplFiscalYear,

  _JournalEntry.RecurringAccountingDocument,
  _JournalEntry.Reference1InDocumentHeader,
  _JournalEntry.Reference2InDocumentHeader,
  _JournalEntry.ReferenceDocumentType,
//  NOT IN I_JournalEntry

//  _JournalEntry.ReversalFunction,

//  _ReversalText.ReversalFunctionName,

  _JournalEntry.ReversalReason,
  _JournalEntry.ReverseDocument,
  _JournalEntry.ReversedDocument,
  _JournalEntry.ReverseDocumentFiscalYear,
  _JournalEntry.ReversalReferenceDocument,
  _JournalEntry.ReversedReferenceDocument,
  _JournalEntry.IsReversal,
  _JournalEntry.IsReversed,
  _JournalEntry.PlannedReversalDate,
  _JournalEntry.TaxBaseAmountIsNetAmount,
  _JournalEntry.TaxBaseAmountOrigin,
  _JournalEntry.TaxFulfillmentDate,
  _JournalEntry.TaxIsCalculatedAutomatically,
  _JournalEntry.TaxCalculationType,
  _JournalEntry.TaxReportingDate,
  _JournalEntry.WithholdingTaxReportingDate,
  _JournalEntry.TransactionCode,
  _JournalEntry.TransactionCurrency,

  _JournalEntry.JrnlEntryCntrySpecificRef1,
  _JournalEntry.JrnlEntryCntrySpecificDate1,
  _JournalEntry.JrnlEntryCntrySpecificRef2,
  _JournalEntry.JrnlEntryCntrySpecificDate2,
  _JournalEntry.JrnlEntryCntrySpecificRef3,
  _JournalEntry.JrnlEntryCntrySpecificDate3,
  _JournalEntry.JrnlEntryCntrySpecificRef4,
  _JournalEntry.JrnlEntryCntrySpecificDate4,
  _JournalEntry.JrnlEntryCntrySpecificRef5,
  _JournalEntry.JrnlEntryCntrySpecificDate5,
  _JournalEntry.JrnlEntryCntrySpecificBP1,
  _JournalEntry.JrnlEntryCntrySpecificBP2,

  _JournalEntry.AcctgDocumentWorkflowStatus,
  @Semantics.booleanIndicator
  _JournalEntry.WrkflwScenIsActv,
  @Semantics.booleanIndicator
  _JournalEntry.AccountingDocumentIsReversible,

  @Semantics.systemDateTime.localInstanceLastChangedAt: true
  _JournalEntry.JournalEntryLastChangeDateTime,

  @Semantics.systemDateTime.lastChangedAt: true
  _JournalEntry.JournalEntryLastChangeDateTime as LastChangeDateTime,

  _ItemEntryView,

  _AmountFilter,
  _CreatedByContactCard,
  _ParkedByUserContactCard,
  _MngJrnlEntrTaxCalcTypeText,
  _MngJrnlEntrTxBaseAmtOrignTxt,
  _AccountingDocumentCategoryT,
  _AccountingDocumentTypeText,
  _CompanyCode,
  _LedgerGroupText,
  _ReferenceDocumentTypeText,
  _ReversalReasonText,
  _DocumentWorkflowStatus,
  _TaxCountryText,

  //DCL

  _AccountingDocumentType

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_MANAGEJOURNALENTRY"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTCATEGORYT",
"I_ACCOUNTINGDOCUMENTTYPE",
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_COMPANYCODE",
"I_COUNTRYTEXT",
"I_LEDGERGROUPTEXT",
"I_MNGJRNLENTRDOCWRKFLWSTSTEXT",
"I_MNGJRNLENTRTAXCALCTYPETEXT",
"I_MNGJRNLENTRTXBASEAMTORIGNTXT",
"I_REFERENCEDOCUMENTTYPETEXT",
"I_REVERSALREASONTEXT",
"I_USERCONTACTCARD",
"R_MANAGEJOURNALENTRYAMOUNT",
"R_MANAGEJOURNALENTRYITEMTP"
],
"BASE":
[
"R_MANAGEJOURNALENTRY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Depth:
R_MANAGEJOURNALENTRYTP

CDS Views using this table (1)

Learn More
