I_FldLogsPurchasingDocItem

DDL: I_FLDLOGSPURCHASINGDOCITEM SQL: IFLPURDOC_ITM Type: view BASIC Package: ODATA_FLOG_PROCESS_RECEIPTS
15 Fields 2 Data Sources

Field Logistics Purchase Orders

I_FldLogsPurchasingDocItem is a Basic CDS View that provides data about "Field Logistics Purchase Orders" in SAP S/4HANA. It reads from 2 data sources (ekko, ekpo) and exposes 15 fields with key fields PurchasingDocument, PurchasingDocumentItem. Part of development package ODATA_FLOG_PROCESS_RECEIPTS.

Data Sources (2)

SourceAliasJoin Type
ekko _header inner
ekpo _item from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLPURDOC_ITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Field Logistics Purchase Orders view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ekpo ebeln Source PurchDoc
KEY PurchasingDocumentItem ekpo ebelp Item pur. doc.
PurchaseRequisition ekpo banfn Requisition
PurchaseRequisitionItem ekpo bnfpo Requisn. item
Plant ekpo werks Receiving Plant
PurchasingDocumentCategory ekpo bstyp Source doc.cat.
PurchasingDocumentItemCategory ekpo pstyp Item Category
OrderQuantity ekpo menge WarrCountValue
OrderQuantityUnit ekpo meins Valuation Unit
IsToBeAcceptedAtOrigin ekpo weora Origin Accept.
IsEndOfPurposeBlocked ekko iseopblocked Business Usage Comp.
PurchasingDocumentDeletionCode ekpo loekz Status
PurchasingDocumentType ekko bsart Stnd purch.ord.
PurchasingDocumentSubtype ekko bsakz Control
PurchasingProcessingStatus ekko procstat Tour Status

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 I_FldLogsPurchasingDocItem.
-- 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: IFLPURDOC_ITM

CREATE VIEW I_FldLogsPurchasingDocItem AS
SELECT
  _item.ebeln AS PurchasingDocument,
  _item.ebelp AS PurchasingDocumentItem,
  _item.banfn AS PurchaseRequisition,
  _item.bnfpo AS PurchaseRequisitionItem,
  _item.werks AS Plant,
  _item.bstyp AS PurchasingDocumentCategory,
  _item.pstyp AS PurchasingDocumentItemCategory,
  _item.menge AS OrderQuantity,
  _item.meins AS OrderQuantityUnit,
  _item.weora AS IsToBeAcceptedAtOrigin,
  _header.iseopblocked AS IsEndOfPurposeBlocked,
  _item.loekz AS PurchasingDocumentDeletionCode,
  _header.bsart AS PurchasingDocumentType,
  _header.bsakz AS PurchasingDocumentSubtype,
  _header.procstat AS PurchasingProcessingStatus
FROM ekpo AS _item
INNER JOIN ekko AS _header ON /* join condition not captured in parsed metadata */
;

Learn More