C_RenegotiationListTP

DDL: C_RENEGOTIATIONLISTTP Type: view_entity CONSUMPTION Package: APPL_MM_PUR_CTR_RENEGOTIATION
39 Fields 1 Data Sources 1 OData Services

Renegotiation list - TP

C_RenegotiationListTP is a Consumption CDS View that provides data about "Renegotiation list - TP" in SAP S/4HANA. It reads from 1 data source (R_RenegotiationListTP) and exposes 39 fields with key field RenegotiationHeaderUUID. It is exposed through 1 OData service (UI_PURCONTRRENEGTTN_MANAGE). Part of development package APPL_MM_PUR_CTR_RENEGOTIATION.

Data Sources (1)

SourceAliasJoin Type
R_RenegotiationListTP R_RenegotiationListTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey RenegotiationHeaderUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Renegotiation list - TP view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PURCONTRRENEGTTN_MANAGE UI_PURCONTRRENEGTTN_MANAGE V2 C1 NOT_RELEASED

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
SupplierName _Supplier SupplierName Supplier Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
DocumentCurrency DocumentCurrency Document Currency
CurrencyName
TargetSavingPercent TargetSavingPercent Saving Percentage
TargetSavingPercentageUnit TargetSavingPercentageUnit Percentage Unit
PricingReferenceDate PricingReferenceDate Price Reference Date
PriceValidityStartDate PriceValidityStartDate Price valid from
PriceValidityEndDate PriceValidityEndDate Valid to
RenegttnInitialResponseDueDate RenegttnInitialResponseDueDate Initial Response Due Date
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
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
CreatedByUserName _CreatedBy UserDescription Full Name
CreationDateTime CreationDateTime Timestamp
ChangedBy ChangedBy User Name
ChangedByUserName _ChangedBy UserDescription Full Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangeDateTime LastChangeDateTime Timestamp
_ChangedBy _ChangedBy
_CreatedBy _CreatedBy
_Currency _Currency
_RenegotiationQuotation _RenegotiationQuotation

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 C_RenegotiationListTP.
-- 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 C_RenegotiationListTP AS
SELECT
  RenegotiationHeaderUUID,
  RenegotiationID,
  RenegotiationText,
  RenegotiationStartDate,
  RenegotiationEndDate,
  RenegotiationStatus,
  RenegotiationStatusText,
  PricingProcedure,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  DocumentCurrency,
  _Currency._Text[1: Language = $session.system_language].CurrencyName AS CurrencyName,
  TargetSavingPercent,
  TargetSavingPercentageUnit,
  PricingReferenceDate,
  PriceValidityStartDate,
  PriceValidityEndDate,
  RenegttnInitialResponseDueDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  RenegttnExternalReferenceID,
  IsQuotation,
  QuotationExistText,
  RenegotiationSourceRefType,
  LogicalSystem,
  IsEndOfPurposeBlocked,
  CreatedByUser,
  _CreatedBy.UserDescription AS CreatedByUserName,
  CreationDateTime,
  ChangedBy,
  _ChangedBy.UserDescription AS ChangedByUserName,
  ChangedOnDateTime,
  LastChangeDateTime
FROM R_RenegotiationListTP
;

Learn More