Which tables does C_PurgDocAccountAssignmentObj use?

C_PurgDocAccountAssignmentObj reads from 1 data source(s): I_PurgDocAccountAssignment.

How many fields does C_PurgDocAccountAssignmentObj have?

C_PurgDocAccountAssignmentObj has 17 fields. Key fields: PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber.

C_PurgDocAccountAssignmentObj

DDL: C_PURGDOCACCOUNTASSIGNMENTOBJ SQL: CPURGACCASSOBJ Type: view CONSUMPTION Package: ODATA_MM_PUR_POITEMS_MONI

Purchasing Document Account Assignments For Object Page

C_PurgDocAccountAssignmentObj is a Consumption CDS View that provides data about "Purchasing Document Account Assignments For Object Page" in SAP S/4HANA. It reads from 1 data source (I_PurgDocAccountAssignment) and exposes 17 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber. It has 3 associations to related views. Part of development package ODATA_MM_PUR_POITEMS_MONI.

Data Sources (1)

Source	Alias	Join Type
I_PurgDocAccountAssignment	I_PurgDocAccountAssignment	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_PurchasingDocumentItem	_PurchasingDocumentItem	`I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and I_PurgDocAccountAssignment.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem`
[0..1]	I_CostCenterText	_CostCenterText	`I_PurgDocAccountAssignment.CostCenter = _CostCenterText.CostCenter and I_PurgDocAccountAssignment.ControllingArea = _CostCenterText.ControllingArea and _CostCenterText.Language = $session.system_language association[0..1] to I_PurchaseOrder as _PurchaseOrder on I_PurgDocAccountAssignment.PurchasingDocument = _PurchaseOrder.PurchaseOrder`
[0..1]	I_WBSElement	_WBSelement	`I_PurgDocAccountAssignment.WBSElementInternalID = _WBSelement.WBSElementInternalID`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CPURGACCASSOBJ	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Purchasing Document Account Assignments For Object Page	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor		view

Fields (17)

Key	Field	Source Table	Source Field	Description
KEY	PurchasingDocument	I_PurgDocAccountAssignment	PurchasingDocument
KEY	PurchasingDocumentItem	I_PurgDocAccountAssignment	PurchasingDocumentItem
KEY	AccountAssignmentNumber	I_PurgDocAccountAssignment	AccountAssignmentNumber	Serial Number
	CostCenterName	_CostCenterText	CostCenterName
	CostCenter	I_PurgDocAccountAssignment	CostCenter
	WBSElement	_WBSelement	WBSElement
	Plant	_PurchasingDocumentItem	Plant
	FixedAsset	I_PurgDocAccountAssignment	MasterFixedAsset
	OrderID	I_PurgDocAccountAssignment	OrderID
	GLAccount	I_PurgDocAccountAssignment	GLAccount
	MultipleAcctAssgmtDistrPercent	I_PurgDocAccountAssignment	MultipleAcctAssgmtDistrPercent	Distribution
	OrderQuantityUnit	_PurchasingDocumentItem	OrderQuantityUnit
	Quantity	I_PurgDocAccountAssignment	Quantity
	DocumentCurrency	_PurchasingDocumentItem	DocumentCurrency
	PurgDocNetAmount	I_PurgDocAccountAssignment	PurgDocNetAmount	Value
	_PurchasingDocumentItem		_PurchasingDocumentItem
	_PurchaseOrder		_PurchaseOrder

@AbapCatalog.sqlViewName: 'CPURGACCASSOBJ'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.semanticKey:  [ 'CostCenter','WBSElement','FixedAsset','GLAccount']
@EndUserText.label: 'Purchasing Document Account Assignments For Object Page'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: ''
//this view was used for local object page in monitor PO and PO by AA, deprecated as local object page is not there anymore

define view C_PurgDocAccountAssignmentObj
  as select from I_PurgDocAccountAssignment
  association [0..1] to I_PurchasingDocumentItem as _PurchasingDocumentItem on  I_PurgDocAccountAssignment.PurchasingDocument     = _PurchasingDocumentItem.PurchasingDocument
                                                                            and I_PurgDocAccountAssignment.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
  association [0..1] to I_CostCenterText         as _CostCenterText         on  I_PurgDocAccountAssignment.CostCenter      = _CostCenterText.CostCenter
                                                                            and I_PurgDocAccountAssignment.ControllingArea = _CostCenterText.ControllingArea
  //and I_PurgDocAccountAssignment.ValidityDate <= _CostCenterText.ValidityEndDate

                                                                            and _CostCenterText.Language                   = $session.system_language
association[0..1] to I_PurchaseOrder as _PurchaseOrder  on I_PurgDocAccountAssignment.PurchasingDocument = _PurchaseOrder.PurchaseOrder

  association [0..1] to I_WBSElement             as _WBSelement             on  I_PurgDocAccountAssignment.WBSElementInternalID = _WBSelement.WBSElementInternalID

{
      @UI.hidden: true
  key I_PurgDocAccountAssignment.PurchasingDocument,

      @UI.hidden: true
  key I_PurgDocAccountAssignment.PurchasingDocumentItem,

      @UI.lineItem: [{position:10,importance: #HIGH}]
      @EndUserText.label:'Serial Number'
  key I_PurgDocAccountAssignment.AccountAssignmentNumber,

      _CostCenterText.CostCenterName,

      @UI.lineItem: [{position:20,importance: #HIGH}]
      @ObjectModel.text.element:  [ 'CostCenterName' ]
      @Consumption.semanticObject: 'CostCenter'
      I_PurgDocAccountAssignment.CostCenter,

      @UI.lineItem: [{position:30,importance: #HIGH}]
      @Consumption.semanticObject: 'WBSElement'
      _WBSelement.WBSElement,
      
      
      @UI.hidden: true
      _PurchasingDocumentItem.Plant as Plant,

      @UI.lineItem: [{position:40,importance: #HIGH}]
      @Consumption.semanticObject: 'FixedAsset'
      I_PurgDocAccountAssignment.MasterFixedAsset as FixedAsset,

      @UI.lineItem: [{position:50,importance: #HIGH}]
 //     @Consumption.semanticObject: 'Order'

      I_PurgDocAccountAssignment.OrderID ,

      @UI.lineItem: [{position:60,importance: #HIGH}]
      @Consumption.semanticObject: 'GLAccount'
      I_PurgDocAccountAssignment.GLAccount,

      @UI.lineItem: [{position:70,importance: #HIGH}]
      @EndUserText.label:'Distribution'
      I_PurgDocAccountAssignment.MultipleAcctAssgmtDistrPercent,

      @Semantics.unitOfMeasure: true
      _PurchasingDocumentItem.OrderQuantityUnit,

      @UI.lineItem: [{position:80,importance: #HIGH}]
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'

      /*case _PurchasingDocumentItem.IsReturnsItem
      when 'X' then (I_PurgDocAccountAssignment.Quantity)*(-1)
      else I_PurgDocAccountAssignment.Quantity
      end as Quantity,*/
      I_PurgDocAccountAssignment.Quantity,

      @Semantics.currencyCode: true
      _PurchasingDocumentItem.DocumentCurrency,

      @UI.lineItem: [{position:90,importance: #HIGH}]
      @EndUserText.label:'Value'
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      I_PurgDocAccountAssignment.PurgDocNetAmount,

      _PurchasingDocumentItem,
      _PurchaseOrder
}

Depth:

C_PurgDocAccountAssignmentObj view

I_PurgDocAccountAssignment view