I_RenegotiationList

DDL: I_RENEGOTIATIONLIST SQL: IRENEGOLIST Type: view BASIC

Renegotiation List

I_RenegotiationList is a Basic CDS View that provides data about "Renegotiation List" in SAP S/4HANA. It reads from 1 data source (R_RenegotiationList) and exposes 33 fields with key field RenegotiationHeaderUUID.

Data Sources (1)

SourceAliasJoin Type
R_RenegotiationList R_RenegotiationList from

Annotations (14)

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

Fields (33)

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
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
_ChangedBy _ChangedBy
_CreatedBy _CreatedBy
_Currency _Currency
_RenegotiationDfltCndnTypes _RenegotiationDfltCndnTypes
_RenegotiationItem _RenegotiationItem

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 I_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.
-- SQL view name: IRENEGOLIST

CREATE VIEW I_RenegotiationList AS
SELECT
  RenegotiationHeaderUUID,
  RenegotiationID,
  RenegotiationText,
  RenegotiationStartDate,
  RenegotiationEndDate,
  RenegotiationStatus,
  PricingProcedure,
  Supplier,
  PurchasingOrganization,
  DocumentCurrency,
  TargetSavingPercent,
  TargetSavingPercentageUnit,
  PricingReferenceDate,
  PriceValidityStartDate,
  PriceValidityEndDate,
  CompanyCode,
  RenegttnExternalReferenceID,
  IsQuotation,
  RenegotiationSourceRefType,
  LogicalSystem,
  IsEndOfPurposeBlocked,
  CreatedByUser,
  CreationDateTime,
  ChangedBy,
  ChangedOnDateTime,
  LastChangeDateTime,
  RenegttnInitiationDateTime,
  RenegttnInitialResponseDueDate
FROM R_RenegotiationList
;