I_AltvBsdCharcValCombnTP

DDL: I_ALTVBSDCHARCVALCOMBNTP SQL: IALTVCTRLCVCTP Type: view TRANSACTIONAL Package: ATP_ABC_ALTERNATIVE_CONTROL
8 Fields 1 Data Sources 2 Associations

Altv Ctrl Charc Value Combination TP

I_AltvBsdCharcValCombnTP is a Transactional CDS View that provides data about "Altv Ctrl Charc Value Combination TP" in SAP S/4HANA. It reads from 1 data source (I_AltvBsdCharcValCombn) and exposes 8 fields with key field AltvBsdConfCharcValCombnUUID. It has 2 associations to related views. Part of development package ATP_ABC_ALTERNATIVE_CONTROL.

Data Sources (1)

SourceAliasJoin Type
I_AltvBsdCharcValCombn I_AltvBsdCharcValCombn from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AltvBsdConfAltvCtrlTP _AltvCtrl _AltvCtrl.AltvBsdConfAlternativeCtrlUUID = $projection.AltvBsdConfAlternativeCtrlUUID
[1..*] I_AltvBsdConfCharcAssgmtTP _CharcAssgmt _CharcAssgmt.ProdAllocCharcCtlgPathUUID = $projection.ProdAllocCharcCtlgPathUUID

Annotations (15)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IALTVCTRLCVCTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Altv Ctrl Charc Value Combination TP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeActivePersistence abcaltcntlcvc view
ObjectModel.writeDraftPersistence abcaltcntlcvc_d view
ObjectModel.representativeKey AltvBsdConfCharcValCombnUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AltvBsdConfCharcValCombnUUID AltvBsdConfCharcValCombnUUID Alternative Control Characteristic Value Combination UUID
AltvBsdConfAlternativeCtrlUUID AltvBsdConfAlternativeCtrlUUID Alternative Control UUID
ProdAllocCharcCtlgPathUUID ProdAllocCharcCtlgPathUUID Product Allocation Characteristic Catalog Path UUID
OrdinalNumberValue OrdinalNumberValue Ordinal Number
AltvBsdConfCharcVal AltvBsdConfCharcVal Alternative-Based Confirmation Characteristic
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
_AltvCtrl _AltvCtrl
_CharcAssgmt _CharcAssgmt

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 I_AltvBsdCharcValCombnTP.
-- 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: IALTVCTRLCVCTP

CREATE VIEW I_AltvBsdCharcValCombnTP AS
SELECT
  AltvBsdConfCharcValCombnUUID,
  AltvBsdConfAlternativeCtrlUUID,
  ProdAllocCharcCtlgPathUUID,
  OrdinalNumberValue,
  AltvBsdConfCharcVal,
  IsMarkedForDeletion
FROM I_AltvBsdCharcValCombn
LEFT OUTER JOIN I_AltvBsdConfAltvCtrlTP AS _AltvCtrl ON _AltvCtrl.AltvBsdConfAlternativeCtrlUUID = AltvBsdConfAlternativeCtrlUUID  -- association [1..1]
LEFT OUTER JOIN I_AltvBsdConfCharcAssgmtTP AS _CharcAssgmt ON _CharcAssgmt.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID  -- association [1..*]
;

Learn More