MMRENEGOLIST_D
Draft table for entity R_RENEGOTIATIONLISTTP
MMRENEGOLIST_D is an SAP database table in S/4HANA. Draft table for entity R_RENEGOTIATIONLISTTP. It contains 31 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_RenegotiationDraft | view_entity | from | EXTENSION | Renegotiation Header - Extension |
| R_RenegotiationListDraft | view_entity | from | BASIC | Draft view for Renegotiation List |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | renegotiationheaderuuid | mmpur_renego_hdr_uuid | Renego. HDR UUID | |||
| renegotiationid | mmpur_renego_id | Renegotiation ID | ||||
| renegotiationtext | mmpur_renego_desc | Description | ||||
| renegotiationstartdate | mmpur_renego_start | Renegotiation Start | ||||
| renegotiationenddate | mmpur_renego_end | Renegotiation End | ||||
| renegotiationstatus | mmpur_renego_status | Renegotiation Status | ||||
| renegotiationstatustext | val_text | Short Description | ||||
| pricingprocedure | kalsm_d | Procedure | ||||
| supplier | elifn | Supplier | ||||
| purchasingorganization | ekorg | Purchasing Org. | ||||
| documentcurrency | currency | Currency Key | ||||
| targetsavingpercent | mmpur_savingpercentage | Saving Percentage | ||||
| targetsavingpercentageunit | mmpur_savingpercentageunit | Percentage Unit | ||||
| pricingreferencedate | mmpur_pricereferencedate | Price Reference Date | ||||
| pricevaliditystartdate | mmpur_pricevalidfrom | Price valid from | ||||
| pricevalidityenddate | mmpur_pricevalidto | Price valid to | ||||
| companycode | bukrs | Company Code | ||||
| renegttnexternalreferenceid | mmpur_renegttnextrefid | External Ref. ID | ||||
| isquotation | mmpur_quotationexist | Quotation Exists | ||||
| quotationexisttext | val_text | Short Description | ||||
| renegotiationsourcereftype | mmpur_renegosourcereftype | Renego. Src. ref. ty | ||||
| logicalsystem | mmpur_d_hub_logsys | Logical System | ||||
| isendofpurposeblocked | eopblocked | Busin. Purp. Cmpltd. | ||||
| createdbyuser | mmpur_ernam | Created By | ||||
| creationdatetime | vdm_renegottncreatedatetime | Created on | ||||
| changedby | mmpur_cat_changd_by | Changed By | ||||
| changedondatetime | changedatetime | Last Changed | ||||
| lastchangedatetime | changedatetime | Last Changed | ||||
| renegttninitiationdatetime | vdm_ctr_reneg_initiatedatetime | Renegotiation Initiated At | ||||
| renegttninitialresponseduedate | vdm_reneginitialrespduedate | Initial Response Due Date |
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_RENEGOTIATIONLISTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMRENEGOLIST_D (
MANDT, -- Client [mandt]
RENEGOTIATIONHEADERUUID, -- Renego. HDR UUID [mmpur_renego_hdr_uuid]
RENEGOTIATIONID, -- Renegotiation ID [mmpur_renego_id]
RENEGOTIATIONTEXT, -- Description [mmpur_renego_desc]
RENEGOTIATIONSTARTDATE, -- Renegotiation Start [mmpur_renego_start]
RENEGOTIATIONENDDATE, -- Renegotiation End [mmpur_renego_end]
RENEGOTIATIONSTATUS, -- Renegotiation Status [mmpur_renego_status]
RENEGOTIATIONSTATUSTEXT, -- Short Description [val_text]
PRICINGPROCEDURE, -- Procedure [kalsm_d]
SUPPLIER, -- Supplier [elifn]
PURCHASINGORGANIZATION, -- Purchasing Org. [ekorg]
DOCUMENTCURRENCY, -- Currency Key [currency]
TARGETSAVINGPERCENT, -- Saving Percentage [mmpur_savingpercentage]
TARGETSAVINGPERCENTAGEUNIT, -- Percentage Unit [mmpur_savingpercentageunit]
PRICINGREFERENCEDATE, -- Price Reference Date [mmpur_pricereferencedate]
PRICEVALIDITYSTARTDATE, -- Price valid from [mmpur_pricevalidfrom]
PRICEVALIDITYENDDATE, -- Price valid to [mmpur_pricevalidto]
COMPANYCODE, -- Company Code [bukrs]
RENEGTTNEXTERNALREFERENCEID, -- External Ref. ID [mmpur_renegttnextrefid]
ISQUOTATION, -- Quotation Exists [mmpur_quotationexist]
QUOTATIONEXISTTEXT, -- Short Description [val_text]
RENEGOTIATIONSOURCEREFTYPE, -- Renego. Src. ref. ty [mmpur_renegosourcereftype]
LOGICALSYSTEM, -- Logical System [mmpur_d_hub_logsys]
ISENDOFPURPOSEBLOCKED, -- Busin. Purp. Cmpltd. [eopblocked]
CREATEDBYUSER, -- Created By [mmpur_ernam]
CREATIONDATETIME, -- Created on [vdm_renegottncreatedatetime]
CHANGEDBY, -- Changed By [mmpur_cat_changd_by]
CHANGEDONDATETIME, -- Last Changed [changedatetime]
LASTCHANGEDATETIME, -- Last Changed [changedatetime]
RENEGTTNINITIATIONDATETIME, -- Renegotiation Initiated At [vdm_ctr_reneg_initiatedatetime]
RENEGTTNINITIALRESPONSEDUEDATE, -- Initial Response Due Date [vdm_reneginitialrespduedate]
PRIMARY KEY (MANDT, RENEGOTIATIONHEADERUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA