REF_ID in SEPA_MANDATE
Reference ID (DE: ReferenzID)
REF_ID is a field in SAP table SEPA_MANDATE (SEPA Mandate). It represents "Reference ID". Data element: SEPA_REF_ID. Available in 15 CDS view(s) as SEPAMandateReference, MandateReference.
Business Meaning
| Description (EN) | Reference ID |
|---|---|
| Beschreibung (DE) | ReferenzID |
| Data Element | SEPA_REF_ID |
| Key Field | No |
CDS Views & Technical Names (15)
SEPA_MANDATE.REF_ID is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
SEPAMandateReference
(10 views)
Mandate: Reference ID
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_SEPAMandate | direct | BASIC | Sepa Mandate | |
| I_SEPAMandateBasic | direct | BASIC | SEPA Mandate | |
| I_CustomerSEPAMandate | via 2 level | COMPOSITE | Customer SEPA Mandate | |
| I_FinSEPAMandate | via 2 level | TRANSACTIONAL | Financial SEPA Mandate | |
| P_ManageSEPAMandate | via 2 level | COMPOSITE | ||
| R_SEPAMandateTP | via 2 level | TRANSACTIONAL | SEPA Mandate - TP | |
| C_ManageSEPAMandate | via 3 levels | CONSUMPTION | Manage SEPA Mandate | |
| R_FinSEPAMandateDraftTP | via 3 levels | TRANSACTIONAL | Financial SEPA Mandate Draft | |
| C_OneTimeAcctSEPAMandtDraftTP | via 4 levels | CONSUMPTION | SEPA Mandate for One Time Account | |
| C_OneTimeAcctSEPAMandtList | via 4 levels | CONSUMPTION | SEPA Mandate List for One Time Account |
MandateReference
(5 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_DirectDebitMandate | via 2 level | TRANSACTIONAL | Direct Debit Mandate Private | |
| R_DirectDebitMandateTP | via 3 levels | TRANSACTIONAL | Direct Debit Mandate TP | |
| R_DirectDebitMandateVersionTP | via 3 levels | TRANSACTIONAL | Direct Debit Mandate Version TP | |
| C_DirectDebitMandateTP | via 4 levels | CONSUMPTION | Direct Debit Mandate Projection TP | |
| C_DirectDebitMandateVersionTP | via 4 levels | CONSUMPTION | Direct Debit Mandate Version TP |
Other Tables with Field REF_ID (23)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /LTB/TR_HDR | /LTB/TR_REF_ID | Transformation Rule: Header | |
| /LTB/TRHDR | /LTB/TR_REF_ID | Transformation Rule: Header | |
| /SSB/EVALS | /SSB/ID | Evaluations of Indicators in SAP Smart Business | |
| /SSB/RPT_CONF | /SSB/ID | Configuration table for Reports of Smart Business | |
| APOC_D_OR_DOC | /BOBF/CONF_KEY | APOC Document Index table | |
| BNK_BTCH_STREF | BNK_COM_REF_ID | Status reference | |
| CMS_RBL | CMS_DTE_RBL_REFID | Receivable Details | |
| DMCUT_RAPTSTHDR | ABAP.CHAR | MC UT - Header Table | |
| EHHSSD_RSK_CTRL | EHFND_TO_ID | Risk - Control | |
| ISLM_MDLVRSN | ISLM_DE_REFERENCE_ID | ISLM Model Versions | |
| PYC_D_TASK_STEPT | PYC_UUID | KEY | Activity Step Assignment Text |
| PYC_D_TL_REC | PYC_UUID | KEY | Payroll Activity List Recurrence |
| PYC_D_TL_RECT | PYC_UUID | KEY | Payroll Activity List Recurrence Text |
| PYC_D_TL_TASK_T | PYC_UUID | KEY | Payroll Control Center: Activity List - Activity Assignment |
| PYC_D_TLT | PYC_UUID | KEY | Payroll Control Center: Activity List Text |
| PYT_D_ACL_RESO | PYC_UUID | KEY | PCC: Activity List Recurrence Result |
| PYT_D_ACT_RESO | PYC_UUID | KEY | Activity Recurrence Result |
| PYT_D_ACTRESS | PYC_UUID | KEY | PCC Activity List: ACTivity REcurrence SelectionS |
| PYT_D_ALERT | PYC_UUID | KEY | PCC: Activity Alert |
| PYT_D_BPC | PYC_UUID | KEY | PCC Activity List: Background Processing Component Root |
| PYT_D_OC_REG | PYC_UUID | KEY | Ad-hoc Off-Cycle Registration |
| PYT_D_STEP_RESO | PYC_UUID | KEY | Step Recurrence Result |
| SMMAIN | SCHEDMAN_SCHEDULERID | Main Information for an Entry in the Monitor |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA