A_ChangeMasterClassCharc

DDL: A_CHANGEMASTERCLASSCHARC SQL: ANGCCLFN2 Type: view COMPOSITE

Change Number Class and Characteristic Assignments

A_ChangeMasterClassCharc is a Composite CDS View that provides data about "Change Number Class and Characteristic Assignments" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcForKeyDate) and exposes 9 fields with key fields ChangeNumber, ClassInternalID, CharcInternalID. It has 3 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcForKeyDate I_ClfnObjectCharcForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (3)

CardinalityTargetAliasCondition
[0..*] A_ChangeMasterCharcValue _Valuation $projection.ChangeNumber = _Valuation.ChangeNumber and $projection.CharcInternalID = _Valuation.CharcInternalID and $projection.ClassType = _Valuation.ClassType
[1..1] A_ChangeMasterClass _ClassDetails $projection.ChangeNumber = _ClassDetails.ChangeNumber and $projection.ClassInternalID = _ClassDetails.ClassInternalID
[1..1] A_ChangeMaster_1 _ChangeMaster $projection.ChangeNumber = _ChangeMaster.ChangeNumber

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ANGCCLFN2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Consumption.filter.businessDate.at true view
EndUserText.label Change Number Class and Characteristic Assignments view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber ClfnObjectID
KEY ClassInternalID ClassInternalID
KEY CharcInternalID CharcInternalID
KeyDate
ClassType ClassType
CharcMaintAuthGrp
_Valuation _Valuation
_ClassDetails _ClassDetails
_ChangeMaster _ChangeMaster 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ANGCCLFN2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Change Number Class and Characteristic Assignments'
define view A_ChangeMasterClassCharc 
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate:sydate
  as select from I_ClfnObjectCharcForKeyDate(P_KeyDate: $parameters.P_KeyDate) as Characteristics 
    association [0..*] to A_ChangeMasterCharcValue as _Valuation on
      $projection.ChangeNumber = _Valuation.ChangeNumber and
      $projection.CharcInternalID = _Valuation.CharcInternalID and
      $projection.ClassType = _Valuation.ClassType
    association [1..1] to A_ChangeMasterClass as _ClassDetails on
      $projection.ChangeNumber = _ClassDetails.ChangeNumber and
      $projection.ClassInternalID = _ClassDetails.ClassInternalID 
    association [1..1] to A_ChangeMaster_1 as _ChangeMaster on
      $projection.ChangeNumber = _ChangeMaster.ChangeNumber      
  {
    key ClfnObjectID as ChangeNumber,
    key ClassInternalID,
    key CharcInternalID,
    
    $parameters.P_KeyDate as KeyDate,
    ClassType,
    @Consumption.hidden: true
    _Characteristic(P_KeyDate: $parameters.P_KeyDate).CharcMaintAuthGrp,
    
    _Valuation,
    _ClassDetails,
    _ChangeMaster
  }
    where
      ClfnObjectTable = 'AENR' and
      ClfnObjectType = 'O'

Learn More