BATCH

13 Fields

BATCH is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 5
KEY Material Material 5
KEY Plant Plant 3
_Material _Material 2
_Plant _Plant 2
BatchBySupplier BatchBySupplier 2
BatchIsMarkedForDeletion BatchIsMarkedForDeletion 2
ClfnObjectInternalID ClfnObjectInternalID 1
DefinitionOfBatchLevel DefinitionOfBatchLevel 2
InventoryValuationType SearchForValuationType 1
ManufactureDate ManufactureDate 2
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 2
ShelfLifeExpirationDate ShelfLifeExpirationDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BATCH (
    BATCH,
    MATERIAL,
    PLANT,
    _MATERIAL,
    _PLANT,
    BATCHBYSUPPLIER,
    BATCHISMARKEDFORDELETION,
    CLFNOBJECTINTERNALID,
    DEFINITIONOFBATCHLEVEL,
    INVENTORYVALUATIONTYPE,
    MANUFACTUREDATE,
    MATLBATCHISINRSTRCDUSESTOCK,
    SHELFLIFEEXPIRATIONDATE,
    PRIMARY KEY (BATCH, MATERIAL, PLANT)
);

Learn More