APS_ODA_SOD2_TO_SRVB_MAPPING
SOD2 to SRVB Mapping
APS_ODA_SOD2_TO_SRVB_MAPPING is a CDS View that provides data about "SOD2 to SRVB Mapping" in SAP S/4HANA. It reads from 5 data sources (I_ODACHANGELOG_API, srvb_details, APS_TADIR, APS_TADIR, E_SRVD_RT_ANNOS_T) and exposes 5 fields. Part of development package S_APS_ODA_API.
Data Sources (5)
| Source | Alias | Join Type |
|---|---|---|
| I_ODACHANGELOG_API | api | from |
| srvb_details | srvb_details | inner |
| APS_TADIR | srvb_tadir_info | left_outer |
| APS_TADIR | srvd_tadir_info | left_outer |
| E_SRVD_RT_ANNOS_T | srvd_text_annotation | left_outer |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | SOD2 to SRVB Mapping | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
Fields (5)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| object_type | I_ODACHANGELOG_API | object_type | Type | |
| object_id | I_ODACHANGELOG_API | object_id | Transaction ID | |
| srvb_name | service_binding | srvb_name | Service Binding | |
| srvd_name | service_binding | srvdname | Name of SRVD Source | |
| srvd_title | E_SRVD_RT_ANNOS_T | text | User Group |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view APS_ODA_SOD2_TO_SRVB_MAPPING.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW APS_ODA_SOD2_TO_SRVB_MAPPING AS
SELECT
api.object_type AS object_type,
api.object_id AS object_id,
service_binding.srvb_name AS srvb_name,
service_binding.srvdname AS srvd_name,
srvd_text_annotation.text AS srvd_title
FROM I_ODACHANGELOG_API AS api
INNER JOIN srvb_details ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_TADIR AS srvb_tadir_info ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_SRVD_RT_ANNOS_T AS srvd_text_annotation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_TADIR AS srvd_tadir_info ON /* join condition not captured in parsed metadata */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA