A_DirectDebitMandateTP

DDL: A_DIRECTDEBITMANDATETP Type: view_entity CONSUMPTION Package: RAP_FIN_CA_DDM_MANDATE_API
52 Fields 1 Data Sources 2 OData Services

Direct Debit Mandate

A_DirectDebitMandateTP is a Consumption CDS View that provides data about "Direct Debit Mandate" in SAP S/4HANA. It reads from 1 data source (R_DirectDebitMandateTP) and exposes 52 fields with key fields MandateApplication, OriginalMandate, OriginalMandateCreditor. It is exposed through 2 OData services (API_DIRECTDEBITMANDATE, ASQL_F9162). Part of development package RAP_FIN_CA_DDM_MANDATE_API.

Data Sources (1)

SourceAliasJoin Type
R_DirectDebitMandateTP R_DirectDebitMandateTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Direct Debit Mandate view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name DirectDebitMandate_Type view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
API_DIRECTDEBITMANDATE API_DIRECTDEBITMANDATE V4 C2 C1
ASQL_F9162 ASQL_F9162 C2 NOT_RELEASED

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY MandateApplication MandateApplication Application
KEY OriginalMandate OriginalMandate Orig. Mandate
KEY OriginalMandateCreditor OriginalMandateCreditor Origin. Cred.
DirectDebitMandate DirectDebitMandate Mandate Ref.
SenderCountryOrRegion SenderCountryOrRegion Country/Reg.
MandateDirectDebitProcedure MandateDirectDebitProcedure DD Procedure
MandateSignatureLocation MandateSignatureLocation Location
MandateSignatureDate MandateSignatureDate Signature
MandatePaymentType MandatePaymentType Payment Type
MandateValidityDateStartDate MandateValidityDateStartDate Valid From
MandateValidityEndDate MandateValidityEndDate Valid To
MandateStatus MandateStatus Status
MandateIsB2BMandate MandateIsB2BMandate B2B Mandate
MandateStatusChangeReason MandateStatusChangeReason ReasonForChange
MandateCreatedByUser MandateCreatedByUser Creator
MandateCreationDate MandateCreationDate Created On
MandateCreationTime MandateCreationTime Created At
ContractAccount ContractAccount Contract Acct
ContractAccountExtReference ContractAccountExtReference CAcctLegacySys
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem External Number
SenderLastName SenderLastName Last Name
SenderFirstName SenderFirstName First Name
SenderStreetName SenderStreetName Street
SenderHouseNumber SenderHouseNumber House Number
SenderPostalCode SenderPostalCode Postal Code
SenderCityName SenderCityName City
SenderCountry SenderCountry Country/Reg.
MandateSenderIBAN MandateSenderIBAN IBAN
MandateSenderBankSWIFTCode MandateSenderBankSWIFTCode SWIFT/BIC
BankCountry BankCountry Bank Ctry/Rgn. Key
PayingBankKey PayingBankKey Bank Key
BankAccount BankAccount Bank acct
BankControlKey BankControlKey Control Key
ReferenceBankDetails ReferenceBankDetails Reference
SenderLanguage SenderLanguage Language
MandateAlternativeDebtor MandateAlternativeDebtor ID Alt. Debtor
RecipientName1 RecipientName1 Name 1
RecipientName2 RecipientName2 Name 2
MandateCreditor MandateCreditor Creditor ID
RecipientStreetName RecipientStreetName Street
RecipientHouseNumber RecipientHouseNumber House Number
RecipientPostalCode RecipientPostalCode Postal Code
RecipientCityName RecipientCityName City
RecipientCountry RecipientCountry Country/Reg.
ShortKeyHouseBank ShortKeyHouseBank House Bank
AccountDetails AccountDetails Account ID
MandateFirstUseDate MandateFirstUseDate Date
MandateLastUseDate MandateLastUseDate Date
_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_DirectDebitMandateTP.
-- 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.

CREATE VIEW A_DirectDebitMandateTP AS
SELECT
  MandateApplication,
  OriginalMandate,
  OriginalMandateCreditor,
  DirectDebitMandate,
  SenderCountryOrRegion,
  MandateDirectDebitProcedure,
  MandateSignatureLocation,
  MandateSignatureDate,
  MandatePaymentType,
  MandateValidityDateStartDate,
  MandateValidityEndDate,
  MandateStatus,
  MandateIsB2BMandate,
  MandateStatusChangeReason,
  MandateCreatedByUser,
  MandateCreationDate,
  MandateCreationTime,
  ContractAccount,
  ContractAccountExtReference,
  CAContract,
  CASubApplication,
  BusinessPartner,
  BusinessPartnerIDByExtSystem,
  SenderLastName,
  SenderFirstName,
  SenderStreetName,
  SenderHouseNumber,
  SenderPostalCode,
  SenderCityName,
  SenderCountry,
  MandateSenderIBAN,
  MandateSenderBankSWIFTCode,
  BankCountry,
  PayingBankKey,
  BankAccount,
  BankControlKey,
  ReferenceBankDetails,
  SenderLanguage,
  MandateAlternativeDebtor,
  RecipientName1,
  RecipientName2,
  MandateCreditor,
  RecipientStreetName,
  RecipientHouseNumber,
  RecipientPostalCode,
  RecipientCityName,
  RecipientCountry,
  ShortKeyHouseBank,
  AccountDetails,
  MandateFirstUseDate,
  MandateLastUseDate
FROM R_DirectDebitMandateTP
;

Learn More