C_PurOrdMaintainUoMValHelp

DDL: C_PURORDMAINTAINUOMVALHELP SQL: CPOMAINTVHUOM Type: view CONSUMPTION

Value Help Unit of measure

C_PurOrdMaintainUoMValHelp is a Consumption CDS View that provides data about "Value Help Unit of measure" in SAP S/4HANA. It reads from 2 data sources (I_MaterialPlant, I_Plant) and exposes 10 fields with key fields Material, UnitOfMeasure, Plant, UnitOfMeasure, Plant. It has 3 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_MaterialPlant _MaterialPlant left_outer
I_Plant _Plant left_outer

Associations (3)

CardinalityTargetAliasCondition
[0..1] t006a _uomtext $projection.UnitOfMeasure = _uomtext.msehi
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPOMAINTVHUOM view
EndUserText.label Value Help Unit of measure view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.status #DEPRECATED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material matnr Material
KEY UnitOfMeasure meinh Unit of Measurement
KEY Plant I_MaterialPlant Plant Plant
MaterialName _MaterialText MaterialName
PlantName I_Plant PlantName
KEY UnitOfMeasure t006 msehi Unit of Measurement
KEY Plant Plant
MaterialName
PlantName
_uomtext _uomtext 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CPOMAINTVHUOM'
@EndUserText.label: 'Value Help Unit of measure' //PO Maintenance: Value Help for Unit of Measure

@AccessControl.authorizationCheck: #CHECK
@VDM.lifecycle.status: #DEPRECATED

//-----------------------------------------------------------------------------------------------------------------

// Remark: only Unit of Measures with "T006-KZKEH <> SPACE" are selected (see function module HELP_VALUES_MEINS)

//-----------------------------------------------------------------------------------------------------------------


define view C_PurOrdMaintainUoMValHelp
  as select distinct from marm as marm

    left outer join I_MaterialPlant as _MaterialPlant on marm.matnr           = _MaterialPlant.Material
    left outer join I_Plant         as _Plant         on _MaterialPlant.Plant = _Plant.Plant
  
    association [0..1] to t006a           as _uomtext       on $projection.UnitOfMeasure    = _uomtext.msehi
    association [0..*] to I_MaterialText  as _MaterialText  on $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
{
  @EndUserText.label: 'Material'            key matnr                as Material,
  @EndUserText.label: 'Unit of Measurement' key meinh                as UnitOfMeasure,
  @EndUserText.label: 'Plant'               key _MaterialPlant.Plant as Plant,
  _MaterialText.MaterialName                                         as MaterialName,
  _Plant.PlantName                                                   as PlantName,
  _uomtext //to be used in SADL Mapping to access texts that are depending on language

}
union select distinct from t006
association [0..1] to t006a   as _uomtext on t006.msehi        = _uomtext.msehi
association [0..1] to I_Plant as _Plant   on $projection.Plant = _Plant.Plant

{
  @EndUserText.label: 'Material'            key cast('' as matnr )   as Material,
  @EndUserText.label: 'Unit of Measurement' key t006.msehi           as UnitOfMeasure,
  @EndUserText.label: 'Plant'               key cast(''  as ewerk )  as Plant,
  cast(''  as maktx )                                                as MaterialName,
  cast(''  as ewerk )                                                as PlantName,
  _uomtext
}
where
  t006.kzkeh <> ''     

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALPLANT",
"I_MATERIALTEXT",
"I_PLANT",
"MARM",
"T006"
],
"ASSOCIATED":
[
"I_MATERIALTEXT",
"T006A"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More