P_SFIOPACTYUNPLNDCOMPASSMBLAGG

CDS View
11 Fields 2 CDS Views

SFI at OA Unplanned Component Consumption Aggregation

P_SFIOPACTYUNPLNDCOMPASSMBLAGG is a CDS View in S/4HANA. SFI at OA Unplanned Component Consumption Aggregation. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MfgOpActyComponent view union CONSUMPTION View for Planned/Unplanned Components
P_ShopFloorItemAtOpActyComp view union_all CONSUMPTION SFI Planned Component at OA, Incl. Unplanned Assemblies

Fields (11)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY Plant Plant 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
EntryUnit EntryUnit 1
MaterialBaseUnit BaseUnit 1
MaterialComponentQuantity MaterialComponentQuantity 1
QuantityInEntryUnit QuantityInEntryUnit 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.

-- SFI at OA Unplanned Component Consumption Aggregation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SFIOPACTYUNPLNDCOMPASSMBLAGG (
    MATERIAL,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    ENTRYUNIT,
    MATERIALBASEUNIT,
    MATERIALCOMPONENTQUANTITY,
    QUANTITYINENTRYUNIT,
    PRIMARY KEY (MATERIAL, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More