C_CustomerReturnRefundSts

DDL: C_CUSTOMERRETURNREFUNDSTS SQL: CCRTRFNDSTS Type: view CONSUMPTION

Returns Order Refund Status

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

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 #D 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
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Returns Order Refund Status'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CUSTRETURNITEMREFUNDSTATUS",
"P_CUSTRETITEMRFNDSTATUSCOUNT"
],
"ASSOCIATED":
[
"P_CUSTRETITEMRFNDSTATUSCOUNT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More