P_ChgDocUUIDConvertToCharLong

DDL: P_CHGDOCUUIDCONVERTTOCHARLONG SQL: PCHGDOCCCHAR32 Type: view BASIC

P_ChgDocUUIDConvertToCharLong is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 21 fields with key fields ChangeDocumentUUID, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCHGDOCCCHAR32 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.private true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentUUID
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ChangeDocument ChangeDocument
KEY DatabaseTable DatabaseTable
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType ChangeDocItemChangeType
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
CreatedByUser _ChangeDocument CreatedByUser
CreationDate _ChangeDocument CreationDate
CreationTime _ChangeDocument CreationTime
clientNULLasCreationDateTime
ChangeTransactionCode _ChangeDocument ChangeTransactionCode
ChangeDocChangeType _ChangeDocument ChangeDocChangeType
ChangeDocLanguage _ChangeDocument ChangeDocLanguage
_ChangeDocLanguage _ChangeDocument _ChangeDocLanguage 
@AbapCatalog.sqlViewName: 'PCHGDOCCCHAR32'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #D,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@VDM.viewType: #BASIC
@VDM.private: true

define view P_ChgDocUUIDConvertToCharLong
  as select from I_ChangeDocumentItem

{
      //I_ChangeDocumentItem

  key cast(ChangeDocObject as abap.char( 32 ))     as ChangeDocumentUUID,
  key ChangeDocObjectClass,
  key ChangeDocument,
  key DatabaseTable,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,
      ChangeDocPreviousUnit,
      ChangeDocNewUnit,
      ChangeDocPreviousCurrency,
      ChangeDocNewCurrency,
      ChangeDocNewFieldValue,
      ChangeDocPreviousFieldValue,
      /* Associations */
      //I_ChangeDocumentItem


      _ChangeDocument.CreatedByUser,
      _ChangeDocument.CreationDate,
      _ChangeDocument.CreationTime,
      DATS_TIMS_TO_TSTMP( _ChangeDocument.CreationDate,
                          _ChangeDocument.CreationTime,
                          abap_system_timezone( $session.client,'NULL'),
                          $session.client, 'NULL') as CreationDateTime,
      _ChangeDocument.ChangeTransactionCode,
      _ChangeDocument.ChangeDocChangeType,
      _ChangeDocument.ChangeDocLanguage,
      _ChangeDocument._ChangeDocLanguage


}
where
      ChangeDocObjectClass        = '/PLMI/CR_ENG'
  and DatabaseTable               = '/IAM/D_I_ROOT'
  and ChangeDocDatabaseTableField = 'LCYCLE_CD'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[
"I_CHANGEDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More