C_BankAccSignatureCard

DDL: C_BANKACCSIGNATURECARD SQL: CBANKACCSIGCARD Type: view CONSUMPTION Package: FCLM_BAM_OBSOLETE
12 Fields 1 Data Sources 3 Associations

Bank Account Signature Card

C_BankAccSignatureCard is a Consumption CDS View that provides data about "Bank Account Signature Card" in SAP S/4HANA. It reads from 1 data source (I_SignCardAcctLinkage) and exposes 12 fields with key fields BankAccountInternalID, SignatoryCardID, MandateHolderName. It has 3 associations to related views. Part of development package FCLM_BAM_OBSOLETE.

Data Sources (1)

SourceAliasJoin Type
I_SignCardAcctLinkage I_SignCardAcctLinkage from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SignatoryCard _Card $projection.SignatoryCardID = _Card.SignatoryCardID
[0..*] I_SignatoryCardMandtHldr _Cardhead $projection.SignatoryCardID = _Cardhead.SignatoryCardID
[0..*] I_SignatoryCardChannel _CardChannel $projection.SignatoryCardID = _CardChannel.SignatoryCardID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CBANKACCSIGCARD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Signature Card view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
KEY SignatoryCardID I_SignCardAcctLinkage SignatoryCardID Signatory Card ID
KEY MandateHolderName _Cardhead MandateHolderName
ChannelDescription _CardChannel ChannelDescription
MaxSinglePaymentAmount _Cardhead MaxSinglePaymentAmount
SinglePaymentCurrency _Cardhead SinglePaymentCurrency Single Payment Currency
SinglePaymentNotLimited _Cardhead SinglePaymentNotLimited Single Payment Not Limited
MaxBatchPaymentAmount _Cardhead MaxBatchPaymentAmount
BatchPaymentCurrency _Cardhead BatchPaymentCurrency Batch Payment Currency
BatchPaymentNotLimited _Cardhead BatchPaymentNotLimited Batch Payment Not Limited
ValidityStartDate _Card ValidityStartDate Validity Start Date
ValidityEndDate _Card ValidityEndDate ValidTo

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 C_BankAccSignatureCard.
-- 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: CBANKACCSIGCARD

CREATE VIEW C_BankAccSignatureCard AS
SELECT
  BankAccountInternalID,
  I_SignCardAcctLinkage.SignatoryCardID AS SignatoryCardID,
  _Cardhead.MandateHolderName AS MandateHolderName,
  _CardChannel.ChannelDescription AS ChannelDescription,
  _Cardhead.MaxSinglePaymentAmount AS MaxSinglePaymentAmount,
  _Cardhead.SinglePaymentCurrency AS SinglePaymentCurrency,
  _Cardhead.SinglePaymentNotLimited AS SinglePaymentNotLimited,
  _Cardhead.MaxBatchPaymentAmount AS MaxBatchPaymentAmount,
  _Cardhead.BatchPaymentCurrency AS BatchPaymentCurrency,
  _Cardhead.BatchPaymentNotLimited AS BatchPaymentNotLimited,
  _Card.ValidityStartDate AS ValidityStartDate,
  _Card.ValidityEndDate AS ValidityEndDate
FROM I_SignCardAcctLinkage
LEFT OUTER JOIN I_SignatoryCard AS _Card ON SignatoryCardID = _Card.SignatoryCardID  -- association [0..1]
LEFT OUTER JOIN I_SignatoryCardMandtHldr AS _Cardhead ON SignatoryCardID = _Cardhead.SignatoryCardID  -- association [0..*]
LEFT OUTER JOIN I_SignatoryCardChannel AS _CardChannel ON SignatoryCardID = _CardChannel.SignatoryCardID  -- association [0..*]
;

Learn More