R_RenegotiationListDraft

DDL: R_RENEGOTIATIONLISTDRAFT Type: view_entity BASIC
39 Fields 1 Data Sources 1 Associations

R_RenegotiationListDraft is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mmrenegolist_d) and exposes 39 fields with key field RenegotiationHeaderUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mmrenegolist_d _RenegotiationListDraft from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_RenegotiationDraft _Extension $projection.RenegotiationHeaderUUID = _Extension.RenegotiationHeaderUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY RenegotiationHeaderUUID renegotiationheaderuuid Renego. HDR UUID
RenegotiationID renegotiationid Renegotiation ID
RenegotiationText renegotiationtext Description
RenegotiationStartDate renegotiationstartdate Renegotiation Start
RenegotiationEndDate renegotiationenddate Renegotiation End
RenegotiationStatus renegotiationstatus Renegotiation Status
RenegotiationStatusText renegotiationstatustext Short Description
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
QuotationExistText quotationexisttext Short Description
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
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
RenegttnInitialResponseDueDate renegttninitialresponseduedate Initial Response Due Date
RenegttnIsInBackgroundMode renegttnisinbackgroundmode
RenegttnBckgndProcessingStatus renegttnbckgndprocessingstatus
RenegttnBckgndProcgStatusText renegttnbckgndprocgstatustext

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_RenegotiationListDraft.
-- 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_RenegotiationListDraft AS
SELECT
  RenegotiationHeaderUUID,
  RenegotiationID,
  RenegotiationText,
  RenegotiationStartDate,
  RenegotiationEndDate,
  RenegotiationStatus,
  RenegotiationStatusText,
  PricingProcedure,
  Supplier,
  PurchasingOrganization,
  DocumentCurrency,
  TargetSavingPercent,
  TargetSavingPercentageUnit,
  PricingReferenceDate,
  PriceValidityStartDate,
  PriceValidityEndDate,
  CompanyCode,
  RenegttnExternalReferenceID,
  IsQuotation,
  QuotationExistText,
  RenegotiationSourceRefType,
  LogicalSystem,
  IsEndOfPurposeBlocked,
  CreatedByUser,
  CreationDateTime,
  ChangedBy,
  ChangedOnDateTime,
  LastChangeDateTime,
  RenegttnInitiationDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  RenegttnInitialResponseDueDate,
  RenegttnIsInBackgroundMode,
  RenegttnBckgndProcessingStatus,
  RenegttnBckgndProcgStatusText
FROM mmrenegolist_d AS _RenegotiationListDraft
LEFT OUTER JOIN E_RenegotiationDraft AS _Extension ON RenegotiationHeaderUUID = _Extension.RenegotiationHeaderUUID  -- association [1..1]
;

Learn More