I_MfgOrderConfGRBatchCharc

DDL: I_MFGORDERCONFGRBATCHCHARC Type: view_entity COMPOSITE Package: VDM_PP_CNF
46 Fields 1 Data Sources 3 Associations

Batch Characteristics of Manufacturing Order Confirmation

I_MfgOrderConfGRBatchCharc is a Composite CDS View that provides data about "Batch Characteristics of Manufacturing Order Confirmation" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfMatlDocItem) and exposes 46 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentYear, MaterialDocumentItem. It has 3 associations to related views. Part of development package VDM_PP_CNF.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderConfMatlDocItem MatlDoc from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MaterialDocumentItem_2 _MaterialDocumentItem $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentItem.MaterialDocument and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
[0..1] I_Batch _Batch $projection.Plant = _Batch.Plant and $projection.Material = _Batch.Material and $projection.Batch = _Batch.Batch
[0..1] I_ClfnClassTypeBasic _ClassType $projection.ClassType = _ClassType.ClassType

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.technicalName IMFGORDCONFBCHA view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey ClfnCharcValuePositionNumber view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Batch Characteristics of Manufacturing Order Confirmation view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup I_MfgOrderConfMatlDocItem MfgOrderConfirmationGroup
KEY ConfirmationCount I_MfgOrderConfMatlDocItem MfgOrderConfirmation
KEY MaterialDocument I_MfgOrderConfMatlDocItem MaterialDocument Material Doc.
KEY MaterialDocumentYear I_MfgOrderConfMatlDocItem MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem I_MfgOrderConfMatlDocItem MaterialDocumentItem Material Document Item
KEY Plant
KEY Material Batch Material Vehicle Model
KEY Batch Batch Batch Lot No.
KEY CharcInternalID CharcVal CharcInternalID Characteristic Internal ID
PostingDate I_MfgOrderConfMatlDocItem PostingDate Posting Date for GR
DocumentDate I_MfgOrderConfMatlDocItem DocumentDate Journal Entry Date
CreatedByUser I_MfgOrderConfMatlDocItem CreatedByUser User Name
ManufacturingOrder I_MfgOrderConfMatlDocItem ManufacturingOrder Order
ManufacturingOrderItem I_MfgOrderConfMatlDocItem ManufacturingOrderItem Manufacturing Order Item
ManufacturingOrderCategory I_MfgOrderConfMatlDocItem ManufacturingOrderCategory
ManufacturingOrderType
ConfirmationPlant I_MfgOrderConfMatlDocItem ConfirmationPlant
ConfirmationText I_MfgOrderConfMatlDocItem ConfirmationText
DefinitionOfBatchLevel Batch DefinitionOfBatchLevel
BatchIsMarkedForDeletion Batch BatchIsMarkedForDeletion
MatlBatchIsInRstrcdUseStock Batch MatlBatchIsInRstrcdUseStock Batch restr.
ShelfLifeExpirationDate Batch ShelfLifeExpirationDate SLED/BBD
ManufactureDate Batch ManufactureDate Date of Manuf.
ClfnObjectTable CharcVal ClfnObjectTable
ClassType CharcVal ClassType X Flag
ClfnObjectType CharcVal ClfnObjectType Object/Class
CharcValue CharcVal CharcValue Char. Value
Characteristic
_ConfirmationGroup I_MfgOrderConfMatlDocItem _ConfirmationGroup
_ConfirmationCount I_MfgOrderConfMatlDocItem _ConfirmationCount
_MaterialDocumentHeader I_MfgOrderConfMatlDocItem _MaterialDocumentHeader
_MaterialDocumentYear I_MfgOrderConfMatlDocItem _MaterialDocumentYear
_MaterialDocumentItem _MaterialDocumentItem
_MfgOrder I_MfgOrderConfMatlDocItem _MfgOrder
_MfgOrderItem I_MfgOrderConfMatlDocItem _MfgOrderItem
_MfgOrderCategory I_MfgOrderConfMatlDocItem _MfgOrderCategory
_MfgOrderType I_MfgOrderConfMatlDocItem _MfgOrderType
_ConfirmationPlant I_MfgOrderConfMatlDocItem _ConfirmationPlant
_DocumentDate I_MfgOrderConfMatlDocItem _DocumentDate
_PostingDate I_MfgOrderConfMatlDocItem _PostingDate
_Plant Batch _Plant
_Material Batch _Material
_Batch _Batch
_Characteristic CharcVal _Characteristic
_CharacteristicValue CharcVal _CharacteristicValue
_ClassType _ClassType

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 I_MfgOrderConfGRBatchCharc.
-- 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 I_MfgOrderConfGRBatchCharc AS
SELECT
  MatlDoc.MfgOrderConfirmationGroup AS ConfirmationGroup,
  MatlDoc.MfgOrderConfirmation AS ConfirmationCount,
  MatlDoc.MaterialDocument AS MaterialDocument,
  MatlDoc.MaterialDocumentYear AS MaterialDocumentYear,
  MatlDoc.MaterialDocumentItem AS MaterialDocumentItem,
  cast(Batch.Plant as werks_bp preserving type) AS Plant,
  Batch.Material AS Material,
  Batch.Batch AS Batch,
  CharcVal.CharcInternalID AS CharcInternalID,
  MatlDoc.PostingDate AS PostingDate,
  MatlDoc.DocumentDate AS DocumentDate,
  MatlDoc.CreatedByUser AS CreatedByUser,
  MatlDoc.ManufacturingOrder AS ManufacturingOrder,
  MatlDoc.ManufacturingOrderItem AS ManufacturingOrderItem,
  MatlDoc.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  cast(MatlDoc.ManufacturingOrderType as aufart preserving type) AS ManufacturingOrderType,
  MatlDoc.ConfirmationPlant AS ConfirmationPlant,
  MatlDoc.ConfirmationText AS ConfirmationText,
  Batch.DefinitionOfBatchLevel AS DefinitionOfBatchLevel,
  Batch.BatchIsMarkedForDeletion AS BatchIsMarkedForDeletion,
  Batch.MatlBatchIsInRstrcdUseStock AS MatlBatchIsInRstrcdUseStock,
  Batch.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  Batch.ManufactureDate AS ManufactureDate,
  CharcVal.ClfnObjectTable AS ClfnObjectTable,
  CharcVal.ClassType AS ClassType,
  CharcVal.ClfnObjectType AS ClfnObjectType,
  CharcVal.CharcValue AS CharcValue,
  CharcVal._Characteristic(P_KeyDate: $session.system_date).Characteristic AS Characteristic,
  MatlDoc._ConfirmationGroup AS _ConfirmationGroup,
  MatlDoc._ConfirmationCount AS _ConfirmationCount,
  MatlDoc._MaterialDocumentHeader AS _MaterialDocumentHeader,
  MatlDoc._MaterialDocumentYear AS _MaterialDocumentYear,
  MatlDoc._MfgOrder AS _MfgOrder,
  MatlDoc._MfgOrderItem AS _MfgOrderItem,
  MatlDoc._MfgOrderCategory AS _MfgOrderCategory,
  MatlDoc._MfgOrderType AS _MfgOrderType,
  MatlDoc._ConfirmationPlant AS _ConfirmationPlant,
  MatlDoc._DocumentDate AS _DocumentDate,
  MatlDoc._PostingDate AS _PostingDate,
  Batch._Plant AS _Plant,
  Batch._Material AS _Material,
  CharcVal._Characteristic AS _Characteristic,
  CharcVal._CharacteristicValue AS _CharacteristicValue
FROM I_MfgOrderConfMatlDocItem AS MatlDoc
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _MaterialDocumentItem ON MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentItem.MaterialDocument AND MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_ClfnClassTypeBasic AS _ClassType ON ClassType = _ClassType.ClassType  -- association [0..1]
;

Learn More