SEPA_MANDATE - SEPA Mandate

SEPA Mandate information is stored in SAP table SEPA_MANDATE.
It is part of development package BF_SEPA in software component CA-BK. This development package consists of objects that can be grouped under "Single Euro Payments Area (Mandate)".

Fields for table SEPA_MANDATE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
MGUID	SEPA Mandate: GUID of Mandate	X	SEPA_MGUID	RAW	16
.INCLUDE				SEPA_MANDATE_DATA	0
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
MVERS	SEPA Mandate: Version of Mandate (0 = Current Version)		SEPA_MVERS	NUMC	8
.INCLUDE				SEPA_S_ADMIN	0
.INCLUDE				SEPA_S_ADMIN_EXT	0
SIGN_CITY	Location of Signature		SEPA_SIGN_CITY	CHAR	80
SIGN_DATE	Date of Signature		SEPA_SIGN_DATE	DATS	16
PAY_TYPE	SEPA: Payment Type		SEPA_PAY_TYPE	CHAR	2
VAL_FROM_DATE	SEPA: Validity Date of Mandate (From)		SEPA_VAL_FROM_DATE	DATS	16
VAL_TO_DATE	SEPA: Validity Date of Mandate (To)		SEPA_VAL_TO_DATE	DATS	16
STATUS	SEPA: Mandate Status		SEPA_STATUS	CHAR	2
B2B	SEPA-Mandate: B2B Mandate		SEPA_B2B	CHAR	2
REASON_CODE	Reason Code for Status Change		SEPA_REASON_CODE	CHAR	6	SEPA_RC_CUST
.INCLUDE				SEPA_S_ADMIN_INT	0
ERNAM	User who Created the Current Version of the Mandate		SEPA_ERNAM	CHAR	24
ERDAT	Date on Which the Current Mandate Version was Created		SEPA_ERDAT	DATS	16
ERTIM	Time at Which the Current Mandate Version was Created		SEPA_ERTIM	TIMS	12
CHG_REASON	SEPA: Reason for Change		SEPA_CHG_REASON	CHAR	10
ORIGIN	Single-Character Flag		CHAR1	CHAR	2
ORIGIN_REC_CRDID	SEPA Mandate: Original Creditor ID of Mandate		SEPA_CRDID_ORIGIN	CHAR	70
ORIGIN_MNDID	SEPA Mandate: Original Mandate of Mandate		SEPA_MNDID_ORIGIN	CHAR	70
GLOCK	Global Lock Set in Mandate		SEPA_GLOCK	CHAR	2
GLOCK_VAL_FROM	Global Mandate Lock - Valid From		SEPA_GLOCK_VAL_FROM_DATE	DATS	16
GLOCK_VAL_TO	Global Mandate Lock - Valid Until		SEPA_GLOCK_VAL_TO_DATE	DATS	16
ANWND	SEPA: Application for Which Mandate Relevant		SEPA_ANWND	CHAR	2	*
ORI_ERNAM	User who Created the Original Mandate		SEPA_ORI_ERNAM	CHAR	24
ORI_ERDAT	Date on Which Original Mandate Created		SEPA_ORI_ERDAT	DATS	16
ORI_ERTIM	Time when Original Mandate Was Created		SEPA_ORI_ERTIM	TIMS	12
.INCLUDE				SEPA_S_REFERENCE	0
.INCLUDE				SEPA_S_REFERENCE_ID	0
REF_TYPE	SEPA Mandate: Reference Type		SEPA_REF_TYPE	CHAR	20	*
REF_ID	SEPA Mandate: Reference ID		SEPA_REF_ID	CHAR	140
.INCLUDE				SEPA_S_REFERENCE_DATA	0
REF_DESC	Text Field		TEXT50	CHAR	100
.INCLUDE				SEPA_S_SENDER	0
.INCLUDE				SEPA_S_SENDER_ID	0
SND_TYPE	SEPA Mandate: Sender Type		SEPA_SND_TYPE	CHAR	20	*
SND_ID	SEPA Mandate: Sender ID		SEPA_SND_ID	CHAR	140
.INCLUDE				SEPA_S_SENDER_DATA	0
SND_NAME1	Last name of business partner (person)		BU_NAMEP_L	CHAR	80
SND_NAME2	First name of business partner (person)		BU_NAMEP_F	CHAR	80
SND_STREET	Street		AD_STREET	CHAR	120
SND_HOUSENUM	House Number		AD_HSNM1	CHAR	20
SND_POSTAL	City postal code		AD_PSTCD1	CHAR	20
SND_CITY	City		AD_CITY1	CHAR	80
SND_COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
SND_IBAN	IBAN (International Bank Account Number)		IBAN	CHAR	68
SND_BIC	SWIFT/BIC for International Payments		SWIFT	CHAR	22
SND_DIR_NAME	SEPA: Name of Alternative Debtor		SEPA_PAYMENT_FOR	CHAR	80
SND_LANGUAGE	Language Key		LANGU	LANG	2	T002
SND_DIR_ID	SEPA: ID of Alternative Debtor		SEPA_SND_DIR_ID	CHAR	140
SND_DEBTOR_ID	SEPA: ID Number of Sender (External Reference)		SEPA_SND_DEBTOR_ID	CHAR	70
.INCLUDE				SEPA_S_RECEIVER	0
.INCLUDE				SEPA_S_RECEIVER_ID	0
REC_TYPE	SEPA Mandate: Recipient Type		SEPA_REC_TYPE	CHAR	20	*
REC_ID	SEPA Mandate: Recipient ID		SEPA_REC_ID	CHAR	140
.INCLUDE				SEPA_S_RECEIVER_DATA	0
REC_NAME1	Name 1 of organization		BU_NAMEOR1	CHAR	80
REC_NAME2	Name 2 of organization		BU_NAMEOR2	CHAR	80
REC_CRDID	Creditor Identification Number		SEPA_CRDID	CHAR	70
REC_STREET	Street		AD_STREET	CHAR	120
REC_HOUSENUM	House Number		AD_HSNM1	CHAR	20
REC_POSTAL	City postal code		AD_PSTCD1	CHAR	20
REC_CITY	City		AD_CITY1	CHAR	80
REC_COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
REC_DIR_NAME	SEPA: Name of Alternative Payee		SEPA_REC_DIR_NAME	CHAR	80
REC_DIR_ID	SEPA: ID of Alternative Payee		SEPA_REC_DIR_ID	CHAR	140
.INCLUDE				SEPA_S_USE	0
FIRSTUSE_DATE	SEPA Mandate: Date of First Use		SEPA_FIRSTUSE_DATE	DATS	16
FIRSTUSE_DOCTYPE	SEPA Mandate: Type of First Usage		SEPA_FIRSTUSE_DOCTYPE	CHAR	20	*
FIRSTUSE_DOCID	SEPA Mandate: ID of First Usage		SEPA_FIRSTUSE_DOCID	CHAR	140
LASTUSE_DATE	SEPA Mandate: Date of Last Use		SEPA_LASTUSE_DATE	DATS	16
LASTUSE_DOCTYPE	SEPA Mandate: Type of Last Usage		SEPA_LASTUSE_DOCTYPE	CHAR	20	*
LASTUSE_DOCID	SEPA Mandate: ID of Last Usage		SEPA_LASTUSE_DOCID	CHAR	140
FIRSTUSE_PAYRUN	SEPA Mandate: ID of Payment Run of First Use		SEPA_FIRSTUSE_PAYRUNID	CHAR	32
.INCLUDE				SEPA_S_ORG	0
ORGF1	SEPA Mandate: Internal Organizational Data		SEPA_ORG_ID	CHAR	40
ORGF2	SEPA Mandate: Internal Organizational Data		SEPA_ORG_ID	CHAR	40
ORGF3	SEPA Mandate: Internal Organizational Data		SEPA_ORG_ID_LONG	CHAR	70
ORGF4	SEPA Mandate: Internal Organizational Data		SEPA_ORG_ID_LONG	CHAR	70
.INCLU--AP				/SAPF15/SEPA_MANDATE_APPEND	0
.INCLUDE	F15			/SAPF15/_S_SEPA_MANDATE_BW	0
/SAPF15/F15_BW			/SAPF15/BEWIRTSCHAFTER	CHAR	16
/SAPF15/F15_KZ			/SAPF15/KASSENZEICHEN	CHAR	24
/SAPF15/GUID	GUID		/SAPF15/GUID	RAW	16
.INCLU--AP				BKK_STR_MND_CONTRACT	0
.INCLUDE				IBKK_STR_MND_CONTRACT	0
CONTRACT_ID	BKK: SEPA Mandate Contract ID		BKK_DTE_MND_CONTRACT_ID	CHAR	100
CONTRACT_DESC	BKK:SEPA Mandate Contract Description		BKK_DTE_MND_CONTRACT_DESC	CHAR	100
BANK_CRDTR	Bank Is Creditor		BKK_DTE_MND_BANK_CRDTR	CHAR	2
.INCLU--AP				FKK_SEPA_MANDATE	0
.INCLUDE				FKK_SEPA_MANDATE_APPEND	0
LAUFD	Date ID		LAUFD_KK	DATS	16
LAUFI	Run ID		LAUFI_KK	CHAR	12
.INCLU--AP				FSFND_STR_MND_LIMIT	0
.INCLUDE	MLIMIT			FSFND_STR_MND_LIMIT_FIELDS	0
LIMIT_AMOUNT	Mandate Amount Limit		FSFND_MND_LIMIT_AMOUNT	CURR	12
LIMIT_CURR	Currency		FSFND_CURR	CUKY	10	*
LIMIT_NUMBER	Mandate Limit Number		FSFND_MND_LIMIT_NO	NUMC	12
LIMIT_UNIT	Mandate Limit - Period Unit		FSFND_MND_LIMIT_PUNIT	CHAR	2
LIMIT_START_DATE	Mandate Limit - Start Date		FSFND_MND_LIMIT_STARTD	DATS	16