P_ChangeHeader

DDL: P_CHANGEHEADER SQL: PCHGHDR Type: view BASIC Package: VEP_HFE_MODEL

Planning Scope Linked Object Changes

P_ChangeHeader is a Basic CDS View that provides data about "Planning Scope Linked Object Changes" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocument) and exposes 8 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument. Part of development package VEP_HFE_MODEL.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocument ChangeDocItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCHGHDR view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocument ChangeDocObject
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass
KEY ChangeDocument I_ChangeDocument ChangeDocument
BillOfMaterialCategory
BillOfMaterial
BillOfMaterialVariant
ChangeNumber
ValidityStartDate 
@AbapCatalog.sqlViewName: 'PCHGHDR'
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #MASTER}
-- VDM Annotations
@VDM.viewType: #BASIC
@VDM.private: true
define view P_ChangeHeader
  as select from I_ChangeDocument as ChangeDocItem
{
  key ChangeDocItem.ChangeDocObject                     as ChangeDocObject,
  key ChangeDocItem.ChangeDocObjectClass                as ChangeDocObjectClass,
  key ChangeDocItem.ChangeDocument                      as ChangeDocument,
      SUBSTRING(ChangeDocObject, 4, 1)                  as BillOfMaterialCategory,
      SUBSTRING(ChangeDocObject, 5, 8)                  as BillOfMaterial,
      SUBSTRING(ChangeDocObject, 23, 2)                 as BillOfMaterialVariant,
      SUBSTRING(ChangeDocObject, 25, 12)                as ChangeNumber,
      cast(SUBSTRING(ChangeDocObject, 37, 8) as datum)  as ValidityStartDate
}

Learn More