A_FinPlanItemStagingArea

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 A_FinPlanItemStagingArea.
-- 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: AFINPLNITMSTAREA

CREATE VIEW A_FinPlanItemStagingArea AS
SELECT
  transactionid AS FinancialPlanningTransaction,
  datapakid AS FinancialPlanningDataPacket,
  record AS FinancialPlanningEntryItem,
  rldnr AS Ledger,
  category AS PlanningCategory,
  ryear AS LedgerFiscalYear,
  racct AS GLAccount,
  rbukrs AS CompanyCode,
  rmvct AS FinancialTransactionType,
  bttype AS BusinessTransactionCategory,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  kokrs AS ControllingArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  cast( '' as fcom_fixed_variable_type) AS FixedVariableType,
  rwcur AS TransactionCurrency,
  wsl AS AmountInTransactionCurrency,
  wfsl AS FixedAmountInTransCrcy,
  rhcur AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  hfsl AS FixedAmountInCoCodeCrcy,
  rkcur AS GlobalCurrency,
  ksl AS AmountInGlobalCurrency,
  kfsl AS FixedAmountInGlobalCrcy,
  rco_ocur AS ControllingObjectCurrency,
  co_osl AS AmountInObjectCurrency,
  rfccur AS FunctionalCurrency,
  fcsl AS AmountInFunctionalCurrency,
  rvunit AS CostSourceUnit,
  vmsl AS ValuationQuantity,
  vmfsl AS ValuationFixedQuantity,
  rrunit AS ReferenceQuantityUnit,
  rmsl AS ReferenceQuantity,
  rocur AS FreeDefinedCurrency1,
  osl AS AmountInFreeDefinedCurrency1,
  rvcur AS FreeDefinedCurrency2,
  vsl AS AmountInFreeDefinedCurrency2,
  rbcur AS FreeDefinedCurrency3,
  bsl AS AmountInFreeDefinedCurrency3,
  rccur AS FreeDefinedCurrency4,
  csl AS AmountInFreeDefinedCurrency4,
  rdcur AS FreeDefinedCurrency5,
  dsl AS AmountInFreeDefinedCurrency5,
  recur AS FreeDefinedCurrency6,
  esl AS AmountInFreeDefinedCurrency6,
  rfcur AS FreeDefinedCurrency7,
  fsl AS AmountInFreeDefinedCurrency7,
  rgcur AS FreeDefinedCurrency8,
  gsl AS AmountInFreeDefinedCurrency8,
  poper AS FiscalPeriod,
  periv AS FiscalYearVariant,
  cast(fiscyearper as abap.char(8)) AS FiscalYearPeriod,
  ktopl AS ChartOfAccounts,
  werks AS Plant,
  kunnr AS Customer,
  co_belkz AS ControllingDebitCreditCode,
  ps_pspid AS Project,
  ps_posid AS WBSElement,
  pbukrs AS PartnerCompanyCode,
  lstar AS CostCtrActivityType,
  aufnr AS OrderID,
  paufnr AS PartnerOrder,
  plstar AS PartnerCostCtrActivityType,
  pps_pspid AS PartnerProject,
  pps_posid AS PartnerWBSElement,
  lstar AS ActivityType,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  service_doc_item_id AS ServiceDocumentItem,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  matnr_copa AS SoldMaterial,
  matkl AS MaterialGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  fikrs AS FinancialManagementArea,
  rfund AS Fund,
  rgrant_nbr AS GrantID,
  rbudget_pd AS BudgetPeriod,
  budget_process AS BudgetProcess,
  budget_subcategory AS BudgetingType,
  rsponsored_prog AS SponsoredProgram,
  rsponsored_class AS SponsoredClass,
  rbdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  activity_unit AS CostCtrActivityTypeQtyUnit,
  wfprice AS CostRateFixedAmountInTransCrcy,
  wvprice AS CostRateVarblAmountInTransCrcy,
  wvprice AS CostRateAmountInTransCrcy,
  co2e_quantity_unit AS CO2eqEmissionUnit,
  co2e_variable_quantity AS VariableQuantityInBaseUnit,
  co2e_fixed_quantity AS FixedQuantityInBaseUnit,
  ghg_category AS GHGCategory,
  stagr AS StatisticalKeyFigure,
  runit AS StatisticalKeyFigQtyUnit,
  msl AS StatisticalKeyFigureQuantity,
  Version,
  cast(swenr as rebdvdmbeno preserving type ) AS REBusinessEntity,
  cast(sgenr as rebdvdmbuno preserving type ) AS RealEstateBuilding,
  cast(sgrnr as rebdvdmprno preserving type ) AS RealEstateProperty,
  cast(smenr as rebdvdmrono preserving type ) AS RERentalObject,
  recnnr AS RealEstateContract,
  snksl AS REServiceChargeKey,
  sempsl AS RESettlementUnitID,
  dabrz AS SettlementReferenceDate
FROM acdocp_data
LEFT OUTER JOIN E_FinPlanItemStagingArea AS _Extension ON FinancialPlanningTransaction = _Extension.FinancialPlanningTransaction AND FinancialPlanningDataPacket = _Extension.FinancialPlanningDataPacket AND FinancialPlanningEntryItem = _Extension.FinancialPlanningEntryItem  -- association [1..1]
;