I_PaymentCardMasterTmpTP

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CCARD Master interim'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@Search.searchable: true

@VDM.viewType: #TRANSACTIONAL

define view entity I_PaymentCardMasterTmpTP 
as select from I_PaymentCardMasterTP_2 as PaymentCardMaster

//association [1] to  

//inner join 

inner join I_PaymentCardTP_2 as _PaymentCard1 on 
                                                    _PaymentCard1.PaymentCardType = _PaymentCard1.PaymentCardType
                                                    and _PaymentCard1.PaymentCardID = _PaymentCard1.PaymentCardID
                                                    
association to parent I_PaymentCardTP_2 as _PaymentCard on $projection.PaymentCardNumber = _PaymentCard.CardNumber
                                                    and $projection.PaymentCardType = _PaymentCard.PaymentCardType
                                                    and $projection.BusinessPartner = _PaymentCard.BusinessPartner
                                                    and $projection.PaymentCardID = _PaymentCard.PaymentCardID
//                                                    and $projection.BPDrftUUID = paymentcard.BPDrftUUID

//                                                    and $projection.BPPaymentCardDrftUUID = paymentcard.BPPaymentCardDrftUUID

                                                    

association [1..1] to I_BusinessPartnerTP_2  as _BusinessPartner on         
                                                                 $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                 and $projection.BPDrftUUID      = _BusinessPartner.BPDrftUUID

                                                                 

association [1] to I_PaymentCardMasterTP_2 as _PaymentCardMasterTmp on 
// $projection.BPDrftUUID       = _PaymentCardMasterTmp.BPDrftUUID

//                                                                 and $projection.PayCardDrftUUID  = _PaymentCardMasterTmp.PayCardDrftUUID

                                                                  $projection.PaymentCardType  = _PaymentCardMasterTmp.PaymentCardType
                                                                 and $projection.PaymentCardNumber = _PaymentCardMasterTmp.PaymentCardNumber 

                                                                 
{
//    key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

//    key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPPaymentCardDrftUUID,

//    key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as PayCardDrftUUID,

    key PaymentCardMaster.PaymentCardType,
    key PaymentCardMaster.PaymentCardNumber,
    //key cast ('' as bu_partner) as BusinessPartner,

    key _PaymentCard1.BusinessPartner,
    key _PaymentCard1.PaymentCardID,
    
    PaymentCardMaster.PaymentCardTypeForEdit,
    PaymentCardMaster.PaymentCardNumberForEdit,
    PaymentCardMaster.ValidityDate,
    PaymentCardMaster.ValidityEndDate,
    PaymentCardMaster.CardHolder,
    PaymentCardMaster.PaymentCardCategory,
    PaymentCardMaster.CardIssuingBank,
    PaymentCardMaster.CardIssueDate,
    PaymentCardMaster.PaymentCardLock,
    PaymentCardMaster.MaskedCardNumber,
        
        _BusinessPartner,
        _PaymentCard,
        _PaymentCardMasterTmp,
       //PaymentCardMaster._PaymentCardLock,

       PaymentCardMaster._PaymentCardTypeText,
       PaymentCardMaster._Text
       
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PAYMENTCARDMASTERTP_2",
"I_PAYMENTCARDTP_2"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP_2",
"I_PAYMENTCARDLOCKTEXT",
"I_PAYMENTCARDMASTERTP_2",
"I_PAYMENTCARDTP_2",
"I_PAYMENTCARDTYPETEXT"
],
"BASE":
[
"I_PAYMENTCARDMASTERTP_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/