I_SALESQUOTATIONRELATEDOBJECT

CDS View

Sales Quotation Related Object

I_SALESQUOTATIONRELATEDOBJECT is a CDS View in S/4HANA. Sales Quotation Related Object. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_SalesQuotationRelatedObject view_entity from COMPOSITE Header Related Object

Fields (6)

KeyField CDS FieldsUsed in Views
KEY SalesQuotation SalesQuotation 1
KEY SDDocRelatedObjectSequenceNmbr SDDocRelatedObjectSequenceNmbr 1
SDDocRelatedObjectReference1 SDDocRelatedObjectReference1 1
SDDocRelatedObjectReference2 SDDocRelatedObjectReference2 1
SDDocRelatedObjectSystem SDDocRelatedObjectSystem 1
SDDocumentRelatedObjectType SDDocumentRelatedObjectType 1 
@EndUserText.label: 'Sales Quotation Related Object'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_SalesQuotationRelatedObject as select from I_SalesDocumentRelatedObject as RelatedObject 
  
    association[1..1] to I_SalesQuotation      as _SalesQuotation      on  $projection.SalesQuotation     = _SalesQuotation.SalesQuotation 
    
{
    @ObjectModel.foreignKey.association: '_SalesQuotation'                                                                                                   
    key cast(SalesDocument as sales_quotation preserving type) as SalesQuotation,                                
    key RelatedObject.SDDocRelatedObjectSequenceNmbr,   

    @ObjectModel.foreignKey.association: '_SDDocumentRelatedObjectType'
    RelatedObject.SDDocumentRelatedObjectType        as SDDocumentRelatedObjectType,
    RelatedObject.SDDocRelatedObjectSystem           as SDDocRelatedObjectSystem,
    RelatedObject.SDDocRelatedObjectReference1       as SDDocRelatedObjectReference1,
    RelatedObject.SDDocRelatedObjectReference2       as SDDocRelatedObjectReference2,   

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

    _SalesQuotation,
    //_SDDocumentCategory,

    _SDDocumentRelatedObjectType
}
where SDDocumentCategory = 'B';

Learn More