P_ProdnOrderConfBatchCharc

DDL: P_PRODNORDERCONFBATCHCHARC Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER_CONF_2
13 Fields 1 Data Sources

Private View Batch Characteristics for Matl Mvmnts of Conf

P_ProdnOrderConfBatchCharc is a Composite CDS View that provides data about "Private View Batch Characteristics for Matl Mvmnts of Conf" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfMatlDocItem) and exposes 13 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. Part of development package ODATA_PP_API_PRODORDER_CONF_2.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderConfMatlDocItem MatlDoc from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup I_MfgOrderConfMatlDocItem MfgOrderConfirmationGroup
KEY ConfirmationCount I_MfgOrderConfMatlDocItem MfgOrderConfirmation
KEY MaterialDocument I_MfgOrderConfMatlDocItem MaterialDocument Material Doc.
KEY MaterialDocumentItem I_MfgOrderConfMatlDocItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear I_MfgOrderConfMatlDocItem MaterialDocumentYear Material Document Year
KEY Plant Batch Plant Valuation Area
KEY Material Batch Material Vehicle Model
KEY Batch Batch Batch Lot No.
KEY CharcInternalID CharcVal CharcInternalID Characteristic Internal ID
Characteristic
CharcValue CharcVal CharcValue Char. Value
ClassType CharcVal ClassType X Flag
_Characteristic CharcVal _Characteristic

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_ProdnOrderConfBatchCharc.
-- 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 P_ProdnOrderConfBatchCharc AS
SELECT
  MatlDoc.MfgOrderConfirmationGroup AS ConfirmationGroup,
  MatlDoc.MfgOrderConfirmation AS ConfirmationCount,
  MatlDoc.MaterialDocument AS MaterialDocument,
  MatlDoc.MaterialDocumentItem AS MaterialDocumentItem,
  MatlDoc.MaterialDocumentYear AS MaterialDocumentYear,
  Batch.Plant AS Plant,
  Batch.Material AS Material,
  Batch.Batch AS Batch,
  CharcVal.CharcInternalID AS CharcInternalID,
  CharcVal._Characteristic(P_KeyDate: $session.system_date).Characteristic AS Characteristic,
  CharcVal.CharcValue AS CharcValue,
  CharcVal.ClassType AS ClassType,
  CharcVal._Characteristic AS _Characteristic
FROM I_MfgOrderConfMatlDocItem AS MatlDoc
;

Learn More