/dmbe/I_MixProdCompositComp_TP

DDL: /DMBE/I_MIXPRODCOMPOSITCOMP_TP SQL: /DMBE/IMXPCTP Type: view
11 Fields 1 Data Sources 2 Associations

Mixed Product Composition Component TP

/dmbe/I_MixProdCompositComp_TP is a CDS View that provides data about "Mixed Product Composition Component TP" in SAP S/4HANA. It reads from 1 data source (/dmbe/I_MixProdCompositionComp) and exposes 11 fields with key field componentUuid. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/dmbe/I_MixProdCompositionComp /dmbe/I_MixProdCompositionComp from

Associations (2)

CardinalityTargetAliasCondition
[1..1] /dmbe/I_MixProdComposition_TP _MixedProduct _MixedProduct.mixedProductUuid = $projection.mixedProductUuid
[0..1] /dmbe/i_Material_Search _Material _Material.Material = $projection.component

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName /DMBE/IMXPCTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mixed Product Composition Component TP view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot false view
ObjectModel.writeActivePersistence /dmbe/tm_mxprd_c view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY componentUuid componentuuid UUID
mixedProductUuid mixedproductuuid UUID
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
_MixedProduct _MixedProduct
_Material _Material

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_MixProdCompositComp_TP.
-- 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/IMXPCTP

CREATE VIEW /dmbe/I_MixProdCompositComp_TP AS
SELECT
  componentUuid,
  mixedProductUuid,
  component,
  percentage,
  displayOrder,
  createdAt,
  createdBy,
  changedAt,
  changedBy
FROM /dmbe/I_MixProdCompositionComp
LEFT OUTER JOIN /dmbe/I_MixProdComposition_TP AS _MixedProduct ON _MixedProduct.mixedProductUuid = mixedProductUuid  -- association [1..1]
LEFT OUTER JOIN /dmbe/i_Material_Search AS _Material ON _Material.Material = component  -- association [0..1]
;

Learn More