I_FldLogsPurchasingDocItem

DDL: I_FLDLOGSPURCHASINGDOCITEM SQL: IFLPURDOC_ITM Type: view BASIC
14 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 14 fields with key fields PurchasingDocument, PurchasingDocumentItem.

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 (14)

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
AccountAssignmentCategory ekpo knttp AcctAssgnCat:CC
OrderQuantity ekpo menge WarrCountValue
OrderQuantityUnit ekpo meins Valuation Unit
IsToBeAcceptedAtOrigin ekpo weora Origin Accept.
PurchasingDocumentSubtype ekko bsakz Control
IsEndOfPurposeBlocked ekko iseopblocked Business Usage Comp.
FldLogsPurOrdItem

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.knttp AS AccountAssignmentCategory,
  _item.menge AS OrderQuantity,
  _item.meins AS OrderQuantityUnit,
  _item.weora AS IsToBeAcceptedAtOrigin,
  _header.bsakz AS PurchasingDocumentSubtype,
  _header.iseopblocked AS IsEndOfPurposeBlocked,
  concat(_item.ebeln, concat( '/',_item.ebelp ) ) AS FldLogsPurOrdItem
FROM ekpo AS _item
INNER JOIN ekko AS _header ON /* join condition not captured in parsed metadata */
;

Learn More