What is C_DirectActivityAllocationItem in SAP S/4HANA?

C_DirectActivityAllocationItem is a consumption CDS view in SAP S/4HANA. Item of Manage Direct Activity Allocation It contains 129 fields.

Which tables does C_DirectActivityAllocationItem read from?

C_DirectActivityAllocationItem reads data from: I_DrctActivityAllocationItemTP.

What VDM layer is C_DirectActivityAllocationItem?

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

C_DirectActivityAllocationItem

DDL: C_DIRECTACTIVITYALLOCATIONITEM SQL: CDRCTACTYI Type: view CONSUMPTION Package: ODATA_MANAGE_DRCT_ACTY_ALLOC

129 Fields 1 Data Sources 5 Associations 1 OData Services

Item of Manage Direct Activity Allocation

C_DirectActivityAllocationItem is a Consumption CDS View that provides data about "Item of Manage Direct Activity Allocation" in SAP S/4HANA. It reads from 1 data source (I_DrctActivityAllocationItemTP) and exposes 129 fields with key fields FiscalYear, ReferenceDocument, ControllingArea, CompanyCode, LedgerGLLineItem. It has 5 associations to related views. It is exposed through 1 OData service (ASQL_F3697). Part of development package ODATA_MANAGE_DRCT_ACTY_ALLOC.

Data Sources (1)

Source	Alias	Join Type
I_DrctActivityAllocationItemTP	_DrctActivityAllocationItemTP	from

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	C_DirectActivityAllocation	_Header	`$projection.ControllingArea = _Header.ControllingArea and $projection.FiscalYear = _Header.FiscalYear and $projection.ReferenceDocument = _Header.ReferenceDocument`
[1..1]	I_AccountAssignmentTypeT	_PartnerAccountAssignmentTypeT	`$projection.PartnerAccountAssignmentType = _PartnerAccountAssignmentTypeT.AccountAssignmentType and _PartnerAccountAssignmentTypeT.Language = $session.system_language`
[1..1]	I_AccountAssignmentTypeT	_AccountAssignmentTypeT	`$projection.AccountAssignmentType = _AccountAssignmentTypeT.AccountAssignmentType and _AccountAssignmentTypeT.Language = $session.system_language`
[0..1]	I_CompanyCode	_CompanyCodeText	`$projection.CompanyCode = _CompanyCodeText.CompanyCode`
[0..1]	I_CompanyCode	_SenderCompanyCodeText	`$projection.SenderCompanyCode = _SenderCompanyCodeText .CompanyCode`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CDRCTACTYI	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Item of Manage Direct Activity Allocation	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.transactionalProcessingDelegated	true	view
UI.headerInfo.typeName	Item	view
UI.headerInfo.typeNamePlural	Items	view

OData Services (1)

Service	Binding	Version	Contract	Release
ASQL_F3697	ASQL_F3697		C2	NOT_RELEASED

