I_MaintOrdConfirmationLongText

DDL: I_MAINTORDCONFIRMATIONLONGTEXT Type: view_entity BASIC Package: VDM_EAM_MAINTORDERCONFIRMATION

Maintenance Order Conf Long Text

I_MaintOrdConfirmationLongText is a Basic CDS View that provides data about "Maintenance Order Conf Long Text" in SAP S/4HANA. It reads from 2 data sources (afru_text, I_TextObjectPlainLongText) and exposes 9 fields with key fields ConfirmationGroup, OrderConfirmation, Language. It has 2 associations to related views. Part of development package VDM_EAM_MAINTORDERCONFIRMATION.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
afru_text afru_text inner
I_TextObjectPlainLongText I_TextObjectPlainLongText from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintenanceOrderConfirmation _MaintenanceOrderConf _MaintenanceOrderConf.MaintOrderConf = $projection.ConfirmationGroup and _MaintenanceOrderConf.MaintOrderConfCntrValue = $projection.OrderConfirmation
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Order Conf Long Text view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey OrderConfirmation view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup afru_text rueck
KEY OrderConfirmation afru_text rmzhl
KEY Language I_TextObjectPlainLongText Language
TextObjectKey afru_text tdname
PlainLongText I_TextObjectPlainLongText PlainLongText
TextObjectCategory I_TextObjectPlainLongText TextObjectCategory
MaintenanceOrder _MaintenanceOrderConf MaintenanceOrder
_Language _Language
_MaintenanceOrderConf _MaintenanceOrderConf 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Maintenance Order Conf Long Text'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.representativeKey: 'OrderConfirmation'
define view entity I_MaintOrdConfirmationLongText
  as select from I_TextObjectPlainLongText
    inner join   afru_text on afru_text.tdname = I_TextObjectPlainLongText.TextObjectKey

  association [1..1] to I_MaintenanceOrderConfirmation as _MaintenanceOrderConf on  _MaintenanceOrderConf.MaintOrderConf          = $projection.ConfirmationGroup
                                                                                and _MaintenanceOrderConf.MaintOrderConfCntrValue = $projection.OrderConfirmation
  association [0..1] to I_Language                     as _Language             on  _Language.Language = $projection.Language
{
      @ObjectModel.foreignKey.association: '_MaintenanceOrderConf._ConfirmationGroup'
  key afru_text.rueck                         as ConfirmationGroup,
  key afru_text.rmzhl                         as OrderConfirmation,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key I_TextObjectPlainLongText.Language,
      afru_text.tdname                        as TextObjectKey,
      I_TextObjectPlainLongText.PlainLongText as PlainLongText,
      I_TextObjectPlainLongText.TextObjectCategory,
      _MaintenanceOrderConf.MaintenanceOrder,
      _Language,
      _MaintenanceOrderConf

}
where
      I_TextObjectPlainLongText.TextObjectCategory = 'AUFK'
  and I_TextObjectPlainLongText.TextObjectType     = 'RMEL'
  and _MaintenanceOrderConf.MaintenanceOrder <> ''

Learn More