What is A_PurOrdAccountAssignment in SAP S/4HANA?

A_PurOrdAccountAssignment is a composite CDS view in SAP S/4HANA. Account Assignment It contains 46 fields.

Which tables does A_PurOrdAccountAssignment read from?

A_PurOrdAccountAssignment reads data from: I_PurOrdAccountAssignment.

What VDM layer is A_PurOrdAccountAssignment?

A_PurOrdAccountAssignment is classified as a Composite view that combines data from multiple basic views.

A_PurOrdAccountAssignment

DDL: A_PURORDACCOUNTASSIGNMENT SQL: APURORDACCASSIGN Type: view COMPOSITE

46 Fields 1 Data Sources 2 Associations

Account Assignment

A_PurOrdAccountAssignment is a Composite CDS View that provides data about "Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurOrdAccountAssignment) and exposes 46 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PurOrdAccountAssignment	I_PurOrdAccountAssignment	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	A_PurchaseOrder	_PurchaseOrder	`$projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder`
[0..1]	I_WBSElementBasicData	_WBSElement	`_WBSElement.WBSElementInternalID = I_PurOrdAccountAssignment.WBSElementInternalID`

Annotations (14)

Name	Value	Level
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	APURORDACCASSIGN	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Account Assignment	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
OData.entitySet.name	A_PurOrdAccountAssignment	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseOrder	I_PurOrdAccountAssignment	PurchaseOrder	Purchasing Document
KEY	PurchaseOrderItem	I_PurOrdAccountAssignment	PurchaseOrderItem	Purchasing Document Item
KEY	AccountAssignmentNumber	I_PurOrdAccountAssignment	AccountAssignmentNumber	Account Assgmt No.
	IsDeleted	I_PurOrdAccountAssignment	IsDeleted	TRUE
	PurchaseOrderQuantityUnit	_PurchaseOrderItem	PurchaseOrderQuantityUnit	Order Unit
	Quantity	I_PurOrdAccountAssignment	Quantity	Value
	MultipleAcctAssgmtDistrPercent	I_PurOrdAccountAssignment	MultipleAcctAssgmtDistrPercent	Distribution
	DocumentCurrency	I_PurOrdAccountAssignment	DocumentCurrency	Document Currency
	PurgDocNetAmount	I_PurOrdAccountAssignment	PurgDocNetAmount	Net Value
	GLAccount	I_PurOrdAccountAssignment	GLAccount	General Ledger
	BusinessArea	I_PurOrdAccountAssignment	BusinessArea	Business Area
	CostCenter	I_PurOrdAccountAssignment	CostCenter	Cost Center
	SalesOrder	I_PurOrdAccountAssignment	SalesOrder	SD Document
	SalesOrderItem	I_PurOrdAccountAssignment	SalesOrderItem	Sales Order Item
	SalesOrderScheduleLine	I_PurOrdAccountAssignment	SalesOrderScheduleLine	SOrder schedule
	MasterFixedAsset		MasterFixedAsset	Fixed Asset
	FixedAsset		FixedAsset	Sub-number
	GoodsRecipientName		GoodsRecipientName	Recipient Name
	UnloadingPointName		UnloadingPointName	Unloading Point Name
	ControllingArea	I_PurOrdAccountAssignment	ControllingArea	Controlling Area
	CostObject	I_PurOrdAccountAssignment	CostObject	Cost Object
	OrderID	I_PurOrdAccountAssignment	OrderID	Order ID
	ProfitCenter	I_PurOrdAccountAssignment	ProfitCenter	Profit Center
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	WBSElement	_WBSElement	WBSElement	WBS Internal ID
	WBSElementExternalID	_WBSElement	WBSElementExternalID	WBS Element External ID
	ProjectNetwork	I_PurOrdAccountAssignment	ProjectNetwork	Order
	NetworkActivity	I_PurOrdAccountAssignment	NetworkActivity	Operation/Activity
	RealEstateObject	I_PurOrdAccountAssignment	RealEstateObject	Real Estate Key
	PartnerAccountNumber	I_PurOrdAccountAssignment	PartnerAccountNumber	Partner
	CommitmentItem	I_PurOrdAccountAssignment	CommitmentItem	Commitment item
	JointVentureRecoveryCode	I_PurOrdAccountAssignment	JointVentureRecoveryCode	Recovery Ind.
	FundsCenter	I_PurOrdAccountAssignment	FundsCenter	Funds Center
	Fund	I_PurOrdAccountAssignment	Fund	Sender Fund
	FunctionalArea	I_PurOrdAccountAssignment	FunctionalArea	Sendr Fctl Area
	SettlementReferenceDate	I_PurOrdAccountAssignment	SettlementReferenceDate	Reference date
	TaxCode	I_PurOrdAccountAssignment	TaxCode	Tax Code
	TaxJurisdiction	I_PurOrdAccountAssignment	TaxJurisdiction	Tax Jurisdiction
	CostCtrActivityType		CostCtrActivityType	Activity Type
	BusinessProcess		BusinessProcess	Business Process
	EarmarkedFundsDocument		EarmarkedFundsDocument	Earmarked Funds
	EarmarkedFundsDocumentItem		EarmarkedFundsDocumentItem	Document Item
	GrantID		GrantID	Sender Grant
	BudgetPeriod		BudgetPeriod	Budget Period
	_PurchaseOrder		_PurchaseOrder
	_PurchaseOrderItem		_PurchaseOrderItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_PurOrdAccountAssignment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: APURORDACCASSIGN

