P_COActualLineItem

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 P_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: PFICOACTULITEM

CREATE VIEW P_COActualLineItem AS
SELECT
  a.rldnr AS Ledger,
  rbukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  kokrs AS ControllingArea,
  co_belnr AS ControllingDocument,
  case when v.buzei = 'CO_BUZEI' then a.co_buzei when v.buzei = 'CO_BUZEI1' then a.co_buzei1 when v.buzei = 'CO_BUZEI2' then a.co_buzei2 when v.buzei = 'CO_BUZEI5' then a.co_buzei5 when v.buzei = 'CO_BUZEI6' then a.co_buzei6 when v.buzei = 'CO_BUZEI7' then a.co_buzei7 else a.co_buzei end as ControllingDocumentItem AS co_buzeiendasControllingDocumentItem,
  poper AS FiscalPeriod,
  cast( fiscyearper as fins_fyearperiod ) AS FiscalYearPeriod,
  ktopl AS ChartOfAccounts,
  racct AS CostElement,
  objnr AS ControllingObject,
  glaccount_type AS GLAccountType,
  versn AS Version,
  a.hrkft AS ControllingKeySubNumber,
  a.vrgng AS ControllingBusTransacType,
  glaccount_type AS CtrlgOriginClassification,
  co_beknz AS OriginCtrlgDebitCreditCode,
  co_belkz AS ControllingDebitCreditCode,
  hkgrp AS CostOriginGroup,
  uspob AS OriginSenderObject,
  ukostl AS OriginCostCenter,
  ulstar AS OriginCostCtrActivityType,
  accas AS AccountAssignment,
  accasty AS AccountAssignmentType,
  rcntr AS CostCenter,
  lstar AS ActivityType,
  aufnr AS OrderID,
  aufps AS OrderItem,
  autyp AS OrderCategory,
  paccas AS PartnerAccountAssignment,
  paccasty AS PartnerAccountAssignmentType,
  parob1 AS PartnerCostObject,
  scntr AS PartnerCostCenter,
  plstar AS PartnerCostCtrActivityType,
  paufnr AS PartnerOrder,
  pprznr AS PartnerBusinessProcess,
  matnr AS Material,
  werks AS Plant,
  rkcur AS GlobalCurrency,
  arbid AS WorkCenterInternalID,
  vornr AS OrderOperation,
  pernr AS PersonnelNumber,
  gkont AS OffsettingAccount,
  gkoar AS OffsettingAccountType,
  bldat AS DocumentDate,
  budat AS PostingDate,
  a.buzei AS AccountingDocumentItem,
  rhcur AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  tsl AS AmountInTransactionCurrency,
  rtcur AS TransactionCurrency,
  osl AS AmountInFreeDefinedCurrency1,
  rocur AS FreeDefinedCurrency1,
  vsl AS AmountInFreeDefinedCurrency2,
  rvcur AS FreeDefinedCurrency2,
  bsl AS AmountInFreeDefinedCurrency3,
  rbcur AS FreeDefinedCurrency3,
  csl AS AmountInFreeDefinedCurrency4,
  rccur AS FreeDefinedCurrency4,
  dsl AS AmountInFreeDefinedCurrency5,
  rdcur AS FreeDefinedCurrency5,
  esl AS AmountInFreeDefinedCurrency6,
  recur AS FreeDefinedCurrency6,
  fsl AS AmountInFreeDefinedCurrency7,
  rfcur AS FreeDefinedCurrency7,
  gsl AS AmountInFreeDefinedCurrency8,
  rgcur AS FreeDefinedCurrency8,
  runit AS BaseUnit,
  msl AS Quantity,
  rvunit AS UnitOfMeasure,
  vmsl AS TotalQuantity,
  vmfsl AS FixedQuantity
FROM acdoca AS a
INNER JOIN finsc_cmp_versnc AS v ON /* join condition not captured in parsed metadata */
;