SAP table SEPA_MANDATE (SEPA Mandate)

SAP table SEPA_MANDATE has 2 primary key fields being MANDT,MGUID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

SEPA_MANDATE foreign key relationships

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