1. Home
  2. Resources
  3. SAP Tables
  4. SEPA_MANDATE - SEPA Mandate

SAP Table SEPA_MANDATE

SEPA Mandate

SEPA_MANDATE (SEPA Mandate) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SEPA_MANDATE to other SAP tables.

SEPA_MANDATE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
MGUID SEPA Mandate: GUID of Mandate SEPA_MGUID RAW 16 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
MVERS SEPA Mandate: Version of Mandate (0 = Current Version) SEPA_MVERS NUMC 4 0
SIGN_CITY Location of Signature SEPA_SIGN_CITY CHAR 40 0
SIGN_DATE Date of Signature SEPA_SIGN_DATE DATS 8 0
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
VAL_FROM_DATE SEPA: Validity Date of Mandate (From) SEPA_VAL_FROM_DATE DATS 8 0
VAL_TO_DATE SEPA: Validity Date of Mandate (To) SEPA_VAL_TO_DATE DATS 8 0
STATUS SEPA: Mandate Status SEPA_STATUS CHAR 1 0
0 Entered
1 Active
2 To Be Confirmed
3 Locked
4 Canceled
5 Obsolete
6 Completed
B2B SEPA-Mandate: B2B Mandate SEPA_B2B CHAR 1 0
X Yes
NULL No
REASON_CODE Reason Code for Status Change SEPA_REASON_CODE SEPA_RC_CUST CHAR 3 0
ERNAM User who Created the Current Version of the Mandate SEPA_ERNAM CHAR 12 0
ERDAT Date on Which the Current Mandate Version was Created SEPA_ERDAT DATS 8 0
ERTIM Time at Which the Current Mandate Version was Created SEPA_ERTIM TIMS 6 0
CHG_REASON SEPA: Reason for Change SEPA_CHG_REASON CHAR 5 0
01 Mandate Reference
02 Creditors - Identification
03 Name of Creditor
071 IBAN of Paying Party in same Bank
072 IBAN of Paying Party in Different Bank
0102 Mandate Reference and Creditor Identification
ORIGIN Single-Character Indicator CHAR1 CHAR 1 0
ORIGIN_REC_CRDID SEPA Mandate: Original Creditor ID of Mandate SEPA_CRDID_ORIGIN CHAR 35 0
ORIGIN_MNDID SEPA Mandate: Original Mandate of Mandate SEPA_MNDID_ORIGIN CHAR 35 0
GLOCK Global Lock Set in Mandate SEPA_GLOCK CHAR 1 0
X true
- false
NULL unknown
GLOCK_VAL_FROM Global Mandate Lock - Valid From SEPA_GLOCK_VAL_FROM_DATE DATS 8 0
GLOCK_VAL_TO Global Mandate Lock - Valid Until SEPA_GLOCK_VAL_TO_DATE DATS 8 0
ANWND SEPA: Application for Which Mandate Relevant SEPA_ANWND CHAR 1 0
ORI_ERNAM User who Created the Original Mandate SEPA_ORI_ERNAM CHAR 12 0
ORI_ERDAT Date on Which Original Mandate Created SEPA_ORI_ERDAT DATS 8 0
ORI_ERTIM Time when Original Mandate Was Created SEPA_ORI_ERTIM TIMS 6 0
REF_TYPE SEPA Mandate: Reference Type SEPA_REF_TYPE CHAR 10 0
REF_ID SEPA Mandate: Reference ID SEPA_REF_ID CHAR 70 0
REF_DESC Text Field TEXT50 CHAR 50 0
SND_TYPE SEPA Mandate: Sender Type SEPA_SND_TYPE CHAR 10 0
SND_ID SEPA Mandate: Sender ID SEPA_SND_ID CHAR 70 0
SND_NAME1 Last name of business partner (person) BU_NAMEP_L CHAR 40 0
SND_NAME2 First name of business partner (person) BU_NAMEP_F CHAR 40 0
SND_STREET Street AD_STREET CHAR 60 0
SND_HOUSENUM House Number AD_HSNM1 CHAR 10 0
SND_POSTAL City postal code AD_PSTCD1 CHAR 10 0
SND_CITY City AD_CITY1 CHAR 40 0
SND_COUNTRY Country Key LAND1 T005 CHAR 3 0
SND_IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
SND_BIC SWIFT/BIC for International Payments SWIFT CHAR 11 0
SND_DIR_NAME SEPA: Name of Alternative Debtor SEPA_PAYMENT_FOR CHAR 40 0
SND_LANGUAGE Language Key LANGU T002 LANG 1 0
SND_DIR_ID SEPA: ID of Alternative Debtor SEPA_SND_DIR_ID CHAR 70 0
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_ID CHAR 35 0
REC_TYPE SEPA Mandate: Recipient Type SEPA_REC_TYPE CHAR 10 0
REC_ID SEPA Mandate: Recipient ID SEPA_REC_ID CHAR 70 0
REC_NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
REC_NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
REC_CRDID Creditor Identification Number SEPA_CRDID CHAR 35 0
REC_STREET Street AD_STREET CHAR 60 0
REC_HOUSENUM House Number AD_HSNM1 CHAR 10 0
REC_POSTAL City postal code AD_PSTCD1 CHAR 10 0
REC_CITY City AD_CITY1 CHAR 40 0
REC_COUNTRY Country Key LAND1 T005 CHAR 3 0
REC_DIR_NAME SEPA: Name of Alternative Payee SEPA_REC_DIR_NAME CHAR 40 0
REC_DIR_ID SEPA: ID of Alternative Payee SEPA_REC_DIR_ID CHAR 70 0
FIRSTUSE_DATE SEPA Mandate: Date of First Use SEPA_FIRSTUSE_DATE DATS 8 0
FIRSTUSE_DOCTYPE SEPA Mandate: Type of First Usage SEPA_FIRSTUSE_DOCTYPE CHAR 10 0
FIRSTUSE_DOCID SEPA Mandate: ID of First Usage SEPA_FIRSTUSE_DOCID CHAR 70 0
LASTUSE_DATE SEPA Mandate: Date of Last Use SEPA_LASTUSE_DATE DATS 8 0
LASTUSE_DOCTYPE SEPA Mandate: Type of Last Usage SEPA_LASTUSE_DOCTYPE CHAR 10 0
LASTUSE_DOCID SEPA Mandate: ID of Last Usage SEPA_LASTUSE_DOCID CHAR 70 0
FIRSTUSE_PAYRUN SEPA Mandate: ID of Payment Run of First Use SEPA_FIRSTUSE_PAYRUNID CHAR 16 0
ORGF1 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20 0
ORGF2 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20 0
ORGF3 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35 0
ORGF4 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35 0
/SAPF15/F15_BW /SAPF15/BEWIRTSCHAFTER CHAR 8 0
/SAPF15/F15_KZ /SAPF15/KASSENZEICHEN CHAR 12 0
/SAPF15/GUID /SAPF15/GUID RAW 16 0
CONTRACT_ID BKK: SEPA Mandate Contract ID BKK_DTE_MND_CONTRACT_ID CHAR 50 0
CONTRACT_DESC BKK:SEPA Mandate Contract Description BKK_DTE_MND_CONTRACT_DESC CHAR 50 0
BANK_CRDTR Bank Is Creditor BKK_DTE_MND_BANK_CRDTR CHAR 1 0
X Yes
NULL No
LAUFD Date ID LAUFD_KK DATS 8 0
LAUFI Additional Identification Characteristic LAUFI_KK CHAR 6 0

SEPA_MANDATE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SEPA_MANDATE REASON_CODE SYST MANDT SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code MANDT
SEPA_MANDATE REASON_CODE * SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code APPLICATION
SEPA_MANDATE REASON_CODE SEPA_MANDATE STATUS SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code STATUS
SEPA_MANDATE REASON_CODE SEPA_MANDATE REASON_CODE SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code REASON_CODE
SEPA_MANDATE REC_COUNTRY SEPA_MANDATE REC_COUNTRY T005 Countries LAND1
SEPA_MANDATE REC_COUNTRY SYST MANDT T005 Countries MANDT
SEPA_MANDATE SND_COUNTRY SYST MANDT T005 Countries MANDT
SEPA_MANDATE SND_COUNTRY SEPA_MANDATE SND_COUNTRY T005 Countries LAND1
SEPA_MANDATE SND_LANGUAGE SEPA_MANDATE SND_LANGUAGE T002 Language Keys (Component BC-I18) SPRAS