SAP ABAP Table FICA_MANDATE_STR_ITEM (SEPA Mandate Positions)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKK_SEPA (Package) FI-CA: SEPA

Basic Data

Table Category	INTTAB	Structure
Structure	FICA_MANDATE_STR_ITEM	Table Relationship Diagram
Short Description	SEPA Mandate Positions

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	WA_ITEM	☐	SEPA_STR_DATA_MANDATE_DATA		STRU	0	0
2	MGUID	☐	GUID		RAW	16	0	Globally Unique Identifier
3	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
4	MVERS	☐	SEPA_MVERS	NUM04	NUMC	4	0	SEPA Mandate: Version of Mandate (0 = Current Version)
5	.INCLUDE	☐				0	0	SEPA Mandate: Management Data
6	.INCLUDE	☐				0	0	SEPA Mandate: Management Data (External Fields)
7	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
8	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
9	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
10	VAL_FROM_DATE	☐	SEPA_VAL_FROM_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (From)
11	VAL_TO_DATE	☐	SEPA_VAL_TO_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (To)
12	STATUS	☐	SEPA_STATUS	SEPA_STATUS	CHAR	1	0	SEPA: Mandate Status
13	B2B	☐	SEPA_B2B	XFELD	CHAR	1	0	SEPA-Mandate: B2B Mandate
14	REASON_CODE	☐	SEPA_REASON_CODE	SEPA_REASON_CODE	CHAR	3	0	Reason Code for Status Change
15	.INCLUDE	☐				0	0	SEPA Mandate: Management Data (Internal Data)
16	ERNAM	☐	SEPA_ERNAM	SYCHAR12	CHAR	12	0	User who Created the Current Version of the Mandate
17	ERDAT	☐	SEPA_ERDAT	DATUM	DATS	8	0	Date on Which the Current Mandate Version was Created
18	ERTIM	☐	SEPA_ERTIM	UZEIT	TIMS	6	0	Time at Which the Current Mandate Version was Created
19	CHG_REASON	☐	SEPA_CHG_REASON	SEPA_CHG_REASON	CHAR	5	0	SEPA: Reason for Change
20	ORIGIN	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
21	ORIGIN_REC_CRDID	☐	SEPA_CRDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Creditor ID of Mandate
22	ORIGIN_MNDID	☐	SEPA_MNDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Mandate of Mandate
23	GLOCK	☐	SEPA_GLOCK	BOOLEAN	CHAR	1	0	Global Lock Set in Mandate
24	GLOCK_VAL_FROM	☐	SEPA_GLOCK_VAL_FROM_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid From
25	GLOCK_VAL_TO	☐	SEPA_GLOCK_VAL_TO_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid Until
26	ANWND	☐	SEPA_ANWND	SEPA_ANWND	CHAR	1	0	SEPA: Application for Which Mandate Relevant
27	ORI_ERNAM	☐	SEPA_ORI_ERNAM	SYCHAR12	CHAR	12	0	User who Created the Original Mandate
28	ORI_ERDAT	☐	SEPA_ORI_ERDAT	DATUM	DATS	8	0	Date on Which Original Mandate Created
29	ORI_ERTIM	☐	SEPA_ORI_ERTIM	UZEIT	TIMS	6	0	Time when Original Mandate Was Created
30	.INCLUDE	☐				0	0	SEPA Mandate: Data for Referencing to Other Objects
31	.INCLUDE	☐				0	0	SEPA Mandate: ID of Referenced Object
32	REF_TYPE	☐	SEPA_REF_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Reference Type
33	REF_ID	☐	SEPA_REF_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Reference ID
34	.INCLUDE	☐				0	0	SEPA Mandate: Data of Referenced Object
35	REF_DESC	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
36	.INCLUDE	☐				0	0	SEPA Mandate: Sender Data (Debited Bank Account)
37	.INCLUDE	☐				0	0	SEPA Mandate: ID of Sender
38	SND_TYPE	☐	SEPA_SND_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Sender Type
39	SND_ID	☐	SEPA_SND_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Sender ID
40	.INCLUDE	☐				0	0	SEPA Mandate: Sender Data
41	SND_NAME1	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
42	SND_NAME2	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
43	SND_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
44	SND_HOUSENUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
45	SND_POSTAL	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
46	SND_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
47	SND_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
48	SND_IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
49	SND_BIC	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
50	SND_DIR_NAME	☐	SEPA_PAYMENT_FOR	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Debtor
51	SND_LANGUAGE	☐	LANGU	SPRAS	LANG	1	0	Language Key
52	SND_DIR_ID	☐	SEPA_SND_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Debtor
53	SND_DEBTOR_ID	☐	SEPA_SND_DEBTOR_ID	ID035	CHAR	35	0	SEPA: ID Number of Sender (External Reference)
54	.INCLUDE	☐				0	0	SEPA Mandate: Recipient Data (Beneficiary Bank Account)
55	.INCLUDE	☐				0	0	SEPA Mandate: ID of Recipient
56	REC_TYPE	☐	SEPA_REC_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Recipient Type
57	REC_ID	☐	SEPA_REC_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Recipient ID
58	.INCLUDE	☐				0	0	SEPA Mandate: Recipient Data
59	REC_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
60	REC_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
61	REC_CRDID	☐	SEPA_CRDID	ID035	CHAR	35	0	Creditor Identification Number
62	REC_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
63	REC_HOUSENUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
64	REC_POSTAL	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
65	REC_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
66	REC_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
67	REC_DIR_NAME	☐	SEPA_REC_DIR_NAME	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Payee
68	REC_DIR_ID	☐	SEPA_REC_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Payee
69	.INCLUDE	☐				0	0	SEPA Mandate: Usage Data
70	FIRSTUSE_DATE	☐	SEPA_FIRSTUSE_DATE	DATUM	DATS	8	0	SEPA Mandate: Date of First Use
71	FIRSTUSE_DOCTYPE	☐	SEPA_FIRSTUSE_DOCTYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Type of First Usage
72	FIRSTUSE_DOCID	☐	SEPA_FIRSTUSE_DOCID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: ID of First Usage
73	LASTUSE_DATE	☐	SEPA_LASTUSE_DATE	DATUM	DATS	8	0	SEPA Mandate: Date of Last Use
74	LASTUSE_DOCTYPE	☐	SEPA_LASTUSE_DOCTYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Type of Last Usage
75	LASTUSE_DOCID	☐	SEPA_LASTUSE_DOCID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: ID of Last Usage
76	FIRSTUSE_PAYRUN	☐	SEPA_FIRSTUSE_PAYRUNID	CHAR16	CHAR	16	0	SEPA Mandate: ID of Payment Run of First Use
77	VERSION_CHG	☐	SEPA_VERSION_CHG	BOOLEAN	CHAR	1	0	Version 0 changed in LUW
78	.INCLUDE	☐				0	0	SEPA Mandate: Internal Organizational Data
79	ORGF1	☐	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
80	ORGF2	☐	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
81	ORGF3	☐	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data
82	ORGF4	☐	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data
83	REC_ID_CRDID	☐	SEPA_ID_CRDID	ID035	CHAR	35	0	Creditor ID Without Business Code
84	.INCLU--AP	☐				0	0	F15 Append f. Mandatsdaten im Applikation Layer
85	.INCLUDE	☐				0	0	F15 SEPA-Mandat: Bewirtschafterdaten
86	/SAPF15/F15_BW	☐	/SAPF15/BEWIRTSCHAFTER	/SAPF15/BEWIRTSCHAFTER	CHAR	8	0	Bewirtschafter
87	/SAPF15/F15_KZ	☐	/SAPF15/KASSENZEICHEN	CHAR12	CHAR	12	0	Kassenzeichen
88	/SAPF15/GUID	☐	/SAPF15/GUID	SYSUUID	RAW	16	0	GUID
89	.INCLU--AP	☐				0	0	Append Structure for BCA to store contract id and desc
90	.INCLUDE	☐				0	0	BKK:SEPA Mandate Contract Details
91	CONTRACT_ID	☐	BKK_DTE_MND_CONTRACT_ID	BKK_MANDATE_CONTRACT	CHAR	50	0	BKK: SEPA Mandate Contract ID
92	CONTRACT_DESC	☐	BKK_DTE_MND_CONTRACT_DESC	BKK_MANDATE_CONTRACT	CHAR	50	0	BKK:SEPA Mandate Contract Description

History

Last changed by/on	SAP	20131127
SAP Release Created in