- Home
- Resources
- SAP Tables
- 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.
Source: SEPA_S_ADMIN (SEPA Mandate: Management Data)
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 |
Possible values
| 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 |
Possible values
| 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 |
Possible values
|
| 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 |
Possible values
| 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 |
Possible values
| 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 |
