P_PHYSINVTRYNOTPOSTEDMATERIAL

CDS View
10 Fields 2 CDS Views

Never Posted Material

P_PHYSINVTRYNOTPOSTEDMATERIAL is a CDS View in S/4HANA. Never Posted Material. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PhysInvtryActvStkSeparator view_entity union_all COMPOSITE Active stock separators for which a PI count can be done
P_PhysInvtryActvStkSeparatSitn view_entity union_all COMPOSITE Active stock separators for PI Situation

Fields (10)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 2
KEY Customer Customer 2
KEY InventoryStockType InventoryStockType 2
KEY Plant Plant 2
KEY SalesOrder SalesOrder 2
KEY SalesOrderItem SalesOrderItem 2
KEY StockOwner StockOwner 2
KEY StorageLocation StorageLocation 2
KEY Supplier Supplier 2
KEY WBSElementInternalID WBSElementInternalID 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.

-- Never Posted Material
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PHYSINVTRYNOTPOSTEDMATERIAL (
    BATCH,
    CUSTOMER,
    INVENTORYSTOCKTYPE,
    PLANT,
    SALESORDER,
    SALESORDERITEM,
    STOCKOWNER,
    STORAGELOCATION,
    SUPPLIER,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (BATCH, CUSTOMER, INVENTORYSTOCKTYPE, PLANT, SALESORDER, SALESORDERITEM, STOCKOWNER, STORAGELOCATION, SUPPLIER, WBSELEMENTINTERNALID)
);

Learn More