I_BATCHPLANT

CDS View
35 Fields 8 CDS Views

Batch in table MCHA with WERKS key

I_BATCHPLANT is a CDS View in S/4HANA. Batch in table MCHA with WERKS key. It contains 35 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
ESH_N_BATCH_PLANT view from Anchor view -BATCH_PLANT
I_BatchVH view union_all COMPOSITE Batch
MMIMBatchesVH view left_outer Value Help for Batches
P_BatchPlant view from COMPOSITE Batch on Plant Level without split valuation
P_BatchWithValuationVH view_entity from COMPOSITE Batches in Physical Inventory
P_BatchWithValuationVH view_entity union_all COMPOSITE Batches in Physical Inventory
P_InconsistentBatchMatStockVal view_entity from COMPOSITE Inconsistent between batch valuation and material stock val.
P_MfgProcgExecBatch view union_all COMPOSITE MPE Batch

Fields (35)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 5
KEY Material Material 5
KEY Plant Plant 4
_BusinessPartnerSupplier _BusinessPartnerSupplier 1
_CountryOfOrigin _CountryOfOrigin 2
_Material _Material 3
_Plant _Plant 3
_Product _Product 1
_RegionOfOrigin _RegionOfOrigin 2
_Supplier _Supplier 2
BatchBySupplier BatchBySupplier 2
BatchCertificationDate BatchCertificationDate 1
BatchExtWhseMgmtInternalId BatchExtWhseMgmtInternalId 3
BatchIsMarkedForDeletion BatchIsMarkedForDeletion 2
ClfnObjectInternalID ClfnObjectInternalID 2
CountryOfOrigin CountryOfOrigin 3
CreationDateTime CreationDateTime 3
ExportAndImportProductGroup ExportAndImportProductGroup 1
FreeDefinedDate1 FreeDefinedDate1 2
FreeDefinedDate2 FreeDefinedDate2 2
FreeDefinedDate3 FreeDefinedDate3 2
FreeDefinedDate4 FreeDefinedDate4 2
FreeDefinedDate5 FreeDefinedDate5 2
FreeDefinedDate6 FreeDefinedDate6 2
InventoryValuationType InventoryValuationType,ValuationTypeInBatch 2
LastChangeDateTime LastChangeDateTime 3
LastGoodsReceiptDate LastGoodsReceiptDate 1
ManufactureDate ManufactureDate 2
MatlBatchAvailabilityDate MatlBatchAvailabilityDate 2
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 2
NextInspectionDate NextInspectionDate 1
RegionOfOrigin RegionOfOrigin 3
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 in table MCHA with WERKS key
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BATCHPLANT (
    BATCH,
    MATERIAL,
    PLANT,
    _BUSINESSPARTNERSUPPLIER,
    _COUNTRYOFORIGIN,
    _MATERIAL,
    _PLANT,
    _PRODUCT,
    _REGIONOFORIGIN,
    _SUPPLIER,
    BATCHBYSUPPLIER,
    BATCHCERTIFICATIONDATE,
    BATCHEXTWHSEMGMTINTERNALID,
    BATCHISMARKEDFORDELETION,
    CLFNOBJECTINTERNALID,
    COUNTRYOFORIGIN,
    CREATIONDATETIME,
    EXPORTANDIMPORTPRODUCTGROUP,
    FREEDEFINEDDATE1,
    FREEDEFINEDDATE2,
    FREEDEFINEDDATE3,
    FREEDEFINEDDATE4,
    FREEDEFINEDDATE5,
    FREEDEFINEDDATE6,
    INVENTORYVALUATIONTYPE,
    LASTCHANGEDATETIME,
    LASTGOODSRECEIPTDATE,
    MANUFACTUREDATE,
    MATLBATCHAVAILABILITYDATE,
    MATLBATCHISINRSTRCDUSESTOCK,
    NEXTINSPECTIONDATE,
    REGIONOFORIGIN,
    SHELFLIFEEXPIRATIONDATE,
    STOCKSEGMENT,
    SUPPLIER,
    PRIMARY KEY (BATCH, MATERIAL, PLANT)
);

Learn More