P_ProductCostEstimateErrorLog

DDL: P_PRODUCTCOSTESTIMATEERRORLOG SQL: PPRODCESTERRLOG Type: view BASIC Package: FINS_COSTING_ANALYTICS

Product Cost Estimate Error Log

P_ProductCostEstimateErrorLog is a Basic CDS View that provides data about "Product Cost Estimate Error Log" in SAP S/4HANA. It reads from 1 data source (cmfp) and exposes 16 fields with key fields CostingErrorLogApplication, CostingErrorLogID, CostingErrorMessageSequence. Part of development package FINS_COSTING_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
cmfp cmfp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPRODCESTERRLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CostingErrorLogApplication cmfk aplid Error Mgmt
KEY CostingErrorLogID cmfk nr Number
KEY CostingErrorMessageSequence cmfp msgcnt Total
CostingErrorLogCreationDate cmfk datum Valid to
CostingErrorLogCreationTime cmfk uzeit Time
CostingErrorLogCreatedByUser cmfk uname User Name
CostingErrorLogObject cmfk objid Work Center
SystemMessageClass cmfp arbgb Message ID
SystemMessageNumber cmfp msgnr Message
CostingErrorMessageType cmfp msgty Msg.Type (E,I,W..)
SystemMessageVariable1 cmfp msgv1 Message variable 1
SystemMessageVariable2 cmfp msgv2 Message variable 2
SystemMessageVariable3 cmfp msgv3 Message variable 3
SystemMessageVariable4 cmfp msgv4 Message variable 4
CostgErrorMsgIsObjectDependent cmfp objkz Remaining split
CostingErrorLogObjectName cmfp object TRFM Object

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_ProductCostEstimateErrorLog.
-- 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: PPRODCESTERRLOG

CREATE VIEW P_ProductCostEstimateErrorLog AS
SELECT
  cmfk.aplid AS CostingErrorLogApplication,
  cmfk.nr AS CostingErrorLogID,
  cmfp.msgcnt AS CostingErrorMessageSequence,
  cmfk.datum AS CostingErrorLogCreationDate,
  cmfk.uzeit AS CostingErrorLogCreationTime,
  cmfk.uname AS CostingErrorLogCreatedByUser,
  cmfk.objid AS CostingErrorLogObject,
  cmfp.arbgb AS SystemMessageClass,
  cmfp.msgnr AS SystemMessageNumber,
  cmfp.msgty AS CostingErrorMessageType,
  cmfp.msgv1 AS SystemMessageVariable1,
  cmfp.msgv2 AS SystemMessageVariable2,
  cmfp.msgv3 AS SystemMessageVariable3,
  cmfp.msgv4 AS SystemMessageVariable4,
  cmfp.objkz AS CostgErrorMsgIsObjectDependent,
  cmfp.object AS CostingErrorLogObjectName
FROM cmfp
;