/dmbe/I_MixProdCompositionComp

DDL: /DMBE/I_MIXPRODCOMPOSITIONCOMP SQL: /DMBE/I_MXDPRDC Type: view
8 Fields 1 Data Sources

Mixed Product Component

/dmbe/I_MixProdCompositionComp is a CDS View that provides data about "Mixed Product Component" in SAP S/4HANA. It reads from 1 data source (/dmbe/tm_mxprd_c) and exposes 8 fields.

Data Sources (1)

SourceAliasJoin Type
/dmbe/tm_mxprd_c /dmbe/tm_mxprd_c from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName /DMBE/I_MXDPRDC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Mixed Product Component view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (8)

KeyFieldSource TableSource FieldDescription
component component Softw. Comp.
percentage percentage Well Contribution Percentage
displayorder displayorder Sequence no.
createdat createdat Time Stamp
createdby createdby User Name
changedat changedat Time Stamp
changedby changedby User Name
deleted deleted Truth Value

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 /dmbe/I_MixProdCompositionComp.
-- 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: /DMBE/I_MXDPRDC

CREATE VIEW /dmbe/I_MixProdCompositionComp AS
SELECT
  component,
  percentage,
  displayorder,
  createdat,
  createdby,
  changedat,
  changedby,
  deleted
FROM /dmbe/tm_mxprd_c
;

Learn More