I_ChmlCmplncWasteDataTP

DDL: I_CHMLCMPLNCWASTEDATATP SQL: ICCWASTEDATATP Type: view TRANSACTIONAL

Chemical Compliance Waste Data - TP

I_ChmlCmplncWasteDataTP is a Transactional CDS View that provides data about "Chemical Compliance Waste Data - TP" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncWasteData) and exposes 5 fields. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncWasteData I_ChmlCmplncWasteData from

Associations (1)

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

Annotations (16)

NameValueLevelField
EndUserText.label Chemical Compliance Waste Data - TP view
AbapCatalog.sqlViewName ICCWASTEDATATP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence EHFNDW_CCW_WDATA view
ObjectModel.writeActivePersistence EHFNDV_CCW_WDATA view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (5)

KeyFieldSource TableSource FieldDescription
CreationUTCDateTime CreationUTCDateTime
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
_ChmlCmplncInfo _ChmlCmplncInfo 
@EndUserText.label: 'Chemical Compliance Waste Data - TP'
@AbapCatalog.sqlViewName: 'ICCWASTEDATATP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL

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

define view I_ChmlCmplncWasteDataTP 
  
  --Select data from basic view of waste characteristic
  as select from I_ChmlCmplncWasteData

  --Nodes/Detaildata
  association [1..1] to I_ChmlCmplncInfoTP as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
{
      --UUID of assignment
  key ChmlCmplncEnvrmtWasteCharcUUID,

      --UUID of chemical compliance info
      @ObjectModel.mandatory: true
      ChmlCmplncInfoUUID,

      @ObjectModel.readOnly: true
      CreationUTCDateTime,
      @ObjectModel.readOnly: true
      CreatedByUser,
      @ObjectModel.readOnly: true
      LastChangeUTCDateTime,
      @ObjectModel.readOnly: true
      LastChangedByUser,

      --Supplier Status per chemical compliance information
      EnvrmtWasteHazardCharcID,

      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _ChmlCmplncInfo
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCWASTEDATA"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFOTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More