I_CHMLCMPLNCWASTECODEASSGMT

CDS View

Chml Cmplnc Info Waste Code Assgmt

I_CHMLCMPLNCWASTECODEASSGMT is a CDS View in S/4HANA. Chml Cmplnc Info Waste Code Assgmt. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CmbndChmlCmplncWasteCode view inner CONSUMPTION Manage Material - Waste codes
I_ChmlCmplncWasteCodeAssgmtTP view from TRANSACTIONAL Chml Cmplnc Waste Code Assgmt TP

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncWasteCodeUUID ChmlCmplncWasteCodeUUID 1
ChmlCmplncWasteCodeSequence ChmlCmplncWasteCodeSequence 1
MaterialIsRequiredOnLabel MaterialIsRequiredOnLabel 1
MaterialIsRequiredOnManifest MaterialIsRequiredOnManifest 1 
@EndUserText.label: 'Chml Cmplnc Info Waste Code Assgmt'

@AbapCatalog:
{
  sqlViewName: 'ICCIWSTCDASSGMT',
  compiler.compareFilter: true,
  preserveKey:true
}

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  },
  semanticKey:  ['EnvrmtWasteCodeUUID', 'EnvrmtWasteCode' ],
  representativeKey: 'ChmlCmplncWasteCodeAssgmtUUID'
}

--VDM view type
@VDM.viewType: #BASIC

@AccessControl:
{
  authorizationCheck: #CHECK,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ChmlCmplncWasteCodeAssgmt
  as select from ehfndv_ccw_wcast

//  association [1..1] to I_CmplRqVersWasteCode as _CmplRqVersWasteCode on $projection.EnvrmtWasteCodeUUID = _CmplRqVersWasteCode.EnvrmtWasteCodeUUID

  association [1..1] to I_EnvrmtWasteCodesReleased as _CmplRqVersWasteCode on $projection.EnvrmtWasteCodeUUID = _CmplRqVersWasteCode.EnvrmtWasteCodeUUID
                                                                          
  
  association [1..1] to I_ChmlCmplncWasteCode as _ChmlCmplncWasteCode on $projection.ChmlCmplncWasteCodeUUID = _ChmlCmplncWasteCode.ChmlCmplncWasteCodeUUID
  --Link to user data
  association [0..1] to I_User                as _CreatedByUser       on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                as _LastChangedByUser   on $projection.LastChangedByUser = _LastChangedByUser.UserID

{

      //ehfndv_ccw_wcast

  key chmlcmplncwastecodeassgmtuuid                                           as ChmlCmplncWasteCodeAssgmtUUID,

      -- Parent
      @ObjectModel.foreignKey.association: '_ChmlCmplncWasteCode'
      chmlcmplncwastecodeuuid                                                 as ChmlCmplncWasteCodeUUID,
      -- admin data
      @Semantics.systemDateTime.createdAt: true
      cast(creationutcdatetime as ehfnd_bo_crea_date_time preserving type )   as CreationUTCDateTime,
      @Semantics.user.createdBy: true
      cast(createdbyuser as ehfnd_bo_crea_uname preserving type )             as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      cast(lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type ) as LastChangeUTCDateTime,
      @Semantics.user.lastChangedBy: true
      cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type )         as LastChangedByUser,

      -- Assigned Waste Code
      @ObjectModel.foreignKey.association: '_CmplRqVersWasteCode'
      envrmtwastecodeuuid                                                     as EnvrmtWasteCodeUUID,
      envrmtwastecode                                                         as EnvrmtWasteCode,
      chmlcmplncwastecodesequence                                             as ChmlCmplncWasteCodeSequence,
      
      materialisrequiredonmanifest                                            as MaterialIsRequiredOnManifest,
      materialisrequiredonlabel                                               as MaterialIsRequiredOnLabel,
      
      _CmplRqVersWasteCode,
      _ChmlCmplncWasteCode,
      _CreatedByUser,
      _LastChangedByUser



}

Learn More