I_CUSTOMERRETURNRELATEDOBJECT

CDS View

Returns Order Related Object

I_CUSTOMERRETURNRELATEDOBJECT is a CDS View in S/4HANA. Returns 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_CustomerReturnRelatedObject view_entity from COMPOSITE Header Related Object

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 1
KEY SDDocRelatedObjectSequenceNmbr SDDocRelatedObjectSequenceNmbr 1
SDDocRelatedObjectReference1 SDDocRelatedObjectReference1 1
SDDocRelatedObjectReference2 SDDocRelatedObjectReference2 1
SDDocRelatedObjectSystem SDDocRelatedObjectSystem 1
SDDocumentRelatedObjectType SDDocumentRelatedObjectType 1 
@EndUserText.label: 'Returns Order 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_CustomerReturnRelatedObject as select from I_SalesDocumentRelatedObject as RelatedObject

  association[1..1] to I_CustomerReturn          as _CustomerReturn on  $projection.CustomerReturn     = _CustomerReturn.CustomerReturn
{
    @ObjectModel.foreignKey.association: '_CustomerReturn'                                                                                                   
    key cast(SalesDocument as vdm_sales_order preserving type) as CustomerReturn,                                
    
    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 CustomerReturnType,
    @Consumption.hidden: true
    OrganizationDivision,
    @Consumption.hidden: true
    SalesOrganization,
    @Consumption.hidden: true
    DistributionChannel,
                    
    //Association

    _CustomerReturn,
    _SDDocumentRelatedObjectType
}
where SDDocumentCategory = 'H';

Learn More