I_SerialNumberChangeDocument

DDL: I_SERIALNUMBERCHANGEDOCUMENT Type: view_entity COMPOSITE Package: ODATA_LO_SN_HISTORY

Serial Number Change Documents

I_SerialNumberChangeDocument is a Composite CDS View that provides data about "Serial Number Change Documents" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocumentItem, I_Equipment) and exposes 15 fields with key fields Equipment, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocDatabaseTableField. It has 1 association to related views. Part of development package ODATA_LO_SN_HISTORY.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from
I_Equipment I_Equipment inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChangeDocFieldNamesT _ChangeDocFieldNamesT I_ChangeDocumentItem.DatabaseTable = _ChangeDocFieldNamesT.DatabaseTable and I_ChangeDocumentItem.ChangeDocDatabaseTableField = _ChangeDocFieldNamesT.Value

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Serial Number Change Documents view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_Equipment Equipment
KEY ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType
KEY LastChangeDate
KEY LastChangeTime
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue
ChangeDocNewFieldValueText
ChangeDocPrevFieldValueText
LastChangedByUser
ChangeDocDatabaseTblFieldText _ChangeDocFieldNamesT Text 
@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Serial Number Change Documents'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }

@VDM.viewType: #COMPOSITE

define view entity I_SerialNumberChangeDocument
  as select from I_ChangeDocumentItem

    inner join   I_Equipment          on I_ChangeDocumentItem.ChangeDocObject = I_Equipment.Equipment

  association [1..1] to I_ChangeDocFieldNamesT as _ChangeDocFieldNamesT
    on  I_ChangeDocumentItem.DatabaseTable               = _ChangeDocFieldNamesT.DatabaseTable
    and I_ChangeDocumentItem.ChangeDocDatabaseTableField = _ChangeDocFieldNamesT.Value

{
  key I_Equipment.Equipment,
  key I_ChangeDocumentItem.ChangeDocObjectClass,
  key I_ChangeDocumentItem.ChangeDocument,
  key I_ChangeDocumentItem.DatabaseTable,
  key I_ChangeDocumentItem.ChangeDocDatabaseTableField,
  key I_ChangeDocumentItem.ChangeDocItemChangeType,
  key I_ChangeDocumentItem._ChangeDocument.CreationDate          as LastChangeDate,
  key I_ChangeDocumentItem._ChangeDocument.CreationTime          as LastChangeTime,
  key I_ChangeDocumentItem.ChangeDocTableKey,

      I_ChangeDocumentItem.ChangeDocNewFieldValue,
      I_ChangeDocumentItem.ChangeDocPreviousFieldValue,
      
      cast( '' as cdfldvaln ) as ChangeDocNewFieldValueText,
      cast( '' as cdfldvalo ) as ChangeDocPrevFieldValueText,

      I_ChangeDocumentItem._ChangeDocument.CreatedByUser         as LastChangedByUser,
      _ChangeDocFieldNamesT.Text                                 as ChangeDocDatabaseTblFieldText
}

where I_ChangeDocumentItem.ChangeDocObjectClass         = 'EQUI'
  and I_ChangeDocumentItem.ChangeDocDatabaseTableField <> 'KEY'

Learn More