I_WrntyOutputManagement

@AbapCatalog.sqlViewName: 'IWRNTYOPMGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Warranty Claim Output Management'
@VDM.viewType: #COMPOSITE
@ObjectModel:{
    representativeKey: 'ExternalDocumentID',
    usageType:{
        dataClass       : #TRANSACTIONAL,
        serviceQuality  : #C,
        sizeCategory    : #L
        }
}
define view I_WrntyOutputManagement

  //  as select from I_WrntyClaimVersion

  //  association [0..1] to I_SalesOrganization as _SalesOrganization on $projection.SalesOrganization = _SalesOrganization.SalesOrganization

  //{

  //  key    cast(  concat(CONCAT(_WrntyClaimHeader.WarrantyClaimNumber ,'-') ,WrntyVersionNumber )   as abap.char( 40 )       ) as ExternalDocumentID,

  //         _WrntyClaimHeader.WarrantyClaimNumber,

  //         WrntyVersionUUID,

  //         PurchasingOrganization,

  //         SalesOrganization,

  //         _WrntyClaimHeader.Plant,

  //         _WrntyClaimHeader.WarrantyClaimType,

  ////         _WrntyClaimHeader.WrntyClaimProcessingStatus,

  //         _WrntyClaimHeader.WrntySuplrClmProcessingStatus,

  //         WrntyClaimHeaderUUID,

  //         WrntyVersionNumber,

  //         _SalesOrganization

  //}


  //union

  as select from I_WrntyClaimHeader  as _WrntyClaimHeader
    inner join   I_WrntyClaimVersion as _WrntyClaimVersion on _WrntyClaimHeader.WrntyClaimHeaderUUID = _WrntyClaimVersion.WrntyClaimHeaderUUID
  //association [1..1] to I_WrntyClaimActvVersion as _WrntyClaimActvVersion on $projection.WrntyClaimHeaderUUID = _WrntyClaimActvVersion.WrntyClaimHeaderUUID

  association [0..1] to I_SalesOrganization as _SalesOrganization on $projection.SalesOrganization = _SalesOrganization.SalesOrganization
{
     key   _WrntyClaimVersion.WarrantyVersionRprstvID as ExternalDocumentID,
        _WrntyClaimHeader.WarrantyClaimNumber,
        _WrntyClaimVersion.WrntyVersionNumber      as WrntyVersionNumber,
        _WrntyClaimHeader.WrntyClaimHeaderUUID     as WrntyVersionUUID,
        _WrntyClaimVersion.PurchasingOrganization  as PurchasingOrganization,
        _WrntyClaimVersion.SalesOrganization       as SalesOrganization,
        _WrntyClaimVersion.DistributionChannel     as DistributionChannel,
        _WrntyClaimVersion.Division                as Division,
        _WrntyClaimHeader.Plant,
        _WrntyClaimHeader.WrntySupplier,
        _WrntyClaimHeader.WrntySupplierRole,
        _WrntyClaimHeader.WarrantyClaimType,
        _WrntyClaimHeader.WrntySupplierClaimGroup,
        _WrntyClaimHeader.WrntySuplrClmProcessingStatus,
        _WrntyClaimHeader.WrntyClaimHeaderUUID,
        _WrntyClaimVersion.WrntyDecisionCode,
        _WrntyClaimVersion.WarrantyClaimVersionCategory,
        _SalesOrganization

} where _WrntyClaimVersion.WarrantyVersionRprstvID is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WRNTYCLAIMHEADER",
"I_WRNTYCLAIMVERSION"
],
"ASSOCIATED":
[
"I_SALESORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/