I_FLDLOGSMATLDOCUMENTRECORD

CDS View

Field Logistics Material Document Record

I_FLDLOGSMATLDOCUMENTRECORD is a CDS View in S/4HANA. Field Logistics Material Document Record. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_FldLogsAggrgRqdQty view from COMPOSITE Aggregate remote qty for purchase order
I_FldLogsMaintOrdMaterialStock view_entity from COMPOSITE Material stock for Maintenance Order
I_FldLogsMatlDocumentByOrder view_entity from COMPOSITE Goods Issue Data for Order
I_FldLogsMatlDocumentByOrder view_entity union_all COMPOSITE Goods Issue Data for Order
I_FldLogsReturnsMaterialStock view_entity from COMPOSITE Returns Material Stock

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Plant FldLogsRemotePlant 2
KEY SpecialStockIdfgWBSElement WBSElementInternalID 1
KEY StockIdentifyingMaterial Material 2
KEY StockIdfgStorageLocation RemoteStorageLocation 1
Batch Batch 1
MaterialBaseUnit StockUnit 2
ValuationType ValuationType 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.

-- Field Logistics Material Document Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FLDLOGSMATLDOCUMENTRECORD (
    PLANT,
    SPECIALSTOCKIDFGWBSELEMENT,
    STOCKIDENTIFYINGMATERIAL,
    STOCKIDFGSTORAGELOCATION,
    BATCH,
    MATERIALBASEUNIT,
    VALUATIONTYPE,
    PRIMARY KEY (PLANT, SPECIALSTOCKIDFGWBSELEMENT, STOCKIDENTIFYINGMATERIAL, STOCKIDFGSTORAGELOCATION)
);