OCIITM_PROP_SUPP

Transparent Table Application Table
13 Fields 1 CDS Views

Supplier recommendations for internal catalog proposals

OCIITM_PROP_SUPP is an SAP database table in S/4HANA. Supplier recommendations for internal catalog proposals. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_OpenCatalogProposalSupplier view from BASIC Supplier for internal catalog proposals

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY proposal_id mmpur_proposal_id Proposal ID
KEY serial_number mmpur_prop_sl_no Serial Number of Proposal Descriptions
KEY supplier_id lifnr Supplier
netprice mmpur_prop_netprc Net price
currency waers Currency
materialnumberofsupplier idnlf Supp. Mat. No.
leadtime mmpur_lead_time Lead Time in Days
order_price_unit bprme PO Price Unit
price_unit peinh Price unit
ref_po ebeln Purchasing Doc.
ref_po_item ebelp Item
lastchangedate paedt Changed On

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.

-- Supplier recommendations for internal catalog proposals
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OCIITM_PROP_SUPP (
    MANDT,                     -- Client [mandt]
    PROPOSAL_ID,               -- Proposal ID [mmpur_proposal_id]
    SERIAL_NUMBER,             -- Serial Number of Proposal Descriptions [mmpur_prop_sl_no]
    SUPPLIER_ID,               -- Supplier [lifnr]
    NETPRICE,                  -- Net price [mmpur_prop_netprc]
    CURRENCY,                  -- Currency [waers]
    MATERIALNUMBEROFSUPPLIER,  -- Supp. Mat. No. [idnlf]
    LEADTIME,                  -- Lead Time in Days [mmpur_lead_time]
    ORDER_PRICE_UNIT,          -- PO Price Unit [bprme]
    PRICE_UNIT,                -- Price unit [peinh]
    REF_PO,                    -- Purchasing Doc. [ebeln]
    REF_PO_ITEM,               -- Item [ebelp]
    LASTCHANGEDATE,            -- Changed On [paedt]
    PRIMARY KEY (MANDT, PROPOSAL_ID, SERIAL_NUMBER, SUPPLIER_ID)
);

Learn More