I_BUFFEREDMATERIALPLANT1

CDS View
26 Fields 4 CDS Views

Plant data for Buffered Product

I_BUFFEREDMATERIALPLANT1 is a CDS View in S/4HANA. Plant data for Buffered Product. It contains 26 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_DemandDrivenMaterialData view union_all COMPOSITE Data related to materials
I_ProductPlantMRPArea view_entity from COMPOSITE Product Details By Plant and MRP Area
P_DemandDrivenExtdProduct view_entity inner COMPOSITE Demand Driven Product Details
P_ProdBufPositining view_entity from COMPOSITE Private view for Buffer Positioning app

Fields (26)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY Plant MRPArea,Plant 3
_MatStatus _MatStatus 3
AuthorizationGroup AuthorizationGroup 3
BaseUnit BaseUnit 3
GoodsReceiptDuration GoodsReceiptDuration 2
IsBulkMaterial IsBulkMaterial 4
IsPhantomItem IsPhantomItem 4
LotSizingProcedure LotSizingProcedure 1
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity 1
MaterialPlannedProductionDurn MaterialPlannedProductionDurn 2
MaterialProcurementProfile ProcurementSubType 2
MinimumLotSizeQuantity MinimumLotSizeQuantity 1
MRPController MRPController 3
MRPGroup MRPGroup 2
MRPType MRPType 3
PlanningTimeFence PlanningTimeFence 1
ProcurementType ProcurementType 2
ProductGroup ProductGroup 3
ProductGroupAuthorizationGroup ProductGroupAuthorizationGroup 3
ProductType ProductType 2
ProductTypeAuthorizationGroup ProductTypeAuthorizationGroup 3
PurchasingGroup PurchasingGroup 2
ReorderThresholdQuantity ReorderThresholdQuantity 1
SafetyStockQuantity SafetyStockQuantity 1
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration 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.

-- Plant data for Buffered Product
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUFFEREDMATERIALPLANT1 (
    MATERIAL,
    PLANT,
    _MATSTATUS,
    AUTHORIZATIONGROUP,
    BASEUNIT,
    GOODSRECEIPTDURATION,
    ISBULKMATERIAL,
    ISPHANTOMITEM,
    LOTSIZINGPROCEDURE,
    MATERIALMAXSTOCKLEVELQUANTITY,
    MATERIALPLANNEDPRODUCTIONDURN,
    MATERIALPROCUREMENTPROFILE,
    MINIMUMLOTSIZEQUANTITY,
    MRPCONTROLLER,
    MRPGROUP,
    MRPTYPE,
    PLANNINGTIMEFENCE,
    PROCUREMENTTYPE,
    PRODUCTGROUP,
    PRODUCTGROUPAUTHORIZATIONGROUP,
    PRODUCTTYPE,
    PRODUCTTYPEAUTHORIZATIONGROUP,
    PURCHASINGGROUP,
    REORDERTHRESHOLDQUANTITY,
    SAFETYSTOCKQUANTITY,
    TOTALREPLENISHMENTLEADDURATION,
    PRIMARY KEY (MATERIAL, PLANT)
);

Learn More