C_CustomerReturnRefundSts

DDL: C_CUSTOMERRETURNREFUNDSTS SQL: CCRTRFNDSTS Type: view CONSUMPTION Package: ODATA_SD_RETURN_V2

Returns Order Refund Status

C_CustomerReturnRefundSts is a Consumption CDS View that provides data about "Returns Order Refund Status" in SAP S/4HANA. Part of development package ODATA_SD_RETURN_V2.

1 fields

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCRTRFNDSTS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Returns Order Refund Status view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn RefundItem CustomerReturn 
@AbapCatalog.sqlViewName: 'CCRTRFNDSTS'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Returns Order Refund Status'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

define view C_CustomerReturnRefundSts
  as select distinct from C_CustReturnItemRefundStatus as RefundItem
  
  association to P_CustRetItemRfndStatusCount as _CustRetItmRfndStsCount on $projection.CustomerReturn = _CustRetItmRfndStsCount.CustomerReturn
{
  key RefundItem.CustomerReturn,
      case when RefundItem.RetsMgmtProcess = ''
      then ''
      else
        case when _CustRetItmRfndStsCount.CustReturnRefundStatusCount = 1 
        then
          RefundItem.CustReturnItmRefundStatus
        else
          'B'
        end
      end as CustReturnRefundStatus
}

Learn More