P_PurOrdItmAccountAssignment

DDL: P_PURORDITMACCOUNTASSIGNMENT SQL: PPOITMACCTASSGMT Type: view CONSUMPTION Package: ODATA_MM_PUR_MYPURGDOCITEMS

PO Item Account Assignment

P_PurOrdItmAccountAssignment is a Consumption CDS View that provides data about "PO Item Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurgDocAccountAssignment) and exposes 14 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber. It has 1 association to related views. Part of development package ODATA_MM_PUR_MYPURGDOCITEMS.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_PurgDocAccountAssignment I_PurgDocAccountAssignment from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPOITMACCTASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label PO Item Account Assignment view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument
KEY PurchaseOrderItem PurchasingDocumentItem
KEY AccountAssignmentNumber AccountAssignmentNumber
CostCenter CostCenter
CostCenterName
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
Quantity Quantity
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent
PurgDocNetAmount PurgDocNetAmount
WBSElementInternalID WBSElementInternalID
WBSElementInternalID_2
WBSElementExternalID _WBSElement WBSElementExternalID
WBSElementObject _WBSElement WBSElementObject 
@AbapCatalog.sqlViewName: 'PPOITMACCTASSGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'PO Item Account Assignment'

define view P_PurOrdItmAccountAssignment
  as select from I_PurgDocAccountAssignment //I_PurOrdAccountAssignment


  association [0..1] to I_WBSElementBasicData as _WBSElement on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
{

  key PurchasingDocument                            as PurchaseOrder,
  key PurchasingDocumentItem                        as PurchaseOrderItem,
  key AccountAssignmentNumber,
      CostCenter,
      _CostCenter._Text[1: Language = $session.system_language].CostCenterName as CostCenterName,
      SalesOrder,
      SalesOrderItem,
      Quantity,
      MultipleAcctAssgmtDistrPercent,
      PurgDocNetAmount,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'WBSElementInternalID_2'
      WBSElementInternalID,
      cast( WBSElementInternalID as ps_s4_pspnr ) as WBSElementInternalID_2,
      _WBSElement.WBSElementExternalID                                           as WBSElementExternalID,
      _WBSElement.WBSElementObject
}

Learn More