I_CUSTOMERRETURNITEMRELATEDOBJ

CDS View

Returns Order Item Related Object

I_CUSTOMERRETURNITEMRELATEDOBJ is a CDS View in S/4HANA. Returns Order Item Related Object. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CustomerReturnItemRelatedObj view_entity from COMPOSITE Item Related Object

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 1
KEY CustomerReturnItem CustomerReturnItem 1
KEY SDDocRelatedObjectSequenceNmbr SDDocRelatedObjectSequenceNmbr 1
SDDocRelatedObjectReference1 SDDocRelatedObjectReference1 1
SDDocRelatedObjectReference2 SDDocRelatedObjectReference2 1
SDDocRelatedObjectSystem SDDocRelatedObjectSystem 1
SDDocumentRelatedObjectType SDDocumentRelatedObjectType 1 
@EndUserText.label: 'Returns Order Item 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_CustomerReturnItemRelatedObj as select from I_SlsDocumentItemRelatedObject as RelatedObject 
  
  association[1..1] to I_CustomerReturn      as _CustomerReturn      on  $projection.CustomerReturn     = _CustomerReturn.CustomerReturn 
  association[1..1] to I_CustomerReturnItem  as _CustomerReturnItem  on  $projection.CustomerReturn     = _CustomerReturnItem.CustomerReturn  
                                                                     and $projection.CustomerReturnItem = _CustomerReturnItem.CustomerReturnItem  

{
   @ObjectModel.foreignKey.association: '_CustomerReturn'                                                                                                   
   key cast(SalesDocument as vdm_sales_order preserving type) as CustomerReturn,                 
   @ObjectModel.foreignKey.association: '_CustomerReturnItem'                                                                                                   
   key cast(SalesDocumentItem as sales_order_item preserving type) as CustomerReturnItem,                
   
   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,
    _CustomerReturnItem,
    _SDDocumentRelatedObjectType 
}
where SDDocumentCategory = 'H'; 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SLSDOCUMENTITEMRELATEDOBJECT"
],
"ASSOCIATED":
[
"I_CUSTOMERRETURN",
"I_CUSTOMERRETURNITEM",
"I_SDDOCRELATEDOBJECTTYPESTDVH"
],
"BASE":
[
"I_SLSDOCUMENTITEMRELATEDOBJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More