P_CostingProductionVersionVH

DDL: P_COSTINGPRODUCTIONVERSIONVH SQL: PCOSTPRODVERSNVH Type: view BASIC Package: FINS_FIS_FICO

Costing Product Version Value Help

P_CostingProductionVersionVH is a Basic CDS View that provides data about "Costing Product Version Value Help" in SAP S/4HANA. It reads from 2 data sources (I_Material, mkal) and exposes 10 fields with key fields CostingProductionVersion, Material, Plant. Part of development package FINS_FIS_FICO.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_Material Material inner
mkal mkal from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCOSTPRODVERSNVH 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 mkal werks
ProductionVersionText mkal text1
MaterialType I_Material MaterialType
MaterialGroup I_Material MaterialGroup
AuthorizationGroup
MaterialAuthorizationGroup
_MaterialType I_Material _MaterialType
_MaterialGroup I_Material _MaterialGroup 
@AbapCatalog.sqlViewName: 'PCOSTPRODVERSNVH'
@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 (mkal.verid as ck_verid) as CostingProductionVersion,
  key mkal.matnr                    as Material,
  key mkal.werks                    as Plant,
      mkal.text1                    as ProductionVersionText,
      Material.MaterialType,
      Material.MaterialGroup,
      Material._MaterialType.AuthorizationGroup,
      Material._MaterialGroup.MaterialAuthorizationGroup,

      Material._MaterialType,
      Material._MaterialGroup
}

Learn More