SAP table SEPA_S_ADMIN (SEPA Mandate: Management Data)

Field Description Data Type Length Decimals Checktable Data Element
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

SEPA_S_ADMIN foreign key relationships

Table Field Check Table Check Field
0 SEPA_S_ADMIN REASON_CODE SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code MANDT
0 SEPA_S_ADMIN REASON_CODE SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code APPLICATION
0 SEPA_S_ADMIN REASON_CODE SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code STATUS
0 SEPA_S_ADMIN REASON_CODE SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code REASON_CODE