Fclm_Mm_Ekko

DDL: FCLM_MM_EKKO SQL: VFCLMMMEKKO Type: view
40 Fields 1 Data Sources

Purchasing Document

Fclm_Mm_Ekko is a CDS View that provides data about "Purchasing Document" in SAP S/4HANA. It reads from 1 data source (ekko) and exposes 40 fields.

Data Sources (1)

SourceAliasJoin Type
ekko ekko from

Annotations (7)

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

Fields (40)

KeyFieldSource TableSource FieldDescription
mandt ekko mandt Editing Client
PurchasingDocument ekko ebeln Source PurchDoc
PurchasingDocumentCategory ekko bstyp Source doc.cat.
PurchasingDocumentType ekko bsart Stnd purch.ord.
PurchasingDocumentSubtype ekko bsakz Control
CompanyCode ekko bukrs Value
PurchasingDocumentDeletionCode ekko loekz Status
PurchasingDocumentOrigin ekko statu Vehicle Status
ReleaseIsNotCompleted ekko frgrl Subj.to Release
ReleaseCode ekko frgke Release ind.
CreationDate ekko aedat Obsolete
CreatedByUser ekko ernam User Name
Supplier ekko lifnr Vendor no.
SupplierRespSalesPersonName ekko verkf Salesperson
SupplierPhoneNumber ekko telf1 Telephone no.
SupplierAddressID ekko adrnr Sold-To Address
ManualSupplierAddressID ekko adrnr Sold-To Address
PurchasingOrganization ekko ekorg Purchasing Org.
PurchasingGroup ekko ekgrp Sub. purchasing grp
DocumentCurrency ekko waers Transaction Currency
ExchangeRate ekko wkurs Exchange Rate
PurchasingDocumentOrderDate ekko bedat Start date
SupplyingSupplier ekko llief Goods Supplier
SupplyingPlant ekko reswk Supplying Plant
InvoicingParty ekko lifre Location Alias
PurchaseContract ekko konnr Agreement
PurchasingCompletenessStatus ekko memory Incomplete
IncotermsClassification ekko inco1 Incoterms
IncotermsTransferLocation ekko inco2 Incoterms 2
PaymentTerms ekko zterm Terms of Payment
CashDiscount1Days ekko zbd1t Payment in
CashDiscount2Days ekko zbd2t Payment in
NetPaymentDays ekko zbd3t Payment in
CashDiscount1Percent ekko zbd1p Max. Cash Dis. (%)
CashDiscount2Percent ekko zbd2p Nrm. Cash Dis. (%)
PricingProcedure ekko kalsm Search Proced.
TargetAmount ekko ktwrt Target Value
PurchasingDocumentCondition ekko knumv Doc. Condition
ValidityStartDate ekko kdatb Validity Start
ValidityEndDate ekko kdate Validity End

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_Ekko.
-- 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: VFCLMMMEKKO

CREATE VIEW Fclm_Mm_Ekko AS
SELECT
  ekko.mandt AS mandt,
  ekko.ebeln AS PurchasingDocument,
  ekko.bstyp AS PurchasingDocumentCategory,
  ekko.bsart AS PurchasingDocumentType,
  ekko.bsakz AS PurchasingDocumentSubtype,
  ekko.bukrs AS CompanyCode,
  ekko.loekz AS PurchasingDocumentDeletionCode,
  ekko.statu AS PurchasingDocumentOrigin,
  ekko.frgrl AS ReleaseIsNotCompleted,
  ekko.frgke AS ReleaseCode,
  ekko.aedat AS CreationDate,
  ekko.ernam AS CreatedByUser,
  ekko.lifnr AS Supplier,
  ekko.verkf AS SupplierRespSalesPersonName,
  ekko.telf1 AS SupplierPhoneNumber,
  ekko.adrnr AS SupplierAddressID,
  ekko.adrnr AS ManualSupplierAddressID,
  ekko.ekorg AS PurchasingOrganization,
  ekko.ekgrp AS PurchasingGroup,
  ekko.waers AS DocumentCurrency,
  ekko.wkurs AS ExchangeRate,
  ekko.bedat AS PurchasingDocumentOrderDate,
  ekko.llief AS SupplyingSupplier,
  ekko.reswk AS SupplyingPlant,
  ekko.lifre AS InvoicingParty,
  ekko.konnr AS PurchaseContract,
  ekko.memory AS PurchasingCompletenessStatus,
  ekko.inco1 AS IncotermsClassification,
  ekko.inco2 AS IncotermsTransferLocation,
  ekko.zterm AS PaymentTerms,
  ekko.zbd1t AS CashDiscount1Days,
  ekko.zbd2t AS CashDiscount2Days,
  ekko.zbd3t AS NetPaymentDays,
  ekko.zbd1p AS CashDiscount1Percent,
  ekko.zbd2p AS CashDiscount2Percent,
  ekko.kalsm AS PricingProcedure,
  ekko.ktwrt AS TargetAmount,
  ekko.knumv AS PurchasingDocumentCondition,
  ekko.kdatb AS ValidityStartDate,
  ekko.kdate AS ValidityEndDate
FROM ekko
;

Learn More