Fclm_Mmpd_Dcost

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_Mmpd_Dcost.
-- 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: VFCLMMMPDDCOST

CREATE VIEW Fclm_Mmpd_Dcost AS
SELECT
  poitem.PurchasingDocument AS PurchasingDocument,
  poitem.PurchasingDocumentItem AS PurchasingDocumentItem,
  cond.stunr AS ConditionStep,
  cond.zaehk AS ConditionCount,
  cond.kwert AS NetAmount,
  poitem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  poitem.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  poitem.Material AS Material,
  poitem.SupplierMaterialNumber AS SupplierMaterialNumber,
  poitem.ManufacturerMaterial AS ManufacturerMaterial,
  poitem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  poitem.Manufacturer AS Manufacturer,
  poitem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  poitem.CompanyCode AS CompanyCode,
  poitem.Plant AS Plant,
  poitem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  poitem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  poitem.StorageLocation AS StorageLocation,
  poitem.MaterialGroup AS MaterialGroup,
  poitem.OrderQuantityUnit AS OrderQuantityUnit,
  poitem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  poitem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  poitem.NetPriceQuantity AS NetPriceQuantity,
  poitem.IsCompletelyDelivered AS IsCompletelyDelivered,
  poitem.IsFinallyInvoiced AS IsFinallyInvoiced,
  poitem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  poitem.InvoiceIsExpected AS InvoiceIsExpected,
  poitem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  poitem.PurchaseRequisition AS PurchaseRequisition,
  poitem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  poitem.ServicePackage AS ServicePackage,
  poitem.PurchaseContractItem AS PurchaseContractItem,
  poitem.PurchaseContract AS PurchaseContract,
  poitem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  poitem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  poitem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  poitem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  poitem.RequisitionerName AS RequisitionerName,
  poitem.IncotermsClassification AS IncotermsClassification,
  poitem.IncotermsTransferLocation AS IncotermsTransferLocation,
  poitem.InternationalArticleNumber AS InternationalArticleNumber,
  poitem.ConfirmationControl AS ConfirmationControl,
  poitem.PriceIsToBePrinted AS PriceIsToBePrinted,
  poitem.BaseUnit AS BaseUnit,
  poitem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  poitem.ProfitCenter AS ProfitCenter,
  poitem.OrderPriceUnit AS OrderPriceUnit,
  poitem.VolumeUnit AS VolumeUnit,
  poitem.WeightUnit AS WeightUnit,
  poitem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  poitem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  poitem.PricingDateControl AS PricingDateControl,
  poitem.IsStatisticalItem AS IsStatisticalItem,
  poitem.IsReturnsItem AS IsReturnsItem,
  poitem.AccountAssignmentCategory AS AccountAssignmentCategory,
  poitem.PurchasingInfoRecord AS PurchasingInfoRecord,
  poitem.EffectiveAmount AS EffectiveAmount,
  poitem.NonDeductibleInputTax AS NonDeductibleInputTax,
  poitem.TargetQuantity AS TargetQuantity,
  poitem.OrderQuantity AS OrderQuantity,
  poitem.NetPriceAmount AS NetPriceAmount,
  poitem.TargetAmount AS TargetAmount,
  poitem.ItemVolume AS ItemVolume,
  poitem.ItemNetWeight AS ItemNetWeight,
  poitem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  poitem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  poitem.GoodsReceiptNonValuated AS GoodsReceiptNonValuated,
  poitem.PurchasingGroup AS PurchasingGroup,
  poitem.Supplier AS Supplier,
  poitem.PurchasingOrganization AS PurchasingOrganization,
  poitem.DocumentCurrency AS DocumentCurrency,
  poitem.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  poitem.PurchasingDocumentType AS PurchasingDocumentType,
  poitem.PaymentTerms AS PaymentTerms,
  poitem.CashDiscount1Days AS CashDiscount1Days,
  poitem.CashDiscount2Days AS CashDiscount2Days,
  poitem.NetPaymentDays AS NetPaymentDays,
  poitem.CashDiscount1Percent AS CashDiscount1Percent,
  poitem.CashDiscount2Percent AS CashDiscount2Percent,
  poitem.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  poitem.ValueBasedCommitment AS ValueBasedCommitment,
  poitem.InvoicePlanNumber AS InvoicePlanNumber,
  poitem.CompanyCodeCurrency AS CompanyCodeCurrency
FROM ekko AS podoc
INNER JOIN prcd_elements AS cond ON /* join condition not captured in parsed metadata */
INNER JOIN Fclm_Mm_Ekpo AS poitem ON /* join condition not captured in parsed metadata */
;