What is R_ManageJournalEntryDraft in SAP S/4HANA?

R_ManageJournalEntryDraft is a basic CDS view in SAP S/4HANA. Draft Data for Journal Entry It contains 98 fields.

Which tables does R_ManageJournalEntryDraft read from?

R_ManageJournalEntryDraft reads data from: mngje_draft.

What VDM layer is R_ManageJournalEntryDraft?

R_ManageJournalEntryDraft is classified as a Basic (interface) view providing a 1:1 representation of a database table.

R_ManageJournalEntryDraft

DDL: R_MANAGEJOURNALENTRYDRAFT Type: view_entity BASIC Package: ODATA_MANAGE_JOURNAL_ENTRY_V2

98 Fields 1 Data Sources 1 Associations

Draft Data for Journal Entry

R_ManageJournalEntryDraft is a Basic CDS View that provides data about "Draft Data for Journal Entry" in SAP S/4HANA. It reads from 1 data source (mngje_draft) and exposes 98 fields with key fields CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views. Part of development package ODATA_MANAGE_JOURNAL_ENTRY_V2.

Data Sources (1)

Source	Alias	Join Type
mngje_draft	mngje_draft	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_AccountingDocumentType	_AccountingDocumentType	`$projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Draft Data for Journal Entry	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (98)

Key	Field	Source Field	Description
KEY	CompanyCode	companycode	Receiver Company Code
KEY	FiscalYear	fiscalyear	G/L Fiscal Year
KEY	AccountingDocument	accountingdocument	Journal Entry
	Ledger	ledger	Ledger
	AccountingDocumentCategory	accountingdocumentcategory	Journal Entry Category
	AccountingDocumentHeaderText	accountingdocumentheadertext	Doc.Header Text
	SenderAccountingDocument	senderaccountingdocument	Sender Journal Entry
	AccountingDocumentType	accountingdocumenttype	Journal Entry Type
	AdditionalCurrency1	additionalcurrency1	Local curr. 2
	AdditionalCurrency1Role	additionalcurrency1role	LC2 Crcy Type
	AdditionalCurrency2	additionalcurrency2	Local curr. 3
	AdditionalCurrency2Role	additionalcurrency2role	LC3 Crcy Type
	AlternativeReferenceDocument	alternativereferencedocument	Alternative Reference Document
	Branch	branch	Repository branch
	BusinessTransactionType	businesstransactiontype	Bus.transaction
	JrnlEntryBusinessTransType	jrnlentrybusinesstranstype
	CompanyCodeCurrency	companycodecurrency	Local Currency
	SenderCompanyCode	sendercompanycode	Sender Company Code
	AccountingDocCreatedByUser	accountingdoccreatedbyuser	User which created overhead document
	AccountingDocumentCreationDate	accountingdocumentcreationdate	Journal Entry Date
	CreationTime	creationtime	Time of Change
	CreationDateTime	creationdatetime	Timestamp
	DocumentDate	documentdate	Journal Entry Date
	DocumentReferenceID	documentreferenceid	Reference
	AbsoluteExchangeRate	absoluteexchangerate	Absolute Exchange Rate
	ExchangeRateDate	exchangeratedate	Translatn Date
	TaxAbsoluteExchangeRate	taxabsoluteexchangerate	Absolute Tax Exchange Rate
	CtryCrcyTxAbsoluteExchangeRate	ctrycrcytxabsoluteexchangerate	Absolute Tax Exch. Rate in C/R Cur.
	MarketDataAbsoluteExchangeRate	marketdataabsoluteexchangerate	Absolute Market Data Exch. Rate
	TaxCountry	taxcountry	Tax Ctry/Reg.
	ExchangeRateType	exchangeratetype	Exch. Rate Type
	FiscalPeriod	fiscalperiod	Tax period
	FiscalYearPeriod	fiscalyearperiod	Period/Year
	SenderFiscalYear	senderfiscalyear	Sender FiscalYr
	IntercompanyTransaction	intercompanytransaction	Intercompany Transaction
	InvoiceReceiptDate	invoicereceiptdate	Invoice Receipt Date
	LastManualChangeDate	lastmanualchangedate	Manual Change Date
	LastAutomaticChangeDate	lastautomaticchangedate	Autom. Change Date
	LedgerGroup	ledgergroup	Ledger Group
	SenderLogicalSystem	senderlogicalsystem	Sender Logical System
	NmbrOfPages	nmbrofpages	SDS Number of Pages
	OriginalReferenceDocument	originalreferencedocument	Reference Key
	ReferenceDocumentLogicalSystem	referencedocumentlogicalsystem	Ref. Doc. Lgcl Syst.
	ParkingTime	parkingtime	Parked At
	ParkedByUser	parkedbyuser	JE Parked By
	ParkingDate	parkingdate	Parked On
	ParkingDateTime	parkingdatetime	Time Stamp
	PostingDate	postingdate	Posting Date for GR
	RecurringAccountingDocument	recurringaccountingdocument	Recurring Journal Entry
	Reference1InDocumentHeader	reference1indocumentheader	Reference 1
	Reference2InDocumentHeader	reference2indocumentheader	Reference 2
	ReferenceDocumentType	referencedocumenttype	Reference Document Type
	ReversalReason	reversalreason	Reversal Reason
	ReverseDocument	reversedocument	Reversed With
	ReversedDocument	reverseddocument	Reversed doc.
	ReverseDocumentFiscalYear	reversedocumentfiscalyear	Year
	ReversalReferenceDocument	reversalreferencedocument	Reversal Reference Document
	ReversedReferenceDocument	reversedreferencedocument	Reversed Reference Document
	IsReversal	isreversal	Reversal doc.
	IsReversed	isreversed	Reversed?
	PlannedReversalDate	plannedreversaldate	Reversal Date
	TaxBaseAmountIsNetAmount	taxbaseamountisnetamount	Tax Base Amount is Net Amount
	TaxBaseAmountOrigin	taxbaseamountorigin	Tax Based On
	TaxFulfillmentDate	taxfulfillmentdate	Tax Settlement Date
	TaxIsCalculatedAutomatically	taxiscalculatedautomatically	Tax Is Automatically Calculated
	TaxCalculationType	taxcalculationtype	Tax Calculation
	TaxReportingDate	taxreportingdate	Tax Reporting Date
	WithholdingTaxReportingDate	withholdingtaxreportingdate	Withholding Tax Reporting Date
	TransactionCode	transactioncode	Transaction Code
	TransactionCurrency	transactioncurrency	Transaction Currency
	JrnlEntryCntrySpecificRef1	jrnlentrycntryspecificref1	Country/Region Specific Reference 1
	JrnlEntryCntrySpecificDate1	jrnlentrycntryspecificdate1	Country/Region Specific Date 1
	JrnlEntryCntrySpecificRef2	jrnlentrycntryspecificref2	Country/Region Specific Reference 2
	JrnlEntryCntrySpecificDate2	jrnlentrycntryspecificdate2	Country/Region Specific Date 2
	JrnlEntryCntrySpecificRef3	jrnlentrycntryspecificref3	Country/Region Specific Reference 3
	JrnlEntryCntrySpecificDate3	jrnlentrycntryspecificdate3	Country/Region Specific Date 3
	JrnlEntryCntrySpecificRef4	jrnlentrycntryspecificref4	Country/Region Specific Reference 4
	JrnlEntryCntrySpecificDate4	jrnlentrycntryspecificdate4	Country/Region Specific Date 4
	JrnlEntryCntrySpecificRef5	jrnlentrycntryspecificref5	Country/Region Specific Reference 5
	JrnlEntryCntrySpecificDate5	jrnlentrycntryspecificdate5	Country/Region Specific Date 5
	JrnlEntryCntrySpecificBP1	jrnlentrycntryspecificbp1	Ctry/Reg. Specific Business Partner 1
	JrnlEntryCntrySpecificBP2	jrnlentrycntryspecificbp2	Ctry/Reg. Specific Business Partner 2
	AcctgDocumentWorkflowStatus	acctgdocumentworkflowstatus	Workflow Status
	WrkflwScenIsActv	wrkflwscenisactv
	AccountingDocumentIsReversible	accountingdocumentisreversible
	JournalEntryLastChangeDateTime	journalentrylastchangedatetime	Journal Entry Last Change Date Time
	LastChangeDateTime	lastchangedatetime	Timestamp
	ParkingTransactionCode	parkingtransactioncode
	JournalEntryIsSecondaryEntry	journalentryissecondaryentry	Is Secondary Journal Entry
	EntryViewPostingControl	entryviewpostingcontrol
	JrnlEntrIsCrtedFromAIProposal	jrnlentriscrtedfromaiproposal
	DraftEntityCreationDateTime	draftentitycreationdatetime	Draft Created On
	DraftEntityLastChangeDateTime	draftentitylastchangedatetime	Draft Last Changed On
	DraftAdministrativeDataUUID	draftadministrativedatauuid	UUID
	DraftEntityOperationCode	draftentityoperationcode	Draft - Operation Code
	HasActiveEntity	hasactiveentity	TRUE
	DraftFieldChanges	draftfieldchanges	Field Changes
	_AccountingDocumentType	_AccountingDocumentType

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_ManageJournalEntryDraft.
-- 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_ManageJournalEntryDraft AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  Ledger,
  AccountingDocumentCategory,
  AccountingDocumentHeaderText,
  SenderAccountingDocument,
  AccountingDocumentType,
  AdditionalCurrency1,
  AdditionalCurrency1Role,
  AdditionalCurrency2,
  AdditionalCurrency2Role,
  AlternativeReferenceDocument,
  Branch,
  BusinessTransactionType,
  JrnlEntryBusinessTransType,
  CompanyCodeCurrency,
  SenderCompanyCode,
  AccountingDocCreatedByUser,
  AccountingDocumentCreationDate,
  CreationTime,
  CreationDateTime,
  DocumentDate,
  DocumentReferenceID,
  AbsoluteExchangeRate,
  ExchangeRateDate,
  TaxAbsoluteExchangeRate,
  CtryCrcyTxAbsoluteExchangeRate,
  MarketDataAbsoluteExchangeRate,
  TaxCountry,
  ExchangeRateType,
  FiscalPeriod,
  FiscalYearPeriod,
  SenderFiscalYear,
  IntercompanyTransaction,
  InvoiceReceiptDate,
  LastManualChangeDate,
  LastAutomaticChangeDate,
  LedgerGroup,
  SenderLogicalSystem,
  NmbrOfPages,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  ParkingTime,
  ParkedByUser,
  ParkingDate,
  ParkingDateTime,
  PostingDate,
  RecurringAccountingDocument,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  ReferenceDocumentType,
  ReversalReason,
  ReverseDocument,
  ReversedDocument,
  ReverseDocumentFiscalYear,
  ReversalReferenceDocument,
  ReversedReferenceDocument,
  IsReversal,
  IsReversed,
  PlannedReversalDate,
  TaxBaseAmountIsNetAmount,
  TaxBaseAmountOrigin,
  TaxFulfillmentDate,
  TaxIsCalculatedAutomatically,
  TaxCalculationType,
  TaxReportingDate,
  WithholdingTaxReportingDate,
  TransactionCode,
  TransactionCurrency,
  JrnlEntryCntrySpecificRef1,
  JrnlEntryCntrySpecificDate1,
  JrnlEntryCntrySpecificRef2,
  JrnlEntryCntrySpecificDate2,
  JrnlEntryCntrySpecificRef3,
  JrnlEntryCntrySpecificDate3,
  JrnlEntryCntrySpecificRef4,
  JrnlEntryCntrySpecificDate4,
  JrnlEntryCntrySpecificRef5,
  JrnlEntryCntrySpecificDate5,
  JrnlEntryCntrySpecificBP1,
  JrnlEntryCntrySpecificBP2,
  AcctgDocumentWorkflowStatus,
  WrkflwScenIsActv,
  AccountingDocumentIsReversible,
  JournalEntryLastChangeDateTime,
  LastChangeDateTime,
  ParkingTransactionCode,
  JournalEntryIsSecondaryEntry,
  EntryViewPostingControl,
  JrnlEntrIsCrtedFromAIProposal,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM mngje_draft
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
;

Depth:

R_ManageJournalEntryDraft view_entity

mngje_draft