A_UtilsProductSalesScenario

DDL: A_UTILSPRODUCTSALESSCENARIO Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 2 Associations

Utilities Product Sales Scenario

A_UtilsProductSalesScenario is a Consumption CDS View that provides data about "Utilities Product Sales Scenario" in SAP S/4HANA. It reads from 1 data source (I_UtilsProductSalesScenario) and exposes 12 fields with key field UtilitiesProductSalesScenario. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_UtilsProductSalesScenario I_UtilsProductSalesScenario from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_UtilsProdSlsScenCharc _ScenarioCharacteristic $projection.UtilitiesProductSalesScenario = _ScenarioCharacteristic.UtilitiesProductSalesScenario
[0..*] A_UtilsProductSalesScenarioT _ScenarioText _ScenarioText.UtilitiesProductSalesScenario = $projection.UtilitiesProductSalesScenario

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utilities Product Sales Scenario view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name UtilitiesProductSalesScenario_Type view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProductSalesScenario UtilitiesProductSalesScenario VAT Scenario
UtilsProdSlsScenarioCategory UtilsProdSlsScenarioCategory Violation Category
UtilsProdSlsScenExtDocType UtilsProdSlsScenExtDocType Ext. Doc. Type
UtilsProdSlsScenExtItmCategory UtilsProdSlsScenExtItmCategory Ext. Itm. Category
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
IsActive IsActive Object active?
UtilsProdSlsScenarioIsDefault UtilsProdSlsScenarioIsDefault Truth Value
UtilitiesDivision UtilitiesDivision Internal Division ID
UtilsProdSlsScenSemanticGroup UtilsProdSlsScenSemanticGroup Semantic Group
_ScenarioCharacteristic _ScenarioCharacteristic
_ScenarioText _ScenarioText

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_UtilsProductSalesScenario.
-- 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_UtilsProductSalesScenario AS
SELECT
  UtilitiesProductSalesScenario,
  UtilsProdSlsScenarioCategory,
  UtilsProdSlsScenExtDocType,
  UtilsProdSlsScenExtItmCategory,
  SalesDocumentType,
  SalesDocumentItemCategory,
  IsActive,
  UtilsProdSlsScenarioIsDefault,
  UtilitiesDivision,
  UtilsProdSlsScenSemanticGroup
FROM I_UtilsProductSalesScenario
LEFT OUTER JOIN A_UtilsProdSlsScenCharc AS _ScenarioCharacteristic ON UtilitiesProductSalesScenario = _ScenarioCharacteristic.UtilitiesProductSalesScenario  -- association [0..*]
LEFT OUTER JOIN A_UtilsProductSalesScenarioT AS _ScenarioText ON _ScenarioText.UtilitiesProductSalesScenario = UtilitiesProductSalesScenario  -- association [0..*]
;

Learn More