I_PurctritnotesWD

DDL: I_PURCTRITNOTESWD SQL: IPURCTRITNOTESWD Type: view TRANSACTIONAL Package: VDM_MM_PUR_CON

Purchase Contract Item Notes with Draft

I_PurctritnotesWD is a Transactional CDS View that provides data about "Purchase Contract Item Notes with Draft" in SAP S/4HANA. It reads from 1 data source (I_Purctritnotes) and exposes 16 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, PurchaseContractItem. It has 2 associations to related views. Part of development package VDM_MM_PUR_CON.

Data Sources (1)

SourceAliasJoin Type
I_Purctritnotes Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContractItemWD _PurchaseContractItemWD _PurchaseContractItemWD.PurchaseContractItem = $projection.PurchaseContractItem and _PurchaseContractItemWD.PurchaseContract = $projection.PurchaseContract
[1..1] I_PurchaseContractWD _PurchaseContractWD _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPURCTRITNOTESWD view
EndUserText.label Purchase Contract Item Notes with Draft view
ObjectModel.writeDraftPersistence PURCTR_ITM_TXT_D view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ClientDependent true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Language I_Purctritnotes Language
KEY DocumentText I_Purctritnotes DocumentText
KEY TechnicalObjectType I_Purctritnotes TechnicalObjectType
KEY ArchObjectNumber I_Purctritnotes ArchitecturalObjectNumber
KEY PurchaseContractItem I_Purctritnotes PurchaseContractItem
KEY PurchaseContract I_Purctritnotes PurchaseContract
ArchObjectNumberForEdit I_Purctritnotes ArchitecturalObjectNumber
PurchaseContractForEdit I_Purctritnotes PurchaseContract
PurchaseContractItemForEdit I_Purctritnotes PurchaseContractItem
TechnicalObjectTypeForEdit I_Purctritnotes TechnicalObjectType
DocumentTextForEdit I_Purctritnotes DocumentText
LanguageForEdit I_Purctritnotes Language
NoteDescription I_Purctritnotes NoteDescription
FixedIndicator I_Purctritnotes FixedIndicator
_PurchaseContractWD _PurchaseContractWD
_PurchaseContractItemWD _PurchaseContractItemWD
@AbapCatalog.sqlViewName: 'IPURCTRITNOTESWD'
@EndUserText.label: 'Purchase Contract Item Notes with Draft'
//@ObjectModel.compositionRoot: true

//@ObjectModel.transactionalProcessingEnabled: true

//@OData.publish: true

@ObjectModel.writeDraftPersistence: 'PURCTR_ITM_TXT_D'
@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@ClientDependent: true
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
                
define view I_PurctritnotesWD 
  as select from I_Purctritnotes as Document
  association [1..1] to I_PurchaseContractItemWD as _PurchaseContractItemWD on  _PurchaseContractItemWD.PurchaseContractItem = $projection.PurchaseContractItem
                                                                            and _PurchaseContractItemWD.PurchaseContract     = $projection.PurchaseContract

  association [1..1] to I_PurchaseContractWD     as _PurchaseContractWD     on  _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract
{
  key Document.Language,
  key Document.DocumentText,
  key Document.TechnicalObjectType,
  key Document.ArchitecturalObjectNumber as ArchObjectNumber,
  key Document.PurchaseContractItem,
  key Document.PurchaseContract,
      Document.ArchitecturalObjectNumber as ArchObjectNumberForEdit,

      Document.PurchaseContract          as PurchaseContractForEdit,

      Document.PurchaseContractItem      as PurchaseContractItemForEdit,

      Document.TechnicalObjectType       as TechnicalObjectTypeForEdit,
      
      Document.DocumentText              as DocumentTextForEdit,
      
      Document.Language                  as LanguageForEdit,

      Document.NoteDescription,   
      
      Document.FixedIndicator,
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _PurchaseContractWD,

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _PurchaseContractItemWD
}