P_CUSTRETPROCFLOW0

CDS View

Customer Return Process Flow: Level 0 Initial Focus

P_CUSTRETPROCFLOW0 is a CDS View in S/4HANA. Customer Return Process Flow: Level 0 Initial Focus. It contains 6 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 6 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
P_CustRetProcFlow05 view from CONSUMPTION Customer Return Process Flow: Level +0.5 Inspection
P_CustRetProcFlow06 view from CONSUMPTION Customer Return Process Flow: Level +0.5 RPO and IHR
P_CustRetProcFlow10 view from CONSUMPTION Customer Return Process Flow: Level +1 Sales & Distribution
P_CustRetProcFlow10 view union_all CONSUMPTION Customer Return Process Flow: Level +1 Sales & Distribution
P_CustRetProcFlow12 view from CONSUMPTION Customer Return Process Flow: Level +1 Inspection
P_CustRetProcFlow13 view from CONSUMPTION Customer Return Process Flow: Level +1 RPO
P_CustRetProcFlowMIHR view_entity from CONSUMPTION Customer Return Process Flow: Level -1 In-house Repair

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn,Level0Document 6
KEY SDDocumentCategory Level0DocumentCategory,SDDocumentCategory 6
CustomerReturnType CustomerReturnType 6
DistributionChannel DistributionChannel 6
OrganizationDivision OrganizationDivision 6
SalesOrganization SalesOrganization 6 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PCUSTRETPROCF0'

define view P_CustRetProcFlow0
as select from I_SalesDocumentBasic as CustRet
       
{
    //Key

    key cast( ' ' as vbeln_von) as Level1Document,
    key cast( ' ' as posnr_von) as Level1DocumentItem,
   
    //Customer Return

    key CustRet.SalesDocument   as CustomerReturn,
   
    //Category

    CustRet.SalesDocumentType   as CustomerReturnType,
    CustRet.SDDocumentCategory,
       
    //Organization

    CustRet.SalesOrganization,
    CustRet.DistributionChannel,
    CustRet.OrganizationDivision,
    
    //ARM-based Process Identification Number

    CustRet.RetsMgmtProcess,
    
    //Relevance for planned subsequent process steps 

    case 
    when ( ( CustRet.OverallTotalDeliveryStatus = 'A' or
             CustRet.OverallTotalDeliveryStatus = 'B' )
     and CustRet.RetsMgmtProcess != '' )                          --- planned subsequent delivery for ARM-based Customer Returns only      
     then
       'X'
     else 
       ''
     end                         as DeliveryDocumentIsRequired,
    
    cast('' as boolean)          as PlndSubsqntCrdtMemoReqIsRqd,  --- planned subsequent credit memo request
    cast('' as boolean)          as PlndSubsqntRplcmtOrderIsRqd   --- planned subsequent replacement order
}
where CustRet.SDDocumentCategory = 'H'   --> Customer Return

Learn More