What is A_DirectActivityAllocationItem in SAP S/4HANA?

A_DirectActivityAllocationItem is a consumption CDS view in SAP S/4HANA. Direct Activity Allocation Item It contains 120 fields.

Which tables does A_DirectActivityAllocationItem read from?

A_DirectActivityAllocationItem reads data from: R_DrctActivityAllocationItemTP.

What VDM layer is A_DirectActivityAllocationItem?

A_DirectActivityAllocationItem is classified as a Consumption view optimized for specific business scenarios and reporting.

A_DirectActivityAllocationItem

DDL: A_DIRECTACTIVITYALLOCATIONITEM Type: view_entity CONSUMPTION

120 Fields 1 Data Sources 1 OData Services

Direct Activity Allocation Item

A_DirectActivityAllocationItem is a Consumption CDS View that provides data about "Direct Activity Allocation Item" in SAP S/4HANA. It reads from 1 data source (R_DrctActivityAllocationItemTP) and exposes 120 fields with key fields FiscalYear, ReferenceDocument, ControllingArea, ReferenceDocumentItem, LedgerGLLineItem. It is exposed through 1 OData service (API_DIRECTACTIVITYALLOCATION).

Data Sources (1)

Source	Alias	Join Type
R_DrctActivityAllocationItemTP	R_DrctActivityAllocationItemTP	projection

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Direct Activity Allocation Item	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
OData.entityType.name	DirectActivityAllocationItem_Type	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

OData Services (1)

Service	Binding	Version	Contract	Release
API_DIRECTACTIVITYALLOCATION	API_DRCTACTIVITYALLOCATION	V4	C2	C1

Fields (120)

