SAP ABAP Table ISU_BI_BILL_S_SEPA_PRENO (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
⤷ IS-U-IN (Application Component) Invoicing
⤷ EE22 (Package) IS-U: Bill Printout
Basic Data
Table Category | INTTAB | Structure |
Structure | ISU_BI_BILL_S_SEPA_PRENO | 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 | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | WA_SEPA_PRENO | 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 |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |