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