R_RenegotiationList

DDL: R_RENEGOTIATIONLIST Type: view BASIC
35 Fields 1 Data Sources 5 Associations

Renegotiation List

R_RenegotiationList is a Basic CDS View that provides data about "Renegotiation List" in SAP S/4HANA. It reads from 1 data source (mmrenegolist) and exposes 35 fields with key field RenegotiationHeaderUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mmrenegolist mmrenegolist from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_RenegotiationItemList _RenegotiationItem $projection.RenegotiationHeaderUUID = _RenegotiationItem.RenegotiationHeaderUUID
[1..*] R_RenegotiationDfltCndnTypes _RenegotiationDfltCndnTypes $projection.RenegotiationHeaderUUID = _RenegotiationDfltCndnTypes.RenegotiationHeaderUUID
[0..1] I_Currency _Currency $projection.DocumentCurrency = _Currency.Currency
[0..1] I_UserContactCard _CreatedBy $projection.CreatedByUser = _CreatedBy.ContactCardID
[0..1] I_UserContactCard _ChangedBy $projection.ChangedBy = _ChangedBy.ContactCardID

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName RRENEGOLIST view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.semanticKey RenegotiationID view
ObjectModel.representativeKey RenegotiationHeaderUUID view
ObjectModel.sapObjectNodeType.name Renegotiation view
EndUserText.label Renegotiation List view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY RenegotiationHeaderUUID renegotiationheaderuuid Renego. HDR UUID
RenegotiationID renegotiationid Renegotiation ID
RenegotiationText renegotiationtext Description
RenegotiationStartDate renegotiationstartdate Renegotiation Start
RenegotiationEndDate renegotiationenddate Renegotiation End
RenegttnBckgndProcessingStatus renegttnbckgndprocessingstatus
RenegotiationStatus renegotiationstatus Renegotiation Status
PricingProcedure pricingprocedure Procedure
Supplier supplier Supplier
PurchasingOrganization purchasingorganization Purchasing Organization
DocumentCurrency documentcurrency Document Currency
TargetSavingPercent targetsavingpercent Saving Percentage
TargetSavingPercentageUnit targetsavingpercentageunit Percentage Unit
PricingReferenceDate pricingreferencedate Price Reference Date
PriceValidityStartDate pricevaliditystartdate Price valid from
PriceValidityEndDate pricevalidityenddate Valid to
CompanyCode companycode Receiver Company Code
RenegttnExternalReferenceID renegttnexternalreferenceid External Ref. ID
IsQuotation isquotation Quotation Exists
RenegotiationSourceRefType renegotiationsourcereftype Renego. Src. ref. ty
LogicalSystem logicalsystem Logical System
IsEndOfPurposeBlocked isendofpurposeblocked Busin. Purp. Cmpltd.
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
ChangedBy changedby User Name
ChangedOnDateTime changedondatetime Last Changed At
LastChangeDateTime lastchangedatetime Timestamp
RenegttnInitiationDateTime renegttninitiationdatetime Renegotiation Initiated At
RenegttnInitialResponseDueDate renegttninitialresponseduedate Initial Response Due Date
RenegttnIsInBackgroundMode renegttnisinbackgroundmode
_RenegotiationItem _RenegotiationItem
_RenegotiationDfltCndnTypes _RenegotiationDfltCndnTypes
_Currency _Currency
_ChangedBy _ChangedBy
_CreatedBy _CreatedBy

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_RenegotiationList.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_RenegotiationList AS
SELECT
  RenegotiationHeaderUUID,
  RenegotiationID,
  RenegotiationText,
  RenegotiationStartDate,
  RenegotiationEndDate,
  RenegttnBckgndProcessingStatus,
  RenegotiationStatus,
  PricingProcedure,
  Supplier,
  PurchasingOrganization,
  DocumentCurrency,
  TargetSavingPercent,
  TargetSavingPercentageUnit,
  PricingReferenceDate,
  PriceValidityStartDate,
  PriceValidityEndDate,
  CompanyCode,
  RenegttnExternalReferenceID,
  IsQuotation,
  RenegotiationSourceRefType,
  LogicalSystem,
  IsEndOfPurposeBlocked,
  CreatedByUser,
  CreationDateTime,
  ChangedBy,
  ChangedOnDateTime,
  LastChangeDateTime,
  RenegttnInitiationDateTime,
  RenegttnInitialResponseDueDate,
  RenegttnIsInBackgroundMode
FROM mmrenegolist
LEFT OUTER JOIN R_RenegotiationItemList AS _RenegotiationItem ON RenegotiationHeaderUUID = _RenegotiationItem.RenegotiationHeaderUUID  -- association [1..*]
LEFT OUTER JOIN R_RenegotiationDfltCndnTypes AS _RenegotiationDfltCndnTypes ON RenegotiationHeaderUUID = _RenegotiationDfltCndnTypes.RenegotiationHeaderUUID  -- association [1..*]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedBy ON ChangedBy = _ChangedBy.ContactCardID  -- association [0..1]
;

Learn More