1. Home
  2. Resources
  3. SAP Tables
  4. SEPA_S_ADMIN - SEPA Mandate: Management Data

SAP Table SEPA_S_ADMIN

SEPA Mandate: Management Data

SEPA_S_ADMIN (SEPA Mandate: Management Data) 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_S_ADMIN to other SAP tables.

SEPA_S_ADMIN table fields

Field Data element Checktable Datatype Length Decimals
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
1 One-Time Mandate
N Recurring Use Mandate
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
0 Entered
1 Active
2 To Be Confirmed
3 Locked
4 Canceled
5 Obsolete
6 Completed
B2B SEPA-Mandate: B2B Mandate SEPA_B2B CHAR 1 0
X Yes
NULL No
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
01 Mandate Reference
02 Creditors - Identification
03 Name of Creditor
071 IBAN of Paying Party in same Bank
072 IBAN of Paying Party in Different Bank
0102 Mandate Reference and Creditor Identification
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
X true
- false
NULL unknown
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

SEPA_S_ADMIN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SEPA_S_ADMIN REASON_CODE SYST MANDT SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code MANDT
SEPA_S_ADMIN REASON_CODE * SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code APPLICATION
SEPA_S_ADMIN REASON_CODE SEPA_S_ADMIN STATUS SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code STATUS
SEPA_S_ADMIN REASON_CODE SEPA_S_ADMIN REASON_CODE SEPA_RC_CUST SEPA Mandate: Customizing for Reason Code REASON_CODE