I_SALESORDERRELATEDOBJECT

CDS View

Sales Order Related Object

I_SALESORDERRELATEDOBJECT is a CDS View in S/4HANA. Sales Order 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_SalesOrderRelatedObject view_entity from COMPOSITE Header Related Object

Fields (6)

KeyField CDS FieldsUsed in Views
KEY SalesOrder SalesOrder 1
KEY SDDocRelatedObjectSequenceNmbr SDDocRelatedObjectSequenceNmbr 1
SDDocRelatedObjectReference1 SDDocRelatedObjectReference1 1
SDDocRelatedObjectReference2 SDDocRelatedObjectReference2 1
SDDocRelatedObjectSystem SDDocRelatedObjectSystem 1
SDDocumentRelatedObjectType SDDocumentRelatedObjectType 1 
//@ClientHandling.algorithm: #SESSION_VARIABLE 

@EndUserText.label: 'Sales Order Related Object'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
//@AbapCatalog: {

//  sqlViewName: 'ISDSLSORDRO',

//  compiler.compareFilter: true

//}

@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}
@Metadata.ignorePropagatedAnnotations: true
//@AbapCatalog.preserveKey:true

define view entity I_SalesOrderRelatedObject as select from I_SalesDocumentRelatedObject as RelatedObject 
  
    association[1..1] to I_SalesOrder      as _SalesOrder      on  $projection.SalesOrder     = _SalesOrder.SalesOrder 
    
{
    @ObjectModel.foreignKey.association: '_SalesOrder'                                                                                                   
    key cast(SalesDocument as vdm_sales_order preserving type) as SalesOrder,                                
    //@ObjectModel.foreignKey.association: '_SDDocumentCategory'        

    //key RelatedObject.SDDocumentCategory,

    //@ObjectModel.readOnly: true

    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 SalesOrderType,
    @Consumption.hidden: true
    OrganizationDivision,
    @Consumption.hidden: true
    SalesOrganization,
    @Consumption.hidden: true
    DistributionChannel,
                    
    //Association

    _SalesOrder,
    //_SDDocumentCategory,

    _SDDocumentRelatedObjectType
}
where SDDocumentCategory = 'C';

Learn More