SAP ABAP Table RJSEPAWUL_MSDREC (SEPA: IS-M/SD Research in Where-Used List)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
Basic Data
Table Category | INTTAB | Structure |
Structure | RJSEPAWUL_MSDREC | Table Relationship Diagram |
Short Description | SEPA: IS-M/SD Research in Where-Used List |
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 | GPNR_REGUL | GPNR_REGUL | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Number Payer | * | |
2 | ISMADDRESS | LINES | LINES | CHAR | 80 | 0 | Address line | ||
3 | RENR | RECHERNR | RECHERNR | NUMC | 10 | 0 | IS-M: Research Number | * | |
4 | REART | RECHART | RECHART | CHAR | 2 | 0 | IS-M: Research Type | * | |
5 | RFBSK | RFBSK_BR | RFBSK_BR | CHAR | 1 | 0 | IS-M: Status for Transfer to FI (Bank Returns) | ||
6 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
7 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
8 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
9 | RUECKGRUND | RUECKGRUND | RUECKGRUND | CHAR | 3 | 0 | IS-M: Bank Return Reason | * | |
10 | BANKAUSDAT | BANKAUSDAT | BANKAUSDAT | DATS | 8 | 0 | IS-M: Bank Statement Date | ||
11 | REERG | RECHERG | RECHERG | CHAR | 3 | 0 | Research Result | * | |
12 | RUECKBETR | RUECKBETR | WERTV7 | CURR | 13 | 2 | IS-M: Billing Amount for Bank Return | ||
13 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
14 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
15 | .INCLUDE | 0 | 0 | SEPA Mandate: Standard Fields (Cannot be Enhanced) | |||||
16 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
17 | MVERS | SEPA_MVERS | NUM04 | NUMC | 4 | 0 | SEPA Mandate: Version of Mandate (0 = Current Version) | ||
18 | .INCLUDE | 0 | 0 | SEPA Mandate: Management Data | |||||
19 | .INCLUDE | 0 | 0 | SEPA Mandate: Management Data (External Fields) | |||||
20 | SIGN_CITY | SEPA_SIGN_CITY | TEXT40 | CHAR | 40 | 0 | Location of Signature | ||
21 | SIGN_DATE | SEPA_SIGN_DATE | DATUM | DATS | 8 | 0 | Date of Signature | ||
22 | PAY_TYPE | SEPA_PAY_TYPE | SEPA_PAY_TYPE | CHAR | 1 | 0 | SEPA: Payment Type | ||
23 | VAL_FROM_DATE | SEPA_VAL_FROM_DATE | DATUM | DATS | 8 | 0 | SEPA: Validity Date of Mandate (From) | ||
24 | VAL_TO_DATE | SEPA_VAL_TO_DATE | DATUM | DATS | 8 | 0 | SEPA: Validity Date of Mandate (To) | ||
25 | STATUS | SEPA_STATUS | SEPA_STATUS | CHAR | 1 | 0 | SEPA: Mandate Status | ||
26 | B2B | SEPA_B2B | XFELD | CHAR | 1 | 0 | SEPA-Mandate: B2B Mandate | ||
27 | REASON_CODE | SEPA_REASON_CODE | SEPA_REASON_CODE | CHAR | 3 | 0 | Reason Code for Status Change | SEPA_RC_CUST | |
28 | .INCLUDE | 0 | 0 | SEPA Mandate: Management Data (Internal Data) | |||||
29 | ERNAM | SEPA_ERNAM | SYCHAR12 | CHAR | 12 | 0 | User who Created the Current Version of the Mandate | ||
30 | ERDAT | SEPA_ERDAT | DATUM | DATS | 8 | 0 | Date on Which the Current Mandate Version was Created | ||
31 | ERTIM | SEPA_ERTIM | UZEIT | TIMS | 6 | 0 | Time at Which the Current Mandate Version was Created | ||
32 | CHG_REASON | SEPA_CHG_REASON | SEPA_CHG_REASON | CHAR | 5 | 0 | SEPA: Reason for Change | ||
33 | ORIGIN | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
34 | ORIGIN_REC_CRDID | SEPA_CRDID_ORIGIN | ID035 | CHAR | 35 | 0 | SEPA Mandate: Original Creditor ID of Mandate | ||
35 | ORIGIN_MNDID | SEPA_MNDID_ORIGIN | ID035 | CHAR | 35 | 0 | SEPA Mandate: Original Mandate of Mandate | ||
36 | GLOCK | SEPA_GLOCK | BOOLEAN | CHAR | 1 | 0 | Global Lock Set in Mandate | ||
37 | GLOCK_VAL_FROM | SEPA_GLOCK_VAL_FROM_DATE | DATUM | DATS | 8 | 0 | Global Mandate Lock - Valid From | ||
38 | GLOCK_VAL_TO | SEPA_GLOCK_VAL_TO_DATE | DATUM | DATS | 8 | 0 | Global Mandate Lock - Valid Until | ||
39 | ANWND | SEPA_ANWND | SEPA_ANWND | CHAR | 1 | 0 | SEPA: Application for Which Mandate Relevant | * | |
40 | ORI_ERNAM | SEPA_ORI_ERNAM | SYCHAR12 | CHAR | 12 | 0 | User who Created the Original Mandate | ||
41 | ORI_ERDAT | SEPA_ORI_ERDAT | DATUM | DATS | 8 | 0 | Date on Which Original Mandate Created | ||
42 | ORI_ERTIM | SEPA_ORI_ERTIM | UZEIT | TIMS | 6 | 0 | Time when Original Mandate Was Created | ||
43 | .INCLUDE | 0 | 0 | SEPA Mandate: Data for Referencing to Other Objects | |||||
44 | .INCLUDE | 0 | 0 | SEPA Mandate: ID of Referenced Object | |||||
45 | REF_TYPE | SEPA_REF_TYPE | OJ_NAME | CHAR | 10 | 0 | SEPA Mandate: Reference Type | * | |
46 | REF_ID | SEPA_REF_ID | SWO_TYPEID | CHAR | 70 | 0 | SEPA Mandate: Reference ID | ||
47 | .INCLUDE | 0 | 0 | SEPA Mandate: Data of Referenced Object | |||||
48 | REF_DESC | TEXT50 | TEXT50 | CHAR | 50 | 0 | Text Field | ||
49 | .INCLUDE | 0 | 0 | SEPA Mandate: Sender Data (Debited Bank Account) | |||||
50 | .INCLUDE | 0 | 0 | SEPA Mandate: ID of Sender | |||||
51 | SND_TYPE | SEPA_SND_TYPE | OJ_NAME | CHAR | 10 | 0 | SEPA Mandate: Sender Type | * | |
52 | SND_ID | SEPA_SND_ID | SWO_TYPEID | CHAR | 70 | 0 | SEPA Mandate: Sender ID | ||
53 | .INCLUDE | 0 | 0 | SEPA Mandate: Sender Data | |||||
54 | SND_NAME1 | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
55 | SND_NAME2 | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
56 | SND_STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
57 | SND_HOUSENUM | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
58 | SND_POSTAL | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
59 | SND_CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
60 | SND_COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
61 | SND_IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
62 | SND_BIC | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
63 | SND_DIR_NAME | SEPA_PAYMENT_FOR | BU_NAME | CHAR | 40 | 0 | SEPA: Name of Alternative Debtor | ||
64 | SND_LANGUAGE | LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
65 | SND_DIR_ID | SEPA_SND_DIR_ID | SWO_TYPEID | CHAR | 70 | 0 | SEPA: ID of Alternative Debtor | ||
66 | SND_DEBTOR_ID | SEPA_SND_DEBTOR_ID | ID035 | CHAR | 35 | 0 | SEPA: ID Number of Sender (External Reference) | ||
67 | .INCLUDE | 0 | 0 | SEPA Mandate: Recipient Data (Beneficiary Bank Account) | |||||
68 | .INCLUDE | 0 | 0 | SEPA Mandate: ID of Recipient | |||||
69 | REC_TYPE | SEPA_REC_TYPE | OJ_NAME | CHAR | 10 | 0 | SEPA Mandate: Recipient Type | * | |
70 | REC_ID | SEPA_REC_ID | SWO_TYPEID | CHAR | 70 | 0 | SEPA Mandate: Recipient ID | ||
71 | .INCLUDE | 0 | 0 | SEPA Mandate: Recipient Data | |||||
72 | REC_NAME1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
73 | REC_NAME2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
74 | REC_CRDID | SEPA_CRDID | ID035 | CHAR | 35 | 0 | Creditor Identification Number | ||
75 | REC_STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
76 | REC_HOUSENUM | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
77 | REC_POSTAL | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
78 | REC_CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
79 | REC_COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
80 | REC_DIR_NAME | SEPA_REC_DIR_NAME | BU_NAME | CHAR | 40 | 0 | SEPA: Name of Alternative Payee | ||
81 | REC_DIR_ID | SEPA_REC_DIR_ID | SWO_TYPEID | CHAR | 70 | 0 | SEPA: ID of Alternative Payee | ||
82 | .INCLUDE | 0 | 0 | SEPA Mandate: Usage Data | |||||
83 | FIRSTUSE_DATE | SEPA_FIRSTUSE_DATE | DATUM | DATS | 8 | 0 | SEPA Mandate: Date of First Use | ||
84 | FIRSTUSE_DOCTYPE | SEPA_FIRSTUSE_DOCTYPE | OJ_NAME | CHAR | 10 | 0 | SEPA Mandate: Type of First Usage | * | |
85 | FIRSTUSE_DOCID | SEPA_FIRSTUSE_DOCID | SWO_TYPEID | CHAR | 70 | 0 | SEPA Mandate: ID of First Usage | ||
86 | LASTUSE_DATE | SEPA_LASTUSE_DATE | DATUM | DATS | 8 | 0 | SEPA Mandate: Date of Last Use | ||
87 | LASTUSE_DOCTYPE | SEPA_LASTUSE_DOCTYPE | OJ_NAME | CHAR | 10 | 0 | SEPA Mandate: Type of Last Usage | * | |
88 | LASTUSE_DOCID | SEPA_LASTUSE_DOCID | SWO_TYPEID | CHAR | 70 | 0 | SEPA Mandate: ID of Last Usage | ||
89 | FIRSTUSE_PAYRUN | SEPA_FIRSTUSE_PAYRUNID | CHAR16 | CHAR | 16 | 0 | SEPA Mandate: ID of Payment Run of First Use | ||
90 | .INCLUDE | 0 | 0 | SEPA Mandate: Internal Organizational Data | |||||
91 | ORGF1 | SEPA_ORG_ID | CHAR20 | CHAR | 20 | 0 | SEPA Mandate: Internal Organizational Data | ||
92 | ORGF2 | SEPA_ORG_ID | CHAR20 | CHAR | 20 | 0 | SEPA Mandate: Internal Organizational Data | ||
93 | ORGF3 | SEPA_ORG_ID_LONG | CHAR35 | CHAR | 35 | 0 | SEPA Mandate: Internal Organizational Data | ||
94 | ORGF4 | SEPA_ORG_ID_LONG | CHAR35 | CHAR | 35 | 0 | SEPA Mandate: Internal Organizational Data | ||
95 | ALVSTYLE | LVC_T_STYL | TTYP | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RJSEPAWUL_MSDREC | REASON_CODE | SEPA_RC_CUST | REASON_CODE | |||
2 | RJSEPAWUL_MSDREC | REC_COUNTRY | T005 | LAND1 | |||
3 | RJSEPAWUL_MSDREC | SND_COUNTRY | T005 | LAND1 | |||
4 | RJSEPAWUL_MSDREC | SND_LANGUAGE | T002 | SPRAS |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |