A_ChangeMasterClassCharc

DDL: A_CHANGEMASTERCLASSCHARC SQL: ANGCCLFN2 Type: view COMPOSITE
9 Fields 1 Data Sources 3 Associations

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.

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 Int class no.
KEY CharcInternalID CharcInternalID Characteristic Internal ID
KeyDate
ClassType ClassType X Flag
CharcMaintAuthGrp
_Valuation _Valuation
_ClassDetails _ClassDetails
_ChangeMaster _ChangeMaster

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_ChangeMasterClassCharc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ANGCCLFN2
-- Parameters: P_KeyDate : sydate

CREATE VIEW A_ChangeMasterClassCharc AS
SELECT
  ClfnObjectID AS ChangeNumber,
  ClassInternalID,
  CharcInternalID,
  $parameters.P_KeyDate AS KeyDate,
  ClassType,
  _Characteristic(P_KeyDate: $parameters.P_KeyDate).CharcMaintAuthGrp AS CharcMaintAuthGrp
FROM I_ClfnObjectCharcForKeyDate
LEFT OUTER JOIN A_ChangeMasterCharcValue AS _Valuation ON ChangeNumber = _Valuation.ChangeNumber AND CharcInternalID = _Valuation.CharcInternalID AND ClassType = _Valuation.ClassType  -- association [0..*]
LEFT OUTER JOIN A_ChangeMasterClass AS _ClassDetails ON ChangeNumber = _ClassDetails.ChangeNumber AND ClassInternalID = _ClassDetails.ClassInternalID  -- association [1..1]
LEFT OUTER JOIN A_ChangeMaster_1 AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [1..1]
;

Learn More