R_SEPAMandateTP

DDL: R_SEPAMANDATETP Type: view_entity TRANSACTIONAL Package: BF_SEPA_EN
61 Fields 1 Data Sources

SEPA Mandate - TP

R_SEPAMandateTP is a Transactional CDS View that provides data about "SEPA Mandate - TP" in SAP S/4HANA. It reads from 1 data source (I_SEPAMandateBasic) and exposes 61 fields with key field SEPAMandateUUID. Part of development package BF_SEPA_EN.

Data Sources (1)

SourceAliasJoin Type
I_SEPAMandateBasic I_SEPAMandateBasic from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SEPA Mandate - TP view
ObjectModel.representativeKey SEPAMandateUUID view
ObjectModel.sapObjectNodeType.name SEPAMandate view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY SEPAMandateUUID SEPAMandateUUID Mandate ID
SEPAMandate SEPAMandate SEPA Mandate
SEPAMandateVersion SEPAMandateVersion Meas.plan.vers.
SEPASignatureCityName SEPASignatureCityName Location
SEPASignatureDate SEPASignatureDate Signature
SEPAPaymentType SEPAPaymentType Payment Type
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
SEPAMandateStatus SEPAMandateStatus Workflow Status
SEPAMandateIsB2BMandate SEPAMandateIsB2BMandate B2B Mandate
SEPAMandateStatusChangeReason SEPAMandateStatusChangeReason Return/Change Reason
SEPAMandateCreatedByUser SEPAMandateCreatedByUser User Name
SEPAMandateCreationDate SEPAMandateCreationDate Entered On
SEPAMandateCreationTime SEPAMandateCreationTime Time
SEPAMandateChangeReason SEPAMandateChangeReason ReasonForChange
OriginalSEPAMandateCreditor OriginalSEPAMandateCreditor Origin. Cred.
OriginalSEPAMandate OriginalSEPAMandate Orig. Mandate
SEPAMandateIsLocked SEPAMandateIsLocked Global Lock
SEPAMandateApplication SEPAMandateApplication Application
OriglSEPAMandateCreatedByUser OriglSEPAMandateCreatedByUser Created (Orig)
OriglSEPAMandateCreationDate OriglSEPAMandateCreationDate Created On
OriglSEPAMandateCreationTime OriglSEPAMandateCreationTime Created At
SEPAMandateReferenceType SEPAMandateReferenceType SettlmtRefDocCat
SEPAMandateReference SEPAMandateReference Technical Object
SEPAMandateReferenceDesc SEPAMandateReferenceDesc Explanation
SEPAMandateSenderType SEPAMandateSenderType SND/RCV type
SEPAMandateSender SEPAMandateSender 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.
SEPAMandateSenderIBAN SEPAMandateSenderIBAN IBAN
SEPAMandateSenderBankSWIFTCode SEPAMandateSenderBankSWIFTCode SWIFT/BIC
SenderLanguage SenderLanguage Language
SEPAMandateAlternativePayer SEPAMandateAlternativePayer ID Alt. Debtor
SEPAMandateRecipientType SEPAMandateRecipientType Totals rec.type
SEPAMandateRecipient SEPAMandateRecipient Record ID
RecipientName1 RecipientName1 Name 1
RecipientName2 RecipientName2 Name 2
SEPAMandateCreditor SEPAMandateCreditor Creditor ID
RecipientStreetName RecipientStreetName Street
RecipientHouseNumber RecipientHouseNumber House Number
RecipientPostalCode RecipientPostalCode Postal Code
RecipientCityName RecipientCityName City
RecipientCountry RecipientCountry Country/Reg.
SEPAMandateAlternativePyeName SEPAMandateAlternativePyeName Name Alt. Payee
SEPAMandateAlternativePayee SEPAMandateAlternativePayee ID Alt. Payee
SEPAMandateFirstUseDate SEPAMandateFirstUseDate Date
SEPAMandateFirstUseObjTypeCode SEPAMandateFirstUseObjTypeCode Type of First Usage
SEPAMandateFirstUsePaymentDoc SEPAMandateFirstUsePaymentDoc Key
SEPAMandateLastUseDate SEPAMandateLastUseDate Date
SEPAMandateLastUseObjTypeCode SEPAMandateLastUseObjTypeCode Type of Last Usage
SEPAMandateLastUsePaymentDoc SEPAMandateLastUsePaymentDoc ID of Last Usage
SEPAMandateFirstUsePaymentRun SEPAMandateFirstUsePaymentRun First Payment Run
SEPAMandateOrganizationalUnit1 SEPAMandateOrganizationalUnit1 Organization ID
SEPAMandateOrganizationalUnit2 SEPAMandateOrganizationalUnit2 Organization ID
SEPAMandateOrganizationalUnit3 SEPAMandateOrganizationalUnit3 Organization
SEPAMandateOrganizationalUnit4 SEPAMandateOrganizationalUnit4 Organization

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_SEPAMandateTP.
-- 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_SEPAMandateTP AS
SELECT
  SEPAMandateUUID,
  SEPAMandate,
  SEPAMandateVersion,
  SEPASignatureCityName,
  SEPASignatureDate,
  SEPAPaymentType,
  ValidityStartDate,
  ValidityEndDate,
  SEPAMandateStatus,
  SEPAMandateIsB2BMandate,
  SEPAMandateStatusChangeReason,
  SEPAMandateCreatedByUser,
  SEPAMandateCreationDate,
  SEPAMandateCreationTime,
  SEPAMandateChangeReason,
  OriginalSEPAMandateCreditor,
  OriginalSEPAMandate,
  SEPAMandateIsLocked,
  SEPAMandateApplication,
  OriglSEPAMandateCreatedByUser,
  OriglSEPAMandateCreationDate,
  OriglSEPAMandateCreationTime,
  SEPAMandateReferenceType,
  SEPAMandateReference,
  SEPAMandateReferenceDesc,
  SEPAMandateSenderType,
  SEPAMandateSender,
  SenderLastName,
  SenderFirstName,
  SenderStreetName,
  SenderHouseNumber,
  SenderPostalCode,
  SenderCityName,
  SenderCountry,
  SEPAMandateSenderIBAN,
  SEPAMandateSenderBankSWIFTCode,
  SenderLanguage,
  SEPAMandateAlternativePayer,
  SEPAMandateRecipientType,
  SEPAMandateRecipient,
  RecipientName1,
  RecipientName2,
  SEPAMandateCreditor,
  RecipientStreetName,
  RecipientHouseNumber,
  RecipientPostalCode,
  RecipientCityName,
  RecipientCountry,
  SEPAMandateAlternativePyeName,
  SEPAMandateAlternativePayee,
  SEPAMandateFirstUseDate,
  SEPAMandateFirstUseObjTypeCode,
  SEPAMandateFirstUsePaymentDoc,
  SEPAMandateLastUseDate,
  SEPAMandateLastUseObjTypeCode,
  SEPAMandateLastUsePaymentDoc,
  SEPAMandateFirstUsePaymentRun,
  SEPAMandateOrganizationalUnit1,
  SEPAMandateOrganizationalUnit2,
  SEPAMandateOrganizationalUnit3,
  SEPAMandateOrganizationalUnit4
FROM I_SEPAMandateBasic
;

Learn More