C_StRpFxdAssetAcquisitionFormC

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 C_StRpFxdAssetAcquisitionFormC.
-- 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: CSRFAACQFORMC
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_DateFieldPrintedOnForm : fiaagen_frm_date_fld_prntd, P_NationalClsfctnSourceField : fiaagen_natl_clfn_srce_fld

CREATE VIEW C_StRpFxdAssetAcquisitionFormC AS
SELECT
  FixedAssetVal.CompanyCode AS CompanyCode,
  AssetDepreciationArea,
  FixedAssetVal.MasterFixedAsset AS MasterFixedAsset,
  FixedAssetVal.FixedAsset AS FixedAsset,
  FixedAssetVal.AccountingDocument AS AccountingDocument,
  LedgerGLLineItem,
  TransactionSubitem,
  Ledger,
  FixedAssetVal.FiscalYear AS FiscalYear,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  FixedAssetVal.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  AssetAccountingKeyFigure,
  DebitCreditCode,
  AssetFormCompCode.FullName AS CompanyCodeName,
  ControllingArea,
  Inventory,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).DepreciationKey AS DepreciationKey,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  FixedAssetVal.LedgerFiscalYear AS LedgerFiscalYear,
  FixedAssetVal.FiscalYearVariant AS FiscalYearVariant,
  ChartOfDepreciation,
  PostingDate,
  DocumentDate,
  AssetValueDate,
  _FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  FixedAssetVal.AccountingDocumentType AS AccountingDocumentType,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  _FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  AssetClass,
  '' AS AssetClassDescription,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  FixedAssetVal.Country AS Country,
  AssetSerialNumber,
  _FixedAsset.Supplier AS Supplier,
  _FixedAsset._Supplier.BPSupplierName AS SupplierName,
  cast (DisplayCurrency as waers) AS CompanyCodeCurrency,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).Plant as faa_werks) AS AssetPlant,
  _AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).AssetLocation AS AssetLocation,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).CostCenter as faa_kostl) AS AssetCostCenter,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).BusinessArea as faa_gsber) AS AssetBusinessArea,
  _AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_ToFiscalPeriod).PersonnelNumber AS PersonnelNumber,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  FormNumber.FixedAssetFormNumber AS FixedAssetFormNumber,
  FormNumber.StatryRptgEntity AS StatryRptgEntity,
  FormNumber.StatryRptCategory AS StatryRptCategory,
  FormNumber.StatryRptRunID AS StatryRptRunID
FROM I_AssetBalanceCube
LEFT OUTER JOIN I_FixedAssetFormNumber AS FormNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_STRPFxdAssetFormCompanyCode AS AssetFormCompCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_FxdAstDeprAreaByFsclPerdEnd AS _DeprAreaByFiscalPeriodEnd ON CompanyCode = _DeprAreaByFiscalPeriodEnd.CompanyCode AND Ledger = _DeprAreaByFiscalPeriodEnd.Ledger AND AssetDepreciationArea = _DeprAreaByFiscalPeriodEnd.AssetDepreciationArea AND MasterFixedAsset = _DeprAreaByFiscalPeriodEnd.MasterFixedAsset AND FixedAsset = _DeprAreaByFiscalPeriodEnd.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_DepreciationKey AS _DepreciationKey ON ChartOfDepreciation = _DepreciationKey.ChartOfDepreciation AND depreciationkey = _DepreciationKey.DepreciationKey  -- association [0..1]
LEFT OUTER JOIN I_FxdAstAssgmtByFsclPerdEndDte AS _AssignmentByFiscalPeriodEnd ON CompanyCode = _AssignmentByFiscalPeriodEnd.CompanyCode AND Ledger = _AssignmentByFiscalPeriodEnd.Ledger AND AssetDepreciationArea = _AssignmentByFiscalPeriodEnd.AssetDepreciationArea AND MasterFixedAsset = _AssignmentByFiscalPeriodEnd.MasterFixedAsset AND FixedAsset = _AssignmentByFiscalPeriodEnd.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _AssetPlant ON AssetPlant = _AssetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Location AS _AssetLocation ON assetlocation = _AssetLocation.Location AND AssetPlant = _AssetLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _AssetCostCenter ON ControllingArea = _AssetCostCenter.ControllingArea AND AssetCostCenter = _AssetCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _AssetBusinessArea ON AssetBusinessArea = _AssetBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_Group1AssetEvaluationKey AS _EvaluationGroup1 ON Group1AssetEvaluationKey = _EvaluationGroup1.Group1AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group2AssetEvaluationKey AS _EvaluationGroup2 ON Group2AssetEvaluationKey = _EvaluationGroup2.Group2AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group3AssetEvaluationKey AS _EvaluationGroup3 ON Group3AssetEvaluationKey = _EvaluationGroup3.Group3AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group4AssetEvaluationKey AS _EvaluationGroup4 ON Group4AssetEvaluationKey = _EvaluationGroup4.Group4AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group5AssetEvaluationKey AS _EvaluationGroup5 ON Group5AssetEvaluationKey = _EvaluationGroup5.Group5AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON CompanyCode = _FixedAssetForLedger.CompanyCode AND MasterFixedAsset = _FixedAssetForLedger.MasterFixedAsset AND FixedAsset = _FixedAssetForLedger.FixedAsset AND Ledger = _FixedAssetForLedger.Ledger  -- association [0..1]
;