P_Matval_Manage_Cost_Max_Pre

DDL: P_MATVAL_MANAGE_COST_MAX_PRE SQL: PMATVALMGMCOSTMP Type: view BASIC
7 Fields 2 Data Sources

P_Matval_Manage_Cost_Max_Pre is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (keko, mbew) and exposes 7 fields with key fields bzobj, kalnr, kalka, kadky, tvers.

Data Sources (2)

SourceAliasJoin Type
keko k from
mbew m inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMATVALMGMCOSTMP 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 (7)

KeyFieldSource TableSource FieldDescription
KEY bzobj keko bzobj Reference Obj.
KEY kalnr keko kalnr ProdCostEst.No.
KEY kalka keko kalka Costing Type
KEY kadky keko kadky Costing Date
KEY tvers keko tvers Costing Version
KEY bwvar keko bwvar Valuation Variant
KEY kkzma keko kkzma Additive Costs

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_Matval_Manage_Cost_Max_Pre.
-- 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: PMATVALMGMCOSTMP

CREATE VIEW P_Matval_Manage_Cost_Max_Pre AS
SELECT
  k.bzobj AS bzobj,
  k.kalnr AS kalnr,
  k.kalka AS kalka,
  k.kadky AS kadky,
  k.tvers AS tvers,
  k.bwvar AS bwvar,
  k.kkzma AS kkzma
FROM keko AS k
INNER JOIN mbew AS m ON /* join condition not captured in parsed metadata */
;

Learn More