R_SrvcQtanItemLongTextTP

DDL: R_SRVCQTANITEMLONGTEXTTP Type: view_entity TRANSACTIONAL

Long Text for Service Quotation Item

R_SrvcQtanItemLongTextTP is a Transactional CDS View that provides data about "Long Text for Service Quotation Item" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentLongText, I_ServiceDocumentItem) and exposes 26 fields with key fields ServiceQuotation, ServiceQuotationItem, TextObjectType, Language, SrvcDocLogTextIdentifier. It has 1 association to related views.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentLongText ServiceItemText from
I_ServiceDocumentItem ServiceQuotationItem inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ServiceQuotationTP _ServiceQuotationTP $projection.ServiceQuotation = _ServiceQuotationTP.ServiceQuotation

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
EndUserText.label Long Text for Service Quotation Item view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation I_ServiceDocumentItem ServiceDocument
KEY ServiceQuotationItem I_ServiceDocumentItem ServiceDocumentItem
KEY TextObjectType I_ServiceDocumentLongText TextObjectType
KEY Language I_ServiceDocumentLongText Language
KEY SrvcDocLogTextIdentifier I_ServiceDocumentLongText SrvcDocLogTextIdentifier
ServiceDocumentLongTextUUID I_ServiceDocumentLongText ServiceDocumentLongTextUUID
TextObjectCategory I_ServiceDocumentLongText TextObjectCategory
SrvcDocLongTextMimeType I_ServiceDocumentLongText SrvcDocLongTextMimeType
SrvcQtanItemLongText I_ServiceDocumentLongText ServiceDocumentLongText
ReferenceTextObjectCategory I_ServiceDocumentLongText ReferenceTextObjectCategory
ReferenceTextObjectType I_ServiceDocumentLongText ReferenceTextObjectType
ReferenceLongTextKey I_ServiceDocumentLongText ReferenceLongTextKey
ReferenceServiceObjectType I_ServiceDocumentLongText ReferenceServiceObjectType
ReferenceServiceDocument I_ServiceDocumentLongText ReferenceServiceDocument
ReferenceServiceDocumentItem I_ServiceDocumentLongText ReferenceServiceDocumentItem
SrvcDocLongTxtCreationDateTime I_ServiceDocumentLongText SrvcDocLongTxtCreationDateTime
SrvcDocLongTextCreatedByUser I_ServiceDocumentLongText SrvcDocLongTextCreatedByUser
SrvcDocLongTextChangedDateTime I_ServiceDocumentLongText SrvcDocLongTextChangedDateTime
SrvcDocLongTextChangedByUser I_ServiceDocumentLongText SrvcDocLongTextChangedByUser
_Language I_ServiceDocumentLongText _Language
_ReferenceTextObjectCategory I_ServiceDocumentLongText _ReferenceTextObjectCategory
_ReferenceTextObjectType I_ServiceDocumentLongText _ReferenceTextObjectType
_TextObjectCategory I_ServiceDocumentLongText _TextObjectCategory
_TextObjectType I_ServiceDocumentLongText _TextObjectType
_ServiceQuotationItemTP _ServiceQuotationItemTP
_ServiceQuotationTP _ServiceQuotationTP 
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@Metadata: {
  ignorePropagatedAnnotations: true
}

@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L},
                dataCategory: #TEXT
}
@EndUserText.label: 'Long Text for Service Quotation Item'
define view entity R_SrvcQtanItemLongTextTP  as select from I_ServiceDocumentLongText as ServiceItemText
    inner join   I_ServiceDocumentItem     as ServiceQuotationItem on  ServiceItemText.ServiceDocument                 = ServiceQuotationItem.ServiceDocument
                                                               and ServiceItemText.ServiceDocumentItem             = ServiceQuotationItem.ServiceDocumentItem
                                                               and ServiceItemText.TextObjectCategory              = 'CRM_ORDERI'
                                                               and ServiceQuotationItem.ServiceObjectType              = 'BUS2000116'
                                                               and ServiceQuotationItem.ServiceDocumentItemIsQuotation is not initial
                                                               and ServiceQuotationItem.ServiceDocumentTemplateType    is initial
  association        to parent R_ServiceQuotationItemTP as _ServiceQuotationItemTP on  $projection.ServiceQuotation     = _ServiceQuotationItemTP.ServiceQuotation
                                                                           and $projection.ServiceQuotationItem = _ServiceQuotationItemTP.ServiceQuotationItem
  association [1..1] to R_ServiceQuotationTP            as _ServiceQuotationTP     on  $projection.ServiceQuotation = _ServiceQuotationTP.ServiceQuotation

{
  key ServiceQuotationItem.ServiceDocument        as ServiceQuotation,
  key ServiceQuotationItem.ServiceDocumentItem    as ServiceQuotationItem,
  key ServiceItemText.TextObjectType,
  @Semantics.language:true
  key ServiceItemText.Language,
  key ServiceItemText.SrvcDocLogTextIdentifier,
   ServiceItemText.ServiceDocumentLongTextUUID,

      
      // ServiceOrderItem.ServiceObjectType,


      ServiceItemText.TextObjectCategory,
      

      ServiceItemText.SrvcDocLongTextMimeType,
      @Semantics.text:true
      ServiceItemText.ServiceDocumentLongText as SrvcQtanItemLongText,

      ServiceItemText.ReferenceTextObjectCategory,
      ServiceItemText.ReferenceTextObjectType,
      ServiceItemText.ReferenceLongTextKey,
      ServiceItemText.ReferenceServiceObjectType,
      ServiceItemText.ReferenceServiceDocument,
      ServiceItemText.ReferenceServiceDocumentItem,

      ServiceItemText.SrvcDocLongTxtCreationDateTime,
      ServiceItemText.SrvcDocLongTextCreatedByUser,
      ServiceItemText.SrvcDocLongTextChangedDateTime,
      ServiceItemText.SrvcDocLongTextChangedByUser,

      /* Associations */
      ServiceItemText._Language,
      ServiceItemText._ReferenceTextObjectCategory,
      ServiceItemText._ReferenceTextObjectType,
      ServiceItemText._TextObjectCategory,
      ServiceItemText._TextObjectType,
      _ServiceQuotationItemTP,
      _ServiceQuotationTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEM",
"I_SERVICEDOCUMENTLONGTEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TEXTOBJECTCATEGORY",
"I_TEXTOBJECTTYPE",
"R_SERVICEQUOTATIONITEMTP",
"R_SERVICEQUOTATIONTP"
],
"BASE":
[
"I_SERVICEDOCUMENTLONGTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More