P_ChangeDocumentPlanningScope

DDL: P_CHANGEDOCUMENTPLANNINGSCOPE SQL: PCHNGDOC_PLNSCP Type: view BASIC

P_ChangeDocumentPlanningScope is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (stpo, I_ChangeDocumentItem) and exposes 15 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
stpo BOMItem left_outer
I_ChangeDocumentItem ChangeDocItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCHNGDOC_PLNSCP 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 (15)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject
KEY ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType ChangeDocItemChangeType
BillOfMaterialComponent stpo idnrk
BillOfMaterialItemNumber stpo posnr
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue 
@AbapCatalog.sqlViewName: 'PCHNGDOC_PLNSCP'
@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_ChangeDocumentPlanningScope
  as select from I_ChangeDocumentItem as ChangeDocItem left outer join 
    stpo                 as BOMItem    on ChangeDocItem.DatabaseTable     = 'STPO'
                                      and ChangeDocItem.ChangeDocTableKey = concat(
    concat(
      concat(
        concat(
          BOMItem.mandt, BOMItem.stlty
        ), BOMItem.stlnr
      ), BOMItem.stlkn
    ), BOMItem.stpoz
  )
{
  key ChangeDocItem.ChangeDocObject,
  key ChangeDocItem.ChangeDocObjectClass,
  key ChangeDocItem.ChangeDocument,
  key ChangeDocItem.DatabaseTable,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,
      BOMItem.idnrk     as BillOfMaterialComponent,
      BOMItem.posnr     as BillOfMaterialItemNumber,  
      ChangeDocPreviousUnit,
      ChangeDocNewUnit,
      ChangeDocPreviousCurrency,
      ChangeDocNewCurrency,
      ChangeDocNewFieldValue,
      ChangeDocPreviousFieldValue
}

Learn More