C_AltvBsdConfCharcValCombnTP

DDL: C_ALTVBSDCONFCHARCVALCOMBNTP SQL: CALTVCTRLCVTP Type: view CONSUMPTION
9 Fields 1 Data Sources 3 Associations

ABC Alternative Control Charc Value Combination TP

C_AltvBsdConfCharcValCombnTP is a Consumption CDS View that provides data about "ABC Alternative Control Charc Value Combination TP" in SAP S/4HANA. It reads from 1 data source (I_AltvBsdConfCharcValCombnTP) and exposes 9 fields with key field AltvBsdConfCharcValCombnUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AltvBsdConfCharcValCombnTP I_AltvBsdConfCharcValCombnTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_AltvBsdConfAltvCtrlGroupTP _AltvCtrlGroup _AltvCtrlGroup.AltvBsdConfAltvCtrlGroupUUID = $projection.AltvBsdConfAltvCtrlGroupUUID
[1..1] C_AltvBsdConfAlternativeCtrlTP _AltvCtrl _AltvCtrl.AltvBsdConfAlternativeCtrlUUID = $projection.AltvBsdConfAlternativeCtrlUUID
[1..*] C_AltvBsdConfCharcAssignmentTP _CharcAssignment _CharcAssignment.ProdAllocCharcCtlgPathUUID = $projection.ProdAllocCharcCtlgPathUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CALTVCTRLCVTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey AltvBsdConfCharcValCombnUUID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label ABC Alternative Control Charc Value Combination TP view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AltvBsdConfCharcValCombnUUID AltvBsdConfCharcValCombnUUID Alternative Control Characteristic Value Combination UUID
AltvBsdConfAltvCtrlGroupUUID AltvBsdConfAltvCtrlGroupUUID Alternative Control UUID
AltvBsdConfAlternativeCtrlUUID AltvBsdConfAlternativeCtrlUUID Alternative Control UUID
ProdAllocCharcCtlgPathUUID ProdAllocCharcCtlgPathUUID Product Allocation Characteristic Catalog Path UUID
OrdinalNumberValue OrdinalNumberValue Ordinal Number
AltvBsdConfCharcVal AltvBsdConfCharcVal Alternative-Based Confirmation Characteristic
_AltvCtrl _AltvCtrl
_AltvCtrlGroup _AltvCtrlGroup
_CharcAssignment _CharcAssignment

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 C_AltvBsdConfCharcValCombnTP.
-- 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: CALTVCTRLCVTP

CREATE VIEW C_AltvBsdConfCharcValCombnTP AS
SELECT
  AltvBsdConfCharcValCombnUUID,
  AltvBsdConfAltvCtrlGroupUUID,
  AltvBsdConfAlternativeCtrlUUID,
  ProdAllocCharcCtlgPathUUID,
  OrdinalNumberValue,
  AltvBsdConfCharcVal
FROM I_AltvBsdConfCharcValCombnTP
LEFT OUTER JOIN C_AltvBsdConfAltvCtrlGroupTP AS _AltvCtrlGroup ON _AltvCtrlGroup.AltvBsdConfAltvCtrlGroupUUID = AltvBsdConfAltvCtrlGroupUUID  -- association [1..1]
LEFT OUTER JOIN C_AltvBsdConfAlternativeCtrlTP AS _AltvCtrl ON _AltvCtrl.AltvBsdConfAlternativeCtrlUUID = AltvBsdConfAlternativeCtrlUUID  -- association [1..1]
LEFT OUTER JOIN C_AltvBsdConfCharcAssignmentTP AS _CharcAssignment ON _CharcAssignment.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID  -- association [1..*]
;

Learn More