A_UtilsProdSlsScenCharc

DDL: A_UTILSPRODSLSSCENCHARC Type: view_entity CONSUMPTION
54 Fields 2 Data Sources 2 Associations

Utils Prod Sales Scenario Characteristic

A_UtilsProdSlsScenCharc is a Consumption CDS View that provides data about "Utils Prod Sales Scenario Characteristic" in SAP S/4HANA. It reads from 2 data sources (I_ClfnCharacteristic, I_UtilsProdSlsScenCharc) and exposes 54 fields with key fields UtilitiesProductSalesScenario, Characteristic, ValidityEndDate. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ClfnCharacteristic _Characteristic inner
I_UtilsProdSlsScenCharc ScenarioCharacteristic from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_UtilsProdSlsScenCharcT _CharacteristicDesc $projection.CharcInternalID = _CharacteristicDesc.CharcInternalID
[0..*] A_UtilsProdSlsScenCharcVal _CharacteristicValue $projection.CharcInternalID = _CharacteristicValue.CharcInternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utils Prod Sales Scenario Characteristic view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name UtilsProdSlsScenCharacteristic_Type view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProductSalesScenario I_UtilsProdSlsScenCharc UtilitiesProductSalesScenario VAT Scenario
KEY Characteristic I_UtilsProdSlsScenCharc Characteristic Field Name
KEY ValidityEndDate I_ClfnCharacteristic ValidityEndDate ValidTo
ValidityStartDate I_ClfnCharacteristic ValidityStartDate Validity Start Date
UtilsProdSlsScenCharcUsageKind I_UtilsProdSlsScenCharc UtilsProdSlsScenCharcUsageKind Usage Kind
UtilsProdSlsScenScreenSequence I_UtilsProdSlsScenCharc UtilsProdSlsScenScreenSequence Visit Sequence
UtilsProductSalesScenarioStep1 I_UtilsProdSlsScenCharc UtilsProductSalesScenarioStep1 Step 1
UtilsProductSalesScenarioStep2 I_UtilsProdSlsScenCharc UtilsProductSalesScenarioStep2 Step 2
UtilsProductSalesScenarioStep3 I_UtilsProdSlsScenCharc UtilsProductSalesScenarioStep3 Step 3
UtilsProductSalesScenarioStep4 I_UtilsProdSlsScenCharc UtilsProductSalesScenarioStep4 Step 4
UtilsProdSlsScenCharcSemantic I_UtilsProdSlsScenCharc UtilsProdSlsScenCharcSemantic
CharcInternalID I_ClfnCharacteristic CharcInternalID Characteristic Internal ID
CharcStatus I_ClfnCharacteristic CharcStatus Status
CharcDataType I_ClfnCharacteristic CharcDataType Format
CharcLength I_ClfnCharacteristic CharcLength Number of Chars
CharcDecimals I_ClfnCharacteristic CharcDecimals Decimal Places
CharcTemplate I_ClfnCharacteristic CharcTemplate
ValueIsCaseSensitive I_ClfnCharacteristic ValueIsCaseSensitive
CharcConversionRoutine I_ClfnCharacteristic CharcConversionRoutine
CharcGroup I_ClfnCharacteristic CharcGroup
EntryIsRequired I_ClfnCharacteristic EntryIsRequired
MultipleValuesAreAllowed I_ClfnCharacteristic MultipleValuesAreAllowed
CharcValueUnit I_ClfnCharacteristic CharcValueUnit Internal UoM
Currency I_ClfnCharacteristic Currency Valuation Crcy
CharcExponentValue I_ClfnCharacteristic CharcExponentValue
ValueIntervalIsAllowed I_ClfnCharacteristic ValueIntervalIsAllowed
AdditionalValueIsAllowed I_ClfnCharacteristic AdditionalValueIsAllowed
NegativeValueIsAllowed I_ClfnCharacteristic NegativeValueIsAllowed
ChangeNumber I_ClfnCharacteristic ChangeNumber Change Number
DocumentInfoRecordDocType I_ClfnCharacteristic DocumentInfoRecordDocType Document Type
DocumentInfoRecordDocNumber I_ClfnCharacteristic DocumentInfoRecordDocNumber Document
DocumentInfoRecordDocVersion I_ClfnCharacteristic DocumentInfoRecordDocVersion Doc. Version
DocumentInfoRecordDocPart I_ClfnCharacteristic DocumentInfoRecordDocPart Document Part
CharcMaintAuthGrp I_ClfnCharacteristic CharcMaintAuthGrp
CharcIsReadOnly I_ClfnCharacteristic CharcIsReadOnly
CharcIsHidden I_ClfnCharacteristic CharcIsHidden
CharcIsRestrictable I_ClfnCharacteristic CharcIsRestrictable
CharcReferenceTable I_ClfnCharacteristic CharcReferenceTable
CharcReferenceTableField I_ClfnCharacteristic CharcReferenceTableField
CharcCheckTable I_ClfnCharacteristic CharcCheckTable
CharcCheckFunctionModule I_ClfnCharacteristic CharcCheckFunctionModule
CharcExponentFormat I_ClfnCharacteristic CharcExponentFormat
CharcEntryIsNotFormatCtrld I_ClfnCharacteristic CharcEntryIsNotFormatCtrld
CharcTemplateIsDisplayed I_ClfnCharacteristic CharcTemplateIsDisplayed
CharcSelectedSet I_ClfnCharacteristic CharcSelectedSet
Plant I_ClfnCharacteristic Plant Valuation Area
CharcCatalogType I_ClfnCharacteristic CharcCatalogType
CreatedByUser I_ClfnCharacteristic CreatedByUser User Name
CreationDate I_ClfnCharacteristic CreationDate Time Stamp
LastChangedByUser I_ClfnCharacteristic LastChangedByUser User Name
LastChangeDate I_ClfnCharacteristic LastChangeDate Time Stamp
CharcLastChangedDateTime I_ClfnCharacteristic CharcLastChangedDateTime
_CharacteristicDesc _CharacteristicDesc
_CharacteristicValue _CharacteristicValue

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 A_UtilsProdSlsScenCharc.
-- 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 A_UtilsProdSlsScenCharc AS
SELECT
  ScenarioCharacteristic.UtilitiesProductSalesScenario AS UtilitiesProductSalesScenario,
  ScenarioCharacteristic.Characteristic AS Characteristic,
  _Characteristic.ValidityEndDate AS ValidityEndDate,
  _Characteristic.ValidityStartDate AS ValidityStartDate,
  ScenarioCharacteristic.UtilsProdSlsScenCharcUsageKind AS UtilsProdSlsScenCharcUsageKind,
  ScenarioCharacteristic.UtilsProdSlsScenScreenSequence AS UtilsProdSlsScenScreenSequence,
  ScenarioCharacteristic.UtilsProductSalesScenarioStep1 AS UtilsProductSalesScenarioStep1,
  ScenarioCharacteristic.UtilsProductSalesScenarioStep2 AS UtilsProductSalesScenarioStep2,
  ScenarioCharacteristic.UtilsProductSalesScenarioStep3 AS UtilsProductSalesScenarioStep3,
  ScenarioCharacteristic.UtilsProductSalesScenarioStep4 AS UtilsProductSalesScenarioStep4,
  ScenarioCharacteristic.UtilsProdSlsScenCharcSemantic AS UtilsProdSlsScenCharcSemantic,
  _Characteristic.CharcInternalID AS CharcInternalID,
  _Characteristic.CharcStatus AS CharcStatus,
  _Characteristic.CharcDataType AS CharcDataType,
  _Characteristic.CharcLength AS CharcLength,
  _Characteristic.CharcDecimals AS CharcDecimals,
  _Characteristic.CharcTemplate AS CharcTemplate,
  _Characteristic.ValueIsCaseSensitive AS ValueIsCaseSensitive,
  _Characteristic.CharcConversionRoutine AS CharcConversionRoutine,
  _Characteristic.CharcGroup AS CharcGroup,
  _Characteristic.EntryIsRequired AS EntryIsRequired,
  _Characteristic.MultipleValuesAreAllowed AS MultipleValuesAreAllowed,
  _Characteristic.CharcValueUnit AS CharcValueUnit,
  _Characteristic.Currency AS Currency,
  _Characteristic.CharcExponentValue AS CharcExponentValue,
  _Characteristic.ValueIntervalIsAllowed AS ValueIntervalIsAllowed,
  _Characteristic.AdditionalValueIsAllowed AS AdditionalValueIsAllowed,
  _Characteristic.NegativeValueIsAllowed AS NegativeValueIsAllowed,
  _Characteristic.ChangeNumber AS ChangeNumber,
  _Characteristic.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  _Characteristic.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  _Characteristic.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  _Characteristic.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  _Characteristic.CharcMaintAuthGrp AS CharcMaintAuthGrp,
  _Characteristic.CharcIsReadOnly AS CharcIsReadOnly,
  _Characteristic.CharcIsHidden AS CharcIsHidden,
  _Characteristic.CharcIsRestrictable AS CharcIsRestrictable,
  _Characteristic.CharcReferenceTable AS CharcReferenceTable,
  _Characteristic.CharcReferenceTableField AS CharcReferenceTableField,
  _Characteristic.CharcCheckTable AS CharcCheckTable,
  _Characteristic.CharcCheckFunctionModule AS CharcCheckFunctionModule,
  _Characteristic.CharcExponentFormat AS CharcExponentFormat,
  _Characteristic.CharcEntryIsNotFormatCtrld AS CharcEntryIsNotFormatCtrld,
  _Characteristic.CharcTemplateIsDisplayed AS CharcTemplateIsDisplayed,
  _Characteristic.CharcSelectedSet AS CharcSelectedSet,
  _Characteristic.Plant AS Plant,
  _Characteristic.CharcCatalogType AS CharcCatalogType,
  _Characteristic.CreatedByUser AS CreatedByUser,
  _Characteristic.CreationDate AS CreationDate,
  _Characteristic.LastChangedByUser AS LastChangedByUser,
  _Characteristic.LastChangeDate AS LastChangeDate,
  _Characteristic.CharcLastChangedDateTime AS CharcLastChangedDateTime
FROM I_UtilsProdSlsScenCharc AS ScenarioCharacteristic
INNER JOIN I_ClfnCharacteristic AS _Characteristic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_UtilsProdSlsScenCharcT AS _CharacteristicDesc ON CharcInternalID = _CharacteristicDesc.CharcInternalID  -- association [0..*]
LEFT OUTER JOIN A_UtilsProdSlsScenCharcVal AS _CharacteristicValue ON CharcInternalID = _CharacteristicValue.CharcInternalID  -- association [0..*]
;

Learn More