Fclm_Mm_Pohistdcost

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_Pohistdcost.
-- 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: VFCLMMMPOHTC

CREATE VIEW Fclm_Mm_Pohistdcost AS
SELECT
  mandt,
  ebeln AS PurchaseOrder,
  ebelp AS PurchaseOrderItem,
  stunr AS ConditionStep,
  zaehk AS ConditionCount,
  vgabe AS PurchaseOrderTransactionType,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  buzei AS AccountingDocumentItem,
  bewtp AS PurchaseOrderHistCategory,
  budat AS PostingDate,
  menge AS PurchaseOrderItemQuantity,
  dmbtr AS PurOrdAmountInCompanyCodeCrcy,
  wrbtr AS PurOrderItemAmountInPurOrdCrcy,
  waers AS CompanyCodeCurrency,
  arewr AS GRIRAcctClrgAmtInCoCodeCrcy,
  shkzg AS QuantityDebitCreditCode,
  xblnr AS DocumentReferenceID,
  lifnr AS Supplier,
  reewr AS InvoiceAmtInCoCodeCrcy,
  refwr AS InvoiceAmountInFrgnCurrency,
  bpmng AS PurchaseOrderQty,
  areww AS GRIRAcctClrgAmtInTransacCrcy,
  shkko AS AmountDebitCreditCode,
  arewb AS GRIRAcctClrgAmtInOrdTrnsacCrcy,
  rewrb AS InvoiceAmtInPurgDocTransacCrcy,
  kschl AS ConditionType
FROM ekbz
-- UNION ALL with additional select branch(es): ekbzh
;