A_BusSolnOrdItmConfiguration

DDL: A_BUSSOLNORDITMCONFIGURATION Type: view_entity COMPOSITE Package: ODATA_CRMS4_SOLUTIONORDER
17 Fields 1 Data Sources 3 Associations

Solution Order Item Configuration

A_BusSolnOrdItmConfiguration is a Composite CDS View that provides data about "Solution Order Item Configuration" in SAP S/4HANA. It reads from 1 data source (I_VarConfignProdInstanceValue2) and exposes 17 fields with key fields VarConfignInstceBusObjectKey, VarConfignInstceBusObjectType, VariantConfigurationInstance, CharcInternalID, CharcValue. It has 3 associations to related views. Part of development package ODATA_CRMS4_SOLUTIONORDER.

Data Sources (1)

SourceAliasJoin Type
I_VarConfignProdInstanceValue2 VarConfignProdInstanceValue2 from

Associations (3)

CardinalityTargetAliasCondition
[0..1] A_BusSolnOrderServiceItem _BusSolnOrderServiceItem $projection.VariantConfigurationInstance = _BusSolnOrderServiceItem.ConfigurationNumber
[0..1] A_BusSolnOrdSrvcContractItem _BusSolnOrdSrvcContractItem $projection.VariantConfigurationInstance = _BusSolnOrdSrvcContractItem.ConfigurationNumber
[0..1] A_BusSolnOrderSalesItem _BusSolnOrderSalesItem $projection.VariantConfigurationInstance = _BusSolnOrderSalesItem.ConfigurationNumber

Annotations (11)

NameValueLevelField
EndUserText.label Solution Order Item Configuration view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY VarConfignInstceBusObjectKey I_VarConfignProdInstanceValue2 VarConfignInstceBusObjectKey
KEY VarConfignInstceBusObjectType I_VarConfignProdInstanceValue2 VarConfignInstceBusObjectType
KEY VariantConfigurationInstance I_VarConfignProdInstanceValue2 VariantConfigurationInstance
KEY CharcInternalID I_VarConfignProdInstanceValue2 CharcInternalID Characteristic Internal ID
KEY CharcValue I_VarConfignProdInstanceValue2 CharcValue Char. Value
KEY CharcFromNumericValue I_VarConfignProdInstanceValue2 CharcFromNumericValue Value from
KEY CharcToNumericValue I_VarConfignProdInstanceValue2 CharcToNumericValue Value to
CharcReferenceTable
CharcReferenceTableField
Characteristic I_VarConfignProdInstanceValue2 Characteristic Field Name
CharcValueAsCharacterValue
CharcValueAssignmentType
VariantConditionFactor
VariantConfigurationDate I_VarConfignProdInstanceValue2 VariantConfigurationDate
_BusSolnOrderServiceItem _BusSolnOrderServiceItem
_BusSolnOrderSalesItem _BusSolnOrderSalesItem
_BusSolnOrdSrvcContractItem _BusSolnOrdSrvcContractItem

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_BusSolnOrdItmConfiguration.
-- 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_BusSolnOrdItmConfiguration AS
SELECT
  VarConfignProdInstanceValue2.VarConfignInstceBusObjectKey AS VarConfignInstceBusObjectKey,
  VarConfignProdInstanceValue2.VarConfignInstceBusObjectType AS VarConfignInstceBusObjectType,
  VarConfignProdInstanceValue2.VariantConfigurationInstance AS VariantConfigurationInstance,
  VarConfignProdInstanceValue2.CharcInternalID AS CharcInternalID,
  VarConfignProdInstanceValue2.CharcValue AS CharcValue,
  VarConfignProdInstanceValue2.CharcFromNumericValue AS CharcFromNumericValue,
  VarConfignProdInstanceValue2.CharcToNumericValue AS CharcToNumericValue,
  VarConfignProdInstanceValue2._Characteristic.CharcReferenceTable AS CharcReferenceTable,
  VarConfignProdInstanceValue2._Characteristic.CharcReferenceTableField AS CharcReferenceTableField,
  VarConfignProdInstanceValue2.Characteristic AS Characteristic,
  cast('' as atwrt) AS CharcValueAsCharacterValue,
  cast('' as vch_hl_assignment_type_api_in) AS CharcValueAssignmentType,
  cast('' as comt_cfgd_vacondfac ) AS VariantConditionFactor,
  VarConfignProdInstanceValue2.VariantConfigurationDate AS VariantConfigurationDate
FROM I_VarConfignProdInstanceValue2 AS VarConfignProdInstanceValue2
LEFT OUTER JOIN A_BusSolnOrderServiceItem AS _BusSolnOrderServiceItem ON VariantConfigurationInstance = _BusSolnOrderServiceItem.ConfigurationNumber  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdSrvcContractItem AS _BusSolnOrdSrvcContractItem ON VariantConfigurationInstance = _BusSolnOrdSrvcContractItem.ConfigurationNumber  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrderSalesItem AS _BusSolnOrderSalesItem ON VariantConfigurationInstance = _BusSolnOrderSalesItem.ConfigurationNumber  -- association [0..1]
;

Learn More