C_CePuCoItmNotesForMassUpdt

DDL: C_CEPUCOITMNOTESFORMASSUPDT SQL: CCTRITMNTFORMASS Type: view CONSUMPTION

Central Purchase Contract Item Notes

C_CePuCoItmNotesForMassUpdt is a Consumption CDS View that provides data about "Central Purchase Contract Item Notes" in SAP S/4HANA. It reads from 1 data source (R_CntrlPurContrItemNotesTP) and exposes 17 fields with key field PurchasingDocumentNoteUUID. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
R_CntrlPurContrItemNotesTP R_CntrlPurContrItemNotesTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContract _CentralPurchaseContract $projection.CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract
[1..1] I_CntrlPurchaseContractItem _CntrlPurchaseContractItem $projection.CentralPurchaseContract = _CntrlPurchaseContractItem.CentralPurchaseContract and $projection.CentralPurchaseContractItem = _CntrlPurchaseContractItem.CentralPurchaseContractItem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCTRITMNTFORMASS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Central Purchase Contract Item Notes view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #NONE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentNoteUUID PurchasingDocumentNoteUUID Note ID
CentralPurchaseContract Central Contract
CentralPurchaseContractItem CentralPurchaseContractItem Item
FormattedPurchaseContractItem
PurchasingDocumentNoteType PurchasingDocumentNoteType Note Type
PurchasingDocumentNoteLanguage PurchasingDocumentNoteLanguage Language
PurchasingDocumentNoteTitle PurchasingDocumentNoteTitle Note Type Description
PurchasingDocumentNoteMimeType PurchasingDocumentNoteMimeType
IsCreated Is New
IsDeleted Deletion Indicator
PurgDocNoteText PurgDocNoteText Text
LanguageName _LanguageDef LanguageName Language Description
ActivePurchasingDocument _CentralPurchaseContract ActivePurchasingDocument
PurchasingDocumentDeletionCode _CentralPurchaseContract PurchasingDocumentDeletionCode
PurchasingContractDeletionCode _CntrlPurchaseContractItem PurchasingContractDeletionCode
PurgDocChangeRequestStatus _CentralPurchaseContract PurgDocChangeRequestStatus
_CentralPurchaseContract _CentralPurchaseContract 
@AbapCatalog.sqlViewName: 'CCTRITMNTFORMASS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Central Purchase Contract Item Notes'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking:  #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type : #NONE
define view C_CePuCoItmNotesForMassUpdt
  as select from R_CntrlPurContrItemNotesTP  
  association [1..1] to I_CentralPurchaseContract   as _CentralPurchaseContract   on  $projection.CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract
  
  association [1..1] to I_CntrlPurchaseContractItem as _CntrlPurchaseContractItem on  $projection.CentralPurchaseContract     = _CntrlPurchaseContractItem.CentralPurchaseContract
                                                                                  and $projection.CentralPurchaseContractItem = _CntrlPurchaseContractItem.CentralPurchaseContractItem
  
{
       @EndUserText.label: 'Note ID'
  key  PurchasingDocumentNoteUUID,

       @EndUserText.label: 'Central Contract'
       cast( CentralPurchaseContract as ebeln preserving type ) as CentralPurchaseContract ,
      
       @EndUserText.label: 'Item'
       CentralPurchaseContractItem,
       
       cast (concat(concat(_CentralPurchaseContract.ActivePurchasingDocument, '/'), _CntrlPurchaseContractItem.CentralPurchaseContractItem ) as formattedcontractitem) as FormattedPurchaseContractItem,
       
       @EndUserText.label: 'Note Type'
       PurchasingDocumentNoteType,

       @EndUserText.label: 'Language'
       PurchasingDocumentNoteLanguage,

       @EndUserText.label: 'Note Type Description'
       PurchasingDocumentNoteTitle,

       PurchasingDocumentNoteMimeType,

       @EndUserText.label: 'Is New'
       cast ('' as xfeld)                                                                                                       as IsCreated,

       @EndUserText.label: 'Deletion Indicator'
       cast ('' as xfeld)                                                                                                       as IsDeleted,

       @EndUserText.label: 'Text'
       PurgDocNoteText,

       @EndUserText.label: 'Language Description'
       _LanguageDef.LanguageName,

       _CentralPurchaseContract.ActivePurchasingDocument,

     //  PurchasingDocumentNoteLength,

       
       _CentralPurchaseContract.PurchasingDocumentDeletionCode,
       _CntrlPurchaseContractItem.PurchasingContractDeletionCode,
       _CentralPurchaseContract.PurgDocChangeRequestStatus,

       //needed for DCL

       _CentralPurchaseContract
       
}
where
       _CentralPurchaseContract.PurchasingDocumentSubtype      <> 'H' 
  and  _CentralPurchaseContract.PurchasingDocumentSubtype      <> 'C' 
  and  _CentralPurchaseContract.PurchasingDocumentOrigin       <> 'N'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CENTRALPURCHASECONTRACT",
"I_CNTRLPURCHASECONTRACTITEM",
"R_CNTRLPURCONTRITEMNOTESTP",
"SGBT_NTE_CDS_LANGU"
],
"ASSOCIATED":
[
"I_CENTRALPURCHASECONTRACT",
"I_CNTRLPURCHASECONTRACTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More