OCIITM_PROPS

Transparent Table Application Table
19 Fields 1 CDS Views

Internal catalog proposals for free text

OCIITM_PROPS is an SAP database table in S/4HANA. Internal catalog proposals for free text. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpenCatalogProposal view from BASIC Internal catalog proposals for free text

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY proposal_id mmpur_proposal_id Proposal ID
proposaluniqueid mmpur_proposal_uniqueid Catalog Proposal ID
trigger_matgroup matkl Material Group
trigger_supplier lifnr Supplier
trigger_unitofmeasure mmpur_prop_unit Proposed uom
trigger_supplier_material idnlf Supp. Mat. No.
pr_id banfn Purchase Req.
pr_item_no bnfpo Requisn. item
trigger_po_number ebeln Purchasing Doc.
trigger_po_item_number ebelp Item
trigger_po_netpr_in_usd netpr Net Price
trigger_po_leadtime plifz Pl. Deliv. Time
catalog_id mmpur_cat_ws_serv_id Catalog Web Serv ID
ml_id mmpur_proposal_mlid ML ID
status mmpur_prop_status Proposal Status
creationdate mmpur_prop_created_at Proposal Creation Dt
lastchangedate mmpur_prop_lastchange_at Last change date
archiving_status mmpur_archiving_status_code Archiving Stat.

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.

-- Internal catalog proposals for free text
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OCIITM_PROPS (
    MANDT,                      -- Client [mandt]
    PROPOSAL_ID,                -- Proposal ID [mmpur_proposal_id]
    PROPOSALUNIQUEID,           -- Catalog Proposal ID [mmpur_proposal_uniqueid]
    TRIGGER_MATGROUP,           -- Material Group [matkl]
    TRIGGER_SUPPLIER,           -- Supplier [lifnr]
    TRIGGER_UNITOFMEASURE,      -- Proposed uom [mmpur_prop_unit]
    TRIGGER_SUPPLIER_MATERIAL,  -- Supp. Mat. No. [idnlf]
    PR_ID,                      -- Purchase Req. [banfn]
    PR_ITEM_NO,                 -- Requisn. item [bnfpo]
    TRIGGER_PO_NUMBER,          -- Purchasing Doc. [ebeln]
    TRIGGER_PO_ITEM_NUMBER,     -- Item [ebelp]
    TRIGGER_PO_NETPR_IN_USD,    -- Net Price [netpr]
    TRIGGER_PO_LEADTIME,        -- Pl. Deliv. Time [plifz]
    CATALOG_ID,                 -- Catalog Web Serv ID [mmpur_cat_ws_serv_id]
    ML_ID,                      -- ML ID [mmpur_proposal_mlid]
    STATUS,                     -- Proposal Status [mmpur_prop_status]
    CREATIONDATE,               -- Proposal Creation Dt [mmpur_prop_created_at]
    LASTCHANGEDATE,             -- Last change date [mmpur_prop_lastchange_at]
    ARCHIVING_STATUS,           -- Archiving Stat. [mmpur_archiving_status_code]
    PRIMARY KEY (MANDT, PROPOSAL_ID)
);

Learn More