A_BusSolnQtanItmPriceElement
Item Price Element
A_BusSolnQtanItmPriceElement is a Composite CDS View that provides data about "Item Price Element" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentEnhcd, I_PricingElement) and exposes 12 fields with key fields BusinessSolutionQuotation, BusSolutionQuotationItem, PricingProcedureStep, PricingProcedureCounter. It has 2 associations to related views. Part of development package ODATA_CRMS4_SOLUTIONQUOTATION.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_ServiceDocumentEnhcd | BusinessSolutionQuotation | inner |
| I_PricingElement | PricingElement | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_UnitOfMeasure | _UnitOfMeasure | $projection.ConditionQuantityUnit = _UnitOfMeasure.UnitOfMeasure |
| [1..1] | A_BusinessSolutionQuotation | _BusinessSolutionQuotation | $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Item Price Element | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| AbapCatalog.sqlViewName | ABSQITMPRELEM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (12)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BusinessSolutionQuotation | I_ServiceDocumentEnhcd | ServiceDocument | |
| KEY | BusSolutionQuotationItem | PricingDocumentItem | ||
| KEY | PricingProcedureStep | PricingProcedureStep | ||
| KEY | PricingProcedureCounter | PricingProcedureCounter | ||
| ConditionType | ConditionType | |||
| ConditionRateValue | ConditionRateValue | |||
| ConditionCurrency | ConditionCurrency | |||
| ConditionQuantity | ConditionQuantity | |||
| ConditionQuantityUnit | ConditionQuantityUnit | |||
| ConditionQuantityISOUnit | _UnitOfMeasure | UnitOfMeasureISOCode | ||
| VariantCondition | VariantCondition | |||
| _BusinessSolutionQuotation | _BusinessSolutionQuotation |
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Item Price Element'
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
sqlViewName: 'ABSQITMPRELEM',
compiler.compareFilter: true,
preserveKey: true
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
usageType: {
dataClass: #MIXED,
serviceQuality: #C,
sizeCategory: #XXL
}
}
@Metadata.ignorePropagatedAnnotations: true
define view A_BusSolnQtanItmPriceElement
as select from I_PricingElement as PricingElement
inner join I_ServiceDocumentEnhcd as BusinessSolutionQuotation on BusinessSolutionQuotation.PricingDocument = PricingElement.PricingDocument
and BusinessSolutionQuotation.ServiceObjectType = 'BUS2000116'
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.ConditionQuantityUnit = _UnitOfMeasure.UnitOfMeasure
association [1..1] to A_BusinessSolutionQuotation as _BusinessSolutionQuotation on $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation
{
key BusinessSolutionQuotation.ServiceDocument as BusinessSolutionQuotation,
key PricingDocumentItem as BusSolutionQuotationItem,
key PricingProcedureStep,
key PricingProcedureCounter,
ConditionType,
ConditionRateValue,
ConditionCurrency,
//PriceDetnExchangeRate,
@Semantics.quantity.unitOfMeasure: 'ConditionQuantityUnit'
ConditionQuantity,
@Semantics.unitOfMeasure: true
ConditionQuantityUnit,
_UnitOfMeasure.UnitOfMeasureISOCode as ConditionQuantityISOUnit,
VariantCondition,
case ConditionInactiveReason
when '' then 'X'
else ''
end as ConditionIsActive,
//Expose associations
_BusinessSolutionQuotation
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA