I_SPNegttnEndDateSituation

DDL: I_SPNEGTTNENDDATESITUATION Type: view_entity COMPOSITE
17 Fields 2 Data Sources 1 Associations

Srcg Proj Negotiation End Date Situation

I_SPNegttnEndDateSituation (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_SPNegttnEndDateSituation is a Composite CDS View that provides data about "Srcg Proj Negotiation End Date Situation" in SAP S/4HANA. It reads from 2 data sources (R_SourcingProject, R_SourcingProjectNegotiation) and exposes 17 fields with key field SourcingProjectNegotiationUUID. It has 1 association to related views.

SAP Help Documentation

CategoryProduct Sourcing
Purpose
This CDS view retrieves information about the negotiation that acts as a trigger for the situation template Negotiation Deadline is Approaching ( PROC_SRCGPROJNEGNENDDATE ). To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description SOURCINGPROJECTNEGOTIATIONUUID Negotiation UUID SOURCINGPROJECTNEGOTIATION Negotiation for Sourcing Project SRCGPROJNEGOTIATIONENDDATE End Date of Negotiation SRCGPROJNEGOTIATIONSTARTDATE Start Date of Negotiation SOURCINGPROJECTNEGOTIATIONTYPE Type of Negotiation NUMBEROFDAYS Number of Days to Negotiation EndDate SOURCINGPROJECTUUID Sourcing Project UUID SOURCINGPROJECT Sourcing Project SOURCINGPROJECTVERSION Sourcing Project Version PURCHASINGGROUP Purchasing Group SOURCINGPROJECTTYPE Sourcing Project Type COMPANYCODE Company Code PURCHASINGORGANIZATION Purchasing Organization MATERIALGROUP Material Group PURCHASERRESPONSIBLEUSER Purchaser Responsible User

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-SRC-NGN
CapabilitiesSituation Handling: Trigger Object, Situation Handling: Anchor Object
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
R_SourcingProject R_SourcingProject from
R_SourcingProjectNegotiation SourcingProjectNegotiation inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SourcingProjectSitnAnchor _SourcingProjectSitnAnchor $projection.SourcingProjectUUID = _SourcingProjectSitnAnchor.SourcingProjectUUID

Annotations (8)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Srcg Proj Negotiation End Date Situation view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectNegotiationUUID R_SourcingProjectNegotiation SourcingProjectNegotiationUUID Negotiation UUID
SourcingProjectUUID R_SourcingProjectNegotiation SourcingProjectUUID Sourcing Project UUID
SourcingProjectNegotiation R_SourcingProjectNegotiation SourcingProjectNegotiation Negotiation for Sourcing Project
SrcgProjNegotiationEndDate R_SourcingProjectNegotiation SrcgProjNegotiationEndDate End Date of Negotiation
SrcgProjNegotiationStartDate R_SourcingProjectNegotiation SrcgProjNegotiationStartDate Start Date of Negotiation
SourcingProjectNegotiationType R_SourcingProjectNegotiation SourcingProjectNegotiationType Type of Negotiation
SourcingProject R_SourcingProject SourcingProject Sourcing Project
SourcingProjectVersion R_SourcingProject SourcingProjectVersion Sourcing Project Version
PurchasingGroup R_SourcingProject PurchasingGroup Purchasing Group
SourcingProjectType R_SourcingProject SourcingProjectType Sourcing Project Type
CompanyCode R_SourcingProject CompanyCode Receiver Company Code
MaterialGroup R_SourcingProject MaterialGroup Material Group
PurchasingCategory R_SourcingProject PurchasingCategory Purchasing Category ID
PurchasingOrganization R_SourcingProject PurchasingOrganization Purchasing Organization
ProjectUUID R_SourcingProject SourcingProjectUUID Sourcing Project UUID
PurchaserResponsibleUser _SourcingProjectSitnAnchor PurchaserResponsibleUser Purchaser Responsible User
_SourcingProjectSitnAnchor _SourcingProjectSitnAnchor

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_SPNegttnEndDateSituation.
-- 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 I_SPNegttnEndDateSituation AS
SELECT
  SourcingProjectNegotiation.SourcingProjectNegotiationUUID AS SourcingProjectNegotiationUUID,
  SourcingProjectNegotiation.SourcingProjectUUID AS SourcingProjectUUID,
  SourcingProjectNegotiation.SourcingProjectNegotiation AS SourcingProjectNegotiation,
  SourcingProjectNegotiation.SrcgProjNegotiationEndDate AS SrcgProjNegotiationEndDate,
  SourcingProjectNegotiation.SrcgProjNegotiationStartDate AS SrcgProjNegotiationStartDate,
  SourcingProjectNegotiation.SourcingProjectNegotiationType AS SourcingProjectNegotiationType,
  R_SourcingProject.SourcingProject AS SourcingProject,
  R_SourcingProject.SourcingProjectVersion AS SourcingProjectVersion,
  R_SourcingProject.PurchasingGroup AS PurchasingGroup,
  R_SourcingProject.SourcingProjectType AS SourcingProjectType,
  R_SourcingProject.CompanyCode AS CompanyCode,
  R_SourcingProject.MaterialGroup AS MaterialGroup,
  R_SourcingProject.PurchasingCategory AS PurchasingCategory,
  R_SourcingProject.PurchasingOrganization AS PurchasingOrganization,
  R_SourcingProject.SourcingProjectUUID AS ProjectUUID,
  _SourcingProjectSitnAnchor.PurchaserResponsibleUser AS PurchaserResponsibleUser
FROM R_SourcingProject
INNER JOIN R_SourcingProjectNegotiation AS SourcingProjectNegotiation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SourcingProjectSitnAnchor AS _SourcingProjectSitnAnchor ON SourcingProjectUUID = _SourcingProjectSitnAnchor.SourcingProjectUUID  -- association [1..1]
;

Learn More