I_BillOfMaterialUoMVH

DDL: I_BILLOFMATERIALUOMVH Type: view_entity BASIC Package: CS_MODEL

Variable Size Component Size Unit of Measure

I_BillOfMaterialUoMVH is a Basic CDS View that provides data about "Variable Size Component Size Unit of Measure" in SAP S/4HANA. It reads from 3 data sources (t006d, t006t, t006a) and exposes 4 fields with key field VariableSizeCompUnitOfMeasure. It is exposed through 4 OData services (ASQL_F5987, ASQL_F6990, UI_SOURCINGPROJECT_MANAGE, ...). Part of development package CS_MODEL.

Data Sources (3)

SourceAliasJoin Type
t006d Dimension inner
t006t DimensionText left_outer
t006a LanguageDependentUnit left_outer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Variable Size Component Size Unit of Measure view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED
ASQL_F6990 ASQL_F6990 C2 NOT_RELEASED
UI_SOURCINGPROJECT_MANAGE UI_SOURCINGPROJECT_MANAGE V2 C1 NOT_RELEASED
UI_SRCGPROJQUOTATION_MANAGE UI_SRCGPROJQTN_MANAGE V2 C1 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY VariableSizeCompUnitOfMeasure UnitOfMeasure msehi Unit of measmnt
VariableSizeCompCommercialUoM t006a mseh3 Commercial
VariableSizeCompUoMText t006a msehl Meas. Unit Text
VariableSizeCompDimensionText t006t txdim Dimension Text

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 I_BillOfMaterialUoMVH.
-- 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 I_BillOfMaterialUoMVH AS
SELECT
  UnitOfMeasure.msehi AS VariableSizeCompUnitOfMeasure,
  LanguageDependentUnit.mseh3 AS VariableSizeCompCommercialUoM,
  LanguageDependentUnit.msehl AS VariableSizeCompUoMText,
  DimensionText.txdim AS VariableSizeCompDimensionText
LEFT OUTER JOIN t006a AS LanguageDependentUnit ON /* join condition not captured in parsed metadata */
INNER JOIN t006d AS Dimension ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t006t AS DimensionText ON /* join condition not captured in parsed metadata */
;