NSDM_e_V_SLGH_2

DDL: NSDM_DDL_V_SLGH_2 SQL: NSDM_V_SLGH_2 Type: view

V_SLGH_2 Compatibility View

NSDM_e_V_SLGH_2 is a CDS View that provides data about "V_SLGH_2 Compatibility View" in SAP S/4HANA. It reads from 5 data sources (mara, nsdm_e_marc, mcha, nsdm_e_mchb, Mbv_Mbew) and exposes 23 fields with key fields mandt, werks, lgort, mtart, bwkey.

Data Sources (5)

SourceAliasJoin Type
mara a from
nsdm_e_marc b inner
mcha c inner
nsdm_e_mchb d inner
Mbv_Mbew f inner

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName NSDM_V_SLGH_2 view
EndUserText.label V_SLGH_2 Compatibility View view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.viewEnhancementCategory #PROJECTION_LIST view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY mandt nsdm_e_mchb mandt Editing Client
KEY werks nsdm_e_mchb werks Receiving Plant
KEY lgort nsdm_e_mchb lgort Sublocation
KEY mtart mara mtart Product Type
KEY bwkey Mbv_Mbew bwkey Valuation Area
KEY bwtar Mbv_Mbew bwtar Valuation Type
KEY matnr nsdm_e_mchb matnr Vehicle Model
KEY charg mcha charg Chargeable Proc.
lvorm mara lvorm Stock del. flag
maabc nsdm_e_marc maabc ABC Indicator
kzkri nsdm_e_marc kzkri Critical Part
xchpf nsdm_e_marc xchpf Batch Mgmt Rqt(Plnt)
vprsv Mbv_Mbew vprsv Price control
verpr Mbv_Mbew verpr Moving price
stprs Mbv_Mbew stprs Standard price
peinh Mbv_Mbew peinh Unit of measure
bwtar2 mcha bwtar Valuation Type
clabs nsdm_e_mchb clabs Unrestricted
cinsm nsdm_e_mchb cinsm Quality Insp.
ceinm nsdm_e_mchb ceinm Restricted-Use
kzicl nsdm_e_mchb kzicl Warehouse stock
kzicq nsdm_e_mchb kzicq QualInspStock
sernp nsdm_e_marc sernp SerialNoProfile

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 NSDM_e_V_SLGH_2.
-- 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: NSDM_V_SLGH_2

CREATE VIEW NSDM_e_V_SLGH_2 AS
SELECT
  d.mandt AS mandt,
  d.werks AS werks,
  d.lgort AS lgort,
  a.mtart AS mtart,
  f.bwkey AS bwkey,
  f.bwtar AS bwtar,
  d.matnr AS matnr,
  c.charg AS charg,
  a.lvorm AS lvorm,
  b.maabc AS maabc,
  b.kzkri AS kzkri,
  b.xchpf AS xchpf,
  f.vprsv AS vprsv,
  f.verpr AS verpr,
  f.stprs AS stprs,
  f.peinh AS peinh,
  c.bwtar AS bwtar2,
  d.clabs AS clabs,
  d.cinsm AS cinsm,
  d.ceinm AS ceinm,
  d.kzicl AS kzicl,
  d.kzicq AS kzicq,
  b.sernp AS sernp
FROM mara AS a
INNER JOIN nsdm_e_marc AS b ON /* join condition not captured in parsed metadata */
INNER JOIN mcha AS c ON /* join condition not captured in parsed metadata */
INNER JOIN nsdm_e_mchb AS d ON /* join condition not captured in parsed metadata */
INNER JOIN Mbv_Mbew AS f ON /* join condition not captured in parsed metadata */
;