P_AllocCycleVersionStatusName

DDL: P_ALLOCCYCLEVERSIONSTATUSNAME Type: view_entity CONSUMPTION Package: ODATA_MANAGE_ALLOC_CHANGES

Allocation Object Type Text

P_AllocCycleVersionStatusName is a Consumption CDS View that provides data about "Allocation Object Type Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields with key fields AllocationCycleVersionStatus, Language. It has 1 association to related views. Part of development package ODATA_MANAGE_ALLOC_CHANGES.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY AllocationCycleVersionStatus
KEY Language
AllocCycleVersionStatusText
_Language _Language
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view entity P_AllocCycleVersionStatusName
  as select from dd07t

  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language

{
  key cast( substring( domvalue_l, 1, 1) as fcoua_cycle_version_status preserving type ) as AllocationCycleVersionStatus,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast( ddlanguage as spras preserving type )                    as Language,

      @Semantics.text: true
      cast(ddtext as fcoua_cycle_versn_status_name)                  as AllocCycleVersionStatusText,
      _Language

}
where
      domname  = 'FCOUA_CYCLE_VERSION_STATUS'
  and as4local = 'A';