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 | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
B2B
SEPA-Mandate: B2B Mandate
|
SEPA_B2B |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 |