MMRENEGHISTORY_D

Transparent Table Application Table
19 Fields 2 CDS Views

Draft table for entity R_RENEGOTIATIONPRICINGLOGTP

MMRENEGHISTORY_D is an SAP database table in S/4HANA. Draft table for entity R_RENEGOTIATIONPRICINGLOGTP. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_RenegotiationPricingDraft view_entity from EXTENSION Reneg Pricing Log - Extension
R_RenegotiationPricingLogDraft view_entity from BASIC

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY renegotiationheaderuuid mmpur_renego_hdr_uuid Renego. HDR UUID
KEY renegotiationitemuuid mmpur_renego_item_uuid Renego. Item UUID
KEY renegotiationloguuid mmpur_renego_hdr_uuid Renego. HDR UUID
conditiontype kschl Condition Type
pricevaliditystartdate mmpur_pricevalidfrom Price valid from
pricevalidityenddate mmpur_pricevalidto Price valid to
conditionquantity kpein Pricing Unit
conditionquantityunit kmein Unit of Measure
supplierquotation ebeln Purchasing Doc.
supplierquotationitem ebelp Item
documentcurrency waers Currency
lastchangedatetime changedatetime Last Changed
conditionrateratiounit msehiunit Unit of Measure
conditionrateratio vfprc_element_ratio Ratio
conditioncurrency waers Currency
conditionrateamount vfprc_element_amount Amount
conditionratevalueisamount boole_d TRUE
conditionratevalueisratio boole_d TRUE

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.

-- Draft table for entity R_RENEGOTIATIONPRICINGLOGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMRENEGHISTORY_D (
    MANDT,                       -- Client [mandt]
    RENEGOTIATIONHEADERUUID,     -- Renego. HDR UUID [mmpur_renego_hdr_uuid]
    RENEGOTIATIONITEMUUID,       -- Renego. Item UUID [mmpur_renego_item_uuid]
    RENEGOTIATIONLOGUUID,        -- Renego. HDR UUID [mmpur_renego_hdr_uuid]
    CONDITIONTYPE,               -- Condition Type [kschl]
    PRICEVALIDITYSTARTDATE,      -- Price valid from [mmpur_pricevalidfrom]
    PRICEVALIDITYENDDATE,        -- Price valid to [mmpur_pricevalidto]
    CONDITIONQUANTITY,           -- Pricing Unit [kpein]
    CONDITIONQUANTITYUNIT,       -- Unit of Measure [kmein]
    SUPPLIERQUOTATION,           -- Purchasing Doc. [ebeln]
    SUPPLIERQUOTATIONITEM,       -- Item [ebelp]
    DOCUMENTCURRENCY,            -- Currency [waers]
    LASTCHANGEDATETIME,          -- Last Changed [changedatetime]
    CONDITIONRATERATIOUNIT,      -- Unit of Measure [msehiunit]
    CONDITIONRATERATIO,          -- Ratio [vfprc_element_ratio]
    CONDITIONCURRENCY,           -- Currency [waers]
    CONDITIONRATEAMOUNT,         -- Amount [vfprc_element_amount]
    CONDITIONRATEVALUEISAMOUNT,  -- TRUE [boole_d]
    CONDITIONRATEVALUEISRATIO,   -- TRUE [boole_d]
    PRIMARY KEY (MANDT, RENEGOTIATIONHEADERUUID, RENEGOTIATIONITEMUUID, RENEGOTIATIONLOGUUID)
);

Learn More