I_ChmlCmplncInfoTP

DDL: I_CHMLCMPLNCINFOTP Type: view TRANSACTIONAL Package: EHFND_BO_CCI

Chemical Compliance Info

I_ChmlCmplncInfoTP is a Transactional CDS View that provides data about "Chemical Compliance Info" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 35 fields with key field ChmlCmplncInfoUUID. It has 8 associations to related views. Part of development package EHFND_BO_CCI.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo I_ChmlCmplncInfo from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncProdAssgmtTP _ProductAssignment $projection.ChmlCmplncInfoUUID = _ProductAssignment.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncPrpsAssgmtTP _PurposeAssignment $projection.ChmlCmplncInfoUUID = _PurposeAssignment.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncMktReqTP _MarketRequest $projection.ChmlCmplncInfoUUID = _MarketRequest.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncMktCvrgTP _MarketCoverage $projection.ChmlCmplncInfoUUID = _MarketCoverage.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncMatlAssgmtTP _MaterialAssignment $projection.ChmlCmplncInfoUUID = _MaterialAssignment.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncApplAssgmtTP _Application $projection.ChmlCmplncInfoUUID = _Application.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncSuplrMatlAssgmtTP _SuplrMatlAssignment $projection.ChmlCmplncInfoUUID = _SuplrMatlAssignment.ChmlCmplncInfoUUID
[0..1] I_ChmlCmplncWasteDataTP _WasteData $projection.ChmlCmplncInfoUUID = _WasteData.ChmlCmplncInfoUUID

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName ICCINFOTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeDraftPersistence ehfndw_cci view
ObjectModel.writeActivePersistence ehfndv_cci view
ObjectModel.entityChangeStateId LastChangeUTCDateTime view
ObjectModel.sapObjectNodeType.name ChemicalComplianceInfo view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
EndUserText.label Chemical Compliance Info view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ActiveChmlCmplncInfoUUID ChmlCmplncInfoUUID
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
ProdStewardshipRespUnit ProdStewardshipRespUnit
DngrsGdsRespUnit DngrsGdsRespUnit
ChmlCmplncInfoType ChmlCmplncInfoType
ChmlCmplncInternalName ChmlCmplncInternalName
ChmlCmplncProdCatztnPhrsUUID ChmlCmplncProdCatztnPhrsUUID
MaterialIsBaseProduct MaterialIsBaseProduct
MaterialIsSold MaterialIsSold
MaterialIsTransported MaterialIsTransported
MaterialIsSourced MaterialIsSourced
MaterialIsProduced MaterialIsProduced
MaterialIsDisposed MaterialIsDisposed
MaterialIsEmissionRelevant MaterialIsEmissionRelevant
MatlIsMultiComponentProduct MatlIsMultiComponentProduct
Specification Specification
ChmlCmplncProdIsResearched ChmlCmplncProdIsResearched
SpecificationInternalID SpecificationInternalID
MatlIsNotProdMarketabilityRlvt MatlIsNotProdMarketabilityRlvt
MatlIsNotProdSafetyRlvt MatlIsNotProdSafetyRlvt
_MarketRequest _MarketRequest
_MarketCoverage _MarketCoverage
_MaterialAssignment _MaterialAssignment
_ProductAssignment _ProductAssignment
_PurposeAssignment _PurposeAssignment
_Application _Application
_SuplrMatlAssignment _SuplrMatlAssignment
_WasteData _WasteData
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_RespUnitForDangerousGoods _RespUnitForDangerousGoods
_RespUnitForProductStewardship _RespUnitForProductStewardship
@AbapCatalog:
{
 sqlViewName: 'ICCINFOTP',
 compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #CHECK,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}
--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@ObjectModel:
{
  modelCategory: #BUSINESS_OBJECT,
  compositionRoot: true,
  draftEnabled: true,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: 'EXTERNAL_CALCULATION',
  deleteEnabled: 'EXTERNAL_CALCULATION',
  writeDraftPersistence: 'ehfndw_cci',
  writeActivePersistence: 'ehfndv_cci',
  entityChangeStateId: 'LastChangeUTCDateTime',
  semanticKey:  [ 'ChmlCmplncInfoUUID' ],
  sapObjectNodeType.name: 'ChemicalComplianceInfo',
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  }
}

