Fclm_Mm_Ekkn

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 Fclm_Mm_Ekkn.
-- 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: VFCLMMMEKKN

CREATE VIEW Fclm_Mm_Ekkn AS
SELECT
  a.mandt AS mandt,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  zekkn AS AccountAssignmentNumber,
  kostl AS CostCenter,
  anln1 AS MasterFixedAsset,
  nplnr AS ProjectNetwork,
  aufnr AS ProcessOrder,
  menge AS Quantity,
  vproz AS MultipleAcctAssgmtDistrPercent,
  netwr AS PurgDocNetAmount,
  loekz AS IsDeleted,
  sakto AS GLAccount,
  gsber AS BusinessArea,
  vbeln AS SalesOrder,
  vbelp AS SalesOrderItem,
  veten AS SalesOrderScheduleLine,
  anln2 AS FixedAsset,
  aufnr AS OrderID,
  ablad AS UnloadingPointName,
  a.kokrs AS ControllingArea,
  kstrg AS CostObject,
  paobjnr AS ProfitabilitySegment,
  a.prctr AS ProfitCenter,
  ps_psp_pnr AS WBSElementInternalID,
  aufpl AS ProjectNetworkInternalID,
  fipos AS CommitmentItem,
  fistl AS FundsCenter,
  geber AS Fund,
  fkber AS FunctionalArea,
  '00010101' AS ValidDateFrom,
  '99991231' AS ValidDateTo
FROM ekkn AS a
LEFT OUTER JOIN cepc AS b ON /* join condition not captured in parsed metadata */
;