- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
I_SEPAMandate
Core view for SEPA_MANDATE
| view: ISEPAMANDATE
| Extraction:
Not supported
| Component: Information System
Tables used:
SEPA_MANDATE
- 🔑 Keys (1)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (10)
- ☰ Categorical (5)
- Other (44)
- 🔗 Relations (3)
| Column Name | Description | |
|---|---|---|
| SEPAMandateUUID | SEPA Mandate: GUID of Mandate |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| SEPASignatureDate | Date of Signature | |
| ValidityStartDate | SEPA: Validity Date of Mandate (From) | |
| ValidityEndDate | SEPA: Validity Date of Mandate (To) | |
| SEPAMandateCreationDate | Date on Which the Current Mandate Version was Created | |
| SEPAMandateLockStartDate | Global Mandate Lock - Valid From | |
| SEPAMandateLockEndDate | Global Mandate Lock - Valid Until | |
| OriglSEPAMandateCreationDate | Date on Which Original Mandate Created | |
| SEPAMandateFirstUseDate | SEPA Mandate: Date of First Use | |
| SEPAMandateLastUseDate | SEPA Mandate: Date of Last Use | |
| CAMassRunDate | Date ID |
| Column Name | Description | |
|---|---|---|
| SEPAPaymentType | SEPA: Payment Type | Show values |
| SEPAMandateStatus | SEPA: Mandate Status | Show values |
| SEPAMandateIsB2BMandate | SEPA-Mandate: B2B Mandate | Show values |
| SEPAMandateChangeReason | SEPA: Reason for Change | Show values |
| SEPAMandateIsLocked | Global Lock Set in Mandate | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| SEPAMandate | Unique Reference to Mandate for each Payee | ID035 | |
| SEPAMandateVersion | SEPA Mandate: Version of Mandate (0 = Current Version) | NUM04 | |
| SEPASignatureCityName | Location of Signature | TEXT40 | |
| SEPAMandateCreatedByUser | User who Created the Current Version of the Mandate | SYCHAR12 | |
| OriginalSEPAMandateCreditor | SEPA Mandate: Original Creditor ID of Mandate | ID035 | |
| OriginalSEPAMandate | SEPA Mandate: Original Mandate of Mandate | ID035 | |
| OriglSEPAMandateCreatedByUser | User who Created the Original Mandate | SYCHAR12 | |
| SEPAMandateReferenceType | SEPA Mandate: Reference Type | OJ_NAME | |
| SEPAMandateReference | SEPA Mandate: Reference ID | SWO_TYPEID | |
| SEPAMandateReferenceDesc | Text Field | TEXT50 | |
| SEPAMandateSenderType | SEPA Mandate: Sender Type | OJ_NAME | |
| SEPAMandateSender | SEPA Mandate: Sender ID | SWO_TYPEID | |
| 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 | |
| SEPAMandateSenderIBAN | IBAN (International Bank Account Number) | IBAN | |
| SEPAMandateSenderBankSWIFTCode | SWIFT/BIC for International Payments | SWIFT | |
| SEPAMandateAlternativePyrName | SEPA: Name of Alternative Debtor | BU_NAME | |
| SEPAMandateAlternativePayer | SEPA: ID of Alternative Debtor | SWO_TYPEID | |
| SEPAMandateSenderExternalID | SEPA: ID Number of Sender (External Reference) | ID035 | |
| SEPAMandateRecipientType | SEPA Mandate: Recipient Type | OJ_NAME | |
| SEPAMandateRecipient | SEPA Mandate: Recipient ID | SWO_TYPEID | |
| RecipientName1 | Name 1 of organization | BU_NAME | |
| RecipientName2 | Name 2 of organization | BU_NAME | |
| SEPAMandateCreditor | Creditor Identification Number | ID035 | |
| RecipientStreetName | Street | TEXT60 | |
| RecipientHouseNumber | House Number | TEXT10 | |
| RecipientPostalCode | City postal code | CHAR10 | |
| RecipientCityName | City | TEXT40 | |
| SEPAMandateAlternativePyeName | SEPA: Name of Alternative Payee | BU_NAME | |
| SEPAMandateAlternativePayee | SEPA: ID of Alternative Payee | SWO_TYPEID | |
| SEPAMandateFirstUseObjTypeCode | SEPA Mandate: Type of First Usage | OJ_NAME | |
| SEPAMandateFirstUsePaymentDoc | SEPA Mandate: ID of First Usage | SWO_TYPEID | |
| SEPAMandateLastUseObjTypeCode | SEPA Mandate: Type of Last Usage | OJ_NAME | |
| SEPAMandateLastUsePaymentDoc | SEPA Mandate: ID of Last Usage | SWO_TYPEID | |
| SEPAMandateFirstUsePaymentRun | SEPA Mandate: ID of Payment Run of First Use | CHAR16 | |
| 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 | |
| CAMassRunID | Run ID | LAUFI_KK |
| Master Data Relations | Join Conditions |
|---|---|
Country/Region Key
| |
Country/Region Key
| |
Reason Code for Status Change
|
|