I_PaymentCardTP

DDL: I_PAYMENTCARDTP SQL: IBUPPAYCARDTP Type: view TRANSACTIONAL

Association view for BUT0CC table

I_PaymentCardTP is a Transactional CDS View that provides data about "Association view for BUT0CC table" in SAP S/4HANA. It reads from 1 data source (I_Paymentcard) and exposes 13 fields with key fields BusinessPartner, PaymentCardID, CardNumber, PaymentCardType. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_Paymentcard PaymentCard from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_PaymentCardMasterTP _CardDetails $projection.CardNumber = _CardDetails.PaymentCardNumber and $projection.PaymentCardType = _CardDetails.PaymentCardType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBUPPAYCARDTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Association view for BUT0CC table view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence BUPA_BUUT0CC_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_Paymentcard BusinessPartner
KEY PaymentCardID I_Paymentcard PaymentCardID
KEY CardNumber I_Paymentcard CardNumber
KEY PaymentCardType I_Paymentcard PaymentCardType
PaymentCardTypeForEdit I_Paymentcard PaymentCardType Payment Card Type
CardNumberForEdit I_Paymentcard CardNumber Card Number
PaymentCardIDForEdit I_Paymentcard PaymentCardID
CardDescription I_Paymentcard CardDescription
IsStandardCard I_Paymentcard IsStandardCard
AuthorizationGroup I_Paymentcard AuthorizationGroup
CollectionIsAuthorized I_Paymentcard CollectionIsAuthorized
_CardDetails _CardDetails
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IBUPPAYCARDTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Association view for BUT0CC table'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeDraftPersistence: 'BUPA_BUUT0CC_D'
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled

@ObjectModel.semanticKey:  [ 'BusinessPartner','PaymentCardID','CardNumber','PaymentCardType' ]

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
define view I_PaymentCardTP
  as select from I_Paymentcard as PaymentCard

  association [1..1] to I_BusinessPartnerTP   as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [1..1] to I_PaymentCardMasterTP as _CardDetails     on  $projection.CardNumber      = _CardDetails.PaymentCardNumber
                                                                  and $projection.PaymentCardType = _CardDetails.PaymentCardType

  // association [1..1] to I_PaymentCardTypeText     as _PaymentCardTypeText     on  $projection.PaymentCardType   = _PaymentCardTypeText.PaymentCardType

  //                                                                             and _PaymentCardTypeText.Language = $session.system_language

  //


{

  key        PaymentCard.BusinessPartner,

  key        PaymentCard.PaymentCardID,

             @ObjectModel.readOnly: true
             @ObjectModel.foreignKey.association: null
  key        PaymentCard.CardNumber,

             @ObjectModel.readOnly: true
             @ObjectModel.foreignKey.association: null
  key        PaymentCard.PaymentCardType,


             @EndUserText.label: 'Payment Card Type'
             @ObjectModel.foreignKey.association: '_CardDetails'
             PaymentCard.PaymentCardType as PaymentCardTypeForEdit,

             @EndUserText.label: 'Card Number'
             @ObjectModel.foreignKey.association: '_CardDetails'
             PaymentCard.CardNumber      as CardNumberForEdit,


             @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
             PaymentCard.PaymentCardID   as PaymentCardIDForEdit,


             PaymentCard.CardDescription,


             PaymentCard.IsStandardCard,

             PaymentCard.AuthorizationGroup,
             PaymentCard.CollectionIsAuthorized,

             //             _PaymentCardTypeText.CardTypeText,


             //  fallback approach starts

             //          _CardDetails.CardIssuingBank,

             //          _CardDetails.PaymentCardLock,

             //          _CardDetails.PaymentCardCategory,

             //         _CardDetails.ValidityEndDate,

             //fallback approach ends

             



             @ObjectModel.association.draft.enabled:true
             @ObjectModel.association.draft.fieldNamePrefix:'CARDDETAILS'
             _CardDetails,

             @ObjectModel.association.type: [#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT]
             _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PAYMENTCARD"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP",
"I_PAYMENTCARDMASTERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More