R_ControllingActualLineItem

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 R_ControllingActualLineItem.
-- 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: RFICOACTULITEM

CREATE VIEW R_ControllingActualLineItem AS
SELECT
  rldnr AS Ledger,
  rbukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  kokrs AS ControllingArea,
  co_belnr AS ControllingDocument,
  co_buzei AS ControllingDocumentItem,
  poper AS FiscalPeriod,
  cast( fiscyearper as fins_fyearperiod ) AS FiscalYearPeriod,
  ktopl AS ChartOfAccounts,
  racct AS CostElement,
  objnr AS ControllingObject,
  glaccount_type AS GLAccountType,
  hrkft AS ControllingKeySubNumber,
  slalittype AS SubLedgerAcctLineItemType,
  vrgng AS BusinessTransactionType,
  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,
  scntr AS PartnerCostCenter,
  plstar AS PartnerCostCtrActivityType,
  paufnr AS PartnerOrder,
  pprznr AS PartnerBusinessProcess,
  matnr AS Material,
  werks AS Plant,
  rkcur AS GlobalCurrency,
  bttype AS BusinessTransactionCategory,
  ktosl AS TransactionTypeDetermination,
  arbid AS WorkCenterInternalID,
  vornr AS OrderOperation,
  pernr AS PersonnelNumber,
  gkont AS OffsettingAccount,
  gkoar AS OffsettingAccountType,
  bldat AS DocumentDate,
  budat AS PostingDate,
  buzei AS AccountingDocumentItem,
  rhcur AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  rco_ocur AS ControllingObjectCurrency,
  ksl AS AmountInGlobalCurrency,
  kfsl AS FixedAmountInGlobalCrcy,
  co_osl AS AmountInObjectCurrency,
  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
;