C_AltvBsdConfAltvCtrlTP

DDL: C_ALTVBSDCONFALTVCTRLTP Type: view_entity CONSUMPTION Package: ATP_ABC_ALTERNATIVE_CONTROL
15 Fields 1 Data Sources 5 Associations

Altv Control Transactional Processing

C_AltvBsdConfAltvCtrlTP is a Consumption CDS View that provides data about "Altv Control Transactional Processing" in SAP S/4HANA. It reads from 1 data source (I_AltvBsdConfAltvCtrlTP) and exposes 15 fields with key field AltvBsdConfAlternativeCtrlUUID. It has 5 associations to related views. Part of development package ATP_ABC_ALTERNATIVE_CONTROL.

Data Sources (1)

SourceAliasJoin Type
I_AltvBsdConfAltvCtrlTP I_AltvBsdConfAltvCtrlTP from

Associations (5)

CardinalityTargetAliasCondition
[1..*] C_AltvBsdCharcValCombnTP _AltvBsdCharcValCombn _AltvBsdCharcValCombn.AltvBsdConfAlternativeCtrlUUID = $projection.AltvBsdConfAlternativeCtrlUUID
[0..1] C_AltvBsdConfSubstnStrgyTP _AltvBsdSubstnStrgy _AltvBsdSubstnStrgy.AltvBsdConfSubstnStrgyUUID = $projection.AltvBsdConfSubstnStrgyUUID
[0..1] C_AltvBsdConfSubstnStrgyVH _AltvBsdSubstnStrgyVH _AltvBsdSubstnStrgyVH.AltvBsdConfSubstnStrgyUUID = $projection.AltvBsdConfSubstnStrgyUUID
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.CreatedByUser
[0..1] I_User _LastChangedByUser _LastChangedByUser.UserID = $projection.LastChangedByUser

Annotations (16)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Altv Control Transactional Processing view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey AltvBsdConfAlternativeCtrlUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Analytics.technicalName CALTVCTRLTP view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY AltvBsdConfAlternativeCtrlUUID AltvBsdConfAlternativeCtrlUUID Alternative Control UUID
ATPRelevantDocumentClass ATPRelevantDocumentClass Document Class
AltvBsdConfSubstnStrgyUUID AltvBsdConfSubstnStrgyUUID Substitution Strategy UUID
AlternativeControlIsActive AlternativeControlIsActive Is Active
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
BusPrpsOfRefdValueIsCompleted BusPrpsOfRefdValueIsCompleted Purpose Completed
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_AltvBsdCharcValCombn _AltvBsdCharcValCombn
_AltvBsdSubstnStrgyVH _AltvBsdSubstnStrgyVH
_AltvBsdSubstnStrgy _AltvBsdSubstnStrgy
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_AltvBsdConfAltvCtrlTP.
-- 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.

CREATE VIEW C_AltvBsdConfAltvCtrlTP AS
SELECT
  AltvBsdConfAlternativeCtrlUUID,
  ATPRelevantDocumentClass,
  AltvBsdConfSubstnStrgyUUID,
  AlternativeControlIsActive,
  IsMarkedForDeletion,
  BusPrpsOfRefdValueIsCompleted,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_AltvBsdConfAltvCtrlTP
LEFT OUTER JOIN C_AltvBsdCharcValCombnTP AS _AltvBsdCharcValCombn ON _AltvBsdCharcValCombn.AltvBsdConfAlternativeCtrlUUID = AltvBsdConfAlternativeCtrlUUID  -- association [1..*]
LEFT OUTER JOIN C_AltvBsdConfSubstnStrgyTP AS _AltvBsdSubstnStrgy ON _AltvBsdSubstnStrgy.AltvBsdConfSubstnStrgyUUID = AltvBsdConfSubstnStrgyUUID  -- association [0..1]
LEFT OUTER JOIN C_AltvBsdConfSubstnStrgyVH AS _AltvBsdSubstnStrgyVH ON _AltvBsdSubstnStrgyVH.AltvBsdConfSubstnStrgyUUID = AltvBsdConfSubstnStrgyUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
;

Learn More