C_SourcingProjectNegotiationTP

DDL: C_SOURCINGPROJECTNEGOTIATIONTP Type: view_entity CONSUMPTION
28 Fields 1 Data Sources 2 Associations

Negotiation for Sourcing Project - TP

C_SourcingProjectNegotiationTP is a Consumption CDS View that provides data about "Negotiation for Sourcing Project - TP" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectNegotiationTP) and exposes 28 fields with key field SourcingProjectNegotiationUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectNegotiationTP R_SourcingProjectNegotiationTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_SrcgProjItemHierarchy _SrcgProjItemHierarchy $projection.SourcingProjectUUID = _SrcgProjItemHierarchy.SourcingProjectUUID
[0..*] C_SrcgProjNegttnQtanSummary _SrcgProjNegttnQtanSummary $projection.SourcingProjectNegotiationUUID = _SrcgProjNegttnQtanSummary.SourcingProjectNegotiationUUID

Annotations (20)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey SourcingProjectNegotiationUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
EndUserText.label Negotiation for Sourcing Project - TP view
UI.headerInfo.typeName Negotiation view
UI.headerInfo.typeNamePlural Negotiations view
UI.headerInfo.title.value SourcingProjectNegotiationName view
UI.headerInfo.description.value SourcingProjectNegotiation view
Metadata.allowExtensions true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SNH view
AbapCatalog.extensibility.quota.maximumFields 404 view
AbapCatalog.extensibility.quota.maximumBytes 40400 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectNegotiationUUID _SourcingProjectNegotiationTP SourcingProjectNegotiationUUID Negotiation UUID
SourcingProjectNegotiationName _SourcingProjectNegotiationTP SourcingProjectNegotiationName Negotiation Name
SourcingProjectUUID _SourcingProjectNegotiationTP SourcingProjectUUID Sourcing Project UUID
SourcingProjectNegotiationType _SourcingProjectNegotiationTP SourcingProjectNegotiationType Negotiation Type
SourcingProjectNegotiation SourcingProjectNegotiation Negotiation for Sourcing Project
LastChangeDateTime LastChangeDateTime Timestamp
SrcgProjNegttnStartDateTime SrcgProjNegttnStartDateTime Negotiation Start Date Time
SrcgProjNegotiationStartDate SrcgProjNegotiationStartDate Negotiation Start Date
SrcgProjNegttnEndDateTime SrcgProjNegttnEndDateTime Negotiation End Date Time
SrcgProjNegotiationEndDate SrcgProjNegotiationEndDate Negotiation End Date
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser Created by User
CreatedByUserName _CreatedByUser UserDescription Full Name
LastChangedByUser _SourcingProjectNegotiationTP LastChangedByUser Last Changed by User
ChangedByUserName _ChangedByUser UserDescription Full Name
SrcgProjNegttnLifecycleStatus _SourcingProjectNegotiationTP SrcgProjNegttnLifecycleStatus Status
SourcingProject SourcingProject Sourcing Project
SourcingProjectName SourcingProjectName Name
SourcingProjectVersion SourcingProjectVersion Sourcing Project Version
virtualBiddervdm_businesspartner
char450 Note Type List Text
_SrcgProjItemHierarchy _SrcgProjItemHierarchy
_SourcingProjectTP _SourcingProjectTP
_SrcgProjNegttnLfcycStatus _SrcgProjNegttnLfcycStatus
_SrcgProjNegotiationType _SrcgProjNegotiationType
_SrcgProjNegttnQtanSummary _SrcgProjNegttnQtanSummary
_ChangedByUser _ChangedByUser
_CreatedByUser _CreatedByUser

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_SourcingProjectNegotiationTP.
-- 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_SourcingProjectNegotiationTP AS
SELECT
  _SourcingProjectNegotiationTP.SourcingProjectNegotiationUUID AS SourcingProjectNegotiationUUID,
  _SourcingProjectNegotiationTP.SourcingProjectNegotiationName AS SourcingProjectNegotiationName,
  _SourcingProjectNegotiationTP.SourcingProjectUUID AS SourcingProjectUUID,
  _SourcingProjectNegotiationTP.SourcingProjectNegotiationType AS SourcingProjectNegotiationType,
  SourcingProjectNegotiation,
  LastChangeDateTime,
  SrcgProjNegttnStartDateTime,
  SrcgProjNegotiationStartDate,
  SrcgProjNegttnEndDateTime,
  SrcgProjNegotiationEndDate,
  CreationDateTime,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  _SourcingProjectNegotiationTP.LastChangedByUser AS LastChangedByUser,
  _ChangedByUser.UserDescription AS ChangedByUserName,
  _SourcingProjectNegotiationTP.SrcgProjNegttnLifecycleStatus AS SrcgProjNegttnLifecycleStatus,
  SourcingProject,
  SourcingProjectName,
  SourcingProjectVersion,
  virtual Bidder : vdm_businesspartner AS virtualBiddervdm_businesspartner,
  virtual NoteTypeListText : abap.char( 450 ) AS char450
FROM R_SourcingProjectNegotiationTP
LEFT OUTER JOIN C_SrcgProjItemHierarchy AS _SrcgProjItemHierarchy ON SourcingProjectUUID = _SrcgProjItemHierarchy.SourcingProjectUUID  -- association [1..*]
LEFT OUTER JOIN C_SrcgProjNegttnQtanSummary AS _SrcgProjNegttnQtanSummary ON SourcingProjectNegotiationUUID = _SrcgProjNegttnQtanSummary.SourcingProjectNegotiationUUID  -- association [0..*]
;

Learn More