F_Mmim_Mcha_Dval

DDL: F_MMIM_MCHA_DVAL Type: view_entity
48 Fields 2 Data Sources 2 Associations

Help View Null Values for Stock

F_Mmim_Mcha_Dval is a CDS View that provides data about "Help View Null Values for Stock" in SAP S/4HANA. It reads from 2 data sources (mcha, marc) and exposes 48 fields with key fields SourceConstantId, Material, Plant, StorageLocation, ResourceId. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
mcha ma from
marc mc inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] F_Mmim_Mathlp_Vh _Material $projection.Material = _Material.Material
[1..1] F_Mmim_Bukrs_Plant _F_Mmim_Bukrs_Plant $projection.Plant = _F_Mmim_Bukrs_Plant.Plant

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Help View Null Values for Stock view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY SourceConstantId
KEY Material mcha matnr Vehicle Model
KEY Plant mcha werks Receiving Plant
KEY StorageLocation
KEY ResourceId
KEY Batch mcha charg Chargeable Proc.
MaterialIsBatchManaged _Material MaterialIsBatchManaged
MaterialBaseUnit _Material MaterialBaseUnit Valuation Unit
CompanyCode _F_Mmim_Bukrs_Plant CompanyCode Receiver Company Code
ValuationArea _F_Mmim_Bukrs_Plant ValuationArea Valuation Area
Currency _F_Mmim_Bukrs_Plant Currency Valuation Crcy
InventoryValuationType mcha bwtar Valuation Type
Supplier
SDDocument
SDDocumentItem
WBSElementInternalID
Customer
InventorySpecialStockType
CurrentStock
QualityInspectionStockQuantity
ReturnsBlockedStockQuantity
TransferStockStorageLocQty
TransferStockPlantQuantity
StockInTransitQuantity
BlockedStockQuantity
RestrictedStockQuantity
TiedEmptiesStockQuantity
GoodsReceiptBlockedStockQty
CurrentStockValue
QualityInspectionStockValue
ReturnsBlockedStockValue
TransferStockStorageLocValue
TransferStockPlantValue
StockInTransitValue
BlockedStockValue
RestrictedStockValue
TiedEmptiesStockValue
GoodsReceiptBlockedStockValue
CurrentStockCurVal
QualityInspectionStockCurVal
ReturnsBlockedStockCurVal
TransferStockStorageLocCurVal
TransferStockPlantCurVal
StockInTransitCurVal
BlockedStockCurVal
RestrictedStockCurVal
TiedEmptiesStockCurVal
GoodsReceiptBlockedStockCurVal

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 F_Mmim_Mcha_Dval.
-- 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 F_Mmim_Mcha_Dval AS
SELECT
  cast('02' as char02) AS SourceConstantId,
  ma.matnr AS Material,
  ma.werks AS Plant,
  cast('' as lgort_d) AS StorageLocation,
  cast('' as nsdm_resourcename) AS ResourceId,
  ma.charg AS Batch,
  _Material.MaterialIsBatchManaged AS MaterialIsBatchManaged,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  _F_Mmim_Bukrs_Plant.CompanyCode AS CompanyCode,
  _F_Mmim_Bukrs_Plant.ValuationArea AS ValuationArea,
  _F_Mmim_Bukrs_Plant.Currency AS Currency,
  ma.bwtar AS InventoryValuationType,
  cast('' as md_supplier) AS Supplier,
  cast('' as mat_kdauf) AS SDDocument,
  cast('000000' as mat_kdpos) AS SDDocumentItem,
  cast('00000000' as mat_pspnr) AS WBSElementInternalID,
  cast('' as kunnr) AS Customer,
  cast('' as sobkz) AS InventorySpecialStockType,
  cast(0 as abap.dec(21,3 ) ) AS CurrentStock,
  cast(0 as abap.dec(21,3 ) ) AS QualityInspectionStockQuantity,
  cast(0 as abap.dec(21,3 ) ) AS ReturnsBlockedStockQuantity,
  cast(0 as abap.dec(21,3 ) ) AS TransferStockStorageLocQty,
  cast(0 as abap.dec(21,3 ) ) AS TransferStockPlantQuantity,
  cast(0 as abap.dec(21,3 ) ) AS StockInTransitQuantity,
  cast(0 as abap.dec(21,3 ) ) AS BlockedStockQuantity,
  cast(0 as abap.dec(21,3 ) ) AS RestrictedStockQuantity,
  cast(0 as abap.dec(21,3 ) ) AS TiedEmptiesStockQuantity,
  cast(0 as abap.dec(18,3 ) ) AS GoodsReceiptBlockedStockQty,
  cast(0 as abap.dec(23,2 ) ) AS CurrentStockValue,
  cast(0 as abap.dec(23,2 ) ) AS QualityInspectionStockValue,
  cast(0 as abap.dec(23,2 ) ) AS ReturnsBlockedStockValue,
  cast(0 as abap.dec(23,2 ) ) AS TransferStockStorageLocValue,
  cast(0 as abap.dec(23,2 ) ) AS TransferStockPlantValue,
  cast(0 as abap.dec(23,2 ) ) AS StockInTransitValue,
  cast(0 as abap.dec(23,2 ) ) AS BlockedStockValue,
  cast(0 as abap.dec(23,2 ) ) AS RestrictedStockValue,
  cast(0 as abap.dec(23,2 ) ) AS TiedEmptiesStockValue,
  cast(0 as abap.dec(23,2 ) ) AS GoodsReceiptBlockedStockValue,
  cast(0 as abap.dec(23,2 ) ) AS CurrentStockCurVal,
  cast(0 as abap.dec(23,2 ) ) AS QualityInspectionStockCurVal,
  cast(0 as abap.dec(23,2 ) ) AS ReturnsBlockedStockCurVal,
  cast(0 as abap.dec(23,2 ) ) AS TransferStockStorageLocCurVal,
  cast(0 as abap.dec(23,2 ) ) AS TransferStockPlantCurVal,
  cast(0 as abap.dec(23,2 ) ) AS StockInTransitCurVal,
  cast(0 as abap.dec(23,2 ) ) AS BlockedStockCurVal,
  cast(0 as abap.dec(23,2 ) ) AS RestrictedStockCurVal,
  cast(0 as abap.dec(23,2 ) ) AS TiedEmptiesStockCurVal,
  cast(0 as abap.dec(23,2 ) ) AS GoodsReceiptBlockedStockCurVal
FROM mcha AS ma
INNER JOIN marc AS mc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN F_Mmim_Mathlp_Vh AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN F_Mmim_Bukrs_Plant AS _F_Mmim_Bukrs_Plant ON Plant = _F_Mmim_Bukrs_Plant.Plant  -- association [1..1]
;

Learn More