P_OPACTYPLNDCOMPONENTPERSFI

CDS View
21 Fields 2 CDS Views

P_OPACTYPLNDCOMPONENTPERSFI is a CDS View in S/4HANA. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MfgOpActyComponent view from CONSUMPTION
P_OpActyComponentMRS view from COMPOSITE

Fields (21)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY ParentShopFloorItem AssemblyShopFloorItem,ParentShopFloorItem 2
KEY Plant Plant 2
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 1
_Material _Material 2
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 2
_Plant _Plant 1
AlternativeItemGroup AlternativeItemGroup 1
BaseUnit BaseUnit 1
EntryUnit EntryUnit 1
MaterialCompIsAlternativeItem MaterialCompIsAlternativeItem 1
MatlCompInstceAssyIsRequired MatlCompInstceAssyIsRequired 1
MfgOrderComponentUsageQuantity MfgOrderComponentUsageQuantity 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 2
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 2
UsageProbabilityPercent UsageProbabilityPercent 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPACTYPLNDCOMPONENTPERSFI (
    MATERIAL,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PARENTSHOPFLOORITEM,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _MATERIAL,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _PLANT,
    ALTERNATIVEITEMGROUP,
    BASEUNIT,
    ENTRYUNIT,
    MATERIALCOMPISALTERNATIVEITEM,
    MATLCOMPINSTCEASSYISREQUIRED,
    MFGORDERCOMPONENTUSAGEQUANTITY,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    USAGEPROBABILITYPERCENT,
    PRIMARY KEY (MATERIAL, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PARENTSHOPFLOORITEM, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More