SAP Table SEPA_MANDATE

SEPA Mandate

The table SEPA_MANDATE (SEPA Mandate) is a standard table in SAP ERP. It belongs to the package BF_SEPA.

Technical Information

Table	SEPA_MANDATE
Short Text	SEPA Mandate
Package	BF_SEPA
Table Type	Transparent Table

Fields for Table SEPA_MANDATE

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