P_ManageSEPAMandate

SEPA Mandate | view: PMNGSEPA | Extraction: Not supported | Component: Fiori UI for Accounts Receivable
Tables used: SEPA_MANDATE, SEPA_RC_CUST, SEPA_RC_CUST_TXT, USR21
Column Name Description
SEPAMandateUUID SEPA Mandate: GUID of Mandate
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate SEPA: Validity Date of Mandate (From)
ValidityEndDate SEPA: Validity Date of Mandate (To)
SEPAMandateCreationDate Date on Which the Current Mandate Version was Created
CAMassRunDate Date ID
SEPAMandateLastUseDate SEPA Mandate: Date of Last Use
SEPAMandateFirstUseDate SEPA Mandate: Date of First Use
SEPASignatureDate Date of Signature
SEPAMandateLockStartDate Global Lock Valid From
SEPAMandateLockEndDate Global Lock Valid To
OriglSEPAMandateCreationDate Date on Which Original Mandate Created
Column Name Description
SEPAMandateIsLocked Global Lock Set in Mandate Show values
SEPAMandateStatus SEPA: Mandate Status Show values
SEPAPaymentType SEPA: Payment Type Show values
SEPAMandateIsB2BMandate SEPA-Mandate: B2B Mandate Show values
SEPAMandateChangeReason SEPA: Reason for Change Show values
Column Name Description Domain name
SEPAMandate Unique Reference to Mandate for each Payee ID035
SEPAMandateCreatedByUser User who Created the Current Version of the Mandate SYCHAR12
CreatedByUserDescription User Description SUIDTECHDESC
SEPAMandateStatusName Short Text for Fixed Values DDTEXT
SEPAMandateReferenceType SEPA Mandate: Reference Type OJ_NAME
SEPAMandateReferenceTypeName Description TEXT80
SEPAMandateReference SEPA Mandate: Reference ID SWO_TYPEID
SEPAMandateReferenceDesc Reference Description TEXT50
SEPAMandateSenderType SEPA Mandate: Sender Type OJ_NAME
SEPAMandateSenderTypeName Description TEXT80
SEPAMandateSender SEPA Mandate: Sender ID SWO_TYPEID
SEPAMandateRecipientType SEPA Mandate: Recipient Type OJ_NAME
SEPAMandateRecipientTypeName Description TEXT80
SEPAMandateRecipient SEPA Mandate: Recipient ID SWO_TYPEID
MaximumNumberOfHits Maximum Number of Result INT4
PayingCompanyCode Paying Company Code BUKRS
SenderType SEPA Mandate: Sender Type OJ_NAME
Customer Customer Number KUNNR
SEPAMandateContractType SEPA Mandate: Contract Type OJ_NAME
SEPAMandateContract SEPA Mandate: Contract ID SWO_TYPEID
CompanyCode Company Code BUKRS
AccountingDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
BusinessPartner Business Partner Number BU_PARTNER
CAStandardCompanyCode Standard Company Code BUKRS
CAContract Reference Specifications from Contract VTREF_KK
ContractAccount Contract Account Number VKONT_KK
CAMassRunID Run ID LAUFI_KK
SEPAPaymentTypeName Short Text for Fixed Values DDTEXT
SEPAMandateFirstUseObjTypeCode SEPA Mandate: Type of First Usage OJ_NAME
SEPAMandateFirstUseObjTypeText Description TEXT80
SEPAMandateFirstUsePaymentDoc SEPA Mandate: ID of First Usage SWO_TYPEID
SEPAMandateLastUseObjTypeCode SEPA Mandate: Type of Last Usage OJ_NAME
SEPAMandateLastUseObjTypeText Description TEXT80
SEPAMandateCreditor Creditor Identification Number ID035
SEPAMandateSenderIBAN IBAN (International Bank Account Number) IBAN
SEPAMandateSenderBankSWIFTCode SWIFT/BIC for International Payments SWIFT
SEPAMandateFirstUsePaymentRun SEPA Mandate: ID of Payment Run of First Use CHAR16
SEPAMandateVersion SEPA Mandate: Version of Mandate (0 = Current Version) NUM04
OriginalSEPAMandateCreditor SEPA Mandate: Original Creditor ID of Mandate ID035
OriginalSEPAMandate SEPA Mandate: Original Mandate of Mandate ID035
SEPAMandateLastUsePaymentDoc SEPA Mandate: ID of Last Usage SWO_TYPEID
SEPAMandateAlternativePayer SEPA: ID of Alternative Debtor SWO_TYPEID
SEPASignatureCityName Location of Signature TEXT40
SEPAMandateStsChangeReasonName Description of Reason for Status Change SEPA_REASON_CODE_DESC
SEPAMandateAlternativePyeName SEPA: Name of Alternative Payee BU_NAME
SEPAMandateAlternativePayee SEPA: ID of Alternative Payee SWO_TYPEID
SEPAMandateOrganizationalUnit1 SEPA Mandate: Internal Organizational Data CHAR20
SEPAMandateOrganizationalUnit2 SEPA Mandate: Internal Organizational Data CHAR20
SEPAMandateOrganizationalUnit3 SEPA Mandate: Internal Organizational Data CHAR35
SEPAMandateOrganizationalUnit4 SEPA Mandate: Internal Organizational Data CHAR35
OriglSEPAMandateCreatedByUser User who Created the Original Mandate SYCHAR12
OriglCreatedByUserDescription User Description SUIDTECHDESC
SEPAMandateAlternativePyrName SEPA: Name of Alternative Debtor BU_NAME
SEPAMandateSenderExternalID SEPA: ID Number of Sender (External Reference) ID035
SenderLastName Last name of business partner (person) BU_NAME
SenderFirstName First name of business partner (person) BU_NAME
SenderStreetName Street TEXT60
SenderHouseNumber House Number TEXT10
SenderPostalCode City postal code CHAR10
SenderCityName City TEXT40
RecipientName1 Name 1 of organization BU_NAME
RecipientName2 Name 2 of organization BU_NAME
RecipientStreetName Street TEXT60
RecipientHouseNumber House Number TEXT10
RecipientPostalCode City postal code CHAR10
RecipientCityName City TEXT40
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • P_MANAGESEPAMANDATE.MANDT == T005.MANDT
  • P_MANAGESEPAMANDATE.RECIPIENTCOUNTRY == T005.LAND1
Country/Region Key
  • Country/Region Key
  • Client
  • P_MANAGESEPAMANDATE.SENDERCOUNTRY == T005.LAND1
  • P_MANAGESEPAMANDATE.MANDT == T005.MANDT
Reason Code for Status Change
  • Reason Code for Status Change
  • ?
  • Client
  • SEPA: Mandate Status
  • P_MANAGESEPAMANDATE.SEPAMANDATESTATUSCHANGEREASON == SEPA_RC_CUST.REASON_CODE
  • P_MANAGESEPAMANDATE.[column in domain "SEPA_ANWND"] == SEPA_RC_CUST.APPLICATION
  • P_MANAGESEPAMANDATE.MANDT == SEPA_RC_CUST.MANDT
  • P_MANAGESEPAMANDATE.SEPAMANDATESTATUS == SEPA_RC_CUST.STATUS