Nsdm_Ddl_Disc_Bottom

DDL: NSDM_DDL_DISC_BOTTOM SQL: NSDM_V_DISC_BOT Type: view
49 Fields 4 Data Sources

Discrepancy check bottom level

Nsdm_Ddl_Disc_Bottom is a CDS View that provides data about "Discrepancy check bottom level" in SAP S/4HANA. It reads from 4 data sources (matdoc, matdoc, matdoc_extract, matdoc_extract) and exposes 49 fields.

Data Sources (4)

SourceAliasJoin Type
matdoc matdoc from
matdoc matdoc union_all
matdoc_extract matdoc_extract union_all
matdoc_extract matdoc_extract union_all

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName NSDM_V_DISC_BOT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Discrepancy check bottom level view
DataAging.noAgingRestriction false 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

Fields (49)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
TableName
matbf matbf Stock Mat.
werks werks Receiving Plant
lgort_sid lgort_sid Stor. Location SID
charg_sid charg_sid Batch SID
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
kunnr_sid kunnr_sid Customer SID
sobkz sobkz Special Stock
lbbsa_sid lbbsa_sid Stock Type
meins meins Valuation Unit
TableName
matbf matbf Stock Mat.
werks werks Receiving Plant
lgort_sid lgort_sid Stor. Location SID
charg_sid charg_sid Batch SID
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
kunnr_sid kunnr_sid Customer SID
sobkz sobkz Special Stock
lbbsa_sid lbbsa_sid Stock Type
meins meins Valuation Unit
TableName
matbf matbf Stock Mat.
werks werks Receiving Plant
lgort_sid lgort_sid Stor. Location SID
charg_sid Batch SID
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
kunnr_sid kunnr_sid Customer SID
sobkz sobkz Special Stock
lbbsa_sid lbbsa_sid Stock Type
meins meins Valuation Unit
TableName
matbf matbf Stock Mat.
werks werks Receiving Plant
lgort_sid lgort_sid Stor. Location SID
charg_sid Batch SID
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
kunnr_sid kunnr_sid Customer SID
sobkz sobkz Special Stock
lbbsa_sid lbbsa_sid Stock Type
meins meins Valuation Unit

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_Ddl_Disc_Bottom.
-- 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_DISC_BOT

CREATE VIEW Nsdm_Ddl_Disc_Bottom AS
SELECT
  mandt,
  cast('MATDOC_BT' as tabname) AS TableName,
  matbf,
  werks,
  lgort_sid,
  charg_sid,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  kunnr_sid,
  sobkz,
  lbbsa_sid,
  meins
FROM matdoc
-- UNION ALL with additional select branch(es): matdoc_extract, matdoc
;

Learn More