SDM_MARC_APS_EXT_DD

DDL: SDM_MARC_APS_EXT_DD SQL: SDM_MARCAPSEXTCV Type: view
6 Fields 2 Data Sources

CDS view: migration status for marc_aps_ext for SDM

SDM_MARC_APS_EXT_DD is a CDS View that provides data about "CDS view: migration status for marc_aps_ext for SDM" in SAP S/4HANA. It reads from 2 data sources (nsdm_e_marc, marc_aps_ext) and exposes 6 fields with key fields matnr, werks.

Data Sources (2)

SourceAliasJoin Type
nsdm_e_marc b inner
marc_aps_ext c left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SDM_MARCAPSEXTCV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view: migration status for marc_aps_ext for SDM view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY matnr nsdm_e_marc matnr Vehicle Model
KEY werks nsdm_e_marc werks Receiving Plant
ext_matnr marc_aps_ext matnr Vehicle Model
dismm nsdm_e_marc dismm MRP Type
eisbe nsdm_e_marc eisbe Safety Stock
shzet nsdm_e_marc shzet Safety Time

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 SDM_MARC_APS_EXT_DD.
-- 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.
-- SQL view name: SDM_MARCAPSEXTCV

CREATE VIEW SDM_MARC_APS_EXT_DD AS
SELECT
  b.matnr AS matnr,
  b.werks AS werks,
  c.matnr AS ext_matnr,
  b.dismm AS dismm,
  b.eisbe AS eisbe,
  b.shzet AS shzet
INNER JOIN nsdm_e_marc AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN marc_aps_ext AS c ON /* join condition not captured in parsed metadata */
;

Learn More