P_CustRetProcFlowMIHR

DDL: P_CUSTRETPROCFLOWMIHR Type: view_entity CONSUMPTION Package: ODATA_SD_CRET_PROCESSFLOW

Customer Return Process Flow: Level -1 In-house Repair

P_CustRetProcFlowMIHR is a Consumption CDS View that provides data about "Customer Return Process Flow: Level -1 In-house Repair" in SAP S/4HANA. It reads from 2 data sources (P_CustRetProcFlow0, I_SDDocCompleteRelatedObject) and exposes 8 fields with key fields PrecedingDocument, CustomerReturn. Part of development package ODATA_SD_CRET_PROCESSFLOW.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
P_CustRetProcFlow0 Level0 from
I_SDDocCompleteRelatedObject LevelMIHR inner

Annotations (7)

NameValueLevelField
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument I_SDDocCompleteRelatedObject SDDocRelatedObjectReference1
KEY CustomerReturn P_CustRetProcFlow0 CustomerReturn
PrecedingDocumentCategory
CustomerReturnType P_CustRetProcFlow0 CustomerReturnType
SDDocumentCategory P_CustRetProcFlow0 SDDocumentCategory
SalesOrganization P_CustRetProcFlow0 SalesOrganization
DistributionChannel P_CustRetProcFlow0 DistributionChannel
OrganizationDivision P_CustRetProcFlow0 OrganizationDivision 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view entity P_CustRetProcFlowMIHR as select from P_CustRetProcFlow0 as Level0 

inner join I_SDDocCompleteRelatedObject as LevelMIHR on Level0.CustomerReturn = LevelMIHR.SalesDocument
                                                      and LevelMIHR.SalesDocumentItem = '000000'
                                                      and LevelMIHR.SDDocumentCategory = 'H'
                                                      and LevelMIHR.SDDocRelatedObjectSequenceNmbr = '0001'
                                                      and LevelMIHR.SDDocumentRelatedObjectType = 'IHR1'
{
    //Key

    key LevelMIHR.SDDocRelatedObjectReference1 as PrecedingDocument,
    //Customer Return,

    key Level0.CustomerReturn,
    
    //Category

    cast('IHR1' as vbtypl) as PrecedingDocumentCategory,
    
    Level0.CustomerReturnType,    
    Level0.SDDocumentCategory,
    
    //Organization

    Level0.SalesOrganization,
    Level0.DistributionChannel,
    Level0.OrganizationDivision
}

Learn More