How many fields does A_SalesQuotationItemText have?

A_SalesQuotationItemText has 11 fields. Key fields: SalesQuotation, SalesQuotationItem, Language, LongTextID.

A_SalesQuotationItemText

Q: Which tables does A_SalesQuotationItemText use?

A_SalesQuotationItemText reads from 2 data source(s): P_SalesDocumentItemText, I_SalesDocumentBasic.

DDL: A_SALESQUOTATIONITEMTEXT Type: view COMPOSITE

Item Text

A_SalesQuotationItemText is a Composite CDS View that provides data about "Item Text" in SAP S/4HANA. It reads from 2 data sources (P_SalesDocumentItemText, I_SalesDocumentBasic) and exposes 11 fields with key fields SalesQuotation, SalesQuotationItem, Language, LongTextID. It has 2 associations to related views.

Data Sources (2)

Source	Alias	Join Type
P_SalesDocumentItemText	P_SalesDocumentItemText	from
I_SalesDocumentBasic	SalesQuotation	inner

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	A_SalesQuotation	_SalesQuotation	`_SalesQuotation.SalesQuotation = $projection.SalesQuotation`
[1..1]	A_SalesQuotationItem	_SalesQuotationItem	`$projection.SalesQuotation = _SalesQuotationItem.SalesQuotation and $projection.SalesQuotationItem = _SalesQuotationItem.SalesQuotationItem`

Annotations (14)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Item Text	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AbapCatalog.sqlViewName	ASQITMTEXT	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	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 (11)

Key	Field	Source Table	Source Field
KEY	SalesQuotation
KEY	SalesQuotationItem
KEY	Language		Language
KEY	LongTextID		LongTextID
	LongText		LongText
	SalesQuotationType	I_SalesDocumentBasic	SalesDocumentType
	OrganizationDivision	I_SalesDocumentBasic	OrganizationDivision
	SalesOrganization	I_SalesDocumentBasic	SalesOrganization
	DistributionChannel	I_SalesDocumentBasic	DistributionChannel
	_SalesQuotation		_SalesQuotation
	_SalesQuotationItem		_SalesQuotationItem

@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Item Text'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASQITMTEXT',
  preserveKey :true,
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true


define view A_SalesQuotationItemText
  as select from P_SalesDocumentItemText( P_SAPClient : $session.client ) as SalesQuotationItemText
    inner join   I_SalesDocumentBasic                                     as SalesQuotation on  SalesQuotation.SalesDocument = SalesQuotationItemText.SalesDocument
                                                                                              and SDDocumentCategory             = 'B'
                                                                                                
  association [1..1] to A_SalesQuotation    as _SalesQuotation     on  _SalesQuotation.SalesQuotation = $projection.SalesQuotation
  association [1..1] to A_SalesQuotationItem as _SalesQuotationItem on  $projection.SalesQuotation     = _SalesQuotationItem.SalesQuotation
                                                            and $projection.SalesQuotationItem = _SalesQuotationItem.SalesQuotationItem
{

      @ObjectModel.readOnly: true
  key cast(SalesQuotationItemText.SalesDocument as sales_quotation preserving type)      as SalesQuotation,

      @ObjectModel.readOnly: true
  key cast(SalesQuotationItemText.SalesDocumentItem as sales_quotation_item preserving type) as SalesQuotationItem,

  key Language,
  key LongTextID,
      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_SD_S4H_STXL_SQ'
      LongText,

      // For Access control

      @Consumption.hidden: true
      SalesQuotation.SalesDocumentType                                           as SalesQuotationType,
      @Consumption.hidden: true
      SalesQuotation.OrganizationDivision,
      @Consumption.hidden: true
      SalesQuotation.SalesOrganization,
      @Consumption.hidden: true
      SalesQuotation.DistributionChannel,

      // Expose own associations

      _SalesQuotation,
      _SalesQuotationItem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTBASIC"
],
"ASSOCIATED":
[
"A_SALESQUOTATION",
"A_SALESQUOTATIONITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

A_SalesQuotationItemText view