I_EDCJournalEntryRecords

DDL: I_EDCJOURNALENTRYRECORDS Type: view_entity BASIC
30 Fields 2 Data Sources

EDC Relevant Journal Entry Records

I_EDCJournalEntryRecords is a Basic CDS View that provides data about "EDC Relevant Journal Entry Records" in SAP S/4HANA. It reads from 2 data sources (I_EDCAccountingDocRelation, I_JournalEntry) and exposes 30 fields with key fields EDCType, CompanyCode, EDCCommonKey.

Data Sources (2)

SourceAliasJoin Type
I_EDCAccountingDocRelation _EDCRelation from
I_JournalEntry _JournalEntry inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EDC Relevant Journal Entry Records view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_EDCAccountingDocRelation EDCType
KEY CompanyCode I_EDCAccountingDocRelation CompanyCode Receiver Company Code
KEY EDCCommonKey I_EDCAccountingDocRelation EDCCommonKey
AccountingDocument I_EDCAccountingDocRelation AccountingDocument Journal Entry
FiscalYear I_EDCAccountingDocRelation FiscalYear G/L Fiscal Year
EDCRecordUUID I_EDCAccountingDocRelation EDCRecordUUID
EDCCreatedOnDateTime I_EDCAccountingDocRelation EDCCreatedOnDateTime
EDCRepresentationType I_EDCAccountingDocRelation EDCRepresentationType
EDCRepresentationKey I_EDCAccountingDocRelation EDCRepresentationKey
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
DocumentDate I_JournalEntry DocumentDate Journal Entry Date
PostingDate I_JournalEntry PostingDate Posting Date for GR
AccountingDocumentCreationDate I_JournalEntry AccountingDocumentCreationDate Journal Entry Date
TransactionCode I_JournalEntry TransactionCode Transaction Code
IntercompanyTransaction I_JournalEntry IntercompanyTransaction Intercompany Transaction
DocumentReferenceID I_JournalEntry DocumentReferenceID Reference
TransactionCurrency I_JournalEntry TransactionCurrency Transaction Currency
AccountingDocumentCategory I_JournalEntry AccountingDocumentCategory Journal Entry Category
BusinessTransactionType I_JournalEntry BusinessTransactionType Bus.transaction
Branch I_JournalEntry Branch Repository branch
IsDiscountDocument I_JournalEntry IsDiscountDocument discount document
TaxReportingDate I_JournalEntry TaxReportingDate Tax Reporting Date
TaxFulfillmentDate I_JournalEntry TaxFulfillmentDate Tax Settlement Date
AccountingDocumentClass I_JournalEntry AccountingDocumentClass Document Cat.
IsReversal I_JournalEntry IsReversal Reversal doc.
IsReversed I_JournalEntry IsReversed Reversed?
TaxCountry I_JournalEntry TaxCountry Tax Ctry/Reg.
WithholdingTaxReportingDate I_JournalEntry WithholdingTaxReportingDate Withholding Tax Reporting Date
_AccountingDocumentCategory I_JournalEntry _AccountingDocumentCategory
_AccountingDocumentType I_JournalEntry _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 I_EDCJournalEntryRecords.
-- 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 I_EDCJournalEntryRecords AS
SELECT
  _EDCRelation.EDCType AS EDCType,
  _EDCRelation.CompanyCode AS CompanyCode,
  _EDCRelation.EDCCommonKey AS EDCCommonKey,
  _EDCRelation.AccountingDocument AS AccountingDocument,
  _EDCRelation.FiscalYear AS FiscalYear,
  _EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  _EDCRelation.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _EDCRelation.EDCRepresentationType AS EDCRepresentationType,
  _EDCRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.DocumentDate AS DocumentDate,
  _JournalEntry.PostingDate AS PostingDate,
  _JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _JournalEntry.TransactionCode AS TransactionCode,
  _JournalEntry.IntercompanyTransaction AS IntercompanyTransaction,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _JournalEntry.TransactionCurrency AS TransactionCurrency,
  _JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  _JournalEntry.BusinessTransactionType AS BusinessTransactionType,
  _JournalEntry.Branch AS Branch,
  _JournalEntry.IsDiscountDocument AS IsDiscountDocument,
  _JournalEntry.TaxReportingDate AS TaxReportingDate,
  _JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  _JournalEntry.AccountingDocumentClass AS AccountingDocumentClass,
  _JournalEntry.IsReversal AS IsReversal,
  _JournalEntry.IsReversed AS IsReversed,
  _JournalEntry.TaxCountry AS TaxCountry,
  _JournalEntry.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  _JournalEntry._AccountingDocumentCategory AS _AccountingDocumentCategory,
  _JournalEntry._AccountingDocumentType AS _AccountingDocumentType
FROM I_EDCAccountingDocRelation AS _EDCRelation
INNER JOIN I_JournalEntry AS _JournalEntry ON /* join condition not captured in parsed metadata */
;

Learn More