Fields (129)

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	CompanyCode		CompanyCode	Receiver Company Code
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
KEY	ReferenceDocumentItem		ReferenceDocumentItem	Reference item
	ReferenceDocumentItemForEdit		ReferenceDocumentItemForEdit	Reference Document Item
	FiscalYearForEdit	_Header	FiscalYearForEdit	Fiscal Year
	ReferenceDocumentForEdit		ReferenceDocumentForEdit	Reference Document
	ControllingAreaForEdit	_Header	ControllingAreaForEdit	Controlling Area
	CompanyCodeForEdit		CompanyCodeForEdit	Company Code
	CompanyCodeName	_CompanyCodeText	CompanyCodeName	Receiver Company Code Name
	LedgerGLLineItemForEdit		LedgerGLLineItemForEdit	Journal Entry Item
	SourceLedger		SourceLedger	Source Ledger
	AccountingDocument		AccountingDocument	Journal Entry
	SenderCompanyCode		SenderCompanyCode	Sender Company Code
	SourceCompanyCodeName	_SenderCompanyCodeText	CompanyCodeName	Sender Company Code Name
	AccountAssignment		AccountAssignment	Sender Acct Assgmt
	AccountAssignmentType		AccountAssignmentType	Sender Object Type
	AccountAssignmentTypeDesc	_AccountAssignmentTypeT	AccountAssignmentTypeDesc	Sender Object Type Text
	PartnerAccountAssignment		PartnerAccountAssignment	Partner Account Assignment
	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
	PartAccountAssignmentTypeDesc	_PartnerAccountAssignmentTypeT	AccountAssignmentTypeDesc	Receiver Object Type Text
	CostCtrActivityType		CostCtrActivityType	Sender Activity Type
	CostCtrActivityTypeName	_CostCtrActivityTypeTxt	CostCtrActivityTypeName	Sender Activity Type Name
	PartnerCostCenter		PartnerCostCenter	Receiver Cost Center
	PartnerCostCenterName	_PartnerCostCenterText	CostCenterName	Receiver Cost Center Name
	OriginCostCenter		OriginCostCenter
	CostCenterName	_CostCenterText	CostCenterName	Sender Cost Center Name
	DocumentItemText		DocumentItemText	Text
	GLAccount		GLAccount	General Ledger
	GLAccountName			Account for Allocation Name
	ChartOfAccounts	I_DrctActivityAllocationItemTP	ChartOfAccounts	Node Class
	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
	PartnerWBSElement		PartnerWBSElement	Receiver WBS Element (Deprecated)
	WBSDescription	_PartnerWBSElementText	WBSDescription	Receiver WBS Element Name
	PartnerProjectExternalID		PartnerProjectExternalID	Receiver Project
	PartnerProject		PartnerProject	Receiver Project (Deprecated)
	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
	Material		Material	Vehicle Model
	ReceiverProcurementProcess		ReceiverProcurementProcess	Prod. Proc. No.
	PartnerBusinessProcess		PartnerBusinessProcess	Receiver Business Process
	Fund		Fund	Sender Fund
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	GrantID		GrantID	Sender Grant
	BudgetPeriod		BudgetPeriod	Sender Budget Period
	PartnerFund		PartnerFund	Receiver Fund
	PartnerFunctionalArea		PartnerFunctionalArea	Rec. Fntcl Area
	PartnerGrant		PartnerGrant	Receiver Grant
	PartnerBudgetPeriod		PartnerBudgetPeriod	Receiver Budget Period
	FundName			Sender Fund Name
	ReceiverPostedFundName			Receiver Fund Name
	GrantName			Sender Grant Name
	ReceiverPostedGrantName			Receiver Grant Name
	BudgetPeriodName			Sender Budget Period Name
	ReceiverPostedBudgetPeriodName			Receiver Budget Period Name
	FunctionalAreaName			Sender Functional Area Name
	PartnerFunctionalAreaName			Receiver Functional Area Name
	IsSettled		IsSettled	Is Reposted
	BillableControl		BillableControl	Receiver Accounting Indicator
	BillableControlName
	JointVentureCostRecoveryCode		JointVentureCostRecoveryCode	Receiver Recovery Indicator
	SenderCostRecoveryCode		SenderCostRecoveryCode	Sender Recovery Indicator
	DirectActivityAllocationAction		DirectActivityAllocationAction
	Status		Status	Workflow Status
	PostingDate		PostingDate	Posting Date for GR
	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
	ControllingBusTransacType		ControllingBusTransacType	CO Bus. Transaction
	PartnerProfitCenter		PartnerProfitCenter	Profit Center
	ProfitCenter		ProfitCenter	Profit Center
	ServicesRenderedDate		ServicesRenderedDate	Services Rendered Date
	AccountingDocumentType	I_DrctActivityAllocationItemTP	AccountingDocumentType	Journal Entry Type
	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
	_Header		_Header

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 C_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.
-- SQL view name: CDRCTACTYI

