I_CHMLCMPLNCBRNDDPRODNAME

CDS View

Branded Product Name

I_CHMLCMPLNCBRNDDPRODNAME is a CDS View in S/4HANA. Branded Product Name. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChmlCmplncBrnddProdNameTP view_entity from TRANSACTIONAL Branded Product Name - TP 
@EndUserText.label: 'Branded Product Name'

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@VDM.viewType: #BASIC

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #A
  }
}

@Metadata.ignorePropagatedAnnotations: true
define view entity I_ChmlCmplncBrnddProdName
  as select from ehfndd_cci_bpn

  association [1..1] to I_ChmlCmplncInfo           as _ChmlCmplncInfo            on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

  association [0..*] to I_ChmlCmplncBrnddProdCntry as _BrandedProductNameCountry on $projection.ChmlCmplncBrnddProdNameUUID = _BrandedProductNameCountry.ChmlCmplncBrnddProdNameUUID
  
  association [0..1] to I_Language              as _Language          on $projection.Language           = _Language.Language
    
{
  key uuid                                                             as ChmlCmplncBrnddProdNameUUID,
      cci_uuid                                                         as ChmlCmplncInfoUUID,
      @Semantics.systemDateTime.createdAt: true
      cast(crea_date_time as ehfnd_bo_crea_date_time preserving type ) as CreationDateTime,
      @Semantics.user.createdBy: true
      cast(crea_uname as ehfnd_bo_crea_uname preserving type )         as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      cast(lchg_date_time as ehfnd_bo_lchg_date_time preserving type ) as LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      cast(lchg_uname as ehfnd_bo_lchg_uname preserving type )         as LastChangedByUser,
      language                                                         as Language,
      name                                                             as ChmlCmplncBrnddProdName,

      _ChmlCmplncInfo,
      _Language,
      _BrandedProductNameCountry
}

Learn More