R_DngrsGdsBasicClassfctnTextTP

DDL: R_DNGRSGDSBASICCLASSFCTNTEXTTP Type: view_entity TRANSACTIONAL Package: EHDGM_RAP_BASIC_CLASSIFICATION

DG Basic Classification - Text TP

R_DngrsGdsBasicClassfctnTextTP is a Transactional CDS View that provides data about "DG Basic Classification - Text TP" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltDngrsGdsBscDescT) and exposes 12 fields with key fields CmplRqRsltUUID, Language. It has 1 association to related views. Part of development package EHDGM_RAP_BASIC_CLASSIFICATION.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltDngrsGdsBscDescT DngrsGdsBscClassfctnText from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_DngrsGdsBasicClassfctnDetTP _Details $projection.CmplRqRsltUUID = _Details.CmplRqRsltUUID

Annotations (11)

NameValueLevelField
EndUserText.label DG Basic Classification - Text TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.sapObjectNodeType.name DngrsGdsBscClassfctnText view
ObjectModel.representativeKey CmplRqRsltUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID I_CmplRqRsltDngrsGdsBscDescT CmplRqRsltUUID
KEY Language I_CmplRqRsltDngrsGdsBscDescT Language
CreationDateTime I_CmplRqRsltDngrsGdsBscDescT CreationDateTime
CreatedByUser I_CmplRqRsltDngrsGdsBscDescT CreatedByUser
LastChangeDateTime I_CmplRqRsltDngrsGdsBscDescT LastChangeDateTime
LastChangedByUser I_CmplRqRsltDngrsGdsBscDescT LastChangedByUser
DangerousGoodBasicDescription I_CmplRqRsltDngrsGdsBscDescT DangerousGoodBasicDescription
CmplRqRsltProcessingStatus _DngrsGoodsBasicClassification CmplRqRsltProcessingStatus
CmplRqVersIsLatest _DngrsGoodsBasicClassification CmplRqVersIsLatest
_Details _Details
_Language _Language
_DngrsGoodsBasicClassification _DngrsGoodsBasicClassification 
@EndUserText.label: 'DG Basic Classification - Text TP'
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:
{
  dataCategory: #TEXT,
  sapObjectNodeType.name: 'DngrsGdsBscClassfctnText',
  semanticKey:  [ 'Language' ],
  representativeKey:  'CmplRqRsltUUID',
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L, // <10.000.000

    serviceQuality: #C // <= 15 msec

  }
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view entity R_DngrsGdsBasicClassfctnTextTP
  as select from I_CmplRqRsltDngrsGdsBscDescT as DngrsGdsBscClassfctnText
  association to parent R_DngrsGdsBasicClassfctnTP as _DngrsGoodsBasicClassification on $projection.CmplRqRsltUUID = _DngrsGoodsBasicClassification.CmplRqRsltUUID
  association [0..1] to R_DngrsGdsBasicClassfctnDetTP as _Details on $projection.CmplRqRsltUUID = _Details.CmplRqRsltUUID
{
  key DngrsGdsBscClassfctnText.CmplRqRsltUUID,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key DngrsGdsBscClassfctnText.Language,

      @Semantics.systemDateTime.createdAt: true
      DngrsGdsBscClassfctnText.CreationDateTime,
      @Semantics.user.createdBy: true
      DngrsGdsBscClassfctnText.CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      DngrsGdsBscClassfctnText.LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      DngrsGdsBscClassfctnText.LastChangedByUser,

      @Semantics.text: true
      DngrsGdsBscClassfctnText.DangerousGoodBasicDescription,

      _DngrsGoodsBasicClassification.CmplRqRsltProcessingStatus,
      _DngrsGoodsBasicClassification.CmplRqVersIsLatest,

      _Details,
      _Language,
      _DngrsGoodsBasicClassification
} where _DngrsGoodsBasicClassification.CmplRqRsltUUID is not null // only select Texts for Basic Classifcations

Learn More