Key	Field	Source Table	Source Field	Description
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	ReferenceDocument		ReferenceDocument	Reference Document
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	ReferenceDocumentItem		ReferenceDocumentItem	Reference item
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
KEY	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
KEY	ReferenceDocumentContext		ReferenceDocumentContext	Reference Document Context
KEY	AccountingDocument		AccountingDocument	Journal Entry
	TransactionSubitem		TransactionSubitem	Sub Transaction
	SourceLedger		SourceLedger	Source Ledger
	ServicesRenderedDate		ServicesRenderedDate	Services Rendered Date
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCodeText	CompanyCodeName	Company Name
	SenderCompanyCode		SenderCompanyCode	Sender Company Code
	SourceCompanyCodeName	_SenderCompanyCodeText	CompanyCodeName	Sender Company Code Name
	AccountAssignment		AccountAssignment	Sender Acct Assgmt
	AccountAssignmentType		AccountAssignmentType	Sndr AcctAssgmt Type
	AccountAssignmentTypeDesc	_AccountAssignmentTypeT	AccountAssignmentTypeDesc	Account Assignment Type Text
	PartnerAccountAssignment		PartnerAccountAssignment	Partner Account Assignment
	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
	PartAccountAssignmentTypeDesc	_PartnerAccountAssignmentTypeT	AccountAssignmentTypeDesc	Receiver Account Assignment Type Text
	GLAccount		GLAccount	General Ledger
	GLAccountName			Account for Allocation Name
	ChartOfAccounts		ChartOfAccounts	Node Class
	SenderCostCenter		SenderCostCenter	Sender Cost Center
	SenderCostCenterName	_CostCenterText	CostCenterName	Sender Cost Center Name
	CostCtrActivityType		CostCtrActivityType	Sender Activity Type
	CostCtrActivityTypeName	_CostCtrActivityTypeTxt	CostCtrActivityTypeName	Sender Activity Type Name
	Fund		Fund	Sender Fund
	FundName			Sender Fund Name
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	FunctionalAreaName			Sender Functional Area Name
	GrantID		GrantID	Sender Grant
	GrantName			Sender Grant Name
	BudgetPeriod		BudgetPeriod	Sender Budget Period
	BudgetPeriodName			Sender Budget Period Name
	SenderCostRecoveryCode		SenderCostRecoveryCode	Sender Recovery Indicator
	PartnerCostCenter		PartnerCostCenter	Receiver Cost Center
	PartnerCostCenterName	_PartnerCostCenterText	CostCenterName	Receiver Cost Center Name
	DocumentItemText		DocumentItemText	Text
	BaseUnit		BaseUnit	Unit of Measure
	UnitOfMeasureLongName
	Quantity		Quantity	Quantity
	TransactionCurrency		TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	PrcTotAmtInTransactionCurrency		PrcTotAmtInTransactionCurrency	Total Cost Rate in Trans. Crcy
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	PrcTotAmtInCompanyCodeCurrency		PrcTotAmtInCompanyCodeCurrency	Total Cost Rate in CC Crcy
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
	PrcTotAmtInGlobalCurrency		PrcTotAmtInGlobalCurrency	Total Cost Rate in Global Crcy
	PartnerWBSElementExternalID		PartnerWBSElementExternalID	Receiver WBS Element
	WBSDescription	_PartnerWBSElementText	WBSDescription	Receiver WBS Element Name
	PartnerProjectExternalID		PartnerProjectExternalID	Receiver Project
	PartnerServiceDocumentType		PartnerServiceDocumentType	Receiver Service Doc. Type
	PartnerServiceDocument		PartnerServiceDocument	Receiver Service Document
	PartnerServiceDocumentItem		PartnerServiceDocumentItem	Receiver Service Doc. Item
	PartnerProjectNetwork		PartnerProjectNetwork	Receiver Project Network
	PartnerOrder		PartnerOrder	Receiver Order
	PartnerProjectNetworkActivity		PartnerProjectNetworkActivity	Receiver Project Network Activity
	PartnerCostCtrActivityType		PartnerCostCtrActivityType	Receiver Activity Type
	PartnerCostCtrActivityTypeName	_PartnerCostCtrActivityTypeTxt	CostCtrActivityTypeName	Receiver Activity Type Name
	PartnerCostObject		PartnerCostObject	Receiver Cost Object
	PartnerSalesDocument		PartnerSalesDocument	Receiver Sales Document
	PartnerSalesDocumentItem		PartnerSalesDocumentItem	Receiver Sales Doc. Item
	WorkItem		WorkItem	Work Item ID
	PersonnelNumber		PersonnelNumber	Personnel No.
	Plant		Plant	Valuation Area
	Product		Product	Product Sold
	ReceiverProcurementProcess		ReceiverProcurementProcess	Prod. Proc. No.
	PartnerBusinessProcess		PartnerBusinessProcess	Receiver Business Process
	PartnerFund		PartnerFund	Receiver Fund
	ReceiverPostedFundName			Receiver Fund Name
	PartnerFunctionalArea		PartnerFunctionalArea	Rec. Fntcl Area
	PartnerFunctionalAreaName			Receiver Functional Area Name
	PartnerGrant		PartnerGrant	Receiver Grant
	ReceiverPostedGrantName			Receiver Grant Name
	PartnerBudgetPeriod		PartnerBudgetPeriod	Receiver Budget Period
	ReceiverPostedBudgetPeriodName			Receiver Budget Period Name
	IsSettled		IsSettled	Is Reposted
	BillableControl		BillableControl	Receiver Accounting Indicator
	BillableControlName
	PartnerCostRecoveryCode		PartnerCostRecoveryCode	Receiver Recovery Indicator
	ControllingDocumentItem		ControllingDocumentItem	Controlling Doc Item
	OperatingConcern		OperatingConcern	Operating concern
	PartnerProfitabilitySegment		PartnerProfitabilitySegment	Profit. segment
	PartProfitabilitySgmtIsAssgd		PartProfitabilitySgmtIsAssgd	Profitability Segment Is Assigned
	SuccessorReferenceDocument	_SuccessorReferenceItem	SuccessorReferenceDocument	Reposting Reference Document
	OrderOperation		OrderOperation	Receiver Order Operation
	ReceiverRECompanyCode		ReceiverRECompanyCode	Receiver Real Estate Company Code
	REPartnerBusinessEntity		REPartnerBusinessEntity	Receiver Real Estate Business Entity
	RealEstatePartnerBuilding		RealEstatePartnerBuilding	Receiver Real Estate Building
	RealEstatePartnerProperty		RealEstatePartnerProperty	Receiver Real Estate Property
	REPartnerRentalObject		REPartnerRentalObject	Receiver Real Estate Rental Object
	RealEstatePartnerContract		RealEstatePartnerContract	Receiver Real Estate Contract
	REPartnerServiceChargeKey		REPartnerServiceChargeKey	Receiver Real Estate Service Charge Key
	REPartnerSettlementUnitID		REPartnerSettlementUnitID	Receiver Real Estate Settlement Unit
	PartnerSettlementReferenceDate		PartnerSettlementReferenceDate	Receiver Real Estate Settlement Reference Date
	PartnerProfitCenter		PartnerProfitCenter	Profit Center
	ProfitCenter		ProfitCenter	Profit Center
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1		AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2		AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3		AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4		AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5		AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6		AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7		AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8		AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	FunctionalCurrency		FunctionalCurrency	Functional Currency
	AmountInFunctionalCurrency		AmountInFunctionalCurrency	Amount in Functional Currency
	ControllingBusTransacType		ControllingBusTransacType	CO Bus. Transaction

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_DirectActivityAllocationItem.
-- 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.

