SAP ABAP Table BUS_EI_COM_BUPA_SEPA_MANDATE (Com. Interface: Data for BP SEPA Mandates)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ COM_BUPA (Package) Business Partner Communication Data

Basic Data

Table Category	INTTAB	Structure
Structure	BUS_EI_COM_BUPA_SEPA_MANDATE	Table Relationship Diagram
Short Description	Com. Interface: Data for BP SEPA Mandates

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	TASK	☐	GC_TASK	CHAR1	CHAR	1	0	Com. Interface: Change Indicator
2	DATA	☐	BUS_EI_COM_SEPA_MANDATE_DATA		STRU	0	0
3	APPLICATION	☐	SEPA_ANWND	SEPA_ANWND	CHAR	1	0	SEPA: Application for Which Mandate Relevant
4	SEPA_CREDITOR_ID	☐	SEPA_CRDID	ID035	CHAR	35	0	Creditor Identification Number
5	SEPA_MANDATE_ID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
6	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
7	SND_TYPE	☐	SEPA_SND_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Sender Type
8	SND_ID	☐	SEPA_SND_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Sender ID
9	SND_NAME1	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
10	SND_NAME2	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
11	SND_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
12	SND_HOUSENUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
13	SND_POSTAL	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
14	SND_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
15	SND_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
16	SND_LANGUAGE	☐	LANGU	SPRAS	LANG	1	0	Language Key
17	SND_IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
18	SND_BIC	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
19	SND_DIR_NAME	☐	SEPA_PAYMENT_FOR	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Debtor
20	REC_TYPE	☐	SEPA_REC_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Recipient Type
21	REC_ID	☐	SEPA_REC_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Recipient ID
22	REC_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
23	REC_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
24	REC_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
25	REC_HOUSENUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
26	REC_POSTAL	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
27	REC_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
28	REC_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
29	REF_TYPE	☐	SEPA_REF_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Reference Type
30	REF_ID	☐	SEPA_REF_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Reference ID
31	REF_DESC	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
32	LIFETIME_FROM	☐	SEPA_VAL_FROM_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (From)
33	LIFETIME_TO	☐	SEPA_VAL_TO_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (To)
34	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
35	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
36	STATUS	☐	SEPA_STATUS	SEPA_STATUS	CHAR	1	0	SEPA: Mandate Status
37	SND_DIR_ID	☐	SEPA_SND_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Debtor
38	REC_DIR_NAME	☐	SEPA_REC_DIR_NAME	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Payee
39	REC_DIR_ID	☐	SEPA_REC_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Payee
40	B2B	☐	SEPA_B2B	XFELD	CHAR	1	0	SEPA-Mandate: B2B Mandate
41	SND_DEBTOR_ID	☐	SEPA_SND_DEBTOR_ID	ID035	CHAR	35	0	SEPA: ID Number of Sender (External Reference)
42	ORGF1	☐	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
43	ORGF2	☐	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
44	ORGF3	☐	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data
45	ORGF4	☐	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data
46	GLOBAL_LOCK	☐	SEPA_GLOCK	BOOLEAN	CHAR	1	0	Global Lock Set in Mandate
47	GLOBAL_LOCK_FROM	☐	SEPA_GLOCK_VAL_FROM_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid From
48	GLOBAL_LOCK_TO	☐	SEPA_GLOCK_VAL_TO_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid Until
49	FIRSTUSE_DATE	☐	DATUM	DATUM	DATS	8	0	Date
50	FIRSTUSE_DOCTYPE	☐	SEPA_FIRSTUSE_DOCTYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Type of First Usage
51	FIRSTUSE_DOCID	☐	SEPA_FIRSTUSE_DOCID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: ID of First Usage
52	LASTUSE_DATE	☐	DATUM	DATUM	DATS	8	0	Date
53	LASTUSE_DOCTYPE	☐	SEPA_LASTUSE_DOCTYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Type of Last Usage
54	LASTUSE_DOCID	☐	SEPA_LASTUSE_DOCID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: ID of Last Usage
55	SEPA_CREDITOR_ID_ORIGIN	☐	SEPA_CRDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Creditor ID of Mandate
56	SEPA_MANDATE_ID_ORIGIN	☐	SEPA_MNDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Mandate of Mandate
57	VERSION	☐	SEPA_MVERS	NUM04	NUMC	4	0	SEPA Mandate: Version of Mandate (0 = Current Version)
58	CREATOR	☐	CNAM	SYCHAR12	CHAR	12	0	Author
59	CREATIONDATE	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
60	CREATIONTIME	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
61	BUAG_ID	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
62	DATAX	☐	BUS_EI_COM_SEPA_MANDATE_DATAX		STRU	0	0
63	APPLICATION	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
64	SEPA_CREDITOR_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
65	SEPA_MANDATE_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
66	PAY_TYPE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
67	SND_TYPE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
68	SND_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
69	SND_NAME1	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
70	SND_NAME2	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
71	SND_STREET	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
72	SND_HOUSENUM	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
73	SND_POSTAL	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
74	SND_CITY	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
75	SND_COUNTRY	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
76	SND_LANGUAGE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
77	SND_IBAN	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
78	SND_BIC	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
79	SND_DIR_NAME	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
80	REC_TYPE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
81	REC_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
82	REC_NAME1	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
83	REC_NAME2	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
84	REC_STREET	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
85	REC_HOUSENUM	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
86	REC_POSTAL	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
87	REC_CITY	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
88	REC_COUNTRY	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
89	REF_TYPE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
90	REF_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
91	REF_DESC	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
92	LIFETIME_FROM	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
93	LIFETIME_TO	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
94	SIGN_CITY	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
95	SIGN_DATE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
96	STATUS	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
97	SND_DIR_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
98	REC_DIR_NAME	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
99	REC_DIR_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
100	B2B	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
101	SND_DEBTOR_ID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
102	ORGF1	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
103	ORGF2	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
104	ORGF3	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
105	ORGF4	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
106	GLOBAL_LOCK	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
107	GLOBAL_LOCK_FROM	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
108	GLOBAL_LOCK_TO	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
109	FIRSTUSE_DATE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
110	FIRSTUSE_DOCTYPE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
111	FIRSTUSE_DOCID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
112	LASTUSE_DATE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
113	LASTUSE_DOCTYPE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
114	LASTUSE_DOCID	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
115	SEPA_CREDITOR_ID_ORIGIN	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
116	SEPA_MANDATE_ID_ORIGIN	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
117	VERSION	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
118	CREATOR	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
119	CREATIONDATE	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field
120	CREATIONTIME	☐	GB_BAPIUPD	CHAR1	CHAR	1	0	R3A BP: Change Information for Relevant User Data Field

History

Last changed by/on	SAP	20130604
SAP Release Created in