I_ChgImpactPurDocAcctAssign

DDL: I_CHGIMPACTPURDOCACCTASSIGN SQL: ICHGIMPPUOACCT Type: view BASIC

Purchase Order acccount assignment details

I_ChgImpactPurDocAcctAssign is a Basic CDS View that provides data about "Purchase Order acccount assignment details" in SAP S/4HANA. It reads from 2 data sources (ekkn, ekpo) and exposes 13 fields. It has 1 association to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
ekkn pur_acct from
ekpo pur_item inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_WBSElement _WBSElementText $projection.WBSElementInternalID = _WBSElementText.WBSElementInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHGIMPPUOACCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Purchase Order acccount assignment details view

Fields (13)

KeyFieldSource TableSource FieldDescription
PurchasingDocument ekkn ebeln
PurchasingDocumentItem ekkn ebelp
ConditionSequentialNumberShort ekkn zekkn
SalesDocument ekkn vbeln
SalesDocumentItem ekkn vbelp
ScheduleLine ekkn veten
ProductionOrder ekkn aufnr
WBSElementInternalID ekkn ps_psp_pnr
ItemCounter ekkn aplzl
ProjectNetworkInternalID ekkn aufpl
Material ekpo matnr
WBSElement _WBSElementText WBSElement
_WBSElementText _WBSElementText 
@AbapCatalog.sqlViewName: 'ICHGIMPPUOACCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory:#L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Purchase Order acccount assignment details'
define view I_ChgImpactPurDocAcctAssign
  as select from ekkn as pur_acct
    inner join   ekpo as pur_item on  pur_acct.ebeln = pur_item.ebeln
                                  and pur_acct.ebelp = pur_item.ebelp
  association [1..*] to I_WBSElement as _WBSElementText on $projection.WBSElementInternalID = _WBSElementText.WBSElementInternalID
{
  pur_acct.ebeln      as PurchasingDocument,
  pur_acct.ebelp      as PurchasingDocumentItem,
  pur_acct.zekkn      as ConditionSequentialNumberShort,
  pur_acct.vbeln      as SalesDocument,
  pur_acct.vbelp      as SalesDocumentItem,
  pur_acct.veten      as ScheduleLine,
  pur_acct.aufnr      as ProductionOrder,
  pur_acct.ps_psp_pnr as WBSElementInternalID,
  pur_acct.aplzl      as ItemCounter,
  pur_acct.aufpl      as ProjectNetworkInternalID,
  pur_item.matnr      as Material,
  _WBSElementText.WBSElement,
  _WBSElementText
} where pur_item.bstyp = 'F'

Learn More