R_ChmlCmplncIdfrValNmbrTP

DDL: R_CHMLCMPLNCIDFRVALNMBRTP Type: view_entity TRANSACTIONAL Package: EHFND_RAP_CCIDFR

Chml Compliance Identifier Numbers - TP

R_ChmlCmplncIdfrValNmbrTP is a Transactional CDS View that provides data about "Chml Compliance Identifier Numbers - TP" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncIdfrValue) and exposes 21 fields with key field ChmlCmplncIdfrValueUUID. It has 3 associations to related views. Part of development package EHFND_RAP_CCIDFR.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncIdfrValue I_ChmlCmplncIdfrValue from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_ChmlCmplncIdfrParentTypeTxt _ChmlCmplncIdfrParentTypeTxt $projection.ChmlCmplncIdfrParentType = _ChmlCmplncIdfrParentTypeTxt.ChmlCmplncIdfrParentType
[1..*] I_ChmlCmplncIdfrTypeTxt _ChmlCmplncIdfrTypeTxt $projection.ChmlCmplncIdfrType = _ChmlCmplncIdfrTypeTxt.ChmlCmplncIdfrType
[1..*] I_ProdCmplncLegalAreaText _ProdCmplncLegalAreaText $projection.ProdCmplncLegalArea = _ProdCmplncLegalAreaText.ProdCmplncLegalArea

Annotations (8)

NameValueLevelField
EndUserText.label Chml Compliance Identifier Numbers - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ChemicalComplianceIdentifier view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncIdfrValueUUID ChmlCmplncIdfrValueUUID
ChmlCmplncIdfrUUID ChmlCmplncIdfrUUID
CreationUTCDateTime CreationUTCDateTime
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
ChmlCmplncIdfrParentType ChmlCmplncIdfrParentType
ChmlCmplncIdfrType ChmlCmplncIdfrType
ChmlCmplncIdfrCategory ChmlCmplncIdfrCategory
Language Language
ProdCmplncLegalArea ProdCmplncLegalArea
ChmlCmplncIdfrSequenceNumber ChmlCmplncIdfrSequenceNumber
ChmlCmplncIdfrValue ChmlCmplncIdfrValue
_ChmlCmplncIdfrTP _ChmlCmplncIdfrTP
_ChmlCmplncIdfr _ChmlCmplncIdfr
_ChmlCmplncIdfrParentTypeTxt _ChmlCmplncIdfrParentTypeTxt
_ChmlCmplncIdfrTypeTxt _ChmlCmplncIdfrTypeTxt
_Language _Language
_ProdCmplncLegalAreaText _ProdCmplncLegalAreaText
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@EndUserText.label: 'Chml Compliance Identifier Numbers - TP'

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]

@VDM:{
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@ObjectModel: {
  semanticKey: ['ChmlCmplncIdfrValueUUID'],
  sapObjectNodeType.name: 'ChemicalComplianceIdentifier',
  usageType: {
    serviceQuality: #A,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
  }
}

define view entity R_ChmlCmplncIdfrValNmbrTP
  as select from I_ChmlCmplncIdfrValue
  
  association to parent R_ChmlCmplncIdfrTP as _ChmlCmplncIdfrTP on $projection.ChmlCmplncIdfrUUID = _ChmlCmplncIdfrTP.ChmlCmplncIdfrUUID
  
  // Text Associations

  association [1..*] to I_ChmlCmplncIdfrParentTypeTxt as _ChmlCmplncIdfrParentTypeTxt on $projection.ChmlCmplncIdfrParentType = _ChmlCmplncIdfrParentTypeTxt.ChmlCmplncIdfrParentType
  association [1..*] to I_ChmlCmplncIdfrTypeTxt       as _ChmlCmplncIdfrTypeTxt       on $projection.ChmlCmplncIdfrType       = _ChmlCmplncIdfrTypeTxt.ChmlCmplncIdfrType
  association [1..*] to I_ProdCmplncLegalAreaText     as _ProdCmplncLegalAreaText     on $projection.ProdCmplncLegalArea      = _ProdCmplncLegalAreaText.ProdCmplncLegalArea
{
  key ChmlCmplncIdfrValueUUID,
  
      // Admin fields

      ChmlCmplncIdfrUUID,
      CreationUTCDateTime,
      CreatedByUser,
      LastChangeUTCDateTime,
      LastChangedByUser,
      
      ChmlCmplncIdfrParentType,
      ChmlCmplncIdfrType,
      ChmlCmplncIdfrCategory,
      Language,
      ProdCmplncLegalArea,      
 
      ChmlCmplncIdfrSequenceNumber,
      ChmlCmplncIdfrValue,

      /* Associations */
      _ChmlCmplncIdfrTP,
      _ChmlCmplncIdfr,  // association required for ACL

      
      _ChmlCmplncIdfrParentTypeTxt,
      _ChmlCmplncIdfrTypeTxt,
      _Language, // - Numbers are not language dependent

      _ProdCmplncLegalAreaText,      
      _CreatedByUser,
      _LastChangedByUser

}
where ChmlCmplncIdfrCategory = 'NUM'

Learn More