R_ChmlCmplncMatlAssgmtTP

DDL: R_CHMLCMPLNCMATLASSGMTTP Type: view_entity TRANSACTIONAL

Chemical Compliance Mat Assignment - TP

R_ChmlCmplncMatlAssgmtTP is a Transactional CDS View that provides data about "Chemical Compliance Mat Assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMatlAssgmt) and exposes 10 fields with key field ChmlCmplncMatlAssgmtUUID.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMatlAssgmt I_ChmlCmplncMatlAssgmt from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Chemical Compliance Mat Assignment - 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 (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMatlAssgmtUUID ChmlCmplncMatlAssgmtUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
CreationUTCDateTime CreationUTCDateTime
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
Material Material
MatlAssgmtIsPrimary MatlAssgmtIsPrimary
_ChmlCmplncInfo _ChmlCmplncInfo
_Product _Product 
@AccessControl:
{
  authorizationCheck: #MANDATORY
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Chemical Compliance Mat Assignment - TP'

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

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

  association to parent R_ChemicalComplianceInfoTP as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
{
  key ChmlCmplncMatlAssgmtUUID as ChmlCmplncMatlAssgmtUUID,
      ChmlCmplncInfoUUID       as ChmlCmplncInfoUUID, 
      CreationUTCDateTime      as CreationUTCDateTime,
      CreatedByUser            as CreatedByUser,
      LastChangeUTCDateTime    as LastChangeUTCDateTime,
      LastChangedByUser        as LastChangedByUser,
      
      Material,
      MatlAssgmtIsPrimary,

      /* Associations */
      _ChmlCmplncInfo,
      _Product
}
//where _ChmlCmplncInfo.ChmlCmplncInfoType = 'BU'

Learn More