R_SOURCINGPROJECTNEGOTIATIONTP

CDS View

Negotiation for Sourcing Project - TP

R_SOURCINGPROJECTNEGOTIATIONTP is a CDS View in S/4HANA. Negotiation for Sourcing Project - TP. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_SourcingProjectNegotiation view_entity projection CONSUMPTION Negotiation for Sourcing Project
C_SourcingProjectNegotiationTP view_entity projection CONSUMPTION Negotiation for Sourcing Project - TP
ESH_N_SRCGPROJNEGOTIATION view from
I_SourcingProjectNegotiationTP view_entity projection TRANSACTIONAL Negotiation for Sourcing Project - TP 
@EndUserText.label: 'Negotiation for Sourcing Project - TP'
//@AbapCatalog.sqlViewName: 'RSPNEGNTP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
//@AbapCatalog.preserveKey:true


@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.compiler.compareFilter:true

@ObjectModel:{    semanticKey: ['SourcingProjectNegotiation'],
                  representativeKey: 'SourcingProjectNegotiationUUID',
                  usageType.dataClass: #TRANSACTIONAL,
                  usageType.serviceQuality: #C,
                  usageType.sizeCategory: #L }
@ObjectModel.sapObjectNodeType.name: 'SourcingProjectNegotiation'
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_Extension'],
  allowNewDatasources: false,
  elementSuffix: 'SNH',
  quota: { maximumFields: 404,
           maximumBytes: 40400 },
  allowNewCompositions: true }

define root view entity R_SourcingProjectNegotiationTP
  as select from R_SourcingProjectNegotiation as _SourcingProjectNegotiation
  composition [1..*] of R_SrcgProjNegttnQuotationTP  as _SrcgProjNegttnQuotationTP
  //composition [1..*] of I_SrcgProjNegttnQtanSummary as _SrcgProjNegttnQtanSummary


  association [1..1] to R_SourcingProjectTP          as _SourcingProjectTP on $projection.SourcingProjectUUID = _SourcingProjectTP.SourcingProjectUUID
  //association [0..1] to I_UserContactCard            as _CreatedByUser   on $projection.CreatedByUser = _CreatedByUser.ContactCardID

  //association [0..1] to I_UserContactCard            as _ChangedByUser   on $projection.LastChangedByUser = _ChangedByUser.ContactCardID


  //Extension

  association [1..1] to E_SourcingProjectNegotiation as _Extension         on $projection.SourcingProjectNegotiationUUID = _Extension.SourcingProjectNegotiationUUID
{
  key SourcingProjectNegotiationUUID,
      SourcingProjectNegotiation,
      SourcingProjectNegotiationType,
      SourcingProjectNegotiationName,

      SrcgProjNegttnLifecycleStatus,
      SrcgProjNegotiationStartDate,
      SrcgProjNegotiationEndDate,

      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,

      SourcingProjectUUID,
      _SourcingProjectTP.SourcingProject,
      _SourcingProjectTP.SourcingProjectName,
      _SourcingProjectTP.SourcingProjectVersion,
      //      cast( '' as abap.char( 1 ) )             as SrcgProjNotesAreAllowed,

      cast( '' as abap.char( 1 ) ) as HasNote,

      _SourcingProjectTP,
      _SrcgProjNegttnQuotationTP,
      _SrcgProjNegotiationQuotation,
      _SrcgProjNegttnLfcycStatus,
      _SrcgProjNegotiationType,
      _SrcgProjNegttnQtanSummary,
      _CreatedByUser,
      _ChangedByUser

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_SOURCINGPROJECTNEGOTIATION",
"R_SOURCINGPROJECTTP"
],
"ASSOCIATED":
[
"I_SRCGPROJNEGOTIATIONTYPE",
"I_SRCGPROJNEGTTNLFCYCSTATUS",
"I_SRCGPROJNEGTTNQTANSUMMARY",
"I_USERCONTACTCARD",
"R_SOURCINGPROJECTTP",
"R_SRCGPROJNEGOTIATIONQUOTATION",
"R_SRCGPROJNEGTTNQUOTATIONTP"
],
"BASE":
[
"R_SOURCINGPROJECTNEGOTIATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More