I_BUFFEREDMATERIALPLANT

CDS View

Plant Data for Buffered Material

I_BUFFEREDMATERIALPLANT is a CDS View in S/4HANA. Plant Data for Buffered Material. It contains 10 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_DmndDrivenProdDscontn view from CONSUMPTION Demand Driven Product Discontinuation
I_DemandDrivenMaterialData view union_all BASIC Data related to materials
I_ProductPlantMRPArea view from COMPOSITE Product Details By Plant and MRP Area
I_ProductPlantMRPAreaVH view from COMPOSITE Value Help for Product Details By Plant and MRP Area
P_FallBackTargetStock view inner BASIC
P_MaterialMRPGroup view from CONSUMPTION
P_ProductMasterLeadTime view from CONSUMPTION Lead Time Details from Product Master
P_ProductMasterLeadTime view union_all CONSUMPTION Lead Time Details from Product Master

Fields (10)

KeyField CDS FieldsUsed in Views
KEY Material Material 4
KEY Plant MRPArea,Plant,ProductionPlant 5
GoodsReceiptDuration GoodsReceiptDuration 1
MaterialPlannedProductionDurn MaterialPlannedProductionDurn 1
MRPController MRPController 2
MRPGroup MRPGroup 2
MRPType MRPType 2
ProcurementType ProcurementType 1
PurchasingGroup PurchasingGroup 1
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration 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.

-- Plant Data for Buffered Material
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUFFEREDMATERIALPLANT (
    MATERIAL,
    PLANT,
    GOODSRECEIPTDURATION,
    MATERIALPLANNEDPRODUCTIONDURN,
    MRPCONTROLLER,
    MRPGROUP,
    MRPTYPE,
    PROCUREMENTTYPE,
    PURCHASINGGROUP,
    TOTALREPLENISHMENTLEADDURATION,
    PRIMARY KEY (MATERIAL, PLANT)
);