P_ASSLDRELTDCOMPONENTINSTANCE

CDS View

P_ASSLDRELTDCOMPONENTINSTANCE is a CDS View in S/4HANA. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AssldReltdCompInstceSrlNmbr view from COMPOSITE Assembled Related Component Instance and/or Serial Number

Fields (16)

KeyField CDS FieldsUsed in Views
KEY AssemblyShopFloorItem AssemblyShopFloorItem 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
KEY ShopFloorItem ShopFloorItem 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_ParentShopFloorItem _ParentShopFloorItem 1
_ReservationHeader _ReservationHeader 1
Batch Batch 1
ReferenceDesignatorName ReferenceDesignatorName 1
ReferenceDesignatorValue ReferenceDesignatorValue 1
ReltdOriglDgtlMockUpCharcsUUID ReltdOriglDgtlMockUpCharcsUUID 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_ASSLDRELTDCOMPONENTINSTANCE (
    ASSEMBLYSHOPFLOORITEM,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORIGLDGTLMOCKUPCHARCSUUID,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    SHOPFLOORITEM,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _PARENTSHOPFLOORITEM,
    _RESERVATIONHEADER,
    BATCH,
    REFERENCEDESIGNATORNAME,
    REFERENCEDESIGNATORVALUE,
    RELTDORIGLDGTLMOCKUPCHARCSUUID,
    PRIMARY KEY (ASSEMBLYSHOPFLOORITEM, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORIGLDGTLMOCKUPCHARCSUUID, RECORDTYPE, RESERVATION, RESERVATIONITEM, SHOPFLOORITEM)
);