R_DirectDebitMandateVersDrft

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

Data for DDM Versions

R_DirectDebitMandateVersDrft is a Basic CDS View that provides data about "Data for DDM Versions" in SAP S/4HANA. It reads from 1 data source (fin_dd_vers_d) and exposes 95 fields with key field DirectDebitMandateUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
fin_dd_vers_d fin_dd_vers_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 DDM Versions 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 DirectDebitMandateUUID directdebitmandateuuid Mandate GUID
ParentDraftUUID parentdraftuuid NodeID
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
MandateValidityDateStartDate mandatevaliditydatestartdate Valid From
MandateValidityEndDate mandatevalidityenddate Valid To
MandateStatus mandatestatus Status
MandateStatusCriticality mandatestatuscriticality
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_DirectDebitMandateVersDrft.
-- 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_DirectDebitMandateVersDrft AS
SELECT
  DirectDebitMandateUUID,
  ParentDraftUUID,
  MandateApplication,
  OriginalMandate,
  OriginalMandateCreditor,
  DirectDebitMandate,
  MandateVersion,
  MandateSignatureLocation,
  MandateSignatureDate,
  MandatePaymentType,
  MandateValidityDateStartDate,
  MandateValidityEndDate,
  MandateStatus,
  MandateStatusCriticality,
  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_vers_d
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More