F_Mmim_Sorder_Union

DDL: F_MMIM_SORDER_UNION SQL: FMMIMSORDERUN Type: view

Help-View for Sales Order Union

F_Mmim_Sorder_Union is a CDS View that provides data about "Help-View for Sales Order Union" in SAP S/4HANA. It reads from 2 data sources (matdoc, matdoc).

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
matdoc matdoc from
matdoc matdoc union_all

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName FMMIMSORDERUN view
EndUserText.label Help-View for Sales Order Union view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'FMMIMSORDERUN'
@EndUserText.label: 'Help-View for Sales Order Union'
@AccessControl.authorizationCheck:#NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view F_Mmim_Sorder_Union as select from matdoc

{
 key mat_kdauf as SalesOrder   
}
  where mat_kdauf <> ''
           
union all

select from matdoc

{
    kdauf as SalesOrder    
}
  where kdauf    <> ''
    and mat_kdauf = '' 
    

    

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More