What is A_PurReqnAcctAssgmt in SAP S/4HANA?

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

Which tables does A_PurReqnAcctAssgmt read from?

A_PurReqnAcctAssgmt reads data from: I_PurReqnAcctAssgmt.

What VDM layer is A_PurReqnAcctAssgmt?

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

A_PurReqnAcctAssgmt

DDL: A_PURREQNACCTASSGMT SQL: APURREQACC Type: view COMPOSITE

58 Fields 1 Data Sources 3 Associations

Account Assignment

A_PurReqnAcctAssgmt is a Composite CDS View that provides data about "Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurReqnAcctAssgmt) and exposes 58 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchaseReqnAcctAssgmtNumber. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PurReqnAcctAssgmt	I_PurReqnAcctAssgmt	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	A_PurchaseRequisitionItem	_PurchaseReqnItem	`$projection.PurchaseRequisition = _PurchaseReqnItem.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseReqnItem.PurchaseRequisitionItem`
[1..1]	A_PurchaseRequisitionHeader	_PurchaseReqn	`_PurchaseReqn.PurchaseRequisition = $projection.PurchaseRequisition ----Extension`
[0..1]	E_Purreqnacctassgmt	_PurReqnAcctAssgmtExtension	`$projection.PurchaseRequisition = _PurReqnAcctAssgmtExtension.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurReqnAcctAssgmtExtension.PurchaseRequisitionItem and $projection.PurchaseReqnAcctAssgmtNumber = _PurReqnAcctAssgmtExtension.PurchaseReqnAcctAssgmtNumber`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	APURREQACC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Account Assignment	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	false	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (58)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseRequisition	I_PurReqnAcctAssgmt	PurchaseRequisition	Requisition
KEY	PurchaseRequisitionItem	I_PurReqnAcctAssgmt	PurchaseRequisitionItem	Requisn. item
KEY	PurchaseReqnAcctAssgmtNumber	I_PurReqnAcctAssgmt	PurchaseReqnAcctAssgmtNumber
	CostCenter	I_PurReqnAcctAssgmt	CostCenter	Cost Center
	MasterFixedAsset	I_PurReqnAcctAssgmt	MasterFixedAsset	Fixed Asset
	ProjectNetwork	I_PurReqnAcctAssgmt	ProjectNetwork	Order
	BaseUnit	_PurchaseReqnItem	BaseUnit	Unit of Measure
	Quantity	I_PurReqnAcctAssgmt	Quantity	Value
	MultipleAcctAssgmtDistrPercent	I_PurReqnAcctAssgmt	MultipleAcctAssgmtDistrPercent	Distribution
	PurReqnItemCurrency	_PurchaseReqnItem	PurReqnItemCurrency	Currency
	PurReqnNetAmount	I_PurReqnAcctAssgmt	PurReqnNetAmount	Net Value
	IsDeleted	I_PurReqnAcctAssgmt	IsDeleted	TRUE
	CostElement	I_PurReqnAcctAssgmt	CostElement	G/L Account
	GLAccount	I_PurReqnAcctAssgmt	GLAccount	General Ledger
	BusinessArea	I_PurReqnAcctAssgmt	BusinessArea	Business Area
	SDDocument	I_PurReqnAcctAssgmt	SDDocument	SD Document
	SalesOrder	I_PurReqnAcctAssgmt	SalesOrder	SD Document
	SalesDocumentItem	I_PurReqnAcctAssgmt	SalesDocumentItem	Sales Document Item
	SalesOrderItem	I_PurReqnAcctAssgmt	SalesOrderItem	Sales Order Item
	ScheduleLine	I_PurReqnAcctAssgmt	ScheduleLine	Schedule Line
	SalesOrderScheduleLine	I_PurReqnAcctAssgmt	SalesOrderScheduleLine	SOrder schedule
	FixedAsset	I_PurReqnAcctAssgmt	FixedAsset	Sub-number
	ProcessOrder	I_PurReqnAcctAssgmt	ProcessOrder	Order
	OrderID	I_PurReqnAcctAssgmt	OrderID	Order ID
	UnloadingPointName	I_PurReqnAcctAssgmt	UnloadingPointName	Unloading Point Name
	ControllingArea	I_PurReqnAcctAssgmt	ControllingArea	Controlling Area
	CostObject	I_PurReqnAcctAssgmt	CostObject	Cost Object
	ProfitabilitySegment	I_PurReqnAcctAssgmt	ProfitabilitySegment	Profitability Segment
	ProfitCenter	I_PurReqnAcctAssgmt	ProfitCenter	Profit Center
	ProjectNetworkInternalID	I_PurReqnAcctAssgmt	ProjectNetworkInternalID	Plan No.f.Oper.
	CommitmentItem
	FundsCenter	I_PurReqnAcctAssgmt	FundsCenter	Funds Center
	Fund	I_PurReqnAcctAssgmt	Fund	Sender Fund
	FunctionalArea	I_PurReqnAcctAssgmt	FunctionalArea	Sendr Fctl Area
	CreationDate	I_PurReqnAcctAssgmt	CreationDate	Time Stamp
	GoodsRecipientName	I_PurReqnAcctAssgmt	GoodsRecipientName	Recipient Name
	RealEstateObject
	NetworkActivityInternalID	I_PurReqnAcctAssgmt	NetworkActivityInternalID	Counter
	PartnerAccountNumber	I_PurReqnAcctAssgmt	PartnerAccountNumber	Partner
	JointVentureRecoveryCode	I_PurReqnAcctAssgmt	JointVentureRecoveryCode	Recovery Ind.
	SettlementReferenceDate	I_PurReqnAcctAssgmt	SettlementReferenceDate	Reference date
	OrderInternalID	I_PurReqnAcctAssgmt	OrderInternalID	Plan No.f.Oper.
	OrderIntBillOfOperationsItem	I_PurReqnAcctAssgmt	OrderIntBillOfOperationsItem	Order Internal Bill of Operations Item
	EarmarkedFundsDocument	I_PurReqnAcctAssgmt	EarmarkedFundsDocument	Earmarked Funds
	EarmarkedFundsDocumentItem	I_PurReqnAcctAssgmt	EarmarkedFundsDocumentItem	Document Item
	CostCtrActivityType	I_PurReqnAcctAssgmt	CostCtrActivityType	Activity Type
	BusinessProcess	I_PurReqnAcctAssgmt	BusinessProcess	Business Process
	GrantID	I_PurReqnAcctAssgmt	GrantID	Sender Grant
	ValidityDate	I_PurReqnAcctAssgmt	ValidityDate	Valid On
	ChartOfAccounts	I_PurReqnAcctAssgmt	ChartOfAccounts	Node Class
	WBSElement	I_WBSElementByInternalKey	WBSElement	WBS Internal ID
	NetworkActivity	I_PurReqnAcctAssgmt	NetworkActivity	Operation/Activity
	PurchaseRequisitionType	_PurchaseReqnItem	PurchaseRequisitionType	Order Type
	Plant	_PurchaseReqnItem	Plant	Valuation Area
	PurchasingOrganization	_PurchaseReqnItem	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	_PurchaseReqnItem	PurchasingGroup	Purchasing Group
	_PurchaseReqnItem		_PurchaseReqnItem
	_PurchaseReqn		_PurchaseReqn

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_PurReqnAcctAssgmt.
-- 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: APURREQACC

