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