SEPA_MANDATE is an SAP table in package BF_SEPA, software component SAP_ABA. View details, fields & related tables of SEPA_MANDATE in SAP.
- Table description : SEPA Mandate
- Package : BF_SEPA
- Software Component : SAP_ABA

Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP SEPA_MANDATE Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| MGUID | SEPA Mandate: GUID of Mandate | SEPA_MGUID | |
| .INCLUDE | SEPA Mandate: Standard Fields (Cannot be Enhanced) | ||
| MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | ID035 |
| MVERS | SEPA Mandate: Version of Mandate (0 = Current Version) | SEPA_MVERS | NUM04 |
| .INCLUDE | SEPA Mandate: Management Data | ||
| .INCLUDE | SEPA Mandate: Management Data (External Fields) | ||
| SIGN_CITY | Location of Signature | SEPA_SIGN_CITY | TEXT40 |
| SIGN_DATE | Date of Signature | SEPA_SIGN_DATE | DATUM |
| PAY_TYPE | SEPA: Payment Type | SEPA_PAY_TYPE | SEPA_PAY_TYPE |
| VAL_FROM_DATE | SEPA: Validity Date of Mandate (From) | SEPA_VAL_FROM_DATE | DATUM |
| VAL_TO_DATE | SEPA: Validity Date of Mandate (To) | SEPA_VAL_TO_DATE | DATUM |
| STATUS | SEPA: Mandate Status | SEPA_STATUS | SEPA_STATUS |
| B2B | SEPA-Mandate: B2B Mandate | SEPA_B2B | XFELD |
| REASON_CODE | Reason Code for Status Change | SEPA_REASON_CODE | SEPA_REASON_CODE |
| .INCLUDE | SEPA Mandate: Management Data (Internal Data) | ||
| ERNAM | User who Created the Current Version of the Mandate | SEPA_ERNAM | SYCHAR12 |
| ERDAT | Date on Which the Current Mandate Version was Created | SEPA_ERDAT | DATUM |
| ERTIM | Time at Which the Current Mandate Version was Created | SEPA_ERTIM | UZEIT |
| CHG_REASON | SEPA: Reason for Change | SEPA_CHG_REASON | SEPA_CHG_REASON |
| ORIGIN | Single-Character Flag | CHAR1 | CHAR1 |
| ORIGIN_REC_CRDID | SEPA Mandate: Original Creditor ID of Mandate | SEPA_CRDID_ORIGIN | ID035 |
| ORIGIN_MNDID | SEPA Mandate: Original Mandate of Mandate | SEPA_MNDID_ORIGIN | ID035 |
| GLOCK | Global Lock Set in Mandate | SEPA_GLOCK | BOOLEAN |
| GLOCK_VAL_FROM | Global Mandate Lock - Valid From | SEPA_GLOCK_VAL_FROM_DATE | DATUM |
| GLOCK_VAL_TO | Global Mandate Lock - Valid Until | SEPA_GLOCK_VAL_TO_DATE | DATUM |
| ANWND | SEPA: Application for Which Mandate Relevant | SEPA_ANWND | SEPA_ANWND |
| ORI_ERNAM | User who Created the Original Mandate | SEPA_ORI_ERNAM | SYCHAR12 |
| ORI_ERDAT | Date on Which Original Mandate Created | SEPA_ORI_ERDAT | DATUM |
| ORI_ERTIM | Time when Original Mandate Was Created | SEPA_ORI_ERTIM | UZEIT |
| .INCLUDE | SEPA Mandate: Data for Referencing to Other Objects | ||
| .INCLUDE | SEPA Mandate: ID of Referenced Object | ||
| REF_TYPE | SEPA Mandate: Reference Type | SEPA_REF_TYPE | OJ_NAME |
| REF_ID | SEPA Mandate: Reference ID | SEPA_REF_ID | SWO_TYPEID |
| .INCLUDE | SEPA Mandate: Data of Referenced Object | ||
| REF_DESC | Text Field | TEXT50 | TEXT50 |
| .INCLUDE | SEPA Mandate: Sender Data (Debited Bank Account) | ||
| .INCLUDE | SEPA Mandate: ID of Sender | ||
| SND_TYPE | SEPA Mandate: Sender Type | SEPA_SND_TYPE | OJ_NAME |
| SND_ID | SEPA Mandate: Sender ID | SEPA_SND_ID | SWO_TYPEID |
| .INCLUDE | SEPA Mandate: Sender Data | ||
| SND_NAME1 | Last name of business partner (person) | BU_NAMEP_L | BU_NAME |
| SND_NAME2 | First name of business partner (person) | BU_NAMEP_F | BU_NAME |
| SND_STREET | Street | AD_STREET | TEXT60 |
| SND_HOUSENUM | House Number | AD_HSNM1 | TEXT10 |
| SND_POSTAL | City postal code | AD_PSTCD1 | CHAR10 |
| SND_CITY | City | AD_CITY1 | TEXT40 |
| SND_COUNTRY | Country Key | LAND1 | LAND1 |
| SND_IBAN | IBAN (International Bank Account Number) | IBAN | IBAN |
| SND_BIC | SWIFT/BIC for International Payments | SWIFT | SWIFT |
| SND_DIR_NAME | SEPA: Name of Alternative Debtor | SEPA_PAYMENT_FOR | BU_NAME |
| SND_LANGUAGE | Language Key | LANGU | SPRAS |
| SND_DIR_ID | SEPA: ID of Alternative Debtor | SEPA_SND_DIR_ID | SWO_TYPEID |
| SND_DEBTOR_ID | SEPA: ID Number of Sender (External Reference) | SEPA_SND_DEBTOR_ID | ID035 |
| .INCLUDE | SEPA Mandate: Recipient Data (Beneficiary Bank Account) | ||
| .INCLUDE | SEPA Mandate: ID of Recipient | ||
| REC_TYPE | SEPA Mandate: Recipient Type | SEPA_REC_TYPE | OJ_NAME |
| REC_ID | SEPA Mandate: Recipient ID | SEPA_REC_ID | SWO_TYPEID |
| .INCLUDE | SEPA Mandate: Recipient Data | ||
| REC_NAME1 | Name 1 of organization | BU_NAMEOR1 | BU_NAME |
| REC_NAME2 | Name 2 of organization | BU_NAMEOR2 | BU_NAME |
| REC_CRDID | Creditor Identification Number | SEPA_CRDID | ID035 |
| REC_STREET | Street | AD_STREET | TEXT60 |
| REC_HOUSENUM | House Number | AD_HSNM1 | TEXT10 |
| REC_POSTAL | City postal code | AD_PSTCD1 | CHAR10 |
| REC_CITY | City | AD_CITY1 | TEXT40 |
| REC_COUNTRY | Country Key | LAND1 | LAND1 |
| REC_DIR_NAME | SEPA: Name of Alternative Payee | SEPA_REC_DIR_NAME | BU_NAME |
| REC_DIR_ID | SEPA: ID of Alternative Payee | SEPA_REC_DIR_ID | SWO_TYPEID |
| .INCLUDE | SEPA Mandate: Usage Data | ||
| FIRSTUSE_DATE | SEPA Mandate: Date of First Use | SEPA_FIRSTUSE_DATE | DATUM |
| FIRSTUSE_DOCTYPE | SEPA Mandate: Type of First Usage | SEPA_FIRSTUSE_DOCTYPE | OJ_NAME |
| FIRSTUSE_DOCID | SEPA Mandate: ID of First Usage | SEPA_FIRSTUSE_DOCID | SWO_TYPEID |
| LASTUSE_DATE | SEPA Mandate: Date of Last Use | SEPA_LASTUSE_DATE | DATUM |
| LASTUSE_DOCTYPE | SEPA Mandate: Type of Last Usage | SEPA_LASTUSE_DOCTYPE | OJ_NAME |
| LASTUSE_DOCID | SEPA Mandate: ID of Last Usage | SEPA_LASTUSE_DOCID | SWO_TYPEID |
| FIRSTUSE_PAYRUN | SEPA Mandate: ID of Payment Run of First Use | SEPA_FIRSTUSE_PAYRUNID | CHAR16 |
| .INCLUDE | SEPA Mandate: Internal Organizational Data | ||
| ORGF1 | SEPA Mandate: Internal Organizational Data | SEPA_ORG_ID | CHAR20 |
| ORGF2 | SEPA Mandate: Internal Organizational Data | SEPA_ORG_ID | CHAR20 |
| ORGF3 | SEPA Mandate: Internal Organizational Data | SEPA_ORG_ID_LONG | CHAR35 |
| ORGF4 | SEPA Mandate: Internal Organizational Data | SEPA_ORG_ID_LONG | CHAR35 |
SEPA_MANDATE related tables
| Table | Note |
|---|---|
| SEPA_MNDID_FM_T | SEPA Mandate ID: Function Module for Generating Mandate IDs |
| B090 | SEPA Mandate - Payment Method |
| DFKK_SEPA_IDS | SEPA: Short Key for Mandate Reference |
| FSEPA_REFTYPE | SEPA Mandate: Permitted Contract Types |
| FSEPA_REFTYPET | SEPA Mandate: Text Table for Permitted Contract Types |
| REGUS_SEPA | SEPA Mandate Lock: Applications To Be Retrieved |
| SEPA_CTRL | SEPA Mandate Management: System Control |
| SEPA_CTRLT | SEPA Mandate Management: System Control |
| SEPA_CUST | SEPA Mandate Management: Customizing |
| SEPA_CUST_SD | SEPA Mandate Management: Customizing SD |
| SEPA_FIELDS | SEPA Mandate Management: Modifiable Fields |
| SEPA_MANDATE | SEPA Mandate |
| SEPA_MANDATE_ENQ | SEPA Mandate: Internal Table for ENQUEUE |
| SEPA_MANDATE_LCK | SEPA Mandate Management: Global Locks |
| SEPA_MANDATE_USE | SEPA Mandate Management: Usages |
Related tcodes for SEPA_MANDATE
Transaction codes in the same SAP package (BF_SEPA) as the SEPA_MANDATE table.
| Tcode | Description |
|---|---|
| FSEPA_M1 | SEPA: Create Mandate |
| FSEPA_M2 | SEPA: Change Mandate |
| FSEPA_M3 | SEPA: Display Mandate |
| FSEPA_M4 | SEPA: List Mandates |
| FPSEPA_AR1 | SEPA Archiving |
| FPSEPA_AR2 | Activate AIS SEPA |
| FSEPA_M3_LUW | SEPA: Display Mandate (in new LUW) |
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP