I_AdvncdReturnsMgmtProcessItem

DDL: I_ADVNCDRETURNSMGMTPROCESSITEM SQL: IARMPROCESSITM Type: view COMPOSITE

Advanced Returns Management Process Item

I_AdvncdReturnsMgmtProcessItem is a Composite CDS View that provides data about "Advanced Returns Management Process Item" in SAP S/4HANA. It reads from 1 data source (I_AdvncdRetsMgmtProcItemBasic) and exposes 23 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem. It has 2 associations to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_AdvncdRetsMgmtProcItemBasic Item from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AdvncdReturnsMgmtProcess _AdvncdRetsMgmtProcess $projection.RetsMgmtProcess = _AdvncdRetsMgmtProcess.RetsMgmtProcess
[0..*] I_AdvncdReturnsMgmtProcessStep _AdvncdRetsMgmtProcStep $projection.RetsMgmtProcess = _AdvncdRetsMgmtProcStep.RetsMgmtProcess and $projection.RetsMgmtProcessItem = _AdvncdRetsMgmtProcStep.RetsMgmtProcessItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IARMPROCESSITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataExtraction.enabled false view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Advanced Returns Management Process Item view
ObjectModel.representativeKey RetsMgmtProcessItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess I_AdvncdRetsMgmtProcItemBasic RetsMgmtProcess
KEY RetsMgmtProcessItem I_AdvncdRetsMgmtProcItemBasic RetsMgmtProcessItem
ReturnsRefundRjcnReason ReturnsRefundRjcnReason
CustRetMatlAuthzn CustRetMatlAuthzn
CustomerRetMatlInspResultCode CustomerRetMatlInspResultCode
NextFllwUpActivityForMatlInsp NextFllwUpActivityForMatlInsp
RetsProdValnIsSuspended I_AdvncdRetsMgmtProcItemBasic RetsProdValnIsSuspended
RetsMgmtItmLogProcgStatus RetsMgmtItmLogProcgStatus
RetsMgmtItmLogProcgStatusDesc
RetsMgmtItmCompnProcgStatus RetsMgmtItmCompnProcgStatus
RetsMgmtCompnProcgStatusDesc
RetsMgmtItmProcgStatus RetsMgmtItmProcgStatus
RetsMgmtProcessingStatusDesc
CRMLogicalSystem CRMLogicalSystem
CRMObjectUUID CRMObjectUUID
CRMObjectID CRMObjectID
CRMObjectType CRMObjectType
_AdvncdRetsMgmtProcess _AdvncdRetsMgmtProcess
_AdvncdRetsMgmtProcStep _AdvncdRetsMgmtProcStep
_ReturnsRefundRjcnReason _ReturnsRefundRjcnReason
_RetsMgmtItmLogProcgStatus _RetsMgmtItmLogProcgStatus
_RetsMgmtItmCompnProcgStatus _RetsMgmtItmCompnProcgStatus
_RetsMgmtItmProcgStatus _RetsMgmtItmProcgStatus 
@AbapCatalog.sqlViewName: 'IARMPROCESSITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@Analytics:{ dataExtraction.enabled:false }
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Advanced Returns Management Process Item'

@ObjectModel.representativeKey: 'RetsMgmtProcessItem'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #COMPOSITE

define view I_AdvncdReturnsMgmtProcessItem
  as select from           I_AdvncdRetsMgmtProcItemBasic as Item
    left outer to one join I_RetsMgmtProcItmWthProcgSts  as ItemProcessingStatus on  Item.RetsMgmtProcess     = ItemProcessingStatus.RetsMgmtProcess
                                                                                 and Item.RetsMgmtProcessItem = ItemProcessingStatus.RetsMgmtProcessItem


  association [1..1] to I_AdvncdReturnsMgmtProcess     as _AdvncdRetsMgmtProcess  on  $projection.RetsMgmtProcess = _AdvncdRetsMgmtProcess.RetsMgmtProcess

  association [0..*] to I_AdvncdReturnsMgmtProcessStep as _AdvncdRetsMgmtProcStep on  $projection.RetsMgmtProcess     = _AdvncdRetsMgmtProcStep.RetsMgmtProcess
                                                                                  and $projection.RetsMgmtProcessItem = _AdvncdRetsMgmtProcStep.RetsMgmtProcessItem

{
      //Key

      @ObjectModel.foreignKey.association: '_AdvncdRetsMgmtProcess'
  key Item.RetsMgmtProcess,
  key Item.RetsMgmtProcessItem,

      ReturnsRefundRjcnReason,
      CustRetMatlAuthzn,
      CustomerRetMatlInspResultCode,
      NextFllwUpActivityForMatlInsp,
      
      Item.RetsProdValnIsSuspended,
      
      //Status fields

      RetsMgmtItmLogProcgStatus,
      ItemProcessingStatus._RetsMgmtItmLogProcgStatus._Text[1: Language=$session.system_language].RetsMgmtProcessingStatusDesc          as RetsMgmtItmLogProcgStatusDesc,
      RetsMgmtItmCompnProcgStatus,
      ItemProcessingStatus._RetsMgmtItmCompnProcgStatus._Text[1: Language=$session.system_language].RetsMgmtCompnProcgStatusDesc        as RetsMgmtCompnProcgStatusDesc,
      RetsMgmtItmProcgStatus,
      ItemProcessingStatus._RetsMgmtItmProcgStatus._Text[1: Language=$session.system_language].RetsMgmtProcessingStatusDesc             as RetsMgmtProcessingStatusDesc,

      //CRM Reference

      CRMLogicalSystem,
      CRMObjectUUID,
      CRMObjectID,
      CRMObjectType,

      //Associations

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
                                      #TO_COMPOSITION_ROOT]
      _AdvncdRetsMgmtProcess,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _AdvncdRetsMgmtProcStep,
      _ReturnsRefundRjcnReason,
      _RetsMgmtItmLogProcgStatus,
      _RetsMgmtItmCompnProcgStatus,
      _RetsMgmtItmProcgStatus

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADVNCDRETSMGMTPROCITEMBASIC",
"I_RETSMGMTCOMPNPROCGSTATUS",
"I_RETSMGMTCOMPNPROCGSTATUSTEXT",
"I_RETSMGMTPROCGSTATUS",
"I_RETSMGMTPROCGSTATUSTEXT",
"I_RETSMGMTPROCITMWTHPROCGSTS"
],
"ASSOCIATED":
[
"I_ADVNCDRETURNSMGMTPROCESS",
"I_ADVNCDRETURNSMGMTPROCESSSTEP",
"I_RETSMGMTCOMPNPROCGSTATUS",
"I_RETSMGMTPROCGSTATUS",
"I_SALESDOCUMENTRJCNREASON"
],
"BASE":
[
"I_ADVNCDRETSMGMTPROCITEMBASIC",
"I_RETSMGMTPROCITMWTHPROCGSTS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More