R_CNTRLPURCONTRACTHDRNOTESTP

CDS View

Central Purchase Contract Header Notes

R_CNTRLPURCONTRACTHDRNOTESTP is a CDS View in S/4HANA. Central Purchase Contract Header Notes. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CntrlPurContrHeaderNotes_2 view_entity projection CONSUMPTION
I_CntrlPurContrHdrNotesTP_2 view_entity projection TRANSACTIONAL CCTR Header Notes - TP 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Central Purchase Contract Header Notes'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.semanticKey:  [ 'CentralPurchaseContract' ]


@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

@Metadata.ignorePropagatedAnnotations: true

define view entity R_CntrlPurContractHdrNotesTP
  as select from I_CntrlPurContractHeaderNotes

  association to parent R_CntrlPurchaseContractTP as _CntrlPurchaseContract on $projection.CentralPurchaseContract = _CntrlPurchaseContract.CentralPurchaseContract

{

  key I_CntrlPurContractHeaderNotes.PurchasingDocumentNoteUUID,
      I_CntrlPurContractHeaderNotes.PurchasingDocumentObjNodeType,
      left( I_CntrlPurContractHeaderNotes.PurchasingDocumentNoteObjectID, 10 ) as CentralPurchaseContract,
      I_CntrlPurContractHeaderNotes.PurchasingDocumentNoteObjectID,
      I_CntrlPurContractHeaderNotes.PurchasingDocumentNoteType,
      I_CntrlPurContractHeaderNotes.PurchasingDocumentNoteLanguage,
      I_CntrlPurContractHeaderNotes.PurchasingDocumentNoteTitle,
      I_CntrlPurContractHeaderNotes.PurchasingDocumentNoteMimeType,
      I_CntrlPurContractHeaderNotes.PurgDocNoteCreatedBy,
      I_CntrlPurContractHeaderNotes.PurgDocNoteCreationDateTime,
      I_CntrlPurContractHeaderNotes.PurgDocNoteLastChangedBy,
      I_CntrlPurContractHeaderNotes.PurgDocNoteLastChangedDateTime,
      I_CntrlPurContractHeaderNotes.PurgDocNoteText,
      _CentralPurchaseContract.LastChangeDateTime                              as LastChangeDateTime,

      /* Associations */
      _CntrlPurchaseContract
}

Learn More