C_ObjValDetnAltvConfAccessTP

DDL: C_OBJVALDETNALTVCONFACCESSTP Type: view_entity CONSUMPTION
24 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Access for Altv Based Confirmation

C_ObjValDetnAltvConfAccessTP is a Consumption CDS View that provides data about "Access for Altv Based Confirmation" in SAP S/4HANA. It reads from 1 data source (R_ObjValDetnAccessTP) and exposes 24 fields with key field ObjValDetnAccessUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_OVD_ALTV_CTRL_CONFIGURE). It is used in 1 Fiori application: Configure Alternative Control.

Data Sources (1)

SourceAliasJoin Type
R_ObjValDetnAccessTP R_ObjValDetnAccessTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ObjValDetnCharacteristic _Characteristic $projection.ObjValDetnCharcCombinationUUID = _Characteristic.ObjValDetnCharcCombinationUUID

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Access for Altv Based Confirmation view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
UI.headerInfo.typeName Access view
UI.headerInfo.typeNamePlural Accesses view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value ObjValDetnCharcCombinationDesc view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value ObjValDetnCharcCombination view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_OVD_ALTV_CTRL_CONFIGURE UI_OVD_ALTV_CTRL_CONFIGURE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F2698 Configure Alternative Control Transactional With this app, you can set up and adjust alternative controls with which to improve the confirmations for requirements in sales order documents. The alternative controls are defined on the basis of ordered characteristics to which a substitution strategy is assigned.

Configure Alternative Control

Business Role: Order Fulfillment Manager

With this app, you can setup and adjust alternative controls that can be used to improve the confirmations for requirements in sales order documents. This is acheived by activating Alternative-Based Confirmation (ABC) that now provides increased flexibility through sequential accesses. Each accesses has configurable sets of characteristic values.

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY ObjValDetnAccessUUID ObjValDetnAccessUUID Access UUID
ObjValDetnCharcCombinationUUID ObjValDetnCharcCombinationUUID Combination UUID
ObjValDetnCharcCombination _Combination ObjValDetnCharcCombination Combination
ObjValDetnCharcCombinationDesclocalized
ObjValDetnUsage ObjValDetnUsage Usage
ObjValDetnUsageType ObjValDetnUsageType
ObjValDetnAccessSequenceValue ObjValDetnAccessSequenceValue
ObjValDetnActivationStatus ObjValDetnActivationStatus Status
ObjValDetnActivationStatusDesclocalized
ProdAllocCharcCatalogType _Combination ProdAllocCharcCatalogType Catalog Type
ProdAllocCharcCatalogTypeDesclocalized
CreatedByUser CreatedByUser User Name
CreatedByUserFullName _CreatedByUser FullName Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserFullName _LastChangedByUser FullName Name
LastChangeDateTime LastChangeDateTime Timestamp
ObjValDetnAccLastChgDateTime ObjValDetnAccLastChgDateTime
_Combination _Combination
_Usage _Usage
_Status _Status
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Characteristic _Characteristic

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_ObjValDetnAltvConfAccessTP.
-- 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_ObjValDetnAltvConfAccessTP AS
SELECT
  ObjValDetnAccessUUID,
  ObjValDetnCharcCombinationUUID,
  _Combination.ObjValDetnCharcCombination AS ObjValDetnCharcCombination,
  _Combination._Text.ObjValDetnCharcCombinationDesc : localized AS ObjValDetnCharcCombinationDesclocalized,
  ObjValDetnUsage,
  ObjValDetnUsageType,
  ObjValDetnAccessSequenceValue,
  ObjValDetnActivationStatus,
  _Status._Text.ObjValDetnActivationStatusDesc : localized AS ObjValDetnActivationStatusDesclocalized,
  _Combination.ProdAllocCharcCatalogType AS ProdAllocCharcCatalogType,
  _Combination._ProdAllocCharcCatalogType._Text.ProdAllocCharcCatalogTypeDesc : localized AS ProdAllocCharcCatalogTypeDesclocalized,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserFullName,
  CreationDateTime,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserFullName,
  LastChangeDateTime,
  ObjValDetnAccLastChgDateTime
FROM R_ObjValDetnAccessTP
LEFT OUTER JOIN C_ObjValDetnCharacteristic AS _Characteristic ON ObjValDetnCharcCombinationUUID = _Characteristic.ObjValDetnCharcCombinationUUID  -- association [0..*]
;

Learn More