I_DFS_BLOCKEDSTOCKBYBATCH

CDS View

Blocked Stock on Plant Storage Loc Batch

I_DFS_BLOCKEDSTOCKBYBATCH is a CDS View in S/4HANA. Blocked Stock on Plant Storage Loc Batch. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FlxMtPlObjBlkdQtyInfo view_entity inner COMPOSITE Blocked Quantity Info for FMPO
I_FlxMtPlObjBlkdQtyInfoByBatch view_entity inner COMPOSITE Blocked Quantity Info for FMPO by batch

Fields (6)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 1
KEY Material Material 2
KEY Plant Plant 2
KEY StorageLocation StorageLocation 2
KEY WBSElementInternalID WBSElementInternalID 2
MaterialBaseUnit MaterialBaseUnit 2

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.

-- Blocked Stock on Plant Storage Loc Batch
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_BLOCKEDSTOCKBYBATCH (
    BATCH,
    MATERIAL,
    PLANT,
    STORAGELOCATION,
    WBSELEMENTINTERNALID,
    MATERIALBASEUNIT,
    PRIMARY KEY (BATCH, MATERIAL, PLANT, STORAGELOCATION, WBSELEMENTINTERNALID)
);