P_CostingProductionVersionVH

DDL: P_COSTINGPRODUCTIONVERSIONVH SQL: PCOSTPRODVERSNVH Type: view BASIC Package: FINS_FIS_FICO
10 Fields 2 Data Sources

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.

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 Vehicle Model
KEY Plant mkal werks Receiving Plant
ProductionVersionText mkal text1 Vertikalization Text
MaterialType I_Material MaterialType Material Type
MaterialGroup I_Material MaterialGroup Product Group
AuthorizationGroup
MaterialAuthorizationGroup
_MaterialType I_Material _MaterialType
_MaterialGroup I_Material _MaterialGroup

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 P_CostingProductionVersionVH.
-- 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: PCOSTPRODVERSNVH

CREATE VIEW P_CostingProductionVersionVH AS
SELECT
  cast (mkal.verid as ck_verid) AS CostingProductionVersion,
  mkal.matnr AS Material,
  mkal.werks AS Plant,
  mkal.text1 AS ProductionVersionText,
  Material.MaterialType AS MaterialType,
  Material.MaterialGroup AS MaterialGroup,
  Material._MaterialType.AuthorizationGroup AS AuthorizationGroup,
  Material._MaterialGroup.MaterialAuthorizationGroup AS MaterialAuthorizationGroup,
  Material._MaterialType AS _MaterialType,
  Material._MaterialGroup AS _MaterialGroup
FROM mkal
INNER JOIN I_Material AS Material ON /* join condition not captured in parsed metadata */
;

Learn More