R_CFinRpldPurgDocAcctAssgmt

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_CFinRpldPurgDocAcctAssgmt.
-- 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 R_CFinRpldPurgDocAcctAssgmt AS
SELECT
  db_key AS CFinRpldPurgDocAcctAssgmtUUID,
  root_key AS CFinRpldPurchasingDocUUID,
  parent_key AS CFinRpldPurchasingDocItemUUID,
  fins_logsys AS SourceSystemLogicalSystem,
  cast( ebeln as fins_cfin_av_purchasing_doc preserving type ) AS CFinRpldPurchasingDocument,
  cast( ebelp as fins_cfin_av_purg_document_itm preserving type ) AS CFinRpldPurchasingDocumentItem,
  cast( zekkn as fins_cfin_av_purg_doc_acctasgt preserving type ) AS CFinRpldPurgDocAcctAssgmt,
  loekz AS IsDeleted,
  menge AS Quantity,
  vproz AS MultipleAcctAssgmtDistrPercent,
  netwr AS PurgDocNetAmount,
  sakto AS GLAccount,
  gsber AS BusinessArea,
  kostl AS CostCenter,
  vbeln AS CFinReplicatedSalesDocument,
  vbelp AS CFinRpldSalesDocumentItem,
  veten AS CFinRpldSalesDocScheduleLine,
  anln1 AS MasterFixedAsset,
  anln2 AS FixedAsset,
  aufnr AS OrderID,
  kokrs AS ControllingArea,
  cast( ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  nplnr AS ProjectNetwork,
  aufpl AS ProjectNetworkInternalID,
  cast( imkey as recaimkeyfi preserving type ) AS REInternalFinNumber,
  aplzl AS NetworkActivityInternalID,
  cast( fipos as bbp_bapi_fipos preserving type) AS CommitmentItemShortID,
  fistl AS FundsCenter,
  geber AS Fund,
  fkber AS FunctionalArea,
  dabrz AS SettlementReferenceDate,
  navnw AS NonDeductibleInputTaxAmount,
  lstar AS CostCtrActivityType,
  grant_nbr AS GrantID,
  budget_pd AS BudgetPeriod,
  menge_f AS QuantityAsFloatValue,
  fm_split_batch AS PubSecSplitBatchNumberID,
  fmfgus_key AS USFedGovernmentUUID,
  wempf AS GoodsRecepientName,
  aedat AS CreationDate,
  prctr AS ProfitCenter,
  paobjnr AS ProfitabilitySegment,
  erkrs AS OperatingConcern,
  _CFinRpldPurchasingDocItem.OrderQuantityUnit AS OrderQuantityUnit,
  _CFinRpldPurchasingDocItem.DocumentCurrency AS DocumentCurrency
FROM cfin_av_po_acc
LEFT OUTER JOIN R_CFinRpldPurchasingDocItem AS _CFinRpldPurchasingDocItem ON CFinRpldPurchasingDocItemUUID = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocItemUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
;