SAP ABAP Table SEPA_STR_MANDATE_CREATE (Structure for Creation of Mandate 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_STR_MANDATE_CREATE	Table Relationship Diagram
Short Description	Structure for Creation of Mandate 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	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
2	.INCLUDE	☐				0	0	SEPA Mandate: Management Data (External Fields)
3	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
4	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
5	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
6	VAL_FROM_DATE	☐	SEPA_VAL_FROM_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (From)
7	VAL_TO_DATE	☐	SEPA_VAL_TO_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (To)
8	STATUS	☐	SEPA_STATUS	SEPA_STATUS	CHAR	1	0	SEPA: Mandate Status
9	B2B	☐	SEPA_B2B	XFELD	CHAR	1	0	SEPA-Mandate: B2B Mandate
10	REASON_CODE	☐	SEPA_REASON_CODE	SEPA_REASON_CODE	CHAR	3	0	Reason Code for Status Change	SEPA_RC_CUST
11	ORIGIN	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
12	ANWND	☐	SEPA_ANWND	SEPA_ANWND	CHAR	1	0	SEPA: Application for Which Mandate Relevant	*
13	.INCLUDE	☐				0	0	SEPA Mandate: Data for Referencing to Other Objects
14	.INCLUDE	☐				0	0	SEPA Mandate: ID of Referenced Object
15	REF_TYPE	☐	SEPA_REF_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Reference Type	*
16	REF_ID	☐	SEPA_REF_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Reference ID
17	.INCLUDE	☐				0	0	SEPA Mandate: Data of Referenced Object
18	REF_DESC	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
19	.INCLUDE	☐				0	0	SEPA Mandate: Sender Data (Debited Bank Account)
20	.INCLUDE	☐				0	0	SEPA Mandate: ID of Sender
21	SND_TYPE	☐	SEPA_SND_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Sender Type	*
22	SND_ID	☐	SEPA_SND_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Sender ID
23	.INCLUDE	☐				0	0	SEPA Mandate: Sender Data
24	SND_NAME1	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
25	SND_NAME2	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
26	SND_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
27	SND_HOUSENUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
28	SND_POSTAL	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
29	SND_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
30	SND_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
31	SND_IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
32	SND_BIC	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
33	SND_DIR_NAME	☐	SEPA_PAYMENT_FOR	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Debtor
34	SND_LANGUAGE	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
35	SND_DIR_ID	☐	SEPA_SND_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Debtor
36	SND_DEBTOR_ID	☐	SEPA_SND_DEBTOR_ID	ID035	CHAR	35	0	SEPA: ID Number of Sender (External Reference)
37	.INCLUDE	☐				0	0	SEPA Mandate: ID of Recipient
38	REC_TYPE	☐	SEPA_REC_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Recipient Type	*
39	REC_ID	☐	SEPA_REC_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Recipient ID
40	.INCLUDE	☐				0	0	SEPA Mandate: Recipient Data
41	REC_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
42	REC_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
43	REC_CRDID	☐	SEPA_CRDID	ID035	CHAR	35	0	Creditor Identification Number
44	REC_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
45	REC_HOUSENUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
46	REC_POSTAL	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
47	REC_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
48	REC_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
49	REC_DIR_NAME	☐	SEPA_REC_DIR_NAME	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Payee
50	REC_DIR_ID	☐	SEPA_REC_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Payee
51	.INCLUDE	☐				0	0	SEPA Mandate: Internal Organizational Data
52	ORGF1	☐	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
53	ORGF2	☐	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
54	ORGF3	☐	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data
55	ORGF4	☐	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SEPA_STR_MANDATE_CREATE	REASON_CODE	SEPA_RC_CUST	REASON_CODE
2	SEPA_STR_MANDATE_CREATE	REC_COUNTRY	T005	LAND1
3	SEPA_STR_MANDATE_CREATE	SND_COUNTRY	T005	LAND1
4	SEPA_STR_MANDATE_CREATE	SND_LANGUAGE	T002	SPRAS

History

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