I_COActualLineItem

DDL: I_COACTUALLINEITEM SQL: IFICOACTULEITEM Type: view BASIC
85 Fields 1 Data Sources 5 Associations

Interface view for CO Actual Line Item

I_COActualLineItem is a Basic CDS View that provides data about "Interface view for CO Actual Line Item" in SAP S/4HANA. It reads from 1 data source (P_COActualLineItem) and exposes 85 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_COActualLineItem P_COActualLineItem from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_Currency _ControllingObjectCurrency $projection.ControllingObjectCurrency = _ControllingObjectCurrency.Currency
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFICOACTULEITEM view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface view for CO Actual Line Item view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.buffering.type #NONE view
AbapCatalog.buffering.numberOfKeyFields 0 view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
ControllingArea ControllingArea Controlling Area
ControllingDocument ControllingDocument Document Number
ControllingDocumentItem ControllingDocumentItem Controlling Doc Item
ControllingObject ControllingObject Object number
ControllingKeySubNumber ControllingKeySubNumber Origin group order
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
ChartOfAccounts ChartOfAccounts Node Class
CostElement CostElement G/L Account
GLAccountType GLAccountType G/L Account Type
Version Version XML Vers.
CtrlgOriginClassification CtrlgOriginClassification G/L Account Type
BusinessTransactionType ControllingBusTransacType CO Bus. Transaction
OriginCtrlgDebitCreditCode OriginCtrlgDebitCreditCode Debit/CreditInd
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
CostOriginGroup CostOriginGroup Origin Group
OriginSenderObject OriginSenderObject Source Object
OriginCostCenter OriginCostCenter OrigCCtr
OriginCostCtrActivityType OriginCostCtrActivityType OrigAct.
AccountAssignment AccountAssignment Sender Acct Assgmt
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
CostCenter CostCenter Cost Center
ActivityType ActivityType Activity Type
OrderID OrderID Order ID
OrderItem OrderItem Order item no.
OrderCategory OrderCategory Order Category
PartnerCostObject PartnerCostObject Partner Cost Object
PartnerAccountAssignment PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerOrder PartnerOrder Partner Order
PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
Material Material Vehicle Model
Plant Plant Valuation Area
WorkCenterInternalID WorkCenterInternalID Work Center
OrderOperation OrderOperation Operation or Phase
PersonnelNumber PersonnelNumber Personnel No.
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
AccountingDocumentItem AccountingDocumentItem Posting View Item
IsStatisticalOrder
IsStatisticalCostCenter
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
TransactionCurrency TransactionCurrency Transaction Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
BaseUnit BaseUnit Unit of Measure
Quantity Quantity Value
UnitOfMeasure UnitOfMeasure Unit Protected Qty
TotalQuantity TotalQuantity Activity Quantity
FixedQuantity FixedQuantity Fixed Quantity
_GlobalCurrency _GlobalCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_ControllingObjectCurrency _ControllingObjectCurrency
_UnitOfMeasure _UnitOfMeasure
_BaseUnit _BaseUnit

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 I_COActualLineItem.
-- 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: IFICOACTULEITEM

CREATE VIEW I_COActualLineItem AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  ControllingArea,
  ControllingDocument,
  ControllingDocumentItem,
  ControllingObject,
  ControllingKeySubNumber,
  FiscalPeriod,
  FiscalYearPeriod,
  ChartOfAccounts,
  CostElement,
  GLAccountType,
  Version,
  CtrlgOriginClassification,
  ControllingBusTransacType AS BusinessTransactionType,
  OriginCtrlgDebitCreditCode,
  ControllingDebitCreditCode,
  CostOriginGroup,
  OriginSenderObject,
  OriginCostCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  CostCenter,
  ActivityType,
  OrderID,
  OrderItem,
  OrderCategory,
  PartnerCostObject,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerBusinessProcess,
  Material,
  Plant,
  WorkCenterInternalID,
  OrderOperation,
  PersonnelNumber,
  OffsettingAccount,
  OffsettingAccountType,
  DocumentDate,
  PostingDate,
  AccountingDocumentItem,
  cast( FINS_XAUFNR_STAT as fins_xaufnr_stat ) AS IsStatisticalOrder,
  cast( FINS_XKOSTL_STAT as fins_xkostl_stat ) AS IsStatisticalCostCenter,
  GlobalCurrency,
  CompanyCodeCurrency,
  ControllingObjectCurrency,
  AmountInGlobalCurrency,
  FixedAmountInGlobalCrcy,
  AmountInCompanyCodeCurrency,
  AmountInObjectCurrency,
  AmountInTransactionCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  TransactionCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  BaseUnit,
  Quantity,
  UnitOfMeasure,
  TotalQuantity,
  FixedQuantity
FROM P_COActualLineItem
LEFT OUTER JOIN I_Currency AS _ControllingObjectCurrency ON ControllingObjectCurrency = _ControllingObjectCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;

Learn More