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 4
KEY Plant Plant 3
_Material _Material 1
_Plant _Plant 1
BatchBySupplier BatchBySupplier 2
BatchIsMarkedForDeletion BatchIsMarkedForDeletion 2
ClfnObjectInternalID ClfnObjectInternalID 1
DefinitionOfBatchLevel DefinitionOfBatchLevel 2
InventoryValuationType SearchForValuationType 1
ManufactureDate ManufactureDate 1
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 1
ShelfLifeExpirationDate ShelfLifeExpirationDate 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.

-- 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