A_SourcingProjectNegotiation

DDL: A_SOURCINGPROJECTNEGOTIATION Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_SRCGPROJNGN_API

Negotiation for Sourcing Project

A_SourcingProjectNegotiation is a Consumption CDS View that provides data about "Negotiation for Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectNegotiationTP) and exposes 15 fields with key field SourcingProjectNegotiationUUID. It is exposed through 1 OData service (API_SOURCINGPROJECTNEGOTIATION). Part of development package ODATA_MM_PUR_SRCGPROJNGN_API.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectNegotiationTP R_SourcingProjectNegotiationTP projection

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey SourcingProjectNegotiationUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Negotiation for Sourcing Project view
OData.entityType.name SourcingProjectNegotiation_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SNH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
AbapCatalog.extensibility.allowNewCompositions true view

OData Services (1)

ServiceBindingVersionContractRelease
API_SOURCINGPROJECTNEGOTIATION API_SRCGPROJECTNEGOTIATION V4 C2 Deprecated

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectNegotiationUUID SourcingProjectNegotiationUUID Negotiation UUID
SourcingProjectNegotiation SourcingProjectNegotiation Negotiation for Sourcing Project
SourcingProjectNegotiationType SourcingProjectNegotiationType Negotiation Type
SourcingProjectNegotiationName SourcingProjectNegotiationName Negotiation Name
SrcgProjNegttnLifecycleStatus SrcgProjNegttnLifecycleStatus Negotiation Status
SrcgProjNegotiationStartDate SrcgProjNegotiationStartDate Negotiation Start Date
SrcgProjNegotiationEndDate SrcgProjNegotiationEndDate Negotiation End Date
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProject SourcingProject Sourcing Project
SourcingProjectName SourcingProjectName Name
SourcingProjectVersion SourcingProjectVersion Sourcing Project Version

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 A_SourcingProjectNegotiation.
-- 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 A_SourcingProjectNegotiation AS
SELECT
  SourcingProjectNegotiationUUID,
  SourcingProjectNegotiation,
  SourcingProjectNegotiationType,
  SourcingProjectNegotiationName,
  SrcgProjNegttnLifecycleStatus,
  SrcgProjNegotiationStartDate,
  SrcgProjNegotiationEndDate,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  SourcingProjectUUID,
  SourcingProject,
  SourcingProjectName,
  SourcingProjectVersion
FROM R_SourcingProjectNegotiationTP
;