CREATE VIEW A_PurOrdAccountAssignment AS
SELECT
  I_PurOrdAccountAssignment.PurchaseOrder AS PurchaseOrder,
  I_PurOrdAccountAssignment.PurchaseOrderItem AS PurchaseOrderItem,
  I_PurOrdAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_PurOrdAccountAssignment.IsDeleted AS IsDeleted,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_PurOrdAccountAssignment.Quantity AS Quantity,
  I_PurOrdAccountAssignment.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  I_PurOrdAccountAssignment.DocumentCurrency AS DocumentCurrency,
  I_PurOrdAccountAssignment.PurgDocNetAmount AS PurgDocNetAmount,
  I_PurOrdAccountAssignment.GLAccount AS GLAccount,
  I_PurOrdAccountAssignment.BusinessArea AS BusinessArea,
  I_PurOrdAccountAssignment.CostCenter AS CostCenter,
  I_PurOrdAccountAssignment.SalesOrder AS SalesOrder,
  I_PurOrdAccountAssignment.SalesOrderItem AS SalesOrderItem,
  I_PurOrdAccountAssignment.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  MasterFixedAsset,
  FixedAsset,
  GoodsRecipientName,
  UnloadingPointName,
  I_PurOrdAccountAssignment.ControllingArea AS ControllingArea,
  I_PurOrdAccountAssignment.CostObject AS CostObject,
  I_PurOrdAccountAssignment.OrderID AS OrderID,
  I_PurOrdAccountAssignment.ProfitCenter AS ProfitCenter,
  WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  I_PurOrdAccountAssignment.ProjectNetwork AS ProjectNetwork,
  I_PurOrdAccountAssignment.NetworkActivity AS NetworkActivity,
  I_PurOrdAccountAssignment.RealEstateObject AS RealEstateObject,
  I_PurOrdAccountAssignment.PartnerAccountNumber AS PartnerAccountNumber,
  I_PurOrdAccountAssignment.CommitmentItem AS CommitmentItem,
  I_PurOrdAccountAssignment.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_PurOrdAccountAssignment.FundsCenter AS FundsCenter,
  I_PurOrdAccountAssignment.Fund AS Fund,
  I_PurOrdAccountAssignment.FunctionalArea AS FunctionalArea,
  I_PurOrdAccountAssignment.SettlementReferenceDate AS SettlementReferenceDate,
  I_PurOrdAccountAssignment.TaxCode AS TaxCode,
  I_PurOrdAccountAssignment.TaxJurisdiction AS TaxJurisdiction,
  CostCtrActivityType,
  BusinessProcess,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  GrantID,
  BudgetPeriod
FROM I_PurOrdAccountAssignment
LEFT OUTER JOIN A_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = I_PurOrdAccountAssignment.WBSElementInternalID  -- association [0..1]
;

Depth:

A_PurOrdAccountAssignment view

I_PurOrdAccountAssignment view