P_ChmlCompositionMigrationCast

DDL: P_CHMLCOMPOSITIONMIGRATIONCAST SQL: PCHMLCMPSMIGC Type: view COMPOSITE

P_ChmlCompositionMigrationCast is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ChmlComposition) and exposes 18 fields.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlComposition ChmlComposition from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCHMLCMPSMIGC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (18)

KeyFieldSource TableSource FieldDescription
ChmlCompositionUUID I_ChmlComposition ChmlCompositionUUID
ChmlCmplncInfoUUID I_ChmlComposition ChmlCmplncInfoUUID
ChmlSuplrMatlUUID I_ChmlComposition ChmlSuplrMatlUUID
Otherwise
ChmlCompositionType I_ChmlComposition ChmlCompositionType
ProdCmplncLegalArea I_ChmlComposition ProdCmplncLegalArea
ChmlCompositionStatus I_ChmlComposition ChmlCompositionStatus
PolymerCompositionIntID I_ChmlComposition PolymerCompositionIntID
ReleaseDateTime I_ChmlComposition ReleaseDateTime
ReleasedByUser I_ChmlComposition ReleasedByUser
ValidityStartDateTime I_ChmlComposition ValidityStartDateTime
ValidityEndDateTime I_ChmlComposition ValidityEndDateTime
ProdCmplncLegalAreaRef I_ChmlComposition ProdCmplncLegalAreaRef
PolymerCompositionName I_ChmlComposition PolymerCompositionName
CreationUTCDateTime I_ChmlComposition CreationUTCDateTime
CreatedByUser I_ChmlComposition CreatedByUser
LastChangeUTCDateTime I_ChmlComposition LastChangeUTCDateTime
LastChangedByUser I_ChmlComposition LastChangedByUser 
@AbapCatalog.sqlViewName: 'PCHMLCMPSMIGC'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_ALLOWED

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #B
  }
}

@VDM.viewType: #COMPOSITE
@VDM.private: true

-------------------------------------------------------------
-- IMPORTANT: View may not be changed after initial delivery!
-------------------------------------------------------------

define view P_ChmlCompositionMigrationCast

  as select from I_ChmlComposition as ChmlComposition

{
  ChmlComposition.ChmlCompositionUUID,
  ChmlComposition.ChmlCmplncInfoUUID,
  ChmlComposition.ChmlSuplrMatlUUID,

  -- Make sure that null values are converted into a zero guid. Otherwise, duplicates are not found
  cast( case
    when ChmlComposition.SubstanceUUID is null
        then hextobin( '00000000000000000000000000000000' )
    when ChmlComposition.SubstanceUUID = hextobin( '                                ' )
        then hextobin( '00000000000000000000000000000000' )
    else ChmlComposition.SubstanceUUID
   end as ehfnd_sub_uuid ) as SubstanceUUID,

  ChmlComposition.ChmlCompositionType,
  ChmlComposition.ProdCmplncLegalArea,
  ChmlComposition.ChmlCompositionStatus,
  ChmlComposition.PolymerCompositionIntID,

  ChmlComposition.ReleaseDateTime,
  ChmlComposition.ReleasedByUser,
  ChmlComposition.ValidityStartDateTime,
  ChmlComposition.ValidityEndDateTime,

  ChmlComposition.ProdCmplncLegalAreaRef,
  ChmlComposition.PolymerCompositionName,

  ChmlComposition.CreationUTCDateTime,
  ChmlComposition.CreatedByUser,
  ChmlComposition.LastChangeUTCDateTime,
  ChmlComposition.LastChangedByUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCOMPOSITION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More