C_SlsDocFlfmtMfgOrderContacts

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S

@EndUserText.label: 'Sales Doc Fulfillment: MFG Order Contacts'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'CSOFMFGORDERCONT'

define view C_SlsDocFlfmtMfgOrderContacts

  as select distinct from I_PMContactCardUser      as ContactCardUser
    inner join            I_MRPController          as MRPController on ContactCardUser.UserID      = MRPController.UserID
    inner join            I_MfgOrder               as Header        on MRPController.MRPController = Header.MRPController
                                                                
   association [0..*] to I_MfgOrderObjPgContTypeText as _MfgOrderObjPgContTypeText on $projection.PartnerFunction = _MfgOrderObjPgContTypeText.InteractionContactType
                                                                                                                        
{ 
    key   Header.ManufacturingOrder            as ManufacturingOrder,
   
    @ObjectModel.text.association: '_MfgOrderObjPgContTypeText'   
    key   cast( '03' as parvw )                as   PartnerFunction,                        // 03=MRP Controller

    
        ContactCardUser.UserID,
 
        cast( ContactCardUser.FullName
        as ad_namtext )                      as   FullName,
        cast ( ContactCardUser.LastName  
        as ad_namelas )                      as   FamilyName,
        cast ( ContactCardUser.FirstName 
        as ad_namefir )                      as   FirstName,
//        @UI.lineItem: [{position:30}]

        cast( ContactCardUser.EmailAddress
        as ad_smtpadr )                      as   EmailAddress,
//        @UI.lineItem: [{position:40}]

//        @EndUserText.label: 'Telephone Number'

        cast ( ContactCardUser.InternationalPhoneNumber
        as ad_tlnmbr )                       as   PhoneNumber,
//        @UI.lineItem: [{position:50}]

//        @EndUserText.label: 'Mobile Phone Number'

        cast ( ContactCardUser.InternationalMobilePhoneNumber
        as ad_mbnmbr1 )                      as   MobilePhoneNumber, 
        
        Header.ManufacturingOrderCategory,
        Header.ManufacturingOrderType,
        Header.ProductionPlant,
       
       @Consumption.filter.hidden: true
       _MfgOrderObjPgContTypeText      
   
}
where
  ContactCardUser.UserID = _MRPController.UserID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDER",
"I_MRPCONTROLLER",
"I_PMCONTACTCARDUSER"
],
"ASSOCIATED":
[
"I_MFGORDEROBJPGCONTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/