I_PaymentCardTP_2

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BP Payment Card TP view'
//@AccessControl.authorizationCheck: #CHECK

@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@Search.searchable: true

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true

define view entity I_PaymentCardTP_2 as select from I_Paymentcard 
association  to parent I_BusinessPartnerTP_2   as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                   and $projection.BPDrftUUID = _BusinessPartner.BPDrftUUID


 // association [1..1] to I_PAYMENTCARDMASTERTP_2 as _CardDetails     on  $projection.CardNumber      = _CardDetails.PaymentCardNumber

   //                                                               and $projection.PaymentCardType = _CardDetails.PaymentCardType

                                                                  
  composition [0..1] of I_PaymentCardMasterTmpTP as _CardMaster 
  association [0..1] to I_PaymentCardMasterTmpTP as _CardMasterDetails on $projection.CardNumber      = _CardMasterDetails.PaymentCardNumber
                                                                  and $projection.PaymentCardType = _CardMasterDetails.PaymentCardType                                                                  
                                                                    
{
//    key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

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

    key BusinessPartner,
    key PaymentCardID,
    key PaymentCardType,
    key CardNumber,
    PaymentCardID as PaymentCardForEditID,
    IsStandardCard,
    CardDescription,
    
    cast ('' as cc_issbank) as CardIssuingBank,
    cast ('' as cc_lock) as PaymentCardLock,
    cast ('' as ccname) as CardHolderName,
    cast ('00000000' as cc_datbi) as ValidityEndDate,
    cast ('' as dp_mask_number) as MaskedCardNumber,
    //_CardMasterDetails.CardIssuingBank,

    //_CardMasterDetails.PaymentCardLock,

    
    //cast ( '' as char1024 ) as Registration_URL,

    //cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as Session_ID,

    //cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as CARDMASTERDRAFTUUID,

    _BusinessPartner,
    //_CardDetails,

    _CardMaster,
    _CardMasterDetails
    //_CardMasterDetails._PaymentCardTypeText

    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PAYMENTCARD"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP_2",
"I_PAYMENTCARDMASTERTMPTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/