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