@EndUserText.label: 'Chemical Compliance Info'
define view I_ChmlCmplncInfoTP
  as select from I_ChmlCmplncInfo

  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  // association returns data only for packaged products; it's the assigned unpackaged product for the packaged product   

  association [0..1] to I_ChmlCmplncProdAssgmtTP      as _ProductAssignment   on $projection.ChmlCmplncInfoUUID = _ProductAssignment.ChmlCmplncInfoUUID
  
  association [0..*] to I_ChmlCmplncPrpsAssgmtTP      as _PurposeAssignment   on $projection.ChmlCmplncInfoUUID = _PurposeAssignment.ChmlCmplncInfoUUID
  association [0..*] to I_ChmlCmplncMktReqTP          as _MarketRequest       on $projection.ChmlCmplncInfoUUID = _MarketRequest.ChmlCmplncInfoUUID
  association [0..*] to I_ChmlCmplncMktCvrgTP         as _MarketCoverage      on $projection.ChmlCmplncInfoUUID = _MarketCoverage.ChmlCmplncInfoUUID
  association [0..*] to I_ChmlCmplncMatlAssgmtTP      as _MaterialAssignment  on $projection.ChmlCmplncInfoUUID = _MaterialAssignment.ChmlCmplncInfoUUID
  association [0..*] to I_ChmlCmplncApplAssgmtTP      as _Application         on $projection.ChmlCmplncInfoUUID = _Application.ChmlCmplncInfoUUID
  //  association [0..*] to I_ChmlCmplncApplicationTP     as _Application               on $projection.ChmlCmplncInfoUUID = _Application.ChmlCmplncInfoUUID

  association [0..*] to I_ChmlCmplncSuplrMatlAssgmtTP as _SuplrMatlAssignment on $projection.ChmlCmplncInfoUUID = _SuplrMatlAssignment.ChmlCmplncInfoUUID
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_ChmlCmplncWasteDataTP       as _WasteData           on $projection.ChmlCmplncInfoUUID = _WasteData.ChmlCmplncInfoUUID
{

      @ObjectModel.mandatory: true
  key ChmlCmplncInfoUUID,
      @ObjectModel.readOnly: true
      ChmlCmplncInfoUUID as ActiveChmlCmplncInfoUUID, --Active UUID of Chemical Compliance Information
      @ObjectModel.readOnly: true
      CreationUTCDateTime,
      @ObjectModel.readOnly: true
      CreatedByUser,
      @ObjectModel.readOnly: true
      LastChangeUTCDateTime,
      @ObjectModel.readOnly: true
      LastChangedByUser,
      @ObjectModel.mandatory: true
      ProdStewardshipRespUnit,
      DngrsGdsRespUnit,
      @ObjectModel.mandatory: true
      ChmlCmplncInfoType,
      @ObjectModel.mandatory: true
      ChmlCmplncInternalName,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      ChmlCmplncProdCatztnPhrsUUID,
      MaterialIsBaseProduct,
      MaterialIsSold,
      MaterialIsTransported,
      MaterialIsSourced,
      MaterialIsProduced,
      MaterialIsDisposed,
      MaterialIsEmissionRelevant,
      MatlIsMultiComponentProduct,

      // @ObjectModel.mandatory: true

      Specification,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      ChmlCmplncProdIsResearched,

      SpecificationInternalID,

      -- indicators to disable essential checks
      MatlIsNotDngrsGdsRlvt,
      MatlIsNotProdMarketabilityRlvt,
      MatlIsNotProdSafetyRlvt,
            
      /* Associations */
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MarketRequest,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MarketCoverage,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MaterialAssignment,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _ProductAssignment,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _PurposeAssignment,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _Application,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]
      _SuplrMatlAssignment,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]
      _WasteData,
      _CreatedByUser,
      _LastChangedByUser,
      _RespUnitForDangerousGoods,
      _RespUnitForProductStewardship
      
}