I_INSPLOTMATLDOCITEM

CDS View
10 Fields 7 CDS Views

Material Document Item in Inspection Lot

I_INSPLOTMATLDOCITEM is a CDS View in S/4HANA. Material Document Item in Inspection Lot. It contains 10 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_InspLotMatlDocItmSrlNmbr view inner CONSUMPTION Serial Numbers for Stock Posting
C_InspLotMatlDocValHelp view from CONSUMPTION Inspection Lot Material Document ValueHelp
C_InspLotStockPosting view from CONSUMPTION Inspection Lot Stock Posting
C_InspUsgeDescStk view from CONSUMPTION Insp Usage Decision Stk Posting
I_FldLogsInspectionLot view_entity from COMPOSITE Non-Cancelled Inspection Lot
I_InspLotMatlDocItmGdsMvt view from COMPOSITE Insp Lot Mat Doc Item with Goods Mvt
P_InspSrlNmbrUsgeDcsnStkPostd view inner COMPOSITE Serial Number Usage Decision Posted

Fields (10)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 7
KEY InspLotMatlDocItem InspLotMatlDocItem 6
_GoodsMovementDocument _GoodsMovementDocument 1
_InspectionLot _InspectionLot 1
CreationDate CreationDate 3
InspLotMatlDocItemType InspLotMatlDocItemType 4
MaterialDocument MaterialDocument 5
MaterialDocumentItem MaterialDocumentItem 5
MaterialDocumentYear MaterialDocumentYear 5
UsageDecisionStockType UsageDecisionStockType 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.

-- Material Document Item in Inspection Lot
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPLOTMATLDOCITEM (
    INSPECTIONLOT,
    INSPLOTMATLDOCITEM,
    _GOODSMOVEMENTDOCUMENT,
    _INSPECTIONLOT,
    CREATIONDATE,
    INSPLOTMATLDOCITEMTYPE,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    USAGEDECISIONSTOCKTYPE,
    PRIMARY KEY (INSPECTIONLOT, INSPLOTMATLDOCITEM)
);

Learn More