I_FxdAstStatisticalLineItem

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_FxdAstStatisticalLineItem.
-- 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.

CREATE VIEW I_FxdAstStatisticalLineItem AS
SELECT
  docit.bukrs AS CompanyCode,
  docit.anln1 AS MasterFixedAsset,
  docit.anln2 AS FixedAsset,
  docit.gjahr AS FiscalYear,
  cast(docit.awtyp as fis_awtyp) AS ReferenceDocumentType,
  cast(docit.awref as fis_awref) AS ReferenceDocument,
  docit.aworg AS ReferenceDocumentContext,
  docit.awsys AS LogicalSystem,
  docit.subta AS TransactionSubitem,
  docit.afabe AS AssetDepreciationArea,
  cast(docit.slalittype as fis_slalittype preserving type) AS SubLedgerAcctLineItemType,
  cast(docit.drcrk as fis_shkzg) AS DebitCreditCode,
  cast(docit.gjahr as gjahr_pos) AS LedgerFiscalYear,
  I_LedgerCompanyCodeCrcyRoles.AccountingPrinciple AS AccountingPrinciple,
  docit.rldnr AS Ledger,
  cast('' as faa_deprecated_target_ldgrp) AS LedgerGroup,
  docit.poper AS FiscalPeriod,
  cast(' ' as fagl_hkont preserving type) AS GLAccount,
  docit.movcat AS AssetAcctTransClassfctn,
  docit.anlgr AS GroupMasterFixedAsset,
  docit.anlgr2 AS GroupFixedAsset,
  _ChartOfDeprForAcctgPrinciple.ChartOfDepreciation AS ChartOfDepreciation,
  docit.awitem AS ReferenceDocumentItem,
  docit.awref_rev AS ReversalReferenceDocument,
  docit.aworg_rev AS ReversalReferenceDocumentCntxt,
  docit.xreversing AS IsReversal,
  docit.xreversed AS IsReversed,
  docit.bldat AS DocumentDate,
  docit.budat AS PostingDate,
  docit.bwasl AS AssetTransactionType,
  docit.bzdat AS AssetValueDate,
  cast(docit.cpudt as fis_cpudt) AS AccountingDocumentCreationDate,
  cast(docit.cputm as fis_cputm) AS CreationTime,
  docit.sgtxt AS DocumentItemText,
  cast(docit.usnam as fis_usnam) AS AccountingDocCreatedByUser,
  docit.vorgn AS GLBusinessTransactionType,
  docit.zuonr AS AssignmentReference,
  docit.recid AS JointVentureCostRecoveryCode,
  docit.panl1 AS PartnerMasterFixedAsset,
  docit.panl2 AS PartnerFixedAsset,
  docit.rhcur AS CompanyCodeCurrency,
  docit.hsl AS AmountInCompanyCodeCurrency,
  docit.rkcur AS GlobalCurrency,
  docit.ksl AS AmountInGlobalCurrency,
  docit.rocur AS FreeDefinedCurrency1,
  docit.osl AS AmountInFreeDefinedCurrency1,
  docit.rvcur AS FreeDefinedCurrency2,
  docit.vsl AS AmountInFreeDefinedCurrency2,
  docit.rbcur AS FreeDefinedCurrency3,
  docit.bsl AS AmountInFreeDefinedCurrency3,
  docit.rccur AS FreeDefinedCurrency4,
  docit.csl AS AmountInFreeDefinedCurrency4,
  docit.rdcur AS FreeDefinedCurrency5,
  docit.dsl AS AmountInFreeDefinedCurrency5,
  docit.recur AS FreeDefinedCurrency6,
  docit.esl AS AmountInFreeDefinedCurrency6,
  docit.rfcur AS FreeDefinedCurrency7,
  docit.fsl AS AmountInFreeDefinedCurrency7,
  docit.rgcur AS FreeDefinedCurrency8,
  docit.gsl AS AmountInFreeDefinedCurrency8
FROM faat_doc_it AS docit
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_DepreciationAreaForLedger AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON chartofdepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _PartnerMasterFixedAsset ON CompanyCode = _PartnerMasterFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerMasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _PartnerFixedAsset ON CompanyCode = _PartnerFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerFixedAsset.MasterFixedAsset AND PartnerFixedAsset = _PartnerFixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_MovementCategory AS _AssetAcctTransClassfctn ON AssetAcctTransClassfctn = _AssetAcctTransClassfctn.AssetAcctTransClassfctn  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1]
LEFT OUTER JOIN I_ChartOfDeprForAcctgPrinciple AS _ChartOfDeprForAcctgPrinciple ON AccountingPrinciple = _ChartOfDeprForAcctgPrinciple.AccountingPrinciple AND CompanyCode = _ChartOfDeprForAcctgPrinciple.CompanyCode  -- association [0..1]
;