I_CmplRqRsltWasteCodeTP

DDL: I_CMPLRQRSLTWASTECODETP SQL: ICRRWSTCDTP Type: view TRANSACTIONAL

Waste Code - TP

I_CmplRqRsltWasteCodeTP is a Transactional CDS View that provides data about "Waste Code - TP" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 31 fields with key field CmplRqRsltUUID. It has 4 associations to related views.

1 data source(s) 31 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_CmplRqRsltWasteCodeClfnTP _CmplRqRsltWasteCodeClfn $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeClfn.CmplRqRsltUUID
[0..*] I_CmplRqRsltWasteCodeCatTP _CmplRqRsltWasteCodeCat $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeCat.CmplRqRsltUUID
[0..*] I_CmplRqRsltWstCdAddlStmntTP _CmplRqRsltWasteCodeAddl $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeAddl.CmplRqRsltUUID
[0..1] I_CmplRqRsltWasteCodeNoteTP _CmplRqRsltWasteCodeNote $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeNote.PCPrptyRootUUID

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName ICRRWSTCDTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeDraftPersistence ehfndw_crr_wst view
ObjectModel.writeActivePersistence ehfndv_crr2 view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.sapObjectNodeType.name WasteCodesAssessment view
EndUserText.label Waste Code - TP view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID CmplRqRsltUUID
ActiveCmplRqRsltUUID
ActiveUUIDofCRRCmplRqVersUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
SubstanceUUID SubstanceUUID
ChmlSuplrMatlUUID ChmlSuplrMatlUUID
ComplianceRequirement ComplianceRequirement
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
CmplRqRsltProcessingStatus CmplRqRsltProcessingStatus
CmplRqRsltProcessor Processor
ReleasedByUser ReleasedByUser
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
CmplRqRsltReldCmplncSts CmplRqRsltReldCmplncSts
CmplRqRsltCalculatedStatus CmplRqRsltCalculatedStatus
CmplRqRsltManualStatus CmplRqRsltManualStatus
CmplRqRsltStatusRemark CmplRqRsltStatusRemark
ChmlCompositionType ChmlCompositionType
MaterialIsSold MaterialIsSold
MaterialIsTransported MaterialIsTransported
MaterialIsSourced MaterialIsSourced
MaterialIsProduced MaterialIsProduced
_ChmlCmplncInfo _ChmlCmplncInfo
_CmplRqVers _CmplRqVers
_CmplRqRsltWasteCodeClfn _CmplRqRsltWasteCodeClfn
_CmplRqRsltWasteCodeCat _CmplRqRsltWasteCodeCat
_CmplRqRsltWasteCodeAddl _CmplRqRsltWasteCodeAddl
_CmplRqRsltWasteCodeNote _CmplRqRsltWasteCodeNote 
@AbapCatalog.sqlViewName: 'ICRRWSTCDTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl:{
    authorizationCheck: #CHECK,
    privilegedAssociations: ['_CmplRqRsltWasteCodeNote']
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  modelCategory: #BUSINESS_OBJECT,
  compositionRoot: true,
  draftEnabled: true,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: 'EXTERNAL_CALCULATION',
  writeDraftPersistence: 'ehfndw_crr_wst',
  writeActivePersistence: 'ehfndv_crr2',
  entityChangeStateId: 'LastChangeDateTime',
  semanticKey:  [ 'CmplRqRsltUUID' ],

  usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #XL,
    serviceQuality: #C
  },
  sapObjectNodeType.name: 'WasteCodesAssessment'
}

@EndUserText.label: 'Waste Code - TP'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view I_CmplRqRsltWasteCodeTP
  as select from I_CmplRqRslt

  association [0..*] to I_CmplRqRsltWasteCodeClfnTP  as _CmplRqRsltWasteCodeClfn on $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeClfn.CmplRqRsltUUID
  association [0..*] to I_CmplRqRsltWasteCodeCatTP   as _CmplRqRsltWasteCodeCat  on $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeCat.CmplRqRsltUUID
  association [0..*] to I_CmplRqRsltWstCdAddlStmntTP as _CmplRqRsltWasteCodeAddl on $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeAddl.CmplRqRsltUUID
  association [0..1] to I_CmplRqRsltWasteCodeNoteTP  as _CmplRqRsltWasteCodeNote on $projection.CmplRqRsltUUID = _CmplRqRsltWasteCodeNote.PCPrptyRootUUID

{
  key CmplRqRsltUUID,
         @ObjectModel.readOnly: true
      cast(CmplRqRsltUUID as ehfnd_crr_active_uuid preserving type ) as ActiveCmplRqRsltUUID, --Active UUID of CRR
     CmplRqVersUUID,
      ChmlCmplncInfoUUID,
      SubstanceUUID,
      ChmlSuplrMatlUUID,
      ComplianceRequirement,
      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangedByUser,
      CmplRqRsltProcessingStatus,
      Processor  as CmplRqRsltProcessor,
 
      ReleasedByUser,
      ValidityStartDateTime,
      ValidityEndDateTime,
      CmplRqRsltReldCmplncSts,
      CmplRqRsltCalculatedStatus,
      CmplRqRsltManualStatus,
      CmplRqRsltStatusRemark,
      ChmlCompositionType,
      MaterialIsSold,
      MaterialIsTransported,
      MaterialIsSourced,
      MaterialIsProduced,

      /**** Associations ****/
      _ChmlCmplncInfo,
      _CmplRqVers,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltWasteCodeClfn,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltWasteCodeCat,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltWasteCodeAddl,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltWasteCodeNote
}
where
  _CmplRqVers.CmplRqPattern = 'CompliancePatternWasteCode';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT",
"I_CMPLRQVERSENHANCED"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_CMPLRQRSLTWASTECODECATTP",
"I_CMPLRQRSLTWASTECODECLFNTP",
"I_CMPLRQRSLTWASTECODENOTETP",
"I_CMPLRQRSLTWSTCDADDLSTMNTTP",
"I_CMPLRQVERSENHANCED"
],
"BASE":
[
"I_CMPLRQRSLT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More