I_CnsldtnJrnlEntryItemOriginT

DDL: I_CNSLDTNJRNLENTRYITEMORIGINT Type: view_entity BASIC
6 Fields 1 Data Sources 1 Associations

Cnsldtn Journal Entry Item Origin - Text

I_CnsldtnJrnlEntryItemOriginT is a Basic CDS View that provides data about "Cnsldtn Journal Entry Item Origin - Text" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnDomainText) and exposes 6 fields with key fields Language, CnsldtnJrnlEntryItemOrigin. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CnsldtnDomainText P_CnsldtnDomainText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CnsldtnJrnlEntryItemOrigin _EntryItemOrigin $projection.CnsldtnJrnlEntryItemOrigin = _EntryItemOrigin.CnsldtnJrnlEntryItemOrigin

Annotations (13)

NameValueLevelField
Analytics.dataExtraction.enabled true view
Analytics.technicalName ICSJRNlEntryItemOriginT view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CnsldtnJrnlEntryItemOrigin view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Search.searchable true view
VDM.viewType #BASIC view
EndUserText.label Cnsldtn Journal Entry Item Origin - Text view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language
KEY CnsldtnJrnlEntryItemOrigin
CnsldtnJrnlEntryItemOriginText
DomainValue _DomainT DomainValue Lower Value
_EntryItemOrigin _EntryItemOrigin
_Language _DomainT _Language

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_CnsldtnJrnlEntryItemOriginT.
-- 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_CnsldtnJrnlEntryItemOriginT AS
SELECT
  cast(_DomainT.Language as spras preserving type ) AS Language,
  cast(left(_DomainT.DomainValue, 1) as fincs_jrnlentryitemorigin preserving type ) AS CnsldtnJrnlEntryItemOrigin,
  cast(_DomainT.DomainValueText as fincs_jrnlentryitemorigintext preserving type ) AS CnsldtnJrnlEntryItemOriginText,
  _DomainT.DomainValue AS DomainValue,
  _DomainT._Language AS _Language
FROM P_CnsldtnDomainText
LEFT OUTER JOIN I_CnsldtnJrnlEntryItemOrigin AS _EntryItemOrigin ON CnsldtnJrnlEntryItemOrigin = _EntryItemOrigin.CnsldtnJrnlEntryItemOrigin  -- association [1..1]
;

Learn More