CREATE VIEW A_PurReqnAcctAssgmt AS
SELECT
  I_PurReqnAcctAssgmt.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber AS PurchaseReqnAcctAssgmtNumber,
  I_PurReqnAcctAssgmt.CostCenter AS CostCenter,
  I_PurReqnAcctAssgmt.MasterFixedAsset AS MasterFixedAsset,
  I_PurReqnAcctAssgmt.ProjectNetwork AS ProjectNetwork,
  _PurchaseReqnItem.BaseUnit AS BaseUnit,
  I_PurReqnAcctAssgmt.Quantity AS Quantity,
  I_PurReqnAcctAssgmt.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  _PurchaseReqnItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_PurReqnAcctAssgmt.PurReqnNetAmount AS PurReqnNetAmount,
  I_PurReqnAcctAssgmt.IsDeleted AS IsDeleted,
  I_PurReqnAcctAssgmt.CostElement AS CostElement,
  I_PurReqnAcctAssgmt.GLAccount AS GLAccount,
  I_PurReqnAcctAssgmt.BusinessArea AS BusinessArea,
  I_PurReqnAcctAssgmt.SDDocument AS SDDocument,
  I_PurReqnAcctAssgmt.SalesOrder AS SalesOrder,
  I_PurReqnAcctAssgmt.SalesDocumentItem AS SalesDocumentItem,
  I_PurReqnAcctAssgmt.SalesOrderItem AS SalesOrderItem,
  I_PurReqnAcctAssgmt.ScheduleLine AS ScheduleLine,
  I_PurReqnAcctAssgmt.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  I_PurReqnAcctAssgmt.FixedAsset AS FixedAsset,
  I_PurReqnAcctAssgmt.ProcessOrder AS ProcessOrder,
  I_PurReqnAcctAssgmt.OrderID AS OrderID,
  I_PurReqnAcctAssgmt.UnloadingPointName AS UnloadingPointName,
  I_PurReqnAcctAssgmt.ControllingArea AS ControllingArea,
  I_PurReqnAcctAssgmt.CostObject AS CostObject,
  I_PurReqnAcctAssgmt.ProfitabilitySegment AS ProfitabilitySegment,
  I_PurReqnAcctAssgmt.ProfitCenter AS ProfitCenter,
  I_PurReqnAcctAssgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  cast(I_PurReqnAcctAssgmt.CommitmentItemShortID as fipos) AS CommitmentItem,
  I_PurReqnAcctAssgmt.FundsCenter AS FundsCenter,
  I_PurReqnAcctAssgmt.Fund AS Fund,
  I_PurReqnAcctAssgmt.FunctionalArea AS FunctionalArea,
  I_PurReqnAcctAssgmt.CreationDate AS CreationDate,
  I_PurReqnAcctAssgmt.GoodsRecipientName AS GoodsRecipientName,
  cast( I_PurReqnAcctAssgmt.REInternalFinNumber as imkey preserving type ) AS RealEstateObject,
  I_PurReqnAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurReqnAcctAssgmt.PartnerAccountNumber AS PartnerAccountNumber,
  I_PurReqnAcctAssgmt.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_PurReqnAcctAssgmt.SettlementReferenceDate AS SettlementReferenceDate,
  I_PurReqnAcctAssgmt.OrderInternalID AS OrderInternalID,
  I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_PurReqnAcctAssgmt.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_PurReqnAcctAssgmt.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  I_PurReqnAcctAssgmt.CostCtrActivityType AS CostCtrActivityType,
  I_PurReqnAcctAssgmt.BusinessProcess AS BusinessProcess,
  I_PurReqnAcctAssgmt.GrantID AS GrantID,
  I_PurReqnAcctAssgmt.ValidityDate AS ValidityDate,
  I_PurReqnAcctAssgmt.ChartOfAccounts AS ChartOfAccounts,
  I_WBSElementByInternalKey.WBSElement AS WBSElement,
  I_PurReqnAcctAssgmt.NetworkActivity AS NetworkActivity,
  _PurchaseReqnItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  _PurchaseReqnItem.Plant AS Plant,
  _PurchaseReqnItem.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseReqnItem.PurchasingGroup AS PurchasingGroup
FROM I_PurReqnAcctAssgmt
LEFT OUTER JOIN A_PurchaseRequisitionItem AS _PurchaseReqnItem ON PurchaseRequisition = _PurchaseReqnItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseReqnItem.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN A_PurchaseRequisitionHeader AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN E_Purreqnacctassgmt AS _PurReqnAcctAssgmtExtension ON PurchaseRequisition = _PurReqnAcctAssgmtExtension.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAcctAssgmtExtension.PurchaseRequisitionItem AND PurchaseReqnAcctAssgmtNumber = _PurReqnAcctAssgmtExtension.PurchaseReqnAcctAssgmtNumber  -- association [0..1]
;

Depth:

A_PurReqnAcctAssgmt view

I_PurReqnAcctAssgmt view