C_CustRetProcgStatus

DDL: C_CUSTRETPROCGSTATUS Type: view_entity CONSUMPTION

Customer Return Processing Status

C_CustRetProcgStatus is a Consumption CDS View that provides data about "Customer Return Processing Status" in SAP S/4HANA.

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Customer Return Processing Status view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn CustReturn CustomerReturn
CustomerReturnType CustReturn CustomerReturnType
SalesOrganization CustReturn SalesOrganization
DistributionChannel CustReturn DistributionChannel
OrganizationDivision CustReturn OrganizationDivision
RetsMgmtProcess CustReturn RetsMgmtProcess
RetsMgmtLogProcgStatus _RetsMgmtProcessWthProcgSts RetsMgmtLogProcgStatus
RetsMgmtProcessingStatus _RetsMgmtProcessWthProcgSts RetsMgmtProcessingStatus
_RetsMgmtProcess CustReturn _RetsMgmtProcess
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Customer Return Processing Status'
@ObjectModel.usageType: {
    dataClass:      #MIXED,
    serviceQuality: #D,
    sizeCategory:   #L
  }
@Metadata.ignorePropagatedAnnotations: true
define view entity C_CustRetProcgStatus 
  as select distinct from I_CustomerReturn as CustReturn
  left outer to one join I_RetsMgmtProcessWthProcgSts as _RetsMgmtProcessWthProcgSts on CustReturn.RetsMgmtProcess = _RetsMgmtProcessWthProcgSts.RetsMgmtProcess
{
  key CustReturn.CustomerReturn,
  
  //for Access control

  @UI.hidden: true
  @Consumption.hidden: true
  CustReturn.CustomerReturnType,
  //Org

  @UI.hidden: true
  @Consumption.hidden: true
  CustReturn.SalesOrganization,
  @UI.hidden: true
  @Consumption.hidden: true
  CustReturn.DistributionChannel,
  @UI.hidden: true
  @Consumption.hidden: true
  CustReturn.OrganizationDivision,
  
  @ObjectModel.foreignKey.association: '_RetsMgmtProcess'
  CustReturn.RetsMgmtProcess,
  
  case when CustReturn.RetsMgmtProcess is initial 
       then '' 
       else _RetsMgmtProcessWthProcgSts.RetsMgmtCompnProcgStatus 
       end  as RetsMgmtCompnProcgStatus,
  
  _RetsMgmtProcessWthProcgSts.RetsMgmtLogProcgStatus,
  _RetsMgmtProcessWthProcgSts.RetsMgmtProcessingStatus,
  
  CustReturn._RetsMgmtProcess
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERRETURN",
"I_RETSMGMTPROCESSWTHPROCGSTS"
],
"ASSOCIATED":
[
"I_RETSMGMTPROCESS"
],
"BASE":
[
"I_CUSTOMERRETURN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/