C_DspPaytCardCustomerCard

DDL: C_DSPPAYTCARDCUSTOMERCARD Type: view CONSUMPTION Package: ODATA_DISP_PAYMENT_CARD_DATA

Payment Card - Customer Contact Card

C_DspPaytCardCustomerCard is a Consumption CDS View that provides data about "Payment Card - Customer Contact Card" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 24 fields with key field Customer. It is exposed through 3 OData services (MANAGEPROJBILLGREQUEST_SD, PROJECTBILLINGREQUEST_SD, UI_PROJECTBILLINGREQUEST). Part of development package ODATA_DISP_PAYMENT_CARD_DATA.

Data Sources (1)

SourceAliasJoin Type
I_Customer Customer from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CDPCDCUSCNTCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Payment Card - Customer Contact Card view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
VDM.viewType #CONSUMPTION view
VDM.private false view
Consumption.ranked true view

OData Services (3)

ServiceBindingVersionContractRelease
MANAGEPROJBILLGREQUEST_SD UI_MNGPROJBILLGREQ_SB_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE
PROJECTBILLINGREQUEST_SD UI_PROJBILLGREQUEST_SB_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_PROJECTBILLINGREQUEST UI_PROJECTBILLINGREQUEST V4 C1 NOT_RELEASED

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer
FullName BPCustomerFullName
AuthorizationGroup I_Customer AuthorizationGroup
CustomerAccountGroup I_Customer CustomerAccountGroup
ADDRESSBPAddrStreetNameasStreetName
HouseNumber
CityName BPAddrCityName
PostalCode I_Customer PostalCode
Country
PhoneNumberasPhoneNumber
MobilePhoneNumber
EmailAddress Email
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
@AbapCatalog: {
    sqlViewName: 'CDPCDCUSCNTCT',
    compiler.compareFilter: true
}
@AccessControl: {
    authorizationCheck: #CHECK,
    personalData.blocking: #REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Payment Card - Customer Contact Card'

@ObjectModel.usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory: #L
}
@Search.searchable: true
@VDM: {
    viewType: #CONSUMPTION,
    private: false
}
@Consumption.ranked: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view C_DspPaytCardCustomerCard
  as select from I_Customer as Customer
{
      @Semantics.contact.type: #ORGANIZATION
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.85,
        ranking: #HIGH
      }
      @ObjectModel.text.element:  [ 'FullName' ]
  key Customer.Customer,

      @Semantics.name.fullName: true
      BPCustomerFullName as FullName,
      
      @UI.hidden: true
      Customer.AuthorizationGroup,

      @UI.hidden: true
      Customer.CustomerAccountGroup,

      -- ADDRESS

      @Semantics.address: {
        type:  [ #WORK ],
        street: true
      }
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.85,
        ranking: #LOW
      }
      @EndUserText.quickInfo: 'Street'
      BPAddrStreetName as StreetName,

      @Semantics.address: {
        type:  [ #WORK ],
        streetNoNumber: true
      }
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 1,
        ranking: #LOW
      }
      Customer._StandardAddress.HouseNumber,

      @Semantics.address: {
        type:  [ #WORK ],
        city: true
      }
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.85,
        ranking: #LOW
      }
      BPAddrCityName as CityName,

      @Semantics.address: {
        type:  [ #WORK ],
        zipCode: true
      }
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 1,
        ranking: #LOW
      }
      Customer.PostalCode,

      @Semantics.address: {
        type:  [ #WORK ],
        country: true
      }
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.90,
        ranking: #LOW
      }
      cast(Customer.Country as paymentcardcountryregion preserving type ) as Country,

      -- END ADDRESS


      @Semantics.telephone.type:  [ #WORK ]
      @Consumption.filter.hidden: true
      Customer._StandardAddress._DefaultPhoneNumber.PhoneNumber       as PhoneNumber,

      @Semantics.telephone.type:  [ #CELL ]
      @Consumption.filter.hidden: true
      Customer._StandardAddress._DefaultMobilePhoneNumber.PhoneNumber as MobilePhoneNumber,

      @EndUserText.label: 'Email'      
      @Semantics.eMail.type:  [ #WORK ]
      @Consumption.filter.hidden: true
      Customer._StandardAddress._DefaultCorpEmailAddress.EmailAddress     as EmailAddress,
      
      // Fields added For Data Controller in DCL .... NOT TO BE CONSUMED.

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataControllerSet,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController1,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController2,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController3,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController4,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController5,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController6,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController7,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController8,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController9,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController10,

      @UI.hidden: true
      @Consumption.filter.hidden: true      
      IsBusinessPurposeCompleted
      
}