C_PaymentCardMaster

DDL: C_PAYMENTCARDMASTER SQL: CPCARDMASTER Type: view CONSUMPTION

Consumption view for payment card table

C_PaymentCardMaster is a Consumption CDS View that provides data about "Consumption view for payment card table" in SAP S/4HANA. It reads from 1 data source (I_PaymentCardMasterTP) and exposes 11 fields with key fields PaymentCardNumber, PaymentCardType. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_PaymentCardMasterTP CardDetails from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PaymentCardLock _PaymentCardLock $projection.PaymentCardLock = _PaymentCardLock.PaymentCardLock

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPCARDMASTER view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view for payment card table view
Metadata.allowExtensions true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PaymentCardNumber I_PaymentCardMasterTP PaymentCardNumber
KEY PaymentCardType I_PaymentCardMasterTP PaymentCardType
CardHolder I_PaymentCardMasterTP CardHolder
CardIssueDate I_PaymentCardMasterTP CardIssueDate
CardIssuingBank I_PaymentCardMasterTP CardIssuingBank
PaymentCardCategory I_PaymentCardMasterTP PaymentCardCategory
PaymentCardLock I_PaymentCardMasterTP PaymentCardLock
ValidityDate I_PaymentCardMasterTP ValidityDate
ValidityEndDate I_PaymentCardMasterTP ValidityEndDate
MaskedCardNumber I_PaymentCardMasterTP MaskedCardNumber
_PaymentCardLock _PaymentCardLock 
@AbapCatalog.sqlViewName: 'CPCARDMASTER'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Consumption view for payment card  table'

@Metadata.allowExtensions: true

@ObjectModel.compositionRoot: true
@ObjectModel.draftEnabled: true
@ObjectModel: {
    semanticKey: ['PaymentCardNumber','PaymentCardType' ],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.transactionalProcessingDelegated: true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@VDM.viewType: #CONSUMPTION

define view C_PaymentCardMaster
  as select from I_PaymentCardMasterTP as CardDetails

  association [0..1] to I_PaymentCardLock as _PaymentCardLock on $projection.PaymentCardLock = _PaymentCardLock.PaymentCardLock
    
{
  key CardDetails.PaymentCardNumber,
  key CardDetails.PaymentCardType,
      CardDetails.CardHolder,
      CardDetails.CardIssueDate,
      CardDetails.CardIssuingBank,
      CardDetails.PaymentCardCategory,
      @ObjectModel: {
                 foreignKey.association: '_PaymentCardLock'
               }
      CardDetails.PaymentCardLock,
      CardDetails.ValidityDate,
      @ObjectModel.readOnly: true
      CardDetails.ValidityEndDate,
      @ObjectModel.readOnly: true
      CardDetails.MaskedCardNumber,

      _PaymentCardLock
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PAYMENTCARDMASTERTP"
],
"ASSOCIATED":
[
"I_PAYMENTCARDLOCK"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More