C_PlantSubstnCharcValueTP

DDL: C_PLANTSUBSTNCHARCVALUETP Type: view_entity CONSUMPTION Package: ODATA_ATP_OVD_SUBSTN_VAL_MAINT
7 Fields 1 Data Sources 1 Associations 2 OData Services 1 Fiori Apps

Charc Val for Plant Substitution

C_PlantSubstnCharcValueTP is a Consumption CDS View that provides data about "Charc Val for Plant Substitution" in SAP S/4HANA. It reads from 1 data source (R_ObjValDetnCharcValueTP) and exposes 7 fields with key field ObjValDetnCharcValueUUID. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F5302, UI_OVD_SUBSTN_CVC_MNG). It is used in 1 Fiori application: Manage Access Sequences - Substitutions. Part of development package ODATA_ATP_OVD_SUBSTN_VAL_MAINT.

Data Sources (1)

SourceAliasJoin Type
R_ObjValDetnCharcValueTP R_ObjValDetnCharcValueTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_ObjValDetnCharacteristic _Characteristic $projection.ObjValDetnCharacteristicUUID = _Characteristic.ObjValDetnCharacteristicUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Charc Val for Plant Substitution view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5302 ASQL_F5302 C2 NOT_RELEASED
UI_OVD_SUBSTN_CVC_MNG UI_OVD_SUBSTN_CVC_MNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5302 Manage Access Sequences - Substitutions Transactional Manage Access Sequences - Substitutions

Manage Access Sequences - Substitutions

Business Role: Order Fulfillment Manager

Create a combination of characteristics. To create a characteristic combination, you can use the Manage Characteristic Combinations app. If necessary, reorder the characteristics in the combination. Create an access for the characteristic combination created above. To create an access, you can use the Manage Access Sequences - Substitutions app. If necessary, reorder the accesses in a sequence. You can maintain characteristic value combinations for each access, and if necessary specify a control for each characteristic value combination.

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ObjValDetnCharcValueUUID ObjValDetnCharcValueUUID
ObjValDetnCharcValCombnUUID ObjValDetnCharcValCombnUUID CVC UUID
ObjValDetnAccessUUID ObjValDetnAccessUUID Access UUID
ObjValDetnCharacteristicUUID ObjValDetnCharacteristicUUID Characteristic UUID
ObjValDetnOrdinalValue ObjValDetnOrdinalValue Ordinal Number Value
ObjValDetnCharacteristicValue ObjValDetnCharacteristicValue
_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_PlantSubstnCharcValueTP.
-- 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_PlantSubstnCharcValueTP AS
SELECT
  ObjValDetnCharcValueUUID,
  ObjValDetnCharcValCombnUUID,
  ObjValDetnAccessUUID,
  ObjValDetnCharacteristicUUID,
  ObjValDetnOrdinalValue,
  ObjValDetnCharacteristicValue
FROM R_ObjValDetnCharcValueTP
LEFT OUTER JOIN C_ObjValDetnCharacteristic AS _Characteristic ON ObjValDetnCharacteristicUUID = _Characteristic.ObjValDetnCharacteristicUUID  -- association [1..1]
;

Learn More