CREATE VIEW C_DirectActivityAllocationItem AS
SELECT
  FiscalYear,
  ReferenceDocument,
  ControllingArea,
  CompanyCode,
  LedgerGLLineItem,
  ReferenceDocumentItem,
  ReferenceDocumentItemForEdit,
  _Header.FiscalYearForEdit AS FiscalYearForEdit,
  ReferenceDocumentForEdit,
  _Header.ControllingAreaForEdit AS ControllingAreaForEdit,
  CompanyCodeForEdit,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  LedgerGLLineItemForEdit,
  SourceLedger,
  AccountingDocument,
  SenderCompanyCode,
  _SenderCompanyCodeText.CompanyCodeName AS SourceCompanyCodeName,
  AccountAssignment,
  AccountAssignmentType,
  _AccountAssignmentTypeT.AccountAssignmentTypeDesc AS AccountAssignmentTypeDesc,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  _PartnerAccountAssignmentTypeT.AccountAssignmentTypeDesc AS PartAccountAssignmentTypeDesc,
  CostCtrActivityType,
  _CostCtrActivityTypeTxt.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  PartnerCostCenter,
  _PartnerCostCenterText.CostCenterName AS PartnerCostCenterName,
  OriginCostCenter,
  _CostCenterText.CostCenterName AS CostCenterName,
  DocumentItemText,
  GLAccount,
  _GLAccountText[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  _DrctActivityAllocationItemTP.ChartOfAccounts AS ChartOfAccounts,
  BaseUnit,
  _UnitOfMeasureText[1:Language = $session.system_language].UnitOfMeasureLongName AS UnitOfMeasureLongName,
  Quantity,
  TransactionCurrency,
  AmountInTransactionCurrency,
  PrcTotAmtInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  PrcTotAmtInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  PrcTotAmtInGlobalCurrency,
  PartnerWBSElementExternalID,
  PartnerWBSElement,
  _PartnerWBSElementText.WBSDescription AS WBSDescription,
  PartnerProjectExternalID,
  PartnerProject,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  PartnerProjectNetwork,
  PartnerOrder,
  PartnerProjectNetworkActivity,
  PartnerCostCtrActivityType,
  _PartnerCostCtrActivityTypeTxt.CostCtrActivityTypeName AS PartnerCostCtrActivityTypeName,
  PartnerCostObject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  WorkItem,
  PersonnelNumber,
  Plant,
  Material,
  ReceiverProcurementProcess,
  PartnerBusinessProcess,
  Fund,
  FunctionalArea,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerFunctionalArea,
  PartnerGrant,
  PartnerBudgetPeriod,
  _FundText[1:Language = $session.system_language].FundName AS FundName,
  _PartnerFundText[1:Language = $session.system_language].FundName AS ReceiverPostedFundName,
  _GrantText[1:Language = $session.system_language].GrantName AS GrantName,
  _PartnerGrantText[1:Language = $session.system_language].GrantName AS ReceiverPostedGrantName,
  _BudgetPeriodText[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  _PartnerBudgetPeriodText[1:Language = $session.system_language].BudgetPeriodName AS ReceiverPostedBudgetPeriodName,
  _FunctionalAreaText[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  _PartnerFunctionalAreaText[1:Language = $session.system_language].FunctionalAreaName AS PartnerFunctionalAreaName,
  IsSettled,
  BillableControl,
  _BillableControlText[1:Language = $session.system_language].BillableControlName AS BillableControlName,
  JointVentureCostRecoveryCode,
  SenderCostRecoveryCode,
  DirectActivityAllocationAction,
  Status,
  PostingDate,
  OperatingConcern,
  PartnerProfitabilitySegment,
  PartProfitabilitySgmtIsAssgd,
  _SuccessorReferenceItem.SuccessorReferenceDocument AS SuccessorReferenceDocument,
  OrderOperation,
  ReceiverRECompanyCode,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  ControllingBusTransacType,
  PartnerProfitCenter,
  ProfitCenter,
  ServicesRenderedDate,
  _DrctActivityAllocationItemTP.AccountingDocumentType AS AccountingDocumentType,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FunctionalCurrency,
  AmountInFunctionalCurrency
FROM I_DrctActivityAllocationItemTP AS _DrctActivityAllocationItemTP
LEFT OUTER JOIN C_DirectActivityAllocation AS _Header ON ControllingArea = _Header.ControllingArea AND FiscalYear = _Header.FiscalYear AND ReferenceDocument = _Header.ReferenceDocument  -- association [1..1]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _PartnerAccountAssignmentTypeT ON PartnerAccountAssignmentType = _PartnerAccountAssignmentTypeT.AccountAssignmentType AND _PartnerAccountAssignmentTypeT.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _AccountAssignmentTypeT ON AccountAssignmentType = _AccountAssignmentTypeT.AccountAssignmentType AND _AccountAssignmentTypeT.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _SenderCompanyCodeText ON SenderCompanyCode = _SenderCompanyCodeText .CompanyCode  -- association [0..1]
;

Depth:

C_DirectActivityAllocationItem view

I_DrctActivityAllocationItemTP view