Fclm_Mmphi_Hist

DDL: FCLM_MMPHI_HIST SQL: VFCLMMMPHIHIST Type: view Package: FCLM_REUSE
51 Fields 3 Data Sources

Purchasing Document History with Items

Fclm_Mmphi_Hist is a CDS View that provides data about "Purchasing Document History with Items" in SAP S/4HANA. It reads from 3 data sources (t163b, Fclm_Mm_Ekpo, Fclm_Mm_Pohist) and exposes 51 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber, PurchaseOrderTransactionType, MaterialDocumentYear. Part of development package FCLM_REUSE.

Data Sources (3)

SourceAliasJoin Type
t163b _PurchasingDocHistCategory inner
Fclm_Mm_Ekpo _PurchasingDocumentItem inner
Fclm_Mm_Pohist union_EKBE_EKBEH from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMMMPHIHIST view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label Purchasing Document History with Items view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument Fclm_Mm_Pohist ebeln Source PurchDoc
KEY PurchasingDocumentItem Fclm_Mm_Pohist ebelp Item pur. doc.
KEY AccountAssignmentNumber Fclm_Mm_Pohist zekkn Account Assgmt No.
KEY PurchaseOrderTransactionType Fclm_Mm_Pohist vgabe Transact. Type
KEY MaterialDocumentYear Fclm_Mm_Pohist gjahr Settlement Year
KEY MaterialDocument Fclm_Mm_Pohist belnr SD Document
KEY MaterialDocumentItem Fclm_Mm_Pohist buzei Posting View Item
PurchaseOrderHistCategory Fclm_Mm_Pohist bewtp PO History Cat.
GoodsMovementType Fclm_Mm_Pohist bwart Valuation Type
PostingDate Fclm_Mm_Pohist budat Posting Date
Currency Fclm_Mm_Pohist waers Transaction Currency
DebitCreditCode Fclm_Mm_Pohist shkzg Returns
IsCompletelyDelivered Fclm_Mm_Pohist elikz Delivery Completion
ReferenceDocumentFiscalYear Fclm_Mm_Pohist lfgja Year Cur.Period
ReferenceDocument Fclm_Mm_Pohist lfbnr Reference Doc.
ReferenceDocumentItem Fclm_Mm_Pohist lfpos Ref. Doc. Item
Material Fclm_Mm_Pohist matnr Vehicle Model
Plant Fclm_Mm_Pohist werks Receiving Plant
DocumentDate Fclm_Mm_Pohist bldat Journal Entry Date
InventoryValuationType Fclm_Mm_Pohist bwtar Valuation Type
DocumentReferenceID Fclm_Mm_Pohist xblnr Reference
DeliveryQuantityUnit Fclm_Mm_Pohist lsmeh Del. Note Unit
AccountingDocumentCreationDate Fclm_Mm_Pohist cpudt Imported On
Quantity Fclm_Mm_Pohist menge WarrCountValue
PurOrdAmountInCompanyCodeCrcy Fclm_Mm_Pohist dmbtr Loc. amount
PurchaseOrderAmount Fclm_Mm_Pohist wrbtr Gross Amount
QtyInPurchaseOrderPriceUnit Fclm_Mm_Pohist bpmng Qty. in OPUn
GRIRAcctClrgAmtInCoCodeCrcy Fclm_Mm_Pohist arewr Ord.GRIR.Val
GdsRcptBlkdStkQtyInOrdQtyUnit Fclm_Mm_Pohist wesbs GR Bl.St. OUn
GdsRcptBlkdStkQtyInOrdPrcUnit Fclm_Mm_Pohist bpwes GR blocked stck
InvoiceAmtInCoCodeCrcy Fclm_Mm_Pohist reewr Ord.Set.Value
InvoiceAmountInFrgnCurrency Fclm_Mm_Pohist refwr Inv.Value in FC
QuantityInDeliveryQtyUnit Fclm_Mm_Pohist lsmng Del. Note Qty
GRIRAcctClrgAmtInTransacCrcy Fclm_Mm_Pohist areww GR/IR clr.value
QuantityInBaseUnit Fclm_Mm_Pohist bamng Quantity
GRIRAcctClrgAmtInOrdTrnsacCrcy Fclm_Mm_Pohist arewb GR/IR clr.value
InvoiceAmtInPurOrdTransacCrcy Fclm_Mm_Pohist rewrb FC invoice amnt
VltdGdsRcptBlkdStkQtyInOrdUnit Fclm_Mm_Pohist wesbb Val. GR BlStock OUn
VltdGdsRcptBlkdQtyInOrdPrcUnit Fclm_Mm_Pohist bpweb Val. GR BS OPUn
ExchangeRateDifferenceAmount Fclm_Mm_Pohist kudif Exch.Rate Diff.
SubsequentDebitCreditIsAllowed t163b tbtkz Subseq. Dr/Cr
CompanyCodeCurrency Fclm_Mm_Ekpo CompanyCodeCurrency Local Currency
PurOrdTransactionCurrency Fclm_Mm_Ekpo DocumentCurrency Document Currency
PurchaseOrderAmountCoCodeCrcy Fclm_Mm_Ekpo NetAmount Stated Amount
OrderQuantity Fclm_Mm_Ekpo OrderQuantity Quantity
ValueBasedCommitment Fclm_Mm_Ekpo ValueBasedCommitment
OrdPriceUnitToOrderUnitDnmntr Fclm_Mm_Ekpo OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
OrderPriceUnitToOrderUnitNmrtr Fclm_Mm_Ekpo OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
NetPriceAmount Fclm_Mm_Ekpo NetPriceAmount Net Price
NetPriceQuantity Fclm_Mm_Ekpo NetPriceQuantity Price Unit
InvoicePlanNumber Fclm_Mm_Ekpo InvoicePlanNumber

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_Mmphi_Hist.
-- 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: VFCLMMMPHIHIST

