I_ChmlCmplncMktCvrgTP

DDL: I_CHMLCMPLNCMKTCVRGTP Type: view TRANSACTIONAL

Chemical Compliance Market Coverage

I_ChmlCmplncMktCvrgTP is a Transactional CDS View that provides data about "Chemical Compliance Market Coverage" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMktCvrg) and exposes 18 fields with key field ChmlCmplncMktCvrgUUID. It has 1 association to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMktCvrg I_ChmlCmplncMktCvrg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChmlCmplncInfoTP _ChmlCmplncInfo _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (16)

NameValueLevelField
EndUserText.label Chemical Compliance Market Coverage view
AbapCatalog.sqlViewName ICCMKTCOVTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeDraftPersistence ehfndw_cci_mcvrg view
ObjectModel.writeActivePersistence ehfndv_cci_mcvrg view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMktCvrgUUID ChmlCmplncMktCvrgUUID
ActiveChmlCmplncMktCvrgUUID ChmlCmplncMktCvrgUUID
ActiveUUIDofCoverageChmlCmplncInfoUUID
ActiveChmlCmplncInfoUUID ChmlCmplncInfoUUID
CreationUTCDateTime CreationUTCDateTime
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
Country Country
ChmlCmplncProdnAllwd ChmlCmplncProdnAllwd
ChmlCmplncExprtAllwd ChmlCmplncExprtAllwd
ChmlCmplncImprtAllwd ChmlCmplncImprtAllwd
ChmlCmplncSalesAllwd ChmlCmplncSalesAllwd
ChmlCmplncMktCvrgRemark ChmlCmplncMktCvrgRemark
_ChmlCmplncInfo _ChmlCmplncInfo
_Country _Country
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@EndUserText.label: 'Chemical Compliance Market Coverage'

@AbapCatalog:
{
  sqlViewName: 'ICCMKTCOVTP',
  compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #CHECK,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL

@ObjectModel:
{
  modelCategory: #BUSINESS_OBJECT,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: 'EXTERNAL_CALCULATION',
  writeDraftPersistence: 'ehfndw_cci_mcvrg',
  writeActivePersistence: 'ehfndv_cci_mcvrg',
  semanticKey:  [ 'ChmlCmplncMktCvrgUUID' ],
  
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  }
}

define view I_ChmlCmplncMktCvrgTP
 as select from I_ChmlCmplncMktCvrg
  association [1..1] to I_ChmlCmplncInfoTP as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
  
{
  key ChmlCmplncMktCvrgUUID,
  @ObjectModel.readOnly: true
  ChmlCmplncMktCvrgUUID as ActiveChmlCmplncMktCvrgUUID, --Active UUID of Coverage
  @ObjectModel.mandatory: true
  ChmlCmplncInfoUUID, 
  ChmlCmplncInfoUUID as ActiveChmlCmplncInfoUUID, --Active UUID of Chemical Compliance Information
  ChmlCmplncMktReqUUID,  
  CreationUTCDateTime, 
  CreatedByUser, 
  LastChangeUTCDateTime, 
  LastChangedByUser,
  @ObjectModel.mandatory: true
  Country, 
  ChmlCmplncProdnAllwd,
  ChmlCmplncExprtAllwd,
  ChmlCmplncImprtAllwd,
  ChmlCmplncSalesAllwd,    
  ChmlCmplncMktCvrgRemark,
  
  /* Associations */
  @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
  _ChmlCmplncInfo, 
  
  _Country, 
  _CreatedByUser, 
  _LastChangedByUser
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCMKTCVRG"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFOTP",
"I_COUNTRY",
"I_USER"
],
"BASE":
[
"I_CHMLCMPLNCMKTCVRG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More