_BATCHPLANT

_BATCHPLANT is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 2
KEY InventoryValuationType BatchValuationType,InventoryValuationType,ValuationType 4
ManufactureDate ManufactureDate 1
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 1
PLANT PLANT 1
ShelfLifeExpirationDate ShelfLifeExpirationDate 1
StockSegment StockSegment 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 _BATCHPLANT (
    BATCH,
    INVENTORYVALUATIONTYPE,
    MANUFACTUREDATE,
    MATLBATCHISINRSTRCDUSESTOCK,
    PLANT,
    SHELFLIFEEXPIRATIONDATE,
    STOCKSEGMENT,
    PRIMARY KEY (BATCH, INVENTORYVALUATIONTYPE)
);