I_ChmlCmplncReqNewCmplncInfoTP

DDL: I_CHMLCMPLNCREQNEWCMPLNCINFOTP Type: view TRANSACTIONAL

Chemical Compliance Request New Chemical Compliance Info

I_ChmlCmplncReqNewCmplncInfoTP is a Transactional CDS View that provides data about "Chemical Compliance Request New Chemical Compliance Info" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncReqNewCmplncInfo) and exposes 20 fields with key field ChmlCmplncReqNewCmplncInfoUUID. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncReqNewCmplncInfo I_ChmlCmplncReqNewCmplncInfo from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChmlCmplncReqTP _ChmlCmplncReq $projection.ChmlCmplncRequestUUID = _ChmlCmplncReq.ChmlCmplncRequestUUID

Annotations (16)

NameValueLevelField
EndUserText.label Chemical Compliance Request New Chemical Compliance Info view
AbapCatalog.sqlViewName ICRQNCCITP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeActivePersistence ehfndv_crq_ncci view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncReqNewCmplncInfoUUID ChmlCmplncReqNewCmplncInfoUUID
ChmlCmplncRequestUUID ChmlCmplncRequestUUID
CreatedByUser CreatedByUser
CreationUTCDateTime CreationUTCDateTime
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
ChmlCmplncInfoType ChmlCmplncInfoType
ChmlCmplncProdUUID ChmlCmplncProdUUID
ProdStewardshipRespUnit ProdStewardshipRespUnit
DngrsGdsRespUnit DngrsGdsRespUnit
ChmlCmplncInternalName ChmlCmplncInternalName
ChmlCmplncProdIsResearched ChmlCmplncProdIsResearched
MaterialIsSold MaterialIsSold
MaterialIsTransported MaterialIsTransported
MaterialIsSourced MaterialIsSourced
MaterialIsProduced MaterialIsProduced
ChmlCmplncProdCatztnPhrsUUID ChmlCmplncProdCatztnPhrsUUID
_ChmlCmplncReq _ChmlCmplncReq
_RespUnitForProductStewardship _RespUnitForProductStewardship
_RespUnitForDangerousGoods _RespUnitForDangerousGoods 
@EndUserText.label: 'Chemical Compliance Request New Chemical Compliance Info'

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

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

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

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@ObjectModel:
{
  modelCategory: #BUSINESS_OBJECT,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  writeActivePersistence: 'ehfndv_crq_ncci',
  semanticKey:  [ 'ChmlCmplncReqNewCmplncInfoUUID' ],
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  }
}
define view I_ChmlCmplncReqNewCmplncInfoTP
  as select from I_ChmlCmplncReqNewCmplncInfo
  association [1..1] to I_ChmlCmplncReqTP as _ChmlCmplncReq on $projection.ChmlCmplncRequestUUID = _ChmlCmplncReq.ChmlCmplncRequestUUID
{
  key ChmlCmplncReqNewCmplncInfoUUID as ChmlCmplncReqNewCmplncInfoUUID,

      @ObjectModel.mandatory: true
      ChmlCmplncRequestUUID,
      CreatedByUser,
      CreationUTCDateTime,
      LastChangeUTCDateTime,
      LastChangedByUser,

      ChmlCmplncInfoType             as ChmlCmplncInfoType,

      ChmlCmplncProdUUID             as ChmlCmplncProdUUID,

      @ObjectModel.mandatory: true
      ProdStewardshipRespUnit        as ProdStewardshipRespUnit,
      DngrsGdsRespUnit,

      @ObjectModel.mandatory: true
      ChmlCmplncInternalName         as ChmlCmplncInternalName,
      ChmlCmplncProdIsResearched     as ChmlCmplncProdIsResearched,

      MaterialIsSold,
      MaterialIsTransported,
      MaterialIsSourced,
      MaterialIsProduced,

      ChmlCmplncProdCatztnPhrsUUID   as ChmlCmplncProdCatztnPhrsUUID,

      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _ChmlCmplncReq,
      _RespUnitForProductStewardship,
      _RespUnitForDangerousGoods
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCREQNEWCMPLNCINFO"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCREQTP",
"I_RESPONSIBLEUNIT"
],
"BASE":
[
"I_CHMLCMPLNCREQNEWCMPLNCINFO"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More