I_BATCH

CDS View
32 Fields 9 CDS Views

Batch information

I_BATCH is a CDS View in S/4HANA. Batch information. It contains 32 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_BatchCertificate view from CONSUMPTION
C_RDPBatchClassificationDEX view from CONSUMPTION Batch Data with Classification Extractor for RDP
C_RDPBatchDEX view from CONSUMPTION Batch Data Extractor for RDP
C_RDPBatchGeneralDEX view from CONSUMPTION RDP Specific Data Extractor for general Batch data
I_BatchTP view from TRANSACTIONAL Draft enabled Batch View
I_PhysInvtryBatchVH view_entity inner COMPOSITE Batches in Physical Inventory
MMIMSUPPLIERBATCHVH view from Value Help for Supplier Batches
P_EWM_PINVCOUNTITEM06 view left_outer CONSUMPTION
P_MltplMatlStk_L1_WOS_BATCH view_entity from COMPOSITE

Fields (32)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 4
KEY Material Material,MaterialForEdit 4
KEY Plant Plant 3
_CountryOfOrigin _CountryOfOrigin 1
_RegionOfOrigin _RegionOfOrigin 1
_Supplier _Supplier 1
BatchBySupplier BatchBySupplier 2
BatchExtWhseMgmtInternalId BatchExtWhseMgmtInternalId 2
BatchIdentifyingPlant BatchIdentifyingPlant 1
BatchIsMarkedForDeletion BatchIsMarkedForDeletion 2
ClfnObjectInternalID ClfnObjectInternalID 3
CountryOfOrigin CountryOfOrigin 3
CreationDateTime CreationDateTime 2
DefinitionOfBatchLevel DefinitionOfBatchLevel 1
FreeDefinedDate1 FreeDefinedDate1 1
FreeDefinedDate2 FreeDefinedDate2 1
FreeDefinedDate3 FreeDefinedDate3 1
FreeDefinedDate4 FreeDefinedDate4 1
FreeDefinedDate5 FreeDefinedDate5 1
FreeDefinedDate6 FreeDefinedDate6 1
InventoryValuationType InventoryValuationType 2
IsSubordinateBatch IsSubordinateBatch 1
LastChangeDateTime LastChangeDateTime 4
LastGoodsReceiptDate LastGoodsReceiptDate 1
ManufactureDate ManufactureDate 4
MatlBatchAvailabilityDate MatlBatchAvailabilityDate 2
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 2
NextInspectionDate NextInspectionDate 1
RegionOfOrigin RegionOfOrigin 2
ShelfLifeExpirationDate ShelfLifeExpirationDate 2
StockSegment StockSegment 1
Supplier Supplier 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.

-- Batch information
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BATCH (
    BATCH,
    MATERIAL,
    PLANT,
    _COUNTRYOFORIGIN,
    _REGIONOFORIGIN,
    _SUPPLIER,
    BATCHBYSUPPLIER,
    BATCHEXTWHSEMGMTINTERNALID,
    BATCHIDENTIFYINGPLANT,
    BATCHISMARKEDFORDELETION,
    CLFNOBJECTINTERNALID,
    COUNTRYOFORIGIN,
    CREATIONDATETIME,
    DEFINITIONOFBATCHLEVEL,
    FREEDEFINEDDATE1,
    FREEDEFINEDDATE2,
    FREEDEFINEDDATE3,
    FREEDEFINEDDATE4,
    FREEDEFINEDDATE5,
    FREEDEFINEDDATE6,
    INVENTORYVALUATIONTYPE,
    ISSUBORDINATEBATCH,
    LASTCHANGEDATETIME,
    LASTGOODSRECEIPTDATE,
    MANUFACTUREDATE,
    MATLBATCHAVAILABILITYDATE,
    MATLBATCHISINRSTRCDUSESTOCK,
    NEXTINSPECTIONDATE,
    REGIONOFORIGIN,
    SHELFLIFEEXPIRATIONDATE,
    STOCKSEGMENT,
    SUPPLIER,
    PRIMARY KEY (BATCH, MATERIAL, PLANT)
);

Learn More