R_ChmlCmplncSuplrMatlAssgmtTP

DDL: R_CHMLCMPLNCSUPLRMATLASSGMTTP Type: view_entity TRANSACTIONAL Package: EHFND_RAP_CCI

Chemical Cmplnc Supplier Material - TP

R_ChmlCmplncSuplrMatlAssgmtTP is a Transactional CDS View that provides data about "Chemical Cmplnc Supplier Material - TP" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncSuplrMatlAssgmt) and exposes 9 fields. Part of development package EHFND_RAP_CCI.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncSuplrMatlAssgmt I_ChmlCmplncSuplrMatlAssgmt from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Chemical Cmplnc Supplier Material - TP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
UUIDofSupplierMaterialChmlSuplrMatlUUID
CreationUTCDateTime CreationUTCDateTime
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
ChmlSuplrMatlIsOutdated
_ChmlCmplncInfo _ChmlCmplncInfo
_SupplierMaterial _SupplierMaterial
_SupplierStatus _SupplierStatus 
@AccessControl:
{
  authorizationCheck: #MANDATORY,
  // blocking of personal data required because of link to business partner / supplier

  personalData.blocking: #REQUIRED
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Chemical Cmplnc Supplier Material - TP'

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

@VDM: 
{
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL 
}
define view entity R_ChmlCmplncSuplrMatlAssgmtTP 
  as select from I_ChmlCmplncSuplrMatlAssgmt 

  association to parent R_ChemicalComplianceInfoTP as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
{

      --UUID of assignment
  key ChmlCmplncSuplrMatlAssgmtUUID,

      --Active UUID of supplier material assignment
      ChmlCmplncSuplrMatlAssgmtUUID             as ActvChmlCmplncSuplrAssgmtUUID,

      --UUID of chemical compliance info
      ChmlCmplncInfoUUID,

      --UUID of Supplier Material
      ChmlSuplrMatlUUID,

      CreationUTCDateTime,
      CreatedByUser,
      LastChangeUTCDateTime,
      LastChangedByUser,

      --Supplier Status per chemical compliance information
      ChmlSuplrMatlSuplrSts,

      --Supplier Material is outdated
      _SupplierMaterial.ChmlSuplrMatlIsOutdated,

      --Supplier (Business Partner)
      _SupplierMaterial.BusinessPartnerSupplier as BusinessPartnerSupplier,


      /* Associations */
      _ChmlCmplncInfo,
      _SupplierMaterial,
      /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
      _SupplierStatus
  
}

Learn More