C_AccrEngineAccrAssgmtDEX

DDL: C_ACCRENGINEACCRASSGMTDEX SQL: CACESOASSGMTDX Type: view CONSUMPTION
28 Fields 1 Data Sources

Data Extraction for Accrual Assignment

C_AccrEngineAccrAssgmtDEX is a Consumption CDS View that provides data about "Data Extraction for Accrual Assignment" in SAP S/4HANA. It reads from 1 data source (I_AccrEngineAccrAssgmtRawData) and exposes 28 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject.

Data Sources (1)

SourceAliasJoin Type
I_AccrEngineAccrAssgmtRawData I_AccrEngineAccrAssgmtRawData from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CACESOASSGMTDX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Data Extraction for Accrual Assignment view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType AccrualEngineAccrualObjectType Component
KEY AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccrualObject AccrualObject External Reference of Accrual Object
KEY AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
KEY AccrAcctAssgmtValdtyEndDte AccrAcctAssgmtValdtyEndDte Validity End Date
AccrAcctAssgmtValdtyStrtDte AccrAcctAssgmtValdtyStrtDte Validity Start Date
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
Fund Fund Sender Fund
FundsCenter FundsCenter Funds Center
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
FunctionalArea FunctionalArea Sendr Fctl Area
GrantID GrantID Sender Grant
FundedProgram FundedProgram Funded Program
BudgetPeriod BudgetPeriod Budget Period
CostCenter CostCenter Cost Center
OrderID OrderID Order ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
CostObject CostObject Cost Object
CostCtrActivityType CostCtrActivityType Activity Type
NetworkNumberForAcctAssgmt NetworkNumberForAcctAssgmt Network
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
BusinessProcess BusinessProcess Business Process
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
ProfitabilitySegment ProfitabilitySegment Profitability Segment

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_AccrEngineAccrAssgmtDEX.
-- 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: CACESOASSGMTDX

CREATE VIEW C_AccrEngineAccrAssgmtDEX AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrAcctAssgmtValdtyEndDte,
  AccrAcctAssgmtValdtyStrtDte,
  BusinessArea,
  ProfitCenter,
  Segment,
  Fund,
  FundsCenter,
  CommitmentItemShortID,
  FunctionalArea,
  GrantID,
  FundedProgram,
  BudgetPeriod,
  CostCenter,
  OrderID,
  WBSElementInternalID,
  CostObject,
  CostCtrActivityType,
  NetworkNumberForAcctAssgmt,
  ProjectNetworkInternalID,
  BusinessProcess,
  SalesOrder,
  SalesOrderItem,
  ProfitabilitySegment
FROM I_AccrEngineAccrAssgmtRawData
;

Learn More