CREATE VIEW Fclm_Mmphi_Hist AS
SELECT
  union_EKBE_EKBEH.ebeln AS PurchasingDocument,
  union_EKBE_EKBEH.ebelp AS PurchasingDocumentItem,
  union_EKBE_EKBEH.zekkn AS AccountAssignmentNumber,
  union_EKBE_EKBEH.vgabe AS PurchaseOrderTransactionType,
  union_EKBE_EKBEH.gjahr AS MaterialDocumentYear,
  union_EKBE_EKBEH.belnr AS MaterialDocument,
  union_EKBE_EKBEH.buzei AS MaterialDocumentItem,
  union_EKBE_EKBEH.bewtp AS PurchaseOrderHistCategory,
  union_EKBE_EKBEH.bwart AS GoodsMovementType,
  union_EKBE_EKBEH.budat AS PostingDate,
  union_EKBE_EKBEH.waers AS Currency,
  union_EKBE_EKBEH.shkzg AS DebitCreditCode,
  union_EKBE_EKBEH.elikz AS IsCompletelyDelivered,
  union_EKBE_EKBEH.lfgja AS ReferenceDocumentFiscalYear,
  union_EKBE_EKBEH.lfbnr AS ReferenceDocument,
  union_EKBE_EKBEH.lfpos AS ReferenceDocumentItem,
  union_EKBE_EKBEH.matnr AS Material,
  union_EKBE_EKBEH.werks AS Plant,
  union_EKBE_EKBEH.bldat AS DocumentDate,
  union_EKBE_EKBEH.bwtar AS InventoryValuationType,
  union_EKBE_EKBEH.xblnr AS DocumentReferenceID,
  union_EKBE_EKBEH.lsmeh AS DeliveryQuantityUnit,
  union_EKBE_EKBEH.cpudt AS AccountingDocumentCreationDate,
  union_EKBE_EKBEH.menge AS Quantity,
  union_EKBE_EKBEH.dmbtr AS PurOrdAmountInCompanyCodeCrcy,
  union_EKBE_EKBEH.wrbtr AS PurchaseOrderAmount,
  union_EKBE_EKBEH.bpmng AS QtyInPurchaseOrderPriceUnit,
  union_EKBE_EKBEH.arewr AS GRIRAcctClrgAmtInCoCodeCrcy,
  union_EKBE_EKBEH.wesbs AS GdsRcptBlkdStkQtyInOrdQtyUnit,
  union_EKBE_EKBEH.bpwes AS GdsRcptBlkdStkQtyInOrdPrcUnit,
  union_EKBE_EKBEH.reewr AS InvoiceAmtInCoCodeCrcy,
  union_EKBE_EKBEH.refwr AS InvoiceAmountInFrgnCurrency,
  union_EKBE_EKBEH.lsmng AS QuantityInDeliveryQtyUnit,
  union_EKBE_EKBEH.areww AS GRIRAcctClrgAmtInTransacCrcy,
  union_EKBE_EKBEH.bamng AS QuantityInBaseUnit,
  union_EKBE_EKBEH.arewb AS GRIRAcctClrgAmtInOrdTrnsacCrcy,
  union_EKBE_EKBEH.rewrb AS InvoiceAmtInPurOrdTransacCrcy,
  union_EKBE_EKBEH.wesbb AS VltdGdsRcptBlkdStkQtyInOrdUnit,
  union_EKBE_EKBEH.bpweb AS VltdGdsRcptBlkdQtyInOrdPrcUnit,
  union_EKBE_EKBEH.kudif AS ExchangeRateDifferenceAmount,
  _PurchasingDocHistCategory.tbtkz AS SubsequentDebitCreditIsAllowed,
  _PurchasingDocumentItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _PurchasingDocumentItem.DocumentCurrency AS PurOrdTransactionCurrency,
  _PurchasingDocumentItem.NetAmount AS PurchaseOrderAmountCoCodeCrcy,
  _PurchasingDocumentItem.OrderQuantity AS OrderQuantity,
  _PurchasingDocumentItem.ValueBasedCommitment AS ValueBasedCommitment,
  _PurchasingDocumentItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  _PurchasingDocumentItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  _PurchasingDocumentItem.NetPriceAmount AS NetPriceAmount,
  _PurchasingDocumentItem.NetPriceQuantity AS NetPriceQuantity,
  _PurchasingDocumentItem.InvoicePlanNumber AS InvoicePlanNumber
FROM Fclm_Mm_Pohist AS union_EKBE_EKBEH
INNER JOIN Fclm_Mm_Ekpo AS _PurchasingDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN t163b AS _PurchasingDocHistCategory ON /* join condition not captured in parsed metadata */
;

Learn More