P_CostingProductionVersionVH

DDL: P_COSTINGPRODUCTIONVERSIONVH SQL: PCOSTPRODVERSNVH Type: view BASIC

P_CostingProductionVersionVH is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_Material, mkal) and exposes 10 fields with key fields CostingProductionVersion, Material, Plant.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_Material Material inner
mkal mkal from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCOSTPRODVERSNVH view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CostingProductionVersion
KEY Material mkal matnr
KEY Plant werks
ProductionVersionText text1
MaterialType I_Material MaterialType
MaterialGroup I_Material MaterialGroup
AuthorizationGroup _MaterialType AuthorizationGroup
MaterialAuthorizationGroup _MaterialGroup MaterialAuthorizationGroup
_MaterialType _MaterialType
_MaterialGroup _MaterialGroup 
@AbapCatalog.sqlViewName: 'PCOSTPRODVERSNVH'
@AbapCatalog.preserveKey:true
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_CostingProductionVersionVH
  as select from mkal       as mkal
    inner join   I_Material as Material on Material.Material = mkal.matnr
{
  key cast (verid as ck_verid) as CostingProductionVersion,
  key mkal.matnr               as Material,
  key werks                    as Plant,
      text1                    as ProductionVersionText,
      Material.MaterialType,
      Material.MaterialGroup,
      _MaterialType.AuthorizationGroup,
      _MaterialGroup.MaterialAuthorizationGroup,

      _MaterialType,
      _MaterialGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIAL",
"I_MATERIALGROUP",
"I_MATERIALTYPE",
"MKAL"
],
"ASSOCIATED":
[
"I_MATERIALGROUP",
"I_MATERIALTYPE"
],
"BASE":
[
"I_MATERIAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More