I_CHMLCMPLNCBRNDDPRODCNTRY

CDS View

Branded Product Name Country

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

Used by 1 CDS view(s)

CDS Views using this table (1)

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

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@VDM.viewType: #BASIC

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


@Metadata.ignorePropagatedAnnotations: true
define view entity I_ChmlCmplncBrnddProdCntry
  as select from ehfndd_cci_bpnc

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

  association [1..1] to I_ChmlCmplncBrnddProdName as _BrandedProductName on $projection.ChmlCmplncBrnddProdNameUUID = _BrandedProductName.ChmlCmplncBrnddProdNameUUID

 -- Country
  association [0..1] to I_Country          as _Country           on  $projection.Country = _Country.Country


  -- Admin data - Created by
  association [0..1] to I_User             as _CreatedByUser     on  $projection.CreatedByUser = _CreatedByUser.UserID

  -- Admin data - Last changed by
  association [0..1] to I_User             as _LastChangedByUser on  $projection.LastChangedByUser = _LastChangedByUser.UserID
 
{
  key uuid                                                             as ChmlCmplncBrnddProdCntryUUID,
      bpn_uuid                                                         as ChmlCmplncBrnddProdNameUUID,
      cci_uuid                                                         as ChmlCmplncInfoUUID,
      
      country                                                          as Country,
      
      @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,

      _BrandedProductName,
      _ChmlCmplncInfo,
      _Country,      
      _CreatedByUser,
      _LastChangedByUser

}

Learn More