R_DirectDebitMandateDraft

DDL: R_DIRECTDEBITMANDATEDRAFT Type: view_entity BASIC
95 Fields 1 Data Sources 1 Associations

Data for Manage DDM

R_DirectDebitMandateDraft is a Basic CDS View that provides data about "Data for Manage DDM" in SAP S/4HANA. It reads from 1 data source (fin_dd_mandate_d) and exposes 95 fields with key fields MandateApplication, OriginalMandate, OriginalMandateCreditor, DraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
fin_dd_mandate_d fin_dd_mandate_d from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Data for Manage DDM view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (95)

KeyFieldSource TableSource FieldDescription
KEY MandateApplication mandateapplication Application
KEY OriginalMandate originalmandate Orig. Mandate
KEY OriginalMandateCreditor originalmandatecreditor Origin. Cred.
KEY DraftUUID draftuuid UUID
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
MandateStatusName mandatestatusname Short Description
MandateIsB2BMandate mandateisb2bmandate B2B Mandate
MandateStatusChangeReasonName mandatestatuschangereasonname Description
MandateStatusChangeReason mandatestatuschangereason ReasonForChange
MandateCreatedByUser mandatecreatedbyuser Creator
MandateCreationDate mandatecreationdate Created On
MandateCreationTime mandatecreationtime Created At
LastChangeDateTime lastchangedatetime Timestamp
LocalLastChangeDateTime locallastchangedatetime Time Stamp
DirectDebitMandateChangeReason directdebitmandatechangereason ReasonForChange
MandateIsLocked mandateislocked Global Lock
MandateApplicationText mandateapplicationtext Name
MandatePaymentTypeName mandatepaymenttypename Description
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
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_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 R_DirectDebitMandateDraft.
-- 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_DirectDebitMandateDraft AS
SELECT
  MandateApplication,
  OriginalMandate,
  OriginalMandateCreditor,
  DraftUUID,
  TemporaryMandateApplication,
  DirectDebitMandateUUID,
  DirectDebitMandate,
  MandateVersion,
  MandateSignatureLocation,
  MandateSignatureDate,
  MandatePaymentType,
  MandateValidityDateStartDate,
  MandateValidityEndDate,
  MandateStatus,
  MandateStatusName,
  MandateIsB2BMandate,
  MandateStatusChangeReasonName,
  MandateStatusChangeReason,
  MandateCreatedByUser,
  MandateCreationDate,
  MandateCreationTime,
  LastChangeDateTime,
  LocalLastChangeDateTime,
  DirectDebitMandateChangeReason,
  MandateIsLocked,
  MandateApplicationText,
  MandatePaymentTypeName,
  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,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM fin_dd_mandate_d
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More