A_BusinessPartnerPaymentCard

DDL: A_BUSINESSPARTNERPAYMENTCARD SQL: ABPPAYMENTCARD Type: view BASIC
14 Fields 1 Data Sources

Business Partner Payment Card

A_BusinessPartnerPaymentCard is a Basic CDS View that provides data about "Business Partner Payment Card" in SAP S/4HANA. It reads from 1 data source (I_Paymentcard) and exposes 14 fields with key fields BusinessPartner, PaymentCardID, PaymentCardType, CardNumber.

Data Sources (1)

SourceAliasJoin Type
I_Paymentcard I_Paymentcard from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ABPPAYMENTCARD view
EndUserText.label Business Partner Payment Card view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY PaymentCardID PaymentCardID Card ID
KEY PaymentCardType PaymentCardType Payt Card Type
KEY CardNumber CardNumber Condition Contract
IsStandardCard IsStandardCard Standard Card
CardDescription CardDescription Description
ValidityDate _CardType ValidityDate Valid On
ValidityEndDate _CardType ValidityEndDate ValidTo
CardHolder _CardType CardHolder
CardIssuingBank _CardType CardIssuingBank
CardIssueDate _CardType CardIssueDate
PaymentCardLock _CardType PaymentCardLock
MaskedCardNumber _CardType MaskedCardNumber
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_BusinessPartnerPaymentCard.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ABPPAYMENTCARD

CREATE VIEW A_BusinessPartnerPaymentCard AS
SELECT
  BusinessPartner,
  PaymentCardID,
  PaymentCardType,
  CardNumber,
  IsStandardCard,
  CardDescription,
  _CardType.ValidityDate AS ValidityDate,
  _CardType.ValidityEndDate AS ValidityEndDate,
  _CardType.CardHolder AS CardHolder,
  _CardType.CardIssuingBank AS CardIssuingBank,
  _CardType.CardIssueDate AS CardIssueDate,
  _CardType.PaymentCardLock AS PaymentCardLock,
  _CardType.MaskedCardNumber AS MaskedCardNumber
FROM I_Paymentcard
;

Learn More