R_BusSolnQtanItemTP

DDL: R_BUSSOLNQTANITEMTP Type: view_entity TRANSACTIONAL

Business Solution Quotation Item - TP

R_BusSolnQtanItemTP is a Transactional CDS View that provides data about "Business Solution Quotation Item - TP" in SAP S/4HANA. It reads from 2 data sources (I_BusSolutionQuotationType, I_ServiceDocumentItemEnhcd) and exposes 38 fields with key fields BusinessSolutionQuotation, CustMgmtObjectType, ServiceDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_BusSolutionQuotationType _BusSolutionQuotationType inner
I_ServiceDocumentItemEnhcd _ServiceDocumentItemEnhcd from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Solution Quotation Item - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation I_ServiceDocumentItemEnhcd ServiceDocument
KEY CustMgmtObjectType I_ServiceDocumentItemEnhcd ServiceObjectType
KEY ServiceDocumentItem I_ServiceDocumentItemEnhcd ServiceDocumentItem
Product I_ServiceDocumentItemEnhcd Product
BusSolnQtanItemDescription I_ServiceDocumentItemEnhcd ServiceDocumentItemDescription
BusSolnQtanItemCategory I_ServiceDocumentItemEnhcd ServiceDocItemCategory
ServiceDocumentItemObjectType I_ServiceDocumentItemEnhcd ServiceDocumentItemObjectType
SrvcDocItmCategoryShortName _ServiceDocItemCategoryText SrvcDocItmCategoryShortName
ServiceDocumentItemUUID I_ServiceDocumentItemEnhcd ServiceDocumentItemUUID
ParentServiceDocumentItemUUID I_ServiceDocumentItemEnhcd ParentServiceDocumentItemUUID
Quantity I_ServiceDocumentItemEnhcd ServiceDocumentItemQuantity
QuantityUnit I_ServiceDocumentItemEnhcd ServiceDocItemQuantityUnit
TransactionCurrency I_ServiceDocumentItemEnhcd TransactionCurrency
ServiceDocumentItemNetAmount I_ServiceDocumentItemEnhcd ServiceDocumentItemNetAmount
ServiceDocumentItemStatus I_ServiceDocumentItemEnhcd ServiceDocumentItemStatus
ServiceDocumentStatusName _SrvcDocLifecycleStatusText ServiceDocumentStatusName
ServiceDocumentType I_ServiceDocumentItemEnhcd ServiceDocumentType
SalesGroup I_ServiceDocumentItemEnhcd SalesGroup
SalesOffice I_ServiceDocumentItemEnhcd SalesOffice
Division I_ServiceDocumentItemEnhcd Division
DistributionChannel I_ServiceDocumentItemEnhcd DistributionChannel
SalesOrganization I_ServiceDocumentItemEnhcd SalesOrganization
SalesOrganizationOrgUnitID I_ServiceDocumentItemEnhcd SalesOrganizationOrgUnitID
ServiceOrganization I_ServiceDocumentItemEnhcd ServiceOrganization
SalesGroupOrgUnitID I_ServiceDocumentItemEnhcd SalesGroupOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItemEnhcd SalesOfficeOrgUnitID
RespEmployeeBusinessPartnerId I_ServiceDocumentItemEnhcd ResponsibleEmployee
_ServiceDocItemCategory I_ServiceDocumentItemEnhcd _ServiceDocItemCategory
_BusinessSolutionQuotation _BusinessSolutionQuotation
_SrvcDocLifecycleStatusText _SrvcDocLifecycleStatusText
_ServiceDocItemCategoryText _ServiceDocItemCategoryText
_ServiceDocument I_ServiceDocumentItemEnhcd _ServiceDocument
_ServiceObjType I_ServiceDocumentItemEnhcd _ServiceObjType
_TransactionCurrency I_ServiceDocumentItemEnhcd _TransactionCurrency
_ServiceDocItemStatus I_ServiceDocumentItemEnhcd _ServiceDocItemStatus
_ServiceDocumentType I_ServiceDocumentItemEnhcd _ServiceDocumentType
_Product I_ServiceDocumentItemEnhcd _Product
_RespEmployee I_ServiceDocumentItemEnhcd _RespEmployee
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@EndUserText.label: 'Business Solution Quotation Item - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
  dataClass:      #MIXED,
    serviceQuality: #C,
    sizeCategory:   #XXL
}
define view entity R_BusSolnQtanItemTP
  as select from I_ServiceDocumentItemEnhcd as _ServiceDocumentItemEnhcd
  inner join I_BusSolutionQuotationType as _BusSolutionQuotationType on _ServiceDocumentItemEnhcd.ServiceDocumentType = _BusSolutionQuotationType.BusSolutionQuotationType
  association to parent R_BusinessSolutionQuotationTP as _BusinessSolutionQuotation on $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation
  association[1] to I_SrvcDocLifecycleStatusText as _SrvcDocLifecycleStatusText on $projection.ServiceDocumentItemStatus = _SrvcDocLifecycleStatusText.ServiceDocumentStatus
                                                 and _SrvcDocLifecycleStatusText.Language = $session.system_language
  association[0..1] to I_ServiceDocItemCategoryText as _ServiceDocItemCategoryText on $projection.BusSolnQtanItemCategory = _ServiceDocItemCategoryText.ServiceDocItemCategory
                                                    and _ServiceDocItemCategoryText.Language = $session.system_language
{
  key _ServiceDocumentItemEnhcd.ServiceDocument                as BusinessSolutionQuotation,
  key _ServiceDocumentItemEnhcd.ServiceObjectType              as CustMgmtObjectType,
  key _ServiceDocumentItemEnhcd.ServiceDocumentItem,

      @ObjectModel.foreignKey.association: '_Product'
      _ServiceDocumentItemEnhcd.Product,
      _ServiceDocumentItemEnhcd.ServiceDocumentItemDescription as BusSolnQtanItemDescription,

      _ServiceDocumentItemEnhcd.ServiceDocItemCategory         as BusSolnQtanItemCategory,
      _ServiceDocumentItemEnhcd.ServiceDocumentItemObjectType,
      _ServiceDocItemCategoryText.SrvcDocItmCategoryShortName,

      @Semantics.uuid: true
      _ServiceDocumentItemEnhcd.ServiceDocumentItemUUID,

      @Semantics.uuid: true
      _ServiceDocumentItemEnhcd.ParentServiceDocumentItemUUID,

      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      _ServiceDocumentItemEnhcd.ServiceDocumentItemQuantity    as Quantity,

      _ServiceDocumentItemEnhcd.ServiceDocItemQuantityUnit     as QuantityUnit,

      // Pricing

      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      _ServiceDocumentItemEnhcd.TransactionCurrency,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _ServiceDocumentItemEnhcd.ServiceDocumentItemNetAmount,

      _ServiceDocumentItemEnhcd.ServiceDocumentItemStatus,

      _SrvcDocLifecycleStatusText.ServiceDocumentStatusName,


      @ObjectModel.sapObjectNodeTypeReference: 'ServiceDocumentType'
      _ServiceDocumentItemEnhcd.ServiceDocumentType,

      _ServiceDocumentItemEnhcd.SalesGroup,
      _ServiceDocumentItemEnhcd.SalesOffice,
      _ServiceDocumentItemEnhcd.Division,
      _ServiceDocumentItemEnhcd.DistributionChannel,
      _ServiceDocumentItemEnhcd.SalesOrganization,
      _ServiceDocumentItemEnhcd.SalesOrganizationOrgUnitID,
      _ServiceDocumentItemEnhcd.ServiceOrganization,
      _ServiceDocumentItemEnhcd.SalesGroupOrgUnitID,
      _ServiceDocumentItemEnhcd.SalesOfficeOrgUnitID,

      @Semantics.text: true
      @ObjectModel.foreignKey.association: '_RespEmployee'
      _ServiceDocumentItemEnhcd.ResponsibleEmployee as RespEmployeeBusinessPartnerId,

      _ServiceDocumentItemEnhcd._ServiceDocItemCategory,

      //Associations

      _BusinessSolutionQuotation,
      _SrvcDocLifecycleStatusText,
      _ServiceDocItemCategoryText,
      _ServiceDocumentItemEnhcd._ServiceDocument,
      _ServiceDocumentItemEnhcd._ServiceObjType,
      _ServiceDocumentItemEnhcd._TransactionCurrency,
      _ServiceDocumentItemEnhcd._ServiceDocItemStatus,
      _ServiceDocumentItemEnhcd._ServiceDocumentType,
      _ServiceDocumentItemEnhcd._Product,
      _ServiceDocumentItemEnhcd._RespEmployee

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLUTIONQUOTATIONTYPE",
"I_SERVICEDOCITEMCATEGORYTEXT",
"I_SERVICEDOCUMENTITEMENHCD",
"I_SRVCDOCLIFECYCLESTATUSTEXT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CURRENCY",
"I_CUSTMGMTBUSOBJTYPE",
"I_PRODUCT",
"I_SERVICEDOCITEMCATEGORY",
"I_SERVICEDOCITEMCATEGORYTEXT",
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTSTATUS",
"I_SERVICEDOCUMENTTYPE",
"I_SRVCDOCLIFECYCLESTATUSTEXT",
"R_BUSINESSSOLUTIONQUOTATIONTP"
],
"BASE":
[
"I_SERVICEDOCUMENTITEMENHCD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/