SAP ABAP Table ISU_BI_COLL_BILL_S_CSEPA_PREN (SEPA Direct Debit Pre-Notification)

Hierarchy

☛

IS-UT (Software Component) SAP Utilities/Telecommunication
⤷

IS-U-IN (Application Component) Invoicing
⤷

EE22 (Package) IS-U: Bill Printout

Basic Data

Table Category	INTTAB	Structure
Structure	ISU_BI_COLL_BILL_S_CSEPA_PREN	Table Relationship Diagram
Short Description	SEPA Direct Debit Pre-Notification

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description
1	WA_CSEPA_PREN	DFKKPRNH		STRU	0	0
2	MANDT	MANDT	MANDT	CLNT	3	0	Client
3	PNNUM	PNNUM_KK	PNNUM_KK	CHAR	16	0	SEPA: Number of Direct Debit Pre-Notification
4	PNHKF	PNHKF_KK	PNHKF_KK	CHAR	2	0	SEPA: Origin of Direct Debit Pre-Notification
5	GPART	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number
6	ORI_GPART	ORI_GPART_KK	BU_PARTNER	CHAR	10	0	Alternative Business Partner from Posting Doocument
7	PNEXD	PNEXD_KK	DATUM	DATS	8	0	SEPA: Date of Execution of Direct Debit Pre-Notifcation
8	PNSTA	PNSTA_KK	PNSTA_KK	CHAR	1	0	SEPA: Status of Direct Debit Pre-Notification
9	MNDID	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
10	BETRW	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
11	BETRW_ACT	BETRW_ACT_KK	WRTV7	CURR	13	2	Current Amount of Direct Debit Pre-Notification
12	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key
13	LAUFD_CRE	LAUFD_KK	DATUM	DATS	8	0	Date ID
14	LAUFI_CRE	LAUFI_KK	LAUFI_KK	CHAR	6	0	Additional Identification Characteristic
15	PAYNO	PAYNO_PAY	INT4_NOS	INT4	10	0	Sequential payment number
16	DOC1R	DOC1R_PAY	CHAR24	CHAR	24	0	Reference to Payment Document
17	DOC1T	DOC1T_PAY	DOCTP_PAY	CHAR	2	0	Payment document category
18	CPUDT	CPUDT	DATUM	DATS	8	0	Accounting document entry date
19	CPUTM	CPUTM	UZEIT	TIMS	6	0	Time of data entry
20	COTYP	COTYP_KK	COTYP_KK	CHAR	4	0	Correspondence Type
21	COKEY	COKEY_KK	COKEY_KK	CHAR	36	0	Correspondence key
22	PNXREF	PNXREF_KK	PNXREF_KK	CHAR	16	0	SEPA: Reference to Direct Debit Pre-Notification
23	PYBUK	PYBUK_KK	BUKRS	CHAR	4	0	Company Code for Automatic Payment Transactions
24	ERNAM	ERNAM_KK	USNAM	CHAR	12	0	Created by
25	AENAM	AENAM_KK	USNAM	CHAR	12	0	Last changed by
26	AEDAT	AEDAT_KK	DATUM	DATS	8	0	Date of Last Change
27	AETIM	AETIM_KK	UZEIT	TIMS	6	0	Time at Which the Object Was Last Changed
28	ZIBAN	IBAN_KK	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
29	EMBVT	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee
30	.INCLUDE				0	0
31	.INCLUDE				0	0
32	.INCLUDE				0	0
33	.INCLUDE				0	0
34	.INCLUDE				0	0
35	.INCLUDE				0	0
36	.INCLUDE				0	0
37	WA_MANDATE	SEPA_STR_DATA_MANDATE_DATA		STRU	0	0
38	MGUID	GUID		RAW	16	0	Globally Unique Identifier
39	MNDID	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
40	MVERS	SEPA_MVERS	NUM04	NUMC	4	0	SEPA Mandate: Version of Mandate (0 = Current Version)
41	.INCLUDE				0	0	SEPA Mandate: Management Data
42	.INCLUDE				0	0	SEPA Mandate: Management Data (External Fields)
43	SIGN_CITY	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
44	SIGN_DATE	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
45	PAY_TYPE	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
46	VAL_FROM_DATE	SEPA_VAL_FROM_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (From)
47	VAL_TO_DATE	SEPA_VAL_TO_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (To)
48	STATUS	SEPA_STATUS	SEPA_STATUS	CHAR	1	0	SEPA: Mandate Status
49	B2B	SEPA_B2B	XFELD	CHAR	1	0	SEPA-Mandate: B2B Mandate
50	REASON_CODE	SEPA_REASON_CODE	SEPA_REASON_CODE	CHAR	3	0	Reason Code for Status Change
51	.INCLUDE				0	0	SEPA Mandate: Management Data (Internal Data)
52	ERNAM	SEPA_ERNAM	SYCHAR12	CHAR	12	0	User who Created the Current Version of the Mandate
53	ERDAT	SEPA_ERDAT	DATUM	DATS	8	0	Date on Which the Current Mandate Version was Created
54	ERTIM	SEPA_ERTIM	UZEIT	TIMS	6	0	Time at Which the Current Mandate Version was Created
55	CHG_REASON	SEPA_CHG_REASON	SEPA_CHG_REASON	CHAR	5	0	SEPA: Reason for Change
56	ORIGIN	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
57	ORIGIN_REC_CRDID	SEPA_CRDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Creditor ID of Mandate
58	ORIGIN_MNDID	SEPA_MNDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Mandate of Mandate
59	GLOCK	SEPA_GLOCK	BOOLEAN	CHAR	1	0	Global Lock Set in Mandate
60	GLOCK_VAL_FROM	SEPA_GLOCK_VAL_FROM_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid From
61	GLOCK_VAL_TO	SEPA_GLOCK_VAL_TO_DATE	DATUM	DATS	8	0	Global Mandate Lock - Valid Until
62	ANWND	SEPA_ANWND	SEPA_ANWND	CHAR	1	0	SEPA: Application for Which Mandate Relevant
63	ORI_ERNAM	SEPA_ORI_ERNAM	SYCHAR12	CHAR	12	0	User who Created the Original Mandate
64	ORI_ERDAT	SEPA_ORI_ERDAT	DATUM	DATS	8	0	Date on Which Original Mandate Created
65	ORI_ERTIM	SEPA_ORI_ERTIM	UZEIT	TIMS	6	0	Time when Original Mandate Was Created
66	.INCLUDE				0	0	SEPA Mandate: Data for Referencing to Other Objects
67	.INCLUDE				0	0	SEPA Mandate: ID of Referenced Object
68	REF_TYPE	SEPA_REF_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Reference Type
69	REF_ID	SEPA_REF_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Reference ID
70	.INCLUDE				0	0	SEPA Mandate: Data of Referenced Object
71	REF_DESC	TEXT50	TEXT50	CHAR	50	0	Text Field
72	.INCLUDE				0	0	SEPA Mandate: Sender Data (Debited Bank Account)
73	.INCLUDE				0	0	SEPA Mandate: ID of Sender
74	SND_TYPE	SEPA_SND_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Sender Type
75	SND_ID	SEPA_SND_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Sender ID
76	.INCLUDE				0	0	SEPA Mandate: Sender Data
77	SND_NAME1	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
78	SND_NAME2	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
79	SND_STREET	AD_STREET	TEXT60	CHAR	60	0	Street
80	SND_HOUSENUM	AD_HSNM1	TEXT10	CHAR	10	0	House Number
81	SND_POSTAL	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
82	SND_CITY	AD_CITY1	TEXT40	CHAR	40	0	City
83	SND_COUNTRY	LAND1	LAND1	CHAR	3	0	Country Key
84	SND_IBAN	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
85	SND_BIC	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
86	SND_DIR_NAME	SEPA_PAYMENT_FOR	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Debtor
87	SND_LANGUAGE	LANGU	SPRAS	LANG	1	0	Language Key
88	SND_DIR_ID	SEPA_SND_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Debtor
89	SND_DEBTOR_ID	SEPA_SND_DEBTOR_ID	ID035	CHAR	35	0	SEPA: ID Number of Sender (External Reference)
90	.INCLUDE				0	0	SEPA Mandate: Recipient Data (Beneficiary Bank Account)
91	.INCLUDE				0	0	SEPA Mandate: ID of Recipient
92	REC_TYPE	SEPA_REC_TYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Recipient Type
93	REC_ID	SEPA_REC_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Recipient ID
94	.INCLUDE				0	0	SEPA Mandate: Recipient Data
95	REC_NAME1	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
96	REC_NAME2	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
97	REC_CRDID	SEPA_CRDID	ID035	CHAR	35	0	Creditor Identification Number
98	REC_STREET	AD_STREET	TEXT60	CHAR	60	0	Street
99	REC_HOUSENUM	AD_HSNM1	TEXT10	CHAR	10	0	House Number
100	REC_POSTAL	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
101	REC_CITY	AD_CITY1	TEXT40	CHAR	40	0	City
102	REC_COUNTRY	LAND1	LAND1	CHAR	3	0	Country Key
103	REC_DIR_NAME	SEPA_REC_DIR_NAME	BU_NAME	CHAR	40	0	SEPA: Name of Alternative Payee
104	REC_DIR_ID	SEPA_REC_DIR_ID	SWO_TYPEID	CHAR	70	0	SEPA: ID of Alternative Payee
105	.INCLUDE				0	0	SEPA Mandate: Usage Data
106	FIRSTUSE_DATE	SEPA_FIRSTUSE_DATE	DATUM	DATS	8	0	SEPA Mandate: Date of First Use
107	FIRSTUSE_DOCTYPE	SEPA_FIRSTUSE_DOCTYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Type of First Usage
108	FIRSTUSE_DOCID	SEPA_FIRSTUSE_DOCID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: ID of First Usage
109	LASTUSE_DATE	SEPA_LASTUSE_DATE	DATUM	DATS	8	0	SEPA Mandate: Date of Last Use
110	LASTUSE_DOCTYPE	SEPA_LASTUSE_DOCTYPE	OJ_NAME	CHAR	10	0	SEPA Mandate: Type of Last Usage
111	LASTUSE_DOCID	SEPA_LASTUSE_DOCID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: ID of Last Usage
112	FIRSTUSE_PAYRUN	SEPA_FIRSTUSE_PAYRUNID	CHAR16	CHAR	16	0	SEPA Mandate: ID of Payment Run of First Use
113	VERSION_CHG	SEPA_VERSION_CHG	BOOLEAN	CHAR	1	0	Version 0 changed in LUW
114	.INCLUDE				0	0	SEPA Mandate: Internal Organizational Data
115	ORGF1	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
116	ORGF2	SEPA_ORG_ID	CHAR20	CHAR	20	0	SEPA Mandate: Internal Organizational Data
117	ORGF3	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data
118	ORGF4	SEPA_ORG_ID_LONG	CHAR35	CHAR	35	0	SEPA Mandate: Internal Organizational Data
119	REC_ID_CRDID	SEPA_ID_CRDID	ID035	CHAR	35	0	Creditor ID Without Business Code
120	.INCLU--AP				0	0	F15 Append f. Mandatsdaten im Applikation Layer
121	.INCLUDE				0	0	F15 SEPA-Mandat: Bewirtschafterdaten
122	/SAPF15/F15_BW	/SAPF15/BEWIRTSCHAFTER	/SAPF15/BEWIRTSCHAFTER	CHAR	8	0	Bewirtschafter
123	/SAPF15/F15_KZ	/SAPF15/KASSENZEICHEN	CHAR12	CHAR	12	0	Kassenzeichen
124	/SAPF15/GUID	/SAPF15/GUID	SYSUUID	RAW	16	0	GUID
125	.INCLU--AP				0	0	Append Structure for BCA to store contract id and desc
126	.INCLUDE				0	0	BKK:SEPA Mandate Contract Details
127	CONTRACT_ID	BKK_DTE_MND_CONTRACT_ID	BKK_MANDATE_CONTRACT	CHAR	50	0	BKK: SEPA Mandate Contract ID
128	CONTRACT_DESC	BKK_DTE_MND_CONTRACT_DESC	BKK_MANDATE_CONTRACT	CHAR	50	0	BKK:SEPA Mandate Contract Description