P_MFGORDERITEMGRBATCHCHARC

CDS View

Mfg Order Item Goods Receipt Batches with Characteristics

P_MFGORDERITEMGRBATCHCHARC is a CDS View in S/4HANA. Mfg Order Item Goods Receipt Batches with Characteristics. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgOrderItemGRBatchCharc view_entity from COMPOSITE Mfg Order Item Goods Receipt Batches with Characteristics

Fields (37)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 1
KEY ManufacturingOrder ManufacturingOrder 1
KEY ManufacturingOrderItem ManufacturingOrderItem 1
_Batch _Batch 1
_GoodsMovementType _GoodsMovementType 1
_InventorySpecialStockType _InventorySpecialStockType 1
_InventoryUsabilityCode _InventoryUsabilityCode 1
_InventoryValuationType _InventoryValuationType 1
_Material _Material 1
_MfgOrder _MfgOrder 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderItem _MfgOrderItem 1
_MfgOrderType _MfgOrderType 1
_PlannedBatch _PlannedBatch 1
_PlannedStorageLocation _PlannedStorageLocation 1
_Plant _Plant 1
_Product _Product 1
_ProductionPlant _ProductionPlant 1
_ProductPlant _ProductPlant 1
_StorageLocation _StorageLocation 1
ClfnObjectInternalID ClfnObjectInternalID 1
GoodsMovementType GoodsMovementType 1
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 1
InventorySpecialStockType InventorySpecialStockType 1
InventoryUsabilityCode InventoryUsabilityCode 1
InventoryValuationType InventoryValuationType 1
IsCompletelyDelivered IsCompletelyDelivered 1
ManufactureDate ManufactureDate 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
PlannedBatch PlannedBatch 1
PlannedStorageLocation PlannedStorageLocation 1
Plant Plant 1
ProductionPlant ProductionPlant 1
ShelfLifeExpirationDate ShelfLifeExpirationDate 1
StorageLocation StorageLocation 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Mfg Order Item Goods Receipt Batches with Characteristics
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGORDERITEMGRBATCHCHARC (
    BATCH,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERITEM,
    _BATCH,
    _GOODSMOVEMENTTYPE,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYUSABILITYCODE,
    _INVENTORYVALUATIONTYPE,
    _MATERIAL,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDERITEM,
    _MFGORDERTYPE,
    _PLANNEDBATCH,
    _PLANNEDSTORAGELOCATION,
    _PLANT,
    _PRODUCT,
    _PRODUCTIONPLANT,
    _PRODUCTPLANT,
    _STORAGELOCATION,
    CLFNOBJECTINTERNALID,
    GOODSMOVEMENTTYPE,
    GOODSRECEIPTISNONVALUATED,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYUSABILITYCODE,
    INVENTORYVALUATIONTYPE,
    ISCOMPLETELYDELIVERED,
    MANUFACTUREDATE,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    PLANNEDBATCH,
    PLANNEDSTORAGELOCATION,
    PLANT,
    PRODUCTIONPLANT,
    SHELFLIFEEXPIRATIONDATE,
    STORAGELOCATION,
    PRIMARY KEY (BATCH, MANUFACTURINGORDER, MANUFACTURINGORDERITEM)
);