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
@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
 
  association [0..1] to I_LedgerGroupAssignment as _LedgerGroupReprLedger
    on _JournalEntry.LedgerGroup = _LedgerGroupReprLedger.LedgerGroup
    and _LedgerGroupReprLedger.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 
  
  association [0..*] to R_OfficialDocumentNumberTP        as _OfficialDocumentNumberTP      on  _OfficialDocumentNumberTP.AFDFDocumentKey1 = $projection.CompanyCode
                                                                                            and  _OfficialDocumentNumberTP.AFDFDocumentKey2 = $projection.AccountingDocument
                                                                                            and  _OfficialDocumentNumberTP.AFDFDocumentKey3 = $projection.FiscalYear                                                                                                                                                                                                                                                                                                                                                                                                         
{  
  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.JrnlEntryBusinessTransType,
  _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,
  
  _JournalEntry.ParkingTransactionCode,
  _JournalEntry.JournalEntryIsSecondaryEntry,
  _JournalEntry.EntryViewPostingControl,
  
  _ItemEntryView,
  _OfficialDocumentNumberTP,
  
  _AmountFilter,
  _CreatedByContactCard,
  _ParkedByUserContactCard,
  _MngJrnlEntrTaxCalcTypeText,
  _MngJrnlEntrTxBaseAmtOrignTxt,
  _AccountingDocumentCategoryT,
  _AccountingDocumentTypeText,
  _CompanyCode,
  _LedgerGroupText,
  _ReferenceDocumentTypeText,
  _ReversalReasonText,
  _DocumentWorkflowStatus,
  _TaxCountryText,
  
  //DCL

  _AccountingDocumentType,
  _LedgerGroupReprLedger

}
Depth:
R_MANAGEJOURNALENTRYTP

CDS Views using this table (1)

Learn More
