R_ProdnVersConstcyLogTP

DDL: R_PRODNVERSCONSTCYLOGTP Type: view_entity TRANSACTIONAL
22 Fields 1 Data Sources

Production Version Consistency Log

R_ProdnVersConstcyLogTP is a Transactional CDS View that provides data about "Production Version Consistency Log" in SAP S/4HANA. It reads from 1 data source (I_ProductionVersionConstcyLog) and exposes 22 fields with key fields Material, Plant, ProductionVersion, ProdnVersConstcyIssue.

Data Sources (1)

SourceAliasJoin Type
I_ProductionVersionConstcyLog I_ProductionVersionConstcyLog from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Version Consistency Log view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY ProductionVersion ProductionVersion Version ID
KEY ProdnVersConstcyIssue ProdnVersConstcyIssue Issue Ident. No
ProdnVersConsistencyIssueType ProdnVersConsistencyIssueType Issue Type for stock
ProdnVersConstcyIssSvrtyLvl ProdnVersConstcyIssSvrtyLvl
IssueOccurredDateTime IssueOccurredDateTime Time Stamp
ProductionVersionConstcyStatus ProductionVersionConstcyStatus Status for Production Version
ProducerEventType ProducerEventType Event responsible for Production Version
ProducerBusinessObjectType ProducerBusinessObjectType Business Object responsible for Production Version
ProdnVersConstcyLogMsgClass ProdnVersConstcyLogMsgClass Message ID
ProdnVersConstcyLogMsgNumber ProdnVersConstcyLogMsgNumber Message Number
ProdnVersConstcyLgMsgVarbl1Txt ProdnVersConstcyLgMsgVarbl1Txt Message variable 1
ProdnVersConstcyLgMsgVarbl2Txt ProdnVersConstcyLgMsgVarbl2Txt Message variable 2
ProdnVersConstcyLgMsgVarbl3Txt ProdnVersConstcyLgMsgVarbl3Txt Message variable 3
ProdnVersConstcyLgMsgVarbl4Txt ProdnVersConstcyLgMsgVarbl4Txt Message variable 4
ChangeHistoryCount _Header ChangeHistoryCount
_Material _Material
_Plant _Plant
_ProdnVers _ProdnVers
_Header _Header
_IssueType _IssueType

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 R_ProdnVersConstcyLogTP.
-- 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.

CREATE VIEW R_ProdnVersConstcyLogTP AS
SELECT
  Material,
  Plant,
  ProductionVersion,
  ProdnVersConstcyIssue,
  ProdnVersConsistencyIssueType,
  ProdnVersConstcyIssSvrtyLvl,
  IssueOccurredDateTime,
  ProductionVersionConstcyStatus,
  ProducerEventType,
  ProducerBusinessObjectType,
  ProdnVersConstcyLogMsgClass,
  ProdnVersConstcyLogMsgNumber,
  ProdnVersConstcyLgMsgVarbl1Txt,
  ProdnVersConstcyLgMsgVarbl2Txt,
  ProdnVersConstcyLgMsgVarbl3Txt,
  ProdnVersConstcyLgMsgVarbl4Txt,
  _Header.ChangeHistoryCount AS ChangeHistoryCount
FROM I_ProductionVersionConstcyLog
;

Learn More