R_DirectDebitMandateTP

DDL: R_DIRECTDEBITMANDATETP Type: view_entity TRANSACTIONAL
114 Fields 1 Data Sources 1 Associations

Direct Debit Mandate TP

R_DirectDebitMandateTP is a Transactional CDS View that provides data about "Direct Debit Mandate TP" in SAP S/4HANA. It reads from 1 data source (P_DirectDebitMandate) and exposes 114 fields with key fields MandateApplication, OriginalMandate, OriginalMandateCreditor. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_DirectDebitMandate P_DirectDebitMandate from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_DirectDebitMandtInstrnTP _DirectDebitMandtInstrn

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Direct Debit Mandate TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name DirectDebitMandate view

Fields (114)

KeyFieldSource TableSource FieldDescription
KEY MandateApplication MandateApplication Application
KEY OriginalMandate OriginalMandate Orig. Mandate
KEY OriginalMandateCreditor OriginalMandateCreditor Origin. Cred.
TemporaryMandateApplication TemporaryMandateApplication Application
DirectDebitMandateUUID DirectDebitMandateUUID Mandate GUID
DirectDebitMandate DirectDebitMandate Mandate Ref.
MandateVersion MandateVersion Mandate Version
MandateSignatureLocation MandateSignatureLocation Location
MandateSignatureDate MandateSignatureDate Signature
MandatePaymentType MandatePaymentType Payment Type
MandateValidityDateStartDate MandateValidityDateStartDate Valid From
MandateValidityEndDate MandateValidityEndDate Valid To
MandateStatus MandateStatus Status
MandateStatusCriticality MandateStatusCriticality
MandateIsB2BMandate MandateIsB2BMandate B2B Mandate
MandateStatusChangeReason MandateStatusChangeReason ReasonForChange
MandateCreatedByUser MandateCreatedByUser Creator
MandateCreationDate MandateCreationDate Created On
MandateCreationTime MandateCreationTime Created At
LastChangeDateTime Created At
LocalLastChangeDateTime Created At
DirectDebitMandateChangeReason DirectDebitMandateChangeReason ReasonForChange
MandateIsLocked MandateIsLocked Global Lock
IDOriginalMandateCreatedByUser IDOriginalMandateCreatedByUser Created (Orig)
OriglMandateCreationDate OriglMandateCreationDate Created On
OriglMandateCreationTime OriglMandateCreationTime Created At
MandateReferenceType MandateReferenceType Reference Type
MandateReference MandateReference Reference ID
MandateReferenceDesc MandateReferenceDesc Explanation
MandateSenderType MandateSenderType Sender Type
MandateSender MandateSender ID of Sender
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
SenderLanguage SenderLanguage Language
MandateAlternativeDebtor MandateAlternativeDebtor ID Alt. Debtor
MandateRecipientType MandateRecipientType Recipient Type
MandateRecipient MandateRecipient Recipient ID
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.
MandateAlternativePayeeName MandateAlternativePayeeName Name Alt. Payee
MandateAlternativePayee MandateAlternativePayee ID Alt. Payee
MandateFirstUseDate MandateFirstUseDate Date
MandateFirstUseObjTypeCode MandateFirstUseObjTypeCode Type of First Usage
MandateFirstUseInPaymentDoc MandateFirstUseInPaymentDoc Key
MandateLastUseDate MandateLastUseDate Date
MandateLastUseObjTypeCode MandateLastUseObjTypeCode Type of Last Usage
MandateLastUseInPaymentDoc MandateLastUseInPaymentDoc ID of Last Usage
MandateFirstUsePaymentRun MandateFirstUsePaymentRun First Payment Run
MandateOrganizationalUnit1 MandateOrganizationalUnit1 Organization ID
MandateOrganizationalUnit2 MandateOrganizationalUnit2 Organization ID
MandateOrganizationalUnit3 MandateOrganizationalUnit3 Organization
MandateOrganizationalUnit4 MandateOrganizationalUnit4 Organization
SenderCountryOrRegion SenderCountryOrRegion Country/Reg.
MandateDirectDebitProcedure MandateDirectDebitProcedure DD Procedure
BankCountry BankCountry Bank Ctry/Rgn. Key
PayingBankKey PayingBankKey Bank Key
BankAccount BankAccount Bank acct
BankControlKey BankControlKey Control Key
ReferenceBankDetails ReferenceBankDetails Reference
ShortKeyHouseBank ShortKeyHouseBank House Bank
AccountDetails AccountDetails Account ID
PayingCompanyCode PayingCompanyCode Paying Company Code
Customer Customer Sold-to Party
MandateContractType MandateContractType Contr. Type
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
InputFiscalYear InputFiscalYear Fiscal Year
BusinessPartner BusinessPartner Issuing Authority
CAContract CAContract Contract
ContractAccount ContractAccount Contract Acct
CASubApplication CASubApplication Subapplication
MandateStatusName MandateStatusName Short Description
MandateStatusChangeReasonName MandateStatusChangeReasonName Description
MandateApplicationText
MandatePaymentTypeName
_Application _Application
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_CreatedByUser _CreatedByUser
_Customer _Customer
_FirstUseObjTypeText _FirstUseObjTypeText
_LastUseObjTypeText _LastUseObjTypeText
_MandateChangeReason _MandateChangeReason
_SEPAMandateStatus _SEPAMandateStatus
_OriglCreatedByUser _OriglCreatedByUser
_PayingCompanyCode _PayingCompanyCode
_PaymentType _PaymentType
_RecipientTypeText _RecipientTypeText
_ReferenceTypeText _ReferenceTypeText
_SenderTypeText _SenderTypeText
_SenderCountryText _SenderCountryText
_PayerCountryText _PayerCountryText
_RecipientCountryText _RecipientCountryText
_DirectDebitMandtInstrn _DirectDebitMandtInstrn
_ContractAccountText _ContractAccountText
_ProviderContractText _ProviderContractText
_CASubApplicationText _CASubApplicationText
_MandateApplicationText _MandateApplicationText
_MandatePaymentTypeText _MandatePaymentTypeText
_SEPAMandateStatusText _SEPAMandateStatusText
_MandateChangeReasonText _MandateChangeReasonText

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 R_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 R_DirectDebitMandateTP AS
SELECT
  MandateApplication,
  OriginalMandate,
  OriginalMandateCreditor,
  TemporaryMandateApplication,
  DirectDebitMandateUUID,
  DirectDebitMandate,
  MandateVersion,
  MandateSignatureLocation,
  MandateSignatureDate,
  MandatePaymentType,
  MandateValidityDateStartDate,
  MandateValidityEndDate,
  MandateStatus,
  MandateStatusCriticality,
  MandateIsB2BMandate,
  MandateStatusChangeReason,
  MandateCreatedByUser,
  MandateCreationDate,
  MandateCreationTime,
  cast( MandateCreationTime as timestampl ) AS LastChangeDateTime,
  cast( MandateCreationTime as timestampl ) AS LocalLastChangeDateTime,
  DirectDebitMandateChangeReason,
  MandateIsLocked,
  IDOriginalMandateCreatedByUser,
  OriglMandateCreationDate,
  OriglMandateCreationTime,
  MandateReferenceType,
  MandateReference,
  MandateReferenceDesc,
  MandateSenderType,
  MandateSender,
  SenderLastName,
  SenderFirstName,
  SenderStreetName,
  SenderHouseNumber,
  SenderPostalCode,
  SenderCityName,
  SenderCountry,
  MandateSenderIBAN,
  MandateSenderBankSWIFTCode,
  SenderLanguage,
  MandateAlternativeDebtor,
  MandateRecipientType,
  MandateRecipient,
  RecipientName1,
  RecipientName2,
  MandateCreditor,
  RecipientStreetName,
  RecipientHouseNumber,
  RecipientPostalCode,
  RecipientCityName,
  RecipientCountry,
  MandateAlternativePayeeName,
  MandateAlternativePayee,
  MandateFirstUseDate,
  MandateFirstUseObjTypeCode,
  MandateFirstUseInPaymentDoc,
  MandateLastUseDate,
  MandateLastUseObjTypeCode,
  MandateLastUseInPaymentDoc,
  MandateFirstUsePaymentRun,
  MandateOrganizationalUnit1,
  MandateOrganizationalUnit2,
  MandateOrganizationalUnit3,
  MandateOrganizationalUnit4,
  SenderCountryOrRegion,
  MandateDirectDebitProcedure,
  BankCountry,
  PayingBankKey,
  BankAccount,
  BankControlKey,
  ReferenceBankDetails,
  ShortKeyHouseBank,
  AccountDetails,
  PayingCompanyCode,
  Customer,
  MandateContractType,
  CompanyCode,
  AccountingDocument,
  InputFiscalYear,
  BusinessPartner,
  CAContract,
  ContractAccount,
  CASubApplication,
  MandateStatusName,
  MandateStatusChangeReasonName,
  _MandateApplicationText[1:Language =$session.system_language].SEPAMandateApplicationName AS MandateApplicationText,
  _MandatePaymentTypeText[1:Language =$session.system_language].SEPAPaymentTypeName AS MandatePaymentTypeName
FROM P_DirectDebitMandate
LEFT OUTER JOIN R_DirectDebitMandtInstrnTP AS _DirectDebitMandtInstrn ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More