SAP ABAP Table SEPA_S_ADMIN (SEPA Mandate: Management Data)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-BK (Application Component) Bank
     ⤷ BF_SEPA (Package) Single Euro Payments Area (Mandate)

Basic Data

Table Category	INTTAB	Structure
Structure	SEPA_S_ADMIN	Table Relationship Diagram
Short Description	SEPA Mandate: Management Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	SEPA Mandate: Management Data (External Fields)
2	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
3	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
4	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
5	VAL_FROM_DATE	☐	SEPA_VAL_FROM_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (From)
6	VAL_TO_DATE	☐	SEPA_VAL_TO_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (To)
7	STATUS	☐	SEPA_STATUS	SEPA_STATUS	CHAR	1	0	SEPA: Mandate Status
8	B2B	☐	SEPA_B2B	XFELD	CHAR	1	0	SEPA-Mandate: B2B Mandate
9	REASON_CODE	☐	SEPA_REASON_CODE	SEPA_REASON_CODE	CHAR	3	0	Reason Code for Status Change	SEPA_RC_CUST
10	.INCLUDE	☐				0	0	SEPA Mandate: Management Data (Internal Data)
11	ERNAM	☐	SEPA_ERNAM	SYCHAR12	CHAR	12	0	User who Created the Current Version of the Mandate
12	ERDAT	☐	SEPA_ERDAT	DATUM	DATS	8	0	Date on Which the Current Mandate Version was Created
13	ERTIM	☐	SEPA_ERTIM	UZEIT	TIMS	6	0	Time at Which the Current Mandate Version was Created
14	CHG_REASON	☐	SEPA_CHG_REASON	SEPA_CHG_REASON	CHAR	5	0	SEPA: Reason for Change
15	ORIGIN	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
16	ORIGIN_REC_CRDID	☐	SEPA_CRDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Creditor ID of Mandate
17	ORIGIN_MNDID	☐	SEPA_MNDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Mandate of Mandate
18	GLOCK	☐	SEPA_GLOCK	BOOLEAN	CHAR	1	0	Global Lock Set in Mandate
19	GLOCK_VAL_FROM	☐	SEPA_GLOCK_VAL_FROM_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid From
20	GLOCK_VAL_TO	☐	SEPA_GLOCK_VAL_TO_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid Until
21	ANWND	☐	SEPA_ANWND	SEPA_ANWND	CHAR	1	0	SEPA: Application for Which Mandate Relevant	*
22	ORI_ERNAM	☐	SEPA_ORI_ERNAM	SYCHAR12	CHAR	12	0	User who Created the Original Mandate
23	ORI_ERDAT	☐	SEPA_ORI_ERDAT	DATUM	DATS	8	0	Date on Which Original Mandate Created
24	ORI_ERTIM	☐	SEPA_ORI_ERTIM	UZEIT	TIMS	6	0	Time when Original Mandate Was Created

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SEPA_S_ADMIN	REASON_CODE	SEPA_RC_CUST	REASON_CODE

History

Last changed by/on	SAP	20131122
SAP Release Created in	700