C_DirectDebitMandateVersionTP

DDL: C_DIRECTDEBITMANDATEVERSIONTP Type: view_entity CONSUMPTION
162 Fields 1 Data Sources 1 OData Services

Direct Debit Mandate Version TP

C_DirectDebitMandateVersionTP is a Consumption CDS View that provides data about "Direct Debit Mandate Version TP" in SAP S/4HANA. It reads from 1 data source (R_DirectDebitMandateVersionTP) and exposes 162 fields with key field DirectDebitMandateUUID. It is exposed through 1 OData service (UI_DIRECTDEBITMANDATE_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_DirectDebitMandateVersionTP R_DirectDebitMandateVersionTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Direct Debit Mandate Version TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_DIRECTDEBITMANDATE_MANAGE UI_DIRECTDEBITMANDT_MANAGE_V4 V4 C1 NOT_RELEASED

Fields (162)

KeyFieldSource TableSource FieldDescription
KEY DirectDebitMandateUUID DirectDebitMandateUUID Mandate GUID
MandateApplication MandateApplication Application
OriginalMandate OriginalMandate Orig. Mandate
OriginalMandateCreditor OriginalMandateCreditor Origin. Cred.
DirectDebitMandate DirectDebitMandate Mandate Ref.
MandateVersion MandateVersion Mandate Version
MandateSignatureLocation MandateSignatureLocation Location
MandateSignatureDate MandateSignatureDate Signature
MandatePaymentType MandatePaymentType Payment Type
MandatePaymentTypeName MandatePaymentTypeName Description
MandateValidityDateStartDate MandateValidityDateStartDate Valid From
MandateValidityEndDate MandateValidityEndDate Valid To
MandateStatus MandateStatus Status
MandateStatusName MandateStatusName Short Description
MandateStatusCriticality MandateStatusCriticality
MandateIsB2BMandate MandateIsB2BMandate B2B Mandate
MandateStatusChangeReason MandateStatusChangeReason ReasonForChange
MandateStatusChangeReasonName MandateStatusChangeReasonName Description
MandateCreatedByUser MandateCreatedByUser Creator
MandateCreationDate MandateCreationDate Created On
MandateCreationTime MandateCreationTime Created At
DirectDebitMandateChangeReason DirectDebitMandateChangeReason ReasonForChange
MandateIsLocked MandateIsLocked Global Lock
MandateApplicationText MandateApplicationText Name
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
PayingCompanyCode PayingCompanyCode Paying Company Code
Customer Customer Sold-to Party
MandateContractType MandateContractType Contr. Type
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
CAContract CAContract Contract
CAProviderContractName _ProviderContractText CAProviderContractName
ContractAccount ContractAccount Contract Acct
ContractAccountName _ContractAccountText ContractAccountName Cont. acct name
SenderCountryOrRegion SenderCountryOrRegion Country/Reg.
MandateDirectDebitProcedure MandateDirectDebitProcedure DD Procedure
BankCountry BankCountry Bank Ctry/Rgn. Key
CountryName _PayerBankCountryText CountryName Country
PayingBankKey PayingBankKey Bank Key
BankAccount BankAccount Bank acct
BankControlKey BankControlKey Control Key
ReferenceBankDetails ReferenceBankDetails Reference
ShortKeyHouseBank ShortKeyHouseBank House Bank
AccountDetails AccountDetails Account ID
CASubApplication CASubApplication Subapplication
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
_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
_PayerBankCountryText _PayerBankCountryText
_ContractAccountText _ContractAccountText
_CASubApplicationText _CASubApplicationText

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_DirectDebitMandateVersionTP.
-- 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 C_DirectDebitMandateVersionTP AS
SELECT
  DirectDebitMandateUUID,
  MandateApplication,
  OriginalMandate,
  OriginalMandateCreditor,
  DirectDebitMandate,
  MandateVersion,
  MandateSignatureLocation,
  MandateSignatureDate,
  MandatePaymentType,
  MandatePaymentTypeName,
  MandateValidityDateStartDate,
  MandateValidityEndDate,
  MandateStatus,
  MandateStatusName,
  MandateStatusCriticality,
  MandateIsB2BMandate,
  MandateStatusChangeReason,
  MandateStatusChangeReasonName,
  MandateCreatedByUser,
  MandateCreationDate,
  MandateCreationTime,
  DirectDebitMandateChangeReason,
  MandateIsLocked,
  MandateApplicationText,
  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,
  PayingCompanyCode,
  Customer,
  MandateContractType,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  CAContract,
  _ProviderContractText.CAProviderContractName AS CAProviderContractName,
  ContractAccount,
  _ContractAccountText.ContractAccountName AS ContractAccountName,
  SenderCountryOrRegion,
  MandateDirectDebitProcedure,
  BankCountry,
  _PayerBankCountryText.CountryName AS CountryName,
  PayingBankKey,
  BankAccount,
  BankControlKey,
  ReferenceBankDetails,
  ShortKeyHouseBank,
  AccountDetails,
  CASubApplication,
  virtual UICT_BusinessPartner : abap.char(1) AS char1
FROM R_DirectDebitMandateVersionTP
;

Learn More