CREATE VIEW A_DirectActivityAllocationItem AS
SELECT
  FiscalYear,
  ReferenceDocument,
  ControllingArea,
  ReferenceDocumentItem,
  LedgerGLLineItem,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  AccountingDocument,
  TransactionSubitem,
  SourceLedger,
  ServicesRenderedDate,
  CompanyCode,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  SenderCompanyCode,
  _SenderCompanyCodeText.CompanyCodeName AS SourceCompanyCodeName,
  AccountAssignment,
  AccountAssignmentType,
  _AccountAssignmentTypeT.AccountAssignmentTypeDesc AS AccountAssignmentTypeDesc,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  _PartnerAccountAssignmentTypeT.AccountAssignmentTypeDesc AS PartAccountAssignmentTypeDesc,
  GLAccount,
  _GLAccountText[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  ChartOfAccounts,
  SenderCostCenter,
  _CostCenterText.CostCenterName AS SenderCostCenterName,
  CostCtrActivityType,
  _CostCtrActivityTypeTxt.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  Fund,
  _FundText[1:Language = $session.system_language].FundName AS FundName,
  FunctionalArea,
  _FunctionalAreaText[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  GrantID,
  _GrantText[1:Language = $session.system_language].GrantName AS GrantName,
  BudgetPeriod,
  _BudgetPeriodText[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  SenderCostRecoveryCode,
  PartnerCostCenter,
  _PartnerCostCenterText.CostCenterName AS PartnerCostCenterName,
  DocumentItemText,
  BaseUnit,
  _UnitOfMeasureText[1:Language = $session.system_language].UnitOfMeasureLongName AS UnitOfMeasureLongName,
  Quantity,
  TransactionCurrency,
  AmountInTransactionCurrency,
  PrcTotAmtInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  PrcTotAmtInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  PrcTotAmtInGlobalCurrency,
  PartnerWBSElementExternalID,
  _PartnerWBSElementText.WBSDescription AS WBSDescription,
  PartnerProjectExternalID,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  PartnerProjectNetwork,
  PartnerOrder,
  PartnerProjectNetworkActivity,
  PartnerCostCtrActivityType,
  _PartnerCostCtrActivityTypeTxt.CostCtrActivityTypeName AS PartnerCostCtrActivityTypeName,
  PartnerCostObject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  WorkItem,
  PersonnelNumber,
  Plant,
  Product,
  ReceiverProcurementProcess,
  PartnerBusinessProcess,
  PartnerFund,
  _PartnerFundText[1:Language = $session.system_language].FundName AS ReceiverPostedFundName,
  PartnerFunctionalArea,
  _PartnerFunctionalAreaText[1:Language = $session.system_language].FunctionalAreaName AS PartnerFunctionalAreaName,
  PartnerGrant,
  _PartnerGrantText[1:Language = $session.system_language].GrantName AS ReceiverPostedGrantName,
  PartnerBudgetPeriod,
  _PartnerBudgetPeriodText[1:Language = $session.system_language].BudgetPeriodName AS ReceiverPostedBudgetPeriodName,
  IsSettled,
  BillableControl,
  _BillableControlText[1:Language = $session.system_language].BillableControlName AS BillableControlName,
  PartnerCostRecoveryCode,
  ControllingDocumentItem,
  OperatingConcern,
  PartnerProfitabilitySegment,
  PartProfitabilitySgmtIsAssgd,
  _SuccessorReferenceItem.SuccessorReferenceDocument AS SuccessorReferenceDocument,
  OrderOperation,
  ReceiverRECompanyCode,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  PartnerProfitCenter,
  ProfitCenter,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  ControllingBusTransacType
FROM R_DrctActivityAllocationItemTP
;

Depth:

A_DirectActivityAllocationItem view_entity

R_DrctActivityAllocationItemTP view_entity