I_PurchasingChangeDocument

DDL: I_PURCHASINGCHANGEDOCUMENT SQL: IPURGCHGDOC Type: view COMPOSITE

Purchasing Change Document

I_PurchasingChangeDocument is a Composite CDS View that provides data about "Purchasing Change Document" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocument) and exposes 11 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocument I_ChangeDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _User $projection.CreatedByUser = _User.ContactCardID

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.sqlViewName IPURGCHGDOC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Purchasing Change Document view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ChangeDocument ChangeDocument
CreatedByUser CreatedByUser
FullName _User FullName
FirstName _User FirstName
LastName _User LastName
CreationDate CreationDate
CreationTime CreationTime
ChangeDocLanguage ChangeDocLanguage
_ChangeDocLanguage _ChangeDocLanguage 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@AbapCatalog.sqlViewName: 'IPURGCHGDOC'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchasing Change Document'

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

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

define view I_PurchasingChangeDocument
  as select from I_ChangeDocument
  association [0..1] to I_UserContactCard as _User on $projection.CreatedByUser = _User.ContactCardID
{

  key ChangeDocObject,

  key ChangeDocObjectClass,

  key ChangeDocument,

      CreatedByUser,

      _User.FullName,

      _User.FirstName,

      _User.LastName,

      CreationDate,

      @ObjectModel.readOnly: true
      CreationTime,

      ChangeDocLanguage,

      _ChangeDocLanguage

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENT",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_CHANGEDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More