I_MDGovChangeRequestEdition

DDL: I_MDGOVCHANGEREQUESTEDITION SQL: IMDGCREDTN Type: view BASIC

MDG Edition

I_MDGovChangeRequestEdition is a Basic CDS View (Dimension) that provides data about "MDG Edition" in SAP S/4HANA. It reads from 1 data source (usmd020c) and exposes 8 fields with key field MDGovEdition. It has 3 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
usmd020c usmd020c from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MDGovChgReqEditionType _MDGovChgReqEditionType $projection.MDGovEditionType = _MDGovChgReqEditionType.MDGovEditionType
[0..*] I_MDGovChangeRequestEditionTxt _MDGovChangeRequestEditionTxt $projection.MDGovEdition = _MDGovChangeRequestEditionTxt.MDGovEdition
[0..*] I_MDGovChgReqEditionStatusTxt _MDGovChgReqEditionStatusTxt $projection.MDGovEditionStatus = _MDGovChgReqEditionStatusTxt.MDGovEditionStatus

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMDGCREDTN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MDGovEdition view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
EndUserText.label MDG Edition view
Metadata.allowExtensions true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MDGovEdition usmd_edition Edition
MDGovEditionStartDate usmd_vdate_from
MDGovEditionStartPeriod usmd_vper_from
MDGovEditionType usmd_edtn_type
MDGovDataModel _MDGovChgReqEditionType MDGovDataModel
MDGovEditionStatus usmd_edtn_status Edition Status
_MDGovChangeRequestEditionTxt _MDGovChangeRequestEditionTxt
_MDGovChgReqEditionStatusTxt _MDGovChgReqEditionStatusTxt 
@AbapCatalog.sqlViewName: 'IMDGCREDTN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MDGovEdition'
@ObjectModel.usageType: { sizeCategory: #S, dataClass: #CUSTOMIZING, serviceQuality: #C }
@VDM.viewType: #BASIC
@EndUserText.label: 'MDG Edition'
@Metadata.allowExtensions:true
define view I_MDGovChangeRequestEdition
  as select from usmd020c
  
  association [1..1] to I_MDGovChgReqEditionType as _MDGovChgReqEditionType on $projection.MDGovEditionType = _MDGovChgReqEditionType.MDGovEditionType  
  association [0..*] to I_MDGovChangeRequestEditionTxt as _MDGovChangeRequestEditionTxt on $projection.MDGovEdition = _MDGovChangeRequestEditionTxt.MDGovEdition
  association [0..*] to I_MDGovChgReqEditionStatusTxt as _MDGovChgReqEditionStatusTxt on $projection.MDGovEditionStatus = _MDGovChgReqEditionStatusTxt.MDGovEditionStatus

{
      @ObjectModel.text.association: '_MDGovChangeRequestEditionTxt'
      @EndUserText.label: 'Edition'
      @UI.textArrangement: #TEXT_FIRST
      //USMD020C

  key usmd_edition     as MDGovEdition,
      usmd_vdate_from  as MDGovEditionStartDate,
      usmd_vper_from   as MDGovEditionStartPeriod,
      @UI.hidden: true
      usmd_edtn_type   as MDGovEditionType,
      _MDGovChgReqEditionType.MDGovDataModel as MDGovDataModel,
      
      @ObjectModel.text.association: '_MDGovChgReqEditionStatusTxt'
      @EndUserText.label: 'Edition Status'
      @UI.textArrangement: #TEXT_FIRST
      usmd_edtn_status as MDGovEditionStatus,

      _MDGovChangeRequestEditionTxt,
      _MDGovChgReqEditionStatusTxt
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDGOVCHGREQEDITIONTYPE",
"USMD020C"
],
"ASSOCIATED":
[
"I_MDGOVCHANGEREQUESTEDITIONTXT",
"I_MDGOVCHGREQEDITIONSTATUSTXT",
"I_MDGOVCHGREQEDITIONTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More