A_BusSolnQtanSalesItem
Sales Item
A_BusSolnQtanSalesItem is a Composite CDS View that provides data about "Sales Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 41 fields with key fields BusinessSolutionQuotation, BusSolutionQuotationItem. It has 10 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ServiceDocumentItemEnhcd | I_ServiceDocumentItemEnhcd | from |
Associations (10)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | A_BusSolnQtanItmPriceElement | _PriceElement | $projection.BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _PriceElement.BusSolutionQuotationItem |
| [0..*] | A_BusSolnQtanItemText | _Text | $projection.BusinessSolutionQuotation = _Text.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _Text.BusSolutionQuotationItem |
| [0..*] | A_BusSolnQtanItmFUPSalesOrder | _SalesOrder | $projection.BusinessSolutionQuotation = _SalesOrder.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _SalesOrder.BusSolutionQuotationItem |
| [0..*] | A_BusSolnQtanItmFUPSrvcOrder | _ServiceOrder | $projection.BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _ServiceOrder.BusSolutionQuotationItem |
| [1..1] | A_BusinessSolutionQuotation | _BusinessSolutionQuotation | $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation |
| [0..1] | I_BusSolnQtanItmExtReference | _ExternalReference | $projection.BusinessSolutionQuotation = _ExternalReference.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _ExternalReference.BusSolutionQuotationItem and _ExternalReference.BusSolnQtanItemExtReference <> '' |
| [0..1] | E_ServiceDocumentItem | _Extension | _Extension.ServiceCategory = 'BUS2000116' and $projection.BusinessSolutionQuotation = _Extension.ServiceOrderItem and $projection.BusSolutionQuotationItem = _Extension.ServiceLineExternalID |
| [0..*] | A_BusSolnQtanItmConfign | _Configurations | $projection.ConfigurationNumber = _Configurations.VariantConfigurationInstance |
| [0..1] | I_UnitOfMeasure | _UnitOfMeasure | $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure |
| [0..1] | I_BusSolnQtanItmExtReference | _LegalCntrctItmExtReference | $projection.BusinessSolutionQuotation = _LegalCntrctItmExtReference.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _LegalCntrctItmExtReference.BusSolutionQuotationItem and _LegalCntrctItmExtReference.LegalContractItemExtReference <> '' |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Sales Item | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| AbapCatalog.sqlViewName | ABSQSALESITEM | 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 | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (41)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BusinessSolutionQuotation | ServiceDocument | ||
| KEY | BusSolutionQuotationItem | ServiceDocumentItem | ||
| BusSolnQuotationItemUUID | ServiceDocumentItemUUID | |||
| ParentBusSolnQuotationItem | _ParentServiceDocItem | ServiceDocumentItem | ||
| BusSolnQtanItemCategory | ServiceDocItemCategory | |||
| Product | OriginallyRequestedProduct | |||
| Quantity | ServiceDocumentItemQuantity | |||
| QuantityUnit | ServiceDocItemQuantityUnit | |||
| RequestedQuantityISOUnit | _UnitOfMeasure | UnitOfMeasureISOCode | ||
| BusSolnQtanItemDescription | ServiceDocumentItemDescription | |||
| Language | Language | |||
| BusSolnQtanItemExtReference | _ExternalReference | BusSolnQtanItemExtReference | ||
| LegalContractItemExtReference | _LegalCntrctItmExtReference | LegalContractItemExtReference | ||
| ItemOrderProbabilityInPercent | ItemOrderProbabilityInPercent | |||
| BusSolnQtanItemIsReleased | ServiceDocumentItemIsReleased | |||
| BusSolnQtanItemIsAccepted | QuotationIsAccepted | |||
| BusSolnQtanItemIsRejected | ServiceDocumentItemIsRejected | |||
| BusSolnQtanItmRjcnReason | ServiceDocItemRejectionReason | |||
| SoldToParty | SoldToParty | |||
| ShipToParty | ShipToParty | |||
| BillToParty | BillToParty | |||
| PayerParty | PayerParty | |||
| PersonResponsible | ResponsibleEmployee | |||
| ContactPerson | ContactPerson | |||
| PaymentTerms | PaymentTerms | |||
| IncotermsPart1 | IncotermsPart1 | |||
| IncotermsPart2 | IncotermsPart2 | |||
| DeliveryPriority | DeliveryPriority | |||
| PartialDeliveryIsAllowed | PartialDeliveryIsAllowed | |||
| OrderCombinationIsAllowed | OrderCombinationIsAllowed | |||
| ContractAccount | ContractAccount | |||
| ConfigurationNumber | ConfigurationNumber | |||
| BillingBlockReason | BillingBlockReason | |||
| BillOfMaterialItemNodeNumber | BillOfMaterialItemNodeNumber | |||
| SrvcDocItmProdConfignDateTime | ||||
| _PriceElement | _PriceElement | |||
| _Text | _Text | |||
| _SalesOrder | _SalesOrder | |||
| _ServiceOrder | _ServiceOrder | |||
| _BusinessSolutionQuotation | _BusinessSolutionQuotation | |||
| _Configurations | _Configurations |
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Sales Item'
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
sqlViewName: 'ABSQSALESITEM',
compiler.compareFilter: true,
preserveKey: true
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #L
}
}
@Metadata.ignorePropagatedAnnotations: true
define view A_BusSolnQtanSalesItem
as select from I_ServiceDocumentItemEnhcd
association [0..*] to A_BusSolnQtanItmPriceElement as _PriceElement on $projection.BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation
and $projection.BusSolutionQuotationItem = _PriceElement.BusSolutionQuotationItem
association [0..*] to A_BusSolnQtanItemText as _Text on $projection.BusinessSolutionQuotation = _Text.BusinessSolutionQuotation
and $projection.BusSolutionQuotationItem = _Text.BusSolutionQuotationItem
association [0..*] to A_BusSolnQtanItmFUPSalesOrder as _SalesOrder on $projection.BusinessSolutionQuotation = _SalesOrder.BusinessSolutionQuotation
and $projection.BusSolutionQuotationItem = _SalesOrder.BusSolutionQuotationItem
association [0..*] to A_BusSolnQtanItmFUPSrvcOrder as _ServiceOrder on $projection.BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation
and $projection.BusSolutionQuotationItem = _ServiceOrder.BusSolutionQuotationItem
association [1..1] to A_BusinessSolutionQuotation as _BusinessSolutionQuotation on $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation
association [0..1] to I_BusSolnQtanItmExtReference as _ExternalReference on $projection.BusinessSolutionQuotation = _ExternalReference.BusinessSolutionQuotation
and $projection.BusSolutionQuotationItem = _ExternalReference.BusSolutionQuotationItem
and _ExternalReference.BusSolnQtanItemExtReference <> ''
association [0..1] to E_ServiceDocumentItem as _Extension on _Extension.ServiceCategory = 'BUS2000116'
and $projection.BusinessSolutionQuotation = _Extension.ServiceOrderItem
and $projection.BusSolutionQuotationItem = _Extension.ServiceLineExternalID
association [0..*] to A_BusSolnQtanItmConfign as _Configurations on $projection.ConfigurationNumber = _Configurations.VariantConfigurationInstance
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
//Solution Quote FPS1 Developments
association [0..1] to I_BusSolnQtanItmExtReference as _LegalCntrctItmExtReference on $projection.BusinessSolutionQuotation = _LegalCntrctItmExtReference.BusinessSolutionQuotation
and $projection.BusSolutionQuotationItem = _LegalCntrctItmExtReference.BusSolutionQuotationItem
and _LegalCntrctItmExtReference.LegalContractItemExtReference <> ''
{
key ServiceDocument as BusinessSolutionQuotation,
key ServiceDocumentItem as BusSolutionQuotationItem,
ServiceDocumentItemUUID as BusSolnQuotationItemUUID,
_ParentServiceDocItem.ServiceDocumentItem as ParentBusSolnQuotationItem,
/* GENERAL INFO */
ServiceDocItemCategory as BusSolnQtanItemCategory,
OriginallyRequestedProduct as Product,
@Semantics.quantity.unitOfMeasure: 'QuantityUnit'
ServiceDocumentItemQuantity as Quantity,
ServiceDocItemQuantityUnit as QuantityUnit,
_UnitOfMeasure.UnitOfMeasureISOCode as RequestedQuantityISOUnit,
ServiceDocumentItemDescription as BusSolnQtanItemDescription,
Language,
_ExternalReference.BusSolnQtanItemExtReference,
//Solution Quote FPS1 Developments
_LegalCntrctItmExtReference.LegalContractItemExtReference,
ItemOrderProbabilityInPercent,
/* STATUS */
ServiceDocumentItemIsReleased as BusSolnQtanItemIsReleased,
case
when ServiceDocumentItemStatus = 'C'
then 'X'
else ''
end as BusSolnQtanItemIsCompleted,
QuotationIsAccepted as BusSolnQtanItemIsAccepted,
ServiceDocumentItemIsRejected as BusSolnQtanItemIsRejected,
ServiceDocItemRejectionReason as BusSolnQtanItmRjcnReason,
/* PARTNERS */
@ObjectModel.readOnly: true
SoldToParty,
ShipToParty,
BillToParty,
PayerParty,
ResponsibleEmployee as PersonResponsible,
ContactPerson,
PaymentTerms,
/* SHIPPING */
IncotermsPart1,
IncotermsPart2,
// ModeOfTransport,
DeliveryPriority,
PartialDeliveryIsAllowed,
OrderCombinationIsAllowed,
// MaxNmbrOfPartialDelivery,
ContractAccount,
@ObjectModel.readOnly: true
ConfigurationNumber,
BillingBlockReason,
//BOM Item Node Number
BillOfMaterialItemNodeNumber,
//Configuration Date
@Semantics.dateTime:true
@ObjectModel.virtualElement
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CRMS4_API_SRVP_ITM_DURATION'
cast( '00000000' as timestamp ) as SrvcDocItmProdConfignDateTime,
_PriceElement,
_Text,
_SalesOrder,
_ServiceOrder,
_BusinessSolutionQuotation,
_Configurations
}
where
ServiceObjectType = 'BUS2000116'
and ServiceDocumentItemObjectType = 'BUS2000131'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLNQTANITMEXTREFERENCE",
"I_SERVICEDOCUMENTITEMENHCD",
"I_UNITOFMEASURE"
],
"ASSOCIATED":
[
"A_BUSINESSSOLUTIONQUOTATION",
"A_BUSSOLNQTANITEMTEXT",
"A_BUSSOLNQTANITMCONFIGN",
"A_BUSSOLNQTANITMFUPSALESORDER",
"A_BUSSOLNQTANITMFUPSRVCORDER",
"A_BUSSOLNQTANITMPRICEELEMENT",
"E_SERVICEDOCUMENTITEM",
"I_BUSSOLNQTANITMEXTREFERENCE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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