I_MfgOrderItemGRBatchCharc

DDL: I_MFGORDERITEMGRBATCHCHARC Type: view_entity COMPOSITE Package: VDM_PP_SFC
45 Fields 1 Data Sources 1 Associations

Mfg Order Item Goods Receipt Batches with Characteristics

I_MfgOrderItemGRBatchCharc is a Composite CDS View that provides data about "Mfg Order Item Goods Receipt Batches with Characteristics" in SAP S/4HANA. It reads from 1 data source (P_MfgOrderItemGRBatchCharc) and exposes 45 fields with key fields ManufacturingOrder, ManufacturingOrderItem, Batch, CharcInternalID. It has 1 association to related views. Part of development package VDM_PP_SFC.

Data Sources (1)

SourceAliasJoin Type
P_MfgOrderItemGRBatchCharc GRBatch from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ClfnClassTypeBasic _ClassType $projection.ClassType = _ClassType.ClassType

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.technicalName IMFGORITGRBCHAR view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey ClfnCharcValuePositionNumber view
ObjectModel.usageType.serviceQuality #D 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 Mfg Order Item Goods Receipt Batches with Characteristics view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder P_MfgOrderItemGRBatchCharc ManufacturingOrder Order
KEY ManufacturingOrderItem P_MfgOrderItemGRBatchCharc ManufacturingOrderItem Manufacturing Order Item
KEY Batch P_MfgOrderItemGRBatchCharc Batch Lot No.
KEY CharcInternalID CharcVal CharcInternalID Characteristic Internal ID
ClfnObjectTable CharcVal ClfnObjectTable
ClassType CharcVal ClassType X Flag
ClfnObjectType CharcVal ClfnObjectType Object/Class
Characteristic
CharcValue CharcVal CharcValue Char. Value
ManufacturingOrderCategory P_MfgOrderItemGRBatchCharc ManufacturingOrderCategory
ManufacturingOrderType P_MfgOrderItemGRBatchCharc ManufacturingOrderType
Material P_MfgOrderItemGRBatchCharc Material Vehicle Model
Plant P_MfgOrderItemGRBatchCharc Plant Valuation Area
StorageLocation P_MfgOrderItemGRBatchCharc StorageLocation StorageLocation
InventoryValuationType P_MfgOrderItemGRBatchCharc InventoryValuationType Valuation Type
GoodsMovementType P_MfgOrderItemGRBatchCharc GoodsMovementType Movement Type
InventoryUsabilityCode P_MfgOrderItemGRBatchCharc InventoryUsabilityCode Stock Type
InventorySpecialStockType P_MfgOrderItemGRBatchCharc InventorySpecialStockType Special Stock Type
GoodsReceiptIsNonValuated P_MfgOrderItemGRBatchCharc GoodsReceiptIsNonValuated GR Non-Valuated
IsCompletelyDelivered P_MfgOrderItemGRBatchCharc IsCompletelyDelivered Is completely delivered
ShelfLifeExpirationDate P_MfgOrderItemGRBatchCharc ShelfLifeExpirationDate SLED/BBD
ManufactureDate P_MfgOrderItemGRBatchCharc ManufactureDate Date of Manuf.
PlannedBatch P_MfgOrderItemGRBatchCharc PlannedBatch
PlannedStorageLocation P_MfgOrderItemGRBatchCharc PlannedStorageLocation
ProductionPlant P_MfgOrderItemGRBatchCharc ProductionPlant Prod plnt
ClfnObjectInternalID P_MfgOrderItemGRBatchCharc ClfnObjectInternalID
_MfgOrder P_MfgOrderItemGRBatchCharc _MfgOrder
_MfgOrderItem P_MfgOrderItemGRBatchCharc _MfgOrderItem
_MfgOrderCategory P_MfgOrderItemGRBatchCharc _MfgOrderCategory
_MfgOrderType P_MfgOrderItemGRBatchCharc _MfgOrderType
_Batch P_MfgOrderItemGRBatchCharc _Batch
_Material P_MfgOrderItemGRBatchCharc _Material
_Product P_MfgOrderItemGRBatchCharc _Product
_ProductPlant P_MfgOrderItemGRBatchCharc _ProductPlant
_Plant P_MfgOrderItemGRBatchCharc _Plant
_StorageLocation P_MfgOrderItemGRBatchCharc _StorageLocation
_ProductionPlant P_MfgOrderItemGRBatchCharc _ProductionPlant
_PlannedBatch P_MfgOrderItemGRBatchCharc _PlannedBatch
_PlannedStorageLocation P_MfgOrderItemGRBatchCharc _PlannedStorageLocation
_GoodsMovementType P_MfgOrderItemGRBatchCharc _GoodsMovementType
_InventorySpecialStockType P_MfgOrderItemGRBatchCharc _InventorySpecialStockType
_InventoryValuationType P_MfgOrderItemGRBatchCharc _InventoryValuationType
_InventoryUsabilityCode P_MfgOrderItemGRBatchCharc _InventoryUsabilityCode
_Characteristic CharcVal _Characteristic
_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_MfgOrderItemGRBatchCharc.
-- 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_MfgOrderItemGRBatchCharc AS
SELECT
  GRBatch.ManufacturingOrder AS ManufacturingOrder,
  GRBatch.ManufacturingOrderItem AS ManufacturingOrderItem,
  GRBatch.Batch AS Batch,
  CharcVal.CharcInternalID AS CharcInternalID,
  CharcVal.ClfnObjectTable AS ClfnObjectTable,
  CharcVal.ClassType AS ClassType,
  CharcVal.ClfnObjectType AS ClfnObjectType,
  CharcVal._Characteristic(P_KeyDate: $session.system_date).Characteristic AS Characteristic,
  CharcVal.CharcValue AS CharcValue,
  GRBatch.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  GRBatch.ManufacturingOrderType AS ManufacturingOrderType,
  GRBatch.Material AS Material,
  GRBatch.Plant AS Plant,
  GRBatch.StorageLocation AS StorageLocation,
  GRBatch.InventoryValuationType AS InventoryValuationType,
  GRBatch.GoodsMovementType AS GoodsMovementType,
  GRBatch.InventoryUsabilityCode AS InventoryUsabilityCode,
  GRBatch.InventorySpecialStockType AS InventorySpecialStockType,
  GRBatch.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  GRBatch.IsCompletelyDelivered AS IsCompletelyDelivered,
  GRBatch.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  GRBatch.ManufactureDate AS ManufactureDate,
  GRBatch.PlannedBatch AS PlannedBatch,
  GRBatch.PlannedStorageLocation AS PlannedStorageLocation,
  GRBatch.ProductionPlant AS ProductionPlant,
  GRBatch.ClfnObjectInternalID AS ClfnObjectInternalID,
  GRBatch._MfgOrder AS _MfgOrder,
  GRBatch._MfgOrderItem AS _MfgOrderItem,
  GRBatch._MfgOrderCategory AS _MfgOrderCategory,
  GRBatch._MfgOrderType AS _MfgOrderType,
  GRBatch._Batch AS _Batch,
  GRBatch._Material AS _Material,
  GRBatch._Product AS _Product,
  GRBatch._ProductPlant AS _ProductPlant,
  GRBatch._Plant AS _Plant,
  GRBatch._StorageLocation AS _StorageLocation,
  GRBatch._ProductionPlant AS _ProductionPlant,
  GRBatch._PlannedBatch AS _PlannedBatch,
  GRBatch._PlannedStorageLocation AS _PlannedStorageLocation,
  GRBatch._GoodsMovementType AS _GoodsMovementType,
  GRBatch._InventorySpecialStockType AS _InventorySpecialStockType,
  GRBatch._InventoryValuationType AS _InventoryValuationType,
  GRBatch._InventoryUsabilityCode AS _InventoryUsabilityCode,
  CharcVal._Characteristic AS _Characteristic
FROM P_MfgOrderItemGRBatchCharc AS GRBatch
LEFT OUTER JOIN I_ClfnClassTypeBasic AS _ClassType ON ClassType = _ClassType.ClassType  -- association [0..1]
;

Learn More