R_InhRepairFUPCustReturnTP

DDL: R_INHREPAIRFUPCUSTRETURNTP Type: view_entity TRANSACTIONAL Package: CRMS4_REPAIR_RAP

Follow-Up Returns Order for IHR - TP

R_InhRepairFUPCustReturnTP is a Transactional CDS View that provides data about "Follow-Up Returns Order for IHR - TP" in SAP S/4HANA. It reads from 3 data sources (I_CustMgmtTransactionRelation, I_InHouseRepair, I_CustMgmtTransactionRelation) and exposes 14 fields with key fields InHouseRepair, CustomerReturn. Part of development package CRMS4_REPAIR_RAP.

3 data source(s) 14 fields

Data Sources (3)

SourceAliasJoin Type
I_CustMgmtTransactionRelation CustomerReturn inner
I_InHouseRepair InHouseRepair from
I_CustMgmtTransactionRelation MSR inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Follow-Up Returns Order for IHR - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InHouseRepair I_InHouseRepair InHouseRepair
KEY CustomerReturn
RetsMgmtProcess
DistributionChannel I_InHouseRepair DistributionChannel
Division I_InHouseRepair Division
InhRepairType I_InHouseRepair InhRepairType
RespEmployeeBusinessPartnerId I_InHouseRepair ResponsibleEmployee
SalesGroup I_InHouseRepair SalesGroup
SalesGroupOrgUnitID I_InHouseRepair SalesGroupOrgUnitID
SalesOffice I_InHouseRepair SalesOffice
SalesOfficeOrgUnitID I_InHouseRepair SalesOfficeOrgUnitID
SalesOrganization I_InHouseRepair SalesOrganization
SalesOrganizationOrgUnitID I_InHouseRepair SalesOrganizationOrgUnitID
_InHouseRepairTP _InHouseRepairTP 
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Follow-Up Returns Order for IHR - TP'
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
define view entity R_InhRepairFUPCustReturnTP
  as select from I_InHouseRepair               as InHouseRepair

    inner join   I_CustMgmtTransactionRelation as CustomerReturn on  CustomerReturn.CustMgmtPrdcssrTransactionUUID = InHouseRepair.InHouseRepairUUID
                                                                 and CustomerReturn.CustMgmtPrdcssrTransacObjType  = 'BUS2000256'
                                                                 and CustomerReturn.CustMgmtSuccssrTransacObjType  = 'BUS2102'
                                                                 and CustomerReturn.CustMgmtTransacRelationType    = 'VONA'

    inner join   I_CustMgmtTransactionRelation as MSR            on  MSR.CustMgmtPrdcssrTransactionUUID           = InHouseRepair.InHouseRepairUUID
                                                                 and CustomerReturn.CustMgmtPrdcssrTransacObjType = 'BUS2000256'
                                                                 and CustomerReturn.CustMgmtSuccssrTransacObjType = 'BUS2102'
                                                                 and MSR.CustMgmtTransacRelationType              = 'MSR'

  association to parent I_InHouseRepairTP as _InHouseRepairTP on $projection.InHouseRepair = _InHouseRepairTP.InHouseRepair


{
  key  InHouseRepair.InHouseRepair,
  key  substring( CustomerReturn.CustMgmtSuccssrTransactionKey, 1, 10 ) as CustomerReturn,
       substring( MSR.CustMgmtSuccssrTransactionKey, 1, 10 )            as RetsMgmtProcess,

       @UI.hidden: true
       InHouseRepair.DistributionChannel,

       @UI.hidden: true
       InHouseRepair.Division,

       @UI.hidden: true
       InHouseRepair.InhRepairType,

       @UI.hidden: true
       InHouseRepair.ResponsibleEmployee as RespEmployeeBusinessPartnerId,

       @UI.hidden: true
       InHouseRepair.SalesGroup,

       @UI.hidden: true
       InHouseRepair.SalesGroupOrgUnitID,

       @UI.hidden: true
       InHouseRepair.SalesOffice,

       @UI.hidden: true
       InHouseRepair.SalesOfficeOrgUnitID,

       @UI.hidden: true
       InHouseRepair.SalesOrganization,

       @UI.hidden: true
       InHouseRepair.SalesOrganizationOrgUnitID,

       _InHouseRepairTP
}

Learn More