FAC_DART_Z3_LINEITEM_FIXEDAST

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 FAC_DART_Z3_LINEITEM_FIXEDAST.
-- 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: FAC_DZLIMFAST
-- Parameters: P_Language : sylangu, P_Ledger : fis_rldnr, P_FiscalYear : fins_gjahr, P_StartFiscalPeriod : fis_period_from, P_EndFiscalPeriod : fis_period_to

CREATE VIEW FAC_DART_Z3_LINEITEM_FIXEDAST AS
SELECT
  _FixedAsset.AssetClass AS AssetClass,
  FixedAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  PostingDate,
  AssetAcctTransClassfctn,
  SubLedgerAcctLineItemType,
  AccountingDocument,
  AccountingDocumentItem,
  GLAccount,
  _DebitCreditCode._Text[1:Language = $parameters.P_Language].DebitCreditCodeName AS DebitCreditCodeName,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  AssetDepreciationArea,
  _DepreciationArea._Text[1:Language = $parameters.P_Language].AssetDepreciationAreaName AS AssetDepreciationAreaName,
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  LedgerGroup,
  Ledger,
  TransactionSubitem,
  DebitCreditCode,
  AccountingPrinciple,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalYearPeriod,
  ChartOfAccounts,
  CountryChartOfAccounts,
  cast(AlternativeGLAccount as fis_altkt_skb1 preserving type) AS AlternativeGLAccount,
  cast('' as boolean preserving type) AS IsStatisticalDocument,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  FinancialAccountType,
  ChartOfDepreciation,
  ReferenceDocumentItem,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  IsReversal,
  IsReversed,
  DocumentDate,
  AssetTransactionType,
  AssetValueDate,
  AccountingDocumentCreationDate,
  CreationTime,
  DocumentItemText,
  AccountingDocCreatedByUser,
  GLBusinessTransactionType,
  AssignmentReference,
  JointVentureCostRecoveryCode,
  DepreciationFiscalPeriod,
  ReversalTransactionSubitem,
  CostCenter,
  Plant,
  BusinessArea,
  PersonnelNumber,
  Fund,
  ProfitCenter,
  Segment,
  FunctionalArea,
  ControllingArea,
  FundsCenter,
  AccountingDocumentType,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  BaseUnit,
  Quantity,
  PurchasingDocument,
  PurchasingDocumentItem,
  _OperationalAcctgDocItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  _OperationalAcctgDocItem.TaxCode AS TaxCode,
  _OperationalAcctgDocItem.TaxCountry AS TaxCountry,
  _OperationalAcctgDocItem.PartnerCompany AS PartnerCompany,
  _OperationalAcctgDocItem.Product AS Product,
  _OperationalAcctgDocItem.PartnerBusinessArea AS PartnerBusinessArea,
  _OperationalAcctgDocItem.Material AS MaterialNumber,
  _OperationalAcctgDocItem.BaseUnit AS BaseUnitofMeasure,
  _OperationalAcctgDocItem.Quantity AS Totalquantity,
  _JournalEntry.IntercompanyTransaction AS IntercompanyTransaction,
  _OperationalAcctgDocItem._PartnerCompany AS _PartnerCompany,
  _OperationalAcctgDocItem._Product AS _Product,
  _OperationalAcctgDocItem._PartnerBusinessArea AS _PartnerBusinessArea
FROM I_FixedAssetLineItem AS Lineitem
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON _ReferenceDocumentType.ReferenceDocumentType = ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
;